BUG #8578: loading a 33G (compressed) pg_dump into a fresh host and db instance crashes a postgresql process

From: robert(at)urban4m(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8578: loading a 33G (compressed) pg_dump into a fresh host and db instance crashes a postgresql process
Date: 2013-11-06 01:07:11
Message-ID: E1VdraR-0003NM-KI@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8578
Logged by: Robert Nix
Email address: robert(at)urban4m(dot)com
PostgreSQL version: 9.3.1
Operating system: Linux Ubuntu 12.10
Description:

Below are the logs revealing the failure:

2013-11-05 17:04:21 EST LOG: server process (PID 5869) was terminated by
signal 9: Killed
2013-11-05 17:04:21 EST DETAIL: Failed process was running: autovacuum:
ANALYZE data_partitions.zone_municipality_demog_houston
2013-11-05 17:04:21 EST LOG: terminating any other active server processes
2013-11-05 17:04:21 EST WARNING: terminating connection because of crash of
another server process
2013-11-05 17:04:21 EST DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2013-11-05 17:04:21 EST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2013-11-05 17:04:21 EST WARNING: terminating connection because of crash of
another server process
2013-11-05 17:04:21 EST DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2013-11-05 17:04:21 EST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2013-11-05 17:04:21 EST WARNING: terminating connection because of crash of
another server process
2013-11-05 17:04:21 EST DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2013-11-05 17:04:21 EST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2013-11-05 17:04:21 EST WARNING: terminating connection because of crash of
another server process
2013-11-05 17:04:21 EST DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2013-11-05 17:04:21 EST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2013-11-05 17:04:21 EST CONTEXT: COPY zone_zipcode_demog_orlando, line
8986
2013-11-05 17:04:23 EST LOG: all server processes terminated;
reinitializing
2013-11-05 17:04:23 EST LOG: database system was interrupted; last known up
at 2013-11-05 17:01:22 EST
2013-11-05 17:04:23 EST LOG: database system was not properly shut down;
automatic recovery in progress
2013-11-05 17:04:23 EST LOG: redo starts at 57/643FA1F8
2013-11-05 17:04:47 EST LOG: unexpected pageaddr 56/E5784000 in log segment
00000001000000570000008F, offset 7880704
2013-11-05 17:04:47 EST LOG: redo done at 57/8F783B68
2013-11-05 17:04:47 EST LOG: last completed transaction was at log time
2013-11-05 17:01:52.611585-05
2013-11-05 17:04:53 EST LOG: database system is ready to accept
connections
2013-11-05 17:04:53 EST LOG: autovacuum launcher started

psql reports:

WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process
exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
CONTEXT: COPY zone_zipcode_demog_orlando, line 8986
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost

The command being issued is:

dropdb u; createdb u; cat u.sql.gz | gzip -d | psql u

u.sql.gz was created as:

pg_dump u | gzip >u.sql.gz

The database from which the dump was created is the same, 9.3.1, same
operating system, both Ubuntu 12.10. Db's have same extensions installed.
The source database shows no signs of issues.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-11-06 01:11:44 Re: BUG #8578: loading a 33G (compressed) pg_dump into a fresh host and db instance crashes a postgresql process
Previous Message Tom Lane 2013-11-05 23:24:33 Re: Bad pg_stats.correlation with repeated keys.