Error: Query Error: Lock wait timeout exceeded; try restarting transaction
Installation and Configuration
odd that its the ssd drive that filled up but i think its the full page caching cause i noticed my db got insanely huge as well
MariaDB [(none)]> SHOW PROCESSLIST;
+-----+--------------+-----------+--------------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+-----+--------------+-----------+--------------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+----------+
| 68 | greentec_jam | localhost | greentec_jam | Query | 141 | Sending data | SELECT /*!40001 SQL_NO_CACHE */ * FROM `jr_jrcore_cache` | 0.000 |
| 69 | greentec_jam | localhost | greentec_jam | Query | 147 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 70 | greentec_jam | localhost | greentec_jam | Query | 147 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 71 | greentec_jam | localhost | greentec_jam | Query | 147 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 72 | greentec_jam | localhost | greentec_jam | Query | 146 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 73 | greentec_jam | localhost | greentec_jam | Query | 143 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 76 | greentec_jam | localhost | greentec_jam | Query | 140 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 81 | greentec_jam | localhost | greentec_jam | Query | 138 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 83 | greentec_jam | localhost | greentec_jam | Query | 134 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 86 | greentec_jam | localhost | greentec_jam | Query | 131 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 89 | greentec_jam | localhost | greentec_jam | Query | 127 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 90 | greentec_jam | localhost | greentec_jam | Query | 126 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 93 | greentec_jam | localhost | greentec_jam | Query | 125 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 99 | greentec_jam | localhost | greentec_jam | Query | 121 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 100 | greentec_jam | localhost | greentec_jam | Query | 119 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 109 | greentec_jam | localhost | greentec_jam | Query | 106 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 110 | greentec_jam | localhost | greentec_jam | Query | 105 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 112 | greentec_jam | localhost | greentec_jam | Query | 103 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 115 | greentec_jam | localhost | greentec_jam | Query | 102 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 117 | greentec_jam | localhost | greentec_jam | Query | 100 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 118 | greentec_jam | localhost | greentec_jam | Query | 100 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 119 | greentec_jam | localhost | greentec_jam | Query | 100 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 120 | greentec_jam | localhost | greentec_jam | Query | 100 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 121 | greentec_jam | localhost | greentec_jam | Query | 100 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 122 | greentec_jam | localhost | greentec_jam | Query | 99 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 137 | greentec_jam | localhost | greentec_jam | Query | 64 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 138 | greentec_jam | localhost | greentec_jam | Query | 64 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 143 | greentec_jam | localhost | greentec_jam | Query | 63 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 144 | greentec_jam | localhost | greentec_jam | Query | 63 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 145 | greentec_jam | localhost | greentec_jam | Query | 63 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 146 | greentec_jam | localhost | greentec_jam | Query | 63 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 147 | greentec_jam | localhost | greentec_jam | Query | 63 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 148 | greentec_jam | localhost | greentec_jam | Query | 63 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 149 | greentec_jam | localhost | greentec_jam | Query | 63 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 150 | greentec_jam | localhost | greentec_jam | Query | 63 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 151 | greentec_jam | localhost | greentec_jam | Query | 63 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 152 | greentec_jam | localhost | greentec_jam | Query | 63 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 153 | greentec_jam | localhost | greentec_jam | Query | 63 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 154 | greentec_jam | localhost | greentec_jam | Query | 63 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 155 | greentec_jam | localhost | greentec_jam | Query | 63 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 156 | greentec_jam | localhost | greentec_jam | Query | 63 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 157 | greentec_jam | localhost | greentec_jam | Query | 63 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 160 | greentec_jam | localhost | greentec_jam | Query | 62 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 161 | greentec_jam | localhost | greentec_jam | Query | 61 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 164 | greentec_jam | localhost | greentec_jam | Query | 56 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 166 | greentec_jam | localhost | greentec_jam | Query | 54 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 171 | greentec_jam | localhost | greentec_jam | Query | 50 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 172 | greentec_jam | localhost | greentec_jam | Query | 50 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 174 | greentec_jam | localhost | greentec_jam | Query | 48 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 178 | greentec_jam | localhost | greentec_jam | Query | 46 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 179 | greentec_jam | localhost | greentec_jam | Query | 46 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 181 | greentec_jam | localhost | greentec_jam | Query | 43 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 184 | greentec_jam | localhost | greentec_jam | Query | 42 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 185 | greentec_jam | localhost | greentec_jam | Query | 41 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 190 | greentec_jam | localhost | greentec_jam | Query | 32 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 192 | greentec_jam | localhost | greentec_jam | Query | 30 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 193 | greentec_jam | localhost | greentec_jam | Query | 30 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 194 | greentec_jam | localhost | greentec_jam | Query | 29 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 195 | greentec_jam | localhost | greentec_jam | Query | 28 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 196 | greentec_jam | localhost | greentec_jam | Query | 28 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 199 | greentec_jam | localhost | greentec_jam | Query | 26 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 200 | greentec_jam | localhost | greentec_jam | Query | 26 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 201 | greentec_jam | localhost | greentec_jam | Query | 23 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 202 | greentec_jam | localhost | greentec_jam | Query | 23 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 205 | greentec_jam | localhost | greentec_jam | Query | 21 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 212 | greentec_jam | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
| 217 | greentec_jam | localhost | greentec_jam | Query | 0 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 218 | greentec_jam | localhost | greentec_jam | Query | 0 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 220 | greentec_jam | localhost | greentec_jam | Query | 0 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 221 | greentec_jam | localhost | greentec_jam | Query | 0 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 222 | greentec_jam | localhost | greentec_jam | Query | 0 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 223 | greentec_jam | localhost | greentec_jam | Query | 0 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 224 | greentec_jam | localhost | greentec_jam | Query | 0 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
| 227 | greentec_jam | localhost | greentec_jam | Query | 0 | Waiting for table level lock | UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '3865a15fc1e8d9f2a | 0.000 |
+-----+--------------+-----------+--------------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+----------+
74 rows in set (0.00 sec)
MariaDB [(none)]>
MariaDB [(none)]> SHOW PROCESSLIST;
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
| 2064 | greentec_jam | localhost | greentec_jam | Sleep | 62 | | NULL | 0.000 |
| 3143 | greentec_jam | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
| 3228 | greentec_jam | localhost | greentec_jam | Sleep | 0 | | NULL | 0.000 |
| 3229 | greentec_jam | localhost | greentec_jam | Sleep | 0 | | NULL | 0.000 |
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
4 rows in set (0.00 sec)
MariaDB [(none)]> SHOW PROCESSLIST;
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
| 2064 | greentec_jam | localhost | greentec_jam | Sleep | 73 | | NULL | 0.000 |
| 3143 | greentec_jam | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
| 3389 | greentec_jam | localhost | greentec_jam | Sleep | 0 | | NULL | 0.000 |
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
3 rows in set (0.00 sec)
MariaDB [(none)]> SHOW PROCESSLIST;
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
| 2064 | greentec_jam | localhost | greentec_jam | Sleep | 76 | | NULL | 0.000 |
| 3143 | greentec_jam | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
2 rows in set (0.00 sec)