[HACKERS] VACUUM causes violent postmaster death

2000-11-03 Thread Dan Moschuk
Server process (pid 13361) exited with status 26 at Fri Nov 3 17:49:44 2000 Terminating any active server processes... NOTICE: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have

Re: [HACKERS] VACUUM causes violent postmaster death

2000-11-03 Thread Alfred Perlstein
* Dan Moschuk [EMAIL PROTECTED] [001103 14:55] wrote: Server process (pid 13361) exited with status 26 at Fri Nov 3 17:49:44 2000 Terminating any active server processes... NOTICE: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died

Re: [HACKERS] VACUUM causes violent postmaster death

2000-11-03 Thread Tom Lane
Dan Moschuk [EMAIL PROTECTED] writes: Server process (pid 13361) exited with status 26 at Fri Nov 3 17:49:44 2000 What's signal 26 on your system? (Look in /usr/include/signal.h or /usr/include/signum.h or /usr/include/sys/signal.h) regards, tom lane

Re: [HACKERS] VACUUM causes violent postmaster death

2000-11-03 Thread Dan Moschuk
| Server process (pid 13361) exited with status 26 at Fri Nov 3 17:49:44 2000 | | What's signal 26 on your system? (Look in /usr/include/signal.h or | /usr/include/signum.h or /usr/include/sys/signal.h) dan@spirit:/home/dan grep 26 /usr/include/sys/signal.h #define SIGVTALRM 26

Re: [HACKERS] VACUUM causes violent postmaster death

2000-11-03 Thread Dan Moschuk
| This happens fairly regularly. I assume exit code 26 is used to dictate | that a specific error has occured. | | The database is a decent size (~3M records) with about 4 indexes. | | What version of postgresql? Tom Lane recently fixed some severe problems | with vacuum and heavily used

Re: [HACKERS] VACUUM causes violent postmaster death

2000-11-03 Thread Alfred Perlstein
* Dan Moschuk [EMAIL PROTECTED] [001103 15:32] wrote: | This happens fairly regularly. I assume exit code 26 is used to dictate | that a specific error has occured. | | The database is a decent size (~3M records) with about 4 indexes. | | What version of postgresql? Tom Lane

Re: [HACKERS] VACUUM causes violent postmaster death

2000-11-03 Thread Tom Lane
Dan Moschuk [EMAIL PROTECTED] writes: | Server process (pid 13361) exited with status 26 at Fri Nov 3 17:49:44 2000 | | What's signal 26 on your system? #define SIGVTALRM 26 /* virtual time alarm */ Well, that sure shouldn't be happening. You aren't perhaps running it under a