Re: BUG #14897: Segfault on statitics SQL request

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

The result is identical to PostgreSQL 9.6 (
https://github.com/vlachenal/webservices-bench/blob/master/results.md).

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).
>
>
>