Yii2 - Functional testing - Too many connections

[dynasource]

Im getting an explosion of db-connections when running functional tests with Yii2. If the test sequence is long enough, it will reach its maximum allowed connections.

Is this normal behavior?

[samdark]

Are you using persistent connections?

[dynasource]

Im running a local Xampp machine with nearly default settings.

; Allow or prevent persistent links.
; http://php.net/mysql.allow-persistent
mysql.allow_persistent=On

; If mysqlnd is used: Number of cache slots for the internal result set cache
; http://php.net/mysql.cache_size
mysql.cache_size=2000

; Maximum number of persistent links. -1 means no limit.
; http://php.net/mysql.max-persistent
mysql.max_persistent=-1

; Maximum number of links (persistent + non-persistent). -1 means no limit.
; http://php.net/mysql.max-links
mysql.max_links=-1

[dynasource]

it looks like a DB connection is created for every call in the testsuites. In a browser, manually F5-ing a page with db-queries works normally with only 1 thead.

[samdark]

In case of functional tests we're basically running an application the same way as we're doing it normally. The only difference (that actually isn't really a difference in case of high traffic projects) is that query frequency is quite high. I'm not sure why PHP isn't reusing connections and creating new ones but it's not something Yii or Codeception controls so could not be fixed from Yii or Codeception side.

[dynasource]

@samdark, the problem seems to be solved when applying the PDO attribute to the Yii2 + DB config.
I guess this is something for the manual.

The solution, use:

        'db' => array(
            'class' => 'yii\db\Connection',
            'dsn' => 'mysql:host=localhost;dbname=yii2_advanced_test',
            'username' => 'root',
            'password' => '',
            'tablePrefix' => '',
            'charset' => 'utf8',
            'attributes'=>[
                PDO::ATTR_PERSISTENT => true
            ]

        ),

[samdark]

It's quite rare to configure MySQL persistent connections with php.ini and it seems you've found a conflict between PDO and mysqlnd. Not sure we should describe such a rare PHP and MySQL issue in the Yii guide.

[anders-akero]

I had the exact same problem and adding

            'attributes'=>[
                PDO::ATTR_PERSISTENT => true
            ]

helped me.

[adamdry]

I had the same problem on the unit (integration) tests and adding PDO::ATTR_PERSISTENT => true to my config worked too!

[hmphu]

@anders-akero thank you so much, this helped me

[DanaLuther]

I ran into the same issue today - setting the persistent attribute solved it beautifully. Thank you!!!