kill_long_selects still unstable

Bug #1326224 reported by Alexey Kopytov
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Fix Released
Low
Sergei Glushchenko
2.1
Fix Released
Low
Sergei Glushchenko
2.2
Fix Released
Low
Sergei Glushchenko

Bug Description

The kill_long_selects.sh test is still unstable even after the fix for bug #1214274. See, for example, http://jenkins.percona.com/view/PXB%202.2/job/percona-xtrabackup-2.2-param/150/

It seems to be specific to CentOS 5 slaves.

Related branches

Revision history for this message
Sergei Glushchenko (sergei.glushchenko) wrote :

Related code

bg_run bg_select_pid "mysql_select 200"
bg_run bg_update_pid "sleep 1" "mysql_update 5"

innobackupex $topdir/full --kill-long-queries-timeout=3 \
                          --kill-long-query-type=select

bg_wait_fail $bg_select_pid
bg_wait_ok $bg_update_pid

select apparently started after innobackupex proceeded with backup, so it was not killed as expected.
All failures happened at the same place.

I'll fix it by inserting delay after

bg_run bg_select_pid "mysql_select 200"

Revision history for this message
Sergei Glushchenko (sergei.glushchenko) wrote :

With this delay test still unstable, probably better synchronization needed.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-914

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

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.