Re: Segmentation Fault PG 14

2022-11-08 Thread Willian Colognesi
d, so, if you need anything else that could help the analyses to find the bug feel free to let me know and I can grab the logs or whatever needed. Thanks y'all On Mon, Nov 7, 2022 at 8:05 PM Tom Lane wrote: > Willian Colognesi writes: > > There is no llvm installed on ubuntu ser

Re: Segmentation Fault PG 14

2022-11-08 Thread Willian Colognesi
, 2022 at 11:45 AM Willian Colognesi > wrote: > > root@ip-10-x-x-x:/home/ubuntu# pg_config --configure > > ... --with-extra-version= (Ubuntu 14.5-2.pgdg20.04+2)' ... > > ... '--with-llvm' 'LLVM_CONFIG=/usr/bin/llvm-config-10' ... > > > There

Re: Segmentation Fault PG 14

2022-11-07 Thread Willian Colognesi
ctor-strong -Wformat -Werror=format-security' 'LDFLAGS=-Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now' '--enable-tap-tests' '--with-icu' '--*with-llvm' 'LLVM_CONFIG=/usr/bin/llvm-config-10*' 'CLANG=/usr/bin/clang-10' &

Re: Segmentation Fault PG 14

2022-11-07 Thread Willian Colognesi
Klaver wrote: > On 11/7/22 12:15, Willian Colognesi wrote: > > All the extensions installed in this database are these: > > ``` > > List of installed extensions > > Name| Version | S

Re: Segmentation Fault PG 14

2022-11-07 Thread Willian Colognesi
Tom Lane wrote: > Willian Colognesi writes: > > `I take it things were okay with the version you used previously?` > > > Yes, it was working pretty well in another instance with pg version > > `12.4-1.pgdg18.04+1`, and we had to make a migration of one database that > >

Re: Segmentation Fault PG 14

2022-11-07 Thread Willian Colognesi
No, the origin where the database was was running ubuntu 18.04.5 x86_64 and the destination ubuntu 20.04.5 aarch64 On Mon, Nov 7, 2022 at 4:00 PM Adrian Klaver wrote: > On 11/7/22 10:57 AM, Willian Colognesi wrote: > > 1) What versions of pg_dump and pg_restore did you use? > >

Re: Segmentation Fault PG 14

2022-11-07 Thread Willian Colognesi
during the dump and restore. 4) Are the database clusters on the same machine? A: No, the origin and destination were different servers at the same VPC. On Mon, Nov 7, 2022 at 3:49 PM Adrian Klaver wrote: > On 11/7/22 10:36 AM, Willian Colognesi wrote: > > Hi Tom, > > > > `I tak

Re: Segmentation Fault PG 14

2022-11-07 Thread Willian Colognesi
Is there anything I could provide you to help the analysis ? On Mon, Nov 7, 2022 at 3:08 PM Tom Lane wrote: > Willian Colognesi writes: > > I started to use version `14.5-2.pgdg20.04+2` for a dedicated database > and > > I'm facing many segmentation faults during the day whe

Segmentation Fault PG 14

2022-11-07 Thread Willian Colognesi
Hello! I started to use version `14.5-2.pgdg20.04+2` for a dedicated database and I'm facing many segmentation faults during the day when the database has more heavy queries. The server log there are many of this: ``` 2022-11-07 17:23:19.423 UTC [728] LOG: background worker "parallel worker" (PI