ERROR: infinite recursion in proc_exit
От | Kristofer Munn |
---|---|
Тема | ERROR: infinite recursion in proc_exit |
Дата | |
Msg-id | Pine.LNX.4.04.9911042227470.7118-100000@dec.munn.com обсуждение исходный текст |
Ответы |
Re: [HACKERS] ERROR: infinite recursion in proc_exit
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | pgsql-hackers |
Hi all! On a number of occasions over the past couple of weeks I have encountered the following error during my nightly vacuum process. It repeats infinitely until outside intervention. It seems to identify the fact that it is stuck in an infinite recursion but unable to deal with it. The relevant portion of the log is at the end of the message. Any hints/suggestions are welcome. Also, after exiting from the infinite loop I have the following errors appearing during vacuum and vacuum analyze: NOTICE: CreatePortal: portal <vacuum> already exists NOTICE: Index pg_attribute_attrelid_index: NUMBER OF INDEX' TUPLES (1203) IS NOT THE SAME AS HEAP' (1193) NOTICE: Index pg_attribute_relid_attnum_index: NUMBER OF INDEX' TUPLES (1203) IS NOT THE SAME AS HEAP' (1193) NOTICE: Index pg_attribute_relid_attnam_index: NUMBER OF INDEX' TUPLES (1203) IS NOT THE SAME AS HEAP' (1193) ERROR: cannot find attribute 1 of relation pg_temp.13894.119 Any suggestions on cleaning this up is appreciated... - Kristofer Nov 4 03:37:00 mymailman logger: DEBUG: --Relation tblvalue-- Nov 4 03:37:04 mymailman logger: DEBUG: Pages 945: Changed 83, Reapped 5, Empty 0, New 0; Tup 128483: Vac 13, Keep/VTL0/0, Crash 0, UnUsed 0, MinLen 53, MaxLen 85; Re-using: Free/Avail. Space 876/876; EndEmpty/Avail. Pages 0/5. Elapsed0/0 sec. Nov 4 03:37:08 mymailman logger: DEBUG: Index tblvalue_idx2: Pages 432; Tuples 128483: Deleted 13. Elapsed 0/0 sec. Nov 4 03:37:10 mymailman logger: DEBUG: Index tblvalue_oid: Pages 289; Tuples 128483: Deleted 13. Elapsed 0/1 sec. Nov 4 03:37:20 mymailman logger: ERROR: cannot find attribute 1 of relation pg_temp.13894.119 Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: FATAL 1: Socket command type Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: ERROR: unknown frontend message was received Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: NOTICE: AbortTransaction and not in in-progress state Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_recvbuf: recv() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: FATAL 1: Socket command type ? unknown Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: ERROR: unknown frontend message was received Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: NOTICE: AbortTransaction and not in in-progress state Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_recvbuf: recv() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: FATAL 1: Socket command type ? unknown Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: ERROR: unknown frontend message was received Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: NOTICE: AbortTransaction and not in in-progress state Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_recvbuf: recv() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: FATAL 1: Socket command type ? unknown Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: ERROR: unknown frontend message was received Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: NOTICE: AbortTransaction and not in in-progress state Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_recvbuf: recv() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: FATAL 1: Socket command type ? unknown Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: ERROR: unknown frontend message was received Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: NOTICE: AbortTransaction and not in in-progress state Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_recvbuf: recv() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: ERROR: infinite recursion in proc_exit Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: NOTICE: AbortTransaction and not in in-progress state Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_recvbuf: recv() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: ERROR: infinite recursion in proc_exit Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: NOTICE: AbortTransaction and not in in-progress state Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_recvbuf: recv() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: ERROR: infinite recursion in proc_exit Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: NOTICE: AbortTransaction and not in in-progress state Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_flush: send() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: pq_recvbuf: recv() failed: Bad file descriptor Nov 4 03:37:20 mymailman logger: ERROR: infinite recursion in proc_exit - K Kristofer Munn * KMI * 973-509-9414 * AIM KrMunn * ICQ 352499 * www.munn.com
В списке pgsql-hackers по дате отправления:
Предыдущее
От: Lamar OwenДата:
Сообщение: Re: [HACKERS] PostgreSQL 6.5.3 built, but not released ...