473,224 Members | 1,957 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 software developers and data experts.

After upgrade 7.2.1 to 7.4 "ERROR: large object ... does not exist"

Hi all,

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
r@zorbla.de http://r@zorbla.de/
-------------
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

Nov 12 '05 #1
0 2570

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Marc | last post by:
Hello, I have a page where i can upload binary file (using the HTML input type=file approach). This works fine for relatively small files (<6MB)) but when files get bigger (13MB) there is a...
4
by: John Phelan | last post by:
I have created a front-end application and back-end database. I have code that automatically links the front-end application to the back-end database for whenever I provide a patch or upgrade....
4
by: John Phelan | last post by:
Continue to get error message. Here is an update of my problem and everything that I have done to correct it. I have created a front-end application and back-end database. I have code that...
3
by: mrwoopey | last post by:
Hi, I am using the example "Authenticate against the Active Directory by Using Forms Authentication and Visual Basic .NET": http://support.microsoft.com/default.aspx?scid=KB;EN-US;326340 ...
1
by: gerr | last post by:
Visual studio 2003 "HTTP/1.1 500 Internal Server Error" when trying to create a new Asp.net site with Visual Studio 2003 on localServer XP Pro/IIS 5.1. Everything worked fine prior to installing...
1
by: Dave | last post by:
I am getting te following error in a ASP.Net app that is running on Win XP Pro (SP2): Server cannot access application directory 'C:\Documents and Settings\dave\My Documents\My Visual Studio...
7
by: John | last post by:
Hi Everyone, I'm having this extremely annoying problem with Internet Explorer 6, giving me an error message saying "unknown runtime error" whenever I try to alter the contents of a <divelement...
1
by: =?ISO-8859-1?Q?Lasse_V=E5gs=E6ther_Karlsen?= | last post by:
I get the above error in some of the ASP.NET web applications on a server, and I need some help figuring out how to deal with it. This is a rather long post, and I hope I have enough details that...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.