Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-8060

Sqline creating tables on client nodes works incorrect in case of node's shutdown

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • 2.4
    • 2.8
    • jdbc
    • None

    Description

      For reproducing (master branch)

      You should start one local server and one local client nodes and follow the instructions:

      1)Connect to client node:

      sqlline.bat --color=true --verbose=true -u jdbc:ignite:thin://127.0.0.1:10801

      2)Create new table on client node:

      CREATE TABLE City (id LONG PRIMARY KEY, name VARCHAR)WITH "template=replicated";

      3)Check that table exists from server node:

      !tables

      On this step table should be shown in the response.

      4)Drop the client node

      5)Create new client node

      6)Connect to new client node:

      sqlline.bat --color=true --verbose=true -u jdbc:ignite:thin://127.0.0.1:10801

      7)Check that table exists from server node:

      !tables

      On this step there is no "city" table in the list.

      8)Try to drop the table:
      DROP TABLE City;
      java.sql.SQLException: Table doesn't exist: CITY
      at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:671)
      at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:130)
      at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:299)
      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)

      9)Try to create new table:
      CREATE TABLE City (id LONG PRIMARY KEY, name VARCHAR)WITH "template=replicated";

      java.sql.SQLException: Table already exists: CITY
      at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:671)
      at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:130)
      at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:299)
      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)

      Update:

      Exceptions on CREATE/REMOVE are thrown only until first SELECT isn't done.
      !tables doen\t work even after SELECT
      SELECT works OK.

      Attachments

        1. ignite-76cc6387.log
          40 kB
          Andrei Aleksandrov
        2. ignite-a1c90af9.log
          25 kB
          Andrei Aleksandrov

        Issue Links

          Activity

            People

              Unassigned Unassigned
              aealeksandrov Andrei Aleksandrov
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: