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

sysbench-TPCC failed to prepare with extremely slow execution

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

            And the prepare freeze stack.prepare

            stephane@skysql.com VAROQUI Stephane added a comment - And the prepare freeze stack.prepare
            marko Marko Mäkelä added a comment - - edited

            For the initially reported problem, stack.prepare suggests that the problem is due to a huge buf_pool.flush_list that is being scanned in buf_flush_dirty_pages() while holding buf_pool.flush_list_mutex. That code was refactored in MDEV-23399.

            In most callers, we are not be interested in the count that is returned by buf_flush_dirty_pages(), and we could abort the scan on the first match. But still, if the first dirty pages for the tablespace would be noticed somewhere deep inside the list, we spend a lot of time scanning the list. Possibly we will have to implement a special version of buf_flush_lists() that would only process the pages of the requested tablespace, like the code was before MDEV-23399.

            I tried to debug stack.dropdatabase further, but I could not determine which thread would be holding buf_pool.flush_list_mutex, nor was I able to find anything wrong with the usage of that mutex. Also the buf_flush_page_cleaner thread is waiting for that mutex. I hope that you can reproduce and file a separate bug, providing the output of thread apply all backtrace and print buf_pool.flush_list_mutex from a new hang.

            marko Marko Mäkelä added a comment - - edited For the initially reported problem, stack.prepare suggests that the problem is due to a huge buf_pool.flush_list that is being scanned in buf_flush_dirty_pages() while holding buf_pool.flush_list_mutex . That code was refactored in MDEV-23399 . In most callers, we are not be interested in the count that is returned by buf_flush_dirty_pages() , and we could abort the scan on the first match. But still, if the first dirty pages for the tablespace would be noticed somewhere deep inside the list, we spend a lot of time scanning the list. Possibly we will have to implement a special version of buf_flush_lists() that would only process the pages of the requested tablespace, like the code was before MDEV-23399 . I tried to debug stack.dropdatabase further, but I could not determine which thread would be holding buf_pool.flush_list_mutex , nor was I able to find anything wrong with the usage of that mutex. Also the buf_flush_page_cleaner thread is waiting for that mutex. I hope that you can reproduce and file a separate bug, providing the output of thread apply all backtrace and print buf_pool.flush_list_mutex from a new hang.

            Based on the additional information in MDEV-25801, I do not think that this is a genuine hang, but extremely slow execution (basically, buf_pool.flush_list_mutex contention due to an O(n²) algorithm).

            marko Marko Mäkelä added a comment - Based on the additional information in MDEV-25801 , I do not think that this is a genuine hang, but extremely slow execution (basically, buf_pool.flush_list_mutex contention due to an O(n²) algorithm).

            While rewriting all DROP code for MDEV-25506 today, I concluded that ever since the page flushing logic was rewritten in MDEV-23855, buf_flush_remove_pages() only needs to be called in ALTER TABLE…DISCARD TABLESPACE, but not for any other DDL. Actually, it should suffice to call that in IMPORT TABLESPACE when the tablespace is being imported with a tablespace ID that belongs to a previously discarded tablespace whose pages are still located in the buffer pool.

            For undo tablespace truncation, it should be best to rewrite buf_flush_dirty_pages() so that it will ‘push down’ a tablespace ID filter, to avoid ‘collateral damage’ of writing out any pages of other tablespaces.

            marko Marko Mäkelä added a comment - While rewriting all DROP code for MDEV-25506 today, I concluded that ever since the page flushing logic was rewritten in MDEV-23855 , buf_flush_remove_pages() only needs to be called in ALTER TABLE…DISCARD TABLESPACE , but not for any other DDL. Actually, it should suffice to call that in IMPORT TABLESPACE when the tablespace is being imported with a tablespace ID that belongs to a previously discarded tablespace whose pages are still located in the buffer pool. For undo tablespace truncation, it should be best to rewrite buf_flush_dirty_pages() so that it will ‘push down’ a tablespace ID filter, to avoid ‘collateral damage’ of writing out any pages of other tablespaces.

            I think that the reported performance regression must have been fixed in MDEV-25801.

            marko Marko Mäkelä added a comment - I think that the reported performance regression must have been fixed in MDEV-25801 .

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.