2010/11/2 Grzegorz JaÅkiewiczÂ<gryzman@xxxxxxxxx>
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/ -Band when it fails, type in 'bt' and paste it here please.
/var/pgsql-9_0_1/bin/ --check -P 5433 -v -g -G debug
--
GJ
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
HernÃn J. GonzÃlez
