J'ai développé un site web symfony v2.8 hébergé chez OVH.
J'utilise le bundle fosuserbundle pour l'authentification.

Une fois l'envoi du formulaire d'auth lancé, je redirige vers une home page.

A la première connexion de la journée, j'ai cette erreur :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
An exception occurred while executing 'SELECT t0_.numero AS numero_0, t0_.datecreation AS datecreation_1, t0_.datedernierefermeture AS datedernierefermeture_2, t0_.statut AS statut_3 FROM ticket t0_ LEFT JOIN email e1_ ON t0_.email_principal_id = e1_.id WHERE t0_.datecreation > ? OR t0_.datedernierefermeture > ? ORDER BY t0_.id DESC' with params ["2016-11-10", "2016-11-10"]:
 
SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query
500 Internal Server Error - DriverException
2 linked Exceptions: PDOException » PDOException »

Voici la suite de l'erreur :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
[3/3] DriverException: An exception occurred while executing 'SELECT t0_.numero AS numero_0, t0_.datecreation AS datecreation_1, t0_.datedernierefermeture AS datedernierefermeture_2, t0_.statut AS statut_3 FROM ticket t0_ LEFT JOIN email e1_ ON t0_.email_principal_id = e1_.id WHERE t0_.datecreation > ? OR t0_.datedernierefermeture > ? ORDER BY t0_.id DESC' with params ["2016-11-10", "2016-11-10"]:
 
SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query   -
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php at line 115   -
                return new Exception\NotNullConstraintViolationException($message, $exception);
        }
        return new Exception\DriverException($message, $exception);
    }
    /**
at AbstractMySQLDriver ->convertException ('An exception occurred while executing 'SELECT t0_.numero AS numero_0, t0_.datecreation AS datecreation_1, t0_.datedernierefermeture AS datedernierefermeture_2, t0_.statut AS statut_3 FROM ticket t0_ LEFT JOIN email e1_ ON t0_.email_principal_id = e1_.id WHERE t0_.datecreation > ? OR t0_.datedernierefermeture > ? ORDER BY t0_.id DESC' with params ["2016-11-10", "2016-11-10"]: SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query', object(PDOException)) 
in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php at line 128   + 
at DBALException ::driverExceptionDuringQuery (object(Driver), object(PDOException), 'SELECT t0_.numero AS numero_0, t0_.datecreation AS datecreation_1, t0_.datedernierefermeture AS datedernierefermeture_2, t0_.statut AS statut_3 FROM ticket t0_ LEFT JOIN email e1_ ON t0_.email_principal_id = e1_.id WHERE t0_.datecreation > ? OR t0_.datedernierefermeture > ? ORDER BY t0_.id DESC', array('2016-11-10', '2016-11-10')) 
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php at line 836   + 
at Connection ->executeQuery ('SELECT t0_.numero AS numero_0, t0_.datecreation AS datecreation_1, t0_.datedernierefermeture AS datedernierefermeture_2, t0_.statut AS statut_3 FROM ticket t0_ LEFT JOIN email e1_ ON t0_.email_principal_id = e1_.id WHERE t0_.datecreation > ? OR t0_.datedernierefermeture > ? ORDER BY t0_.id DESC', array('2016-11-10', '2016-11-10'), array('2', '2'), null) 
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php at line 50   + 
at SingleSelectExecutor ->execute (object(Connection), array('2016-11-10', '2016-11-10'), array('2', '2')) 
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php at line 321   + 
at Query ->_doExecute () 
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php at line 969   + 
at AbstractQuery ->executeIgnoreQueryCache (null, '1') 
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php at line 924   + 
at AbstractQuery ->execute (null, '1') 
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php at line 727   + 
at AbstractQuery ->getResult () 
in src/Sas/TicketBundle/Entity/TicketRepository.php at line 47   + 
at TicketRepository ->getStatsTicketsCreatedClosed () 
in src/Sas/TicketBundle/Controller/TableauDeBordController.php at line 37   + 
at TableauDeBordController ->tableaudebordAction ()
Je n'arrive pas à trouver d'explication.

Ce qui est encore plus fou, c'est qu'en faisant F5 et rechargeant la page, je n'ai plus l'erreur et ma home page est affichée. Puis sur toute la journée l'erreur ne se reproduit plus, ce n'est qu'au premier affichage.

Une idée / piste ?