brittneybrinsfield / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

Mysql goes away when sequel pro connects #1809

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Open a database connected site (loads fine)
2. Open sequel pro, connect to localhost
3. Open the same database connect site (cannot connect)
CakeApp (PDO::__construct(): send of 77 bytes failed with errno=32 Broken pipe)
Mysql Workbench error (Error: Lost connection to MySQL server at 'reading 
authorization packet', system error: 0)

Quitting sequel pro fixes the problem. Reproducible every time. 

What version of Sequel Pro are you using? Build 4096
What version of OS X are you using? Mountain Lion Build 12E55
What version of MySQL are you connecting to on the server? 5.6.13

Please provide any additional information below.
All connections are using the same mysql user.

Original issue reported on code.google.com by m...@saymikeo.com on 9 Sep 2013 at 8:02

GoogleCodeExporter commented 9 years ago
Problem went away after restarting the computer.

Original comment by m...@saymikeo.com on 9 Sep 2013 at 8:06

GoogleCodeExporter commented 9 years ago

Original comment by schlabbe...@gmail.com on 11 Sep 2013 at 6:49

GoogleCodeExporter commented 9 years ago
Very strange.  The only reasons I can think of for this is if your user is 
limited to a finite number of connections and you had sufficient connections 
open that the limit was reached (?) - you could check this via SHOW VARIABLES 
LIKE '%max_user_connections%' - or if Sequel Pro was somehow keeping the server 
busy enough that other connections weren't permitted...?

Original comment by rowanb@gmail.com on 12 Sep 2013 at 10:52