You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by shivakumar <sh...@gmail.com> on 2019/04/22 15:12:12 UTC
Table not getting dropped
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/
Re: Table not getting dropped
Posted by Ilya Kasnacheev <il...@gmail.com>.
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 <sh...@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/
>