pt-table-checksum "Deep recursion..." error

  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-table-checksum "Deep recursion..." error

    I am trying to run the latest pt-table-checksum on a MySQL 5.0.67 server (Cent 5.5) and I receive the following error:

    Deep recursion on subroutine "SchemaIterator::_iterate_dbh" at /usr/bin/pt-table-checksum line 6927.

    I am using pt-table-checksum as follows:

    pt-table-checksum h=localhost,u=user,p=password --no-check-replication-filters --lock-wait-time=120 --recursion-method=dsn=D=percona,t=dsns --tables database.table

    I'm not sure what to do. Google didn't really help me on this one.

  • #2

    I've tested it locally but I'm not getting above error. As per your commandline, I'm assuming that you want to compare your master server with specific slave (you must have more slaves with one master). Have you created dsns table on percona DB and add DSN entry in that table? If not, then can you do it first?


    CREATE TABLE `dsns` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) DEFAULT NULL, `dsn` varchar(255) NOT NULL, PRIMARY KEY (`id`));INSERT INTO dsns (dsn) VALUES ("-h127.0.0.1,u=user,p=pass,P=port"); -- here details should be of slave which you want to compare.

    You can get more information here

    http://www.percona.com/doc/percona-toolkit/2.1/pt-table-chec ksum.html#cmdoption-pt-table-checksum--recursion-method
    And then try again to run above command for checksum.



    • #3
      I did that part, although I only add the host and port since I have some slaves on non-standard ports. I didn't add an entry with username and password, or entries for slaves with a standard port.