Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_migrator segfault - Mailing list pgsql-general

From hernan gonzalez
Subject Re: pg_migrator segfault
Date
Msg-id AANLkTinRWmFrd6UKwequbrEUbK0QNz6xiWTpMMfutPG2@mail.gmail.com
Whole thread Raw
In response to Re: pg_migrator segfault  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: pg_migrator segfault  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
2010/11/2 Grzegorz Jaśkiewicz <gryzman@gmail.com>
try gdb --args ./pg_upgrade -d /var/pgsql-8_4_3/data/ -D
/var/pgsql-9_0_1/data/ -b /var/pgsql-8_4_3/bin/ -B
/var/pgsql-9_0_1/bin/ --check -P 5433 -v -g -G debug
and when it fails, type in 'bt' and paste it here please.

--
GJ

Well, this is strange. I run the same command line with gbd, it does not throw the segfault.
The first time it gave me some error, but with sensible info:

===============
Starting program: /var/pgsql-9_0_1/bin/pg_upgrade -d /var/pgsql-8_4_3/data/ -D /var/pgsql-9_0_1/data/ -b /var/pgsql-8_4_3/bin/ -B /var/pgsql-9_0_1/bin/ --check -P 5433 -v -g -G debug
[Thread debugging using libthread_db enabled]
Running in verbose mode
Running in debug mode
Detaching after fork from child process 30334.
Detaching after fork from child process 30335.
PerForming Consistency Checks on Old Live Server
------------------------------------------------
Checking old data directory (/var/pgsql-8_4_3/data)         ok
Checking old bin directory (/var/pgsql-8_4_3/bin)           ok
Checking new data directory (/var/pgsql-9_0_1/data)         ok
Checking new bin directory (/var/pgsql-9_0_1/bin)           ok
Detaching after fork from child process 30336.
Detaching after fork from child process 30337.
Checking for reg* system oid user data types                ok
Checking for /contrib/isn with bigint-passing mismatch      ok
Checking for large objects                                  ok
"/var/pgsql-9_0_1/bin/pg_ctl" -l "/dev/null" -D "/var/pgsql-9_0_1/data" -o "-p 5433 -c autovacuum=off -c autovacuum_freeze_max_age=2000000000" start >> "/dev/null" 2>&1
Detaching after fork from child process 30362.
Trying to start new server                                  .................ok

 Unable to start new postmaster with the command: "/var/pgsql-9_0_1/bin/pg_ctl" -l "/dev/null" -D "/var/pgsql-9_0_1/data" -o "-p 5433 -c autovacuum=off -c autovacuum_freeze_max_age=2000000000" start >> "/dev/null" 2>&1
Perhaps pg_hba.conf was not set to "trust".
Program exited with code 01.
Missing separate debuginfos, use: debuginfo-install glibc-2.11.1-4.i686
========================================================

I found (by calling pg_ctl manually and redirecting the log somewhere) that there was a postmaster.opts not writable by postgres. 
I fixed that, run again, and all seemed well, but...

===============================================================
Reading symbols from /var/pgsql-9_0_1/bin/pg_upgrade...(no debugging symbols found)...done.
(gdb) run
Starting program: /var/pgsql-9_0_1/bin/pg_upgrade -d /var/pgsql-8_4_3/data/ -D /var/pgsql-9_0_1/data/ -b /var/pgsql-8_4_3/bin/ -B /var/pgsql-9_0_1/bin/ --check -P 5433 -v -g -G debug
[Thread debugging using libthread_db enabled]
Running in verbose mode
Running in debug mode
Detaching after fork from child process 30680.
Detaching after fork from child process 30681.
PerForming Consistency Checks on Old Live Server
------------------------------------------------
Checking old data directory (/var/pgsql-8_4_3/data)         ok
Checking old bin directory (/var/pgsql-8_4_3/bin)           ok
Checking new data directory (/var/pgsql-9_0_1/data)         ok
Checking new bin directory (/var/pgsql-9_0_1/bin)           ok
Detaching after fork from child process 30682.
Detaching after fork from child process 30683.
Checking for reg* system oid user data types                ok
Checking for /contrib/isn with bigint-passing mismatch      ok
Checking for large objects                                  ok
"/var/pgsql-9_0_1/bin/pg_ctl" -l "/dev/null" -D "/var/pgsql-9_0_1/data" -o "-p 5433 -c autovacuum=off -c autovacuum_freeze_max_age=2000000000" start >> "/dev/null" 2>&1
Detaching after fork from child process 30708.
Checking for presence of required libraries                 ok

*Clusters are compatible*
"/var/pgsql-9_0_1/bin/pg_ctl" -l "/dev/null" -D "/var/pgsql-9_0_1/data"  stop >> "/dev/null" 2>&1
Detaching after fork from child process 30724.

Program exited normally.
Missing separate debuginfos, use: debuginfo-install glibc-2.11.1-4.i686
==================================================

But when I run the pg_upgrade outside gbd, again the segfault:

===================

./pg_upgrade -d /var/pgsql-8_4_3/data/ -D /var/pgsql-9_0_1/data/ -b /var/pgsql-8_4_3/bin/ -B /var/pgsql-9_0_1/bin/ --check -P 5433 -v -g -G debug
Running in verbose mode
Running in debug mode
PerForming Consistency Checks on Old Live Server
------------------------------------------------
Checking old data directory (/var/pgsql-8_4_3/data)         ok
Checking old bin directory (/var/pgsql-8_4_3/bin)           ok
Checking new data directory (/var/pgsql-9_0_1/data)         ok
Checking new bin directory (/var/pgsql-9_0_1/bin)           ok
Segmentation fault

==============================================

WTF?

Hernán J. González

pgsql-general by date:

Previous
From: zhong ming wu
Date:
Subject: Re: Is this a known feature of 8.1 SSL connection?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Feature request for this mail list