pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
NOTICE:  (transaction aborted): queries ignored until END
4+ messages / 4 participants
[nested] [flat]

* NOTICE:  (transaction aborted): queries ignored until END
@ 1999-12-18 23:58  Alex Guryanow <gav@nlr.ru>
  0 siblings, 2 replies; 4+ messages in thread

From: Alex Guryanow @ 1999-12-18 23:58 UTC (permalink / raw)
  To: pgsql-general@postgresql.org; pgsql-sql

Hi,

I'm use Postgres-6.5.1 on Linux. My database contains two tables and two
indices. I wrote simple program on C that
- begins transaction:  BEGIN WORK
- inserts many (10-500) rows in the first table
- commits the transaction: COMMIT
- begins transaction: BEGIN WORK
- inserts many (1-50) rows in the second table
- commits the transaction: COMMIT

During execution of this program I receive very often the following
message:

                NOTICE:  (transaction aborted): queries ignored until
END

that repeated many times.

What means this message? And why this happens?

Best regards,
Alex




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [GENERAL] NOTICE: (transaction aborted): queries ignored until END
@ 1999-12-19 01:58  Mike Mascari <mascarm@mascari.com>
  parent: Alex Guryanow <gav@nlr.ru>
  1 sibling, 1 reply; 4+ messages in thread

From: Mike Mascari @ 1999-12-19 01:58 UTC (permalink / raw)
  To: Alex Guryanow <gav@nlr.ru>; +Cc: pgsql-general@postgreSQL.org; pgsql-sql

Alex Guryanow wrote:
> 
> Hi,
> 
> I'm use Postgres-6.5.1 on Linux. My database contains two tables and two
> indices. I wrote simple program on C that
> - begins transaction:  BEGIN WORK
> - inserts many (10-500) rows in the first table
> - commits the transaction: COMMIT
> - begins transaction: BEGIN WORK
> - inserts many (1-50) rows in the second table
> - commits the transaction: COMMIT
> 
> During execution of this program I receive very often the following
> message:
> 
>                 NOTICE:  (transaction aborted): queries ignored until
> END
> 
> that repeated many times.
> 
> What means this message? And why this happens?
> 
> Best regards,
> Alex

That message appears when an error has occurred in a
transaction. It means that no other SQL statements will be
processed until the transaction has ended and a new one has
begun. For example:

CREATE TABLE example(key text);

=> begin;
BEGIN
=> insert into example values ('foo');
INSERT 181193 1
=> insert into example values ('bar', 20);
ERROR:  INSERT has more expressions than target columns
=> insert into example values ('bar');
NOTICE:  (transaction aborted): queries ignored until END
*ABORT STATE*
=> commit;
END
=> select * from example;
key
---
(0 rows)

It sounds as if some of your INSERT statements are not being
properly executed, often due to embedded single quotes in
text strings, lack of NULL values for missing datetime
values, or some other such syntax error. You should be able
to use PQresultStatus() and PQerrorMessage() to determine
precisely the error which is causing the transaction to
abort.

Hope that helps, 

Mike Mascari



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] NOTICE:  (transaction aborted): queries ignored until END
@ 1999-12-19 09:47  neko@kredit.sth.szif.hu
  parent: Alex Guryanow <gav@nlr.ru>
  1 sibling, 0 replies; 4+ messages in thread

From: neko@kredit.sth.szif.hu @ 1999-12-19 09:47 UTC (permalink / raw)
  To: Alex Guryanow <gav@nlr.ru>; +Cc: pgsql-general@postgreSQL.org; pgsql-sql

On Sun, 19 Dec 1999, Alex Guryanow wrote:
>                 NOTICE:  (transaction aborted): queries ignored until
> What means this message? And why this happens?
If an error occured inside a transaction, the whole transaction will be
droped. If the first query fails it is the simplest way to do nothing with
subsequent querys. (and the first action of course will be rollbacked)

If you want know what happend, you need look for the error message, before
the first "transaction aborted" notice.

--
 nek;(




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [GENERAL] NOTICE:  (transaction aborted): queries ignored until END
@ 1999-12-19 20:09  Timothy Laswell <tlaswell@erols.com>
  parent: Mike Mascari <mascarm@mascari.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Timothy Laswell @ 1999-12-19 20:09 UTC (permalink / raw)
  To: Mike Mascari <mascarm@mascari.com>; +Cc: Alex Guryanow <gav@nlr.ru>; pgsql-general@postgresql.org; pgsql-sql

Thanks Mike, I had the same problem and couldn't figure it out.  I forgot
that since the last time I ran this type of routine I had added some
quotes in.  I forgot to add the routines to handle the single quotes in
the new program.

Tim in Columbia MD

On Sat, 18 Dec 1999, Mike Mascari wrote:

> Alex Guryanow wrote:
> > 
> >                 NOTICE:  (transaction aborted): queries ignored until
> > 
> > What means this message? And why this happens?
> > 
> > Best regards,
> > Alex
> 
> That message appears when an error has occurred in a
> transaction. It means that no other SQL statements will be
> processed until the transaction has ended and a new one has
> begun. For example:
> 
> It sounds as if some of your INSERT statements are not being
> properly executed, often due to embedded single quotes in
> text strings, lack of NULL values for missing datetime
> values, or some other such syntax error. You should be able
> to use PQresultStatus() and PQerrorMessage() to determine
> precisely the error which is causing the transaction to
> abort.
> 
> Hope that helps, 
> 
> Mike Mascari
> 




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~1999-12-19 20:09 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-12-18 23:58 NOTICE:  (transaction aborted): queries ignored until END Alex Guryanow <gav@nlr.ru>
1999-12-19 01:58 ` Re: [GENERAL] NOTICE: (transaction aborted): queries ignored until END Mike Mascari <mascarm@mascari.com>
1999-12-19 20:09   ` Timothy Laswell <tlaswell@erols.com>
1999-12-19 09:47 ` neko@kredit.sth.szif.hu

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox