gistfile1.txt

mysql> show triggers IN sentact_sbch LIKE 'user%'\G
*************************** 1. row ***************************
             Trigger: log_user_insert
               Event: INSERT
               Table: users
           Statement: CALL update_transaction_log('users',NEW.id,'insert')
              Timing: AFTER
             Created: NULL
            sql_mode: 
             Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
  Database Collation: utf8_general_ci
*************************** 2. row ***************************
             Trigger: log_user_update
               Event: UPDATE
               Table: users
           Statement: CALL update_transaction_log('users',NEW.id,'update')
              Timing: AFTER
             Created: NULL
            sql_mode: 
             Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
  Database Collation: utf8_general_ci
*************************** 3. row ***************************
             Trigger: log_user_delete
               Event: DELETE
               Table: users
           Statement: CALL update_transaction_log('users',OLD.id,'delete')
              Timing: BEFORE
             Created: NULL
            sql_mode: 
             Definer: sentact_sbch@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
  Database Collation: utf8_general_ci
3 rows in set (0.01 sec)

gistfile2.txt

mysql> select * from ROUTINES where routine_name = 'update_transaction_log'\G
*************************** 1. row ***************************
       SPECIFIC_NAME: update_transaction_log
     ROUTINE_CATALOG: NULL
      ROUTINE_SCHEMA: sentact_sbch
        ROUTINE_NAME: update_transaction_log
        ROUTINE_TYPE: PROCEDURE
      DTD_IDENTIFIER: NULL
        ROUTINE_BODY: SQL
  ROUTINE_DEFINITION: BEGIN
   DELETE FROM transaction_log WHERE table_name = t AND record_id = r;
   INSERT INTO transaction_log(time,table_name,record_id,action) VALUES(NOW(),t,r,a);
END
       EXTERNAL_NAME: NULL
   EXTERNAL_LANGUAGE: NULL
     PARAMETER_STYLE: SQL
    IS_DETERMINISTIC: NO
     SQL_DATA_ACCESS: CONTAINS SQL
            SQL_PATH: NULL
       SECURITY_TYPE: DEFINER
             CREATED: 2009-05-27 23:44:35
        LAST_ALTERED: 2009-05-27 23:44:35
            SQL_MODE: 
     ROUTINE_COMMENT: 
             DEFINER: dabdemoulaie@localhost
CHARACTER_SET_CLIENT: utf8
COLLATION_CONNECTION: utf8_general_ci
  DATABASE_COLLATION: utf8_general_ci
1 row in set (0.00 sec)

gistfile3.txt

mysql> show create table sentact_sbch.transaction_log\G
*************************** 1. row ***************************
       Table: transaction_log
Create Table: CREATE TABLE `transaction_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `table_name` varchar(255) NOT NULL,
  `record_id` int(11) NOT NULL,
  `action` enum('insert','update','delete') NOT NULL DEFAULT 'insert',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=240284 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

gistfile4.sql

# at 895589273
#090706 12:00:08 server id 1  end_log_pos 895589478     Query   thread_id=1819319       exec_time=0     error_code=1142
use sentact_sbch/*!*/;
SET TIMESTAMP=1246906808/*!*/;
SET @@session.pseudo_thread_id=1819319/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=3, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
UPDATE users SET last_login = '2009-07-06 12:00:08', failed_login_count = 0, reset_code = NULL WHERE username = '[email protected]'
/*!*/;

gistfile5.txt

Query caused different errors on master and slave.     Error on master: '%-.16s command denied to user '%-.48s'@'%-.64s' for table '%-.192s'' (1142), Error on slave: 'no error' (0).