Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1.22
-
None
-
None
-
mysql Ver 15.1 Distrib 10.1.22-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
Linux HOST 4.4.0-97-generic #120-Ubuntu SMP Tue Sep 19 17:28:18 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
Description
Innodb_row_lock_current_waits increases rapidly from 0 to 18446744073709551615 and does not lower again.
As you can see, this happens very fast and it has been happening more than once.
Monitoring last hour
Monitoring current week
Monitoring last weeks
Monitoring last months
MariaDB [(none)]> show status like '%Innodb_row_lock_current%';
|
+-------------------------------+----------------------+
|
| Variable_name | Value |
|
+-------------------------------+----------------------+
|
| Innodb_row_lock_current_waits | 18446744073709551615 |
|
+-------------------------------+----------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [(none)]> select count(*) from information_schema.innodb_lock_waits;
|
+----------+
|
| count(*) |
|
+----------+
|
| 0 |
|
+----------+
|
1 row in set (0.00 sec)
|
|
MariaDB [(none)]> select version();
|
+--------------------------+
|
| version() |
|
+--------------------------+
|
| 10.1.22-MariaDB-1~xenial |
|
+--------------------------+
|
1 row in set (0.00 sec)
|
Here, I dumped my environment.
MariaDB [(none)]> show status;
|
+--------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------+
|
| Variable_name | Value |
|
+--------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------+
|
| wsrep_connected | ON |
|
| wsrep_evs_state | OPERATIONAL |
|
| wsrep_local_state_comment | Synced |
|
| wsrep_provider_name | Galera |
|
| wsrep_provider_vendor | Codership Oy <info@codership.com> |
|
| wsrep_provider_version | 25.3.19(r3667) |
|
| wsrep_ready | ON |
|