exceptions.Exception sequence item 0: expected string, long found

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Run an online alter table

What is the expected output? What do you see instead?

-- Attempting to lock tables

-- Tables locked WRITE
-- id (min, max) values: ([1L], [66514986L])
-- Tables unlocked
exceptions.Exception sequence item 0: expected string, long found
-- ERROR: Errors found. Initiating cleanup
-- Tables unlocked

What version of the product are you using? On what operating system?

openark-kit-170-1.noarch.rpm on CentOS 5.4

Please provide any additional information below.

MySQL 5.5.8, python 2.4.3, MySQL-python.x86_64 1.2.1-1 

Original issue reported on code.google.com by gha...@gmail.com on 18 Jan 2011 at 12:28

[GoogleCodeExporter]

oak-online-alter-table is currently "on hold", and will possibly become 
obsolete. See derived work from Facebook: Online Schema Change.
At current I'm not putting work into oak-online-alter-table unless otherwise 
convinced it has demand.

Original comment by shlomi.n...@gmail.com on 30 Jan 2011 at 6:46

• Changed state: WontFix

[GoogleCodeExporter]

I evaluated Facebook's OSC, but there were quite a few shortcoming which cause 
me to not be able to use it. First off it's in PHP, so changes or fixes mean I 
have to use PHP. Aside from that, there are no tests, OSC was only tested on 
5.1.47 and 5.0.84, and I'm running 5.5.8. Also importantly, column name changes 
or drops are not supported and the first migration I wanted to perform was a 
drop.

Original comment by gha...@gmail.com on 30 Jan 2011 at 1:23

[GoogleCodeExporter]

Fix for this problem is simple, just replace:
verbose("%s range (%s), (%s), %s" % (description, ",".join("%s" % val for val 
in unique_key_range_start_values), ",".join(unique_key_range_end_values), 
get_progress_and_eta_presentation(elapsed_times, elapsed_time, ratio_complete)))

with:
verbose("%s range (%s), (%s), %s" % (description, ",".join("%s" % val for val 
in unique_key_range_start_values), ",".join("%s" % val for val in 
unique_key_range_end_values), get_progress_and_eta_presentation(elapsed_times, 
elapsed_time, ratio_complete)))

Original comment by sarunas....@gmail.com on 8 Feb 2011 at 1:13

[GoogleCodeExporter]

Thank you. This is now fixed in revision 177 (not yet release)
you may directly download the source code from 
[http://code.google.com/p/openarkkit/source/browse/#svn%2Ftrunk%2Fopenarkkit%2Fs
rc%2Foak]

Original comment by shlomi.n...@gmail.com on 16 Feb 2011 at 7:07

• Changed state: Fixed