still get "Commands out of sync; you can't run this command now" error when using v1.4.9

[emmaaaaa]

we have run proxysql1.4.7 on product for two weeks, and everything works ok.

today, programmer reported that they got this error "Commands out of sync; you can't run this command now", and the only thing they do is adding a comment after each query. but when they remove the comment, no error happened.

i have read the issue #1074 and updated my proxysql version to v1.4.9, but still got this error.

the odd thing is that not all queries get this error, it happens now and then. and i don't know how to reproduce this problem. i think there is capability problem of comment in proxysql. i don't now how to work it out. please help!

comment using /* .................*/, example as below:

INSERT INTO `table1` (`user_id`, `click_num`, `last_update_time`) SELECT from_user_id, '1', '1528873704' FROM table2 WHERE seid='7jj6OO9MQG8I2lU2p1n97SQbMG' ON DUPLICATE KEY UPDATE `click_num`=`click_num`+1, `last_update_time`='1528873704', `is_read`='0' /* .................*/

$ proxysql --version
ProxySQL version 1.4.9-3-gd9fd599, codename Truls

select * from global_variables;
+-----------------------------------------------------+---------------------------------------+
| variable_name                                       | variable_value                        |
+-----------------------------------------------------+---------------------------------------+
| mysql-shun_on_failures                              | 5                                     |
| mysql-shun_recovery_time_sec                        | 10                                    |
| mysql-query_retries_on_failure                      | 1                                     |
| mysql-client_multi_statements                       | true                                  |
| mysql-connect_retries_delay                         | 1                                     |
| mysql-connection_delay_multiplex_ms                 | 0                                     |
| mysql-connection_max_age_ms                         | 0                                     |
| mysql-connect_timeout_server_max                    | 10000                                 |
| mysql-eventslog_filename                            |                                       |
| mysql-eventslog_filesize                            | 104857600                             |
| mysql-default_charset                               | utf8                                  |
| mysql-free_connections_pct                          | 10                                    |
| mysql-session_idle_ms                               | 1000                                  |
| mysql-client_found_rows                             | true                                  |
| mysql-monitor_enabled                               | true                                  |
| mysql-monitor_connect_timeout                       | 600                                   |
| mysql-monitor_ping_max_failures                     | 3                                     |
| mysql-monitor_ping_timeout                          | 1000                                  |
| mysql-monitor_read_only_max_timeout_count           | 3                                     |
| mysql-monitor_replication_lag_interval              | 10000                                 |
| mysql-monitor_replication_lag_timeout               | 1000                                  |
| mysql-monitor_groupreplication_healthcheck_interval | 5000                                  |
| mysql-monitor_groupreplication_healthcheck_timeout  | 800                                   |
| mysql-monitor_replication_lag_use_percona_heartbeat |                                       |
| mysql-monitor_query_interval                        | 60000                                 |
| mysql-monitor_query_timeout                         | 100                                   |
| mysql-monitor_slave_lag_when_null                   | 60                                    |
| mysql-monitor_wait_timeout                          | true                                  |
| mysql-monitor_writer_is_also_reader                 | true                                  |
| mysql-max_allowed_packet                            | 4194304                               |
| mysql-throttle_connections_per_sec_to_hostgroup     | 1000000                               |
| mysql-max_transaction_time                          | 14400000                              |
| mysql-multiplexing                                  | true                                  |
| mysql-forward_autocommit                            | false                                 |
| mysql-enforce_autocommit_on_reads                   | false                                 |
| mysql-autocommit_false_not_reusable                 | false                                 |
| mysql-autocommit_false_is_transaction               | false                                 |
| mysql-verbose_query_error                           | false                                 |
| mysql-hostgroup_manager_verbose                     | 1                                     |
| mysql-threshold_query_length                        | 524288                                |
| mysql-threshold_resultset_size                      | 4194304                               |
| mysql-query_digests_max_digest_length               | 2048                                  |
| mysql-query_digests_max_query_length                | 65000                                 |
| mysql-wait_timeout                                  | 28800000                              |
| mysql-throttle_max_bytes_per_second_to_client       | 2147483647                            |
| mysql-throttle_ratio_server_to_client               | 0                                     |
| mysql-max_stmts_per_connection                      | 20                                    |
| mysql-max_stmts_cache                               | 10000                                 |
| mysql-mirror_max_concurrency                        | 16                                    |
| mysql-mirror_max_queue_length                       | 32000                                 |
| mysql-default_max_latency_ms                        | 1000                                  |
| mysql-query_processor_iterations                    | 0                                     |
| mysql-query_processor_regex                         | 1                                     |
| mysql-long_query_time                               | 1000                                  |
| mysql-query_cache_size_MB                           | 256                                   |
| mysql-poll_timeout_on_failure                       | 100                                   |
| mysql-server_capabilities                           | 45578                                 |
| mysql-session_idle_show_processlist                 | true                                  |
| mysql-query_digests                                 | true                                  |
| mysql-query_digests_lowercase                       | false                                 |
| mysql-servers_stats                                 | true                                  |
| mysql-default_reconnect                             | true                                  |
| mysql-ssl_p2s_ca                                    |                                       |
| mysql-ssl_p2s_cert                                  |                                       |
| mysql-ssl_p2s_key                                   |                                       |
| mysql-ssl_p2s_cipher                                |                                       |
| mysql-init_connect                                  |                                       |
| mysql-default_sql_mode                              |                                       |
| mysql-default_time_zone                             | SYSTEM                                |
| mysql-connpoll_reset_queue_length                   | 50                                    |
| mysql-stats_time_backend_query                      | false                                 |
| mysql-stats_time_query_processor                    | false                                 |
| admin-stats_credentials                             | stats:stats                           |
| admin-stats_mysql_connections                       | 60                                    |
| admin-stats_mysql_connection_pool                   | 60                                    |
| admin-stats_mysql_query_cache                       | 60                                    |
| admin-stats_system_cpu                              | 60                                    |
| admin-stats_system_memory                           | 60                                    |
| admin-telnet_admin_ifaces                           | (null)                                |
| admin-telnet_stats_ifaces                           | (null)                                |
| admin-read_only                                     | false                                 |
| admin-hash_passwords                                | true                                  |
| admin-version                                       | 1.4.9-3-gd9fd599                      |
| admin-cluster_username                              |                                       |
| admin-cluster_password                              |                                       |
| admin-cluster_check_interval_ms                     | 1000                                  |
| admin-cluster_check_status_frequency                | 10                                    |
| admin-cluster_mysql_query_rules_diffs_before_sync   | 3                                     |
| admin-cluster_mysql_servers_diffs_before_sync       | 3                                     |
| admin-cluster_mysql_users_diffs_before_sync         | 3                                     |
| admin-cluster_proxysql_servers_diffs_before_sync    | 3                                     |
| admin-cluster_mysql_query_rules_save_to_disk        | true                                  |
| admin-cluster_mysql_servers_save_to_disk            | true                                  |
| admin-cluster_mysql_users_save_to_disk              | true                                  |
| admin-cluster_proxysql_servers_save_to_disk         | true                                  |
| admin-checksum_mysql_query_rules                    | true                                  |
| admin-checksum_mysql_servers                        | true                                  |
| admin-checksum_mysql_users                          | true                                  |
| admin-web_enabled                                   | false                                 |
| admin-web_port                                      | 6080                                  |
| admin-refresh_interval                              | 2000                                  |
| mysql-threads                                       | 8                                     |
| mysql-max_connections                               | 2048                                  |
| mysql-default_query_delay                           | 0                                     |
| mysql-default_query_timeout                         | 36000000                              |
| mysql-have_compress                                 | true                                  |
| mysql-poll_timeout                                  | 2000                                  |
| mysql-default_schema                                | information_schema                    |
| mysql-stacksize                                     | 1048576                               |
| mysql-server_version                                | 5.6.36                                |
| mysql-connect_timeout_server                        | 3000                                  |
| mysql-monitor_username                              | monitor                               |
| mysql-monitor_password                              | monitor                               |
| mysql-monitor_history                               | 600000                                |
| mysql-monitor_connect_interval                      | 60000                                 |
| mysql-monitor_ping_interval                         | 10000                                 |
| mysql-monitor_read_only_interval                    | 1500                                  |
| mysql-monitor_read_only_timeout                     | 500                                   |
| mysql-ping_interval_server_msec                     | 120000                                |
| mysql-ping_timeout_server                           | 500                                   |
| mysql-commands_stats                                | true                                  |
| mysql-sessions_sort                                 | true                                  |
| mysql-connect_retries_on_failure                    | 10                                    |
+-----------------------------------------------------+---------------------------------------+

[renecannao]

Hi @emmaaaaa , I modified your initial comment for better readability.
If your issue is related to #1074 , you should change mysql-client_multi_statement from true to false

[emmaaaaa]

thank you so much. problem solved.

[renecannao]

Great! Closing