ERROR: infinite recursion in proc_exit - Mailing list 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