SIGSEGV taken on 8.1 during dump/reload - Mailing list pgsql-hackers

Hey all,

I was doing a test run of a live dump from 8.0.2 to 8.1.0, and 8.1.0 took a
segmentation violation 1 hour into the operation.  My plan is to re-do the
dump/restore, and if it fails again, to re-compile with debug and cassert, and
try to get a core.

The command line was (8.1.0 is on port 5433):

time pg_dumpall -c -v | psql -p 5433 -d template1

template1=# select version();                                                version
          
 
-------------------------------------------------------------------------------
--------------------------PostgreSQL 8.1.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2
(Mandrake Linux 10.0 3.3.2-6mdk)
(1 row)

Config is:

BINDIR = /usr/local/pgsql810/bin
DOCDIR = /usr/local/pgsql810/doc
INCLUDEDIR = /usr/local/pgsql810/include
PKGINCLUDEDIR = /usr/local/pgsql810/include
INCLUDEDIR-SERVER = /usr/local/pgsql810/include/server
LIBDIR = /usr/local/pgsql810/lib
PKGLIBDIR = /usr/local/pgsql810/lib
LOCALEDIR = 
MANDIR = /usr/local/pgsql810/man
SHAREDIR = /usr/local/pgsql810/share
SYSCONFDIR = /usr/local/pgsql810/etc
PGXS = /usr/local/pgsql810/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--enable-syslog' '--prefix=/usr/local/pgsql810'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE
CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-labels
-fno-strict-aliasing
CFLAGS_SL = -fpic
LDFLAGS = -Wl,-rpath,/usr/local/pgsql810/lib
LDFLAGS_SL = 
LIBS = -lpgport -lz -lreadline -lncurses -lcrypt -lresolv -lnsl -ldl -lm -lbsd 
VERSION = PostgreSQL 8.1.0

Log snippet as follows (serverlog is empty).  postgres810 is 8.1.0, postgres is
8.0.2.

Nov  6 16:02:09 thunder postgres810[5238]: [1-1] LOG:  autovacuum: processing
database "tassiv"
Nov  6 16:03:09 thunder postgres810[5306]: [1-1] LOG:  autovacuum: processing
database "bacula"
Nov  6 16:03:12 thunder postgres[1772]: [6-1] tassiv LOG:  duration: 1539387.072
ms  statement: COPY public.obs_v (x, y, imag, smag, sky, chi, sharp, iter, loc,
obs_id,
Nov  6 16:03:12 thunder postgres[1772]: [6-2]  file_id, use, solve, star_id,
mag) TO stdout;
Nov  6 16:04:09 thunder postgres810[5359]: [1-1] LOG:  autovacuum: processing
database "cpan"
Nov  6 16:05:09 thunder postgres[1772]: [7-1] tassiv LOG:  duration: 98330.722
ms  statement: COPY public.tycho2 (star_id, gsc, loc, bt, e_bt, vt, e_vt, prox)
TO stdout;
Nov  6 16:05:09 thunder postgres810[5418]: [1-1] LOG:  autovacuum: processing
database "dspam"
Nov  6 16:05:15 thunder postgres810[1773]: [20-1] tassivNOTICE:  ALTER TABLE /
ADD PRIMARY KEY will create implicit index "catalog_pkey" for table "catalog"
Nov  6 16:05:32 thunder postgres810[1773]: [21-1] tassivNOTICE:  ALTER TABLE /
ADD PRIMARY KEY will create implicit index "color_groups_pkey" for table
"color_groups"
Nov  6 16:05:32 thunder postgres810[1773]: [22-1] tassivNOTICE:  ALTER TABLE /
ADD UNIQUE will create implicit index "files_name_key" for table "files"
Nov  6 16:05:32 thunder postgres810[1773]: [23-1] tassivNOTICE:  ALTER TABLE /
ADD PRIMARY KEY will create implicit index "files_pkey" for table "files"
Nov  6 16:05:32 thunder postgres810[1773]: [24-1] tassivNOTICE:  ALTER TABLE /
ADD PRIMARY KEY will create implicit index "groups_pkey" for table "groups"
Nov  6 16:05:32 thunder postgres810[1773]: [25-1] tassivNOTICE:  ALTER TABLE /
ADD PRIMARY KEY will create implicit index "new_reference_loc_pkey" for table
"new_reference_loc"
Nov  6 16:05:32 thunder postgres810[1773]: [26-1] tassivNOTICE:  ALTER TABLE /
ADD UNIQUE will create implicit index "nights_night_key" for table "nights"
Nov  6 16:05:32 thunder postgres810[1773]: [27-1] tassivNOTICE:  ALTER TABLE /
ADD PRIMARY KEY will create implicit index "nights_pkey" for table "nights"
Nov  6 16:05:32 thunder postgres810[1773]: [28-1] tassivNOTICE:  ALTER TABLE /
ADD UNIQUE will create implicit index "obs_root_obs_id_key" for table "obs_root"
Nov  6 16:05:32 thunder postgres810[1773]: [29-1] tassivNOTICE:  ALTER TABLE /
ADD PRIMARY KEY will create implicit index "pairs_pkey" for table "pairs"
Nov  6 16:05:32 thunder postgres810[1773]: [30-1] tassivNOTICE:  ALTER TABLE /
ADD PRIMARY KEY will create implicit index "reference_ubvri_pkey" for table
"reference_ubvri"
Nov  6 16:05:34 thunder postgres810[1773]: [31-1] tassivNOTICE:  ALTER TABLE /
ADD PRIMARY KEY will create implicit index "sites_pkey" for table "sites"
Nov  6 16:05:34 thunder postgres810[1773]: [32-1] tassivNOTICE:  ALTER TABLE /
ADD PRIMARY KEY will create implicit index "tycho2_pkey" for table "tycho2"
Nov  6 16:05:55 thunder postgres810[1773]: [33-1] tassivNOTICE:  ALTER TABLE /
ADD PRIMARY KEY will create implicit index "zero_pair_pkey" for table
"zero_pair"
Nov  6 16:06:10 thunder postgres810[5489]: [1-1] LOG:  autovacuum: processing
database "template1"
Nov  6 16:06:27 thunder postgres810[32258]: [1-1] LOG:  server process (PID
1773) was terminated by signal 11
Nov  6 16:06:27 thunder postgres810[32258]: [2-1] LOG:  terminating any other
active server processes
Nov  6 16:06:27 thunder postgres810[32258]: [3-1] LOG:  all server processes
terminated; reinitializing
Nov  6 16:06:27 thunder postgres[1772]: [8-1] tassiv LOG:  unexpected EOF on
client connection
Nov  6 16:06:28 thunder postgres810[5508]: [4-1] LOG:  database system was
interrupted at 2005-11-06 16:05:15 MST
Nov  6 16:06:28 thunder postgres810[5508]: [5-1] LOG:  checkpoint record is at
1/BA12B8B4
Nov  6 16:06:28 thunder postgres810[5508]: [6-1] LOG:  redo record is at
1/BA020058; undo record is at 0/0; shutdown FALSE
Nov  6 16:06:28 thunder postgres810[5508]: [7-1] LOG:  next transaction ID:
625556; next OID: 33061
Nov  6 16:06:28 thunder postgres810[5508]: [8-1] LOG:  next MultiXactId: 1153;
next MultiXactOffset: 11782
Nov  6 16:06:28 thunder postgres810[5508]: [9-1] LOG:  database system was not
properly shut down; automatic recovery in progress
Nov  6 16:06:28 thunder postgres810[5508]: [10-1] LOG:  redo starts at
1/BA020058
Nov  6 16:06:28 thunder postgres[1373]: [4-1] template1 LOG:  unexpected EOF on
client connection
Nov  6 16:06:42 thunder postgres810[5508]: [11-1] LOG:  record with zero length
at 1/BF1DFB44
Nov  6 16:06:42 thunder postgres810[5508]: [12-1] LOG:  redo done at 1/BF1DFB1C
Nov  6 16:06:44 thunder postgres810[5508]: [13-1] LOG:  database system is ready
Nov  6 16:06:44 thunder postgres810[5508]: [14-1] LOG:  transaction ID wrap
limit is 2147484146, limited by database "template1"


-- 16:09:17 up 35 days,  8:43,  8 users,  load average: 4.56, 5.83, 6.47
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004