为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: DM8
【操作系统】:win11
【CPU】:
【问题描述】*:达梦数据库配置 mycat 写入数据 logs 报错
语法分析出错 con:JDBCConnection [id=6,autocommit=true,pool=io.mycat.backend.jdbc.JDBCDatasource@550dbc7a, schema=mydb1, dbType=ORACLE, oldSchema=mydb1, packetId=1, txIsolation=0, running=false, borrowed=true, host=localhost, port=5236, con=dm.jdbc.driver.DmdbConnection@24ad2795, respHandler=SingleNodeHandler [node=dn1{/* mysql-connector-java-5.1.49 ( Revision: ad86f36e100e104cd926c6b81c8cab9565750116 ) /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, @@performance_schema AS performance_schema, @@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 transaction_isolation, @@wait_timeout AS wait_timeout}, packetId=1], attachement=dn1{/ mysql-connector-java-5.1.49 ( Revision: ad86f36e100e104cd926c6b81c8cab9565750116 ) */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, @@performance_schema AS performance_schema, @@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 transaction_isolation, @@wait_timeout AS wait_timeout}, headerOutputed=false, modifiedSQLExecuted=false, startTime=1652287142597, lastTime=1652287150457, isSpark=false, processor=io.mycat.net.NIOProcessor@1c60808a] frontend host:127.0.0.1/61823/root
2022-05-12 00:39:10.468 ERROR [BusinessExecutor20] (io.mycat.net.FrontendConnection.writeErrMessage(FrontendConnection.java:231)) - ServerConnection [id=1, schema=PRODUCTION, host=127.0.0.1, user=root,txIsolation=3, autocommit=true, schema=PRODUCTION, executeSql=null]第 1 行, 第 111 列[.]附近出现错误:
语法分析出错java.lang.Thread .getStackTrace1559
io.mycat.net.FrontendConnection .getStack245
io.mycat.net.FrontendConnection .writeErrMessage231
io.mycat.backend.mysql.nio.handler.SingleNodeHandler .backConnectionErr314
io.mycat.backend.mysql.nio.handler.SingleNodeHandler .errorResponse275
io.mycat.backend.jdbc.JDBCConnection .executeSQL389
io.mycat.backend.jdbc.JDBCConnection .access$00048
io.mycat.backend.jdbc.JDBCConnection$1 .run868
java.util.concurrent.ThreadPoolExecutor .runWorker1149
java.util.concurrent.ThreadPoolExecutor$Worker .run624
java.lang.Thread .run748
write errorMsg:{} error
2022-05-12 00:39:10.479 INFO [$_NIOREACTOR-1-RW] (io.mycat.net.AbstractConnection.close(AbstractConnection.java:531)) - close connection,reason:stream closed ,ServerConnection [id=1, schema=PRODUCTION, host=127.0.0.1, user=root,txIsolation=3, autocommit=true, schema=PRODUCTION, executeSql=null]
好兄弟问题解决了没有,我也报了这个错