Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

pt-table-checksum throwing error(Issuing rollback()) in Multi-threaded replication tests

Description

Hi Team , 

We are getting error while executing pt-table-checksum in our replication tests .

Please find below error for the same.

Issuing rollback() due to DESTROY without explicit disconnect() of DBD::mysql::db handle ;host=localhost;mysql_socket=/tmp/ps1.sock;mysql_read_default_group=client at /mnt/jenkins/workspace/test-ps-replication/repl-test/percona-toolkit-3.5.1/bin/pt-table-checksum line 5541.

Issue can be reproduced on Jenkins as well as manually with PT 3.5.1 although issue is intermittent.

Some points to be noted :

  1. We are getting error with PT 3.5.1 when executed with PS 8.0.31 and PS 8.0.30  but not with PT 3.5.0 .

  1. After drilling down we suspect issue started occurring after PT-2138 - fix tests for pt table checksum (#568) .

Test-Case is provided in description below , please connect with us if you need more details .

 

 

Environment

None

Activity

Show:

puneet.kaushik February 21, 2023 at 5:29 AM

Hi Team , 
I can observe same error in PS 5.7 with PT 3.5.1.
Thanks !

puneet.kaushik February 13, 2023 at 5:57 AM

Steps to reproduce: # git clone https://github.com/Percona-QA/percona-qa.git

  1. cd percona-qa

  2. mkdir repl-test 

  3. cd repl-test and Download PS and PT from below links 
    PS : wget https://downloads.percona.com/downloads/TESTING/ps-8.0.31-23/Percona-Server-8.0.31-23-Linux.x86_64.glibc2.17.tar.gz
    PT :  wget  https://downloads.percona.com/downloads/percona-toolkit/3.5.1/binary/tarball/percona-toolkit-3.5.1_x86_64.tar.gz

  4. cd ../

  5. ./ps-async-repl-test.sh --workdir=$PWD/repl-test --build-number=800 --testcase=mtr_test

Details

Assignee

Reporter

Priority

Components

Affects versions

Fix versions

Needs Review

No

Needs QA

Yes

Found by Automation

Yes

Time tracking

1d logged

Smart Checklist

Created February 13, 2023 at 5:09 AM
Updated February 29, 2024 at 8:40 PM

Flag notifications