Edit report at https://bugs.php.net/bug.php?id=63365&edit=1
ID: 63365
Updated by: mbecc...@php.net
Reported by: chris at ctgameinfo dot com
Summary: pg_send_query() blocks on queries to other
connections.
-Status: Open
+Status: Not a bug
Type: Bug
Package: PostgreSQL related
Operating System: FreeBSD (probably irrevelant)
PHP Version: 5.4.8
Block user comment: N
Private report: N
New Comment:
Sorry, hit submit too early. By overwriting the connection variable, you force
the old connection to be closed. In order to do that, PHP is waiting for the
query to complete and discard its output.
Previous Comments:
------------------------------------------------------------------------
[2013-06-05 13:48:32] mbecc...@php.net
This won't block:
<?php
for($i=1;$i<=10;$i++)
{
echo "Interation $i\n";
$dbconn[$i] = pg_connect("dbname=postgres", PGSQL_CONNECT_FORCE_NEW);
// Will block in the second loop interation
pg_send_query($dbconn[$i], "select pg_sleep(5)");
echo "Last error: '".pg_last_error($dbconn[$i])."'\n";
}
?>
So the issue only happens when you "overwrite" an existing connection
------------------------------------------------------------------------
[2012-10-28 16:24:28] chris at ctgameinfo dot com
Modified test script with requested pg_last_error output.
-------
<?php
for($i=1;$i<=10;$i++)
{
echo "Interation $i\n";
$dbconn = pg_connect("user=cstdenis dbname=postgres",
PGSQL_CONNECT_FORCE_NEW);
// Will block in the second loop interation
pg_send_query($dbconn, "select pg_sleep(5);");
echo "Last error: '".pg_last_error($dbconn)."'\n";
}
?>
Output:
-------
Interation 1
Last error: ''
Interation 2
Last error: ''
Interation 3
Last error: ''
Interation 4
Last error: ''
Interation 5
Last error: ''
Interation 6
Last error: ''
Interation 7
Last error: ''
Interation 8
Last error: ''
Interation 9
Last error: ''
Interation 10
Last error: ''
------------------------------------------------------------------------
[2012-10-28 13:57:36] fel...@php.net
Please, check out the return from pg_last_error($dbconn); after the
pg_send_query() call and post the result in there.
------------------------------------------------------------------------
[2012-10-25 20:58:13] chris at ctgameinfo dot com
Description:
------------
If I open a connection and send a long running query with pg_send_query, then
open a second connection and try to send a query over the second connection
with
pg_send_query it will block on the first connection's query not being complete
Test script:
---------------
<?php
for($i=1;$i<=10;$i++)
{
echo "Interation $i\n";
$dbconn = pg_connect("user=pgsql dbname=postgres",
PGSQL_CONNECT_FORCE_NEW);
// Will block in the second loop interation
pg_send_query($dbconn, "select pg_sleep(5);");
}
?>
Expected result:
----------------
pg_send_query should only block on incomplete queries on the same connection.
Actual result:
--------------
pg_send_query blocks on incomplete queries on any connection.
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=63365&edit=1
