|
SET @@global.wsrep_sst_auth= '';
|
SHUTDOWN;
|
Can also be used
|
|
Do I need some special setting as I can't repeat?
|
|
jplindst I used the CLI for reproduction, not MTR - does that help? And the messages show up as the last few lines of the error log after shutdown.
Also quickly retested and bug is there. Let me know if you want me to test against latest trunk, but was still present on 8 Jan 2021 from what I can see.
|
|
I used CLI and mysqladmin and I can't reproduce.
|
|
Interesting.
OS:
Ubuntu 20.04.1 LTS (Focal Fossa)
|
Env:
117GB RAM, 32 Tthread CPU, gcc Version 9.3.0
|
cmake:
cmake . -DWITH_SSL=bundled -DCMAKE_BUILD_TYPE=Debug -DBUILD_CONFIG=mysql_release -DWITH_TOKUDB=0 -DWITH_JEMALLOC=no -DFEATURE_SET=community -DDEBUG_EXTNAME=OFF -DWITH_EMBEDDED_SERVER=0 -DENABLE_DOWNLOADS=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/tmp/boost_193297 -DENABLED_LOCAL_INFILE=1 -DENABLE_DTRACE=0 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_ZLIB=bundled -DWITH_ROCKSDB=1 -DWITH_PAM=ON -DFORCE_INSOURCE_BUILD=1 -DCMAKE_C_FLAGS='-Og -march=native -mtune=native' -DCMAKE_CXX_FLAGS='-Og -march=native -mtune=native' -DMYSQL_MAINTAINER_MODE=OFF
|
Retested with latest 10.6 trunk in debug, using CLI (no mysqladmin needed as SHUTDOWN works), and issue remains:
|
10.6.0 0dfabf6e409056b02e37d4503d3517725024f90d (Debug)
|
2021-01-15 14:19:36 0 [Note] InnoDB: Shutdown completed; log sequence number 43218; transaction id 19
|
2021-01-15 14:19:36 0 [Note] /test/MD150121-mariadb-10.6.0-linux-x86_64-dbg/bin/mysqld: Shutdown complete
|
Warning: Memory not freed: 56
|
Warning: 56 bytes lost at 0x14f478012390, allocated by T@0 at 0x55a9c4b123b8, mysys/my_malloc.c:231, sql/wsrep_sst.cc:249, sql/wsrep_sst.cc:285, sql/set_var.cc:208, sql/set_var.cc:859, sql/set_var.cc:746, sql/sql_parse.cc:4919
|
Memory lost: 56 bytes in 1 chunks
|
Warning: 56 bytes lost at 0x14f478012390, allocated by T@0 at sql/sql_parse.cc:7901, mysys/my_malloc.c:231, sql/wsrep_sst.cc:249, sql/wsrep_sst.cc:285, sql/set_var.cc:208, sql/set_var.cc:859, sql/set_var.cc:746, sql/sql_parse.cc:4919
|
Memory lost: 56 bytes in 1 chunks
|
Though notice the debug message has a different bytes lost size, and line number, now.
CLI command:
/test/MD150121-mariadb-10.6.0-linux-x86_64-dbg/bin/mysql -A -uroot -S/test/MD150121-mariadb-10.6.0-linux-x86_64-dbg/socket.sock --force '--prompt=10.6.0>' --binary-mode test
|
Start command:
/test/MD150121-mariadb-10.6.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-file --basedir=/test/MD150121-mariadb-10.6.0-linux-x86_64-dbg --tmpdir=/test/MD150121-mariadb-10.6.0-linux-x86_64-dbg/data --datadir=/test/MD150121-mariadb-10.6.0-linux-x86_64-dbg/data --socket=/test/MD150121-mariadb-10.6.0-linux-x86_64-dbg/socket.sock --port=11710 --log-error=/test/MD150121-mariadb-10.6.0-linux-x86_64-dbg/log/master.err --server-id=100
|
|
|
An ASAN run produces similar issues, but generates no additional information
|
10.6.0 c2ea036b7f4fc4200f168bf53ad3afd208370459 (Debug)
|
Warning: Memory not freed: 56
|
Warning: 56 bytes lost at 0x60f000010280, allocated by T@0 at 0x556202a5861e, 0x556202a599af,
|
|
10.6.0 c2ea036b7f4fc4200f168bf53ad3afd208370459 (Optimized)
|
Warning: Memory not freed: 32
|
The issue also happen when only executing:
SET @@global.wsrep_sst_auth= '';
|
And then using mysqladmin to shutdown the server. It does not happen if only SHUTDOWN; is issued without setting global.wsrep_sst_auth
|
|
Roel Can you try with branch bb-10.6-MDEV-24509 I still can't repeat. Please use -mysqld=-wsrep-debug=1
|
|
jplindst Thank you & done. Said branch also reproduces the issue.
First testcase
|
10.6.0 12d3f6c635a5f43609d5d38462db81810edb5358 (Debug)
|
Warning: Memory not freed: 56
|
Warning: 56 bytes lost at 0x14875c012390, allocated by T@0 at 0x55b5295ba51c, mysys/my_malloc.c:231, sql/wsrep_sst.cc:249, sql/wsrep_sst.cc:295, sql/set_var.cc:208, sql/set_var.cc:859, sql/set_var.cc:746, sql/sql_parse.cc:4919
|
Memory lost: 56 bytes in 1 chunks
|
Warning: 56 bytes lost at 0x14875c012390, allocated by T@0 at sql/sql_parse.cc:7901, mysys/my_malloc.c:231, sql/wsrep_sst.cc:249, sql/wsrep_sst.cc:295, sql/set_var.cc:208, sql/set_var.cc:859, sql/set_var.cc:746, sql/sql_parse.cc:4919
|
Memory lost: 56 bytes in 1 chunks
|
Second testcase
|
10.6.0 12d3f6c635a5f43609d5d38462db81810edb5358 (Debug)
|
Warning: Memory not freed: 32
|
Warning: 32 bytes lost at 0x14feb0009160, allocated by T@0 at 0x557c8f63151c, mysys/my_malloc.c:231, sql/wsrep_sst.cc:249, sql/wsrep_sst.cc:295, sql/set_var.cc:208, sql/set_var.cc:859, sql/set_var.cc:746, sql/sql_parse.cc:4919
|
Memory lost: 32 bytes in 1 chunks
|
Warning: 32 bytes lost at 0x14feb0009160, allocated by T@0 at sql/sql_parse.cc:7901, mysys/my_malloc.c:231, sql/wsrep_sst.cc:249, sql/wsrep_sst.cc:295, sql/set_var.cc:208, sql/set_var.cc:859, sql/set_var.cc:746, sql/sql_parse.cc:4919
|
Memory lost: 32 bytes in 1 chunks
|
|
|
Also figured out that the size relates to the size of the string used.
10.6.0>SET @@global.wsrep_sst_auth= '0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789'; # Length: 100
|
|
10.6.0 12d3f6c635a5f43609d5d38462db81810edb5358 (Debug)
|
Warning: Memory not freed: 128
|
Warning: 128 bytes lost at 0x1528340091c0, allocated by T@0 at 0x5633fefc651c, mysys/my_malloc.c:231, sql/wsrep_sst.cc:249, sql/wsrep_sst.cc:295, sql/set_var.cc:208, sql/set_var.cc:859, sql/set_var.cc:746, sql/sql_parse.cc:4919
|
Memory lost: 128 bytes in 1 chunks
|
Warning: 128 bytes lost at 0x1528340091c0, allocated by T@0 at sql/sql_parse.cc:7901, mysys/my_malloc.c:231, sql/wsrep_sst.cc:249, sql/wsrep_sst.cc:295, sql/set_var.cc:208, sql/set_var.cc:859, sql/set_var.cc:746, sql/sql_parse.cc:4919
|
Memory lost: 128 bytes in 1 chunks
|
|
|
jplindst Error log attached as requested! Thank you
|
|
Thanks, can you test again with bb-10.6-MDEV-24509 branch. I did test case but still can't repeat.
|