=====================================
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 '