*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 110816 11:51:03 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 28 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 702392 1_second, 692841 sleeps, 67456 10_second, 56782 background, 56781 flush srv_master_thread log flush and writes: 696477 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 338790, signal count 1974258 Mutex spin waits 13886602, rounds 17122589, OS waits 233244 RW-shared spins 539203, OS waits 86720; RW-excl spins 68888, OS waits 17718 Spin rounds per wait: 1.23 mutex, 6.33 RW-shared, 30.68 RW-excl ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 110801 15:47:06 Transaction: TRANSACTION 2F6CF, ACTIVE 0 sec, process no 5325, OS thread id 1232783680 updating or deleting, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 4 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 1 MySQL thread id 4151839, query id 15032309 172.23.113.21 ask updating delete from ask_question where id=10 Foreign key constraint fails for table `ask`.`ask_answer`: , CONSTRAINT `FK_ASK_ANSWER` FOREIGN KEY (`quest_id`) REFERENCES `ask_question` (`id`) Trying to delete or update in parent table, in index `PRIMARY` tuple: DATA TUPLE: 12 fields; 0: len 8; hex 800000000000000a; asc ;; 1: len 6; hex 00000002f6cf; asc ;; 2: len 7; hex 000000002d0110; asc - ;; 3: len 18; hex 544f50e695b0e68daee69fa5e8afa2efbc9f; asc TOP ;; 4: SQL NULL; 5: len 1; hex 81; asc ;; 6: SQL NULL; 7: len 8; hex 8000124a637f8b71; asc Jc q;; 8: len 6; hex e5bda4e890b1; asc ;; 9: len 4; hex 80000008; asc ;; 10: len 8; hex 8000000000000010; asc ;; 11: len 8; hex 8000124a64bec21f; asc Jd ;; But in child table `ask`.`ask_answer`, in index `FK_ASK_ANSWER`, there is a record: PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 8; hex 800000000000000a; asc ;; 1: len 8; hex 8000000000000005; asc ;; ------------------------ LATEST DETECTED DEADLOCK ------------------------ 110805 4:06:09 *** (1) TRANSACTION: TRANSACTION 56F5B, ACTIVE 8 sec, process no 5325, OS thread id 1235179840 inserting mysql tables in use 1, locked 1 LOCK WAIT 1329 lock struct(s), heap size 162232, 303636 row lock(s), undo log entries 237 MySQL thread id 4456815, query id 19076201 172.24.113.136 cheetah update insert into meta_column(table_id,name,type,idx,description) values(34917,'auction_id','bigint',0,'') *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 177 page no 38 n bits 128 index `PRIMARY` of table `magicloud`.`meta_table` trx id 56F5B lock mode S locks rec but not gap waiting Record lock, heap no 49 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008865; asc e;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9509ac; asc ;; 3: len 27; hex 746d705f636169715f78756e6469616e303530345f726566756e64; asc tmp_caiq_xundian0504_refund;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e98787e790bc; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3235373734; asc 25774;; 10: len 29; hex 746d705f636169715f78756e6469616e303530345f6175636272616e64; asc tmp_caiq_xundian0504_aucbrand;; 11: len 5; hex 3235373734; asc 25774;; 12: len 30; hex 735f61756374696f6e5f61756374696f6e732c735f63726d5f726566756e; asc s_auction_auctions,s_crm_refun; (total 77 bytes); 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000001; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 57 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 7; hex 3231322e31354d; asc 212.15M;; 20: len 15; hex 45544ce8aea1e7ae97e68980e5be97; asc ETL ;; *** (2) TRANSACTION: TRANSACTION 56F5D, ACTIVE 5 sec, process no 5325, OS thread id 1234913600 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 461 lock struct(s), heap size 47544, 27735 row lock(s), undo log entries 10471 MySQL thread id 4456818, query id 19083183 172.24.113.136 cheetah Updating update meta_table set partition_path='hdfs://hdpnn:9000/group/taobao/taobao/hive/m_group_changed_detail' where name='m_group_changed_detail' *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 177 page no 38 n bits 128 index `PRIMARY` of table `magicloud`.`meta_table` trx id 56F5D lock_mode X locks rec but not gap Record lock, heap no 5 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008838; asc 8;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a1316; asc ;; 3: len 20; hex 746d705f636169715f68756f795f616c6c617563; asc tmp_caiq_huoy_allauc;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 0; hex ; asc ;; 8: len 4; hex 80000000; asc ;; 9: len 0; hex ; asc ;; 10: len 0; hex ; asc ;; 11: len 0; hex ; asc ;; 12: len 0; hex ; asc ;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; Record lock, heap no 6 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008839; asc 9;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a14ba; asc ;; 3: len 23; hex 746d705f636169715f68756f795f617563616c69637572; asc tmp_caiq_huoy_aucalicur;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3233333034; asc 23304;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 8; hex 6e6f746578697374; asc notexist;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 53 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 392e313447; asc 9.14G;; 20: len 18; hex 637265617465207461626c65e8a385e8bdbd; asc create table ;; Record lock, heap no 7 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000883a; asc :;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a149c; asc ;; 3: len 25; hex 746d705f636169715f68756f795f617563616c696d6f6e7468; asc tmp_caiq_huoy_aucalimonth;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 0; hex ; asc ;; 8: len 4; hex 80000000; asc ;; 9: len 0; hex ; asc ;; 10: len 0; hex ; asc ;; 11: len 0; hex ; asc ;; 12: len 0; hex ; asc ;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; Record lock, heap no 8 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000883b; asc ;;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a1460; asc `;; 3: len 23; hex 746d705f636169715f68756f795f617563616c6974776f; asc tmp_caiq_huoy_aucalitwo;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3233333034; asc 23304;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 8; hex 6e6f746578697374; asc notexist;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 53 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 382e383947; asc 8.89G;; 20: len 18; hex 637265617465207461626c65e8a385e8bdbd; asc create table ;; Record lock, heap no 9 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000883c; asc <;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a156e; asc n;; 3: len 22; hex 746d705f636169715f68756f795f617563636c656172; asc tmp_caiq_huoy_aucclear;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 0; hex ; asc ;; 8: len 4; hex 80000000; asc ;; 9: len 0; hex ; asc ;; 10: len 0; hex ; asc ;; 11: len 0; hex ; asc ;; 12: len 0; hex ; asc ;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; Record lock, heap no 10 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000883d; asc =;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000aa722ca; asc " ;; 3: len 26; hex 746d705f636169715f68756f795f617563636f6c6c6563746f72; asc tmp_caiq_huoy_auccollector;; 4: SQL NULL; 5: SQL NULL; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3233333034; asc 23304;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 8; hex 6e6f746578697374; asc notexist;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 56 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 362e303947; asc 6.09G;; 20: len 18; hex 637265617465207461626c65e8a385e8bdbd; asc create table ;; Record lock, heap no 11 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000883e; asc >;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a1424; asc $;; 3: len 23; hex 746d705f636169715f68756f795f6175636c69756c616e; asc tmp_caiq_huoy_aucliulan;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3233333034; asc 23304;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 8; hex 6e6f746578697374; asc notexist;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 53 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 6; hex 31302e303247; asc 10.02G;; 20: len 18; hex 637265617465207461626c65e8a385e8bdbd; asc create table ;; Record lock, heap no 12 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000883f; asc ?;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000aa721f8; asc ! ;; 3: len 24; hex 746d705f636169715f68756f795f61756370766d6f6e7468; asc tmp_caiq_huoy_aucpvmonth;; 4: SQL NULL; 5: SQL NULL; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3233333034; asc 23304;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 8; hex 6e6f746578697374; asc notexist;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 54 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 312e363447; asc 1.64G;; 20: len 18; hex 637265617465207461626c65e8a385e8bdbd; asc create table ;; Record lock, heap no 13 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008840; asc @;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000aa721da; asc ! ;; 3: len 22; hex 746d705f636169715f68756f795f617563757674776f; asc tmp_caiq_huoy_aucuvtwo;; 4: SQL NULL; 5: SQL NULL; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3233333034; asc 23304;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 8; hex 6e6f746578697374; asc notexist;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 52 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 312e303247; asc 1.02G;; 20: len 18; hex 637265617465207461626c65e8a385e8bdbd; asc create table ;; Record lock, heap no 14 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008841; asc A;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000aa721bc; asc ! ;; 3: len 21; hex 746d705f636169715f68756f795f636f6c736f6c64; asc tmp_caiq_huoy_colsold;; 4: SQL NULL; 5: SQL NULL; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3233333034; asc 23304;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 8; hex 6e6f746578697374; asc notexist;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 51 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 352e313347; asc 5.13G;; 20: len 18; hex 637265617465207461626c65e8a385e8bdbd; asc create table ;; Record lock, heap no 15 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008842; asc B;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a147e; asc ~;; 3: len 19; hex 746d705f636169715f68756f795f6d6f6e7468; asc tmp_caiq_huoy_month;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 0; hex ; asc ;; 8: len 4; hex 80000000; asc ;; 9: len 0; hex ; asc ;; 10: len 0; hex ; asc ;; 11: len 0; hex ; asc ;; 12: len 0; hex ; asc ;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; Record lock, heap no 16 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008843; asc C;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000aa72216; asc " ;; 3: len 26; hex 746d705f636169715f68756f795f73656c6c6572616c69636e74; asc tmp_caiq_huoy_selleralicnt;; 4: SQL NULL; 5: SQL NULL; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3233333034; asc 23304;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 8; hex 6e6f746578697374; asc notexist;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 56 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 392e32364d; asc 9.26M;; 20: len 18; hex 637265617465207461626c65e8a385e8bdbd; asc create table ;; Record lock, heap no 17 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008844; asc D;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000aa72252; asc "R;; 3: len 27; hex 746d705f636169715f68756f795f73656c6c6572616c69696e666f; asc tmp_caiq_huoy_selleraliinfo;; 4: SQL NULL; 5: SQL NULL; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3233333034; asc 23304;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 8; hex 6e6f746578697374; asc notexist;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 57 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 362e313147; asc 6.11G;; 20: len 18; hex 637265617465207461626c65e8a385e8bdbd; asc create table ;; Record lock, heap no 18 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008845; asc E;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a14d8; asc ;; 3: len 29; hex 746d705f636169715f68756f795f73656c6c65726261736963696e666f; asc tmp_caiq_huoy_sellerbasicinfo;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3233333034; asc 23304;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 8; hex 6e6f746578697374; asc notexist;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 59 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 362e303847; asc 6.08G;; 20: len 18; hex 637265617465207461626c65e8a385e8bdbd; asc create table ;; Record lock, heap no 19 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008846; asc F;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000aa72234; asc "4;; 3: len 26; hex 746d705f636169715f68756f795f73656c6c6572627579636e74; asc tmp_caiq_huoy_sellerbuycnt;; 4: SQL NULL; 5: SQL NULL; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3233333034; asc 23304;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 8; hex 6e6f746578697374; asc notexist;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 56 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 382e39324d; asc 8.92M;; 20: len 18; hex 637265617465207461626c65e8a385e8bdbd; asc create table ;; Record lock, heap no 20 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008847; asc G;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a14f6; asc ;; 3: len 24; hex 746d705f636169715f68756f795f73656c6c657266656564; asc tmp_caiq_huoy_sellerfeed;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 0; hex ; asc ;; 8: len 4; hex 80000000; asc ;; 9: len 0; hex ; asc ;; 10: len 0; hex ; asc ;; 11: len 0; hex ; asc ;; 12: len 0; hex ; asc ;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; Record lock, heap no 21 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008848; asc H;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000aa72270; asc "p;; 3: len 28; hex 746d705f636169715f68756f795f73656c6c6572676f6f6466656564; asc tmp_caiq_huoy_sellergoodfeed;; 4: SQL NULL; 5: SQL NULL; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3233333034; asc 23304;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 8; hex 6e6f746578697374; asc notexist;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 58 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 362e313547; asc 6.15G;; 20: len 18; hex 637265617465207461626c65e8a385e8bdbd; asc create table ;; Record lock, heap no 22 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008849; asc I;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a1532; asc 2;; 3: len 26; hex 746d705f636169715f68756f795f73656c6c657270756e697368; asc tmp_caiq_huoy_sellerpunish;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3233333034; asc 23304;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 8; hex 6e6f746578697374; asc notexist;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 56 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 6; hex 3230382e384b; asc 208.8K;; 20: len 18; hex 637265617465207461626c65e8a385e8bdbd; asc create table ;; Record lock, heap no 23 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000884a; asc J;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a1550; asc P;; 3: len 30; hex 746d705f636169715f68756f795f73656c6c657270756e697368696e666f; asc tmp_caiq_huoy_sellerpunishinfo;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 0; hex ; asc ;; 8: len 4; hex 80000000; asc ;; 9: len 0; hex ; asc ;; 10: len 0; hex ; asc ;; 11: len 0; hex ; asc ;; 12: len 0; hex ; asc ;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; Record lock, heap no 24 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000884b; asc K;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000aa7228e; asc " ;; 3: len 30; hex 746d705f636169715f68756f795f73656c6c657270756e697368696e666f; asc tmp_caiq_huoy_sellerpunishinfo; (total 31 bytes); 4: SQL NULL; 5: SQL NULL; 6: SQL NULL; 7: len 0; hex ; asc ;; 8: len 4; hex 80000000; asc ;; 9: len 0; hex ; asc ;; 10: len 0; hex ; asc ;; 11: len 0; hex ; asc ;; 12: len 0; hex ; asc ;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; Record lock, heap no 25 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000884c; asc L;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000aa722ac; asc " ;; 3: len 30; hex 746d705f636169715f68756f795f73656c6c657270756e697368696e666f; asc tmp_caiq_huoy_sellerpunishinfo; (total 31 bytes); 4: SQL NULL; 5: SQL NULL; 6: SQL NULL; 7: len 0; hex ; asc ;; 8: len 4; hex 80000000; asc ;; 9: len 0; hex ; asc ;; 10: len 0; hex ; asc ;; 11: len 0; hex ; asc ;; 12: len 0; hex ; asc ;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; Record lock, heap no 26 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000884d; asc M;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a1514; asc ;; 3: len 26; hex 746d705f636169715f68756f795f73656c6c657272657475726e; asc tmp_caiq_huoy_sellerreturn;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3233333034; asc 23304;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 8; hex 6e6f746578697374; asc notexist;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 56 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 352e32314d; asc 5.21M;; 20: len 18; hex 637265617465207461626c65e8a385e8bdbd; asc create table ;; Record lock, heap no 27 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000884e; asc N;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a1442; asc B;; 3: len 17; hex 746d705f636169715f68756f795f74776f; asc tmp_caiq_huoy_two;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 0; hex ; asc ;; 8: len 4; hex 80000000; asc ;; 9: len 0; hex ; asc ;; 10: len 0; hex ; asc ;; 11: len 0; hex ; asc ;; 12: len 0; hex ; asc ;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; Record lock, heap no 28 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000884f; asc O;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a1406; asc ;; 3: len 23; hex 746d705f636169715f68756f795f757670766d6f6e7468; asc tmp_caiq_huoy_uvpvmonth;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 0; hex ; asc ;; 8: len 4; hex 80000000; asc ;; 9: len 0; hex ; asc ;; 10: len 0; hex ; asc ;; 11: len 0; hex ; asc ;; 12: len 0; hex ; asc ;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; Record lock, heap no 29 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008850; asc P;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a13ca; asc ;; 3: len 21; hex 746d705f636169715f68756f795f7576707674776f; asc tmp_caiq_huoy_uvpvtwo;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 0; hex ; asc ;; 8: len 4; hex 80000000; asc ;; 9: len 0; hex ; asc ;; 10: len 0; hex ; asc ;; 11: len 0; hex ; asc ;; 12: len 0; hex ; asc ;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; Record lock, heap no 30 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008851; asc Q;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a138e; asc ;; 3: len 20; hex 746d705f636169715f6b7779645f616c69706179; asc tmp_caiq_kwyd_alipay;; 4: SQL NULL; 5: len 8; hex 800000000000000e; asc ;; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3138333539; asc 18359;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 5; hex 3138333539; asc 18359;; 12: len 30; hex 6d5f7061795f6869735f7072652c735f626d775f75736572735f64656c74; asc m_pay_his_pre,s_bmw_users_delt; (total 160 bytes); 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 50 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 6; hex 31342e34314d; asc 14.41M;; 20: len 15; hex 45544ce8aea1e7ae97e68980e5be97; asc ETL ;; Record lock, heap no 31 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008852; asc R;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9d1901; asc ;; 3: len 23; hex 746d705f636169715f6b7977645f6f6c696e655f616c69; asc tmp_caiq_kywd_oline_ali;; 4: SQL NULL; 5: SQL NULL; 6: SQL NULL; 7: len 0; hex ; asc ;; 8: len 4; hex 80000000; asc ;; 9: len 0; hex ; asc ;; 10: len 0; hex ; asc ;; 11: len 0; hex ; asc ;; 12: len 0; hex ; asc ;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; Record lock, heap no 32 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008853; asc S;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9a158c; asc ;; 3: len 27; hex 746d705f636169715f6d6f646c65726573756c7470726570617265; asc tmp_caiq_modleresultprepare;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3233333034; asc 23304;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 8; hex 6e6f746578697374; asc notexist;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 57 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 362e313747; asc 6.17G;; 20: len 18; hex 637265617465207461626c65e8a385e8bdbd; asc create table ;; Record lock, heap no 35 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008856; asc V;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9503ab; asc ;; 3: len 27; hex 746d705f636169715f706f735f6361697a695f6175636272616e64; asc tmp_caiq_pos_caizi_aucbrand;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3138373830; asc 18780;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 5; hex 3138373830; asc 18780;; 12: len 30; hex 735f61756374696f6e5f61756374696f6e732c745f61756374696f6e5f63; asc s_auction_auctions,t_auction_c; (total 52 bytes); 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000001; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 57 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 6; hex 31322e303847; asc 12.08G;; 20: len 15; hex 45544ce8aea1e7ae97e68980e5be97; asc ETL ;; Record lock, heap no 36 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008857; asc W;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a950541; asc A;; 3: len 25; hex 746d705f636169715f706f735f6361697a695f617563636f75; asc tmp_caiq_pos_caizi_auccou;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e4b887e7a88b; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3138373830; asc 18780;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 5; hex 3138373830; asc 18780;; 12: len 30; hex 735f61756374696f6e5f61756374696f6e732c745f61756374696f6e5f63; asc s_auction_auctions,t_auction_c; (total 52 bytes); 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000003; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 55 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 6; hex 31312e303147; asc 11.01G;; 20: len 15; hex 45544ce8aea1e7ae97e68980e5be97; asc ETL ;; Record lock, heap no 39 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000885a; asc Z;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9e25b8; asc % ;; 3: len 20; hex 746d705f636169715f706f735f7775715f617563; asc tmp_caiq_pos_wuq_auc;; 4: SQL NULL; 5: SQL NULL; 6: SQL NULL; 7: len 0; hex ; asc ;; 8: len 4; hex 80000000; asc ;; 9: len 0; hex ; asc ;; 10: len 0; hex ; asc ;; 11: len 0; hex ; asc ;; 12: len 0; hex ; asc ;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; Record lock, heap no 42 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000885d; asc ];; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9f24e6; asc $ ;; 3: len 23; hex 746d705f636169715f746f64616e67616e5f746f6f6c31; asc tmp_caiq_todangan_tool1;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e98787e790bc; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3236313137; asc 26117;; 10: len 30; hex 735f7570705f6d705f61727469636c652c735f7570705f706c616e2c735f; asc s_upp_mp_article,s_upp_plan,s_; (total 41 bytes); 11: len 5; hex 3236313137; asc 26117;; 12: len 23; hex 735f7570705f70726f645f737562736372697074696f6e; asc s_upp_prod_subscription;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000001; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 53 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 6; hex 35302e33374d; asc 50.37M;; 20: len 15; hex 45544ce8aea1e7ae97e68980e5be97; asc ETL ;; Record lock, heap no 43 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000885e; asc ^;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9f255e; asc %^;; 3: len 23; hex 746d705f636169715f746f64616e67616e5f746f6f6c32; asc tmp_caiq_todangan_tool2;; 4: SQL NULL; 5: len 8; hex 800000000000000e; asc ;; 6: SQL NULL; 7: len 6; hex e98787e790bc; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3236313137; asc 26117;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 30; hex 735f7570705f6d705f61727469636c652c735f7570705f706c616e2c735f; asc s_upp_mp_article,s_upp_plan,s_; (total 65 bytes); 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 53 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 7; hex 3337352e36334d; asc 375.63M;; 20: len 15; hex 45544ce8aea1e7ae97e68980e5be97; asc ETL ;; Record lock, heap no 48 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008864; asc d;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a951026; asc &;; 3: len 26; hex 746d705f636169715f78756e6469616e303530345f6f72646572; asc tmp_caiq_xundian0504_order;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e98787e790bc; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3235373734; asc 25774;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 5; hex 3235373734; asc 25774;; 12: len 30; hex 725f646d5f77696e5f627579657261756374696f6e5f646d2c725f73656c; asc r_dm_win_buyerauction_dm,r_sel; (total 190 bytes); 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000001; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 56 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 7; hex 3234372e34354d; asc 247.45M;; 20: len 15; hex 45544ce8aea1e7ae97e68980e5be97; asc ETL ;; Record lock, heap no 49 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008865; asc e;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a9509ac; asc ;; 3: len 27; hex 746d705f636169715f78756e6469616e303530345f726566756e64; asc tmp_caiq_xundian0504_refund;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e98787e790bc; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3235373734; asc 25774;; 10: len 29; hex 746d705f636169715f78756e6469616e303530345f6175636272616e64; asc tmp_caiq_xundian0504_aucbrand;; 11: len 5; hex 3235373734; asc 25774;; 12: len 30; hex 735f61756374696f6e5f61756374696f6e732c735f63726d5f726566756e; asc s_auction_auctions,s_crm_refun; (total 77 bytes); 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000001; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 57 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 7; hex 3231322e31354d; asc 212.15M;; 20: len 15; hex 45544ce8aea1e7ae97e68980e5be97; asc ETL ;; Record lock, heap no 50 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008866; asc f;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a951080; asc ;; 3: len 27; hex 746d705f636169715f78756e6469616e303530345f726573756c74; asc tmp_caiq_xundian0504_result;; 4: SQL NULL; 5: len 8; hex 800000000000000e; asc ;; 6: SQL NULL; 7: len 6; hex e98787e790bc; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3235373734; asc 25774;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 8; hex 6e6f746578697374; asc notexist;; 12: len 30; hex 725f646d5f77696e5f627579657261756374696f6e5f646d2c725f73656c; asc r_dm_win_buyerauction_dm,r_sel; (total 190 bytes); 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 57 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 6; hex 32342e39314d; asc 24.91M;; 20: len 15; hex 45544ce8aea1e7ae97e68980e5be97; asc ETL ;; Record lock, heap no 51 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008867; asc g;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a950ddd; asc ;; 3: len 30; hex 746d705f636169715f78756e6469616e303530345f756e696f6e64657363; asc tmp_caiq_xundian0504_uniondesc;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e98787e790bc; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3235373734; asc 25774;; 10: len 19; hex 725f646d5f77696e5f61756374696f6e5f646d; asc r_dm_win_auction_dm;; 11: len 5; hex 3235373734; asc 25774;; 12: len 30; hex 725f73656c6c65725f62617369635f696e666f2c735f61756374696f6e5f; asc r_seller_basic_info,s_auction_; (total 165 bytes); 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000001; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 60 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 372e343347; asc 7.43G;; 20: len 15; hex 45544ce8aea1e7ae97e68980e5be97; asc ETL ;; Record lock, heap no 52 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008868; asc h;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a950a20; asc ;; 3: len 30; hex 746d705f636169715f78756e6469616e303530345f756e696f6e72656675; asc tmp_caiq_xundian0504_unionrefu; (total 32 bytes); 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e98787e790bc; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3235373734; asc 25774;; 10: len 30; hex 725f73656c6c65725f62617369635f696e666f2c746d705f636169715f78; asc r_seller_basic_info,tmp_caiq_x; (total 44 bytes); 11: len 5; hex 3235373734; asc 25774;; 12: len 30; hex 735f61756374696f6e5f61756374696f6e732c735f626173655f76616c75; asc s_auction_auctions,s_base_valu; (total 91 bytes); 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000001; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 62 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 342e363147; asc 4.61G;; 20: len 15; hex 45544ce8aea1e7ae97e68980e5be97; asc ETL ;; Record lock, heap no 54 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008860; asc `;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a950f90; asc ;; 3: len 30; hex 746d705f636169715f78756e6469616e303530345f616c697061796e756c; asc tmp_caiq_xundian0504_alipaynul; (total 31 bytes); 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e98787e790bc; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3235373734; asc 25774;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 5; hex 3235373734; asc 25774;; 12: len 30; hex 725f646d5f77696e5f627579657261756374696f6e5f646d2c725f73656c; asc r_dm_win_buyerauction_dm,r_sel; (total 190 bytes); 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000001; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 61 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 372e343947; asc 7.49G;; 20: len 15; hex 45544ce8aea1e7ae97e68980e5be97; asc ETL ;; Record lock, heap no 55 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008869; asc i;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a950bd3; asc ;; 3: len 30; hex 746d705f636169715f78756e6469616e303530345f756e696f6e73656c6c; asc tmp_caiq_xundian0504_unionsell; (total 36 bytes); 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e98787e790bc; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3235373734; asc 25774;; 10: len 25; hex 746d705f636169715f617563696e645f6465736373636f7265; asc tmp_caiq_aucind_descscore;; 11: len 5; hex 3235373734; asc 25774;; 12: len 30; hex 725f73656c6c65725f62617369635f696e666f2c735f61756374696f6e5f; asc r_seller_basic_info,s_auction_; (total 139 bytes); 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000001; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 66 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 372e333547; asc 7.35G;; 20: len 15; hex 45544ce8aea1e7ae97e68980e5be97; asc ETL ;; Record lock, heap no 57 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000885b; asc [;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000aa62630; asc &0;; 3: len 19; hex 746d705f636169715f706f735f777571636174; asc tmp_caiq_pos_wuqcat;; 4: SQL NULL; 5: SQL NULL; 6: SQL NULL; 7: len 6; hex e98787e790bc; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3138393939; asc 18999;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 5; hex 3138393939; asc 18999;; 12: len 8; hex 6e6f746578697374; asc notexist;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 30; hex 686466733a2f2f6864706e6e3a393030302f67726f75702f74616f62616f; asc hdfs://hdpnn:9000/group/taobao; (total 60 bytes); 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f64772f64696d2f6361; asc /group/taobao/taobao/dw/dim/ca; (total 43 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 4; hex 31333262; asc 132b;; 20: len 15; hex 45544ce8aea1e7ae97e68980e5be97; asc ETL ;; Record lock, heap no 58 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 800000000000885f; asc _;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a950e6e; asc n;; 3: len 27; hex 746d705f636169715f78756e6469616e303530345f616c69706179; asc tmp_caiq_xundian0504_alipay;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e98787e790bc; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3235373734; asc 25774;; 10: len 8; hex 6e6f746578697374; asc notexist;; 11: len 5; hex 3235373734; asc 25774;; 12: len 30; hex 725f646d5f77696e5f627579657261756374696f6e5f646d2c725f73656c; asc r_dm_win_buyerauction_dm,r_sel; (total 190 bytes); 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000001; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 57 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 5; hex 372e353347; asc 7.53G;; 20: len 15; hex 45544ce8aea1e7ae97e68980e5be97; asc ETL ;; Record lock, heap no 59 PHYSICAL RECORD: n_fields 21; compact format; info bits 0 0: len 8; hex 8000000000008863; asc c;; 1: len 6; hex 000000056f5d; asc o];; 2: len 7; hex 0000000a950a77; asc w;; 3: len 24; hex 746d705f636169715f78756e6469616e303530345f647372; asc tmp_caiq_xundian0504_dsr;; 4: SQL NULL; 5: len 8; hex 800000000000000d; asc ;; 6: SQL NULL; 7: len 6; hex e98787e790bc; asc ;; 8: len 4; hex 80000001; asc ;; 9: len 5; hex 3235373734; asc 25774;; 10: len 30; hex 725f73656c6c65725f62617369635f696e666f2c746d705f636169715f78; asc r_seller_basic_info,tmp_caiq_x; (total 52 bytes); 11: len 5; hex 3235373734; asc 25774;; 12: len 27; hex 735f6d65726368616e646973655f6473725f6461696c795f73756d; asc s_merchandise_dsr_daily_sum;; 13: len 4; hex 80000001; asc ;; 14: len 4; hex 80000001; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17: len 30; hex 2f67726f75702f74616f62616f2f74616f62616f2f686976652f746d705f; asc /group/taobao/taobao/hive/tmp_; (total 54 bytes); 18: len 18; hex 6269e7babfe8b584e6ba902d6f7468657273; asc bi -others;; 19: len 6; hex 36312e32324d; asc 61.22M;; 20: len 15; hex 45544ce8aea1e7ae97e68980e5be97; asc ETL ;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 177 page no 130 n bits 280 index `index_meta_table_name` of table `magicloud`.`meta_table` trx id 56F5D lock_mode X waiting Record lock, heap no 137 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 22; hex 6d5f67726f75705f6368616e6765645f64657461696c; asc m_group_changed_detail;; 1: len 6; hex e5ad90e69ca8; asc ;; 2: len 8; hex 80000000000095b6; asc ;; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 9A353 Purge done for trx's n:o < 9A29C undo n:o < 0 History list length 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started, process no 5325, OS thread id 1105987904 MySQL thread id 5428847, query id 108322423 localhost root show innodb status ---TRANSACTION 9A236, not started, process no 5325, OS thread id 1233848640 MySQL thread id 5428073, query id 108317160 172.24.113.144 dwalarm ---TRANSACTION 0, not started, process no 5325, OS thread id 1086413120 MySQL thread id 5427597, query id 108307895 localhost root ---TRANSACTION 9A301, not started, process no 5325, OS thread id 1233582400 MySQL thread id 5427443, query id 108319261 172.24.113.146 ask ---TRANSACTION 9A0C3, not started, process no 5325, OS thread id 1233316160 MySQL thread id 5425299, query id 108314118 172.24.113.146 cheetah ---TRANSACTION 99D01, not started, process no 5325, OS thread id 1235179840 MySQL thread id 5424029, query id 107888686 172.24.113.146 cheetah ---TRANSACTION 9A260, not started, process no 5325, OS thread id 1104922944 MySQL thread id 5371917, query id 108317704 172.24.113.146 cheetah ---TRANSACTION 9A27D, not started, process no 5325, OS thread id 1105721664 MySQL thread id 5371915, query id 108317970 172.24.113.146 cheetah ---TRANSACTION 99F14, not started, process no 5325, OS thread id 1234381120 MySQL thread id 5371918, query id 108309142 172.24.113.146 cheetah ---TRANSACTION 9A34B, not started, process no 5325, OS thread id 1104390464 MySQL thread id 5371916, query id 108321770 172.24.113.146 cheetah ---TRANSACTION 9A350, not started, process no 5325, OS thread id 1105455424 MySQL thread id 5371806, query id 108321825 172.24.113.146 cheetah ---TRANSACTION 9A278, not started, process no 5325, OS thread id 1104124224 MySQL thread id 5371804, query id 108317927 172.24.113.146 cheetah ---TRANSACTION 9A25F, not started, process no 5325, OS thread id 1106520384 MySQL thread id 5371803, query id 108317696 172.24.113.146 cheetah ---TRANSACTION 9A27B, not started, process no 5325, OS thread id 1092999488 MySQL thread id 5371802, query id 108317936 172.24.113.146 cheetah ---TRANSACTION 9A2A7, not started, process no 5325, OS thread id 1234913600 MySQL thread id 5371801, query id 108318350 172.24.113.146 cheetah ---TRANSACTION 9A25E, not started, process no 5325, OS thread id 1235712320 MySQL thread id 5371800, query id 108317703 172.24.113.146 cheetah ---TRANSACTION 9A31F, not started, process no 5325, OS thread id 1235978560 MySQL thread id 5371799, query id 108320060 172.24.113.146 cheetah ---TRANSACTION 9A31A, not started, process no 5325, OS thread id 1233049920 MySQL thread id 4935452, query id 108319901 172.24.113.144 dwalarm ---TRANSACTION 9A352, ACTIVE 1 sec, process no 5325, OS thread id 1234114880 starting index read mysql tables in use 2, locked 2 LOCK WAIT 3 lock struct(s), heap size 1248, 1 row lock(s), undo log entries 24 MySQL thread id 5428845, query id 108322419 172.24.113.136 cheetah updating delete from meta_column_authorization where column_id in (select column_id from meta_column where table_id=36377) Trx read view will not see trx with id >= 9A353, sees < 99E87 ------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 149 page no 8 n bits 432 index `PRIMARY` of table `magicloud`.`meta_column_authorization` trx id 9A352 lock_mode X waiting Record lock, heap no 2 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 8; hex 80000000000667b9; asc g ;; 1: len 6; hex 000000002b08; asc + ;; 2: len 7; hex 80000000320110; asc 2 ;; 3: len 8; hex 800000000000000c; asc ;; 4: len 8; hex 800000000006675b; asc g[;; ------------------ ---TRANSACTION 99E87, ACTIVE 1212 sec, process no 5325, OS thread id 1105189184 1414 lock struct(s), heap size 178616, 308451 row lock(s), undo log entries 1782 MySQL thread id 5427673, query id 108306779 172.24.113.136 cheetah Trx read view will not see trx with id >= 99E88, sees < 99E88 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1717 OS file reads, 9286811 OS file writes, 1077633 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.46 writes/s, 0.25 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 35401589, node heap has 2580 buffer(s) 5478.84 hash searches/s, 94.53 non-hash searches/s --- LOG --- Log sequence number 33483300416 Log flushed up to 33483300416 Last checkpoint at 33483295441 0 pending log writes, 0 pending chkp writes 708935 log i/o's done, 0.14 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 17574133760; in additional pool allocated 0 Dictionary memory allocated 287368 Buffer pool size 1048575 Free buffers 945406 Database pages 100579 Old database pages 37107 Modified db pages 3 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 89608, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 2062, created 580323, written 14027167 0.00 reads/s, 0.00 creates/s, 0.32 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 100579, unzip_LRU len: 0 I/O sum[6]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 3 read views open inside InnoDB Main thread process no. 5325, id 1201047872, state: sleeping Number of rows inserted 134663378, updated 11251739, deleted 29114332, read 248282927700 0.86 inserts/s, 0.00 updates/s, 0.00 deletes/s, 5564.12 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================