#35333 [Opn->Bgs]: MySQL server goes away after multi_query and before the next query.

From:	sniper@php.net	Date:	Wed, 23 Nov 2005 08:30:28 +0000
Subject:	#35333 [Opn->Bgs]: MySQL server goes away after multi_query and before the next query.
References:	1	Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-88764@lists.php.net to get a copy of this message

 ID:               35333
 Updated by:       sniper@php.net
 Reported By:      camka at email dot ee
-Status:           Open
+Status:           Bogus
 Bug Type:         MySQLi related
 Operating System: WinXP, Linux
 PHP Version:      5CVS-2005-11-22 (snap)
 New Comment:

Report that to Mysql, it is not PHP problem.


Previous Comments:
------------------------------------------------------------------------

[2005-11-22 23:15:51] camka at email dot ee

but still, if i use selects in multi_query:
$s -> multi_query("select 1;select 2");

and then 

$s -> query("select 3");

i get more understandable error

- 2014 - Commands out of sync; you can't run this command now

Why then the server goes away in case of non-select queries?
Out of sync error would be less confusing.

------------------------------------------------------------------------

[2005-11-22 19:42:49] georg@php.net

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to
report
a bug at http://bugs.php.net/how-to-report.php

After executing mysqli_multi_query you have first process the
resultsets before sending any another statement to the server,
otherwise your socket is still blocked.

Please note that even if your multi statement doesn't contain SELECT
queries, the server will send result packages containing errorcodes (or
OK packet) for single statements. 

------------------------------------------------------------------------

[2005-11-22 18:02:15] camka at email dot ee

the same behaviour with the latest snapshot. no changes.

------------------------------------------------------------------------

[2005-11-22 17:49:00] sniper@php.net

Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip



------------------------------------------------------------------------

[2005-11-22 16:07:36] camka at email dot ee

may be related to bug #31668

------------------------------------------------------------------------

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
    http://bugs.php.net/35333

-- 
Edit this bug report at http://bugs.php.net/?id=35333&edit=1


   

Thread (10 messages)

• camka at email dot eeTue, 22 Nov 2005 15:07:01 +0000
  • camka at email dot eeTue, 22 Nov 2005 15:07:36 +0000#35333 [Opn]: MySQL server goes away after multi_query and before the next query.
  • sniper@php.netTue, 22 Nov 2005 16:49:01 +0000#35333 [Opn->Fbk]: MySQL server goes away after multi_query and before the next query.
  • camka at email dot eeTue, 22 Nov 2005 17:02:15 +0000#35333 [Fbk->Opn]: MySQL server goes away after multi_query and before the next query.
  • georg@php.netTue, 22 Nov 2005 18:42:51 +0000#35333 [Opn->Bgs]: MySQL server goes away after multi_query and before the next query.
  • camka at email dot eeTue, 22 Nov 2005 22:16:07 +0000#35333 [Bgs->Opn]: MySQL server goes away after multi_query and before the next query.
  • sniper@php.netWed, 23 Nov 2005 08:30:28 +0000#35333 [Opn->Bgs]: MySQL server goes away after multi_query and before the next query.
  • camka at email dot eeFri, 25 Nov 2005 10:12:28 +0000#35333 [Bgs->Opn]: MySQL server goes away after multi_query and before the next query.
  • tony2001@php.netFri, 25 Nov 2005 11:58:47 +0000#35333 [Opn->Asn]: MySQL server goes away after multi_query and before the next query.
  • georg@php.netSat, 26 Nov 2005 05:32:22 +0000#35333 [Asn->Bgs]: MySQL server goes away after multi_query and before the next query.