Percona Server moved to https://jira.percona.com/projects/PS

Bug #1721753
Comment #5

Comment 5 for bug 1721753

Revision history for this message

Daniel Rupp (rupp.riege.com) wrote on 2017-11-06: Re: Query result changed between 5.6.36-82.0 and 5.6.36-82.1

Ok i was able to test a bit and i don´t think that 5.6.36-82.0 or 2.6.37-82.2 are different, so lets just go with the most recent one.

I built a test-case that can be re-run a couple of times. I´m seeing different behavior over a couple of runs, so be sure to try this at least 10-15 times. Also let the script run till it did the queries at least 15 times.

My observation is that one of two things happen:
- it will show no result on the first query and results for #2 & #3 from the start and stay that way
- it will show NO results on all queries and suddenly at the 10th try it will start showing results on all three queries

Hopefully you can reproduce this and maybe explain.

Test setup:
RHEL6.7.z
Percona-Server-shared-56-5.6.37-rel82.2.el6.x86_64
Percona-Server-shared-51-5.1.73-rel14.12.625.rhel6.x86_64
Percona-Server-client-56-5.6.37-rel82.2.el6.x86_64
Percona-Server-server-56-5.6.37-rel82.2.el6.x86_64

Default install - default my.cnf, no changes, single server only

[<email address hidden> ~]$ cat testscript.sh
service mysql stop
rm -rf /var/lib/mysql/*
mysql_install_db --user=mysql
service mysql start
mysql test < /root/mad_partner-anonymized.sql
COUNT=1
while true; do
    echo $COUNT
    bash testquery.sh
    sleep 1
    COUNT=$(($COUNT + 1))
done
[<email address hidden> ~]$ cat testquery.sh
#!/bin/bash

mysql -vvv test -e"SELECT DISTINCT partner0_.organizationOID AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN (
'be067ca5-6cd3-42dc-8a68-a08e9800b195',
'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab',
'8c1fb1ae-25e2-49f8-bb6a-65b5716d0d2b',
'7a090a98-08ec-4924-ac1a-d4b45c749cac',
'83031acb-43cd-4c97-963e-8692a007aba5');"

mysql -vvv test -e"SELECT DISTINCT partner0_.organizationOID AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN (
'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab',
'7a090a98-08ec-4924-ac1a-d4b45c749cac',
'be067ca5-6cd3-42dc-8a68-a08e9800b195');"

mysql -vvv test -e"SELECT DISTINCT partner0_.organizationOID AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN (
'8c1fb1ae-25e2-49f8-bb6a-65b5716d0d2b',
'83031acb-43cd-4c97-963e-8692a007aba5');"
[<email address hidden> ~]$ bash testscript.sh

Ok i was able to test a bit and i don´t think that 5.6.36-82.0 or 2.6.37-82.2 are different, so lets just go with the most recent one.

Hopefully you can reproduce this and maybe explain.

Default install - default my.cnf, no changes, single server only

[root@db3.dev ~]$ cat testscript.sh 
service mysql stop
rm -rf /var/lib/mysql/*
mysql_install_db --user=mysql
service mysql start
mysql test < /root/mad_partner-anonymized.sql 
COUNT=1
while true; do
    echo $COUNT
    bash testquery.sh 
    sleep 1
    COUNT=$(($COUNT + 1))
done
[root@db3.dev ~]$ cat testquery.sh 
#!/bin/bash

mysql -vvv test -e"SELECT DISTINCT partner0_.organizationOID AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN (
	'be067ca5-6cd3-42dc-8a68-a08e9800b195',
	'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab',
	'8c1fb1ae-25e2-49f8-bb6a-65b5716d0d2b',
	'7a090a98-08ec-4924-ac1a-d4b45c749cac',
	'83031acb-43cd-4c97-963e-8692a007aba5');"

mysql -vvv test -e"SELECT DISTINCT partner0_.organizationOID AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN (
	'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab',
	'7a090a98-08ec-4924-ac1a-d4b45c749cac',
	'be067ca5-6cd3-42dc-8a68-a08e9800b195');"

mysql -vvv test -e"SELECT DISTINCT partner0_.organizationOID AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN (
	'8c1fb1ae-25e2-49f8-bb6a-65b5716d0d2b',
        '83031acb-43cd-4c97-963e-8692a007aba5');"
[root@db3.dev ~]$ bash testscript.sh