| Bug #67139 | Reverse Enginering Bug in the MySQL Migration tool | ||
|---|---|---|---|
| Submitted: | 9 Oct 2012 0:37 | Modified: | 9 Nov 2012 13:53 |
| Reporter: | Brent Leavitt | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Workbench: Migration | Severity: | S2 (Serious) |
| Version: | 5.2.44 | OS: | Windows (Microsoft Windows 7 Home Premium Edition Service Pack 1 (build 7601), 64-bit) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | WBBugReporter | ||
[9 Oct 2012 2:36]
MySQL Verification Team
Thank you for the bug report. Please elaborate the migration process you tried, the source and destination server for example. Thanks.
[9 Oct 2012 3:56]
Brent Leavitt
I will attempt to elaborate as much as possible. Like I said, I'm fairly new to mysql work. As far as the source and destination databases are concerned, both were MySQL setups. The source was a Dreamhost database (not sure of the version). The destination was for temporary development on a GoDaddy database, MySQL client version: 5.5.23. I don't know that I can provide more information than that about the servers. What I did note about where the error occurred is that it appears to have gotten hung up on one of the processes setup on the database. The source database has three to five functions or processes setup on the MySQL server. I'm wondering if the script was having problems processing those. Not entirely sure if that was the problem or not. I'm afraid I can't offer more input than that.
[9 Oct 2012 13:53]
MySQL Verification Team
Please check for duplicate with bug: http://bugs.mysql.com/bug.php?id=66861 . Thanks.
[10 Nov 2012 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: Here's the print out information from the display panel when proceeding to the Reverse enginering step of the process: Reverse engineering triggers from loandr Reverse engineering stored procedures from loandr Reverse engineering functions from loandr - Retrieving function loandr.phonestrip... - Reverse engineering loandr.phonestrip... Traceback (most recent call last): File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\db_mysql_re_grt.py", line 310, in reverseEngineer grt.modules.MysqlSqlFacade.parseSqlScriptString(catalog, wrap_sql(wrap_routine_sql(sql), schema_name)) File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\db_mysql_re_grt.py", line 237, in wrap_routine_sql return "DELIMITER $$\n"+sql TypeError: cannot concatenate 'str' and 'NoneType' objects Traceback (most recent call last): File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\workbench\wizard_progress_page_widget.py", line 191, in thread_work self.func() File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\migration_schema_selection.py", line 160, in task_reveng self.main.plan.migrationSource.reverseEngineer() File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\migration.py", line 332, in reverseEngineer self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData) SystemError: TypeError("cannot concatenate 'str' and 'NoneType' objects"): error calling Python module function DbMySQLRE.reverseEngineer ERROR: Reverse engineer selected schemata: TypeError("cannot concatenate 'str' and 'NoneType' objects"): error calling Python module function DbMySQLRE.reverseEngineer Failed ----- Developer Notes ----- MySQL Workbench CE for Windows version 5.2.44 revision 9933 Configuration Directory: C:\Users\Brent\AppData\Roaming\MySQL\Workbench Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE Cairo Version: 1.8.8 OS: Microsoft Windows 7 Home Premium Edition Service Pack 1 (build 7601), 64-bit CPU: 8x Intel(R) Core(TM) i7-2670QM CPU @ 2.20GHz, 7.8 GiB RAM Active video adapter (1): Intel(R) HD Graphics Family Installed video RAM: -175 MB Current video mode: 1366 x 768 x 4294967296 colors Used bit depth: 32 Driver version: 8.15.10.2462 Installed display drivers: igdumd64.dll,igd10umd64.dll,igd10umd64.dll,igdumdx32,igd10umd32,igd10umd32 Current user language: English (United States) How to repeat: In preparing to migrate the database from one location to the other, the automated process of reverse engineering returned an error message making it impossible for me to proceed. As I'm not familiar enough with the databases that I'm migrating (I just starting working on a new project and am trying to setup a test environment.) I'm not sure what caused this. I do not have access to the source database via phpMyAdmin or any other sort of tool, and I'm not that proficient in commandline interfaces.