Re: [GENERAL] Please help me debug regular segfaults on 8.3.10

2010-05-09 Thread pgsql
Tom Lane wrote: pgsql writes: Tom Lane wrote: Um, that's not too helpful, we want to see the string it's pointing at. Sorry about that. All statements are calling one of two pl/pgsql functions. While that information already helps me a lot, it'll take me a while to step through the code. T

Re: [GENERAL] Please help me debug regular segfaults on 8.3.10

2010-05-06 Thread Tom Lane
pgsql writes: > Tom Lane wrote: >> Um, that's not too helpful, we want to see the string it's pointing at. > Sorry about that. All statements are calling one of two pl/pgsql > functions. While that information already helps me a lot, it'll take me > a while to step through the code. Those funct

Re: [GENERAL] Please help me debug regular segfaults on 8.3.10

2010-05-05 Thread pgsql
Tom Lane wrote: pgsql writes: Tom Lane wrote: Looking at debug_query_string in the core dumps would at least show what SQL command is calling the function(s) --- and I wouldn't be surprised if there's exactly one function involved here. Content of debug_query_string: core.21207 $1 = 6310

Re: [GENERAL] Please help me debug regular segfaults on 8.3.10

2010-05-05 Thread Tom Lane
pgsql writes: > Tom Lane wrote: >> Looking at debug_query_string in the core dumps would >> at least show what SQL command is calling the function(s) --- and I >> wouldn't be surprised if there's exactly one function involved here. > Content of debug_query_string: > core.21207 > $1 = 63106368 U

Re: [GENERAL] Please help me debug regular segfaults on 8.3.10

2010-05-05 Thread pgsql
Tom Lane wrote: pgsql writes: Looking at debug_query_string in the core dumps would at least show what SQL command is calling the function(s) --- and I wouldn't be surprised if there's exactly one function involved here. Content of debug_query_string: core.21207 $1 = 63106368 core.20832 $1 =

Re: [GENERAL] Please help me debug regular segfaults on 8.3.10

2010-05-05 Thread pgsql
Alvaro Herrera wrote: pgsql wrote: Hi, one of our pgsql instances recently started to segfault multiple times a week. I tried a couple of things to pin it down to a certain query or job but failed to find any pattern. All I can offer is some notes and a set of similar looking back traces. Ple

Re: [GENERAL] Please help me debug regular segfaults on 8.3.10

2010-05-04 Thread Craig Ringer
On 5/05/2010 5:27 AM, Alvaro Herrera wrote: pgsql wrote: Hi, one of our pgsql instances recently started to segfault multiple times a week. I tried a couple of things to pin it down to a certain query or job but failed to find any pattern. All I can offer is some notes and a set of similar look

Re: [GENERAL] Please help me debug regular segfaults on 8.3.10

2010-05-04 Thread Tom Lane
pgsql writes: > one of our pgsql instances recently started to segfault multiple times a > week. I tried a couple of things to pin it down to a certain query > or job but failed to find any pattern. All I can offer is some notes > and a set of similar looking back traces. BTW, there is a post-8.3

Re: [GENERAL] Please help me debug regular segfaults on 8.3.10

2010-05-04 Thread Tom Lane
pgsql writes: > one of our pgsql instances recently started to segfault multiple times a > week. I tried a couple of things to pin it down to a certain query > or job but failed to find any pattern. All I can offer is some notes > and a set of similar looking back traces. All of those traces seem

Re: [GENERAL] Please help me debug regular segfaults on 8.3.10

2010-05-04 Thread Alvaro Herrera
pgsql wrote: > Hi, > > one of our pgsql instances recently started to segfault multiple times a > week. I tried a couple of things to pin it down to a certain query > or job but failed to find any pattern. All I can offer is some notes > and a set of similar looking back traces. Please install th