You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2019/08/14 08:25:35 UTC
[GitHub] [incubator-shardingsphere] liujuntao edited a comment on issue
#2860: Access Sharing-Proxy 4.0.0RC2 with navicat return null point
exception for lack of scheam
liujuntao edited a comment on issue #2860: Access Sharing-Proxy 4.0.0RC2 with navicat return null point exception for lack of scheam
URL: https://github.com/apache/incubator-shardingsphere/issues/2860#issuecomment-521148171
Below is the error log on my mac, if necessary , you can access remote use such as Teamviewr。
The error i reported occured when you remove the “defaultDataSourceName: ds_0” in sharding-config.yml.
[INFO ] 15:31:37.682 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ: [id: 0xd461e648, L:/127.0.0.1:3307 - R:/127.0.0.1:65240]
[INFO ] 15:31:37.682 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ COMPLETE
[INFO ] 15:31:37.850 [ShardingSphere-Command-7] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 15:31:37.850 [ShardingSphere-Command-7] ShardingSphere-SQL - Logic SQL: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:37.850 [ShardingSphere-Command-7] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@1b81654b], tables=Tables(tables=[]), logicSQL=/* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout, parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@1b81654b, where=Optional.absent(), groupBy=Optional.absent(), orderBy=Optional.absent())
[INFO ] 15:31:37.850 [ShardingSphere-Command-7] ShardingSphere-SQL - Actual SQL: ds_1 ::: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:37.884 [ShardingSphere-Command-11] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 15:31:37.884 [ShardingSphere-Command-11] ShardingSphere-SQL - Logic SQL: SELECT @@session.tx_isolation
[INFO ] 15:31:37.884 [ShardingSphere-Command-11] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@7b15320f], tables=Tables(tables=[]), logicSQL=SELECT @@session.tx_isolation, parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@7b15320f, where=Optional.absent(), groupBy=Optional.absent(), orderBy=Optional.absent())
[INFO ] 15:31:37.884 [ShardingSphere-Command-11] ShardingSphere-SQL - Actual SQL: ds_1 ::: SELECT @@session.tx_isolation
[INFO ] 15:31:38.001 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ: [id: 0xd9fc66ac, L:/127.0.0.1:3307 - R:/127.0.0.1:65241]
[INFO ] 15:31:38.001 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ COMPLETE
[INFO ] 15:31:38.073 [ShardingSphere-Command-12] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 15:31:38.074 [ShardingSphere-Command-12] ShardingSphere-SQL - Logic SQL: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.074 [ShardingSphere-Command-12] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@28bc7444], tables=Tables(tables=[]), logicSQL=/* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout, parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@28bc7444, where=Optional.absent(), groupBy=Optional.absent(), orderBy=Optional.absent())
[INFO ] 15:31:38.075 [ShardingSphere-Command-12] ShardingSphere-SQL - Actual SQL: ds_0 ::: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.086 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ: [id: 0xc32e9af7, L:/127.0.0.1:3307 - R:/127.0.0.1:65242]
[INFO ] 15:31:38.086 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ COMPLETE
[INFO ] 15:31:38.150 [ShardingSphere-Command-15] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 15:31:38.150 [ShardingSphere-Command-15] ShardingSphere-SQL - Logic SQL: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.150 [ShardingSphere-Command-15] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@7a68e9e5], tables=Tables(tables=[]), logicSQL=/* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout, parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@7a68e9e5, where=Optional.absent(), groupBy=Optional.absent(), orderBy=Optional.absent())
[INFO ] 15:31:38.150 [ShardingSphere-Command-15] ShardingSphere-SQL - Actual SQL: ds_3 ::: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.158 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ: [id: 0x9f4fb62a, L:/127.0.0.1:3307 - R:/127.0.0.1:65243]
[INFO ] 15:31:38.158 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ COMPLETE
[INFO ] 15:31:38.224 [ShardingSphere-Command-2] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 15:31:38.224 [ShardingSphere-Command-2] ShardingSphere-SQL - Logic SQL: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.224 [ShardingSphere-Command-2] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@7daa3387], tables=Tables(tables=[]), logicSQL=/* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout, parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@7daa3387, where=Optional.absent(), groupBy=Optional.absent(), orderBy=Optional.absent())
[INFO ] 15:31:38.224 [ShardingSphere-Command-2] ShardingSphere-SQL - Actual SQL: ds_1 ::: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.231 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ: [id: 0x57739fc7, L:/127.0.0.1:3307 - R:/127.0.0.1:65244]
[INFO ] 15:31:38.231 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ COMPLETE
[INFO ] 15:31:38.289 [ShardingSphere-Command-5] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 15:31:38.289 [ShardingSphere-Command-5] ShardingSphere-SQL - Logic SQL: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.289 [ShardingSphere-Command-5] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@618759c4], tables=Tables(tables=[]), logicSQL=/* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout, parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@618759c4, where=Optional.absent(), groupBy=Optional.absent(), orderBy=Optional.absent())
[INFO ] 15:31:38.289 [ShardingSphere-Command-5] ShardingSphere-SQL - Actual SQL: ds_0 ::: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.296 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ: [id: 0xb14bbb81, L:/127.0.0.1:3307 - R:/127.0.0.1:65245]
[INFO ] 15:31:38.296 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ COMPLETE
[INFO ] 15:31:38.352 [ShardingSphere-Command-8] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 15:31:38.352 [ShardingSphere-Command-8] ShardingSphere-SQL - Logic SQL: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.352 [ShardingSphere-Command-8] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@3677c495], tables=Tables(tables=[]), logicSQL=/* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout, parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@3677c495, where=Optional.absent(), groupBy=Optional.absent(), orderBy=Optional.absent())
[INFO ] 15:31:38.352 [ShardingSphere-Command-8] ShardingSphere-SQL - Actual SQL: ds_3 ::: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.360 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ: [id: 0xf94c614e, L:/127.0.0.1:3307 - R:/127.0.0.1:65246]
[INFO ] 15:31:38.360 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ COMPLETE
[INFO ] 15:31:38.417 [ShardingSphere-Command-11] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 15:31:38.417 [ShardingSphere-Command-11] ShardingSphere-SQL - Logic SQL: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.417 [ShardingSphere-Command-11] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@31edbc30], tables=Tables(tables=[]), logicSQL=/* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout, parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@31edbc30, where=Optional.absent(), groupBy=Optional.absent(), orderBy=Optional.absent())
[INFO ] 15:31:38.417 [ShardingSphere-Command-11] ShardingSphere-SQL - Actual SQL: ds_1 ::: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.431 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ: [id: 0x257d6efc, L:/127.0.0.1:3307 - R:/127.0.0.1:65247]
[INFO ] 15:31:38.432 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ COMPLETE
[INFO ] 15:31:38.495 [ShardingSphere-Command-14] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 15:31:38.495 [ShardingSphere-Command-14] ShardingSphere-SQL - Logic SQL: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.495 [ShardingSphere-Command-14] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@5c7910f0], tables=Tables(tables=[]), logicSQL=/* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout, parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@5c7910f0, where=Optional.absent(), groupBy=Optional.absent(), orderBy=Optional.absent())
[INFO ] 15:31:38.495 [ShardingSphere-Command-14] ShardingSphere-SQL - Actual SQL: ds_3 ::: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.503 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ: [id: 0x32414b4d, L:/127.0.0.1:3307 - R:/127.0.0.1:65248]
[INFO ] 15:31:38.503 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ COMPLETE
[INFO ] 15:31:38.566 [ShardingSphere-Command-1] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 15:31:38.566 [ShardingSphere-Command-1] ShardingSphere-SQL - Logic SQL: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.566 [ShardingSphere-Command-1] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@4d5d55fa], tables=Tables(tables=[]), logicSQL=/* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout, parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@4d5d55fa, where=Optional.absent(), groupBy=Optional.absent(), orderBy=Optional.absent())
[INFO ] 15:31:38.566 [ShardingSphere-Command-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.573 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ: [id: 0x72ebe0e8, L:/127.0.0.1:3307 - R:/127.0.0.1:65249]
[INFO ] 15:31:38.573 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ COMPLETE
[INFO ] 15:31:38.633 [ShardingSphere-Command-4] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 15:31:38.633 [ShardingSphere-Command-4] ShardingSphere-SQL - Logic SQL: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:31:38.633 [ShardingSphere-Command-4] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@91c8a97], tables=Tables(tables=[]), logicSQL=/* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout, parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@91c8a97, where=Optional.absent(), groupBy=Optional.absent(), orderBy=Optional.absent())
[INFO ] 15:31:38.633 [ShardingSphere-Command-4] ShardingSphere-SQL - Actual SQL: ds_0 ::: /* mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
[INFO ] 15:47:07.657 [ShardingSphere-Command-8] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 15:47:07.658 [ShardingSphere-Command-8] ShardingSphere-SQL - Logic SQL: CREATE TABLE IF NOT EXISTS t_order (order_id BIGINT AUTO_INCREMENT, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));
[INFO ] 15:47:07.658 [ShardingSphere-Command-8] ShardingSphere-SQL - SQLStatement: CreateTableStatement(super=DDLStatement(super=AbstractSQLStatement(sqlSegments=[TableSegment(startIndex=27, stopIndex=33, name=t_order, quoteCharacter=NONE, owner=Optional.absent(), alias=Optional.absent()), org.apache.shardingsphere.core.parse.sql.segment.ddl.column.ColumnDefinitionSegment@4a1ef1f1, org.apache.shardingsphere.core.parse.sql.segment.ddl.column.ColumnDefinitionSegment@38e659bc, org.apache.shardingsphere.core.parse.sql.segment.ddl.column.ColumnDefinitionSegment@54e407c9, org.apache.shardingsphere.core.parse.sql.segment.ddl.constraint.ConstraintDefinitionSegment@763e7f20], tables=Tables(tables=[Table(name=t_order, alias=Optional.absent())]), logicSQL=CREATE TABLE IF NOT EXISTS t_order (order_id BIGINT AUTO_INCREMENT, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));, parametersCount=0), indexName=null), columnDefinitions=[org.apache.shardingsphere.core.parse.sql.segment.ddl.column.ColumnDefinitionSegment@4a1ef1f1, org.apache.shardingsphere.core.parse.sql.segment.ddl.column.ColumnDefinitionSegment@38e659bc, org.apache.shardingsphere.core.parse.sql.segment.ddl.column.ColumnDefinitionSegment@54e407c9])
[INFO ] 15:47:07.658 [ShardingSphere-Command-8] ShardingSphere-SQL - Actual SQL: ds_0 ::: CREATE TABLE IF NOT EXISTS t_order_0 (order_id BIGINT AUTO_INCREMENT, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));
[INFO ] 15:47:07.658 [ShardingSphere-Command-8] ShardingSphere-SQL - Actual SQL: ds_0 ::: CREATE TABLE IF NOT EXISTS t_order_1 (order_id BIGINT AUTO_INCREMENT, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));
[INFO ] 15:47:07.658 [ShardingSphere-Command-8] ShardingSphere-SQL - Actual SQL: ds_1 ::: CREATE TABLE IF NOT EXISTS t_order_0 (order_id BIGINT AUTO_INCREMENT, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));
[INFO ] 15:47:07.658 [ShardingSphere-Command-8] ShardingSphere-SQL - Actual SQL: ds_1 ::: CREATE TABLE IF NOT EXISTS t_order_1 (order_id BIGINT AUTO_INCREMENT, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));
[INFO ] 15:47:18.753 [ShardingSphere-Command-10] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 15:47:18.753 [ShardingSphere-Command-10] ShardingSphere-SQL - Logic SQL: CREATE TABLE IF NOT EXISTS t_order_item (order_item_id BIGINT AUTO_INCREMENT, order_id BIGINT, user_id INT NOT NULL, status VARCHAR(50) , PRIMARY KEY (order_item_id));
[INFO ] 15:47:18.753 [ShardingSphere-Command-10] ShardingSphere-SQL - SQLStatement: CreateTableStatement(super=DDLStatement(super=AbstractSQLStatement(sqlSegments=[TableSegment(startIndex=27, stopIndex=38, name=t_order_item, quoteCharacter=NONE, owner=Optional.absent(), alias=Optional.absent()), org.apache.shardingsphere.core.parse.sql.segment.ddl.column.ColumnDefinitionSegment@6f4836b9, org.apache.shardingsphere.core.parse.sql.segment.ddl.column.ColumnDefinitionSegment@46adaa7c, org.apache.shardingsphere.core.parse.sql.segment.ddl.column.ColumnDefinitionSegment@7be4b8c3, org.apache.shardingsphere.core.parse.sql.segment.ddl.column.ColumnDefinitionSegment@4f1cb4a6, org.apache.shardingsphere.core.parse.sql.segment.ddl.constraint.ConstraintDefinitionSegment@614fae02], tables=Tables(tables=[Table(name=t_order_item, alias=Optional.absent())]), logicSQL=CREATE TABLE IF NOT EXISTS t_order_item (order_item_id BIGINT AUTO_INCREMENT, order_id BIGINT, user_id INT NOT NULL, status VARCHAR(50) , PRIMARY KEY (order_item_id));, parametersCount=0), indexName=null), columnDefinitions=[org.apache.shardingsphere.core.parse.sql.segment.ddl.column.ColumnDefinitionSegment@6f4836b9, org.apache.shardingsphere.core.parse.sql.segment.ddl.column.ColumnDefinitionSegment@46adaa7c, org.apache.shardingsphere.core.parse.sql.segment.ddl.column.ColumnDefinitionSegment@7be4b8c3, org.apache.shardingsphere.core.parse.sql.segment.ddl.column.ColumnDefinitionSegment@4f1cb4a6])
[INFO ] 15:47:18.753 [ShardingSphere-Command-10] ShardingSphere-SQL - Actual SQL: ds_0 ::: CREATE TABLE IF NOT EXISTS t_order_item_0 (order_item_id BIGINT AUTO_INCREMENT, order_id BIGINT, user_id INT NOT NULL, status VARCHAR(50) , PRIMARY KEY (order_item_id));
[INFO ] 15:47:18.754 [ShardingSphere-Command-10] ShardingSphere-SQL - Actual SQL: ds_0 ::: CREATE TABLE IF NOT EXISTS t_order_item_1 (order_item_id BIGINT AUTO_INCREMENT, order_id BIGINT, user_id INT NOT NULL, status VARCHAR(50) , PRIMARY KEY (order_item_id));
[INFO ] 15:47:18.754 [ShardingSphere-Command-10] ShardingSphere-SQL - Actual SQL: ds_1 ::: CREATE TABLE IF NOT EXISTS t_order_item_0 (order_item_id BIGINT AUTO_INCREMENT, order_id BIGINT, user_id INT NOT NULL, status VARCHAR(50) , PRIMARY KEY (order_item_id));
[INFO ] 15:47:18.754 [ShardingSphere-Command-10] ShardingSphere-SQL - Actual SQL: ds_1 ::: CREATE TABLE IF NOT EXISTS t_order_item_1 (order_item_id BIGINT AUTO_INCREMENT, order_id BIGINT, user_id INT NOT NULL, status VARCHAR(50) , PRIMARY KEY (order_item_id));
[INFO ] 15:47:50.245 [ShardingSphere-Command-13] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 15:47:50.245 [ShardingSphere-Command-13] ShardingSphere-SQL - Logic SQL: TRUNCATE TABLE t_order;
[INFO ] 15:47:50.245 [ShardingSphere-Command-13] ShardingSphere-SQL - SQLStatement: DDLStatement(super=AbstractSQLStatement(sqlSegments=[TableSegment(startIndex=15, stopIndex=21, name=t_order, quoteCharacter=NONE, owner=Optional.absent(), alias=Optional.absent())], tables=Tables(tables=[Table(name=t_order, alias=Optional.absent())]), logicSQL=TRUNCATE TABLE t_order;, parametersCount=0), indexName=null)
[INFO ] 15:47:50.245 [ShardingSphere-Command-13] ShardingSphere-SQL - Actual SQL: ds_0 ::: TRUNCATE TABLE t_order_0;
[INFO ] 15:47:50.245 [ShardingSphere-Command-13] ShardingSphere-SQL - Actual SQL: ds_0 ::: TRUNCATE TABLE t_order_1;
[INFO ] 15:47:50.245 [ShardingSphere-Command-13] ShardingSphere-SQL - Actual SQL: ds_1 ::: TRUNCATE TABLE t_order_0;
[INFO ] 15:47:50.245 [ShardingSphere-Command-13] ShardingSphere-SQL - Actual SQL: ds_1 ::: TRUNCATE TABLE t_order_1;
[INFO ] 15:48:16.380 [ShardingSphere-Command-0] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 15:48:16.380 [ShardingSphere-Command-0] ShardingSphere-SQL - Logic SQL: TRUNCATE TABLE t_order_item;
[INFO ] 15:48:16.380 [ShardingSphere-Command-0] ShardingSphere-SQL - SQLStatement: DDLStatement(super=AbstractSQLStatement(sqlSegments=[TableSegment(startIndex=15, stopIndex=26, name=t_order_item, quoteCharacter=NONE, owner=Optional.absent(), alias=Optional.absent())], tables=Tables(tables=[Table(name=t_order_item, alias=Optional.absent())]), logicSQL=TRUNCATE TABLE t_order_item;, parametersCount=0), indexName=null)
[INFO ] 15:48:16.380 [ShardingSphere-Command-0] ShardingSphere-SQL - Actual SQL: ds_0 ::: TRUNCATE TABLE t_order_item_0;
[INFO ] 15:48:16.380 [ShardingSphere-Command-0] ShardingSphere-SQL - Actual SQL: ds_0 ::: TRUNCATE TABLE t_order_item_1;
[INFO ] 15:48:16.380 [ShardingSphere-Command-0] ShardingSphere-SQL - Actual SQL: ds_1 ::: TRUNCATE TABLE t_order_item_0;
[INFO ] 15:48:16.380 [ShardingSphere-Command-0] ShardingSphere-SQL - Actual SQL: ds_1 ::: TRUNCATE TABLE t_order_item_1;
[INFO ] 15:49:22.888 [ShardingSphere-Command-4] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 15:49:22.889 [ShardingSphere-Command-4] ShardingSphere-SQL - Logic SQL: INSERT INTO t_order (user_id, status) VALUES (?, ?);
[INFO ] 15:49:22.889 [ShardingSphere-Command-4] ShardingSphere-SQL - SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[TableSegment(startIndex=12, stopIndex=18, name=t_order, quoteCharacter=NONE, owner=Optional.absent(), alias=Optional.absent()), ColumnSegment(startIndex=21, stopIndex=27, name=user_id, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=30, stopIndex=35, name=status, quoteCharacter=NONE, owner=Optional.absent()), org.apache.shardingsphere.core.parse.sql.segment.dml.column.InsertColumnsSegment@65141608, org.apache.shardingsphere.core.parse.sql.segment.dml.assignment.InsertValuesSegment@14126fa6], tables=Tables(tables=[Table(name=t_order, alias=Optional.absent())]), logicSQL=INSERT INTO t_order (user_id, status) VALUES (?, ?);, parametersCount=2)), columns=[ColumnSegment(startIndex=21, stopIndex=27, name=user_id, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=30, stopIndex=35, name=status, quoteCharacter=NONE, owner=Optional.absent())], values=[org.apache.shardingsphere.core.parse.sql.segment.dml.assignment.InsertValuesSegment@14126fa6], setAssignment=Optional.absent())
[INFO ] 15:49:22.889 [ShardingSphere-Command-4] ShardingSphere-SQL - Actual SQL: ds_1 ::: INSERT INTO t_order_1 (user_id, status, order_id) VALUES (?, ?, ?); ::: [1, INSERT_TEST, 368424991118589953]
[INFO ] 16:09:46.427 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ: [id: 0x616dcac2, L:/127.0.0.1:3307 - R:/127.0.0.1:49268]
[INFO ] 16:09:46.428 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1ac0eb17, L:/0:0:0:0:0:0:0:0:3307] READ COMPLETE
[INFO ] 16:09:46.433 [ShardingSphere-Command-2] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 16:09:46.433 [ShardingSphere-Command-2] ShardingSphere-SQL - Logic SQL: SET NAMES utf8mb4
[INFO ] 16:09:46.433 [ShardingSphere-Command-2] ShardingSphere-SQL - SQLStatement: SetStatement(super=DALStatement(super=AbstractSQLStatement(sqlSegments=[], tables=Tables(tables=[]), logicSQL=SET NAMES utf8mb4, parametersCount=0)))
[INFO ] 16:09:46.433 [ShardingSphere-Command-2] ShardingSphere-SQL - Actual SQL: ds_0 ::: SET NAMES utf8mb4
[INFO ] 16:09:46.725 [ShardingSphere-Command-1] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 16:09:46.725 [ShardingSphere-Command-1] ShardingSphere-SQL - Logic SQL: SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'information_schema' UNION SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'information_schema' UNION SELECT COUNT(*) FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = 'information_schema'
[INFO ] 16:09:46.725 [ShardingSphere-Command-1] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[TableSegment(startIndex=21, stopIndex=45, name=TABLES, quoteCharacter=NONE, owner=Optional.of(org.apache.shardingsphere.core.parse.sql.segment.common.SchemaSegment@2e3f9957), alias=Optional.absent()), ColumnSegment(startIndex=53, stopIndex=64, name=TABLE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=149, stopIndex=160, name=TABLE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=246, stopIndex=259, name=ROUTINE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@17265459, org.apache.shardingsphere.core.parse.sql.segment.dml.predicate.WhereSegment@4ed54d9d], tables=Tables(tables=[Table(name=TABLES, alias=Optional.absent())]), logicSQL=SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'information_schema' UNION SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'information_schema' UNION SELECT COUNT(*) FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = 'information_schema', parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@17265459, where=Optional.of(org.apache.shardingsphere.core.parse.sql.segment.dml.predicate.WhereSegment@4ed54d9d), groupBy=Optional.absent(), orderBy=Optional.absent())
[INFO ] 16:09:46.726 [ShardingSphere-Command-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'information_schema' UNION SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'information_schema' UNION SELECT COUNT(*) FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = 'information_schema'
[INFO ] 16:09:46.819 [ShardingSphere-Command-5] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 16:09:46.819 [ShardingSphere-Command-5] ShardingSphere-SQL - Logic SQL: SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'information_schema' ORDER BY TABLE_SCHEMA, TABLE_TYPE
[INFO ] 16:09:46.819 [ShardingSphere-Command-5] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[TableSegment(startIndex=49, stopIndex=73, name=TABLES, quoteCharacter=NONE, owner=Optional.of(org.apache.shardingsphere.core.parse.sql.segment.common.SchemaSegment@10f04858), alias=Optional.absent()), ColumnSegment(startIndex=7, stopIndex=18, name=TABLE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=21, stopIndex=30, name=TABLE_NAME, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=33, stopIndex=42, name=TABLE_TYPE, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=81, stopIndex=92, name=TABLE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=126, stopIndex=137, name=TABLE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=140, stopIndex=149, name=TABLE_TYPE, quoteCharacter=NONE, owner=Optional.absent()), org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@76abd0f9, org.apache.shardingsphere.core.parse.sql.segment.dml.predicate.WhereSegment@2d89f596, org.apache.shardingsphere.core.parse.sql.segment.dml.order.OrderBySegment@18b8cecb], tables=Tables(tables=[Table(name=TABLES, alias=Optional.absent())]), logicSQL=SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'information_schema' ORDER BY TABLE_SCHEMA, TABLE_TYPE, parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@76abd0f9, where=Optional.of(org.apache.shardingsphere.core.parse.sql.segment.dml.predicate.WhereSegment@2d89f596), groupBy=Optional.absent(), orderBy=Optional.of(org.apache.shardingsphere.core.parse.sql.segment.dml.order.OrderBySegment@18b8cecb))
[INFO ] 16:09:46.819 [ShardingSphere-Command-5] ShardingSphere-SQL - Actual SQL: ds_0 ::: SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'information_schema' ORDER BY TABLE_SCHEMA, TABLE_TYPE
[INFO ] 16:09:46.904 [ShardingSphere-Command-6] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 16:09:46.904 [ShardingSphere-Command-6] ShardingSphere-SQL - Logic SQL: SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'information_schema' ORDER BY TABLE_SCHEMA, TABLE_NAME
[INFO ] 16:09:46.904 [ShardingSphere-Command-6] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[TableSegment(startIndex=63, stopIndex=88, name=COLUMNS, quoteCharacter=NONE, owner=Optional.of(org.apache.shardingsphere.core.parse.sql.segment.common.SchemaSegment@268c1dee), alias=Optional.absent()), ColumnSegment(startIndex=7, stopIndex=18, name=TABLE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=21, stopIndex=30, name=TABLE_NAME, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=33, stopIndex=43, name=COLUMN_NAME, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=46, stopIndex=56, name=COLUMN_TYPE, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=96, stopIndex=107, name=TABLE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=141, stopIndex=152, name=TABLE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=155, stopIndex=164, name=TABLE_NAME, quoteCharacter=NONE, owner=Optional.absent()), org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@18442b90, org.apache.shardingsphere.core.parse.sql.segment.dml.predicate.WhereSegment@a28fbf6, org.apache.shardingsphere.core.parse.sql.segment.dml.order.OrderBySegment@293db8ba], tables=Tables(tables=[Table(name=COLUMNS, alias=Optional.absent())]), logicSQL=SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'information_schema' ORDER BY TABLE_SCHEMA, TABLE_NAME, parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@18442b90, where=Optional.of(org.apache.shardingsphere.core.parse.sql.segment.dml.predicate.WhereSegment@a28fbf6), groupBy=Optional.absent(), orderBy=Optional.of(org.apache.shardingsphere.core.parse.sql.segment.dml.order.OrderBySegment@293db8ba))
[INFO ] 16:09:46.904 [ShardingSphere-Command-6] ShardingSphere-SQL - Actual SQL: ds_0 ::: SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'information_schema' ORDER BY TABLE_SCHEMA, TABLE_NAME
[ERROR] 16:09:47.333 [ShardingSphere-Command-7] o.a.s.s.f.c.CommandExecutorTask - Exception occur:
org.apache.shardingsphere.core.parse.exception.SQLParsingException: Cannot support multiple schemas in one SQL
at org.apache.shardingsphere.core.parse.filler.impl.TableFiller.fill(TableFiller.java:42)
at org.apache.shardingsphere.core.parse.filler.impl.TableFiller.fill(TableFiller.java:35)
at org.apache.shardingsphere.core.parse.filler.SQLStatementFillerEngine.fill(SQLStatementFillerEngine.java:65)
at org.apache.shardingsphere.core.parse.SQLParseEngine.parse(SQLParseEngine.java:64)
at org.apache.shardingsphere.shardingproxy.backend.text.TextProtocolBackendHandlerFactory.newInstance(TextProtocolBackendHandlerFactory.java:66)
at org.apache.shardingsphere.shardingproxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.<init>(MySQLComQueryPacketExecutor.java:64)
at org.apache.shardingsphere.shardingproxy.frontend.mysql.command.MySQLCommandExecutorFactory.newInstance(MySQLCommandExecutorFactory.java:72)
at org.apache.shardingsphere.shardingproxy.frontend.mysql.command.MySQLCommandExecuteEngine.getCommandExecutor(MySQLCommandExecuteEngine.java:60)
at org.apache.shardingsphere.shardingproxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:85)
at org.apache.shardingsphere.shardingproxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:66)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
[INFO ] 16:09:53.298 [ShardingSphere-Command-9] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 16:09:53.299 [ShardingSphere-Command-9] ShardingSphere-SQL - Logic SQL: SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'db1' UNION SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db1' UNION SELECT COUNT(*) FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = 'db1'
[INFO ] 16:09:53.299 [ShardingSphere-Command-9] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[TableSegment(startIndex=21, stopIndex=45, name=TABLES, quoteCharacter=NONE, owner=Optional.of(org.apache.shardingsphere.core.parse.sql.segment.common.SchemaSegment@6a59e7c8), alias=Optional.absent()), ColumnSegment(startIndex=53, stopIndex=64, name=TABLE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=134, stopIndex=145, name=TABLE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=216, stopIndex=229, name=ROUTINE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@3cfaccfe, org.apache.shardingsphere.core.parse.sql.segment.dml.predicate.WhereSegment@563666b0], tables=Tables(tables=[Table(name=TABLES, alias=Optional.absent())]), logicSQL=SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'db1' UNION SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db1' UNION SELECT COUNT(*) FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = 'db1', parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@3cfaccfe, where=Optional.of(org.apache.shardingsphere.core.parse.sql.segment.dml.predicate.WhereSegment@563666b0), groupBy=Optional.absent(), orderBy=Optional.absent())
[INFO ] 16:09:53.299 [ShardingSphere-Command-9] ShardingSphere-SQL - Actual SQL: ds_0 ::: SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'db1' UNION SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db1' UNION SELECT COUNT(*) FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = 'db1'
[INFO ] 16:09:53.328 [ShardingSphere-Command-11] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 16:09:53.328 [ShardingSphere-Command-11] ShardingSphere-SQL - Logic SQL: SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'db1' ORDER BY TABLE_SCHEMA, TABLE_TYPE
[INFO ] 16:09:53.328 [ShardingSphere-Command-11] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[TableSegment(startIndex=49, stopIndex=73, name=TABLES, quoteCharacter=NONE, owner=Optional.of(org.apache.shardingsphere.core.parse.sql.segment.common.SchemaSegment@411d76f), alias=Optional.absent()), ColumnSegment(startIndex=7, stopIndex=18, name=TABLE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=21, stopIndex=30, name=TABLE_NAME, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=33, stopIndex=42, name=TABLE_TYPE, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=81, stopIndex=92, name=TABLE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=111, stopIndex=122, name=TABLE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=125, stopIndex=134, name=TABLE_TYPE, quoteCharacter=NONE, owner=Optional.absent()), org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@181cda3a, org.apache.shardingsphere.core.parse.sql.segment.dml.predicate.WhereSegment@3795951d, org.apache.shardingsphere.core.parse.sql.segment.dml.order.OrderBySegment@3e28f64a], tables=Tables(tables=[Table(name=TABLES, alias=Optional.absent())]), logicSQL=SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'db1' ORDER BY TABLE_SCHEMA, TABLE_TYPE, parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@181cda3a, where=Optional.of(org.apache.shardingsphere.core.parse.sql.segment.dml.predicate.WhereSegment@3795951d), groupBy=Optional.absent(), orderBy=Optional.of(org.apache.shardingsphere.core.parse.sql.segment.dml.order.OrderBySegment@3e28f64a))
[INFO ] 16:09:53.328 [ShardingSphere-Command-11] ShardingSphere-SQL - Actual SQL: ds_0 ::: SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'db1' ORDER BY TABLE_SCHEMA, TABLE_TYPE
[INFO ] 16:09:53.359 [ShardingSphere-Command-13] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 16:09:53.360 [ShardingSphere-Command-13] ShardingSphere-SQL - Logic SQL: SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db1' ORDER BY TABLE_SCHEMA, TABLE_NAME
[INFO ] 16:09:53.360 [ShardingSphere-Command-13] ShardingSphere-SQL - SQLStatement: SelectStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[TableSegment(startIndex=63, stopIndex=88, name=COLUMNS, quoteCharacter=NONE, owner=Optional.of(org.apache.shardingsphere.core.parse.sql.segment.common.SchemaSegment@a80183), alias=Optional.absent()), ColumnSegment(startIndex=7, stopIndex=18, name=TABLE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=21, stopIndex=30, name=TABLE_NAME, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=33, stopIndex=43, name=COLUMN_NAME, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=46, stopIndex=56, name=COLUMN_TYPE, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=96, stopIndex=107, name=TABLE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=126, stopIndex=137, name=TABLE_SCHEMA, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=140, stopIndex=149, name=TABLE_NAME, quoteCharacter=NONE, owner=Optional.absent()), org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@771c829, org.apache.shardingsphere.core.parse.sql.segment.dml.predicate.WhereSegment@30ceb677, org.apache.shardingsphere.core.parse.sql.segment.dml.order.OrderBySegment@3b14a8a6], tables=Tables(tables=[Table(name=COLUMNS, alias=Optional.absent())]), logicSQL=SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db1' ORDER BY TABLE_SCHEMA, TABLE_NAME, parametersCount=0)), selectItems=org.apache.shardingsphere.core.parse.sql.segment.dml.item.SelectItemsSegment@771c829, where=Optional.of(org.apache.shardingsphere.core.parse.sql.segment.dml.predicate.WhereSegment@30ceb677), groupBy=Optional.absent(), orderBy=Optional.of(org.apache.shardingsphere.core.parse.sql.segment.dml.order.OrderBySegment@3b14a8a6))
[INFO ] 16:09:53.360 [ShardingSphere-Command-13] ShardingSphere-SQL - Actual SQL: ds_0 ::: SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db1' ORDER BY TABLE_SCHEMA, TABLE_NAME
[ERROR] 16:09:53.411 [ShardingSphere-Command-14] o.a.s.s.f.c.CommandExecutorTask - Exception occur:
org.apache.shardingsphere.core.parse.exception.SQLParsingException: Cannot support multiple schemas in one SQL
at org.apache.shardingsphere.core.parse.filler.impl.TableFiller.fill(TableFiller.java:42)
at org.apache.shardingsphere.core.parse.filler.impl.TableFiller.fill(TableFiller.java:35)
at org.apache.shardingsphere.core.parse.filler.SQLStatementFillerEngine.fill(SQLStatementFillerEngine.java:65)
at org.apache.shardingsphere.core.parse.SQLParseEngine.parse(SQLParseEngine.java:64)
at org.apache.shardingsphere.shardingproxy.backend.text.TextProtocolBackendHandlerFactory.newInstance(TextProtocolBackendHandlerFactory.java:66)
at org.apache.shardingsphere.shardingproxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.<init>(MySQLComQueryPacketExecutor.java:64)
at org.apache.shardingsphere.shardingproxy.frontend.mysql.command.MySQLCommandExecutorFactory.newInstance(MySQLCommandExecutorFactory.java:72)
at org.apache.shardingsphere.shardingproxy.frontend.mysql.command.MySQLCommandExecuteEngine.getCommandExecutor(MySQLCommandExecuteEngine.java:60)
at org.apache.shardingsphere.shardingproxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:85)
at org.apache.shardingsphere.shardingproxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:66)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services