#30067 [Opn->Bgs]: mysql_pconnect stops 'SHOW SLAVE STATUS' working

ID: 30067 Updated by: tony2001@php.net Reported By: chris at shagged dot org -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: FreeBSD 5.2.1 PHP Version: 4.3.9RC2 New Comment: Use mysql_error() to figure out why your query failed. Previous Comments: ------------------------------------------------------------------------ [2004-09-12 17:50:12] chris at shagged dot org 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 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=30067&edit=1