• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[split] [split] Log errors

#1
Hi sorry if i am offtopic how to avoid the following log errors ?:

[2016-09-05 15:50:02][E/codeigniter][URI=/] Severity: Warning --> mysqli::query(): MySQL server has gone away /web/htdocs/www/home/system/database/drivers/mysqli/mysqli_driver.php 306
[2016-09-05 15:50:02][E/codeigniter][URI=/] Severity: Warning --> mysqli::query(): Error reading result set's header /web/htdocs/www/home/system/database/drivers/mysqli/mysqli_driver.php 306
[2016-09-05 15:50:02][E/codeigniter][URI=/] Query error: MySQL server has gone away - Invalid query: SELECT GET_LOCK('3084335f0fbc7d242719711b7970a602ef6fa509', 300) AS ci_session_lock
[2016-09-05 15:50:02][E/codeigniter][URI=/] Severity: Error --> Call to a member function row() on boolean /web/htdocs/www/home/system/libraries/Session/drivers/Session_database_driver.php 358

i dont know if depends by last ci version but pls can u suggest anything in order to fix it?
Reply

#2
Check your MySQL my.in or my.cnf file to see if there is a wait_timeout

It should be = to 28800 for 8 hours

Code:
set wait_timeout = 28800;

Also with CI you can do the following:

Code:
$this->db->reconnect();

If your doing a lot of database work I would autoload the database in ./application/config/autoload.php
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.