simple_heap_delete LargeObjectDrop ERROR messages

Поиск
Список
Период
Сортировка
От tech techie
Тема simple_heap_delete LargeObjectDrop ERROR messages
Дата
Msg-id 421B660900A66B549A52916657D9D711@techie.1stcounsel.com
обсуждение исходный текст
Список pgsql-admin
Greetings!

I'm a new (very new) postgresql dba, and I was
wondering if the following error messages
are 'Normal' in your environments.

I've already gone into single user mode and
issued 'reindex database dbname', yet these
messages still persist.

Thanks in advance for any help or tips you have
to offer!

techie@1stcounsel.com

============
begin log file snippet
*** only 4 minutes worth of log file entries
============


[pgsql@adsdb ads]$ tail -
50 /var/log/clus.ads.log
2003-07-28 12:53:52 ERROR:  simple_heap_delete:
tuple concurrently updated
2003-07-28 12:53:52 ERROR:  simple_heap_delete:
tuple concurrently updated
2003-07-28 12:53:52 ERROR:  LargeObjectDrop:
large object 4177478 not found
2003-07-28 12:53:52 ERROR:  LargeObjectDrop:
large object 4177478 not found
2003-07-28 12:53:52 ERROR:  LargeObjectDrop:
large object 4177478 not found
2003-07-28 12:53:53 ERROR:  LargeObjectDrop:
large object 4177493 not found
2003-07-28 12:53:53 ERROR:  LargeObjectDrop:
large object 4177493 not found
2003-07-28 12:53:56 ERROR:  LargeObjectDrop:
large object 4177498 not found
2003-07-28 12:54:09 ERROR:  LargeObjectDrop:
large object 4177504 not found
2003-07-28 12:54:16 ERROR:  simple_heap_delete:
tuple concurrently updated
2003-07-28 12:54:16 ERROR:  LargeObjectDrop:
large object 4177520 not found
2003-07-28 12:54:16 ERROR:  LargeObjectDrop:
large object 4177520 not found
2003-07-28 12:54:16 ERROR:  LargeObjectDrop:
large object 4177520 not found
2003-07-28 12:54:22 ERROR:  simple_heap_delete:
tuple concurrently updated
2003-07-28 12:54:22 ERROR:  simple_heap_delete:
tuple concurrently updated
2003-07-28 12:54:23 ERROR:  simple_heap_delete:
tuple concurrently updated
2003-07-28 12:54:24 LOG:  recycled transaction
log file 0000000400000035
2003-07-28 12:54:46 ERROR:  LargeObjectDrop:
large object 4177544 not found
2003-07-28 12:54:53 ERROR:  simple_heap_delete:
tuple concurrently updated
2003-07-28 12:54:54 ERROR:  simple_heap_delete:
tuple concurrently updated
2003-07-28 12:55:06 ERROR:  LargeObjectDrop:
large object 4177602 not found
2003-07-28 12:55:17 ERROR:  LargeObjectDrop:
large object 4177614 not found
2003-07-28 12:55:27 ERROR:  LargeObjectDrop:
large object 4177612 not found
2003-07-28 12:55:29 ERROR:  LargeObjectDrop:
large object 4177619 not found
2003-07-28 12:55:31 ERROR:  LargeObjectDrop:
large object 4177637 not found
2003-07-28 12:55:44 ERROR:  Cannot insert a
duplicate key into unique index
phpads_cache_pkey
2003-07-28 12:55:53 ERROR:  LargeObjectDrop:
large object 4177663 not found
2003-07-28 12:55:54 ERROR:  LargeObjectDrop:
large object 4177667 not found
2003-07-28 12:55:59 ERROR:  simple_heap_delete:
tuple concurrently updated
2003-07-28 12:56:04 ERROR:  LargeObjectDrop:
large object 4177680 not found
2003-07-28 12:56:06 ERROR:  LargeObjectDrop:
large object 4177682 not found
2003-07-28 12:56:07 ERROR:  LargeObjectDrop:
large object 4177685 not found
2003-07-28 12:56:07 ERROR:  LargeObjectDrop:
large object 4177685 not found
2003-07-28 12:56:07 ERROR:  LargeObjectDrop:
large object 4177687 not found
2003-07-28 12:56:07 ERROR:  LargeObjectDrop:
large object 4177690 not found
2003-07-28 12:56:10 ERROR:  LargeObjectDrop:
large object 4177692 not found
2003-07-28 12:56:10 ERROR:  LargeObjectDrop:
large object 4177692 not found
2003-07-28 12:56:15 ERROR:  simple_heap_delete:
tuple concurrently updated
2003-07-28 12:56:24 ERROR:  LargeObjectDrop:
large object 4177703 not found
2003-07-28 12:56:40 ERROR:  simple_heap_delete:
tuple concurrently updated
2003-07-28 12:56:56 ERROR:  LargeObjectDrop:
large object 4177724 not found
2003-07-28 12:57:04 ERROR:  LargeObjectDrop:
large object 4177743 not found
2003-07-28 12:57:09 ERROR:  LargeObjectDrop:
large object 4177752 not found
2003-07-28 12:57:12 ERROR:  LargeObjectDrop:
large object 4177761 not found
2003-07-28 12:57:15 ERROR:  Cannot insert a
duplicate key into unique index
phpads_cache_pkey
2003-07-28 12:57:18 ERROR:  LargeObjectDrop:
large object 4177779 not found
2003-07-28 12:57:35 ERROR:  LargeObjectDrop:
large object 4177792 not found
2003-07-28 12:57:44 ERROR:  LargeObjectDrop:
large object 4177796 not found
2003-07-28 12:57:51 ERROR:  LargeObjectDrop:
large object 4177813 not found
2003-07-28 12:57:52 ERROR:  LargeObjectDrop:
large object 4177818 not found



Sent by 1stcounsel Mail

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

Предыдущее
От: "Marvin"
Дата:
Сообщение: Re: Starting PostgreSQL server as root
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: [PERFORM] Rebuild indexes