===================================== 2016-09-08 09:36:18 7fe53d909700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 13 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 36910 srv_active, 0 srv_shutdown, 42987 srv_idle srv_master_thread log flush and writes: 79896 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 228127 --Thread 140617818597120 has waited at fts0fts.cc line 3540 for 945.00 seconds the semaphore: X-lock on RW-latch at 0x7fe46a52c268 '&cache->lock' a writer (thread id 140619066337024) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file /home/buildbot/buildbot/build/mariadb-10.0.27/storage/xtradb/fts/fts0fts.cc line 4538 --Thread 140619108300544 has waited at srv0srv.cc line 2721 for 943.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x145bc40 '&dict_operation_lock' a writer (thread id 140619108300544) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file fts0opt.cc line 2980 Last time write locked in file /home/buildbot/buildbot/build/mariadb-10.0.27/storage/xtradb/srv/srv0srv.cc line 2721 --Thread 140617824876288 has waited at row0mysql.cc line 1759 for 942.00 seconds the semaphore: S-lock on RW-latch at 0x145bc40 '&dict_operation_lock' a writer (thread id 140619108300544) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file fts0opt.cc line 2980 Last time write locked in file /home/buildbot/buildbot/build/mariadb-10.0.27/storage/xtradb/srv/srv0srv.cc line 2721 --Thread 140619099907840 has waited at row0purge.cc line 770 for 940.00 seconds the semaphore: S-lock on RW-latch at 0x145bc40 '&dict_operation_lock' a writer (thread id 140619108300544) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file fts0opt.cc line 2980 Last time write locked in file /home/buildbot/buildbot/build/mariadb-10.0.27/storage/xtradb/srv/srv0srv.cc line 2721 --Thread 140617809626880 has waited at row0ins.cc line 1819 for 922.00 seconds the semaphore: S-lock on RW-latch at 0x145bc40 '&dict_operation_lock' a writer (thread id 140619108300544) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file fts0opt.cc line 2980 Last time write locked in file /home/buildbot/buildbot/build/mariadb-10.0.27/storage/xtradb/srv/srv0srv.cc line 2721 --Thread 140622556526336 has waited at row0mysql.cc line 1759 for 920.00 seconds the semaphore: S-lock on RW-latch at 0x145bc40 '&dict_operation_lock' a writer (thread id 140619108300544) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file fts0opt.cc line 2980 Last time write locked in file /home/buildbot/buildbot/build/mariadb-10.0.27/storage/xtradb/srv/srv0srv.cc line 2721 --Thread 140619049551616 has waited at row0mysql.cc line 1759 for 916.00 seconds the semaphore: S-lock on RW-latch at 0x145bc40 '&dict_operation_lock' a writer (thread id 140619108300544) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file fts0opt.cc line 2980 Last time write locked in file /home/buildbot/buildbot/build/mariadb-10.0.27/storage/xtradb/srv/srv0srv.cc line 2721 --Thread 140617814411008 has waited at row0mysql.cc line 1759 for 890.00 seconds the semaphore: S-lock on RW-latch at 0x145bc40 '&dict_operation_lock' a writer (thread id 140619108300544) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file fts0opt.cc line 2980 Last time write locked in file /home/buildbot/buildbot/build/mariadb-10.0.27/storage/xtradb/srv/srv0srv.cc line 2721 --Thread 140619074729728 has waited at dict0stats.cc line 2394 for 883.00 seconds the semaphore: X-lock on RW-latch at 0x145bc40 '&dict_operation_lock' a writer (thread id 140619108300544) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file fts0opt.cc line 2980 Last time write locked in file /home/buildbot/buildbot/build/mariadb-10.0.27/storage/xtradb/srv/srv0srv.cc line 2721 --Thread 140617813513984 has waited at row0mysql.cc line 1759 for 883.00 seconds the semaphore: S-lock on RW-latch at 0x145bc40 '&dict_operation_lock' a writer (thread id 140619108300544) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file fts0opt.cc line 2980 Last time write locked in file /home/buildbot/buildbot/build/mariadb-10.0.27/storage/xtradb/srv/srv0srv.cc line 2721 --Thread 140624427214592 has waited at row0mysql.cc line 1759 for 880.00 seconds the semaphore: S-lock on RW-latch at 0x145bc40 '&dict_operation_lock' a writer (thread id 140619108300544) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file fts0opt.cc line 2980 Last time write locked in file /home/buildbot/buildbot/build/mariadb-10.0.27/storage/xtradb/srv/srv0srv.cc line 2721 OS WAIT ARRAY INFO: signal count 747419 Mutex spin waits 442837, rounds 561475, OS waits 5042 RW-shared spins 424262, rounds 7065282, OS waits 218701 RW-excl spins 51514, rounds 1070652, OS waits 3213 Spin rounds per wait: 1.27 mutex, 16.65 RW-shared, 20.78 RW-excl ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 2016-09-07 13:15:51 7fe73d458700 Transaction: TRANSACTION 1741390808, ACTIVE 0 sec inserting, thread declared inside InnoDB 5000 mysql tables in use 1, locked 1 3 lock struct(s), heap size 1184, 1 row lock(s), undo log entries 1 MySQL thread id 7, OS thread handle 0x7fe73d458700, query id 1671527 172.29.9.11 bobex update INSERT INTO T_PARTNERRFP (BUSINESSTYPE, DATESUBMISSION, DATECREATION, LANGUAGE, PROJECTDESC, MEMBER, ZIP, REGION, STATUS, AFFILIATE, TEMPLATE,BO_QUALITY, PROJECTNAME, ORIGINATOR, TEMPLATEVALUES,MATCH_PROSPECTS, ID) VALUES (-1, '2016-09-07 13:15:51.223', NOW(), 2, NULL, 540400,'4340',10,1,1,10420,NULL,NULL,NULL,_binary ' ',0,NULL) Foreign key constraint fails for table `bobex`.`t_partnerrfp`: , CONSTRAINT `FK_PARTNER_BUSINESSTYPE` FOREIGN KEY (`BUSINESSTYPE`) REFERENCES `t_business` (`ID`) Trying to add in child table, in index `NUI_PARTNERRFP_BUSTYPE_STATUS` tuple: DATA TUPLE: 4 fields; 0: len 8; hex 7fffffffffffffff; asc ;; 1: len 4; hex 80000001; asc ;; 2: len 8; hex 8000000000000002; asc ;; 3: len 8; hex 800000000050ed3c; asc P <;; But in parent table `bobex`.`t_business`, in index `PRIMARY`, the closest match we can find is record: PHYSICAL RECORD: n_fields 37; compact format; info bits 0 0: len 8; hex 8000000000000021; asc !;; 1: len 6; hex 0000521f32b4; asc R 2 ;; 2: len 7; hex 360000050920de; asc 6 ;; 3: len 22; hex 427573696e657373547970652e636f64652e63617273; asc BusinessType.code.cars;; 4: SQL NULL; 5: SQL NULL; 6: SQL NULL; 7: SQL NULL; 8: len 9; hex 686f6d655f63617273; asc home_cars;; 9: len 4; hex 7fffffff; asc ;; 10: len 4; hex 80000008; asc ;; 11: len 4; hex 80000001; asc ;; 12: SQL NULL; 13: len 8; hex 8000000000000002; asc ;; 14: len 22; hex 427573696e657373547970652e646573632e63617273; asc BusinessType.desc.cars;; 15: len 8; hex 000000000000f0bf; asc ;; 16: len 8; hex 000000000000f0bf; asc ;; 17: len 8; hex 80001245d451e5bb; asc E Q ;; 18: len 8; hex 0000000000003e40; asc >@;; 19: len 8; hex 0000000000c05240; asc R@;; 20: len 8; hex 0000000000004940; asc I@;; 21: SQL NULL; 22: len 4; hex 80000000; asc ;; 23: len 4; hex 80000000; asc ;; 24: len 4; hex 80000000; asc ;; 25: SQL NULL; 26: len 26; hex 427573696e657373547970652e627573696e6573732e63617273; asc BusinessType.business.cars;; 27: SQL NULL; 28: len 8; hex 8000000000000000; asc ;; 29: len 4; hex 80000000; asc ;; 30: SQL NULL; 31: len 4; hex 8000000a; asc ;; 32: SQL NULL; 33: SQL NULL; 34: SQL NULL; 35: len 4; hex 80000000; asc ;; 36: SQL NULL; ------------ TRANSACTIONS ------------ Trx id counter 1744925223 Purge done for trx's n:o < 1744910060 undo n:o < 0 state: running History list length 1794 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started sleeping before entering InnoDB mysql tables in use 4, locked 0 MySQL thread id 1521, OS thread handle 0x7fe42312b700, query id 10911003 172.29.9.10 bobex statistics SELECT T_PARTNERRFP.TEMPLATEVALUES,T_PARTNERRFP.SPECIAL_PAGE, T_PARTNERRFP.ID, T_PARTNERRFP.DATESUBMISSION, T_PARTNERRFP.DATECREATION, T_PARTNERRFP.LANGUAGE,T_PARTNERRFP.PROJECTDESC, T_PARTNERRFP.MEMBER, T_PARTNERRFP.ZIP, T_PARTNERRFP.REGION, T_PARTNERRFP.STATUS, T_PARTNERRFP.AFFILIATE, T_PARTNERRFP.TEMPLATE,T_PARTNERRFP.BO_QUALITY,T_PARTNERRFP.PROJECTNAME,T_PARTNERRFP.REJECT_REASON,T_PARTNERRFP.REJECT_EXTRA,T_PARTNERRFP.UTM_SOURCE,T_PARTNERRFP.UTM_MEDIUM,T_PARTNERRFP.UTM_CAMPAIGN,T_PARTNERRFP.UTM_TERM,T_PARTNERRFP.UTM_CONTENT,T_PARTNERRFP.REM_SOURCE,T_PARTNERRFP.REM_ID,T_PARTNERRFP.EXTRA_DESC ---TRANSACTION 0, not started sleeping before entering InnoDB mysql tables in use 4, locked 0 MySQL thread id 1513, OS thread handle 0x7fe423696700, query id 10910716 172.29.9.10 bobex statistics SELECT T_PARTNERRFP.TEMPLATEVALUES,T_PARTNERRFP.SPECIAL_PAGE, T_PARTNERRFP.ID, T_PARTNERRFP.DATESUBMISSION, T_PARTNERRFP.DATECREATION, T_PARTNERRFP.LANGUAGE,T_PARTNERRFP.PROJECTDESC, T_PARTNERRFP.MEMBER, T_PARTNERRFP.ZIP, T_PARTNERRFP.REGION, T_PARTNERRFP.STATUS, T_PARTNERRFP.AFFILIATE, T_PARTNERRFP.TEMPLATE,T_PARTNERRFP.BO_QUALITY,T_PARTNERRFP.PROJECTNAME,T_PARTNERRFP.REJECT_REASON,T_PARTNERRFP.REJECT_EXTRA,T_PARTNERRFP.UTM_SOURCE,T_PARTNERRFP.UTM_MEDIUM,T_PARTNERRFP.UTM_CAMPAIGN,T_PARTNERRFP.UTM_TERM,T_PARTNERRFP.UTM_CONTENT,T_PARTNERRFP.REM_SOURCE,T_PARTNERRFP.REM_ID,T_PARTNERRFP.EXTRA_DESC ---TRANSACTION 0, not started sleeping before entering InnoDB mysql tables in use 5, locked 0 MySQL thread id 1493, OS thread handle 0x7fe423895700, query id 10910329 172.29.9.11 bobex Sorting result select t_member.lastname,t_member.firstname,t_member.PREFERREDLANG,t_company.name,t_member.userref,t_todo.DUE_DATE,t_todo.userref, t_todo.TODO_TYPE, T_TODO.TODO_LEVEL,t_partnerrfp.ID, t_partnerrfp.status, t_partnerrfp.language, t_partnerrfp.affiliate, T_BUSINESS.TYPE, t_business.name from t_todo inner join t_member on t_todo.USERREF = t_member.userref inner join t_company on t_member.company = t_company.id left outer join t_partnerrfp on T_TODO.RFPID=t_partnerrfp.id left outer join T_BUSINESS on t_partnerrfp.businesstype=t_business.id where t_todo.status = -1 and t_todo.todo_type=1 and DAT ---TRANSACTION 0, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 MySQL thread id 1490, OS thread handle 0x7fe46c4d1700, query id 10910504 172.29.9.10 govex update INSERT INTO T_JOUE_FILE (NAME, DATE_UPLOAD, STATUS, NUMBER_RECORDS, LANGUAGE, ID) VALUES ('20160908_2016173.tar.gz', '2016-09-08 09:25:07.532', 1, 1530, 3, NULL) ---TRANSACTION 0, not started sleeping before entering InnoDB mysql tables in use 5, locked 0 MySQL thread id 1460, OS thread handle 0x7fe422f2c700, query id 10909769 172.29.9.10 govex Sorting result select t_member.lastname,t_member.firstname,t_member.PREFERREDLANG,t_company.name,t_member.userref,t_todo.DUE_DATE,t_todo.userref, t_todo.TODO_TYPE, T_TODO.TODO_LEVEL,t_partnerrfp.ID, t_partnerrfp.status, t_partnerrfp.language, t_partnerrfp.affiliate, T_BUSINESS.TYPE, t_business.name from t_todo inner join t_member on t_todo.USERREF = t_member.userref inner join t_company on t_member.company = t_company.id left outer join t_partnerrfp on T_TODO.RFPID=t_partnerrfp.id left outer join T_BUSINESS on t_partnerrfp.businesstype=t_business.id where t_todo.status = -1 and t_todo.todo_type=1 and DAT ---TRANSACTION 0, not started sleeping before entering InnoDB mysql tables in use 5, locked 0 MySQL thread id 1458, OS thread handle 0x7fe423edb700, query id 10909742 172.29.9.10 govex Sorting result select t_member.lastname,t_member.firstname,t_member.PREFERREDLANG,t_company.name,t_member.userref,t_todo.DUE_DATE,t_todo.userref, t_todo.TODO_TYPE, T_TODO.TODO_LEVEL,t_partnerrfp.ID, t_partnerrfp.status, t_partnerrfp.language, t_partnerrfp.affiliate, T_BUSINESS.TYPE, t_business.name from t_todo inner join t_member on t_todo.USERREF = t_member.userref inner join t_company on t_member.company = t_company.id left outer join t_partnerrfp on T_TODO.RFPID=t_partnerrfp.id left outer join T_BUSINESS on t_partnerrfp.businesstype=t_business.id where t_todo.status = -1 and t_todo.todo_type=1 and DAT ---TRANSACTION 0, not started sleeping before entering InnoDB mysql tables in use 5, locked 0 MySQL thread id 1444, OS thread handle 0x7fe47ff16700, query id 10909514 172.29.9.11 bobex Sorting result select t_member.lastname,t_member.firstname,t_member.PREFERREDLANG,t_company.name,t_member.userref,t_todo.DUE_DATE,t_todo.userref, t_todo.TODO_TYPE, T_TODO.TODO_LEVEL,t_partnerrfp.ID, t_partnerrfp.status, t_partnerrfp.language, t_partnerrfp.affiliate, T_BUSINESS.TYPE, t_business.name from t_todo inner join t_member on t_todo.USERREF = t_member.userref inner join t_company on t_member.company = t_company.id left outer join t_partnerrfp on T_TODO.RFPID=t_partnerrfp.id left outer join T_BUSINESS on t_partnerrfp.businesstype=t_business.id where t_todo.status = -1 and t_todo.todo_type=1 and DAT ---TRANSACTION 0, not started sleeping before entering InnoDB mysql tables in use 5, locked 0 MySQL thread id 1440, OS thread handle 0x7fe423728700, query id 10909496 172.29.9.11 bobex Sorting result select t_member.lastname,t_member.firstname,t_member.PREFERREDLANG,t_company.name,t_member.userref,t_todo.DUE_DATE,t_todo.userref, t_todo.TODO_TYPE, T_TODO.TODO_LEVEL,t_partnerrfp.ID, t_partnerrfp.status, t_partnerrfp.language, t_partnerrfp.affiliate, T_BUSINESS.TYPE, t_business.name from t_todo inner join t_member on t_todo.USERREF = t_member.userref inner join t_company on t_member.company = t_company.id left outer join t_partnerrfp on T_TODO.RFPID=t_partnerrfp.id left outer join T_BUSINESS on t_partnerrfp.businesstype=t_business.id where t_todo.status = -1 and t_todo.todo_type=1 and DAT ---TRANSACTION 0, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 MySQL thread id 1439, OS thread handle 0x7fe423d6e700, query id 10909365 172.29.9.11 bobex updating UPDATE T_USER SET ISACTIVE = -1, TIMELASTLOGIN = '2016-09-08 09:23:01.898', LOGINCOUNT = 0, REMOTE_IP = '108.171.128.189', TIMEPREVIOUSLOGIN = '2016-09-08 08:00:58', PREVIOUS_REMOTE_IP = '108.171.128.188' WHERE ID = 387576 ---TRANSACTION 0, not started sleeping before entering InnoDB mysql tables in use 5, locked 0 MySQL thread id 1429, OS thread handle 0x7fe53d952700, query id 10909097 172.29.9.11 bobex Sorting result select t_member.lastname,t_member.firstname,t_member.PREFERREDLANG,t_company.name,t_member.userref,t_todo.DUE_DATE,t_todo.userref, t_todo.TODO_TYPE, T_TODO.TODO_LEVEL,t_partnerrfp.ID, t_partnerrfp.status, t_partnerrfp.language, t_partnerrfp.affiliate, T_BUSINESS.TYPE, t_business.name from t_todo inner join t_member on t_todo.USERREF = t_member.userref inner join t_company on t_member.company = t_company.id left outer join t_partnerrfp on T_TODO.RFPID=t_partnerrfp.id left outer join T_BUSINESS on t_partnerrfp.businesstype=t_business.id where t_todo.status = -1 and t_todo.todo_type=1 and DAT ---TRANSACTION 0, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 MySQL thread id 1428, OS thread handle 0x7fe61c94f700, query id 10909092 172.29.9.11 bobex updating UPDATE T_USER SET ISACTIVE = -1, TIMELASTLOGIN = '2016-09-08 09:22:36.429', LOGINCOUNT = 0, REMOTE_IP = '108.171.128.189', TIMEPREVIOUSLOGIN = '2016-09-08 08:00:58', PREVIOUS_REMOTE_IP = '108.171.128.188' WHERE ID = 387576 ---TRANSACTION 1744911354, not started MySQL thread id 1405, OS thread handle 0x7fe53d909700, query id 10911335 85.234.217.234 root init show engine innodb status ---TRANSACTION 1744682439, not started MySQL thread id 1373, OS thread handle 0x7fe73c8c8700, query id 10911335 85.234.217.234 root cleaning up ---TRANSACTION 1744911108, not started sleeping before entering InnoDB mysql tables in use 1, locked 1 MySQL thread id 1337, OS thread handle 0x7fe422a53700, query id 10908861 172.29.9.11 govex updating UPDATE T_BDA SET TITLE = 'Licences SAP BUSINESS INTELLIGENCE pour les besoins du Centre d\'Informatique pour la Région Bruxelloise et de la Centrale de Marchés', BELGIUMONLY = 0, typeofmarket = 4, status = 1, typeofdoc = 2, typeofprocedure = 1, bda_id = 244468, parent_id = NULL, date_attributed = NULL, date_creation = '2016-09-08 08:29:46', date_dispatch = '2016-09-07 08:29:46', date_due = '2016-10-31 00:00:00', date_published = '2016-09-07 08:29:46', date_update = '2016-09-08 09:22:02.819', LANGUAGE = 5, authority = 'Centre d\'Informatique pour la Région Bruxelloise, Avenue des Arts, 21 ---TRANSACTION 0, not started MySQL thread id 33, OS thread handle 0x7fe5ad0c7700, query id 10911330 zenossc8h.cegeka.be 212.113.88.158 zenoss cleaning up ---TRANSACTION 0, not started MySQL thread id 32, OS thread handle 0x7fe5ad110700, query id 10911334 zenossc8h.cegeka.be 212.113.88.158 zenoss cleaning up ---TRANSACTION 0, not started MySQL thread id 31, OS thread handle 0x7fe61c874700, query id 10911332 zenossc8h.cegeka.be 212.113.88.158 zenoss cleaning up ---TRANSACTION 1744912141, ACTIVE 823 sec sleeping before entering InnoDB mysql tables in use 14, locked 0 MySQL thread id 1012, OS thread handle 0x7fe422e9a700, query id 10909054 172.29.9.10 brutrade statistics SELECT T_CLASSIFIED.ID, T_CLASSIFIED.CLASSIFIEDNAME, T_CLASSIFIED.CLASSIFIEDDESC, T_CLASSIFIED.PRICE, T_CLASSIFIED.CURRENCY, T_CLASSIFIED.MEMBER,T_CLASSIFIED.CREATIONDATE, T_CLASSIFIED.REMOVALDATE, T_CLASSIFIED.SUBMISSIONDATE, T_CLASSIFIED.EXPIRATIONDATE, T_CLASSIFIED.TYPE, T_CLASSIFIED.STATUS, T_CLASSIFIED.NUMBEROFVIEWS, T_CLASSIFIED.WEIGHTPRIORITY, T_CLASSIFIED.AFFILIATE, T_CLASSIFIED.CLASSIFIEDTYPE, T_CLASSIFIED.TEMPLATE, T_CLASSIFIED.TEMPLATEVALUES, T_CLASSIFIED.LANGUAGE, T_CLASSIFIED.PARENT, T_CLASSIFIED.EXT_REF, T_REGION.ID, T_REGION.NAME, T_REGION.STATUS, T_REGION.COUNTRY, T_REGION.SUP Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 1744912114, ACTIVE 864 sec sleeping before entering InnoDB mysql tables in use 3, locked 0 MySQL thread id 1298, OS thread handle 0x7fe68c0c0700, query id 10908761 172.29.9.11 bobex statistics SELECT T_BUSINESS.ID, T_BUSINESS.NAME, T_BUSINESS.TEMPLATE,T_BUSINESS.DESCRIPTION,T_BUSINESS.BUSINESS,T_BUSINESS.ACTION_CLASS, T_BUSINESS.MESSAGEBOARD, T_BUSINESS.PARENTTYPE, T_BUSINESS.TEMPLATEBID, T_BUSINESS.LEADPRICE_LOW, T_BUSINESS.LEADPRICE_HIGH, T_BUSINESS.DATEUPDATE, T_BUSINESS.BUYINGGUIDE, T_BUSINESS.ISPAYABLE, T_BUSINESS.STATUS, T_BUSINESS.TYPE, T_BUSINESS.MEMBER, T_BUSINESS.SUBSCRIPTION_CATEGORY,T_BUSINESS.PACKPRICE_LOW,T_BUSINESS.PACKPRICE_MEDIUM,T_BUSINESS.PACKPRICE_HIGH,T_BUSINESS.FEATURED,T_BUSINESS.BEST_OF,T_BUSINESS.POPULAR,T_BUSINESS.CATEGORY_TYPE,T_BUSINESS.RELATED_NAME,T_BUS Trx read view will not see trx with id >= 1744912115, sees < 1744909970 Trx #rec lock waits 1 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 1744912110, ACTIVE 880 sec updating or deleting, thread declared inside InnoDB 4999 mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 1420, OS thread handle 0x7fe5ad07e700, query id 10908708 172.29.9.11 bobex updating UPDATE T_PARTNERRFP SET BUSINESSTYPE = 30030 , DATESUBMISSION = '2016-09-07 17:30:15', LANGUAGE = 5,PROJECTDESC='///Yuri Projet pour mi-2017 surface de +/-80m² Toit neuf en tuiles Pour nouvelle maison en construction dans la commune de Romzée (liège)', MEMBER=542002, ZIP='4040', REGION=10, STATUS=1, AFFILIATE=138, TEMPLATE=14863,BO_QUALITY=NULL,PROJECTNAME='Devis pour panneaux photovoltaïques dans',TEMPLATEVALUES = _binary ' Projet pour mi-2017
surface de Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 1744912059, ACTIVE 883 sec updating or deleting, thread declared inside InnoDB 4999 mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 1393, OS thread handle 0x7fe422d2d700, query id 10908566 172.29.9.11 bobex updating UPDATE T_USER SET ISACTIVE = -1, TIMELASTLOGIN = '2016-09-08 09:21:35.724', LOGINCOUNT = 0, REMOTE_IP = '108.171.128.189', TIMEPREVIOUSLOGIN = '2016-09-08 08:00:58', PREVIOUS_REMOTE_IP = '108.171.128.188' WHERE ID = 387576 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 1744911564, ACTIVE 890 sec updating or deleting, thread declared inside InnoDB 4999 mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 1147, OS thread handle 0x7fe422e08700, query id 10907650 172.29.9.11 brutrade updating update t_classified set numberofviews = numberofviews+1 where id=55046 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 1744911201, ACTIVE 916 sec updating or deleting, thread declared inside InnoDB 4999 mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 1391, OS thread handle 0x7fe46c7f4700, query id 10906517 172.29.9.11 bobex updating UPDATE T_PARTNERRFP SET BUSINESSTYPE = 30003 , DATESUBMISSION = '2016-09-07 23:08:42', LANGUAGE = 2,PROJECTDESC='Ik zou de spouw van mijn prive willen laten isoleren. Vrijstaand huis van 1977, diepte spouw onbekend, spouw is er wel, gevels niet bewerkt, opp. rond de 100m².', MEMBER=542060, ZIP='9820', REGION=2, STATUS=1, AFFILIATE=139, TEMPLATE=15948,BO_QUALITY=25,PROJECTNAME='Spouwmuurisolatie voor de regio Merelbeke',TEMPLATEVALUES = _binary '