From: | Vincent Lachenal <vincent(dot)lachenal(at)gmail(dot)com> |
---|---|
To: | Dmitry Dolgov <9erthalion6(at)gmail(dot)com> |
Cc: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #14897: Segfault on statitics SQL request |
Date: | 2017-11-11 12:39:00 |
Message-ID: | CAA2tJ7oojHHSO3EsYHgvTcjPVDsnEypjn743-xXQJ7V-hSGmWQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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(at)gmail(dot)com> a
écrit :
> > On 11 November 2017 at 09:39, Michael Paquier <michael(dot)paquier(at)gmail(dot)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).
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2017-11-11 15:53:58 | Re: Help me plz |
Previous Message | Marko Tiikkaja | 2017-11-11 12:05:33 | Re: BUG #14870: wrong query results when using WITH with UPDATE |