HS/SR Assert server crash

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: HS/SR Assert server crash
Date: 2010-05-13 22:01:09
Message-ID: 201005132201.o4DM19Q10877@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I was able to easily crash the standby server today just by starting it
and connecting to it via psql. The master was idle. The failure was:

LOG: streaming replication successfully connected to primary
TRAP: FailedAssertion("!(((xmax) >= ((TransactionId) 3)))", File: "procarray.c", Line: 1211)
LOG: server process (PID 12761) was terminated by signal 6: Abort trap
LOG: terminating any other active server processes

My master postgresql.conf was:

wal_level = hot_standby # minimal, archive, or hot_standby
archive_mode = on # allows archiving to be done
archive_command = 'cp -i %p /u/pg/archive/%f < /dev/null ' # command to use to archive a logfile segment
max_wal_senders = 1 # max number of walsender processes

My slave postgresql.conf was:

port = 5433 # (change requires restart)
wal_level = hot_standby # minimal, archive, or hot_standby
archive_mode = off # allows archiving to be done
archive_command = 'cp -i %p /u/pg/archive/%f < /dev/null ' # command to use to archive a logfile segment
hot_standby = on # allows queries during recovery
max_wal_senders = 1 # max number of walsender processes

and my slave recovery.conf was:

restore_command = 'cp /u/pg/archive/%f %p' # e.g. 'cp /mnt/server/archivedir/%f %p'
standby_mode = 'on'
primary_conninfo = 'host=localhost port=5432' # e.g. 'host=localhost port=5432'

Let me know what additional information I can supply.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2010-05-13 22:13:30 Re: List traffic
Previous Message Kevin Grittner 2010-05-13 21:51:02 Re: Row-level Locks & SERIALIZABLE transactions, postgres vs. Oracle