Bug #65384 [Com]: pg_last_notice test failures
| From: | nikic@php.net | Date: | Tue, 20 Aug 2013 08:49:06 +0000 |
| Subject: | Bug #65384 [Com]: pg_last_notice test failures | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-181034@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=65384&edit=1
ID: 65384
Comment by: nikic@php.net
Reported by: nikic@php.net
Summary: pg_last_notice test failures
Status: Closed
Type: Bug
Package: PostgreSQL related
PHP Version: 5.5.2RC1
Assigned To: yohgaki
Block user comment: N
Private report: N
New Comment:
For anyone interested, the relevant commits are:
* https://github.com/php/php-src/commit/e960eebfea1fccbb4a2f030949249d4d1d198728
* https://github.com/php/php-src/commit/7d538cf8dd41a2584c56ec4abfafd738f0fa1e31
> I've only committed the fix. Should I commit the fix to 5.4/5.5?
I don't know about 5.4, but this should definitely go into 5.5 as we're also testing that
on Travis ;)
The 09notice.phpt test is still failing:
TEST 5533/12097 [ext/pgsql/tests/09notice.phpt]
========DIFF========
001+ Cannot find notice message in hash
002+ bool(false)
003+
001- Notice: pg_query(): %s already a transaction in progress in %s on line %d
002- %s already a transaction in progress
========DONE========
That's also the last failing test on Travis, so once that's fixed we'll *finally*
have a working build there :)
Thanks for working on this!
Previous Comments:
------------------------------------------------------------------------
[2013-08-20 05:28:40] yohgaki@php.net
> Setting error logging message solved issue.
Setting error logging level solved issue.
------------------------------------------------------------------------
[2013-08-20 05:27:59] yohgaki@php.net
It was error logging setting.
Setting error logging message solved issue.
I've only committed the fix. Should I commit the fix to 5.4/5.5?
------------------------------------------------------------------------
[2013-08-18 07:43:23] yohgaki@php.net
> Could it just be that they configured client_min_messages=WARNING?
Users can set it as SQL command.
SET client_min_messages TO WARNING;
It may be the reason why this test fails. I'll try to change message level to
NOTICE to see if it helps. I'm not sure how NOTIFY command is handled by
PostgreSQL, so it might not be related, though.
There is request that stores all notice during session. I'll work on this
request later. If pgsql module keep all of them, it may consume all available
memory. Therefore, configuration for max number of notices recorded will be
added. It may help to find out what is going on.
------------------------------------------------------------------------
[2013-08-09 20:35:53] mike@php.net
Could it just be that they configured client_min_messages=WARNING?
------------------------------------------------------------------------
[2013-08-05 01:18:45] yohgaki@php.net
I cannot reproduce on my Fedora19 and PHP 5.5 branch
[yohgaki@dev PHP-5.5]$ rpm -q postgresql
postgresql-9.2.4-1.fc19.x86_64
Anyone know what the PostgreSQL version on Travis CI?
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
https://bugs.php.net/bug.php?id=65384
--
Edit this bug report at https://bugs.php.net/bug.php?id=65384&edit=1