dbTalk Databases Forums  

Re: [BUGS] BUG #1917: autovaccuum crashes

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss Re: [BUGS] BUG #1917: autovaccuum crashes in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Alvaro Herrera
 
Posts: n/a

Default Re: [BUGS] BUG #1917: autovaccuum crashes - 09-28-2005 , 08:58 AM






On Wed, Sep 28, 2005 at 04:21:16AM +0100, Theo Schlossnagle wrote:

Quote:
Doing large data loads via the COPY command into a set of schema-identical
tables table1, table2, table3 all of which inherrit table. (simulating
Oracle's partitioning). Periodically, we get:


LOG: autovacuum process (PID 9685) was terminated by signal 11
LOG: terminating any other active server processes
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2005-09-27 09:12:49 PDT

The process doesn't seem to dump core.
Please run "ulimit -c unlimited" and restart the postmaster, to try to
get a core dump. (It should be in the data/ directory, not in the
data/base/<oid>/ directory as it used to be in previous versions.)

If it doesn't work, please provide more details on your schema. I'm
going to try to reproduce your problem here.

--
Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC
Tulio: oh, para qué servirá este boton, Juan Carlos?
Policarpo: No, aléjense, no toquen la consola!
Juan Carlos: Lo apretaré una y otra vez.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


Reply With Quote
  #2  
Old   
Alvaro Herrera
 
Posts: n/a

Default Re: [BUGS] BUG #1917: autovaccuum crashes - 09-28-2005 , 09:06 AM






I wrote

Quote:
On Wed, Sep 28, 2005 at 04:21:16AM +0100, Theo Schlossnagle wrote:

Doing large data loads via the COPY command into a set of schema-identical
tables table1, table2, table3 all of which inherrit table. (simulating
Oracle's partitioning). Periodically, we get:


LOG: autovacuum process (PID 9685) was terminated by signal 11
LOG: terminating any other active server processes
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2005-09-27 09:12:49 PDT

The process doesn't seem to dump core.

Please run "ulimit -c unlimited" and restart the postmaster, to try to
get a core dump. (It should be in the data/ directory, not in the
data/base/<oid>/ directory as it used to be in previous versions.)

If it doesn't work, please provide more details on your schema. I'm
going to try to reproduce your problem here.
I tried and failed. Please post more details, and the exact version you
are using (for example the date you pulled the CVS or nightly snapshot,
or specify if this is a released beta.) A sample schema may be useful
too, though I don't see a problem with inheritance by itself.

--
Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34
Si no sabes adonde vas, es muy probable que acabes en otra parte.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.