Default port for JdbcThinDriver is 10800, while this node started on: Local ports: TCP:10801 TCP:11211 TCP:47101 UDP:47400 TCP:47501 It's possible that you have some problem node started on the port 10800.
OR As I see, you have Topology snapshot [ver=6024, servers=1, clients=0, CPUs=64, heap=1.0GB], which means that it's daemon node was started earlier and it stores topology version. It's possible that you could connect to the this node too. To fix this you need to stop all other nodes, including visor and connect to the default port or just change a port in the connection string. Evgenii 2018-01-25 13:07 GMT+03:00 Rahul Pandey <[email protected]> : > Hi, > > I do not know where to find complete logs for sqlline. > > The lists of steps which I am following is: > > 1. Starting one ignite server by using ignite.sh script with no xml > configuration. > The logs for this step I have attached. > > 2. Starting sqlline with following commands: > ./sqlline.sh --color=true --verbose=true -u jdbc:ignite:thin://127.0.0.1/ > > 3. Executing query to see list of tables with the help of !tables command > > On third step I get the following error: > > Error: Failed to handle JDBC request because node is stopping. > (state=50000,code=0) > java.sql.SQLException: Failed to handle JDBC request because node is > stopping. > at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.send > Request(JdbcThinConnection.java:671) > at org.apache.ignite.internal.jdbc.thin.JdbcThinDatabaseMetadat > a.getTables(JdbcThinDatabaseMetadata.java:740) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce > ssorImpl.java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe > thodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at sqlline.Reflector.invoke(Reflector.java:75) > at sqlline.Commands.metadata(Commands.java:194) > at sqlline.Commands.tables(Commands.java:332) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce > ssorImpl.java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe > thodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHa > ndler.java:38) > at sqlline.SqlLine.dispatch(SqlLine.java:791) > at sqlline.SqlLine.begin(SqlLine.java:668) > at sqlline.SqlLine.start(SqlLine.java:373) > at sqlline.SqlLine.main(SqlLine.java:265) > > > Regards, > > > > On Thu, Jan 25, 2018 at 3:21 PM, Evgenii Zhuravlev < > [email protected]> wrote: > >> Hi Rahul, >> >> Could you please share full logs from Ignite - we need to check it's >> status. >> >> Evgenii >> >> 2018-01-25 12:34 GMT+03:00 Rahul Pandey <rahul.pandey@pragmatixservice >> s.com>: >> >>> Hi all, >>> >>> I am facing error while runnig sqlline.sh >>> >>> I am running the following commands: >>> ./sqlline.sh --color=true --verbose=true -u jdbc:ignite:thin:// >>> 127.0.0.1/ >>> >>> !tables >>> >>> Error Stack trace is as below: >>> >>> Error: Failed to handle JDBC request because node is stopping. >>> (state=50000,code=0) >>> java.sql.SQLException: Failed to handle JDBC request because node is >>> stopping. >>> at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.send >>> Request(JdbcThinConnection.java:671) >>> at org.apache.ignite.internal.jdbc.thin.JdbcThinDatabaseMetadat >>> a.getTables(JdbcThinDatabaseMetadata.java:740) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce >>> ssorImpl.java:62) >>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe >>> thodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:498) >>> at sqlline.Reflector.invoke(Reflector.java:75) >>> at sqlline.Commands.metadata(Commands.java:194) >>> at sqlline.Commands.tables(Commands.java:332) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce >>> ssorImpl.java:62) >>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe >>> thodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:498) >>> at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHa >>> ndler.java:38) >>> at sqlline.SqlLine.dispatch(SqlLine.java:791) >>> at sqlline.SqlLine.begin(SqlLine.java:668) >>> at sqlline.SqlLine.start(SqlLine.java:373) >>> at sqlline.SqlLine.main(SqlLine.java:265) >>> >>> I am running ignite.sh with default configurations. >>> >>> Regards, >>> >>> >>> ------------------------------ >>> >>> The content of this e-mail is confidential and intended solely for the >>> use of the addressee(s). The text of this email (including any attachments) >>> may contain information, belonging to Pragmatix Services Private Limited, >>> and/or its associates/ group companies/ subsidiaries (the Company), which >>> is proprietary and/or confidential or legally privileged in nature or >>> exempt from disclosure under applicable law. If you are not the >>> addressee, or the person responsible for delivering it to the addressee, >>> any disclosure, copying, distribution or any action taken or omitted to be >>> taken in reliance on it is prohibited and may be unlawful. If you have >>> received this e-mail in error, please notify the sender and remove this >>> communication entirely from your system. The recipient acknowledges that no >>> guarantee or any warranty is given as to completeness and accuracy of the >>> content of the email. The recipient further acknowledges that the views >>> contained in the email message are those of the sender and may not >>> necessarily reflect those of the Company. Before opening and accessing the >>> attachment please check and scan for virus. Thank you. >>> >>> WARNING: Computer viruses can be transmitted via email. The recipient >>> should check this email and any attachments for the presence of viruses. >>> The sender or the Company accepts no liability for any damage caused by any >>> virus transmitted by this email or errors or omissions. >>> >>> >> > > ------------------------------ > > The content of this e-mail is confidential and intended solely for the use > of the addressee(s). The text of this email (including any attachments) may > contain information, belonging to Pragmatix Services Private Limited, > and/or its associates/ group companies/ subsidiaries (the Company), which > is proprietary and/or confidential or legally privileged in nature or > exempt from disclosure under applicable law. If you are not the > addressee, or the person responsible for delivering it to the addressee, > any disclosure, copying, distribution or any action taken or omitted to be > taken in reliance on it is prohibited and may be unlawful. If you have > received this e-mail in error, please notify the sender and remove this > communication entirely from your system. The recipient acknowledges that no > guarantee or any warranty is given as to completeness and accuracy of the > content of the email. The recipient further acknowledges that the views > contained in the email message are those of the sender and may not > necessarily reflect those of the Company. Before opening and accessing the > attachment please check and scan for virus. Thank you. > > WARNING: Computer viruses can be transmitted via email. The recipient > should check this email and any attachments for the presence of viruses. > The sender or the Company accepts no liability for any damage caused by any > virus transmitted by this email or errors or omissions. > >
