| Bug #89350 | Error using ALTER TABLE... Menu | ||
|---|---|---|---|
| Submitted: | 22 Jan 2018 21:13 | Modified: | 23 Jan 2018 9:00 |
| Reporter: | Geraldo Santo | Email Updates: | |
| Status: | Unsupported | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 6.3.10 | OS: | Windows (Microsoft Windows 10 Pro) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | WBBugReporter | ||
[23 Jan 2018 1:25]
MySQL Verification Team
Please try version 6.3.10.
[23 Jan 2018 8:53]
Geraldo Santo
Thansk for quick response. We upgrade Workbench to 6.3.10 and we continue with the same problem, here are the wb.lob. ================================================================== 06:49:29 [ERR][ Workbench]: Console redirection failed. 06:49:29 [INF][ Workbench]: Starting up Workbench 06:49:29 [INF][ Workbench]: Current environment: Command line: "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe" CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE HasShutdownStarted: False OSVersion: Microsoft Windows NT 6.2.9200.0 SystemDirectory: C:\WINDOWS\system32 TickCount: 459396859 UserInteractive: True Version: 4.0.30319.42000 WorkingSet: 35631104 06:49:29 [INF][ Workbench]: Environment variables: COMPUTERNAME = MARTE USERPROFILE = C:\Users\Geraldo HOMEPATH = \Users\Geraldo LOCALAPPDATA = C:\Users\Geraldo\AppData\Local asl.log = Destination=file PSModulePath = C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\ PROCESSOR_ARCHITECTURE = AMD64 Path = C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\OpenVPN\bin;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\Oberthur Technologies\AWP\Dlls;C:\Program Files\Oberthur Technologies\AWP\Dlls;C:\Program Files\Amazon\AWSCLI\;C:\Program Files (x86)\Skype\Phone\;C:\Program Files\PuTTY\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\dotnet\;C:\Program Files\Git\cmd;C:\Program Files\nodejs\;C:\Users\Geraldo\AppData\Local\Microsoft\WindowsApps;C:\Program Files (x86)\Microsoft VS Code\bin;C:\Program Files\MySQL\MySQL Server 5.7\bin;C:\Users\Geraldo\AppData\Roaming\npm; CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files ProgramFiles(x86) = C:\Program Files (x86) PROCESSOR_LEVEL = 6 windows_tracing_flags = 3 LOGONSERVER = \\MARTE PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC HOMEDRIVE = C: SystemRoot = C:\WINDOWS PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 37 Stepping 5, GenuineIntel SESSIONNAME = Console ALLUSERSPROFILE = C:\ProgramData PUBLIC = C:\Users\Public FP_NO_HOST_CHECK = NO APPDATA = C:\Users\Geraldo\AppData\Roaming PROCESSOR_REVISION = 2505 USERNAME = Geraldo CommonProgramW6432 = C:\Program Files\Common Files TEMP = C:\Users\Geraldo\AppData\Local\Temp OneDrive = C:\Users\Geraldo\OneDrive CommonProgramFiles = C:\Program Files\Common Files OS = Windows_NT USERDOMAIN_ROAMINGPROFILE = MARTE FPS_BROWSER_APP_PROFILE_STRING = Internet Explorer ComSpec = C:\WINDOWS\system32\cmd.exe SystemDrive = C: FPS_BROWSER_USER_PROFILE_STRING = Default ProgramFiles = C:\Program Files NUMBER_OF_PROCESSORS = 4 windows_tracing_logfile = C:\BVTBin\Tests\installpackage\csilogfile.log TMP = C:\Users\Geraldo\AppData\Local\Temp ProgramData = C:\ProgramData ProgramW6432 = C:\Program Files windir = C:\WINDOWS USERDOMAIN = MARTE 06:49:29 [INF][ Workbench]: Current version given by meta info is: 6.3.10 06:49:29 [INF][ Workbench]: Exiting as another instance of WB is already running. 06:50:33 [INF][SQL Editor Form]: Opened connection 'DB_Cetesb' to MariaDB Server version 5.5.56-MariaDB 06:50:34 [INF][ WQE.net]: Launching SQL IDE 06:50:37 [INF][ WQE.net]: SQL IDE UI is ready 06:50:52 [WRN][SqlEditorSchemaTree]: Error parsing DDL for iPBX.history: delimiter $$ CREATE TABLE `history` ( `id` varchar(40) NOT NULL, `UniqueID` varchar(45) NOT NULL, `EventTime` datetime(6) NOT NULL, `Event` varchar(255) DEFAULT NULL, `param1` varchar(255) DEFAULT NULL, `param2` varchar(255) DEFAULT NULL, `param3` varchar(255) DEFAULT NULL, `AGI` varchar(45) DEFAULT NULL, `AGI_RunTime` decimal(11,8) DEFAULT NULL, PRIMARY KEY (`id`), KEY `EventTime_IDX` (`EventTime`), KEY `Event_IDX` (`Event`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8$$
[23 Jan 2018 9:00]
MySQL Verification Team
Thank you for the feedback. Your server version isn't supported for WorkBench: 06:50:33 [INF][SQL Editor Form]: Opened connection 'DB_Cetesb' to MariaDB Server version 5.5.56-MariaDB
Description: The ALTER TABLE menu does not work when we have DATETIME(2) fields. ----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Geraldo\AppData\Roaming\MySQL\Workbench\log\wb.log] 19:00:47 [ERR][ Workbench]: Console redirection failed. 19:00:47 [INF][ Workbench]: Starting up Workbench 19:00:47 [INF][ Workbench]: Current environment: Command line: "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe" CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE HasShutdownStarted: False OSVersion: Microsoft Windows NT 6.2.9200.0 SystemDirectory: C:\WINDOWS\system32 TickCount: 416877281 UserInteractive: True Version: 4.0.30319.42000 WorkingSet: 35397632 19:00:47 [INF][ Workbench]: Environment variables: COMPUTERNAME = MARTE USERPROFILE = C:\Users\Geraldo HOMEPATH = \Users\Geraldo LOCALAPPDATA = C:\Users\Geraldo\AppData\Local asl.log = Destination=file PSModulePath = C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\ PROCESSOR_ARCHITECTURE = AMD64 Path = C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\OpenVPN\bin;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\Oberthur Technologies\AWP\Dlls;C:\Program Files\Oberthur Technologies\AWP\Dlls;C:\Program Files\Amazon\AWSCLI\;C:\Program Files (x86)\Skype\Phone\;C:\Program Files\PuTTY\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\dotnet\;C:\Program Files\Git\cmd;C:\Program Files\nodejs\;C:\Users\Geraldo\AppData\Local\Microsoft\WindowsApps;C:\Program Files (x86)\Microsoft VS Code\bin;C:\Program Files\MySQL\MySQL Server 5.7\bin;C:\Users\Geraldo\AppData\Roaming\npm; CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files ProgramFiles(x86) = C:\Program Files (x86) PROCESSOR_LEVEL = 6 windows_tracing_flags = 3 LOGONSERVER = \\MARTE PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC HOMEDRIVE = C: SystemRoot = C:\WINDOWS PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 37 Stepping 5, GenuineIntel SESSIONNAME = Console ALLUSERSPROFILE = C:\ProgramData PUBLIC = C:\Users\Public FP_NO_HOST_CHECK = NO APPDATA = C:\Users\Geraldo\AppData\Roaming PROCESSOR_REVISION = 2505 USERNAME = Geraldo CommonProgramW6432 = C:\Program Files\Common Files TEMP = C:\Users\Geraldo\AppData\Local\Temp OneDrive = C:\Users\Geraldo\OneDrive CommonProgramFiles = C:\Program Files\Common Files OS = Windows_NT USERDOMAIN_ROAMINGPROFILE = MARTE FPS_BROWSER_APP_PROFILE_STRING = Internet Explorer ComSpec = C:\WINDOWS\system32\cmd.exe SystemDrive = C: FPS_BROWSER_USER_PROFILE_STRING = Default ProgramFiles = C:\Program Files NUMBER_OF_PROCESSORS = 4 windows_tracing_logfile = C:\BVTBin\Tests\installpackage\csilogfile.log TMP = C:\Users\Geraldo\AppData\Local\Temp ProgramData = C:\ProgramData ProgramW6432 = C:\Program Files windir = C:\WINDOWS USERDOMAIN = MARTE 19:00:47 [INF][ Workbench]: Current version given by meta info is: 6.3.9 19:00:47 [INF][ Workbench]: Setting PATH to: C:\WINDOWS\system32;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\OpenVPN\bin;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\Oberthur Technologies\AWP\Dlls;C:\Program Files\Oberthur Technologies\AWP\Dlls;C:\Program Files\Amazon\AWSCLI\;C:\Program Files (x86)\Skype\Phone\;C:\Program Files\PuTTY\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\dotnet\;C:\Program Files\Git\cmd;C:\Program Files\nodejs\;C:\Users\Geraldo\AppData\Local\Microsoft\WindowsApps;C:\Program Files (x86)\Microsoft VS Code\bin;C:\Program Files\MySQL\MySQL Server 5.7\bin;C:\Users\Geraldo\AppData\Roaming\npm; 19:00:47 [INF][ mforms managed]: Initializing mforms wrapper 19:00:47 [INF][ WBContext UI]: Initializing workbench context UI with these values: base dir: C:\Program Files\MySQL\MySQL Workbench 6.3 CE plugin path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE struct path: module path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules library path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE user data dir: C:\Users\Geraldo\AppData\Roaming\MySQL\Workbench open at start: open type: run at startup: run type: Force SW rendering: No Force OpenGL: No quit when done: No 19:00:47 [INF][ WBContext]: WbContext::init 19:00:49 [INF][ WBA]: Looking for extension modules for WBA... 19:00:49 [INF][ WBA]: 0 extension modules found 19:00:49 [WRN][ grt]: C:\Users\Geraldo\AppData\Roaming\MySQL\Workbench\connections.xml:26: link '{1DED231D-ACCE-4FD3-BEE6-8C81B9EC01B7}' <object GrtObject> key=owner could not be resolved 19:00:49 [INF][ WBContext]: System info: MySQL Workbench Community (GPL) for Windows version 6.3.9 CE build 10690321 (64 bit) Configuration Directory: C:\Users\Geraldo\AppData\Roaming\MySQL\Workbench Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE Cairo Version: 1.10.2 OS: Microsoft Windows 10 Pro CPU: 4x Intel(R) Core(TM) i5 CPU M 450 @ 2.40GHz, 3.8 GiB RAM Active video adapter Intel(R) HD Graphics Installed video RAM: 1722 MB Current video mode: 1920 x 1080 x 4294967296 colors Used bit depth: 32 Driver version: 8.15.10.2900 Installed display drivers: igdumd64.dll,igd10umd64.dll Current user language: Portuguese (Brazil) 19:00:49 [INF][ Workbench]: UI is up 19:00:50 [INF][ Workbench]: Running the application 19:00:53 [INF][SQL Editor Form]: Opened connection 'DB_Cetesb' to MariaDB Server version 5.5.56-MariaDB 19:00:54 [INF][ WQE.net]: Launching SQL IDE 19:00:57 [INF][ WQE.net]: SQL IDE UI is ready 19:01:28 [WRN][SqlEditorSchemaTree]: Error parsing DDL for iPBX.history: delimiter $$ CREATE TABLE `history` ( `id` varchar(40) NOT NULL, `UniqueID` varchar(45) NOT NULL, `EventTime` datetime(6) NOT NULL, `Event` varchar(255) DEFAULT NULL, `param1` varchar(255) DEFAULT NULL, `param2` varchar(255) DEFAULT NULL, `param3` varchar(255) DEFAULT NULL, `AGI` varchar(45) DEFAULT NULL, `AGI_RunTime` decimal(11,8) DEFAULT NULL, PRIMARY KEY (`id`), KEY `EventTime_IDX` (`EventTime`), KEY `Event_IDX` (`Event`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8$$ How to repeat: Just try to alter a table with datetime(n)