ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-10004) Parse error leads to leave the transaction
Date Fri, 26 Oct 2018 13:35:00 GMT

    [ https://issues.apache.org/jira/browse/IGNITE-10004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16665174#comment-16665174
] 

ASF GitHub Bot commented on IGNITE-10004:
-----------------------------------------

GitHub user AMashenkov opened a pull request:

    https://github.com/apache/ignite/pull/5088

    IGNITE-10004: Add test.

    

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/gridgain/apache-ignite ignite-10004

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/ignite/pull/5088.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #5088
    
----
commit 4222322e8c5381db458a41d0f1a73791bf067c66
Author: Andrey V. Mashenkov <andrey.mashenkov@...>
Date:   2018-10-26T13:21:59Z

    IGNITE-10004: Add test.

----


> Parse error leads to leave the transaction
> ------------------------------------------
>
>                 Key: IGNITE-10004
>                 URL: https://issues.apache.org/jira/browse/IGNITE-10004
>             Project: Ignite
>          Issue Type: Bug
>          Components: mvcc
>    Affects Versions: 2.7
>            Reporter: Sergey Kozlov
>            Assignee: Andrew Mashenkov
>            Priority: Major
>             Fix For: 2.7
>
>
> 1. Start 2 nodes + connect sqlline
> 2. Execute following queries:
> {noformat}
> create table t10 (a int, b varchar, primary key(a)) with "ATOMICITY=TRANSACTIONAL_SNAPSHOT,backups=1";
> begin;
> insert into t10 values(1); <- worng set
> insert into t10 values(2, '2'); <- coorect set
> commit;
> {noformat}
> The output:
> {noformat}
> 0: jdbc:ignite:thin://127.0.0.1/> create table t10 (a int, b varchar, primary key(a))
with "ATOMICITY=TRANSACTIONAL_SNAP
> SHOT,backups=1";
> No rows affected (0,032 seconds)
> 0: jdbc:ignite:thin://127.0.0.1/> begin;
> No rows affected (0 seconds)
> 0: jdbc:ignite:thin://127.0.0.1/> insert into t10 values(1);
> Error: Failed to parse query. ═хтхЁэюх ъюышўхёЄтю ёЄюысЎют
> Column count does not match; SQL statement:
> insert into t10 values(1) [21002-197] (state=42000,code=1001)
> java.sql.SQLException: Failed to parse query. Неверное количество столбцов
> Column count does not match; SQL statement:
> insert into t10 values(1) [21002-197]
>         at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:750)
>         at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:212)
>         at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:475)
>         at sqlline.Commands.execute(Commands.java:823)
>         at sqlline.Commands.sql(Commands.java:733)
>         at sqlline.SqlLine.dispatch(SqlLine.java:795)
>         at sqlline.SqlLine.begin(SqlLine.java:668)
>         at sqlline.SqlLine.start(SqlLine.java:373)
>         at sqlline.SqlLine.main(SqlLine.java:265)
> 0: jdbc:ignite:thin://127.0.0.1/> insert into t10 values(2, '2');
> Error: Transaction is already completed. (state=25000,code=5004)
> java.sql.SQLException: Transaction is already completed.
>         at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:750)
>         at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:212)
>         at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:475)
>         at sqlline.Commands.execute(Commands.java:823)
>         at sqlline.Commands.sql(Commands.java:733)
>         at sqlline.SqlLine.dispatch(SqlLine.java:795)
>         at sqlline.SqlLine.begin(SqlLine.java:668)
>         at sqlline.SqlLine.start(SqlLine.java:373)
>         at sqlline.SqlLine.main(SqlLine.java:265)
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message