You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Andrey Mashenkov (Jira)" <ji...@apache.org> on 2023/04/27 10:13:00 UTC
[jira] [Updated] (IGNITE-19272) Uninformative jdbc exception. The cause is not logged on the server side.
[ https://issues.apache.org/jira/browse/IGNITE-19272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrey Mashenkov updated IGNITE-19272:
--------------------------------------
Description:
Steps to reproduce.
{code:java}
try (Statement stmt = conn.createStatement()) {
stmt.executeUpdate("CREATE TABLE timetest(id INT PRIMARY KEY,"
+ "ts TIMESTAMP, ts_tz TIMESTAMP WITH LOCAL TIME ZONE)");
stmt.executeUpdate("INSERT INTO timetest VALUES "
+ "(3, '2011-01-01 01:01:01', TIMESTAMP WITH LOCAL TIME ZONE '2011-01-01 01:01:01')"); // <- ok
stmt.executeUpdate("INSERT INTO timetest VALUES "
+ "(1, '2011-01-01 01:01:01', '2011-01-01 01:01:01')"); // <- failed
}
{code}
failed with no reason why:
{noformat}
java.sql.SQLException: Exception while executing query [query=INSERT INTO timetest VALUES (3, '2011-01-01 01:01:01', '2011-01-01 01:01:01')]. Error message:IGN-CMN-65535 TraceId:ba72bbc8-a0e3-414b-a520-6eed739b3f45 Remote query execution
at org.apache.ignite.internal.jdbc.proto.IgniteQueryErrorCode.createJdbcSqlException(IgniteQueryErrorCode.java:57)
at org.apache.ignite.internal.jdbc.JdbcStatement.execute0(JdbcStatement.java:148)
at org.apache.ignite.internal.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:177)
{noformat}
Also, there is no stacktrace
was:
{code:java}
try (Statement stmt = conn.createStatement()) {
stmt.executeUpdate("CREATE TABLE timetest(id INT PRIMARY KEY,"
+ "ts TIMESTAMP, ts_tz TIMESTAMP WITH LOCAL TIME ZONE)");
stmt.executeUpdate("INSERT INTO timetest VALUES "
+ "(3, '2011-01-01 01:01:01', TIMESTAMP WITH LOCAL TIME ZONE '2011-01-01 01:01:01')"); // <- ok
stmt.executeUpdate("INSERT INTO timetest VALUES "
+ "(1, '2011-01-01 01:01:01', '2011-01-01 01:01:01')"); // <- failed
}
{code}
failed with no reason why:
{noformat}
java.sql.SQLException: Exception while executing query [query=INSERT INTO timetest VALUES (3, '2011-01-01 01:01:01', '2011-01-01 01:01:01')]. Error message:IGN-CMN-65535 TraceId:ba72bbc8-a0e3-414b-a520-6eed739b3f45 Remote query execution
at org.apache.ignite.internal.jdbc.proto.IgniteQueryErrorCode.createJdbcSqlException(IgniteQueryErrorCode.java:57)
at org.apache.ignite.internal.jdbc.JdbcStatement.execute0(JdbcStatement.java:148)
at org.apache.ignite.internal.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:177)
{noformat}
> Uninformative jdbc exception. The cause is not logged on the server side.
> -------------------------------------------------------------------------
>
> Key: IGNITE-19272
> URL: https://issues.apache.org/jira/browse/IGNITE-19272
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 3.0.0-beta1
> Reporter: Evgeny Stanilovsky
> Assignee: Andrey Mashenkov
> Priority: Major
> Labels: ignite-3
>
> Steps to reproduce.
> {code:java}
> try (Statement stmt = conn.createStatement()) {
> stmt.executeUpdate("CREATE TABLE timetest(id INT PRIMARY KEY,"
> + "ts TIMESTAMP, ts_tz TIMESTAMP WITH LOCAL TIME ZONE)");
> stmt.executeUpdate("INSERT INTO timetest VALUES "
> + "(3, '2011-01-01 01:01:01', TIMESTAMP WITH LOCAL TIME ZONE '2011-01-01 01:01:01')"); // <- ok
> stmt.executeUpdate("INSERT INTO timetest VALUES "
> + "(1, '2011-01-01 01:01:01', '2011-01-01 01:01:01')"); // <- failed
> }
> {code}
> failed with no reason why:
> {noformat}
> java.sql.SQLException: Exception while executing query [query=INSERT INTO timetest VALUES (3, '2011-01-01 01:01:01', '2011-01-01 01:01:01')]. Error message:IGN-CMN-65535 TraceId:ba72bbc8-a0e3-414b-a520-6eed739b3f45 Remote query execution
> at org.apache.ignite.internal.jdbc.proto.IgniteQueryErrorCode.createJdbcSqlException(IgniteQueryErrorCode.java:57)
> at org.apache.ignite.internal.jdbc.JdbcStatement.execute0(JdbcStatement.java:148)
> at org.apache.ignite.internal.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:177)
> {noformat}
> Also, there is no stacktrace
--
This message was sent by Atlassian Jira
(v8.20.10#820010)