Hi:

After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we
are having intermitent issues with certain online PHP transactions,
returning this error:

"Warning: pg_exec() query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block"

Half the times we run the query we get the error, the other half it works.

Any ideas? Thanks.



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

On Tue, Oct 05, 2004 at 07:54:23AM +0200, ruben wrote:
[color=blue]
> After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we
> are having intermitent issues with certain online PHP transactions,
> returning this error:
>
> "Warning: pg_exec() query failed: ERROR: current transaction is aborted,
> commands ignored until end of transaction block"[/color]

Some previous query in this transaction has failed. Are there other
error messages before this one? What queries preceded the one that
gives this error?
[color=blue]
> Half the times we run the query we get the error, the other half it works.[/color]

By "half" do you mean exactly 50% of the time, or are you approximating?
Can you identify anything common to the successful transactions that's
different from the failed transactions?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Hi Michael:

Michael Fuhr wrote:
[color=blue][color=green]
>>After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we
>>are having intermitent issues with certain online PHP transactions,
>>returning this error:
>>
>>"Warning: pg_exec() query failed: ERROR: current transaction is aborted,
>>commands ignored until end of transaction block"[/color]
>
>
> Some previous query in this transaction has failed. Are there other
> error messages before this one? What queries preceded the one that
> gives this error?[/color]

Yes, there is some incompatibility between 7.4.2 and 7.4.5 with INT type
comparisons, not allowing (7.4.5) something like "WHERE int_field = ''",
so the same transaction failed before the error reported with this one:

Warning: pg_exec() query failed: ERROR: invalid input syntax for integer: ""
[color=blue][color=green]
>>Half the times we run the query we get the error, the other half it works.[/color]
>
> By "half" do you mean exactly 50% of the time, or are you approximating?
> Can you identify anything common to the successful transactions that's
> different from the failed transactions?[/color]

I was approximating. The transaction is exactly the same, I just click
on "UPDATE" button on the web browser and sometimes it worked and
sometimes not.

Thanks a lot.
Ruben.



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly