Hello Everyone, Every morning I try to open my client system I get the below error.
To solve it, I kill mysqld service in ubuntu and restart it, then everything goes fine. Any suggestion for this problem ?
PDOException in Connector.php line 55: SQLSTATE[HY000] [2002]
in Connector.php line 55
at PDO->__construct('mysql:host=localhost;port=3306;dbname=dbname', 'username', 'password', array('0', '2', '0', false, false)) in Connector.php line 55
at Connector->createConnection('mysql:host=localhost;port=3306;dbname=dbname', array('driver' => 'mysql', 'host' => 'localhost', 'port' => '3306', 'database' => 'dbname', 'username' => 'username', 'password' => 'password', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => false, 'engine' => null, 'name' => 'mysql'), array('0', '2', '0', false, false)) in MySqlConnector.php line 24
at MySqlConnector->connect(array('driver' => 'mysql', 'host' => 'localhost', 'port' => '3306', 'database' => 'dbname', 'username' => 'username', 'password' => 'password', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => false, 'engine' => null, 'name' => 'mysql')) in ConnectionFactory.php line 61
at ConnectionFactory->Illuminate\Database\Connectors{closure}()
at call_user_func(object(Closure)) in Connection.php line 924
at Connection->getPdo() in Connection.php line 792
at Connection->reconnectIfMissingConnection() in Connection.php line 677
at Connection->run('select * from serviceusers
where id
= ? and remember_token
= ? limit 1', array('505', 'cea34Tctk0mHFTqiihiX4b0Pa0X2HYTzH4P6pYy8Vs2kCWW1a7ebuTQjLPPB'), object(Closure)) in Connection.php line 349
at Connection->select('select * from serviceusers
where id
= ? and remember_token
= ? limit 1', array('505', 'cea34Tctk0mHFTqiihiX4b0Pa0X2HYTzH4P6pYy8Vs2kCWW1a7ebuTQjLPPB'), true) in Builder.php line 1610
at Builder->runSelect() in Builder.php line 1596
at Builder->get(array('*')) in Builder.php line 1577
at Builder->first() in DatabaseUserProvider.php line 74
at DatabaseUserProvider->retrieveByToken('505', 'cea34Tctk0mHFTqiihiX4b0Pa0X2HYTzH4P6pYy8Vs2kCWW1a7ebuTQjLPPB') in SessionGuard.php line 186
at SessionGuard->getUserByRecaller('505|cea34Tctk0mHFTqiihiX4b0Pa0X2HYTzH4P6pYy8Vs2kCWW1a7ebuTQjLPPB') in SessionGuard.php line 141
at SessionGuard->user() in GuardHelpers.php line 49
at SessionGuard->check() in GuardHelpers.php line 59
at SessionGuard->guest() in Authenticate.php line 20
at Authenticate->handle(object(Request), object(Closure))
at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle(object(Request), object(Closure))
at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in StartSession.php line 64
at StartSession->handle(object(Request), object(Closure))
at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request)) in EncryptCookies.php line 59
at EncryptCookies->handle(object(Request), object(Closure))
at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 102
at Pipeline->then(object(Closure)) in Router.php line 726
at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 699
at Router->dispatchToRoute(object(Request)) in Router.php line 675
at Router->dispatch(object(Request)) in Kernel.php line 246
at Kernel->Illuminate\Foundation\Http{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
at Pipeline->Illuminate\Routing{closure}(object(Request)) in CheckForMaintenanceMode.php line 44
at CheckForMaintenanceMode->handle(object(Request), object(Closure))
at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
at Pipeline->Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline->Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 102
at Pipeline->then(object(Closure)) in Kernel.php line 132
at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 99
at Kernel->handle(object(Request)) in index.php line 53
This error : SQLSTATE[HY000] [2002], generally refers to a wrong connection attempt or a missing file... Hard to tell here if it's your MySQL that just crash everyday or if it's your Laravel app that make it crash... You should check the database status maybe, repair tables, check your hard drive either I would suggest.
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community