[jira] [Comment Edited] (IGNITE-9982) SQLLine: can't run with option --autoCommit=false or true

2018-10-26 Thread Ivan Pavlukhin (JIRA) 


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

Ivan Pavlukhin edited comment on IGNITE-9982 at 10/26/18 2:27 PM:
--

TC runs:
* SQL (failed tests were introduced by this ticket fixes, were fixed and rerun 
locally) 
https://ci.ignite.apache.org/viewLog.html?buildId=2166855=buildResultsDiv=IgniteTests24Java8_RunAllSql
* MVCC JDBC 
https://ci.ignite.apache.org/viewLog.html?buildId=2166839=buildResultsDiv=IgniteTests24Java8_MvccCache
* MVCC Queries 
https://ci.ignite.apache.org/viewLog.html?buildId=2167670=buildResultsDiv=IgniteTests24Java8_MvccQueries
* MVCC Cache 
https://ci.ignite.apache.org/viewLog.html?buildId=2166843=buildResultsDiv=IgniteTests24Java8_MvccCache_2

All other failures seems flaky.


was (Author: pavlukhin):
TC runs:
*SQL (failed tests were introduced by this ticket fixes, were fixed and rerun 
locally) 
https://ci.ignite.apache.org/viewLog.html?buildId=2166855=buildResultsDiv=IgniteTests24Java8_RunAllSql
* MVCC JDBC 
https://ci.ignite.apache.org/viewLog.html?buildId=2166839=buildResultsDiv=IgniteTests24Java8_MvccCache
* MVCC Queries 
https://ci.ignite.apache.org/viewLog.html?buildId=2167670=buildResultsDiv=IgniteTests24Java8_MvccQueries
* MVCC Cache 
https://ci.ignite.apache.org/viewLog.html?buildId=2166843=buildResultsDiv=IgniteTests24Java8_MvccCache_2

All other failures seems flaky.

> SQLLine: can't run with option --autoCommit=false or true
> -
>
> Key: IGNITE-9982
> URL: https://issues.apache.org/jira/browse/IGNITE-9982
> Project: Ignite
>  Issue Type: Bug
>  Components: mvcc, sql
>Affects Versions: 2.7
>Reporter: Stepan Pilschikov
>Assignee: Ivan Pavlukhin
>Priority: Major
> Fix For: 2.7
>
>
> Trying to run sqlline with additional options
> {code}
> $ /bin/sqlline.sh --autoCommit=false --color=true --outputFormat=csv 
> --showNestedErrs=true --showWarnings=true --verbose=true -u 
> jdbc:ignite:thin://127.0.0.1:10800
> {code}
> SQLline is working but with exception on start:
> {code}
> issuing: !connect jdbc:ignite:thin://127.0.0.1:10800 '' '' 
> org.apache.ignite.IgniteJdbcThinDriver
> Connecting to jdbc:ignite:thin://127.0.0.1:10800
> Connected to: Apache Ignite (version 2.7.1#20181023-sha1:0ccde7c4)
> Driver: Apache Ignite Thin JDBC Driver (version 2.7.1#20181023-sha1:0ccde7c4)
> Error: MVCC must be enabled in order to invoke transactional operation: 
> COMMIT (state=25000,code=5002)
> java.sql.SQLException: MVCC must be enabled in order to invoke transactional 
> operation: COMMIT
> 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 
> org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.doCommit(JdbcThinConnection.java:369)
> at 
> org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.setAutoCommit(JdbcThinConnection.java:328)
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:178)
> at 
> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:204)
> at sqlline.Commands.connect(Commands.java:1095)
> at sqlline.Commands.connect(Commands.java:1001)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at 
> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
> at sqlline.SqlLine.dispatch(SqlLine.java:791)
> at sqlline.SqlLine.initArgs(SqlLine.java:566)
> at sqlline.SqlLine.begin(SqlLine.java:643)
> at sqlline.SqlLine.start(SqlLine.java:373)
> at sqlline.SqlLine.main(SqlLine.java:265)
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> {code}
> Without --autoCommit option sqlline running without this exception



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

[jira] [Comment Edited] (IGNITE-9982) SQLLine: can't run with option --autoCommit=false or true

2018-10-26 Thread Ivan Pavlukhin (JIRA) 


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

Ivan Pavlukhin edited comment on IGNITE-9982 at 10/26/18 2:27 PM:
--

TC runs:
*SQL (failed tests were introduced by this ticket fixes, were fixed and rerun 
locally) 
https://ci.ignite.apache.org/viewLog.html?buildId=2166855=buildResultsDiv=IgniteTests24Java8_RunAllSql
* MVCC JDBC 
https://ci.ignite.apache.org/viewLog.html?buildId=2166839=buildResultsDiv=IgniteTests24Java8_MvccCache
* MVCC Queries 
https://ci.ignite.apache.org/viewLog.html?buildId=2167670=buildResultsDiv=IgniteTests24Java8_MvccQueries
* MVCC Cache 
https://ci.ignite.apache.org/viewLog.html?buildId=2166843=buildResultsDiv=IgniteTests24Java8_MvccCache_2

All other failures seems flaky.


was (Author: pavlukhin):
TC runs:
SQL (failed tests were introduced by this ticket fixes, were fixed and rerun 
locally) 
https://ci.ignite.apache.org/viewLog.html?buildId=2166855=buildResultsDiv=IgniteTests24Java8_RunAllSql
MVCC JDBC 
https://ci.ignite.apache.org/viewLog.html?buildId=2166839=buildResultsDiv=IgniteTests24Java8_MvccCache

> SQLLine: can't run with option --autoCommit=false or true
> -
>
> Key: IGNITE-9982
> URL: https://issues.apache.org/jira/browse/IGNITE-9982
> Project: Ignite
>  Issue Type: Bug
>  Components: mvcc, sql
>Affects Versions: 2.7
>Reporter: Stepan Pilschikov
>Assignee: Ivan Pavlukhin
>Priority: Major
> Fix For: 2.7
>
>
> Trying to run sqlline with additional options
> {code}
> $ /bin/sqlline.sh --autoCommit=false --color=true --outputFormat=csv 
> --showNestedErrs=true --showWarnings=true --verbose=true -u 
> jdbc:ignite:thin://127.0.0.1:10800
> {code}
> SQLline is working but with exception on start:
> {code}
> issuing: !connect jdbc:ignite:thin://127.0.0.1:10800 '' '' 
> org.apache.ignite.IgniteJdbcThinDriver
> Connecting to jdbc:ignite:thin://127.0.0.1:10800
> Connected to: Apache Ignite (version 2.7.1#20181023-sha1:0ccde7c4)
> Driver: Apache Ignite Thin JDBC Driver (version 2.7.1#20181023-sha1:0ccde7c4)
> Error: MVCC must be enabled in order to invoke transactional operation: 
> COMMIT (state=25000,code=5002)
> java.sql.SQLException: MVCC must be enabled in order to invoke transactional 
> operation: COMMIT
> 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 
> org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.doCommit(JdbcThinConnection.java:369)
> at 
> org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.setAutoCommit(JdbcThinConnection.java:328)
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:178)
> at 
> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:204)
> at sqlline.Commands.connect(Commands.java:1095)
> at sqlline.Commands.connect(Commands.java:1001)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at 
> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
> at sqlline.SqlLine.dispatch(SqlLine.java:791)
> at sqlline.SqlLine.initArgs(SqlLine.java:566)
> at sqlline.SqlLine.begin(SqlLine.java:643)
> at sqlline.SqlLine.start(SqlLine.java:373)
> at sqlline.SqlLine.main(SqlLine.java:265)
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> {code}
> Without --autoCommit option sqlline running without this exception



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

[jira] [Comment Edited] (IGNITE-9982) SQLLine: can't run with option --autoCommit=false or true

2018-10-24 Thread Stepan Pilschikov (JIRA) 


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

Stepan Pilschikov edited comment on IGNITE-9982 at 10/24/18 10:14 AM:
--

Also  command `!set autoCommit false` is not changing commit mode, always used 
autocommit=true


was (Author: spilschikov):
Also  command is not changing commit mode, always used autocommit=true
{code}
!set autoCommit false
{code}

> SQLLine: can't run with option --autoCommit=false or true
> -
>
> Key: IGNITE-9982
> URL: https://issues.apache.org/jira/browse/IGNITE-9982
> Project: Ignite
>  Issue Type: Bug
>  Components: mvcc, sql
>Affects Versions: 2.7
>Reporter: Stepan Pilschikov
>Priority: Major
>
> Trying to run sqlline with additional options
> {code}
> $ /bin/sqlline.sh --autoCommit=false --color=true --outputFormat=csv 
> --showNestedErrs=true --showWarnings=true --verbose=true -u 
> jdbc:ignite:thin://127.0.0.1:10800
> {code}
> SQLline is working but with exception on start:
> {code}
> issuing: !connect jdbc:ignite:thin://127.0.0.1:10800 '' '' 
> org.apache.ignite.IgniteJdbcThinDriver
> Connecting to jdbc:ignite:thin://127.0.0.1:10800
> Connected to: Apache Ignite (version 2.7.1#20181023-sha1:0ccde7c4)
> Driver: Apache Ignite Thin JDBC Driver (version 2.7.1#20181023-sha1:0ccde7c4)
> Error: MVCC must be enabled in order to invoke transactional operation: 
> COMMIT (state=25000,code=5002)
> java.sql.SQLException: MVCC must be enabled in order to invoke transactional 
> operation: COMMIT
> 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 
> org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.doCommit(JdbcThinConnection.java:369)
> at 
> org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.setAutoCommit(JdbcThinConnection.java:328)
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:178)
> at 
> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:204)
> at sqlline.Commands.connect(Commands.java:1095)
> at sqlline.Commands.connect(Commands.java:1001)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at 
> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
> at sqlline.SqlLine.dispatch(SqlLine.java:791)
> at sqlline.SqlLine.initArgs(SqlLine.java:566)
> at sqlline.SqlLine.begin(SqlLine.java:643)
> at sqlline.SqlLine.start(SqlLine.java:373)
> at sqlline.SqlLine.main(SqlLine.java:265)
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> {code}
> Without --autoCommit option sqlline running without this exception



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