Bug #74767 [Opn->Nab]: pg_connect connects to another database
Edit report at https://bugs.php.net/bug.php?id=74767&edit=1
ID: 74767
Updated by: kalle@php.net
Reported by: ivnpro at mail dot ru
Summary: pg_connect connects to another database
-Status: Open
+Status: Not a bug
Type: Bug
Package: PostgreSQL related
Operating System: Debian Linux
PHP Version: 7.0.20
Block user comment: N
Private report: N
New Comment:
Thank you for taking the time to report a problem with PHP.
Unfortunately you are not using a current version of PHP --
the problem might already be fixed. Please download a new
PHP version from http://www.php.net/downloads.php
If you are able to reproduce the bug with one of the latest
versions of PHP, please change the PHP version on this bug report
to the version you tested and change the status back to "Open".
Again, thank you for your continued support of PHP.
Previous Comments:
------------------------------------------------------------------------
[2020-11-21 18:30:13] dev at dcolt dot org
Unable to reproduce in current version on postgresql and php
------------------------
dcolt@jewels ~ $ php -v
PHP 7.4.12 (cli) (built: Nov 17 2020 21:20:02) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
with Zend OPcache v7.4.12, Copyright (c), by Zend Technologies
dcolt@jewels ~ $ psql --version
psql (PostgreSQL) 13.1
dcolt@jewels ~ $ php testing.php
dcolt@jewels ~ $
------------------------------------------------------------------------
[2017-06-16 14:38:34] ivnpro at mail dot ru
Description:
------------
pg_connect gives connection resourse to incorrect database.
php.ini default
postgreSQL 9.5 default
using PGSQL_CONNECT_FORCE_NEW help avoid this bug, but too many connections are opened in production
php-v:
PHP 7.0.20-2~ubuntu14.04.1+deb.sury.org+1 (cli) (built: Jun 14 2017 05:55:23) ( NTS )
Test script:
---------------
<?php
try {
$count = 0;
while ($count < 1000) {
$names = ['test1', 'test2', 'test3', 'test4'];
$name = $names[mt_rand(0,3)];
$resource = pg_connect("user=postgres dbname=$name host=db-host port=5432");
if (is_resource($resource) && pg_dbname($resource) !== $name) {
/**
* got it !!!
*/
echo "count $count \n";
echo "resource $resource\n";
echo "is_resource ".is_resource($resource)."\n";
echo "pg_dbname " .pg_dbname($resource). "\n";
echo "name $name\n";
die(1);
}
++$count;
usleep(1000);
}
} catch (Exception $e) {
echo $e . "\n";
}
Expected result:
----------------
empty output if everything correctly, or exception in case couldn't connect.
Actual result:
--------------
count 26
resource Resource id #23
is_resource 1
pg_dbname test3
name test2
that mean asking for connection to test2, but it gives test3
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=74767&edit=1
Thread (3 messages)