LargeObjectDrop and simple_heap_delete - Are these errors normal?

From: "tech techie" <techie(at)1stcounsel(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: LargeObjectDrop and simple_heap_delete - Are these errors normal?
Date: 2003-07-30 17:16:30
Message-ID: AA5C596DFFC0486489FBFCB706E1C6B2@techie.1stcounsel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Greetings!

I'm a dba new to postgresql and I wanted to
learn about these two error messages. I am
getting these errors quite often and I'm
wondering what it might be that is causing
them. Could it be bad indexes? ...I've opened
the database up in single user mode, and ran
a 'reindex database databasename'
successfully. Does anyoen have any hints or
suggestions for me to try?

I would not guess that these types of messages
are 'normal', but I have no clue how to get rid
of them.

THANKS so much for your time and help,

-techie(at)1stcounsel(dot)com

<Snippet from logfile - 6 minutes worth >
[root(at)adsdb root]# tail -f /var/log/clus.ads.log
2003-07-30 10:08:50 ERROR: LargeObjectDrop:
large object 4280306 not found
2003-07-30 10:08:58 LOG: recycled transaction
log file 000000050000005B
2003-07-30 10:09:24 ERROR: LargeObjectDrop:
large object 4280320 not found
2003-07-30 10:09:24 ERROR: LargeObjectDrop:
large object 4280320 not found
2003-07-30 10:09:48 ERROR: LargeObjectDrop:
large object 4280331 not found
2003-07-30 10:09:48 ERROR: LargeObjectDrop:
large object 4280331 not found
2003-07-30 10:09:51 ERROR: simple_heap_delete:
tuple concurrently updated
2003-07-30 10:09:57 ERROR: LargeObjectDrop:
large object 4280354 not found
2003-07-30 10:09:58 ERROR: LargeObjectDrop:
large object 4280365 not found
2003-07-30 10:09:58 ERROR: LargeObjectDrop:
large object 4280365 not found
2003-07-30 10:10:36 ERROR: simple_heap_delete:
tuple concurrently updated
2003-07-30 10:10:37 ERROR: LargeObjectDrop:
large object 4280373 not found
2003-07-30 10:10:37 ERROR: LargeObjectDrop:
large object 4280373 not found
2003-07-30 10:10:37 ERROR: LargeObjectDrop:
large object 4280373 not found
2003-07-30 10:10:38 ERROR: simple_heap_delete:
tuple concurrently updated
2003-07-30 10:10:38 ERROR: LargeObjectDrop:
large object 4280388 not found
2003-07-30 10:10:42 ERROR: LargeObjectDrop:
large object 4280393 not found
2003-07-30 10:10:42 ERROR: LargeObjectDrop:
large object 4280393 not found
2003-07-30 10:11:07 ERROR: LargeObjectDrop:
large object 4280397 not found
2003-07-30 10:11:22 ERROR: LargeObjectDrop:
large object 4280412 not found
2003-07-30 10:11:22 ERROR: LargeObjectDrop:
large object 4280412 not found
2003-07-30 10:12:04 ERROR: LargeObjectDrop:
large object 4280415 not found
2003-07-30 10:12:06 ERROR: LargeObjectDrop:
large object 4280440 not found
2003-07-30 10:12:06 ERROR: LargeObjectDrop:
large object 4280440 not found
2003-07-30 10:12:06 ERROR: LargeObjectDrop:
large object 4280442 not found
2003-07-30 10:12:06 ERROR: LargeObjectDrop:
large object 4280442 not found
2003-07-30 10:12:06 ERROR: LargeObjectDrop:
large object 4280442 not found
2003-07-30 10:12:52 ERROR: LargeObjectDrop:
large object 4280449 not found
2003-07-30 10:12:52 ERROR: LargeObjectDrop:
large object 4280449 not found
2003-07-30 10:12:55 ERROR: LargeObjectDrop:
large object 4280478 not found
2003-07-30 10:12:55 ERROR: LargeObjectDrop:
large object 4280478 not found
2003-07-30 10:12:55 ERROR: LargeObjectDrop:
large object 4280478 not found
2003-07-30 10:13:00 ERROR: LargeObjectDrop:
large object 4280482 not found
2003-07-30 10:13:06 ERROR: LargeObjectDrop:
large object 4280472 not found
2003-07-30 10:13:49 ERROR: LargeObjectDrop:
large object 4280525 not found
2003-07-30 10:13:49 ERROR: simple_heap_delete:
tuple concurrently updated
2003-07-30 10:13:49 ERROR: simple_heap_delete:
tuple concurrently updated
2003-07-30 10:13:57 ERROR: LargeObjectDrop:
large object 4280531 not found
2003-07-30 10:13:57 ERROR: LargeObjectDrop:
large object 4280531 not found
2003-07-30 10:13:57 ERROR: LargeObjectDrop:
large object 4280531 not found
2003-07-30 10:14:04 ERROR: LargeObjectDrop:
large object 4280521 not found
2003-07-30 10:14:05 LOG: recycled transaction
log file 000000050000005C
2003-07-30 10:14:05 LOG: recycled transaction
log file 000000050000005D
2003-07-30 10:14:36 ERROR: simple_heap_delete:
tuple concurrently updated
2003-07-30 10:14:36 ERROR: simple_heap_delete:
tuple concurrently updated
2003-07-30 10:14:38 ERROR: LargeObjectDrop:
large object 4280567 not found
2003-07-30 10:14:38 ERROR: LargeObjectDrop:
large object 4280567 not found
2003-07-30 10:14:38 ERROR: LargeObjectDrop:
large object 4280567 not found
2003-07-30 10:14:39 ERROR: simple_heap_delete:
tuple concurrently updated
2003-07-30 10:14:40 ERROR: simple_heap_delete:
tuple concurrently updated

Sent by 1stcounsel.com Mail
Premium Accounts for Legal Professionals
http://1stcounsel.com/

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2003-07-30 17:18:08 Re: recovery from a bad transaction log
Previous Message award 2003-07-30 17:02:29 Re: syslog enabled causes random hangs?