| Bug #73421 | Installation of SYS fails without clear error | ||
|---|---|---|---|
| Submitted: | 29 Jul 2014 11:23 | Modified: | 18 Feb 2015 2:21 |
| Reporter: | Daniël van Eeden (OCA) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 6.1.7 | OS: | Windows |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | sys | ||
[29 Jul 2014 11:33]
Daniël van Eeden
After restarting mysqld with --enabled-named-pipe it worked. 1. The error should be improved. 2. Why are there differences in how WB connects normally and when installing the SYS schema. WB seems to connect via TCP/IP if it is configured to connect over a named pipe to a server w/o named pipes enabled.
[29 Jul 2014 12:14]
MySQL Verification Team
Hello Daniel, Thank you for the bug report. Verified as described. Thanks, Umesh
[29 Jul 2014 12:16]
MySQL Verification Team
// WB log
17:42:29 [ERR][wb_admin_perfschema.py:get_installed_sys_version:49]: MySQL error getting sys schema version: ("Table 'sys.version' doesn't exist", 1146)
17:42:30 [INF][wb_admin_control.py:server_polling_thread:475]: Monitoring thread running...
17:42:30 [ERR][wb_admin_perfschema.py:get_installed_sys_version:49]: MySQL error getting sys schema version: ("Table 'sys.version' doesn't exist", 1146)
17:42:35 [INF][wb_admin_perfschema.py:work:140]: Installing sys\sys_56.sql...
17:42:35 [INF][client_utils.py:import_script:160]: Feeding data from sys\sys_56.sql to "mysql.exe" --defaults-extra-file=c:\users\umshastr\appdata\local\temp\tmpoafab4.cnf --protocol=pipe --user=ushastry --default-character-set=utf8 (cwd=sys)
17:42:35 [INF][client_utils.py:import_script:245]: Task stdout: ERROR 2017 (HY000): Can't open named pipe to host: . pipe: MySQL (2)
17:42:35 [INF][wb_admin_perfschema.py:report_output:104]: ERROR 2017 (HY000): Can't open named pipe to host: . pipe: MySQL (2)
17:42:35 [INF][client_utils.py:import_script:257]: mysql tool exited with code 1
17:42:35 [INF][wb_admin_perfschema.py:work:145]: sys schema installation finished
17:42:36 [ERR][wb_admin_perfschema.py:get_installed_sys_version:49]: MySQL error getting sys schema version: ("Table 'sys.version' doesn't exist", 1146)
[18 Feb 2015 2:21]
Philip Olson
Posted by developer: Fixed as of the upcoming MySQL Workbench 6.2.5 release, and here's the changelog entry: Attempts to install the "SYS" performance helper schema with a "Local Socket/Pipe" enabled MySQL connection would fail, and do so without reporting an error. Thank you for the bug report.
Description: I tried to install the SYS schema. MySQL is 5.6 from a zip installed in d:\mysql The connection uses "Local Socket/Pipe" instead of TCP/IP. The installation fails w/o giving an error. It returns to the screen with the 'Install helper' button. From the WB logfile: 13:18:04 [INF][wb_admin_perfschema.py:work:152]: Installing sys\sys_56.sql... 13:18:04 [INF][client_utils.py:import_script:172]: Feeding data from sys\sys_56.sql to "mysql.exe" --defaults-extra-file=c:\users\802646\appdata\local\temp\tmp1z6nqq.cnf --protocol=pipe --user=root --default-character-set=utf8 (cwd=sys) 13:18:04 [INF][client_utils.py:import_script:257]: Task stdout: ERROR 2017 (HY000): Can't open named pipe to host: . pipe: MySQL (2) 13:18:04 [INF][wb_admin_perfschema.py:report_output:116]: ERROR 2017 (HY000): Can't open named pipe to host: . pipe: MySQL (2) 13:18:04 [INF][client_utils.py:import_script:269]: mysql tool exited with code 1 13:18:04 [INF][wb_admin_perfschema.py:work:157]: sys schema installation finished 13:18:04 [ERR][wb_admin_perfschema.py:get_installed_sys_version:61]: MySQL error getting sys schema version: ("Table 'sys.version' doesn't exist", 1146) How to repeat: Try to install the SYS schema when using a pipe on Windows.