Details
-
Type:
Bug
-
Status: Stalled
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.0.17-galera
-
Fix Version/s: 10.0.22-galera
-
Component/s: Galera
-
Labels:None
-
Environment:Ubuntu 14.04 amd64
galera-3
25.3.9-trusty
mariadb-10.0
10.0.17+maria-1~trusty
Description
When a trigger ran, cluster will fail. I believe the trigger is in one of mysql.log attached.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Umarzuki: What's the structure of 'EVENT_AGENT_CLONE' table?
SHOW CREATE TABLE EVENT_AGENT_CLONE
mysql> SHOW CREATE TABLE EVENT_AGENT_CLONE; +-------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | EVENT_AGENT_CLONE | CREATE TABLE `EVENT_AGENT_CLONE` ( `event` int(11) NOT NULL, `transactionType` varchar(20) NOT NULL, `dateCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 CONNECTION='mysql://dbUser:user@x.x.x.x/testCompBaru/EVENT_AGENT' | +-------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Umarzuki: hmm.. Any idea where is 'evdet_id' column coming from? What's the definition of `CREATE_` trigger?
mysql> show triggers;
+------------------------------+--------+-------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+-----------------------+-------------------+----------------------+----------------------+--------------------+
| Trigger | Event | Table | Statement | Timing | Created | sql_mode | Definer | character_set_client | collation_connection | Database Collation |
+------------------------------+--------+-------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+-----------------------+-------------------+----------------------+----------------------+--------------------+
| CREATE_ | INSERT | uni12_jevents_vevdetail | BEGIN
DECLARE counter int;
DECLARE connect_federated_fail CONDITION FOR 1296;
DECLARE error_reading_packet CONDITION FOR 1158;
DECLARE connect_federated_timeout CONDITION FOR 1159;
DECLARE write_packet_timeout CONDITION FOR 1160;
DECLARE CONTINUE HANDLER FOR connect_federated_fail, connect_federated_timeout,write_packet_timeout,error_reading_packet
BEGIN
IF counter=0 THEN
DELETE FROM EVENT_AGENT_FAILED WHERE event= new.evdet_id;
INSERT INTO EVENT_AGENT_FAILED(event, transactionType) values (new.evdet_id, 'New');
END IF;
END;
SET counter = 0;
DELETE FROM EVENT_AGENT_CLONE WHERE event= new.evdet_id;
INSERT INTO EVENT_AGENT_CLONE (event, transactionType) values (new.evdet_id, 'New');
SET counter=1;
END | AFTER | NULL | NO_AUTO_VALUE_ON_ZERO | webjedi@localhost | utf8 | utf8_general_ci | latin1_swedish_ci |
| DELETE_ | DELETE | uni12_jevents_vevdetail | BEGIN
DECLARE counter int;
DECLARE connect_federated_fail CONDITION FOR 1296;
DECLARE error_reading_packet CONDITION FOR 1158;
DECLARE connect_federated_timeout CONDITION FOR 1159;
DECLARE write_packet_timeout CONDITION FOR 1160;
DECLARE CONTINUE HANDLER FOR connect_federated_fail, connect_federated_timeout,write_packet_timeout,error_reading_packet
BEGIN
IF counter=0 THEN
DELETE FROM EVENT_AGENT_FAILED WHERE event= old.evdet_id;
INSERT INTO EVENT_AGENT_FAILED(event, transactionType) values (old.evdet_id, 'Cancelled');
END IF;
END;
SET counter=0;
DELETE FROM EVENT_AGENT_CLONE WHERE event= old.evdet_id;
INSERT INTO EVENT_AGENT_CLONE(event, transactionType) values (old.evdet_id, 'Cancelled');
SET counter=1;
END | AFTER | NULL | NO_AUTO_VALUE_ON_ZERO | webjedi@localhost | utf8 | utf8_general_ci | latin1_swedish_ci |
| UPDATE_EVENT_AGENT_CLONE_CAT | UPDATE | uni12_jevents_vevent | BEGIN
DECLARE counter int;
DECLARE connect_federated_fail CONDITION FOR 1296;
DECLARE error_reading_packet CONDITION FOR 1158;
DECLARE connect_federated_timeout CONDITION FOR 1159;
DECLARE write_packet_timeout CONDITION FOR 1160;
DECLARE CONTINUE HANDLER FOR connect_federated_fail, connect_federated_timeout,write_packet_timeout,error_reading_packet
BEGIN
IF counter=0 && new.catid<>186 THEN
IF new.state<> old.state AND new.state=0 THEN
DELETE FROM EVENT_AGENT_FAILED WHERE event= old.ev_id;
INSERT INTO EVENT_AGENT_FAILED(event, transactionType) values (new.ev_id, 'Cancelled');
ELSE
DELETE FROM EVENT_AGENT_FAILED WHERE event= old.ev_id;
INSERT INTO EVENT_AGENT_FAILED(event, transactionType) values (new.ev_id, 'Updated');
END IF;
END IF;
END;
SET counter=0;
IF new.catid<>186 THEN
IF new.state<> old.state AND new.state=0 THEN
DELETE FROM EVENT_AGENT_CLONE WHERE event= old.ev_id;
INSERT INTO EVENT_AGENT_CLONE(event, transactionType) values (new.ev_id, 'Cancelled');
SET counter=1;
ELSE
DELETE FROM EVENT_AGENT_CLONE WHERE event= old.ev_id;
INSERT INTO EVENT_AGENT_CLONE(event, transactionType) values (new.ev_id, 'Updated');
SET counter=1;
END IF;
END IF;
END | AFTER | NULL | | webjedi@localhost | utf8 | utf8_general_ci | latin1_swedish_ci |
| DELETE_EVENT_AGENT_CLONE_CAT | DELETE | uni12_jevents_vevent | BEGIN
DECLARE counter int;
DECLARE connect_federated_fail CONDITION FOR 1296;
DECLARE error_reading_packet CONDITION FOR 1158;
DECLARE connect_federated_timeout CONDITION FOR 1159;
DECLARE write_packet_timeout CONDITION FOR 1160;
DECLARE CONTINUE HANDLER FOR connect_federated_fail, connect_federated_timeout,write_packet_timeout,error_reading_packet
BEGIN
IF counter=0 THEN
DELETE FROM EVENT_AGENT_FAILED WHERE event= old.ev_id;
INSERT INTO EVENT_AGENT_FAILED(event, transactionType) values (old.ev_id, 'Cancelled');
END IF;
END;
SET counter=0;
DELETE FROM EVENT_AGENT_CLONE WHERE event= old.ev_id;
INSERT INTO EVENT_AGENT_CLONE(event, transactionType) values (old.ev_id, 'Cancelled');
SET counter=1;
END | AFTER | NULL | | webjedi@localhost | utf8 | utf8_general_ci | latin1_swedish_ci |
+------------------------------+--------+-------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+-----------------------+-------------------+----------------------+----------------------+--------------------+
I will check evdet_id tomorrow
Ok, from the trigger definition 'evdet_id' should be in EVENT_AGENT_CLONE and EVENT_AGENT_FAILED tables.
What would help is the trigger type and the table definition of EVENT_AGENT_CLONE.
What is the table schema on which this trigger happens.
See my comment that perhaps this is just:
You're error log contained the following.
150415 11:47:58 [Warning] WSREP: RBR event 1 Query apply warning: 1, 12193 150415 11:47:58 [Warning] WSREP: Ignoring error for TO isolated action: source: 9a0a95d2-e31f-11e4-aa21-736d6b84b38c version: 3 local: 0 state: APPLYING flags: 65 conn_id: 7069 trx_id: -1 seqnos (l: 2217, g: 12193, s: 12192, d: 12192, ts: 676552141153475) 150415 11:48:52 [ERROR] Slave SQL: Error 'Unknown column 'evdet_id' in 'NEW'' on query. Default database: 'comp2012db'. Query: 'CREATE DEFINER=`webjedi`@`10.224.202.171` TRIGGER `CREATE_` AFTER INSERT ON `agent` FOR EACH ROW BEGIN DECLARE counter int; DECLARE connect_federated_fail CONDITION FOR 1296; DECLARE error_reading_packet CONDITION FOR 1158; DECLARE connect_federated_timeout CONDITION FOR 1159; DECLARE write_packet_timeout CONDITION FOR 1160; DECLARE CONTINUE HANDLER FOR connect_federated_fail, connect_federated_timeout,write_packet_timeout,error_reading_packet BEGIN IF counter=0 THEN DELETE FROM MY_AGENT_FAILED WHERE event= new.event; INSERT INTO MY_AGENT_FAILED(event, transactionType) values (new.evdet_id, new.transactionType); END IF; END; SET counter = 0; DELETE FROM MY_AGENT_CLONE WHERE event= new.event; INSERT INTO MY_AGENT_CLONE (event, transactionType) values (new.evdet_id, new.transactionType); SET counter=1; END', Internal MariaDB error code:evdet_id -> event_id perhaps