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:	17 Oct 11:28
Reporter:	Laurynas Biveinis (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S3 (Non-critical)
Version:	8.0.40, 8.4.3, 9.1.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

Same on 8.0.40.

Same on 8.4.3

Same on 9.1.0