Bug #70866 [Fbk]: pdo_pgsql problems during Drupal 8 test suite

From: Date: Sun, 08 Nov 2015 11:30:33 +0000
Subject: Bug #70866 [Fbk]: pdo_pgsql problems during Drupal 8 test suite
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-197115@lists.php.net to get a copy of this message
Edit report at https://bugs.php.net/bug.php?id=70866&edit=1

 ID:                 70866
 Updated by:         ab@php.net
 Reported by:        fabian at tag1consulting dot com
 Summary:            pdo_pgsql problems during Drupal 8 test suite
 Status:             Feedback
 Type:               Bug
 Package:            PostgreSQL related
 Operating System:   Linux / Ubuntu
 PHP Version:        7.0Git-2015-11-05 (Git)
 Block user comment: N
 Private report:     N

 New Comment:

Actually, I've just checked and the table seems to exist. Probably no way around digging in the
DB codes anyway.

Thanks.


Previous Comments:
------------------------------------------------------------------------
[2015-11-07 16:27:57] ab@php.net

Hi,

from debugging yet, i see the following messages 

errmsg = 0x00000049c6030d40 "ERROR:  relation \"simpletest651326config\" does not
exist\nLINE 1: SELECT data FROM simpletest651326config WHERE collection = '...\n               
         ^\n"

Not sure why they don't popup when the suite ends (as it ends with the 55000, not with the one
the suite finishes). So the first issue seems that the test table doesn't got created.

Fabian, could you please check the table creation part? It could be either something in PHP or still
an issue with PDO. Just as you know the DP8 codebase better, you'll come to the place for sure
faster :) Then we can debug further depending on your research.

Thanks.

------------------------------------------------------------------------
[2015-11-05 21:52:08] fabian at tag1consulting dot com

Description:
------------
Several tests fail with pdo_pgsql on PHP7. Cause is unclear, but exceptions seen only on PHP7 are:

- 'Object not in prerequisite state: 7 ERROR:  currval of sequence 
                 "simpletest386267queue_item_id_seq" is not yet defined in this
session:'

- 'SQLSTATE[42P01]: Undefined
    table: 7 ERROR:  relation "simpletest203206menu_tree_mlid_seq" does not
    exist: INSERT INTO simpletest257820config (collection, name, data) VALUES
    (:db_insert_placeholder_0, :db_insert_placeholder_1,
    :db_insert_placeholder_2);'

Test script:
---------------
Reproducible with Drupal 8 and --with-pdo-pgsql (with Apache):

1. php ./core/scripts/run-tests.sh --sqlite /tmp/coretest.sqlite --dburl
pgsql://postgres:12345@localhost/drupal8  --color --non-html --url http://127.0.0.1/ --verbose --class
'Drupal\menu_ui\Tests\MenuCacheTagsTest'

2. php ./core/scripts/run-tests.sh --sqlite /tmp/coretest.sqlite --dburl
pgsql://postgres:12345@localhost/drupal8  --color --non-html --url http://127.0.0.1/ --verbose --class
'Drupal\system\Tests\Menu\MenuLinkTreeTest'

Expected result:
----------------
Tests do pass (they do with using --php /usr/bin/php5)

Actual result:
--------------
Tests fail with DB exceptions


------------------------------------------------------------------------



--
Edit this bug report at https://bugs.php.net/bug.php?id=70866&edit=1


Thread (9 messages)

« previous php.bugs (#197115) next »