Re: - Mailing list pgsql-bugs

From Igor Shevchenko
Subject Re:
Date
Msg-id 200310152249.01652.igor@carcass.ath.cx
Whole thread Raw
In response to Re:  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re:
List pgsql-bugs
On Tuesday 14 October 2003 20:50, you wrote:
> Igor Shevchenko <igor@carcass.ath.cx> writes:
> > The problem is repeatable when I run my program, especially if the
> > postgresql server and the sserv are on the same server, and the debugging
> > is off. Please let me know if you need more details, I'll try to narrow
> > the conditions to make a simple reproductible sequence of commands.
>
> I think we're going to need a test case to make any progress on this
> one.

Here's a test case.

1. in t2.cc, replace table name "a" in "select * from a" with any other table
which has lots of data. In my setup, the table 'a' is :

            Table "public.a"
 Column |       Type        | Modifiers
--------+-------------------+-----------
 txt    | character varying |

It has ~50k of rows with the same value 'hello'.

2. compile t2.cc
3. run "while true; do echo "notify new_event" | psql; done" in one shell
4. run t2 in another shell

The t2's backend fails before the query is finished and the following is
printed in the postgresql's log:

WARNING:  CommitTransaction and not in in-progress state
TRAP: FailedAssertion("!(TopTransactionContext != ((void *)0))", File: "xact.
c", Line: 660)
LOG:  server process (PID 10622) was terminated by signal 6
LOG:  terminating any other active server processes

>
>             regards, tom lane

--
Best regards,
Igor Shevchenko

pgsql-bugs by date:

Previous
From: "Nayib Kiuhan"
Date:
Subject: Re: timestamp bug 7.4beta3
Next
From: "Nayib Kiuhan"
Date:
Subject: Re: timestamp bug 7.4beta3