CodeIgniter database check for timeout error

Question

I'm running a small webservice that gets data from a user specified database, and some of those queries are heavy and often take longer than usual, because those rows contain base64 images and other needed stuff. When my queries take longer than 30 secs CI crashes somehow. I've tried using $this->db->_error_number(), $this->db->_error_message() and

if ($this->db->trans_status() === FALSE) {
    die('Wops, something weird happened...');
}

But none of them gives me error infos. Anybody knows how to capture those timeout errors and echo them to the user? Thanks.

EDIT:

log output:

...
DEBUG - 2015-04-10 10:34:34 --> Controller "Main" Initialized
DEBUG - 2015-04-10 10:34:34 --> Helper loaded: log_helper
DEBUG - 2015-04-10 10:34:34 --> Database Driver Class Initialized
DEBUG - 2015-04-10 10:35:04 --> Final output sent to browser
DEBUG - 2015-04-10 10:35:04 --> Total execution time: 30.0145
...

Sounds like the maximum execution time of php: php.net/manual/en/function.set-time-limit.php — jeroen
– jeroen, Commented Apr 10, 2015 at 13:29
Just for testing purposes, I tried setting no time limits with set_time_limit(0); but the result is the same. — Anderson Madeira
– Anderson Madeira, Commented Apr 10, 2015 at 13:36
Try increasing memory limit to a higher value e.g 1024 MB. — Kamran
– Kamran, Commented Apr 10, 2015 at 13:43
@KamranAdil, you mean in mysql config files? I did this and increased max_allowed_packet to a very high value, but the issue still persists. — Anderson Madeira
– Anderson Madeira, Commented Apr 10, 2015 at 13:56

CodeWithCoffee · Accepted Answer · 2015-04-11 12:42:04Z

3

Please check mysql.connect_timeout parameter in your phpinfo() and increase in in case require as this may be reason for query timeout.

You can read more about this Here

answered Apr 11, 2015 at 12:42

CodeWithCoffee

1,9042 gold badges15 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Anderson Madeira Over a year ago

As I mentioned in @Darius's answer, I tried to changed this value, but I see no diference. Thanks anyways.

Darius · Accepted Answer · 2015-04-10 13:56:29Z

1

Your query takes too much time. If your are using webserver(nginx or apache) hey have default timeout. In most cases it 30seconds. You can increase timeout time on your webserver.

Also check php timeout parameters in php.ini max_execution_time Or try to set_time_limit bigger directly in php code. http://php.net/manual/en/function.set-time-limit.php

answered Apr 10, 2015 at 13:56

Darius

533 bronze badges

1 Comment

Anderson Madeira Over a year ago

Thanks, I tried to change max_execution_time in php.ini and I also used set_time_limit() but nothing changes. The php doc says that set_time_limit() doesn't work if safe mode is enabled, but in my php.ini it is not.

Collectives™ on Stack Overflow

CodeIgniter database check for timeout error

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related