<br><div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>You could try if the attached patch logs something more useful. I<br>doubt it though. I don't really see how to debug this any better
<br>without looking into what the MySQL library does internally. You<br>could see what ktrace shows though. Does the MySQL library close()<br>the connection, or does it receive some "connection closed" error?</blockquote>
<div><br>Tried the patch and get this:<br>mysql_query() failed: Lost connection to MySQL server during query<br><br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Could it be that MySQL just doesn't like having CALL used as a<br>replacement for SELECT, and while newer versions directly say that,<br>the older versions just go and do random disconnects or whatever?<br><br></blockquote>
</div><br>Why would MySQL drop my connections every minutes or so? This is very strange. The issue can re-occur on 5.0.27, although I got the 'commands out of sync' stuff. <br><br>I ended up using some SQL voodoo and making a big SELECT statement out of my "CALL".
<br>Not sure if it's a surprise or not..but no dropped connections when using SELECT. Same load.<br><br>Cassidy<br><br><br><br>