SYMPTOM:
When attempting to upgrade metadata in in MySQL Enterprise 5.1 database through Strategy Configuration Wizard 9.2.0, the following error occurs:
Sample Code/Error
Failed to execute: CREATE TRIGGER DSSMDOBJTRIG BEFORE DELETE ON DSSMDOBJINFO FOR EACH ROW
BEGIN
DELETE FROM DSSMDOBJDEFN WHERE
DSSMDOBJDEFN.PROJECT_ID = OLD.PROJECT_ID AND
DSSMDOBJDEFN.OBJECT_ID = OLD.OBJECT_ID;
DELETE FROM DSSMDOBJDEF2 WHERE
DSSMDOBJDEF2.PROJECT_ID = OLD.PROJECT_ID AND
DSSMDOBJDEF2.OBJECT_ID = OLD.OBJECT_ID;
DELETE FROM DSSMDOBJBLOB WHERE
DSSMDOBJBLOB.PROJECT_ID = OLD.PROJECT_ID AND
DSSMDOBJBLOB.OBJECT_ID = OLD.OBJECT_ID;
DELETE FROM DSSMDOBJDEPN WHERE
DSSMDOBJDEPN.PROJECT_ID = OLD.PROJECT_ID AND
DSSMDOBJDEPN.OBJECT_ID = OLD.OBJECT_ID;
DELETE FROM DSSMDOBJPROP WHERE
DSSMDOBJPROP.PROJECT_ID = OLD.PROJECT_ID AND
DSSMDOBJPROP.OBJECT_ID = OLD.OBJECT_ID;
DELETE FROM DSSMDOBJCMNT WHERE
DSSMDOBJCMNT.PROJECT_ID = OLD.PROJECT_ID AND
DSSMDOBJCMNT.OBJECT_ID = OLD.OBJECT_ID;
DELETE FROM DSSMDOBJSECU WHERE
DSSMDOBJSECU.PROJECT_ID = OLD.PROJECT_ID AND
...'
Execute Query failed.
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
CAUSE:
A trigger with a different name than DSSMDOBJTRIG exists on the DSSMDOBJINFO table. It is possible that such a trigger was manually created on the table. The mdmysql.sql script used for creating or upgrading metadata tables only creates a trigger called DSSMDOBJTRIG. Since another trigger already exists on the same table when the above SQL statement is being executed, the error comes up.
ACTION:
Contact the database administrator in order to drop the other custom trigger created.
