Hello! This looks almost exactly like a known issue https://issues.apache.org/jira/browse/IGNITE-8055 and its friends, which will be fixed in 2.8.
Regards, -- Ilya Kasnacheev пн, 22 апр. 2019 г. в 18:12, shivakumar <shivakumar....@gmail.com>: > Hi all, > I created one table with JDBC connection, batch inserted around 13 crore > records to that table then I'am trying to drop the table from sqlline, but > it hangs for some time and gives *java.sql.SQLException: Statement is > closed* exception and if i check number of records using *select count(*) > from Cell;* statements then all 13 crore records still exists in that table > but if I try to drop again it says table not exists. > > [root@ignite-st-controller bin]# ./sqlline.sh --verbose=true -u > "jdbc:ignite:thin://10.*.*.*:10800;user=ignite;password=ignite;" > issuing: !connect > jdbc:ignite:thin://10.*.*.*:10800;user=ignite;password=ignite; '' '' > org.apache.ignite.IgniteJdbcThinDriver > Connecting to > jdbc:ignite:thin://10.*.*.*:10800;user=ignite;password=ignite; > Connected to: Apache Ignite (version 2.7.0#19700101-sha1:00000000) > Driver: Apache Ignite Thin JDBC Driver (version > 2.7.0#20181130-sha1:256ae401) > Autocommit status: true > Transaction isolation: TRANSACTION_REPEATABLE_READ > sqlline version 1.3.0 > 0: jdbc:ignite:thin://10.*.*.*:10800> DROP TABLE IF EXISTS CELL; > Error: Statement is closed. (state=,code=0) > java.sql.SQLException: Statement is closed. > at > > org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.ensureNotClosed(JdbcThinStatement.java:862) > at > > org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.getWarnings(JdbcThinStatement.java:454) > at sqlline.Commands.execute(Commands.java:849) > 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://10.*.*.*:10800> > 0: jdbc:ignite:thin://10.*.*.*:10800> select count(*) from CELL; > +--------------------------------+ > | COUNT(*) | > +--------------------------------+ > | 131471437 | > +--------------------------------+ > 1 row selected (4.564 seconds) > 0: jdbc:ignite:thin://10.*.*.*:10800> DROP TABLE CELL; > Error: Table doesn't exist: CELL (state=42000,code=3001) > java.sql.SQLException: Table doesn't exist: CELL > 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://10.*.*.*:10800> select count(*) from CELL; > +--------------------------------+ > | COUNT(*) | > +--------------------------------+ > | 131482007 | > +--------------------------------+ > 1 row selected (1.264 seconds) > 0: jdbc:ignite:thin://10.*.*.*:10800> > > > > > regards, > shiva > > > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
