oids rollover?

From: Daniel Kalchev <daniel(at)digsys(dot)bg>
To: pgsql-hackers(at)postgresql(dot)org
Subject: oids rollover?
Date: 2002-06-24 20:47:10
Message-ID: 200206242047.g5OKlAu13306@dcave.digsys.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

o
I have a problem with an 7.1.3 database that has probably overflowed
the oid counter. The startup halts with these messages

DEBUG: database system was interrupted at 2002-06-24 21:19:43 EEST
DEBUG: CheckPoint record at (156, 1692817164)
DEBUG: Redo record at (156, 1692775580); Undo record at (0, 0);
Shutdown FALSE
DEBUG: NextTransactionId: 859255800; NextOid: 7098
FATAL 2: Invalid NextTransactionId/NextOid
postmaster: Startup proc 4752 exited with status 512 - abort

Can something be sone to recover the database?

Regards,
Daniel

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message J. R. Nield 2002-06-24 20:49:42 Re: Index Scans become Seq Scans after VACUUM ANALYSE
Previous Message Tom Lane 2002-06-24 20:43:31 Re: SQL99, CREATE CAST, and initdb