|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2004-09-12 17:52 UTC] tony2001@php.net
|
|||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Thu Nov 06 10:00:01 2025 UTC |
Description: ------------ Using mysql_pconnect appears to stop SHOW SLAVE STATUS queries working properly. If I change the first line in the supplied snippet to mysql_connect, it works fine. Additionally, this bug doesn't appear to show up when using the script called from commandline. But it does, reproducibly, when executing it inside a FastCGI daemon. Even if I explicitly provide the connection object as a reference to mysql_query, the same behaviour is still observed. Reproduce code: --------------- mysql_pconnect('some_host', 'some_user', 'some_pass'); $R = mysql_query("SHOW SLAVE STATUS"); print_r(mysql_fetch_assoc($R)); print mysql_result($R, 0, 'Seconds_Behind_Master'); Expected result: ---------------- The appropriate result set I asked for would be just peachy :) Actual result: -------------- If I use mysql_result: PHP Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 4 in foo.php on line 4 Or mysql_fetch_assoc: PHP Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in foo.php on line 3