2014-09-30 16:38:36 |
jolan |
bug |
|
|
added bug |
2014-09-30 16:39:19 |
jolan |
description |
Hi,
I have 3 nodes that are mostly idle and they refuse to shutdown gracefully.
They are all 64-bit Ubuntu Trusty with version 5.5.39-25.11-816.
- /etc/init.d/mysql stop returns "fail"
- service mysql stop does the same as above
- kill -TERM is ignored
- mysqladmin shutdown just hangs until I ^C: Warning; Aborted waiting on pid file: '/var/lib/mysql/testdbe2.pid' after 351 seconds
Only kill -9 works.
This on a small test cluster with nearly 0 load:
Uptime: 1413 Threads: 52 Questions: 777 Slow queries: 0 Opens: 53 Flush tables: 1 Open tables: 46 Queries per second avg: 0.549
mysql> SHOW VARIABLES LIKE 'thread_handling%';
+-----------------+---------------------------+
| Variable_name | Value |
+-----------------+---------------------------+
| thread_handling | one-thread-per-connection |
+-----------------+---------------------------+
1 row in set (0.00 sec)
mysql> SHOW STATUS LIKE '%dirty%';
+--------------------------------+-------+
| Variable_name | Value |
+--------------------------------+-------+
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_bytes_dirty | 0 |
+--------------------------------+-------+
2 rows in set (0.00 sec)
There's nothing present in the log that indicates that a shutdown was requested. It's like it's being ignored or blocked.
Absolutely nothing about self-leave, innodb shutdown, etc.
I can't think of any other pertinent information. |
Hi,
I have 3 nodes that are mostly idle and they refuse to shutdown gracefully.
They are all 64-bit Ubuntu Trusty with version 5.5.39-25.11-816.
- /etc/init.d/mysql stop returns "fail"
- service mysql stop does the same as above
- kill -TERM is ignored
- mysqladmin shutdown just hangs until I ^C: Warning; Aborted waiting on pid file: '/var/lib/mysql/testdbe2.pid' after 351 seconds
Only kill -9 works.
This is on a small test cluster with nearly 0 load:
Uptime: 1413 Threads: 52 Questions: 777 Slow queries: 0 Opens: 53 Flush tables: 1 Open tables: 46 Queries per second avg: 0.549
mysql> SHOW VARIABLES LIKE 'thread_handling%';
+-----------------+---------------------------+
| Variable_name | Value |
+-----------------+---------------------------+
| thread_handling | one-thread-per-connection |
+-----------------+---------------------------+
1 row in set (0.00 sec)
mysql> SHOW STATUS LIKE '%dirty%';
+--------------------------------+-------+
| Variable_name | Value |
+--------------------------------+-------+
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_bytes_dirty | 0 |
+--------------------------------+-------+
2 rows in set (0.00 sec)
There's nothing present in the log that indicates that a shutdown was requested. It's like it's being ignored or blocked.
Absolutely nothing about self-leave, innodb shutdown, etc.
I can't think of any other pertinent information. |
|
2014-09-30 16:40:16 |
jolan |
description |
Hi,
I have 3 nodes that are mostly idle and they refuse to shutdown gracefully.
They are all 64-bit Ubuntu Trusty with version 5.5.39-25.11-816.
- /etc/init.d/mysql stop returns "fail"
- service mysql stop does the same as above
- kill -TERM is ignored
- mysqladmin shutdown just hangs until I ^C: Warning; Aborted waiting on pid file: '/var/lib/mysql/testdbe2.pid' after 351 seconds
Only kill -9 works.
This is on a small test cluster with nearly 0 load:
Uptime: 1413 Threads: 52 Questions: 777 Slow queries: 0 Opens: 53 Flush tables: 1 Open tables: 46 Queries per second avg: 0.549
mysql> SHOW VARIABLES LIKE 'thread_handling%';
+-----------------+---------------------------+
| Variable_name | Value |
+-----------------+---------------------------+
| thread_handling | one-thread-per-connection |
+-----------------+---------------------------+
1 row in set (0.00 sec)
mysql> SHOW STATUS LIKE '%dirty%';
+--------------------------------+-------+
| Variable_name | Value |
+--------------------------------+-------+
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_bytes_dirty | 0 |
+--------------------------------+-------+
2 rows in set (0.00 sec)
There's nothing present in the log that indicates that a shutdown was requested. It's like it's being ignored or blocked.
Absolutely nothing about self-leave, innodb shutdown, etc.
I can't think of any other pertinent information. |
Hi,
I have 3 nodes that are mostly idle and they refuse to shutdown gracefully.
They are all 64-bit Ubuntu Trusty with version 5.5.39-25.11-816.
- /etc/init.d/mysql stop returns "fail"
- service mysql stop does the same as above
- kill -TERM is ignored
- mysqladmin shutdown just hangs until I ^C: Warning; Aborted waiting on pid file: '/var/lib/mysql/testdbe2.pid' after 351 seconds
Only kill -9 works.
This is on a small test cluster with nearly 0 load:
Uptime: 1413 Threads: 52 Questions: 777 Slow queries: 0 Opens: 53 Flush tables: 1 Open tables: 46 Queries per second avg: 0.549
mysql> SHOW VARIABLES LIKE 'thread_handling%';
+-----------------+---------------------------+
| Variable_name | Value |
+-----------------+---------------------------+
| thread_handling | one-thread-per-connection |
+-----------------+---------------------------+
1 row in set (0.00 sec)
mysql> SHOW STATUS LIKE '%dirty%';
+--------------------------------+-------+
| Variable_name | Value |
+--------------------------------+-------+
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_bytes_dirty | 0 |
+--------------------------------+-------+
2 rows in set (0.00 sec)
There's nothing present in the log that indicates that a shutdown was requested. It's like it's being ignored or blocked.
Absolutely nothing about self-leave, innodb shutdown, etc.
I can't think of any other pertinent information.
This behavior is present across all 3 nodes. |
|
2014-10-03 19:38:50 |
Przemek |
bug |
|
|
added subscriber Przemek |
2014-10-07 15:21:04 |
Valerii Kravchuk |
nominated for series |
|
percona-xtradb-cluster/5.5 |
|
2014-10-07 15:21:04 |
Valerii Kravchuk |
bug task added |
|
percona-xtradb-cluster/5.5 |
|
2014-10-07 15:21:04 |
Valerii Kravchuk |
nominated for series |
|
percona-xtradb-cluster/5.6 |
|
2014-10-07 15:21:04 |
Valerii Kravchuk |
bug task added |
|
percona-xtradb-cluster/5.6 |
|
2014-10-12 00:56:03 |
Przemek |
percona-xtradb-cluster/5.6: status |
New |
Confirmed |
|
2014-10-12 00:56:07 |
Przemek |
percona-xtradb-cluster/5.5: status |
New |
Confirmed |
|
2014-10-12 00:58:50 |
Przemek |
summary |
graceful shutdown impossible on idle nodes; blocked or ignored |
Shutdown impossible when handlersocket active; blocked or ignored |
|
2014-11-28 07:40:22 |
Raghavendra D Prabhu |
marked as duplicate |
|
1319904 |
|