Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37357

1064 error on simple INSERT, but only after rollback

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 11.4
    • N/A
    • Parser
    • None
    • Not for Release Notes

    Description

      I'm facing strange behavior with
      /* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5 */
      error while executing procedure. I located insert statement and still reproduce the error on
      standalone

      insert into SEP (SE_ID,SP_ID,SEP_ENABLED) VALUES (69,2358,1);

      command. I have two triggers on insert for the table. I have no error, if one specified trigger is dropped. So I investigated every single command in that trigger and hadn't found any syntax error. I recreated the trigger. No help.
      Now the interesting part. After service restart, I connect to DB and execute the insert without an error. With both triggers enabled. Then I issue:

      Rollback

      and my insert changes are gone. Then I try to execute this single command once again, but now I get SQL Error (1064). And only cure is another service restart.
      That seems inconvenient to make service restart to each new successful insert. Would be great to avoid this. Any suggestions?

      Environment:
      Win-64
      11.4.2-MariaDB
      and autocommit=0 in my.ini

      Attachments

        Activity

          People

            Unassigned Unassigned
            balta Tadas Balaišis
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.