LargeObjectDrop and simple_heap_delete - Are these errors normal?

Поиск
Список
Период
Сортировка
От tech techie
Тема LargeObjectDrop and simple_heap_delete - Are these errors normal?
Дата
Msg-id AA5C596DFFC0486489FBFCB706E1C6B2@techie.1stcounsel.com
обсуждение исходный текст
Список 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@1stcounsel.com


<Snippet from logfile  - 6 minutes worth >
[root@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/

В списке pgsql-admin по дате отправления:

Предыдущее
От: award@dominionsciences.com
Дата:
Сообщение: Re: syslog enabled causes random hangs?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: syslog enabled causes random hangs?