Percona Server with XtraDB

dict_store_statistics() should commit mtr for each record's update

Reported by Yasufumi Kinoshita on 2011-06-01
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Medium
Unassigned
5.1
Undecided
Unassigned
5.5
Medium
Unassigned

Bug Description

dict_store_statistics() (called when innodb_use_sys_stats_table is enabled)
updates several records in SYS_STATS on 1 mtr.

But, "btr_pcur_move_to_next_user_rec(&pcur, &mtr);" might release the x_lock of the block and might cause problem.

So, need
"
mtr_commit(&mtr);
mtr_start(&mtr);
btr_pcur_restore_position(BTR_MODIFY_LEAF, &pcur, &mtr);
"
for each change.

Changed in percona-server:
assignee: nobody → Yasufumi Kinoshita (yasufumi-kinoshita)
importance: Undecided → Medium
status: New → Confirmed
Changed in percona-server:
status: Confirmed → Fix Committed
Stewart Smith (stewart) on 2011-06-20
Changed in percona-server:
milestone: none → 5.5.13-20.4
Alexey Kopytov (akopytov) wrote :

In 5.1 the fix was released in 5.1.57-12.8. Updating the target milestone accordingly.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers