Bug #68780 mysqldbcompare TypeError
Submitted: 26 Mar 2013 16:17 Modified: 10 May 2013 13:21
Reporter: Marco Molinaro Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Utilities Severity:S1 (Critical)
Version:5.2.47 OS:Any (Windows7 and Linux CentOS6)
Assigned to: CPU Architecture:Any
Tags: Failure, mysqldbcompare

[26 Mar 2013 16:17] Marco Molinaro
Description:
Trying to compare to schemas having different name, on the same server, with identical schema model (i.e. only schema name and data records are different) the mysqldbcompare exits with the following:

Traceback (most recent call last):
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\utilities\scripts\mysqldbcompare.py", line 164, in <module>
    parts[0], parts[1], options)
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\python\mysql_libs.zip\mysql\utilities\command\dbcompare.py", line 465, in da
tabase_compare
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\python\mysql_libs.zip\mysql\utilities\command\dbcompare.py", line 306, in _c
heck_data_consistency
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\python\mysql_libs.zip\mysql\utilities\common\dbcompare.py", line 858, in che
ck_consistency
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\python\mysql_libs.zip\mysql\utilities\common\sql_transform.py", line 179, in
 transform_data
  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\python\mysql_libs.zip\mysql\utilities\common\sql_transform.py", line 128, in
 build_set_clauses
TypeError: object of type 'NoneType' has no len()
Unable to start mysqldbcompare, please verify that your installation is correct

It seems strange I'm "Unable to start mysqldbcompare" since I'm running it.
I think it's a python code bug since I reproduced it on a virtual linux centos6 machine on the same dbs.

How to repeat:
My command line is

mysqldbcompare --server1=user:pwd@localhost --server2=user:pwd@localhost -a --skip-object-compare --skip-diff --difftype=sql --changes-for=server1 rr:rr_refresh
[28 Mar 2013 19:48] Chuck Bell
Thank you for the bug report. Unfortunately, we are unable to reproduce this defect. 

Please provide the layout for the table rr and an estimate for the number of rows in the table.

Also, please provide the result of this command:

mysqldbcompare --version

Thank you.
[10 May 2013 13:21] Chuck Bell
Cannot repeat - not enough information. Please reopen bug report after testing with latest release-1.2.2 and please provide more detail for reproducing the error including the command used to start the utility and the complete output listing. If data related, a summary of the data format/content would also help to diagnose and repair the defect.