TABLE LOCK table `mkbase/b_stat_day_site` trx id 0 14584852 lock mode IX Record lock, heap no 8 PHYSICAL RECORD: n_fields 335 compact format info bits 0 RECORD LOCKS space id 0 page no 819230 n bits 80 index `PRIMARY` of table `mkbase/b_stat_day` trx id 0 14584852 lock_mode X locks rec but not gap RECORD LOCKS space id 0 page no 819218 n bits 192 index `IX_DATE_STAT` of table `mkbase/b_stat_day` trx id 0 14584852 lock_mode X locks rec but not gap TABLE LOCK table `mkbase/b_stat_day` trx id 0 14584852 lock mode IX TABLE LOCK table `mkbase/b_stat_hit` trx id 0 14584852 lock mode IX Record lock, heap no 44 PHYSICAL RECORD: n_fields 36 compact format info bits 0 RECORD LOCKS space id 0 page no 1196047 n bits 112 index `PRIMARY` of table `mkbase/b_stat_session` trx id 0 14584852 lock_mode X locks rec but not gap TABLE LOCK table `mkbase/b_stat_session` trx id 0 14584852 lock mode IX TABLE LOCK table `mkbase/b_stat_session` trx id 0 14585003 lock mode IX TABLE LOCK table `mkbase/b_stat_day` trx id 0 14820073 lock mode IX RECORD LOCKS space id 0 page no 819218 n bits 192 index `IX_DATE_STAT` of table `mkbase/b_stat_day` trx id 0 14820073 lock_mode X locks rec but not gap waiting TRX HAS BEEN WAITING 44 SEC FOR THIS LOCK TO BE GRANTED: TRANSACTION 0 14820073, ACTIVE 44 sec, process no 6728, OS thread id 1170418000 starting index read TABLE LOCK table `mkbase/b_stat_day` trx id 0 14820078 lock mode IX Record lock, heap no 123 PHYSICAL RECORD: n_fields 2 compact format info bits 0Ġ: len 3 hex 8fb26b asc k 1: len 007a asc z RECORD LOCKS space id 0 page no 819218 n bits 192 index `IX_DATE_STAT` of table `mkbase/b_stat_day` trx id 0 14820078 lock_mode X locks rec but not gap waiting TRX HAS BEEN WAITING 4 SEC FOR THIS LOCK TO BE GRANTED:
#Wordpress mysql deadlock update#
UPDATE b_stat_day SET HITS = HITS + 1, FAVORITES = FAVORITES + 0, HOUR_HIT_14 = HOUR_HIT_14 + 1, WEEKDAY_HIT_3 = WEEKDAY_HIT_3 + 1, MONTH_HIT_3 = MONTH_HIT_3 + 1, HOUR_FAVORITE_14 = HOUR_FAVORITE_14 + 0, WEEKDAY_FAVORITE_3 = WEEKDAY_FAVORITE_3 + 0, MONTH_FAVORITE_3 = MONTH_FAVORITE_3 + 0 WHERE DATE_STAT = CURRENT_DATE LOCK WAIT 2 lock struct(s), heap size 368 TRANSACTION 0 14820078, ACTIVE 4 sec, process no 6728, OS thread id 1084111184 starting index read MySQL thread id 5418, query id 10532525 localhost root TRANSACTION 0 0, not started, process no 6728, OS thread id 1183025488 Total number of lock structs in row lock hash table 16 Purge done for trx's n:o < 0 14820077 undo n:o < 0 0 RECORD LOCKS space id 0 page no 461340 n bits 608 index `UX_IBLOCK_SECTION_ELEMENT2` of table `mkbase/b_iblock_section_element` trx id 0 14548939 lock_mode X insert intention waiting *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 461340 n bits 608 index `UX_IBLOCK_SECTION_ELEMENT2` of table `mkbase/b_iblock_section_element` trx id 0 14548939 lock_mode X INSERT INTO b_iblock_section_element(IBLOCK_SECTION_ID, IBLOCK_ELEMENT_ID) SELECT S.ID, E.ID FROM b_iblock_section S, b_iblock_element E WHERE S.IBLOCK_ID=E.IBLOCK_ID AND S.ID IN (0,31,32) AND E.ID = 236082 TRANSACTION 0 14548939, ACTIVE 31 sec, process no 6728, OS thread id 1187227984 inserting, thread declared inside InnoDB 500ġ8 lock struct(s), heap size 3024, undo log entries 27 Record lock, heap no 1 PHYSICAL RECORD: n_fields 1 compact format info bits 0Ġ: len 7072656d756d asc supremum RECORD LOCKS space id 0 page no 461340 n bits 608 index `UX_IBLOCK_SECTION_ELEMENT2` of table `mkbase/b_iblock_section_element` trx id 0 14541775 lock_mode X insert intention waiting *** (1) WAITING FOR THIS LOCK TO BE GRANTED: INSERT INTO b_iblock_section_element(IBLOCK_SECTION_ID, IBLOCK_ELEMENT_ID) SELECT S.ID, E.ID FROM b_iblock_section S, b_iblock_element E WHERE S.IBLOCK_ID=E.IBLOCK_ID AND S.ID IN (0,39,38) AND E.ID = 236080 LOCK WAIT 19 lock struct(s), heap size 3024, undo log entries 25 How is deadlock on insert in b_iblock_section_element table linked to updates of our statistical tables (b_stat_day.)?
Periodically the whole web site is hunging with error on update statistical tables. We are using Mysql with Web apache/php application.
0 kommentar(er)
