| From: | Daniel Kalchev <daniel(at)digsys(dot)bg> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | maxint reached? |
| Date: | 2002-04-02 20:25:15 |
| Message-ID: | 200204022025.g32KPFu12434@dcave.digsys.bg |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Has anyone seen this:
ERROR: dtoi4: integer out of range
on 7.1.3
What worries me, is that at startup time, the log shows:
DEBUG: database system was shut down at 2002-04-02 23:16:52 EEST
DEBUG: CheckPoint record at (82, 1928435208)
DEBUG: Redo record at (82, 1928435208); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 517528628; NextOid: 2148849196
DEBUG: database system is in production state
Note the NextOid, while i /usr/include/machine/limits.h defines INT_MAX as
2147483647. Are oid really singed ints?
Daniel
PS: This database indeed has an increasing oid counter in that range. Grep
from the log shows
DEBUG: NextTransactionId: 386003914; NextOid: 1551075952
DEBUG: NextTransactionId: 397667914; NextOid: 1643984428
DEBUG: NextTransactionId: 444453748; NextOid: 1864857132
DEBUG: NextTransactionId: 450233305; NextOid: 1888540204
DEBUG: NextTransactionId: 454987662; NextOid: 1917687340
DEBUG: NextTransactionId: 501775621; NextOid: 2078209580
DEBUG: NextTransactionId: 517524499; NextOid: 2148849196
DEBUG: NextTransactionId: 517528628; NextOid: 2148849196
this is from one month ago.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-04-02 20:34:12 | Re: |
| Previous Message | Bruce Momjian | 2002-04-02 19:59:44 | Re: status of IPv6 Support for INET/CIDR types |