| Bug #81278 | Status behaves differently when connection is lost | ||
|---|---|---|---|
| Submitted: | 2 May 2016 13:09 | Modified: | 25 Aug 2016 10:48 |
| Reporter: | Daniël van Eeden (OCA) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Document Store: MySQL Shell | Severity: | S3 (Non-critical) |
| Version: | 1.0.3 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[2 May 2016 14:40]
MySQL Verification Team
Hello Daniël, Thank you for the report. Verified as described. Thanks, Umesh
[2 May 2016 14:40]
MySQL Verification Team
--
[root@cluster-repo ~]# mysqlsh --uri root@localhost test --session-type=node
Creating a Node Session to root@localhost:33060/test
Enter password:
Default schema `test` accessible through db.
Welcome to MySQL Shell 1.0.3 Development Preview
Copyright (c) 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type '\help', '\h' or '\?' for help.
Currently in JavaScript mode. Use \sql to switch to SQL mode and execute queries.
mysql-js> \sql
Switching to SQL mode... Commands end with ;
mysql-sql> \status
MySQL Shell Version 1.0.3 Development Preview
Session type: Node
Server type: mysql
Connection Id: 24
Default schema: test
Current schema: test
Current user: root@localhost
SSL: Not in use.
Server version: MySQL Community Server (GPL)
Server characterset: latin1
Schema characterset: latin1
Client characterset: utf8mb4
Conn. characterset: utf8mb4
mysql-sql>
mysql-sql> rollback release;
ERROR: 1317: Query execution was interrupted
mysql-sql> \status
MySQL server has gone away
...
...
[25 Aug 2016 10:48]
David Moss
Posted by developer: Thank you for your feedback, this has been fixed in upcoming versions and the following was added to the 1.0.5 change log: If the connection to a MySQL server was interrupted, issuing \status failed unless followed by a ;.
Description: \status suddenly requires ';' if the connection is lost. How to repeat: mysql-sql> \status MySQL Shell Version 1.0.3 Development Preview Session type: Node Server type: mysql Connection Id: 10 Default schema: Current schema: Current user: root@172.17.0.3 SSL: Not in use. Server version: MySQL Community Server (GPL) Server characterset: latin1 Schema characterset: latin1 Client characterset: utf8mb4 Conn. characterset: utf8mb4 mysql-sql> rollback release; ERROR: 1317: Query execution was interrupted mysql-sql> \status MySQL server has gone away ... ... ;