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

UPDATE failed to trigger ROLLBACK on its failure causing plugin to send next query

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 25.10.0
    • None
    • MDB Plugin, PrimProc
    • None
    • 2025-10

    Description

      Casual MTR run on Jenkins with ES 11.8.3 triggered this issue. UPDATE fails in PP causing the whole query to fail. MCS plugin in MDB runtime failed to deliver ROLLBACK and moreover it returns something to MDB client(MTR test suite driver in this case) triggering next query. This sequence breaks pluging StateMachine.
      The bug was triggered with mcs82_update_join MTR test.

      Oct 03 11:43:54 jenkins-ubuntu-2404-amd64-clean-8g0czn ExeMgr[18831]: 54.368227 |1128|0|0| D 16 CAL0041: Start SQL statement: UPDATE t2 LEFT JOIN t1 on t1.t1_int=t2.t2_int SET t1.t1_char='xyz' WHERE t1_char is NULL; |mcs82_db|
      Oct 03 11:43:54 jenkins-ubuntu-2404-amd64-clean-8g0czn env[18831]: [134B blob data]
      Oct 03 11:43:54 jenkins-ubuntu-2404-amd64-clean-8g0czn env[18831]: [134B blob data]
      Oct 03 11:43:54 jenkins-ubuntu-2404-amd64-clean-8g0czn ExeMgr[18831]: 54.371199 |1128|0|0| D 16 CAL0041: Start SQL statement: SELECT * FROM t2 ORDER BY t2_int; |mcs82_db|
      Oct 03 11:43:54 jenkins-ubuntu-2404-amd64-clean-8g0czn controllernode[18816]: controllernode[18816]: 54.410466 |0|0|0| C 29 CAL0000: InetStreamSocket::readToMagic(): I/O error1: rc-1; poll signal interrupt ( POLLHUP POLLERR )         %%10%%
      Oct 03 11:43:54 jenkins-ubuntu-2404-amd64-clean-8g0czn controllernode[18816]: 54.410466 |0|0|0| C 29 CAL0000: InetStreamSocket::readToMagic(): I/O error1: rc-1; poll signal interrupt ( POLLHUP POLLERR )         %%10%%
      Oct 03 11:43:54 jenkins-ubuntu-2404-amd64-clean-8g0czn systemd[1]: mcs-primproc.service: Main process exited, code=killed, status=11/SEGV
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              drrtuy Roman
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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