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:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.1.7 OS:Microsoft Windows
Assigned to: CPU Architecture:Any
Tags: sys

[29 Jul 2014 11:23] Daniël van Eeden
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.
[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.