Bug #72608 Unable to alter table with Mysql workbench
Submitted: 10 May 2014 17:57 Modified: 21 Jun 2015 11:03
Reporter: Fobus Turfanda Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.1.7 and 6.2.3 OS:Linux (Linux Mint 17 Qiana 64 Bit)
Assigned to: CPU Architecture:Any
Tags: ALTER TABLE, MySQL, sql editor, workbench

[10 May 2014 17:57] Fobus Turfanda 
Description:
I was using Mysql Query Browser and Mysql Administrator recently. But after I have updated my system they have replaced with Mysql Workbench. When I try to "Alter table" I'm getting the error below:

--------------
Error Parsing DDL for `taurus`.`Pages`
There was an error while parsing the DDL retrieved from the server.
Do you want to view the DDL or cancel processing it?
--------------

Here is the DDL for Pages

------

delimiter $$

CREATE TABLE `Pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `page_category_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci$$

-------------

This error occurs except of only one table, here is it's create code.

------------

delimiter $$

CREATE TABLE `Accounts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(120) NOT NULL,
  `password_hash` varchar(40) NOT NULL,
  `salt` varchar(7) NOT NULL,
  `last_login` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `roles` text NOT NULL,
  `name` varchar(40) NOT NULL,
  `surname` varchar(40) NOT NULL,
  `lang` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8$$

----------

I have tried with Mysql Workbench 5.2.47 and the lastest version 6.1.4 but both version shows the same error message.

How to repeat:
I'm right clicking on the table and clicking on "alter table" then the error occurs above.
[10 May 2014 21:52] MySQL Verification Team 
Please try version 6.1.4. Thanks.
[10 May 2014 21:53] MySQL Verification Team 
Please disregard my prior now noticed you already tested 6.1.4.
[10 May 2014 22:04] MySQL Verification Team 
Pages table

Attachment: 0_pages.png (image/png, text), 35.26 KiB.
[10 May 2014 22:05] MySQL Verification Team 
I couldn't repeat on Windows 7 Ultimate 64_bits. Which OS version are you using and MySQL server version. See attached picture showing the alter table screen.
[11 May 2014 20:50] Fobus Turfanda 
Hello, I'm trying it on Linux Mint 16.

I'm attaching a screen shot for 5.2.47 but the same errors occurs on 6.1.4
[11 May 2014 20:51] Fobus Turfanda 
Here is a screen shot for version 5.2.47, the same error appears.

Attachment: Ekran Görüntüsü - 2014-05-11 23:48:48.png (image/png, text), 165.83 KiB.
[11 May 2014 20:54] Fobus Turfanda 
Here is a working alter table example.

Attachment: Works.png (image/png, text), 147.18 KiB.
[11 Jun 2014 1:04] Fobus Turfanda 
Are there any update about this issue?
[11 Jun 2014 1:59] MySQL Verification Team 
Please try version 6.1.6. Thanks.
[12 Jun 2014 19:52] Fobus Turfanda 
I have installed 6.1.6 but there is the same problem.

Here is the configuration output
MySQL Workbench Community (GPL) for Linux/Unix version 6.1.6  revision 11834 build 1642
Configuration Directory: /home/myusername/.mysql/workbench
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.12.16
OS: Linux 3.11.0-12-generic
CPU: 2x Intel(R) Pentium(R) CPU B950 @ 2.10GHz (800.000MHz) - 5,74GiB RAM
Distribution: Linux Mint 16 Petra
[12 Jun 2014 20:04] Fobus Turfanda 
Here is the log file that I found:

23:01:25 [INF][      WBContext]: Parsing application arguments.
23:01:25 [INF][      WBContext]:     /usr/bin/mysql-workbench-bin
23:01:25 [INF][   base library]: Notification GNUIFormCreated is not registered
23:01:25 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: /usr/share/mysql-workbench
	plugin path: /usr/lib/mysql-workbench/plugins
	struct path: /usr/share/mysql-workbench/grt
	module path: /usr/lib/mysql-workbench/modules
	library path: /usr/share/mysql-workbench/libraries
	user data dir: /home/kervan/.mysql/workbench
	open at start: 
	open type: 
	run at startup: 
	run type: 
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
23:01:25 [INF][      WBContext]: WbContext::init
23:01:26 [INF][            WBA]: Looking for extension modules for WBA...
23:01:26 [INF][            WBA]: 0 extension modules found
23:01:26 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Linux/Unix version 6.1.6  revision 11834 build 1642
	Configuration Directory: /home/kervan/.mysql/workbench
	Data Directory: /usr/share/mysql-workbench
	Cairo Version: 1.12.16
	OS: Linux 3.11.0-12-generic
	CPU: 2x Intel(R) Pentium(R) CPU B950 @ 2.10GHz (800.000MHz) - 5,74GiB RAM
	Distribution: Linux Mint 16 Petra

23:01:26 [INF][   base library]: Notification GNUIFormCreated is not registered
23:01:26 [INF][               ]: /usr/share/mysql-workbench/extras
23:01:26 [ERR][       WBModule]: stderr from process list 
23:01:35 [INF][   base library]: Notification GNUIFormCreated is not registered
23:01:35 [WRN][            grt]: in {A5902515-6F35-469A-861E-9C6A331731FE}: unserialized XML contains invalid member db.mysql.Routine::oldModelSqlDefinitionin {A5902515-6F35-469A-861E-9C6A331731FE}: unserialized XML contains invalid member db.mysql.Routine::oldServerSqlDefinitionin {26DE0377-A2B4-455D-976D-ECE29FAF9CE9}: unserialized XML contains invalid member db.mysql.Routine::oldModelSqlDefinitionin {26DE0377-A2B4-455D-976D-ECE29FAF9CE9}: unserialized XML contains invalid member db.mysql.Routine::oldServerSqlDefinitionin {AE731A4C-253B-42F1-9E35-30C85E238DE2}: unserialized XML contains invalid member db.mysql.Routine::oldModelSqlDefinitionin {AE731A4C-253B-42F1-9E35-30C85E238DE2}: unserialized XML contains invalid member db.mysql.Routine::oldServerSqlDefinitionin {38CEC99E-B89B-4CDD-828A-19F45A08284C}: unserialized XML contains invalid member db.mysql.Routine::oldModelSqlDefinitionin {38CEC99E-B89B-4CDD-828A-19F45A08284C}: unserialized XML contains invalid member db.mysql.Routine::oldServerSqlDefinitionin {0CFEF5BF-2C28-425E-AB51-0C079F326667}: unserialized XML contains invalid member db.mysql.Routine::oldModelSqlDefinitionin {0CFEF5BF-2C28-425E-AB51-0C079F326667}: unserialized XML contains invalid member db.mysql.Routine::oldServerSqlDefinitionin {18A78AF0-0F0E-4467-AC7E-8BD8436B27DF}: unserialized XML contains invalid member db.mysql.Routine::oldModelSqlDefinitionin {18A78AF0-0F0E-4467-AC7E-8BD8436B27DF}: unserialized XML contains invalid member db.mysql.Routine::oldServerSqlDefinitionin {2C9D3253-3556-4555-9EFB-E14D547B7C98}: unserialized XML contains invalid member db.mysql.Trigger::oldModelSqlDefinitionin {2C9D3253-3556-4555-9EFB-E14D547B7C98}: unserialized XML contains invalid member db.mysql.Trigger::oldServerSqlDefinitionin {4FA3013F-A1E4-4AE2-9208-2C9A68ACB7E2}: unserialized XML contains invalid member db.mysql.Trigger::oldModelSqlDefinitionin {4FA3013F-A1E4-4AE2-9208-2C9A68ACB7E2}: unserialized XML contains invalid member db.mysql.Trigger::oldServerSqlDefinitionin {AFE2EF2B-730D-42DB-AC43-37C4F747C25F}: unserialized XML contains invalid member db.mysql.Trigger::oldModelSqlDefinitionin {AFE2EF2B-730D-42DB-AC43-37C4F747C25F}: unserialized XML contains invalid member db.mysql.Trigger::oldServerSqlDefinitionNotification GNUIFormCreated is not registered
23:02:00 [INF][   base library]: Notification GNFocusChanged is not registered
23:02:00 [INF][   base library]: Notification GNFocusChanged is not registered
23:02:01 [INF][     SSH tunnel]: Starting tunnel
23:02:01 [INF][   base library]: Notification GNUIFormCreated is not registered
23:02:01 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: NO)
23:02:01 [INF][     AutoCCache]: Initializing autocompletion cache for Local_instance_3306
23:02:02 [ERR][   mforms.linux]: Passed MenuItem 'Don't Limit' does not have CheckMenuItem at 0x4e2d230
23:02:02 [ERR][   mforms.linux]: Passed MenuItem '10' does not have CheckMenuItem at 0x4e21370
23:02:02 [ERR][   mforms.linux]: Passed MenuItem '50' does not have CheckMenuItem at 0x4e2d650
23:02:02 [ERR][   mforms.linux]: Passed MenuItem '100' does not have CheckMenuItem at 0x4e2c670
23:02:02 [ERR][   mforms.linux]: Passed MenuItem '200' does not have CheckMenuItem at 0x4dfe6e0
23:02:02 [ERR][   mforms.linux]: Passed MenuItem '300' does not have CheckMenuItem at 0x4ddc750
23:02:02 [ERR][   mforms.linux]: Passed MenuItem '400' does not have CheckMenuItem at 0x4b90c50
23:02:02 [ERR][   mforms.linux]: Passed MenuItem '500' does not have CheckMenuItem at 0x4e43be0
23:02:02 [ERR][   mforms.linux]: Passed MenuItem '1000' does not have CheckMenuItem at 0x4e11c40
23:02:02 [ERR][   mforms.linux]: Passed MenuItem '2000' does not have CheckMenuItem at 0x4e42fb0
23:02:02 [ERR][   mforms.linux]: Passed MenuItem '5000' does not have CheckMenuItem at 0x4e358f0
23:02:02 [ERR][   mforms.linux]: Passed MenuItem '10000' does not have CheckMenuItem at 0x4e40000
23:02:02 [ERR][   mforms.linux]: Passed MenuItem '50000' does not have CheckMenuItem at 0x4b91ed0
23:02:02 [INF][   base library]: Notification GNFormTitleDidChange is not registered
23:02:09 [INF][   base library]: Notification GNUIFormCreated is not registered
23:02:16 [WRN][SqlEditorSchemaTree]: Error parsing DDL for mydb.Categories: delimiter $$

CREATE TABLE `Categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `top_id` int(11) NOT NULL,
  `url` varchar(255) NOT NULL,
  `title` text NOT NULL,
  `subtitle` text NOT NULL,
  `content` text NOT NULL,
  `description` text NOT NULL,
  `keywords` text NOT NULL,
  `order` int(11) NOT NULL DEFAULT '0',
  `code` varchar(55) NOT NULL,
  `style_code` varchar(55) NOT NULL,
  `link_to` int(11) NOT NULL DEFAULT '0',
  `bg_image` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=430 DEFAULT CHARSET=utf8$$

23:02:19 [INF][   base library]: Notification GNUIFormDestroyed is not registered
[21 Jul 2014 18:08] Fobus Turfanda 
Are there any update about this issue?
[8 Sep 2014 13:15] MySQL Verification Team 
Please try Development Releases 6.2.2 rc version. Thanks.
[9 Oct 2014 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".
[18 Oct 2014 1:10] Fobus Turfanda 
Hello,

Now I'm sure that this error occurs on Linux Mint. 

I have reinstalled my linux, then installed Mysql Workbench 6.2.3 it was buggy. Then I have downgraded to 6.1.7 it is buggy too.

Also, this thread didn't fix my problem : http://bugs.mysql.com/bug.php?id=64741
[21 May 2015 11:03] MySQL Verification Team 
Please try version 6.3.3. Thanks.
[22 Jun 2015 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".