Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
11.4
-
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