innodb_space's output can't find the record that showed in 'INFORMATION_SCHEMA.INNODB_LOCKS'
17 views
Skip to first unread message
白晓宇
Jan 12, 2018, 10:07:38 PM1/12/18
to innod...@googlegroups.com
hi,
in mysql5.6, i have a table with a unique index, when i deleted different rows in 2 sessions, session 2 was blocked by sesssion 1, so i want to find out which row generates lock ,i selected information_schema.innodb_locks ,LOCK_PAGE,LOCK_REC gave me information ,then i used innodb_space show all rows on that page,but i did't find the rows match that lock_rec,is there anything different between innodb_space's output and innodb_locks' output?
the test cases are as follow ,i can't find lock_rec:164 in the innodb_space's output ,thank you and have a nice day:
| lock_t1 | CREATE TABLE `lock_t1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fund_code` varchar(40) NOT NULL ,
`trade_date` datetime NOT NULL ,
`adj_factor` decimal(20,6) NOT NULL,
`f_nav_unit` decimal(20,4) NOT NULL ,
`fund_type` int(11) DEFAULT NULL ,
`fund_status` varchar(20) NOT NULL DEFAULT 'VALID' ,
`avg_available` int(1) NOT NULL DEFAULT '1' ,
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ,
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_code_date` (`fund_code`,`trade_date`)
) ENGINE=InnoDB AUTO_INCREMENT=23482381 DEFAULT CHARSET=utf8
mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS\G
*************************** 1. row ***************************
lock_id: 351081879:42405:35836:164
lock_trx_id: 351081879
lock_mode: X
lock_type: RECORD
lock_table: `wdw`.`lock_t1`
lock_index: idx_code_date
lock_space: 42405
lock_page: 35836
lock_rec: 164
lock_data: '003631.OF', 0x999B260000
*************************** 2. row ***************************
lock_id: 351081874:42405:35836:164
lock_trx_id: 351081874
lock_mode: X
lock_type: RECORD
lock_table: `wdw`.`lock_t1`
lock_index: idx_code_date
lock_space: 42405
lock_page: 35836
lock_rec: 164
lock_data: '003631.OF', 0x999B260000
2 rows in set (0.00 sec)
ruby -r rubygems -I lib bin/innodb_space -s /dbdata/mysql_3309/ibdata1 -T wdw/lock_t1 -p 35836 page-records
Record 126: (fund_code="003630.OF", trade_date="184547968-96-95 60:60:10") → (id=1107886080)
Record 150: (fund_code="003630.OF", trade_date="184548188-87-18 86:15:82") → (id=-771162112)
Record 174: (fund_code="003630.OF", trade_date="184549508-28-58 39:49:13") → (id=67699712)
Record 198: (fund_code="003630.OF", trade_date="184549728-18-81 65:04:84") → (id=1980301312)
Record 222: (fund_code="003630.OF", trade_date="184549948-09-04 90:60:58") → (id=-1509359616)
Record 246: (fund_code="003630.OF", trade_date="184550167-99-28 16:16:29") → (id=755564544)
Record 270: (fund_code="003630.OF", trade_date="184550827-69-97 92:83:01") → (id=-1257700352)
Record 294: (fund_code="003630.OF", trade_date="184551047-60-21 18:38:75") → (id=805896192)
Record 318: (fund_code="003630.OF", trade_date="184551267-50-44 43:94:45") → (id=1929969664)
Record 342: (fund_code="003630.OF", trade_date="184551487-40-67 69:50:20") → (id=1007222784)
Record 366: (fund_code="003630.OF", trade_date="184551707-30-90 95:05:92") → (id=151585792)
Record 390: (fund_code="003630.OF", trade_date="184552367-01-60 71:72:68") → (id=-1324810240)
Record 414: (fund_code="003630.OF", trade_date="184552586-91-83 97:28:34") → (id=1174994944)
Record 438: (fund_code="003630.OF", trade_date="184552806-82-07 22:84:06") → (id=386465792)
Record 462: (fund_code="003630.OF", trade_date="184553026-72-30 48:39:82") → (id=1644758016)
Record 486: (fund_code="003630.OF", trade_date="184553246-62-53 73:95:49") → (id=-1492582400)
Record 510: (fund_code="003630.OF", trade_date="184553906-33-23 50:62:30") → (id=1275658240)
Record 534: (fund_code="003630.OF", trade_date="184554126-23-46 76:18:01") → (id=1158217728)
Record 558: (fund_code="003630.OF", trade_date="184554346-13-70 01:73:67") → (id=369689600)
Record 582: (fund_code="003630.OF", trade_date="184554566-03-93 27:29:48") → (id=1829306368)
Record 606: (fund_code="003630.OF", trade_date="184554785-94-16 52:85:17") → (id=369688576)
Record 630: (fund_code="003630.OF", trade_date="184555885-45-32 80:62:96") → (id=1476984832)
Record 654: (fund_code="003630.OF", trade_date="184556325-25-79 31:74:26") → (id=-452393984)
Record 678: (fund_code="003630.OF", trade_date="184556545-16-02 57:29:95") → (id=2131296256)
Record 702: (fund_code="003630.OF", trade_date="184557204-86-72 33:96:73") → (id=1980301312)
Record 726: (fund_code="003630.OF", trade_date="184557424-76-95 59:52:45") → (id=589824)
Record 750: (fund_code="003630.OF", trade_date="184557644-67-18 85:08:14") → (id=956892160)
Record 774: (fund_code="003630.OF", trade_date="184557864-57-42 10:63:91") → (id=252248064)
Record 798: (fund_code="003630.OF", trade_date="184558084-47-65 36:19:64") → (id=-888602624)
Record 822: (fund_code="003630.OF", trade_date="184558744-18-35 12:87:19") → (id=-2079784959)
Record 846: (fund_code="003630.OF", trade_date="184558964-08-58 38:42:71") → (id=-2046229503)
Record 870: (fund_code="003630.OF", trade_date="184559183-98-81 63:98:23") → (id=-2012676095)
Record 894: (fund_code="003630.OF", trade_date="184559403-89-04 89:53:88") → (id=-1341587455)
Record 918: (fund_code="003630.OF", trade_date="184559623-79-28 15:09:68") → (id=1762197505)
Record 942: (fund_code="003630.OF", trade_date="184560283-49-97 91:76:40") → (id=1325990913)
Record 966: (fund_code="003630.OF", trade_date="184560503-40-21 17:32:11") → (id=-1492582399)
Record 990: (fund_code="003630.OF", trade_date="184560723-30-44 42:87:86") → (id=805896193)
Record 1014: (fund_code="003630.OF", trade_date="184560943-20-67 68:43:54") → (id=168361985)
Record 1038: (fund_code="003630.OF", trade_date="184561163-10-90 93:99:34") → (id=-1928788991)
Record 1062: (fund_code="003630.OF", trade_date="184561822-81-60 70:66:06") → (id=201916417)
Record 1086: (fund_code="003630.OF", trade_date="184562042-71-83 96:21:80") → (id=1107886081)
Record 1110: (fund_code="003630.OF", trade_date="184562262-62-07 21:77:53") → (id=1393098753)
Record 1134: (fund_code="003630.OF", trade_date="184562482-52-30 47:33:25") → (id=-922156031)
Record 1158: (fund_code="003630.OF", trade_date="184562702-42-53 72:89:03") → (id=-217513983)
Record 1182: (fund_code="003630.OF", trade_date="184563801-93-70 00:66:82") → (id=1275658241)
Record 1206: (fund_code="003630.OF", trade_date="184564021-83-93 26:22:56") → (id=-1945567231)
Record 1230: (fund_code="003630.OF", trade_date="184564241-74-16 51:78:26") → (id=654902273)
Record 1254: (fund_code="003630.OF", trade_date="184564461-64-39 77:33:98") → (id=755564545)
Record 1278: (fund_code="003630.OF", trade_date="184564681-54-63 02:89:72") → (id=1627979777)
Record 1302: (fund_code="003630.OF", trade_date="184565341-25-32 79:90:33") → (id=-1492582399)
Record 1326: (fund_code="003630.OF", trade_date="184565561-15-56 05:46:13") → (id=-1291254783)
Record 1350: (fund_code="003630.OF", trade_date="184565781-05-79 31:01:85") → (id=269025281)
Record 1374: (fund_code="003630.OF", trade_date="184566000-96-02 56:57:59") → (id=520683521)
Record 1398: (fund_code="003630.OF", trade_date="184566220-86-25 82:13:30") → (id=1393098753)
Record 1422: (fund_code="003630.OF", trade_date="184566880-56-95 58:80:16") → (id=-1878457343)
Record 1446: (fund_code="003630.OF", trade_date="184567100-47-18 84:35:85") → (id=1627979777)
Record 1470: (fund_code="003630.OF", trade_date="184567320-37-42 09:91:51") → (id=-1274478591)
Record 1494: (fund_code="003630.OF", trade_date="184567540-27-65 35:47:33") → (id=-2146893823)
Record 1518: (fund_code="003630.OF", trade_date="184567760-17-88 61:03:06") → (id=738788353)
Record 1542: (fund_code="003630.OF", trade_date="184568419-88-58 37:69:78") → (id=352911361)
Record 1566: (fund_code="003630.OF", trade_date="184568639-78-81 63:25:52") → (id=235470849)
Record 1590: (fund_code="003630.OF", trade_date="184568859-69-04 88:81:32") → (id=722010114)
Record 1614: (fund_code="003630.OF", trade_date="184569079-59-28 14:37:05") → (id=-385285118)
Record 1638: (fund_code="003630.OF", trade_date="184569299-49-51 39:92:75") → (id=805896194)
Record 1662: (fund_code="003630.OF", trade_date="184569959-20-21 16:59:56") → (id=1275658242)
Record 1686: (fund_code="003630.OF", trade_date="184570399-00-67 67:70:72") → (id=1107886082)
Record 1710: (fund_code="003630.OF", trade_date="184570618-90-90 93:26:51") → (id=-1006042110)
Record 1734: (fund_code="003630.OF", trade_date="184570838-81-14 18:82:24") → (id=1443430402)
Record 1758: (fund_code="003630.OF", trade_date="184571058-71-37 44:37:97") → (id=-485949438)
Record 1782: (fund_code="003630.OF", trade_date="184571718-42-07 21:05:02") → (id=-368508926)
Record 1806: (fund_code="003630.OF", trade_date="184571938-32-30 46:61:12") → (id=-402062334)
Record 1830: (fund_code="003630.OF", trade_date="184572158-22-53 72:52:92") → (id=-1526136830)
Record 1854: (fund_code="003630.OF", trade_date="184572378-12-76 98:09:04") → (id=554237954)
Record 1878: (fund_code="003630.OF", trade_date="184572598-03-00 23:82:13") → (id=-1878458366)
Record 1902: (fund_code="003630.OF", trade_date="184573257-73-70 00:48:95") → (id=-150404094)
Record 1926: (fund_code="003630.OF", trade_date="184573477-63-93 26:04:71") → (id=-1928790014)
Record 1950: (fund_code="003630.OF", trade_date="184573697-54-16 51:60:46") → (id=604569602)
Record 1974: (fund_code="003630.OF", trade_date="184573917-44-39 77:16:23") → (id=-1526136830)
Record 1998: (fund_code="003630.OF", trade_date="184574137-34-63 02:72:01") → (id=-938933246)
Record 2022: (fund_code="003630.OF", trade_date="184574797-05-32 79:38:78") → (id=-754384894)
Record 2046: (fund_code="003630.OF", trade_date="184575016-95-56 04:94:53") → (id=1795751938)
Record 2070: (fund_code="003630.OF", trade_date="184575236-85-79 30:50:29") → (id=-100073470)
Record 2094: (fund_code="003630.OF", trade_date="184575456-76-02 56:06:14") → (id=1611203586)
Record 2118: (fund_code="003630.OF", trade_date="184575676-66-25 81:61:91") → (id=319356930)
Record 2142: (fund_code="003630.OF", trade_date="184576336-36-95 58:28:71") → (id=-1257701374)
Record 2166: (fund_code="003630.OF", trade_date="184576556-27-18 83:84:46") → (id=1594425346)
Record 2190: (fund_code="003630.OF", trade_date="184576776-17-42 09:40:31") → (id=-2029452286)
Record 2214: (fund_code="003630.OF", trade_date="184576996-07-65 34:96:06") → (id=1040777218)
Record 2238: (fund_code="003630.OF", trade_date="184577435-88-11 86:07:35") → (id=-1475805182)
Record 2262: (fund_code="003630.OF", trade_date="184578095-58-81 62:74:14") → (id=1644756994)
Record 2286: (fund_code="003630.OF", trade_date="184578315-49-04 88:29:90") → (id=336135170)
Record 2310: (fund_code="003630.OF", trade_date="184578535-39-28 13:85:66") → (id=-519503870)
Record 2334: (fund_code="003630.OF", trade_date="184578755-29-51 39:41:43") → (id=-1962344446)
Record 2358: (fund_code="003630.OF", trade_date="184578975-19-74 64:97:20") → (id=-1895235581)
Record 2382: (fund_code="003630.OF", trade_date="184579634-90-44 41:64:00") → (id=-2096561149)
Record 2406: (fund_code="003630.OF", trade_date="184579854-80-67 67:19:75") → (id=2047410179)
Record 2430: (fund_code="003630.OF", trade_date="184580074-70-90 92:75:51") → (id=2030632963)
Record 2454: (fund_code="003630.OF", trade_date="184580294-61-14 18:31:28") → (id=1577648131)
Record 2478: (fund_code="003630.OF", trade_date="184580514-51-37 43:87:05") → (id=1762198531)
Record 2502: (fund_code="003630.OF", trade_date="184581174-22-07 20:53:85") → (id=-687276029)
Record 2526: (fund_code="003630.OF", trade_date="184581394-12-30 46:09:61") → (id=-502726653)
Record 2550: (fund_code="003630.OF", trade_date="184581614-02-53 71:65:37") → (id=-234291197)
Record 2574: (fund_code="003630.OF", trade_date="184581833-92-76 97:21:36") → (id=470352899)
Record 2598: (fund_code="003630.OF", trade_date="184582053-83-00 22:77:12") → (id=-1509359613)
Record 2622: (fund_code="003630.OF", trade_date="184582713-53-69 99:43:90") → (id=2114519043)
Record 2646: (fund_code="003630.OF", trade_date="184582933-43-93 24:99:67") → (id=-1727463421)
Record 2670: (fund_code="003630.OF", trade_date="184583153-34-16 50:55:43") → (id=-1056373757)
Record 2694: (fund_code="003630.OF", trade_date="184583373-24-39 76:11:20") → (id=-1308033021)
Record 2718: (fund_code="003630.OF", trade_date="184583593-14-63 01:66:97") → (id=-167182333)
Record 2742: (fund_code="003630.OF", trade_date="184586231-97-42 08:33:45") → (id=856227843)
Record 2766: (fund_code="003630.OF", trade_date="184586451-87-65 33:89:21") → (id=1778975747)
Record 2790: (fund_code="003630.OF", trade_date="184586671-77-88 59:44:98") → (id=-1492582397)
Record 2814: (fund_code="003630.OF", trade_date="184586891-68-11 85:00:75") → (id=-1375141885)
Record 2838: (fund_code="003630.OF", trade_date="184587111-58-35 10:56:52") → (id=-32964605)
Record 2862: (fund_code="003630.OF", trade_date="184587771-29-04 87:23:32") → (id=1107887107)
Record 2886: (fund_code="003630.OF", trade_date="184587991-19-28 12:79:09") → (id=-2113339389)
Record 2910: (fund_code="003630.OF", trade_date="184588430-99-74 63:90:43") → (id=-1492582397)
Record 2934: (fund_code="003630.OF", trade_date="184589310-60-67 66:12:76") → (id=-251068413)
Record 2958: (fund_code="003630.OF", trade_date="184589530-50-90 91:68:52") → (id=1074332675)
Record 2982: (fund_code="003630.OF", trade_date="184589750-41-14 17:24:29") → (id=-1979121661)
Record 3006: (fund_code="003630.OF", trade_date="184589970-31-37 42:80:06") → (id=-1475805181)
Record 3030: (fund_code="003630.OF", trade_date="184590190-21-60 68:35:83") → (id=-183959549)
Record 3054: (fund_code="003630.OF", trade_date="184590849-92-30 45:02:63") → (id=1174995971)
Record 3078: (fund_code="003630.OF", trade_date="184591069-82-53 70:58:40") → (id=-1962344445)
Record 3102: (fund_code="003630.OF", trade_date="184591509-63-00 21:69:68") → (id=-687276029)
Record 3126: (fund_code="003630.OF", trade_date="184591729-53-23 47:25:45") → (id=-167182332)
Record 3150: (fund_code="003630.OF", trade_date="184591949-43-46 72:81:22") → (id=1376322564)
Record 3174: (fund_code="003630.OF", trade_date="184592609-14-16 49:48:03") → (id=-1526136828)
Record 3198: (fund_code="003630.OF", trade_date="184592829-04-39 75:03:79") → (id=-83296252)
Record 3222: (fund_code="003630.OF", trade_date="184593048-94-63 00:59:55") → (id=1107886084)
Record 3246: (fund_code="003630.OF", trade_date="184593268-84-86 26:15:46") → (id=168363012)
Record 3270: (fund_code="003630.OF", trade_date="184593488-75-09 51:71:10") → (id=-1073151996)
Record 3294: (fund_code="003630.OF", trade_date="184594148-45-79 28:37:90") → (id=302579716)
Record 3318: (fund_code="003630.OF", trade_date="184594368-36-02 53:93:66") → (id=1577648132)
Record 3342: (fund_code="003630.OF", trade_date="184594588-26-25 79:49:43") → (id=-1341586428)
Record 3366: (fund_code="003630.OF", trade_date="184594808-16-49 05:05:20") → (id=-519503868)
Record 3390: (fund_code="003630.OF", trade_date="184595028-06-72 30:60:97") → (id=1225326596)
Record 3414: (fund_code="003630.OF", trade_date="184595687-77-42 07:27:78") → (id=-1777795068)
Record 3438: (fund_code="003630.OF", trade_date="184595907-67-65 32:83:54") → (id=-251067388)
Record 3462: (fund_code="003630.OF", trade_date="184596127-57-88 58:39:30") → (id=1376321540)
Record 3486: (fund_code="003630.OF", trade_date="184596347-48-11 83:95:07") → (id=1695088644)
Record 3510: (fund_code="003630.OF", trade_date="184596567-38-35 09:50:85") → (id=-1257701372)
Record 3534: (fund_code="003630.OF", trade_date="184597227-09-04 86:17:65") → (id=420021252)
Record 3558: (fund_code="003630.OF", trade_date="184597446-99-28 11:73:42") → (id=-2079784956)
Record 3582: (fund_code="003630.OF", trade_date="184597666-89-51 37:29:18") → (id=-167182332)
Record 3606: (fund_code="003630.OF", trade_date="184598546-50-44 39:51:62") → (id=1007222788)
Record 3630: (fund_code="003630.OF", trade_date="184599206-21-14 16:18:43") → (id=-1240923132)
Record 3654: (fund_code="003630.OF", trade_date="184599426-11-37 41:74:19") → (id=889782276)
Record 3678: (fund_code="003630.OF", trade_date="184599646-01-60 67:29:96") → (id=-1442250748)
Record 3702: (fund_code="003630.OF", trade_date="184599865-91-83 92:85:73") → (id=50921476)
Record 3726: (fund_code="003630.OF", trade_date="184600085-82-07 18:41:51") → (id=-1308031996)
Record 3750: (fund_code="003630.OF", trade_date="184600745-52-76 95:08:31") → (id=621346820)
Record 3774: (fund_code="003630.OF", trade_date="184600965-43-00 20:64:08") → (id=-1509359612)
Record 3798: (fund_code="003630.OF", trade_date="184602724-64-86 25:08:49") → (id=134807556)
Record 3822: (fund_code="003630.OF", trade_date="184602944-55-09 50:64:28") → (id=-1291254780)
Record 3846: (fund_code="003630.OF", trade_date="184603164-45-32 76:20:05") → (id=1695088644)
Record 3870: (fund_code="003630.OF", trade_date="184603824-16-02 52:86:86") → (id=-1928790012)
Record 3894: (fund_code="003630.OF", trade_date="184604044-06-25 78:42:62") → (id=-1677131771)
Record 3918: (fund_code="003630.OF", trade_date="184604263-96-49 03:98:38") → (id=235471877)
Record 3942: (fund_code="003630.OF", trade_date="184604483-86-72 29:54:15") → (id=1812529157)
Record 3966: (fund_code="003630.OF", trade_date="184605143-57-42 06:21:23") → (id=-301400059)
Record 3990: (fund_code="003630.OF", trade_date="184612840-15-56 00:64:66") → (id=1762197509)
Record 4014: (fund_code="003631.OF", trade_date="184511025-37-88 66:75:94") → (id=-217513979)
Record 4062: (fund_code="003631.OF", trade_date="184511904-98-81 68:98:02") → (id=-183958523)
Record 4110: (fund_code="003631.OF", trade_date="184513664-20-67 73:42:18") → (id=-133627899)
Record 4158: (fund_code="003631.OF", trade_date="184522240-39-74 70:07:46") → (id=-83295227)
Record 4206: (fund_code="003631.OF", trade_date="184523559-81-14 23:40:58") → (id=-49741819)
Record 4254: (fund_code="003631.OF", trade_date="184523779-71-37 48:96:10") → (id=590853)
Record 4302: (fund_code="003631.OF", trade_date="184524439-42-07 25:62:66") → (id=50922501)
Record 4038: (fund_code="003631.OF", trade_date="184524659-32-30 51:18:18") → (id=84476933)
Record 4350: (fund_code="003631.OF", trade_date="184524879-22-53 76:73:70") → (id=134807557)
Record 4086: (fund_code="003631.OF", trade_date="184525099-12-77 02:29:22") → (id=151584773)
Record 4398: (fund_code="003631.OF", trade_date="184525319-03-00 27:84:74") → (id=185140229)
Record 4134: (fund_code="003631.OF", trade_date="184525978-73-70 04:51:30") → (id=218693637)
Record 4446: (fund_code="003631.OF", trade_date="184526198-63-93 30:06:82") → (id=252248069)
Record 4182: (fund_code="003631.OF", trade_date="184526418-54-16 55:62:34") → (id=285802501)
Record 4494: (fund_code="003631.OF", trade_date="184526638-44-39 81:17:86") → (id=302580741)
Record 4230: (fund_code="003631.OF", trade_date="184528617-56-49 11:17:54") → (id=336135173)
Record 4542: (fund_code="003631.OF", trade_date="184529277-27-18 87:84:10") → (id=369688581)
Record 4278: (fund_code="003631.OF", trade_date="184529497-17-42 13:39:62") → (id=403243013)
Record 4590: (fund_code="003631.OF", trade_date="184529717-07-65 38:95:14") → (id=436797445)
Record 4638: (fund_code="003631.OF", trade_date="184529936-97-88 64:50:66") → (id=470351877)
Record 4686: (fund_code="003631.OF", trade_date="184530156-88-11 90:06:18") → (id=503906310)
Record 4326: (fund_code="003631.OF", trade_date="184530816-58-81 66:72:74") → (id=537460741)
Record 4734: (fund_code="003631.OF", trade_date="184531036-49-04 92:28:26") → (id=571015174)
Record 4374: (fund_code="003631.OF", trade_date="184531256-39-28 17:83:78") → (id=604569605)
Record 4782: (fund_code="003631.OF", trade_date="184531476-29-51 43:39:30") → (id=638124038)
Record 4422: (fund_code="003631.OF", trade_date="184531696-19-74 68:94:82") → (id=671678469)
Record 4830: (fund_code="003631.OF", trade_date="184532575-80-67 71:16:90") → (id=705233926)
Record 4470: (fund_code="003631.OF", trade_date="184532795-70-90 96:72:42") → (id=738787333)
Record 4878: (fund_code="003631.OF", trade_date="184533015-61-14 22:27:94") → (id=772341766)
Record 4518: (fund_code="003631.OF", trade_date="184533235-51-37 47:83:46") → (id=805896197)
Record 4926: (fund_code="003631.OF", trade_date="184533895-22-07 24:50:02") → (id=839450630)
Record 4566: (fund_code="003631.OF", trade_date="184534115-12-30 50:05:54") → (id=873005061)
Record 4614: (fund_code="003631.OF", trade_date="184535214-63-46 77:83:14") → (id=906559493)
Record 4974: (fund_code="003631.OF", trade_date="184535434-53-70 03:38:66") → (id=940114950)
Record 4662: (fund_code="003631.OF", trade_date="184535654-43-93 28:94:18") → (id=973668358)
Record 5022: (fund_code="003631.OF", trade_date="184536314-14-63 05:60:74") → (id=1007222790)
Record 4710: (fund_code="003631.OF", trade_date="184536534-04-86 31:16:26") → (id=1040777222)
Record 5070: (fund_code="003631.OF", trade_date="184536753-95-09 56:71:78") → (id=1074331654)
Record 4758: (fund_code="003631.OF", trade_date="184536973-85-32 82:27:30") → (id=1107886086)
Record 4806: (fund_code="003631.OF", trade_date="184537193-75-56 07:82:82") → (id=1141440518)
Record 5118: (fund_code="003631.OF", trade_date="184537853-46-25 84:49:38") → (id=1174995974)
Record 4854: (fund_code="003631.OF", trade_date="184538073-36-49 10:04:90") → (id=1208549382)
Record 4902: (fund_code="003631.OF", trade_date="184538293-26-72 36:11:32") → (id=1577648134)
Record 5166: (fund_code="003631.OF", trade_date="184538513-16-95 61:66:84") → (id=1627979782)
Record 4950: (fund_code="003631.OF", trade_date="184538733-07-18 87:22:36") → (id=1644758022)
Record 4998: (fund_code="003631.OF", trade_date="184539392-77-88 63:89:74") → (id=671678470)
Record 5046: (fund_code="003631.OF", trade_date="184539612-68-11 89:45:43") → (id=537461766)
Record 5214: (fund_code="003631.OF", trade_date="184539832-58-35 15:01:14") → (id=1409876998)
Record 5094: (fund_code="003631.OF", trade_date="184540052-48-58 40:56:90") → (id=-922157050)
Record 5262: (fund_code="003631.OF", trade_date="184540272-38-81 66:12:60") → (id=906559494)
Record 5310: (fund_code="003631.OF", trade_date="184540932-09-51 42:79:34") → (id=-1324810234)
Record 5358: (fund_code="003631.OF", trade_date="184541151-99-74 68:35:07") → (id=1107886086)
Record 5406: (fund_code="003631.OF", trade_date="184541371-89-97 93:90:78") → (id=-905379834)
Record 5142: (fund_code="003631.OF", trade_date="184541591-80-21 19:46:51") → (id=-653721594)
Record 5454: (fund_code="003631.OF", trade_date="184541811-70-44 45:02:22") → (id=1476984839)
Record 5190: (fund_code="003631.OF", trade_date="184543131-11-83 98:35:53") → (id=1325989894)
Record 5502: (fund_code="003631.OF", trade_date="184543351-02-07 23:91:26") → (id=-1006043129)
Record 5238: (fund_code="003631.OF", trade_date="184543570-92-30 49:46:96") → (id=520684550)
Record 5550: (fund_code="003631.OF", trade_date="184544230-63-00 26:13:68") → (id=2013855751)
Record 5286: (fund_code="003631.OF", trade_date="184544450-53-23 51:69:42") → (id=789118982)
Record 5334: (fund_code="003631.OF", trade_date="184544670-43-46 77:25:11") → (id=2080964614)
Record 5598: (fund_code="003631.OF", trade_date="184544890-33-70 02:80:87") → (id=-318176249)
Record 5382: (fund_code="003631.OF", trade_date="184545110-23-93 28:36:58") → (id=1376321542)
Record 5646: (fund_code="003631.OF", trade_date="184545769-94-63 05:03:33") → (id=403243015)
Record 5430: (fund_code="003631.OF", trade_date="184545989-84-86 30:59:01") → (id=-1928790009)
Record 5694: (fund_code="003631.OF", trade_date="184546209-75-09 56:14:75") → (id=-720830457)
Record 5478: (fund_code="003631.OF", trade_date="184546429-65-32 81:70:48") → (id=134807559)
Record 5742: (fund_code="003631.OF", trade_date="184546649-55-56 07:26:18") → (id=-620167161)
Record 5526: (fund_code="003631.OF", trade_date="184547309-26-25 83:92:94") → (id=873005063)
Record 5790: (fund_code="003631.OF", trade_date="184547529-16-49 09:48:65") → (id=285803527)
Record 5574: (fund_code="003631.OF", trade_date="184547749-06-72 35:04:36") → (id=252249095)
Record 5838: (fund_code="003631.OF", trade_date="184547968-96-95 60:60:10") → (id=1124663303)
Record 5886: (fund_code="003631.OF", trade_date="184548188-87-18 86:15:82") → (id=-754383865)
Record 5622: (fund_code="003631.OF", trade_date="184549508-28-58 39:49:13") → (id=84475911)
Record 5934: (fund_code="003631.OF", trade_date="184549728-18-81 65:04:84") → (id=1997078535)
Record 5982: (fund_code="003631.OF", trade_date="184549948-09-04 90:60:58") → (id=-1492581369)
Record 5670: (fund_code="003631.OF", trade_date="184550167-99-28 16:16:29") → (id=772342791)
Record 6030: (fund_code="003631.OF", trade_date="184550827-69-97 92:83:01") → (id=-1240924153)
Record 5718: (fund_code="003631.OF", trade_date="184551047-60-21 18:38:75") → (id=822673415)
Record 6078: (fund_code="003631.OF", trade_date="184551267-50-44 43:94:45") → (id=1946747911)
Record 5766: (fund_code="003631.OF", trade_date="184551487-40-67 69:50:20") → (id=1024001031)
Record 5814: (fund_code="003631.OF", trade_date="184551707-30-90 95:05:92") → (id=168361991)
Record 6126: (fund_code="003631.OF", trade_date="184552367-01-60 71:72:68") → (id=-1308033017)
Record 5862: (fund_code="003631.OF", trade_date="184552586-91-83 97:28:34") → (id=1191772167)
Record 6174: (fund_code="003631.OF", trade_date="184552806-82-07 22:84:06") → (id=403244039)
Record 5910: (fund_code="003631.OF", trade_date="184553026-72-30 48:39:82") → (id=1661534215)
Record 6222: (fund_code="003631.OF", trade_date="184553246-62-53 73:95:49") → (id=-1475805176)
Record 5958: (fund_code="003631.OF", trade_date="184553906-33-23 50:62:30") → (id=1292435463)
Record 6270: (fund_code="003631.OF", trade_date="184554126-23-46 76:18:01") → (id=1174994952)
Record 6006: (fund_code="003631.OF", trade_date="184554346-13-70 01:73:67") → (id=386466823)
Record 6318: (fund_code="003631.OF", trade_date="184554566-03-93 27:29:48") → (id=1846083592)
Record 6054: (fund_code="003631.OF", trade_date="184554785-94-16 52:85:17") → (id=386465799)
Record 6366: (fund_code="003631.OF", trade_date="184555885-45-32 80:62:96") → (id=1493762056)
Record 6102: (fund_code="003631.OF", trade_date="184556325-25-79 31:74:26") → (id=-435617785)
Record 6414: (fund_code="003631.OF", trade_date="184556545-16-02 57:29:96") → (id=-2146892792)
Record 6150: (fund_code="003631.OF", trade_date="184557204-86-72 33:96:73") → (id=1997078535)
Record 6462: (fund_code="003631.OF", trade_date="184557424-76-95 59:52:45") → (id=17367048)
Record 6198: (fund_code="003631.OF", trade_date="184557644-67-18 85:08:14") → (id=973668360)
Record 6510: (fund_code="003631.OF", trade_date="184557864-57-42 10:63:91") → (id=269025288)
Record 6246: (fund_code="003631.OF", trade_date="184558084-47-65 36:19:64") → (id=-871825400)
Record 6294: (fund_code="003631.OF", trade_date="184558744-18-35 12:87:19") → (id=-1995898872)
Record 6558: (fund_code="003631.OF", trade_date="184558964-08-58 38:42:71") → (id=-1979121656)
Record 6342: (fund_code="003631.OF", trade_date="184559183-98-81 63:98:23") → (id=-1962344440)
Record 6390: (fund_code="003631.OF", trade_date="184559403-89-04 89:53:88") → (id=-1324810232)
Record 6606: (fund_code="003631.OF", trade_date="184559623-79-28 15:09:68") → (id=1778974728)
Record 6438: (fund_code="003631.OF", trade_date="184560283-49-97 91:76:40") → (id=1342767112)
Record 6654: (fund_code="003631.OF", trade_date="184560503-40-21 17:32:11") → (id=-1475805176)
Record 6486: (fund_code="003631.OF", trade_date="184560723-30-44 42:87:86") → (id=822673416)
Record 6534: (fund_code="003631.OF", trade_date="184560943-20-67 68:43:54") → (id=185140232)
Record 6702: (fund_code="003631.OF", trade_date="184561163-10-90 93:99:34") → (id=-1912011768)
Record 6582: (fund_code="003631.OF", trade_date="184561822-81-60 70:66:06") → (id=218693640)
Record 6750: (fund_code="003631.OF", trade_date="184562042-71-83 96:21:80") → (id=1124663304)
Record 6630: (fund_code="003631.OF", trade_date="184562262-62-07 21:77:53") → (id=1409875976)
Record 6798: (fund_code="003631.OF", trade_date="184562482-52-30 47:33:25") → (id=-905378808)
Record 6678: (fund_code="003631.OF", trade_date="184562702-42-53 72:89:03") → (id=-200735736)
Record 6846: (fund_code="003631.OF", trade_date="184563801-93-70 00:66:82") → (id=1292435464)
Record 6894: (fund_code="003631.OF", trade_date="184564021-83-93 26:22:56") → (id=-1928790008)
Record 6726: (fund_code="003631.OF", trade_date="184564241-74-16 51:78:26") → (id=671678472)
Record 6942: (fund_code="003631.OF", trade_date="184564461-64-39 77:33:98") → (id=772341768)
Record 6774: (fund_code="003631.OF", trade_date="184564681-54-63 02:89:72") → (id=1644758024)
Record 6990: (fund_code="003631.OF", trade_date="184565341-25-32 79:90:33") → (id=-1475805175)
Record 6822: (fund_code="003631.OF", trade_date="184565561-15-56 05:46:13") → (id=-1274478584)
Record 7038: (fund_code="003631.OF", trade_date="184565781-05-79 31:01:85") → (id=285802505)
Record 6870: (fund_code="003631.OF", trade_date="184566000-96-02 56:57:59") → (id=537460744)
Record 6918: (fund_code="003631.OF", trade_date="184566220-86-25 82:13:30") → (id=1409875976)
Record 7086: (fund_code="003631.OF", trade_date="184566880-56-95 58:80:16") → (id=-1861681143)
Record 6966: (fund_code="003631.OF", trade_date="184567100-47-18 84:35:85") → (id=1644757001)
Record 7134: (fund_code="003631.OF", trade_date="184567320-37-42 09:91:51") → (id=-1257701367)
Record 7014: (fund_code="003631.OF", trade_date="184567540-27-65 35:47:33") → (id=-2130116599)
Record 7182: (fund_code="003631.OF", trade_date="184567760-17-88 61:03:06") → (id=755564553)
Record 7062: (fund_code="003631.OF", trade_date="184568419-88-58 37:69:78") → (id=369689609)
Record 7230: (fund_code="003631.OF", trade_date="184568639-78-81 63:25:52") → (id=252248073)
Record 7110: (fund_code="003631.OF", trade_date="184568859-69-04 88:81:32") → (id=738787337)
Record 7278: (fund_code="003631.OF", trade_date="184569079-59-28 14:37:05") → (id=-368508919)
Record 7158: (fund_code="003631.OF", trade_date="184569299-49-51 39:92:75") → (id=822674441)
Record 7326: (fund_code="003631.OF", trade_date="184569959-20-21 16:59:56") → (id=1292436489)
Record 7206: (fund_code="003631.OF", trade_date="184570399-00-67 67:70:72") → (id=1124663305)
Record 7374: (fund_code="003631.OF", trade_date="184570618-90-90 93:26:51") → (id=-989265911)
Record 7254: (fund_code="003631.OF", trade_date="184570838-81-14 18:82:24") → (id=1460208649)
Record 7422: (fund_code="003631.OF", trade_date="184571058-71-37 44:38:01") → (id=-1912012791)
Record 7302: (fund_code="003631.OF", trade_date="184571718-42-07 21:05:02") → (id=-351731703)
Record 7470: (fund_code="003631.OF", trade_date="184571938-32-30 46:61:12") → (id=-368508919)
Record 7518: (fund_code="003631.OF", trade_date="184572158-22-53 72:52:92") → (id=-1509359607)
Record 7566: (fund_code="003631.OF", trade_date="184572378-12-76 98:09:04") → (id=571016201)
Record 7614: (fund_code="003631.OF", trade_date="184572598-03-00 23:82:13") → (id=-1861681143)
Record 7350: (fund_code="003631.OF", trade_date="184573257-73-70 00:48:95") → (id=-133626871)
Record 7398: (fund_code="003631.OF", trade_date="184573477-63-93 26:04:71") → (id=-1912012791)
Record 7662: (fund_code="003631.OF", trade_date="184573697-54-16 51:60:46") → (id=621346825)
Record 7446: (fund_code="003631.OF", trade_date="184573917-44-39 77:16:23") → (id=-1509358583)
Record 7710: (fund_code="003631.OF", trade_date="184574137-34-63 02:72:01") → (id=-922157047)
Record 7494: (fund_code="003631.OF", trade_date="184574797-05-32 79:38:78") → (id=-737607671)
Record 7542: (fund_code="003631.OF", trade_date="184575016-95-56 04:94:53") → (id=1812529161)
Record 7758: (fund_code="003631.OF", trade_date="184575236-85-79 30:50:29") → (id=-83295222)
Record 7590: (fund_code="003631.OF", trade_date="184575456-76-02 56:06:14") → (id=1627979785)
Record 7638: (fund_code="003631.OF", trade_date="184575676-66-25 81:61:91") → (id=336134153)
Record 7806: (fund_code="003631.OF", trade_date="184576336-36-95 58:28:71") → (id=-1240924150)
Record 7686: (fund_code="003631.OF", trade_date="184576556-27-18 83:84:46") → (id=1611203593)
Record 7854: (fund_code="003631.OF", trade_date="184576776-17-42 09:40:31") → (id=-2012676086)
Record 7734: (fund_code="003631.OF", trade_date="184576996-07-65 34:96:06") → (id=1057554442)
Record 7902: (fund_code="003631.OF", trade_date="184577435-88-11 86:07:35") → (id=-1459027958)
Record 7950: (fund_code="003631.OF", trade_date="184578095-58-81 62:74:14") → (id=1661534218)
Record 7998: (fund_code="003631.OF", trade_date="184578315-49-04 88:29:90") → (id=352912394)
Record 8046: (fund_code="003631.OF", trade_date="184578535-39-28 13:85:66") → (id=-502726646)
Record 8094: (fund_code="003631.OF", trade_date="184578755-29-51 39:41:43") → (id=-1945567222)
Record 8142: (fund_code="003631.OF", trade_date="184578975-19-74 64:97:20") → (id=-1878458358)
Record 8190: (fund_code="003631.OF", trade_date="184579634-90-44 41:64:00") → (id=-2079784950)
Record 8238: (fund_code="003631.OF", trade_date="184579854-80-67 67:19:75") → (id=2064188426)
Record 8286: (fund_code="003631.OF", trade_date="184580074-70-90 92:75:51") → (id=2047410186)
Record 8334: (fund_code="003631.OF", trade_date="184580294-61-14 18:31:28") → (id=1594426378)
Record 7782: (fund_code="003631.OF", trade_date="184580514-51-37 43:87:05") → (id=1778974730)
Record 8382: (fund_code="003631.OF", trade_date="184581174-22-07 20:53:85") → (id=-670498806)
Record 7830: (fund_code="003631.OF", trade_date="184581394-12-30 46:09:61") → (id=-485948406)
Record 7878: (fund_code="003631.OF", trade_date="184581614-02-53 71:65:37") → (id=-217513974)
Record 8430: (fund_code="003631.OF", trade_date="184581833-92-76 97:21:36") → (id=487130122)
Record 7926: (fund_code="003631.OF", trade_date="184582053-83-00 22:77:12") → (id=-1492582390)
Record 7974: (fund_code="003631.OF", trade_date="184582713-53-69 99:43:90") → (id=2131297290)
Record 8478: (fund_code="003631.OF", trade_date="184582933-43-93 24:99:67") → (id=-1710686198)
Record 8022: (fund_code="003631.OF", trade_date="184583153-34-16 50:55:43") → (id=-1039597558)
Record 8070: (fund_code="003631.OF", trade_date="184583373-24-39 76:11:20") → (id=-1291255798)
Record 8526: (fund_code="003631.OF", trade_date="184583593-14-63 01:66:97") → (id=-150404085)
Record 8118: (fund_code="003631.OF", trade_date="184586231-97-42 08:33:45") → (id=873005066)
Record 8574: (fund_code="003631.OF", trade_date="184586451-87-65 33:89:21") → (id=1795751947)
Record 8166: (fund_code="003631.OF", trade_date="184586671-77-88 59:44:98") → (id=-1475804150)
Record 8214: (fund_code="003631.OF", trade_date="184586891-68-11 85:00:75") → (id=-1358364662)
Record 8622: (fund_code="003631.OF", trade_date="184587111-58-35 10:56:52") → (id=-16187381)
Record 8262: (fund_code="003631.OF", trade_date="184587771-29-04 87:23:32") → (id=1124663306)
Record 8670: (fund_code="003631.OF", trade_date="184587991-19-28 12:79:09") → (id=-2096562165)
Record 8310: (fund_code="003631.OF", trade_date="184588430-99-74 63:90:43") → (id=-1475805174)
Record 8718: (fund_code="003631.OF", trade_date="184589310-60-67 66:12:76") → (id=-234291189)
Record 8358: (fund_code="003631.OF", trade_date="184589530-50-90 91:68:52") → (id=1091108874)
Record 8766: (fund_code="003631.OF", trade_date="184589750-41-14 17:24:29") → (id=-1962343413)
Record 8406: (fund_code="003631.OF", trade_date="184589970-31-37 42:80:06") → (id=-1459026934)
Record 8814: (fund_code="003631.OF", trade_date="184590190-21-60 68:35:83") → (id=-167182325)
Record 8454: (fund_code="003631.OF", trade_date="184590849-92-30 45:02:63") → (id=1191772170)
Record 8862: (fund_code="003631.OF", trade_date="184591069-82-53 70:58:40") → (id=-1945566197)
Record 8502: (fund_code="003631.OF", trade_date="184591509-63-00 21:69:68") → (id=-670498805)
Record 8910: (fund_code="003631.OF", trade_date="184591729-53-23 47:25:45") → (id=-150405109)
Record 8550: (fund_code="003631.OF", trade_date="184591949-43-46 72:81:22") → (id=1393099787)
Record 8958: (fund_code="003631.OF", trade_date="184592609-14-16 49:48:03") → (id=-1509359605)
Record 8598: (fund_code="003631.OF", trade_date="184592829-04-39 75:03:79") → (id=-66519029)
Record 8646: (fund_code="003631.OF", trade_date="184593048-94-63 00:59:55") → (id=1124663307)
Record 9006: (fund_code="003631.OF", trade_date="184593268-84-86 26:15:46") → (id=185148427)
Record 8694: (fund_code="003631.OF", trade_date="184593488-75-09 51:71:10") → (id=-1056374773)
Record 9054: (fund_code="003631.OF", trade_date="184594148-45-79 28:37:90") → (id=319365131)
Record 8742: (fund_code="003631.OF", trade_date="184594368-36-02 53:93:66") → (id=1594425355)
Record 8790: (fund_code="003631.OF", trade_date="184594588-26-25 79:49:43") → (id=-1324810229)
Record 9102: (fund_code="003631.OF", trade_date="184594808-16-49 05:05:20") → (id=-502717429)
Record 8838: (fund_code="003631.OF", trade_date="184595028-06-72 30:60:97") → (id=1242103819)
Record 9150: (fund_code="003631.OF", trade_date="184595687-77-42 07:27:78") → (id=-1761009653)
Record 8886: (fund_code="003631.OF", trade_date="184595907-67-65 32:83:54") → (id=-234291189)
Record 8934: (fund_code="003631.OF", trade_date="184596127-57-88 58:39:30") → (id=1393098763)
Record 8982: (fund_code="003631.OF", trade_date="184596347-48-11 83:95:07") → (id=1711866891)
Record 9606: (fund_code="003631.OF", trade_date="184596567-38-35 09:50:85") → (id=-1240923124)
Record 9630: (fund_code="003631.OF", trade_date="184597227-09-04 86:17:65") → (id=436797452)
Record 9654: (fund_code="003631.OF", trade_date="184597446-99-28 11:73:42") → (id=-2063007732)
Record 9678: (fund_code="003631.OF", trade_date="184597666-89-51 37:29:18") → (id=-150405108)
Record 9702: (fund_code="003631.OF", trade_date="184598546-50-44 39:51:62") → (id=1024001036)
Record 9726: (fund_code="003631.OF", trade_date="184599206-21-14 16:18:43") → (id=-1224146932)
Record 9750: (fund_code="003631.OF", trade_date="184599426-11-37 41:74:19") → (id=906559500)
Record 9774: (fund_code="003631.OF", trade_date="184599646-01-60 67:29:96") → (id=-1425473524)
Record 9798: (fund_code="003631.OF", trade_date="184599865-91-83 92:85:73") → (id=67699724)
Record 9822: (fund_code="003631.OF", trade_date="184600085-82-07 18:41:51") → (id=-1291255796)
Record 9846: (fund_code="003631.OF", trade_date="184600745-52-76 95:08:31") → (id=638124044)
Record 9870: (fund_code="003631.OF", trade_date="184600965-43-00 20:64:08") → (id=-1492582388)
Record 9894: (fund_code="003631.OF", trade_date="184602724-64-86 25:08:49") → (id=151585804)
Record 9918: (fund_code="003631.OF", trade_date="184602944-55-09 50:64:28") → (id=-1274478580)
Record 9942: (fund_code="003631.OF", trade_date="184603164-45-32 76:20:05") → (id=1711865868)
Record 9966: (fund_code="003631.OF", trade_date="184603824-16-02 52:86:86") → (id=-1912012788)
Record 9990: (fund_code="003631.OF", trade_date="184604044-06-25 78:42:62") → (id=-1660354548)
Record 10014: (fund_code="003631.OF", trade_date="184604263-96-49 03:98:38") → (id=252248076)
Record 10038: (fund_code="003631.OF", trade_date="184604483-86-72 29:54:15") → (id=1829306381)
Record 10062: (fund_code="003631.OF", trade_date="184605143-57-42 06:21:23") → (id=-284621811)
Record 9582: (fund_code="003632.OF", trade_date="184513224-40-21 22:74:42") → (id=201916428)
Reply all
Reply to author
Forward
0 new messages