Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-718

Unable to perform the batch insert operation because DMLProc batchinsert with PID 140826 is currently holding the table lock for session 1548

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.8
    • Fix Version/s: 1.0.9
    • Component/s: DDLProc, DMLProc
    • Labels:
    • Environment:
      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.

      columnstoreSupportReport3.tgz

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            panjun.liu rambo
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.