Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14897: Segfault on statitics SQL request - Mailing list pgsql-bugs

From Vincent Lachenal
Subject Re: [BUGS] BUG #14897: Segfault on statitics SQL request
Date
Msg-id CAA2tJ7oojHHSO3EsYHgvTcjPVDsnEypjn743-xXQJ7V-hSGmWQ@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14897: Segfault on statitics SQL request  (Dmitry Dolgov <9erthalion6@gmail.com>)
List pgsql-bugs
Tree view
I retried database migration using another ... and the bug does not happen anymore.
The first time I use "Manual dump and reload" migration method from Archlinux wiki (https://wiki.archlinux.org/index.php/PostgreSQL#Upgrading_PostgreSQL):
# systemctl stop postgresql.service
# mv /var/lib/postgres/data /var/lib/postgres/olddata
# mkdir /var/lib/postgres/data
# chown postgres:postgres /var/lib/postgres/data
[postgres]$ initdb --locale $LANG -E UTF8 -D '/var/lib/postgres/data'
# /opt/pgsql-9.6/bin/pg_ctl -D /var/lib/postgres/olddata/ start
# /opt/pgsql-9.6/bin/pg_dumpall >> old_backup.sql
# /opt/pgsql-9.6/bin/pg_ctl -D /var/lib/postgres/olddata/ stop
# systemctl start postgresql.service
# psql -f old_backup.sql postgres
The second time I use the other way:
# systemctl stop postgresql.service
# mv /var/lib/postgres/data /var/lib/postgres/olddata
# mkdir /var/lib/postgres/data
# chown postgres:postgres /var/lib/postgres/data
[postgres]$ initdb --locale $LANG -E UTF8 -D '/var/lib/postgres/data'
[postgres]$ cd /tmp
[postgres]$ pg_upgrade -b /opt/pgsql-9.6/bin -B /usr/bin -d /var/lib/postgres/olddata -D /var/lib/postgres/data

I have kept the migration data (both of them). So I will compile PostgreSQL with debugging symbol to have a workable stacktrace.

Regards.

Vincent


Le sam. 11 nov. 2017 à 11:34, Dmitry Dolgov <9erthalion6@gmail.com> a écrit :
> On 11 November 2017 at 09:39, Michael Paquier <michael.paquier@gmail.com> wrote:
>
> My laptop uses Arch, and I can see the crash easily when compiling
> with gcc 7.2 which is the one bundled in the core package set

Yes, I forgot to mention, that I also used quite recent version of gcc (GCC) 8.0.0 20170805 (experimental).


pgsql-bugs by date:

Previous
From: Marko Tiikkaja
Date:
Subject: Re: [BUGS] BUG #14870: wrong query results when using WITH with UPDATE
Next
From: "David G. Johnston"
Date:
Subject: Re: [BUGS] Help me plz