Обсуждение: Error on setAutoCommit with 9.4.1207
Hi,
after an upgrade to 9.4.1207 we get sometimes in this error:
java.util.NoSuchElementException
at java.util.ArrayDeque.removeFirst(ArrayDeque.java:280)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1841)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
at org.postgresql.jdbc.PgConnection.executeTransactionCommand(PgConnection.java:732)
at org.postgresql.jdbc.PgConnection.commit(PgConnection.java:745)
at org.postgresql.jdbc.PgConnection.setAutoCommit(PgConnection.java:715)
Could it be a 1207 regression ? on previuos version the error never occours
Enrico Olivelli
Software Development Manager @Diennea
Tel.: (+39) 0546 066100 - Int. 925
Viale G.Marconi 30/14 - 48018 Faenza (RA)
MagNews - E-mail Marketing Solutions
http://www.magnews.it
Diennea - Digital Marketing Solutions
http://www.diennea.com
Iscriviti alla nostra newsletter per rimanere aggiornato su digital ed email marketing! http://www.magnews.it/newsletter/
The information in this email is confidential and may be legally privileged. If you are not the intended recipient please notify the sender immediately and destroy this email. Any unauthorized, direct or indirect, disclosure, copying, storage, distribution or other use is strictly forbidden.
Can you provide a testcase? Vladimir
I'm sorry but I can't reproduce the problem with a testcase, the problem occurs sometimes, I can tell you that the problemin the stacktrace happened after taking the connection from a pool (Apache BasicDataSource), so no pending statementswould already been sent on the Connection Is there any condition the error can occour ? Where can I find useful info for you to debug ? -----Messaggio originale----- Da: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] Per conto di Vladimir Sitnikov Inviato: mercoledì 13 gennaio 2016 12:16 A: Enrico Olivelli - Diennea <enrico.olivelli@diennea.com> Cc: pgsql-jdbc@postgresql.org Oggetto: Re: [JDBC] Error on setAutoCommit with 9.4.1207 Can you provide a testcase? Vladimir -- Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-jdbc Iscriviti alla nostra newsletter per rimanere aggiornato su digital ed email marketing! http://www.magnews.it/newsletter/ The information in this email is confidential and may be legally privileged. If you are not the intended recipient pleasenotify the sender immediately and destroy this email. Any unauthorized, direct or indirect, disclosure, copying, storage,distribution or other use is strictly forbidden.
Can you add -Dloglevel=2 to make the driver print detailed trace? It would help. Vladimir
To which logger the info will be printed ? -----Messaggio originale----- Da: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] Per conto di Vladimir Sitnikov Inviato: mercoledì 13 gennaio 2016 12:34 A: Enrico Olivelli - Diennea <enrico.olivelli@diennea.com> Cc: pgsql-jdbc@postgresql.org Oggetto: Re: [JDBC] Error on setAutoCommit with 9.4.1207 Can you add -Dloglevel=2 to make the driver print detailed trace? It would help. Vladimir -- Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-jdbc Iscriviti alla nostra newsletter per rimanere aggiornato su digital ed email marketing! http://www.magnews.it/newsletter/ The information in this email is confidential and may be legally privileged. If you are not the intended recipient pleasenotify the sender immediately and destroy this email. Any unauthorized, direct or indirect, disclosure, copying, storage,distribution or other use is strictly forbidden.
To which logger the info will be printed ?
-----Messaggio originale-----
Da: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] Per conto di Vladimir Sitnikov
Inviato: mercoledì 13 gennaio 2016 12:34
A: Enrico Olivelli - Diennea <enrico.olivelli@diennea.com>
Cc: pgsql-jdbc@postgresql.org
Oggetto: Re: [JDBC] Error on setAutoCommit with 9.4.1207Iscriviti alla nostra newsletter per rimanere aggiornato su digital ed email marketing! http://www.magnews.it/newsletter/Can you add -Dloglevel=2 to make the driver print detailed trace?
It would help.
Vladimir
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
The information in this email is confidential and may be legally privileged. If you are not the intended recipient please notify the sender immediately and destroy this email. Any unauthorized, direct or indirect, disclosure, copying, storage, distribution or other use is strictly forbidden.--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
I’m sorry but I cannot modify the App with this kind of change.
I will continue to run 9.4.1207 on staging env in order to gather more logs from my app
I will let you known
thanks
Da: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] Per conto di Dave Cramer
Inviato: mercoledì 13 gennaio 2016 13:18
A: Enrico Olivelli - Diennea <enrico.olivelli@diennea.com>
Cc: Vladimir Sitnikov <sitnikov.vladimir@gmail.com>; pgsql-jdbc@postgresql.org
Oggetto: Re: [JDBC] Error on setAutoCommit with 9.4.1207
You have to call DriverManager.setLogWriter and it will be written to there
Dave Cramer
davec@postgresintl.com
On 13 January 2016 at 07:07, Enrico Olivelli - Diennea <enrico.olivelli@diennea.com> wrote:
To which logger the info will be printed ?
-----Messaggio originale-----
Da: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] Per conto di Vladimir Sitnikov
Inviato: mercoledì 13 gennaio 2016 12:34
A: Enrico Olivelli - Diennea <enrico.olivelli@diennea.com>
Cc: pgsql-jdbc@postgresql.org
Oggetto: Re: [JDBC] Error on setAutoCommit with 9.4.1207Can you add -Dloglevel=2 to make the driver print detailed trace?
It would help.
Vladimir
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbcIscriviti alla nostra newsletter per rimanere aggiornato su digital ed email marketing! http://www.magnews.it/newsletter/
The information in this email is confidential and may be legally privileged. If you are not the intended recipient please notify the sender immediately and destroy this email. Any unauthorized, direct or indirect, disclosure, copying, storage, distribution or other use is strictly forbidden.--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
Iscriviti alla nostra newsletter per rimanere aggiornato su digital ed email marketing! http://www.magnews.it/newsletter/
The information in this email is confidential and may be legally privileged. If you are not the intended recipient please notify the sender immediately and destroy this email. Any unauthorized, direct or indirect, disclosure, copying, storage, distribution or other use is strictly forbidden.