BUG #5718: Cannot start postgres (FATAL: invalid cache id: 19)

From: "Aleksandr Dushein" <adushein(at)rutube(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5718: Cannot start postgres (FATAL: invalid cache id: 19)
Date: 2010-10-20 09:44:09
Message-ID: 201010200944.o9K9i981095017@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5718
Logged by: Aleksandr Dushein
Email address: adushein(at)rutube(dot)ru
PostgreSQL version: 9.0.1
Operating system: FreeBSD 8.1-RELEASE #0: Mon Jul 19 02:36:49 UTC 2010
root(at)mason(dot)cse(dot)buffalo(dot)edu:/usr/obj/usr/src/sys/GENERIC amd64
Description: Cannot start postgres (FATAL: invalid cache id: 19)
Details:

Hello. I was upgraded my database from 8.4.4 то 9.0.1 one week ago by
pg_dump/pg_restore. Yesterday database stop responding with message ERROR:
database is not accepting commands to avoid wraparound data loss
I trying to restart in single mode and fail with the same error.

%postgres --single -D /data/pgdata -d 5
DEBUG: TZ "Africa/Algiers" scores 0: at 1263427200 2010-01-14 01:00:00 std
versus 2010-01-14 03:00:00 std
...skipped...
DEBUG: TZ "UCT" scores 0: at 1263427200 2010-01-14 00:00:00 std versus
2010-01-14 03:00:00 std
DEBUG: TZ "UTC" scores 0: at 1263427200 2010-01-14 00:00:00 std versus
2010-01-14 03:00:00 std
DEBUG: TZ "Universal" scores 0: at 1263427200 2010-01-14 00:00:00 std
versus 2010-01-14 03:00:00 std
DEBUG: TZ "W-SU" gets max score 5200
DEBUG: TZ "Zulu" scores 0: at 1263427200 2010-01-14 00:00:00 std versus
2010-01-14 03:00:00 std
DEBUG: Reject TZ "Mideast/Riyadh87": uses leap seconds
DEBUG: Reject TZ "Mideast/Riyadh88": uses leap seconds
DEBUG: Reject TZ "Mideast/Riyadh89": uses leap seconds
DEBUG: TZ "posixrules" scores 0: at 1263427200 2010-01-13 19:00:00 std
versus 2010-01-14 03:00:00 std
DEBUG: invoking IpcMemoryCreate(size=1103020032)
DEBUG: removing file "pg_notify/0000"
DEBUG: InitPostgres
DEBUG: my backend id is 1
LOG: database system was shut down at 2010-10-19 11:25:38 MSD
DEBUG: checkpoint record is at 433/C474D3C8
DEBUG: redo record is at 433/C474D3C8; shutdown TRUE
DEBUG: next transaction ID: 0/2146484301; next OID: 106178
DEBUG: next MultiXactId: 1; next MultiXactOffset: 0
DEBUG: oldest unfrozen transaction ID: 654, in database 16385
DEBUG: transaction ID wrap limit is 2147484301, limited by database with
OID 16385
FATAL: invalid cache id: 19
DEBUG: shmem_exit(1): 8 callbacks to make
DEBUG: proc_exit(1): 3 callbacks to make
DEBUG: exit(1)
DEBUG: shmem_exit(-1): 0 callbacks to make
DEBUG: proc_exit(-1): 0 callbacks to make

---------config (only uncommented lines)-------------
%cat /data/pgdata/postgresql.conf | grep -v '^[ ]*#' | grep -v '^$'
listen_addresses='*'
max_connections = 100 # (change requires restart)
shared_buffers = 1024MB # min 128kB
temp_buffers = 256MB
work_mem = 128MB
maintenance_work_mem = 512MB
fsync = off
wal_buffers = 512kB
log_destination = 'syslog'
silent_mode = on
update_process_title = off
datestyle = 'iso, mdy'
lc_messages = 'C' # locale for system error message
lc_monetary = 'en_US.UTF-8' # locale for monetary
formatting
lc_numeric = 'en_US.UTF-8' # locale for number
formatting
lc_time = 'en_US.UTF-8' # locale for time
formatting
default_text_search_config = 'pg_catalog.english'

---------sysctl (only uncommented lines)-------------
analyzer-db-1# cat /etc/sysctl.conf | grep -v '^[ ]*#' | grep -v '^$'
kern.ipc.shmall=1048576
kern.ipc.shmmax=4294967296
kern.ipc.semmap=256
kern.ipc.shm_use_phys=1
kern.ipc.somaxconn=4096
kern.ipc.maxsockbuf=16777216
kern.maxfiles=65536
net.inet.tcp.blackhole=0
net.inet.udp.blackhole=0
net.inet.tcp.delayed_ack=0
net.inet.tcp.sendspace=32768
net.inet.tcp.recvspace=32768
net.local.stream.recvspace=65535
net.local.stream.sendspace=65535
net.inet.tcp.keepidle=300000
net.inet.tcp.keepintvl=30000
net.inet.tcp.msl=10000
kern.ipc.nmbclusters=65536

analyzer-db-1# cat /boot/loader.conf
kern.ipc.semmni=256
kern.ipc.semmns=512
kern.ipc.semmnu=256

---------disk utilization -------------

analyzer-db-1# df -h
Filesystem Size Used Avail Capacity Mounted on
/dev/mfid0s1a 989M 268M 642M 29% /
devfs 1.0K 1.0K 0B 100% /dev
/dev/mfid0s1d 1.9G 14K 1.8G 0% /tmp
/dev/mfid0s1f 8.7G 1.2G 6.8G 15% /usr
/dev/mfid0s1e 15G 101M 14G 1% /var
/dev/mfid0s2d 483G 54G 391G 12% /data
/dev/mfid1s1d 541G 228G 269G 46% /data2
/dev/mfid2s1d 1.1T 639G 356G 64% /data3
10.1.13.31:/vol/vol5 1.0T 721G 303G 70% /data/backup
analyzer-db-1# du -sch /data*/pgdata/
54G /data/pgdata/
201G /data2/pgdata/
523G /data3/pgdata/
778G total

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2010-10-20 13:48:47 Re: BUG #5708: configuration php.ini
Previous Message Andrew Tipton 2010-10-19 22:43:53 Re: BUG #5716: Regression joining tables in UPDATE with composite types