Details of Segmentation Fault

[Steve Horn]

I am trying to get the details of a segmentation fault that I'm
encountering when running a function from the pgRouting library. The log
in /var/log/postgresql doesn't give me a lot of detail:

2012-09-09 21:03:36 EDT LOG: server process (PID 20008) was terminated by
signal 11: Segmentation fault
2012-09-09 21:03:36 EDT LOG: terminating any other active server processes
2012-09-09 21:03:36 EDT WARNING: terminating connection because of crash
of another server process
2012-09-09 21:03:36 EDT DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2012-09-09 21:03:36 EDT HINT: In a moment you should be able to reconnect
to the database and repeat your command.

... etc.

Is there any other place to check that would give me a better idea of what
happened?

Thanks!

[Tom Lane]

Post by Steve Horn
I am trying to get the details of a segmentation fault that I'm
encountering when running a function from the pgRouting library. The log

No, it wouldn't. You should try to get a stack trace. See
https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend

regards, tom lane

[Kevin Grittner]

Post by Steve Horn
I am trying to get the details of a segmentation fault that I'm
encountering when running a function from the pgRouting library.
2012-09-09 21:03:36 EDT LOG: server process (PID 20008) was
terminated by signal 11: Segmentation fault
2012-09-09 21:03:36 EDT LOG: terminating any other active server
processes
2012-09-09 21:03:36 EDT WARNING: terminating connection because of
crash of another server process
2012-09-09 21:03:36 EDT DETAIL: The postmaster has commanded this
server process to roll back the current transaction and exit,
because another server process exited abnormally and possibly
corrupted shared memory.
2012-09-09 21:03:36 EDT HINT: In a moment you should be able to
reconnect to the database and repeat your command.
... etc.
Is there any other place to check that would give me a better idea
of what happened?

You could try to get a stack trace:

http://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend

Note that people can be more helpful if you include more information,
like your OS and the version of PostgreSQL.

-Kevin

[Steve Horn]

Ubuntu 12.02, PostgreSQL 9.1

Thanks!

Post by Kevin Grittner

Post by Steve Horn
I am trying to get the details of a segmentation fault that I'm
encountering when running a function from the pgRouting library.
2012-09-09 21:03:36 EDT LOG: server process (PID 20008) was
terminated by signal 11: Segmentation fault
2012-09-09 21:03:36 EDT LOG: terminating any other active server
processes
2012-09-09 21:03:36 EDT WARNING: terminating connection because of
crash of another server process
2012-09-09 21:03:36 EDT DETAIL: The postmaster has commanded this
server process to roll back the current transaction and exit,
because another server process exited abnormally and possibly
corrupted shared memory.
2012-09-09 21:03:36 EDT HINT: In a moment you should be able to
reconnect to the database and repeat your command.
... etc.
Is there any other place to check that would give me a better idea
of what happened?

http://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
Note that people can be more helpful if you include more information,
like your OS and the version of PostgreSQL.
-Kevin