Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.0.8
-
Linux 3.10.0-514.10.2.el7.x86_64 #1 SMP Fri Mar 3 00:04:05 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
Description
Sometime the table lock session has't auto released, Here is the error output:
SQLSTATE[HY000]: General error: 1815 Internal error: CAL0001: Insert Failed: IDB-2009: Unable to perform the batch insert operation because DMLProc batchinsert |
with PID 140826 is currently holding the table lock for session 1548. 2017-05-12 9:02:03^M |
Raw SQL : INSERT INTO vstats_servers (iid,ip, ccons, cobj, CPU, cused, hit, loads, mem, reqs, rpc, rx, time, tpr, tx, uptime) VALUES (1301, '1.82.208.123', 0, 12 |
7, 0.71, 0, 0, '4.42,3.83,3.58', 11.27, 0, 1, 0, 1494550800, 0.11, 0, 3019065),(837, '111.11.4.237', 0, 2855610, 0.79, 100, 0, '1.49,0.68,0.47', 7.25, 0, 1, 0, 1 |
494550800, 0.13, 0, 2664775),(1143, '111.20.248.168', 0, 19108, 0.87, 0.68, 0, '1.34,1.62,1.80', 7.21, 0, 1, 0, 1494550800, 0.25, 0, 3019043),(1747, '113.207.31. |
121', 0, 52, 0.88, 0, 0, '0.00,0.01,0.00', 11.98, 0, 1, 0, 1494550800, 0.14, 0, 3019065),(1101, '117.159.48.7', 0, 15782204, 0.87, 23.68, 0, '2.52,2.58,2.65', 19 |
.3, 0, 1, 0, 1494550800, 0.13, 0, 3019042),(1720, '117.169.88.45', 0, 28673, 1.35, 0.13, 0, '3.08,3.10,2.90', 17.68, 0, 1, 0, 1494550800, 0.14, 0, 3019066),(1454 |
, '117.25.158.139', 0, 4, 0.74, 0, 0, '1.45,1.71,1.82', 7.25, 0, 1, 0, 1494550800, 0.2, 0, 3019056),(1515, '121.14.157.49', 0, 342, 0.96, 0.01, 0, '0.80,1.06,1.1 |
0', 5.64, 0, 1, 0, 1494550800, 0.25, 0, 3019053),(1243, '150.138.166.248', 0, 7, 0.64, 0, 0, '2.24,2.73,2.66', 7.25, 0, 1, 0, 1494550800, 0.25, 0, 3019066),(933, |
'171.107.82.114', 0, 6, 0.8, 0, 0, '1.35,1.09,1.01', 7.26, 0, 1, 0, 1494550800, 0.33, 0, 3019052),(1152, '180.88.63.21', 0, 0, 0.87, 0, 0, '2.46,3.09,3.26', 7.4 |
9, 0, 1, 0, 1494550800, 0.17, 0, 1985885),(143, '183.6.204.16', 0, 60, 0.71, 0, 0, '2.98,3.12,3.17', 5.46, 0, 1, 0, 1494550800, 0.25, 0, 1968219),(1207, '211.91. |
140.152', 0, 223, 0.79, 0.01, 0, '3.35,2.89,2.84', 7.25, 0, 1, 0, 1494550800, 0.25, 0, 3019066),(833, '218.6.154.171', 0, 3, 0.87, 0, 0, '3.04,2.40,2.60', 7.7, 0 |
, 1, 0, 1494550800, 0.25, 0, 3019061),(1278, '219.138.39.147', 0, 894, 1.03, 0.01, 0, '1.49,1.41,1.31', 9.64, 0, 1, 0, 1494550800, 0.11, 0, 2554177),(1372, '221. |
12.140.196', 0, 0, 0.59, 0, 0, '0.94,1.54,1.74', 5.14, 0, 1, 0, 1494550800, 0.33, 0, 2139812),(1576, '221.204.173.200', 0, 1831, 0.79, 0.01, 0, '0.04,0.02,0.00', |
6.53, 0, 1, 0, 1494550800, 0.03, 0, 3019050),(826, '221.204.173.212', 0, 1508, 1.19, 0.01, 0, '4.23,4.65,4.79', 11.63, 0, 1, 0, 1494550800, 0.1, 0, 3019063),(20 |
20, '221.228.69.52', 12, 17513503, 3.25, 55.67, 0, '1.70,1.76,1.69', 59.89, 200, 2.02, 20640, 1494550800, 13.4, 33440, 43663),(838, '222.42.5.8', 0, 107, 0.71, 0 |
, 0, '0.89,1.22,1.14', 5.54, 0, 1, 0, 1494550800, 0.33, 0, 3019050),(1816, '58.222.48.20', 0, 3568, 0.87, 0.02, 0, '0.02,0.02,0.00', 12.67, 0, 1, 0, 1494550500, |
0.13, 0, 3018852),(1541, '59.49.43.56', 0, 1947, 1.03, 0.02, 0, '4.22,4.18,3.92', 9.65, 0, 1, 0, 1494550800, 0.17, 0, 3019052),(834, '59.49.43.62', 0, 2807, 1.11 |
, 0.03, 0, '4.86,4.41,4.20', 21.08, 0, 1, 0, 1494550800, 0.14, 0, 3019053),(1359, '60.217.25.205', 0, 774, 0.81, 0.03, 0, '2.28,1.79,1.59', 7.25, 0, 1, 0, 149455 |
0800, 0.11, 0, 3019066); |
Attachments are log files FYI.