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 2020/07/10 12:12:03 UTC
[GitHub] [shardingsphere] Simbafa commented on issue #6324: ShardingSphere-Proxy stop working
Simbafa commented on issue #6324:
URL: https://github.com/apache/shardingsphere/issues/6324#issuecomment-656643302
Correct process log output like this:
```
[INFO ] 20:09:31.298 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1fbb6b60] REGISTERED
[INFO ] 20:09:31.305 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1fbb6b60] BIND: 0.0.0.0/0.0.0.0:3307
[INFO ] 20:09:31.309 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1fbb6b60, L:/0.0.0.0:3307] ACTIVE
[INFO ] 20:09:36.153 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1fbb6b60, L:/0.0.0.0:3307] READ: [id: 0x2007074d, L:/192.168.1.46:3307 - R:/192.168.1.46:44530]
[INFO ] 20:09:36.157 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1fbb6b60, L:/0.0.0.0:3307] READ COMPLETE
[INFO ] 20:09:36.543 [epollEventLoopGroup-3-1] o.a.s.s.f.m.a.MySQLAuthenticationEngine - ===Username: amRiYzpteXNxbDovLzE5Mi4xNjguMC4xMDg6MzMwNi90ZXN0P3VzZXI9cm9vdCZwYXNzd29yZD10ZXN0JnNlcnZlclRpbWV6b25lPVVUQyZ1c2VTU0w9ZmFsc2U=
[INFO ] 20:09:36.666 [epollEventLoopGroup-3-1] o.a.s.s.f.m.a.MySQLAuthenticationEngine - ===Auth connection url=jdbc:mysql://192.168.0.108:3306/test?user=root&password=test&serverTimezone=UTC&useSSL=false
[INFO ] 20:09:36.668 [epollEventLoopGroup-3-1] o.a.s.s.f.m.a.MySQLAuthenticationEngine - ===Create schema of database=test for 8d232dd2081bf9758e9a40659b84efe7
[INFO ] 20:09:36.910 [epollEventLoopGroup-3-1] com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
[INFO ] 20:09:37.446 [epollEventLoopGroup-3-1] com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
[INFO ] 20:09:37.472 [epollEventLoopGroup-3-1] ShardingSphere-metadata - Get all table names
[INFO ] 20:09:37.562 [epollEventLoopGroup-3-1] o.a.s.s.f.m.a.MySQLAuthenticationEngine - ===Login succeed
[INFO ] 20:09:37.646 [ShardingSphere-Command-0] o.a.s.s.f.m.c.MySQLCommandExecutorFactory - Execute packet type: COM_QUERY, value: MySQLComQueryPacket(sql=/* mysql-connector-java-5.1.47 ( Revision: fe1903b1ecb4a96a917f7ed3190d80c049b1de29 ) */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, @@collation_server AS collation_server, @@collation_connection AS collation_connection, @@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, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@transaction_isolation AS transaction_isolation, @@wait_timeout AS wait_timeout)
[INFO ] 20:09:38.650 [ShardingSphere-Command-0] o.a.s.s.b.c.j.w.StatementExecutorWrapperJustep - ===Modified Sql:SELECT '1' AS auto_increment_increment, 'utf8' AS character_set_client, 'utf8' AS character_set_connection, 'utf8' AS character_set_results, 'utf8' AS character_set_server , 'latin_swedish_ci' AS collation_server, 'utf8_general_ci' AS collation_connection, NULL AS init_connect, 28800 AS interactive_timeout, 'GPL' AS license , 0 AS lower_case_table_names, 67108864 AS max_allowed_packet, 16384 AS net_buffer_length, 60 AS net_write_timeout, 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' AS sql_mode , 'UTC' AS system_time_zone, 'SYSTEM' AS time_zone, 'REPEATABLE-READ' AS transaction_isolation, 28800 AS wait_timeout
[INFO ] 20:09:38.737 [ShardingSphere-Command-1] o.a.s.s.f.m.c.MySQLCommandExecutorFactory - Execute packet type: COM_QUERY, value: MySQLComQueryPacket(sql=SET character_set_results = NULL)
[INFO ] 20:09:38.755 [ShardingSphere-Command-1] o.a.s.s.b.c.j.w.StatementExecutorWrapperJustep - ===Modified Sql:SELECT 'x'
[INFO ] 20:09:38.769 [ShardingSphere-Command-2] o.a.s.s.f.m.c.MySQLCommandExecutorFactory - Execute packet type: COM_QUERY, value: MySQLComQueryPacket(sql=SET autocommit=1)
[INFO ] 20:09:38.783 [ShardingSphere-Command-2] o.a.s.t.s.ShardingTransactionManagerJustep - ===MyAddress: 192.168.1.46:3307
[INFO ] 20:09:38.790 [ShardingSphere-Command-3] o.a.s.s.f.m.c.MySQLCommandExecutorFactory - Execute packet type: COM_QUERY, value: MySQLComQueryPacket(sql=SELECT table_name FROM information_schema.tables WHERE table_schema=database())
[INFO ] 20:09:38.847 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1fbb6b60, L:/0.0.0.0:3307] READ: [id: 0x3bc18f6f, L:/192.168.1.46:3307 - R:/192.168.1.46:44534]
[INFO ] 20:09:38.855 [epollEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x1fbb6b60, L:/0.0.0.0:3307] READ COMPLETE
[INFO ] 20:09:38.863 [epollEventLoopGroup-3-2] o.a.s.s.f.m.a.MySQLAuthenticationEngine - ===Username: amRiYzpteXNxbDovLzE5Mi4xNjguMC4xMDg6MzMwNi90ZXN0P3VzZXI9cm9vdCZwYXNzd29yZD10ZXN0JnNlcnZlclRpbWV6b25lPVVUQyZ1c2VTU0w9ZmFsc2U=
[INFO ] 20:09:38.864 [epollEventLoopGroup-3-2] o.a.s.s.f.m.a.MySQLAuthenticationEngine - ===Auth connection url=jdbc:mysql://192.168.0.108:3306/test?user=root&password=test&serverTimezone=UTC&useSSL=false
[INFO ] 20:09:38.864 [epollEventLoopGroup-3-2] o.a.s.s.f.m.a.MySQLAuthenticationEngine - ===Login succeed
[INFO ] 20:09:38.865 [ShardingSphere-Command-0] o.a.s.s.f.m.c.MySQLCommandExecutorFactory - Execute packet type: COM_QUERY, value: MySQLComQueryPacket(sql=/* mysql-connector-java-5.1.47 ( Revision: fe1903b1ecb4a96a917f7ed3190d80c049b1de29 ) */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, @@collation_server AS collation_server, @@collation_connection AS collation_connection, @@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, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@transaction_isolation AS transaction_isolation, @@wait_timeout AS wait_timeout)
[INFO ] 20:09:38.876 [ShardingSphere-Command-0] o.a.s.s.b.c.j.w.StatementExecutorWrapperJustep - ===Modified Sql:SELECT '1' AS auto_increment_increment, 'utf8' AS character_set_client, 'utf8' AS character_set_connection, 'utf8' AS character_set_results, 'utf8' AS character_set_server , 'latin_swedish_ci' AS collation_server, 'utf8_general_ci' AS collation_connection, NULL AS init_connect, 28800 AS interactive_timeout, 'GPL' AS license , 0 AS lower_case_table_names, 67108864 AS max_allowed_packet, 16384 AS net_buffer_length, 60 AS net_write_timeout, 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' AS sql_mode , 'UTC' AS system_time_zone, 'SYSTEM' AS time_zone, 'REPEATABLE-READ' AS transaction_isolation, 28800 AS wait_timeout
[INFO ] 20:09:38.883 [ShardingSphere-Command-1] o.a.s.s.f.m.c.MySQLCommandExecutorFactory - Execute packet type: COM_QUERY, value: MySQLComQueryPacket(sql=SET character_set_results = NULL)
[INFO ] 20:09:38.884 [ShardingSphere-Command-1] o.a.s.s.b.c.j.w.StatementExecutorWrapperJustep - ===Modified Sql:SELECT 'x'
[INFO ] 20:09:38.887 [ShardingSphere-Command-2] o.a.s.s.f.m.c.MySQLCommandExecutorFactory - Execute packet type: COM_QUERY, value: MySQLComQueryPacket(sql=SET autocommit=1)
[INFO ] 20:09:38.888 [ShardingSphere-Command-0] o.a.s.s.f.m.c.MySQLCommandExecutorFactory - Execute packet type: COM_QUERY, value: MySQLComQueryPacket(sql=SELECT table_name FROM information_schema.tables WHERE table_schema=database())
[INFO ] 20:09:38.892 [ShardingSphere-Command-3] o.a.s.s.b.c.j.w.StatementExecutorWrapperJustep - ===Modified Sql:SELECT table_name FROM information_schema.tables WHERE table_schema = DATABASE()
[INFO ] 20:09:38.892 [ShardingSphere-Command-0] o.a.s.s.b.c.j.w.StatementExecutorWrapperJustep - ===Modified Sql:SELECT table_name FROM information_schema.tables WHERE table_schema = DATABASE()
[INFO ] 20:09:38.937 [ShardingSphere-Command-1] o.a.s.s.f.m.c.MySQLCommandExecutorFactory - Execute packet type: COM_QUERY, value: MySQLComQueryPacket(sql=select * from acls)
[INFO ] 20:09:38.939 [ShardingSphere-Command-2] o.a.s.s.f.m.c.MySQLCommandExecutorFactory - Execute packet type: COM_QUERY, value: MySQLComQueryPacket(sql=select * from acls)
[INFO ] 20:09:38.941 [ShardingSphere-Command-2] o.a.s.s.b.c.j.w.StatementExecutorWrapperJustep - ===Modified Sql:SELECT * FROM acls
[INFO ] 20:09:38.944 [ShardingSphere-Command-1] o.a.s.s.b.c.j.w.StatementExecutorWrapperJustep - ===Modified Sql:SELECT * FROM acls
```
----------------------------------------------------------------
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