Bug #84635 Connection returns True although no connection available
Submitted: 24 Jan 2017 10:59 Modified: 25 Jan 2017 12:01
Reporter: Payam Arzani Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.7.17 OS:Mac OS X (10.12)
Assigned to: CPU Architecture:Any
Tags: Connection, Failure

[24 Jan 2017 10:59] Payam Arzani
Description:
I use an app developed with Xojo. The app has an instruction "If MysqlServer.Connect Then". This instruction seems to return True, but the user does not appear among the list of connections.

This problem does not appear regularly, only sometimes.

How to repeat:
Create an app with the mysql connect instruction. Put this instruction in a 15 seconds timer. Launch the app, and wait for a connection to open. Do not close the connection. Put your computer to sleep and do not quit the app. Wait 24 hours before reactivating your computer. Check wether mysql.connect returns true and if at the same time there is no connection open.

Suggested fix:
no suggestion
[24 Jan 2017 12:02] Chiranjeevi Battula
Hello Payam Arzani,

Thank you for the bug report.
Could you please provide more details like which MySQL connector are you using and repeatable test case(exact steps/sample project, sample connection details etc. - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.
[25 Jan 2017 12:01] Chiranjeevi Battula
Hello Payam Arzani,

Thank you for the feedback.
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php
If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Thanks,
Chiranjeevi.