Error Canceling Statement Due To User Request
Contents |
Sign in Pricing Blog Support Search GitHub This repository Watch 294 Star 3,458 Fork 493 brettwooldridge/HikariCP Code Issues 21 Pull
Pgsql Canceling Statement Due To User Request
requests 2 Projects 0 Wiki Pulse Graphs New issue ERROR: canceling psql canceling statement due to user request statement due to user request #477 Closed Viniciusmsss opened this Issue Oct 29, 2015 · 9 comments canceling query due to user request Projects None yet Labels question Milestone No milestone Assignees No one assigned 3 participants Viniciusmsss commented Oct 29, 2015 Hello, We are using HikariCP in
Canceling Statement Due To Statement Timeout C#
our desktop software that uses Postgresql installed at the users machines (almost 6000). We've made our software to send us e-mails if exceptions occur. Every day we receive around 20 automatic e-mails from different users reporting the following exception: ERROR: canceling statement due to user request org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) <- org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) <- org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) <- org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304) <- com.zaxxer.hikari.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:44) <- m.c.b(Unknown
Canceling Statement Due To Statement Timeout Postgresql
Source) <- ... Searching in Google we've found the following site: http://postgresql.nabble.com/ERROR-canceling-query-due-to-user-request-td2077761.html We think that it probably has nothing to do with HikariCP, but we've decided to report you anyway. It might be useful to know this potential problem. Thank you! Owner brettwooldridge commented Oct 29, 2015 @Viniciusmsss Thank you for the interesting report. Because of a fairly amount of asynchronicity within HikariCP, there is always the possiblility that HikariCP is provoking this issue in the Postgresql backend. Have you done anything to narrow the issue down? It is always in the same piece of application code? Is it only PreparedStatement.executeQuery()? brettwooldridge added more-information-needed question labels Oct 29, 2015 Viniciusmsss commented Oct 29, 2015 It is difficult to narrow down because it never happened in our tests, but it happens daily in production, at the user's machines. Also, our code is extensive. We know that it comes from a lot of different pieces of the application code because we have the complete stack trace of the excepti
buildfarm-members pgsql-cluster-hackers pgsql-committers pgsql-hackers pgsql-rrreviewers pgsql-translators pgsql-www Regional lists Associations User canceling statement due to user request npgsql groups Project lists Inactive lists IRC Local User
Caused By: Org.postgresql.util.psqlexception: Error: Canceling Statement Due To User Request
Groups Featured Users International Sites Propaganda Resources Weekly News "cancelling statement due postgresql statement_timeout to user request error" occurs but the transaction has committed. From: Naoya Anzai
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations User groups Project lists Inactive lists IRC Local User Groups Featured Users International Sites Propaganda Resources Weekly News canceling https://www.postgresql.org/message-id/7E5D8C50942FE5459735F324EFAD8A140D5B533E@CORPEX00.comsysusi.com statement due to user request From: "Spangler, Todd"