Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.5.7, 10.5.8, 10.5.9, 10.5.10, 10.6.0, 10.6.1
Description
209 root fdfe::ad:37134 sbtest Query 2446 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 210 root fdfe::ad:37150 sbtest Query 2449 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 211 root fdfe::ad:37170 sbtest Query 2431 Update INSERT INTO stock6 (s_i_id, s_w_id, s_quantity, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_0 0.000 212 root fdfe::ad:37182 sbtest Query 2432 Update INSERT INTO stock4 (s_i_id, s_w_id, s_quantity, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_0 0.000 214 root fdfe::ad:37196 sbtest Query 2450 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 213 root fdfe::ad:37190 sbtest Query 2449 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 215 root fdfe::ad:37208 sbtest Query 2433 Update INSERT INTO order_line5 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 216 root fdfe::ad:37216 sbtest Query 2432 Update INSERT INTO stock6 (s_i_id, s_w_id, s_quantity, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_0 0.000 217 root fdfe::ad:37220 sbtest Query 2433 Update INSERT INTO order_line6 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 218 root fdfe::ad:37232 sbtest Query 2432 Update INSERT INTO stock3 (s_i_id, s_w_id, s_quantity, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_0 0.000 219 root fdfe::ad:37242 sbtest Query 2432 Update INSERT INTO order_line6 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 224 root fdfe::ad:37266 sbtest Query 2433 Update INSERT INTO order_line5 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 220 root fdfe::ad:37248 sbtest Query 2432 Update INSERT INTO customer7 (c_id, c_d_id, c_w_id, c_first, c_middle, c_last, c_street_1, c_street_2, c_ 0.000 221 root fdfe::ad:37250 sbtest Query 2433 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 222 root fdfe::ad:37258 sbtest Query 2432 Update INSERT INTO order_line3 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 223 root fdfe::ad:37262 sbtest Query 2448 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 225 root fdfe::ad:37270 sbtest Query 2434 Update INSERT INTO history6 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 226 root fdfe::ad:37272 sbtest Query 2463 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 227 root fdfe::ad:37274 sbtest Query 2434 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 228 root fdfe::ad:37276 sbtest Query 2433 Update INSERT INTO order_line3 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 229 root fdfe::ad:37278 sbtest Query 2448 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 230 root fdfe::ad:37280 sbtest Query 2453 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 231 root fdfe::ad:37282 sbtest Query 2464 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 232 root fdfe::ad:37284 sbtest Query 2449 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 233 root fdfe::ad:37286 sbtest Query 2433 Update INSERT INTO order_line5 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 234 root fdfe::ad:37288 sbtest Query 2445 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 235 root fdfe::ad:37290 sbtest Query 2465 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 236 root fdfe::ad:37292 sbtest Query 2433 Update INSERT INTO history7 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 237 root fdfe::ad:37294 sbtest Query 2463 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 238 root fdfe::ad:37296 sbtest Query 2449 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 239 root fdfe::ad:37298 sbtest Query 2433 Update INSERT INTO order_line4 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 240 root fdfe::ad:37300 sbtest Query 2433 Update INSERT INTO order_line5 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 241 root fdfe::ad:37302 sbtest Query 2433 Update INSERT INTO orders4 (o_id, o_d_id, o_w_id, o_c_id, o_entry_d, o_carrier_id, o_ol_cnt, o_all_local) 0.000 242 root fdfe::ad:37304 sbtest Query 2432 Update INSERT INTO stock5 (s_i_id, s_w_id, s_quantity, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_0 0.000 243 root fdfe::ad:37306 sbtest Query 2432 Update INSERT INTO order_line4 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 244 root fdfe::ad:37308 sbtest Query 2433 Update INSERT INTO order_line5 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 245 root fdfe::ad:37310 sbtest Query 2448 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 246 root fdfe::ad:37312 sbtest Query 2433 Update INSERT INTO order_line5 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 247 root fdfe::ad:37314 sbtest Query 2434 Update INSERT INTO order_line5 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 248 root fdfe::ad:37316 sbtest Query 2433 Update INSERT INTO order_line5 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 249 root fdfe::ad:37318 sbtest Query 2432 Update INSERT INTO stock7 (s_i_id, s_w_id, s_quantity, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_0 0.000 250 root fdfe::ad:37320 sbtest Query 2447 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 251 root fdfe::ad:37322 sbtest Query 2432 Update INSERT INTO order_line3 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 252 root fdfe::ad:37324 sbtest Query 2432 Update INSERT INTO stock4 (s_i_id, s_w_id, s_quantity, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_0 0.000 253 root fdfe::ad:37326 sbtest Query 2451 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 254 root fdfe::ad:37328 sbtest Query 2450 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 255 root fdfe::ad:37330 sbtest Query 2433 Update INSERT INTO order_line5 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 256 root fdfe::ad:37332 sbtest Query 2449 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 257 root fdfe::ad:37334 sbtest Query 2449 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 258 root fdfe::ad:37336 sbtest Query 2451 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 259 root fdfe::ad:37338 sbtest Query 2432 Update INSERT INTO customer5 (c_id, c_d_id, c_w_id, c_first, c_middle, c_last, c_street_1, c_street_2, c_ 0.000 260 root fdfe::ad:37340 sbtest Query 2454 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 261 root fdfe::ad:37342 sbtest Query 2433 Update INSERT INTO order_line6 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 262 root fdfe::ad:37344 sbtest Query 2433 Update INSERT INTO stock4 (s_i_id, s_w_id, s_quantity, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_0 0.000 263 root fdfe::ad:37346 sbtest Query 2450 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 264 root fdfe::ad:37348 sbtest Query 2433 Update INSERT INTO order_line3 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 265 root fdfe::ad:37350 sbtest Query 2453 Update INSERT INTO history3 (h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data) values 0.000 266 root fdfe::ad:37352 sbtest Query 2432 Update INSERT INTO stock6 (s_i_id, s_w_id, s_quantity, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_0 0.000 267 root fdfe::ad:37354 sbtest Query 2432 Update INSERT INTO stock7 (s_i_id, s_w_id, s_quantity, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_0 0.000 268 root fdfe::ad:37356 sbtest Query 2433 Update INSERT INTO order_line5 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 270 root fdfe::ad:37360 sbtest Query 2433 Update INSERT INTO order_line5 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 271 root fdfe::ad:37362 sbtest Query 2433 Update INSERT INTO order_line3 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 269 root fdfe::ad:37358 sbtest Query 2433 Update INSERT INTO order_line5 (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_deliver 0.000 272 root fdfe::ad:37366 sbtest Query 2433 Update INSERT INTO orders3 (o_id, o_d_id, o_w_id, o_c_id, o_entry_d, o_carrier_id, o_ol_cnt, o_all_local) 0.000 1540 root localhost NULL Query 250 Filling schema table show status like 'Uptime' 0.000 1653 root localhost NULL Query 0 starting show processlist 0.000
SELECT * FROM information_schema.metadata_lock_info;
--------------------------------------------------------------------------------------+
THREAD_ID LOCK_MODE LOCK_DURATION LOCK_TYPE TABLE_SCHEMA TABLE_NAME ----------
----------------------------------------------------------------------------+
235 MDL_BACKUP_TRANS_DML NULL Backup lock 231 MDL_BACKUP_TRANS_DML NULL Backup lock 226 MDL_BACKUP_TRANS_DML NULL Backup lock 237 MDL_BACKUP_TRANS_DML NULL Backup lock 260 MDL_BACKUP_TRANS_DML NULL Backup lock 230 MDL_BACKUP_TRANS_DML NULL Backup lock 265 MDL_BACKUP_TRANS_DML NULL Backup lock 253 MDL_BACKUP_TRANS_DML NULL Backup lock 258 MDL_BACKUP_TRANS_DML NULL Backup lock 254 MDL_BACKUP_TRANS_DML NULL Backup lock 214 MDL_BACKUP_TRANS_DML NULL Backup lock 263 MDL_BACKUP_TRANS_DML NULL Backup lock 213 MDL_BACKUP_TRANS_DML NULL Backup lock 238 MDL_BACKUP_TRANS_DML NULL Backup lock 232 MDL_BACKUP_TRANS_DML NULL Backup lock 257 MDL_BACKUP_TRANS_DML NULL Backup lock 210 MDL_BACKUP_TRANS_DML NULL Backup lock 256 MDL_BACKUP_TRANS_DML NULL Backup lock 229 MDL_BACKUP_TRANS_DML NULL Backup lock 245 MDL_BACKUP_TRANS_DML NULL Backup lock 223 MDL_BACKUP_TRANS_DML NULL Backup lock 250 MDL_BACKUP_TRANS_DML NULL Backup lock 209 MDL_BACKUP_TRANS_DML NULL Backup lock 234 MDL_BACKUP_TRANS_DML NULL Backup lock 227 MDL_BACKUP_TRANS_DML NULL Backup lock 247 MDL_BACKUP_TRANS_DML NULL Backup lock 225 MDL_BACKUP_TRANS_DML NULL Backup lock 228 MDL_BACKUP_TRANS_DML NULL Backup lock 261 MDL_BACKUP_TRANS_DML NULL Backup lock 269 MDL_BACKUP_TRANS_DML NULL Backup lock 244 MDL_BACKUP_TRANS_DML NULL Backup lock 217 MDL_BACKUP_TRANS_DML NULL Backup lock 255 MDL_BACKUP_TRANS_DML NULL Backup lock 233 MDL_BACKUP_TRANS_DML NULL Backup lock 241 MDL_BACKUP_TRANS_DML NULL Backup lock 239 MDL_BACKUP_TRANS_DML NULL Backup lock 215 MDL_BACKUP_TRANS_DML NULL Backup lock 270 MDL_BACKUP_TRANS_DML NULL Backup lock 224 MDL_BACKUP_TRANS_DML NULL Backup lock 236 MDL_BACKUP_TRANS_DML NULL Backup lock 264 MDL_BACKUP_TRANS_DML NULL Backup lock 271 MDL_BACKUP_TRANS_DML NULL Backup lock 272 MDL_BACKUP_TRANS_DML NULL Backup lock 268 MDL_BACKUP_TRANS_DML NULL Backup lock 246 MDL_BACKUP_TRANS_DML NULL Backup lock 221 MDL_BACKUP_TRANS_DML NULL Backup lock 240 MDL_BACKUP_TRANS_DML NULL Backup lock 262 MDL_BACKUP_TRANS_DML NULL Backup lock 248 MDL_BACKUP_TRANS_DML NULL Backup lock 212 MDL_BACKUP_TRANS_DML NULL Backup lock 222 MDL_BACKUP_TRANS_DML NULL Backup lock 249 MDL_BACKUP_TRANS_DML NULL Backup lock 219 MDL_BACKUP_TRANS_DML NULL Backup lock 242 MDL_BACKUP_TRANS_DML NULL Backup lock 218 MDL_BACKUP_TRANS_DML NULL Backup lock 259 MDL_BACKUP_TRANS_DML NULL Backup lock 220 MDL_BACKUP_TRANS_DML NULL Backup lock 216 MDL_BACKUP_TRANS_DML NULL Backup lock 252 MDL_BACKUP_TRANS_DML NULL Backup lock 266 MDL_BACKUP_TRANS_DML NULL Backup lock 251 MDL_BACKUP_TRANS_DML NULL Backup lock 243 MDL_BACKUP_TRANS_DML NULL Backup lock 267 MDL_BACKUP_TRANS_DML NULL Backup lock 211 MDL_BACKUP_TRANS_DML NULL Backup lock 261 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line6 217 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line6 219 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line6 216 MDL_SHARED_READ NULL Table metadata lock sbtest order_line6 266 MDL_SHARED_READ NULL Table metadata lock sbtest order_line6 211 MDL_SHARED_READ NULL Table metadata lock sbtest order_line6 249 MDL_SHARED_WRITE NULL Table metadata lock sbtest stock7 267 MDL_SHARED_WRITE NULL Table metadata lock sbtest stock7 259 MDL_SHARED_READ NULL Table metadata lock sbtest history5 218 MDL_SHARED_WRITE NULL Table metadata lock sbtest stock3 241 MDL_SHARED_READ NULL Table metadata lock sbtest order_line4 239 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line4 262 MDL_SHARED_READ NULL Table metadata lock sbtest order_line4 212 MDL_SHARED_READ NULL Table metadata lock sbtest order_line4 252 MDL_SHARED_READ NULL Table metadata lock sbtest order_line4 243 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line4 236 MDL_SHARED_WRITE NULL Table metadata lock sbtest history7 220 MDL_SHARED_READ NULL Table metadata lock sbtest history7 241 MDL_SHARED_READ NULL Table metadata lock sbtest new_orders4 241 MDL_SHARED_WRITE NULL Table metadata lock sbtest orders4 235 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 231 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 226 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 237 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 260 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 230 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 265 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 253 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 258 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 254 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 214 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 263 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 213 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 238 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 232 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 257 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 210 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 256 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 229 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 245 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 223 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 250 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 209 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 234 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 227 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 221 MDL_SHARED_WRITE NULL Table metadata lock sbtest history3 242 MDL_SHARED_WRITE NULL Table metadata lock sbtest stock5 220 MDL_SHARED_WRITE NULL Table metadata lock sbtest customer7 259 MDL_SHARED_READ NULL Table metadata lock sbtest orders5 225 MDL_SHARED_WRITE NULL Table metadata lock sbtest history6 247 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line5 269 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line5 244 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line5 255 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line5 233 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line5 215 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line5 270 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line5 224 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line5 268 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line5 246 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line5 240 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line5 248 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line5 242 MDL_SHARED_READ NULL Table metadata lock sbtest order_line5 259 MDL_SHARED_WRITE NULL Table metadata lock sbtest customer5 262 MDL_SHARED_WRITE NULL Table metadata lock sbtest stock4 212 MDL_SHARED_WRITE NULL Table metadata lock sbtest stock4 252 MDL_SHARED_WRITE NULL Table metadata lock sbtest stock4 272 MDL_SHARED_WRITE NULL Table metadata lock sbtest orders3 249 MDL_SHARED_READ NULL Table metadata lock sbtest order_line7 267 MDL_SHARED_READ NULL Table metadata lock sbtest order_line7 228 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line3 264 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line3 271 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line3 272 MDL_SHARED_READ NULL Table metadata lock sbtest order_line3 222 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line3 218 MDL_SHARED_READ NULL Table metadata lock sbtest order_line3 251 MDL_SHARED_WRITE NULL Table metadata lock sbtest order_line3 272 MDL_SHARED_READ NULL Table metadata lock sbtest new_orders3 216 MDL_SHARED_WRITE NULL Table metadata lock sbtest stock6 266 MDL_SHARED_WRITE NULL Table metadata lock sbtest stock6 211 MDL_SHARED_WRITE NULL Table metadata lock sbtest stock6 220 MDL_SHARED_READ NULL Table metadata lock sbtest orders7 ----------
----------------------------------------------------------------------------+
146 rows in set (0.001 sec)
i was able to make it prepare with mariadb 10.5.9 and O_DSYNC
My only change since that Are :
upgrade to docker mariadb 10.5.10
[mysqld]
loose_innodb_undo_tablespaces=64
loose_innodb_undo_log_truncate=1
innodb_flush_method = 0_DIRECT
i'm refining to try to found out what change break the prepare
Attachments
Issue Links
- includes
-
MDEV-25801 DROP DATABASE very slow after innodb undo log truncate
- Closed
- is caused by
-
MDEV-23399 10.5 performance regression with IO-bound tpcc
- Closed
- relates to
-
MDEV-25800 DROP TABLE unnecessarily accesses .ibd file
- Stalled