a few days ago, I upgraded from PostgreSQL 7.2.1 to 7.4, following the instructions in the INSTALL file, including dump and restore. All this worked fine without any error (message).
Since then, I found lots of the following in the postmaster output:
2003-11-29 15:19:54 [1359] ERROR: large object 4838779 does not exist 2003-11-29 15:20:11 [1649] ERROR: large object 4838779 does not exist 2003-11-29 15:20:11 [1657] ERROR: large object 4838779 does not exist 2003-11-29 15:20:27 [1732] ERROR: large object 4838779 does not exist 2003-11-29 15:20:49 [1956] ERROR: large object 10204242 does not exist 2003-11-29 15:20:49 [1975] ERROR: large object 4838779 does not exist 2003-11-29 15:21:49 [2784] ERROR: large object 10204242 does not exist 2003-11-29 15:21:56 [3150] ERROR: large object 10204242 does not exist 2003-11-29 15:22:49 [4053] ERROR: large object 10204242 does not exist 2003-11-29 15:23:06 [4132] ERROR: large object 4838779 does not exist 2003-11-29 15:24:47 [5114] ERROR: large object 4838779 does not exist 2003-11-29 15:26:09 [6259] ERROR: large object 4838779 does not exist 2003-11-29 15:26:27 [6515] ERROR: large object 10204242 does not exist
I cannot find the source of those errors. It seems that everything is basically working, but there are always those errors about the two large objects. I'd like to find out what went wrong and how I can repair it. I couldn't find anything in the docs and the mailing lists.
To give more information about the messages, here are two more detailed outputs, one per id:
003-11-29 21:42:43 [2533] LOG: 00000: statement: BEGIN
LOCATION: pg_parse_query, postgres.c:464
2003-11-29 21:42:43 [2533] LOG: 00000: statement: select proname, oid from pg_proc where proname = 'lo_open'
or proname = 'lo_close' or proname = 'lo_creat' or proname = 'lo_unlink' or proname = 'lo_lseek'
or proname = 'lo_tell' or proname = 'loread' or proname = 'lowrite'
LOCATION: pg_parse_query, postgres.c:464
2003-11-29 21:42:43 [2533] ERROR: 42704: large object 10204242 does not exist
LOCATION: inv_open, inv_api.c:128
2003-11-29 21:42:43 [2533] LOG: 00000: statement: ROLLBACK
----------8<---------8<--------------
2003-11-29 21:43:48 [3047] LOG: 00000: statement: BEGIN
LOCATION: pg_parse_query, postgres.c:464
2003-11-29 21:43:48 [3047] LOG: 00000: statement: select proname, oid from pg_proc where proname = 'lo_open'
or proname = 'lo_close' or proname = 'lo_creat' or proname = 'lo_unlink' or proname = 'lo_lseek'
or proname = 'lo_tell' or proname = 'loread' or proname = 'lowrite'
LOCATION: pg_parse_query, postgres.c:464
2003-11-29 21:43:48 [3057] LOG: 00000: statement: set datestyle to 'ISO'; select version(), case when pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else get
databaseencoding() end;
LOCATION: pg_parse_query, postgres.c:464
2003-11-29 21:43:48 [3047] ERROR: 42704: large object 4838779 does not exist
LOCATION: inv_open, inv_api.c:128
2003-11-29 21:43:48 [3047] LOG: 00000: statement: ROLLBACK
The logged statements seems to suggest that there went something wrong with the template database creation or maybe the dump/restore. But as I wrote earlier: There was no visible error.
-dirk
--
D i r k F "o r s t e r l i n g
[EMAIL PROTECTED] http://[EMAIL PROTECTED]/
-------------
A child of five could understand this. Fetch me a child of five!---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
