Cdbhandle:: doupdateserverstatebatch, has anyone ever encountered the problem of batch operation MySQL failure? Multiple SQL statements fail all the time, and a single SQL statement is normal.

[TARS-Question]

2020-05-29 14:51:52|26977|ERROR|CDbHandle::doUpdateServerStateBatch exception: [TC_Mysql::execute]: mysql_query: [ UPDATE t_server_conf SET present_state='Inactive', process_id= 0 WHERE application='DidKeyBuilder' AND server_name='didkeyClient' AND node_name='10.38.166.103';UPDATE t_server_conf SET present_state='Inactive', process_id= 0 WHERE application='didkeyBuilder' AND server_name='didkeyServer' AND node_name='10.38.166.103';UPDATE t_server_conf SET present_state='Inactive', process_id= 0 WHERE application='didkeyClient' AND server_name='didkeyClient' AND node_name='10.38.166.103' ] :You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE t_server_conf SET present_state='Inactive', process_id= 0 WHERE applicati' at line 1 sql:UPDATE t_server_conf SET present_state='Inactive', process_id= 0 WHERE application='DidKeyBuilder' AND server_name='didkeyClient' AND node_name='10.38.166.103';UPDATE t_server_conf SET present_state='Inactive', process_id= 0 WHERE application='didkeyBuilder' AND server_name='didkeyServer' AND node_name='10.38.166.103';UPDATE t_server_conf SET present_state='Inactive', process_id= 0 WHERE application='didkeyClient' AND server_name='didkeyClient' AND node_name='10.38.166.103'

[tarscloudbot]

该issue长期未更新。如果问题依旧没解决，欢迎重新打开issue。TARS社区有您更精彩。

Thanks for your supporting. The issue has not been updated for a long time. If the problem is still not resolved, welcome to reopen the issue.