Bug #70791 error in mysqldbcopy (MySQL workbench Utilities)

• Submitted: 31 Oct 2013 15:13
• Modified: 13 Jan 2015 8:21
• Reporter: Wendy Tao
• Status: Can't repeat
• Category: MySQL Utilities
• Severity: S3 (Non-critical)
• Version: MySQL Utilities Client version 1.3.4
• OS: Windows (Windows 7)
• CPU Architecture: Any
• Tags: Utility Version 1.3.4 form MySQL Workbench 6.0 on window 7

[31 Oct 2013 15:13] Wendy Tao

Description:

mysqldbcopy received the following error (see private comments).

How to repeat:
Table dump file is available.

[1 Nov 2013 17:02] Chuck Bell

How to repeat:

1) create this table:

CREATE TABLE `t1` (
  `a` int(11) NOT NULL AUTO_INCREMENT,
  `b` text,
  PRIMARY KEY (`a`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1

2) insert a row:

insert into t1 values (null, 'test');

3) run the utility:

$ python ./scripts/mysqldbcopy.py --source=root@localhost:13001 --destination=root@localhost:13002 test_blob:test_blob -vvv --force
# Source on localhost: ... connected.
# Destination on localhost: ... connected.

...

# Copying TABLE test_blob.t1
CREATE TABLE `t1` (
  `a` int(11) NOT NULL AUTO_INCREMENT,
  `b` text,
  PRIMARY KEY (`a`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
# Copying data for TABLE test_blob.t1
Traceback (most recent call last):
  File "./scripts/mysqldbcopy.py", line 274, in <module>
    dbcopy.copy_db(source_values, dest_values, db_list, options)
  File "/Volumes/Macintosh_Data/cbell/source/bzr_public/review-nuno/mysql/utilities/command/dbcopy.py", line 381, in copy_db
    options.get("threads", False))
  File "/Volumes/Macintosh_Data/cbell/source/bzr_public/review-nuno/mysql/utilities/common/database.py", line 753, in copy_data
    tbl.copy_data(self.destination, self.cloning, new_db, connections)
  File "/Volumes/Macintosh_Data/cbell/source/bzr_public/review-nuno/mysql/utilities/common/table.py", line 809, in copy_data
    p = self.insert_rows(rows, new_db, destination, num_conn > 1)
  File "/Volumes/Macintosh_Data/cbell/source/bzr_public/review-nuno/mysql/utilities/common/table.py", line 761, in insert_rows
    self._bulk_insert(rows, new_db, destination)
  File "/Volumes/Macintosh_Data/cbell/source/bzr_public/review-nuno/mysql/utilities/common/table.py", line 718, in _bulk_insert
    dest.exec_query(blob_insert[0] % "%r" % blob_insert[1],
TypeError: not all arguments converted during string formatting

[6 Nov 2013 11:35] MySQL Verification Team

Thank you for the bug report.

C:\Program Files (x86)\MySQL\MySQL Utilities 1.3.4>mysqldbcopy --source=root@localhost:3550 --destination=root@localhost:3560 test_blob:test_blob -vvv --force
# Source on localhost: ... connected.
# Destination on localhost: ... connected.
# Copying database test_blob renamed as test_blob
# Dropping new object TABLE test_blob.t1
# Copying TABLE test_blob.t1
CREATE TABLE `t1` (
  `a` int(11) NOT NULL AUTO_INCREMENT,
  `b` text,
  PRIMARY KEY (`a`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
# Copying data for TABLE test_blob.t1
Traceback (most recent call last):
  File "C:\Python27\lib\site-packages\cx_Freeze\initscripts\Console.py", line 27, in <module>
  File "scripts\mysqldbcopy.py", line 275, in <module>
  File ".\mysql\utilities\command\dbcopy.py", line 381, in copy_db
  File ".\mysql\utilities\common\database.py", line 713, in copy_data
  File ".\mysql\utilities\common\table.py", line 821, in copy_data
  File ".\mysql\utilities\common\table.py", line 772, in insert_rows
  File ".\mysql\utilities\common\table.py", line 728, in _bulk_insert
TypeError: not all arguments converted during string formatting