Skip to content

Instantly share code, notes, and snippets.

@ludofleury

ludofleury/MysqlContext.php

Last active November 8, 2021 14:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ludofleury/5074595 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ludofleury/5074595 to your computer and use it in GitHub Desktop.
Download ZIP
A Behat Context with a hook to kill the Mysql connections
Raw
MysqlContext.php
<?php
use Behat\Symfony2Extension\Context\KernelAwareInterface;
use Behat\Symfony2Extension\Context\KernelDictionary;
use Behat\MinkExtension\Context\MinkContext;
class MysqlContext extends MinkContext implements KernelAwareInterface
{
use KernelDictionary;
/**
* @AfterScenario
*/
public function killMysqlConnections()
{
$connections = $this->kernel->getContainer()->get('doctrine')->getConnections();
foreach ($connections as $connection) {
$threads = $connection->query('SHOW FULL PROCESSLIST');
while ($thread = $threads->fetch()) {
if ($thread['db'] == $connection->getDatabase() && $thread['Command'] == 'Sleep') {
$connection->query(sprintf('KILL %d', $thread['Id']));
}
}
}
}
}
@ludofleury
Copy link
Copy Markdown
Author

ludofleury commented Mar 4, 2013

Thanks @beberlei for the tips, I'll try.

@nmariani
Copy link
Copy Markdown

nmariani commented Jul 22, 2014

Thanks soooooo much @ludofleury. You saved my day after a Symfony 2.5 / PHP 5.5 upgrade! ;)

@itsjavi
Copy link
Copy Markdown

itsjavi commented Feb 25, 2020

that was a life saver! I thought that unsetting the PDO connection was enough but it was not.
thanks for this

@ludofleury
Copy link
Copy Markdown
Author

ludofleury commented Mar 20, 2020 via email

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment