MySQL Bugs: #113260: Client error in error log: MY-004031

Bug #113260	Client error in error log: MY-004031 - The client was disconnected ...
Submitted:	28 Nov 2023 14:55	Modified:	3 Jul 4:25
Reporter:	Laurynas Biveinis (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S3 (Non-critical)
Version:	8.0.38, 8.4.0, 9.0.0	OS:	MacOS
Assigned to:		CPU Architecture:	Any

Description:
On macOS 8.2.0 debug build:
$ ./mtr rpl_nogtid.rpl_semi_sync_sender_observe_commit_only
...
[ 25%] rpl_nogtid.rpl_semi_sync_sender_observe_commit_only 'mix'  [ fail ]  Found warnings/errors in error log file!
        Test ended at 2023-11-28 16:52:18
include/load_error_log.inc
line
2023-11-28T14:51:09.590102Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-004031 - The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior.
.... repeated 2957 times: [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-004031 - The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior.
2023-11-28T14:51:11.043388Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-004031 - The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior.
.... repeated 7965 times: [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-004031 - The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior.
2023-11-28T14:52:14.382636Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-004031 - The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior.
.... repeated 2405 times: [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-004031 - The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior.
^ Found warnings in /Users/laurynas/vilniusdb/mysql-8.2.0/_build-debug-llvm-14/mysql-test/var/log/mysqld.1.err

How to repeat:
See above

Same on rpl_nogtid.rpl_semi_sync

Same for rpl_nogtid.rpl_semi_sync_optimize_for_static_plugin_config

Hi,

Thanks for the report but do you see same issues with release build or only with debug build?

Yes, the output is exactly the same with a release build.

Hi,

I did not reproduce this on intel linux. I see you specified macos, did you run this on arm64 or intel and what binary you used? Thanks

Own build on arm64 with
1) -DCMAKE_EXPORT_COMPILE_COMMANDS=ON -DBUILD_CONFIG=mysql_release -DCMAKE_BUILD_TYPE=Release -DMYSQL_MAINTAINER_MODE=ON -DDOWNLOAD_BOOST=ON -DWITH_BOOST=~/vilniusdb/mysql-boost/ -DWITH_SYSTEM_LIBS=ON -DFORCE_COLORED_OUTPUT=ON -DCMAKE_CXX_FLAGS=-ffp-contract=off -DCMAKE_C_FLAGS_DEBUG=-ffp-contract=off -g -DCMAKE_CXX_FLAGS_DEBUG=-ffp-contract=off -g -DCMAKE_CXX_FLAGS_RELEASE=-ffp-contract=off -O2 -g -DNDEBUG

2) -DCMAKE_EXPORT_COMPILE_COMMANDS=ON -DCMAKE_BUILD_TYPE=Debug -DWITH_DEBUG=ON -DMYSQL_MAINTAINER_MODE=ON -DDOWNLOAD_BOOST=ON -DWITH_BOOST=~/vilniusdb/mysql-boost/ -DWITH_SYSTEM_LIBS=ON -DFORCE_COLORED_OUTPUT=ON -DCMAKE_CXX_FLAGS=-ffp-contract=off -DCMAKE_C_FLAGS_DEBUG=-ffp-contract=off -g -DCMAKE_CXX_FLAGS_DEBUG=-ffp-contract=off -g -DCMAKE_CXX_FLAGS_RELEASE=-ffp-contract=off -O2 -g -DNDEBUG

Thanks for report, reproduced as described

Same on 8.0.36

Same on 8.3.0.

Same on 8.0.37

Same on 8.4.0

Same on 8.0.38

Same on 8.4.1.

Same on 9.0.0