[GENERAL] PGError: server closed the connection unexpectedly

2006-01-08 Thread Dave Steinberg
Hello list, I've been working a bit today to resolve the error I'm seeing mentioned in the title, and I was hoping you might have some insight. I've managed to semi-reliably reproduce this based on two different tasks: - a pg_dumpall from my backup server will throw this, but not always on

Re: [GENERAL] PGError: server closed the connection unexpectedly

2006-01-07 Thread Doug McNaught
Dave Steinberg <[EMAIL PROTECTED]> writes: >> You're not using the same PG connection from two different threads, or >> fork()ing and trying to use the same connection in the parent and the >> child, or anything like that? > > Aha! In the ruby code, I am forking! I'll make the child reconnect >

Re: [GENERAL] PGError: server closed the connection unexpectedly

2006-01-07 Thread Dave Steinberg
You're not using the same PG connection from two different threads, or fork()ing and trying to use the same connection in the parent and the child, or anything like that? Aha! In the ruby code, I am forking! I'll make the child reconnect and see if that helps (I am almost sure this will fix i

Re: [GENERAL] PGError: server closed the connection unexpectedly

2006-01-07 Thread Doug McNaught
Dave Steinberg <[EMAIL PROTECTED]> writes: >>>My biggest problem is the lack of any real error message on the server. >>>I don't see anything wrong in the system logs, and there's no core >>> file in the /var/postgresql directory. >> Are you sure core files are enabled; i.e. the server is runn

Re: [GENERAL] PGError: server closed the connection unexpectedly

2006-01-07 Thread Dave Steinberg
My biggest problem is the lack of any real error message on the server. I don't see anything wrong in the system logs, and there's no core file in the /var/postgresql directory. Are you sure core files are enabled; i.e. the server is running with 'ulimit -c unlimited' ? Yes: $ whoami _po

Re: [GENERAL] PGError: server closed the connection unexpectedly

2006-01-07 Thread Doug McNaught
Dave Steinberg <[EMAIL PROTECTED]> writes: > My biggest problem is the lack of any real error message on the server. > I don't see anything wrong in the system logs, and there's no core > file in the /var/postgresql directory. Are you sure core files are enabled; i.e. the server is running w

[GENERAL] PGError: server closed the connection unexpectedly

2006-01-07 Thread Dave Steinberg
Hello list, I've been working a bit today to resolve the error I'm seeing mentioned in the title, and I was hoping you might have some insight. I've managed to semi-reliably reproduce this based on two different tasks: - a pg_dumpall from my backup server will throw this, but not always on the