Re: pq_recvbuf: unexpected EOF

Running with ulimit ...

  echo "setting max user processes to unlimited..."
  ulimit -u unlimited
      echo -n "$PSQL_START"
      su -l postgres -s /bin/sh -c "$PGLIB/bin/pg_ctl -D $PGDATA -p
$PGLIB/bin/postmaster -o '-i' start > $PGDATA/log/syslog 2>&1" <
/dev/null

but still no core.  I can't product that bt.  Any suggestions?


--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> David Link <dvlink@yahoo.com> writes:
> > [4] LOG:  pq_recvbuf: unexpected EOF on client connection
> > [4] LOG:  server process (pid 28353) was terminated by signal 11
> > [5] LOG:  terminating any other active server processes
>
> That's not what I would call a "scaling issue" :-(
>
> Can you get us a stack backtrace from the crashed backend?  Since
> this is linux, you probably aren't getting core files (look for
> $PGDATA/base/nnnnnn/core) --- if not, restart the postmaster under
> "ulimit -c unlimited" (best to add that to its startup script).
> Once you have a core file, try
>
>     gdb /path/to/postgres-executable /path/to/core-file
>     gdb> bt
>     gdb> p debug_query_string
>     gdb> quit
>
> It would also be worthwhile to enable log_statement in
> postgresql.conf
> so that you can get more info on the command or series of commands
> that
> leads up to the crash.
>
> Also, if you compiled Postgres yourself, it would be worth the
> trouble
> to recompile with --enable-debug and --enable-cassert added to
> whatever
> configure parameters you used before.  I'm not sure what it takes to
> do
> the equivalent in an RPM-based installation.
>
>             regards, tom lane


__________________________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com