note 62356 added to function.mysql-free-result
| From: | Nairebis at osu1 dot php dot net | Date: | Sun, 26 Feb 2006 02:00:13 +0000 |
| Subject: | note 62356 added to function.mysql-free-result | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-104445@lists.php.net to get a copy of this message | ||
ALWAYS use this function! I just encountered a bug in my code where I forgot to use this function. I
also happen to be using mysql_pconnect() for a persistent connection. If you forget to free the
result, it can hold the old result set open indefinitely within the HTTP process.
The upshot (in my application) was that I did updates that happened in a different HTTP process, but
they mysteriously didn't show up in another HTTP process. After panicking that MySQL had
mysterious data corruption and/or synchronization problems, I traced it back to this where an old
result set was held open.
----
Server IP: 64.71.164.2
Probable Submitter: 68.5.244.195
----
X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER
autolearn=no version=2.64
----
Manual Page -- http://www.php.net/manual/en/function.mysql-free-result.php
Edit -- http://master.php.net/note/edit/62356
Del: integrated -- http://master.php.net/note/delete/62356/integrated
Del: useless -- http://master.php.net/note/delete/62356/useless
Del: bad code -- http://master.php.net/note/delete/62356/bad+code
Del: spam -- http://master.php.net/note/delete/62356/spam
Del: non-english -- http://master.php.net/note/delete/62356/non-english
Del: in docs -- http://master.php.net/note/delete/62356/in+docs
Del: other reasons-- http://master.php.net/note/delete/62356
Reject -- http://master.php.net/note/reject/62356
Search -- http://master.php.net/manage/user-notes.php