+------+-------------+----------------------+------------------+---------+--------+--------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +------+-------------+----------------------+------------------+---------+--------+--------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ | 3 | system user | | | Connect | 153707 | Waiting for work from SQL thread | | 0.000 | | 4 | system user | | | Connect | 153707 | Waiting for work from SQL thread | | 0.000 | | 5 | system user | | | Connect | 153707 | Waiting for work from SQL thread | | 0.000 | | 6 | system user | | | Connect | 153707 | Waiting for master to send event | | 0.000 | | 7 | system user | | | Connect | 153707 | Waiting for work from SQL thread | | 0.000 | | 8 | system user | | | Connect | 153707 | Waiting for work from SQL thread | | 0.000 | | 9 | system user | | | Connect | 153707 | Waiting for work from SQL thread | | 0.000 | | 10 | SymmetricDS | 127.0.0.1 | replication_info | Connect | 153617 | Filling schema table | insert into `replication_info`.sym_data (table_name, event_type, trigger_hist_id, row_data, channel_id, transaction_id, source_node_id, external_data, create_time) values( 'jobdata', 'I', 32, concat( if(new.`OID` is null,'',concat('"',cast(new.`OID` as char),'"')),',', if(new.`IDJOB` is null,'',concat('"',cast(new.`IDJOB` as char),'"')),',', if(new.`IDATTR` is null,'',concat('"',cast(new.`IDATTR` as char),'"')),',', if(new.`SIDE` is null,'',concat('"',replace(replace(new.`SIDE`,'\\','\\\\'),'"','\\"'),'"')),',', if(new.`VALUE` is null,'',concat('"',replace(replace(new.`VALUE`,'\\','\\\\'),'"','\\"'),'"')),',', if(new.`BIGVALUE` is null,'',concat('"',replace(replace(new.`BIGVALUE`,'\\','\\\\'),'"','\\"'),'"')),',', if(new.`OptimisticLockField` is null,'',concat('"',cast(new.`OptimisticLockField` as char),'"')),',', if(new.`GCRecord` is null,'',concat('"',cast(new.`GCRecord` as char),'"')),',', if(new.`DVALUE` is null,'',concat('"',cast(new.`DVALUE` as char),'"')) ), 'default', `replication_info`.sym_transaction_id_post_5_1_23(), @sync_node_disabled, (select c.KDLKZ from optovision.cusd001 c join optovision.jobhead h on new.IDJOB = h.OID where c.A_KDNR = h.colACCN), CURRENT_TIMESTAMP ) | 0.000 | | 11 | system user | | | Connect | 153617 | Waiting for prior transaction to start commit before starting next transaction | | 0.000 | | 12 | system user | | | Connect | 153707 | Waiting for work from SQL thread | | 0.000 | | 13 | system user | | | Connect | 153707 | Waiting for work from SQL thread | | 0.000 | | 14 | system user | | | Connect | 153617 | Waiting for prior transaction to start commit before starting next transaction | | 0.000 | | 15 | system user | | | Connect | 153617 | Waiting for prior transaction to start commit before starting next transaction | | 0.000 | | 16 | system user | | | Connect | 153707 | Waiting for room in worker thread event queue | | 0.000 | | 23 | naegele | localhost | | Query | 153617 | Killing slave | stop slave | 0.000 | | 24 | naegele | 172.16.184.22:50047 | | Query | 153594 | Filling schema table | SHOW STATUS | 0.000 | | 36 | SymmetricDS | 127.0.0.1:40653 | replication_info | Killed | 153052 | Filling schema table | insert into `replication_info`.sym_data (table_name, event_type, trigger_hist_id, pk_data, row_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time) values( 'sym_node_host', 'U', 24, concat( if(old.`node_id` is null,'',concat('"',replace(replace(old.`node_id`,'\\','\\\\'),'"','\\"'),'"')),',', if(old.`host_name` is null,'',concat('"',replace(replace(old.`host_name`,'\\','\\\\'),'"','\\"'),'"')) ), NAME_CONST('var_row_data',_utf8'\"000\",\"localhost.localdomain\",\"172.16.187.101\",\"root\",\"Linux\",\"amd64\",\"3.10.0-327.13.1.el7.x86_64\",\"4\",\"189771032\",\"266862592\",\"266862592\",\"1.8.0_77\",\"Oracle Corporation\",\"mysql-connector-java-5.1.30 ( Revision: alexander.soklakov@oracle.com-20140310090514-8xt1yoht5ksg2e7c )\",\"3.7.20\",\"+02:00\",\"2016-04-11 14:46:09\",\"2016-04-08 18:17:11\",\"2016-04-07 12:05:29\"' COLLATE 'utf8_general_ci'), NAME_CONST('var_old_data',NULL), 'heartbeat', `replication_info`.sym_transaction_id_post_5_1_23(), @sync_node_disabled, null, CURRENT_TIMESTAMP ) | 0.000 | | 514 | nagios | 192.168.184.23:37803 | | Query | 134217 | init | SHOW SLAVE STATUS | 0.000 | | 2705 | nagios | 192.168.184.23:46329 | | Query | 47816 | init | SHOW SLAVE STATUS | 0.000 | | 3906 | naegele | 172.16.184.22:53605 | | Query | 561 | Filling schema table | SHOW STATUS | 0.000 | | 3915 | SymmetricDS | 127.0.0.1:43791 | replication_info | Sleep | 37 | | | 0.000 | | 3917 | SymmetricDS | 127.0.0.1:43793 | replication_info | Sleep | 58 | | | 0.000 | | 3918 | SymmetricDS | 127.0.0.1:43794 | replication_info | Sleep | 58 | | | 0.000 | | 3919 | SymmetricDS | 127.0.0.1:43795 | replication_info | Sleep | 1 | | | 0.000 | | 3922 | SymmetricDS | 127.0.0.1:43796 | replication_info | Sleep | 2 | | | 0.000 | | 3923 | naegele | localhost | | Query | 0 | init | show full processlist | 0.000 | +------+-------------+----------------------+------------------+---------+--------+--------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+