SIGSEGV taken on 8.1 during dump/reload

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