Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-25773

sysbench-TPCC failed to prepare with extremely slow execution

    XMLWordPrintable

    Details

      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

        1. mystack2
          232 kB
        2. stack.dropdatabase
          154 kB
        3. stack.prepare
          550 kB

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              stephane@skysql.com VAROQUI Stephane
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: