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: | |
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
[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".