mirror of
https://github.com/MariaDB/server.git
synced 2025-02-14 09:25:35 +01:00
![sjaakola](/assets/img/avatar_default.png)
When client connections use threadpool, i.e. configuration has: thread_handling = pool-of-threads it turned out that during wsrep replication shutdown, not all client connections could be closed. Reason was that some client threads has stmt_da in state DA_EOF, and this state was earlier used to detect if client connection was issuing SHUTDOWN command. To fix this, the connection executing SHUTDOWN is now detected by looking at the actual command being executed: thd->get_command() == COM_SHUTDOWN During replication shutdown, all other connections but the SHUTDOWN executor, are terminated. This commit has new mtr test galera.galera_threadpool, which opens a number of threadpool client connections, and then restarts the node to verify that connections in threadpool are terminated during shutdown. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
17 lines
290 B
INI
17 lines
290 B
INI
!include ../galera_2nodes.cnf
|
|
|
|
[mysqld.1]
|
|
wsrep-node-name="node1"
|
|
log_bin=binlog
|
|
log_slave_updates=ON
|
|
wsrep_sst_method=rsync
|
|
thread_handling = pool-of-threads
|
|
|
|
[mysqld.2]
|
|
wsrep-node-name="node2"
|
|
log_bin=binlog
|
|
log_slave_updates=ON
|
|
wsrep_sst_method=rsync
|
|
thread_handling = pool-of-threads
|
|
|
|
|