Forums

My server was down

My server was down.

I think it's because too hard db query was executed.

How can I check it?

Here is server error.log

2015-05-20 15:10:30 Wed May 20 15:10:29 2015 - *** HARAKIRI ON WORKER 1 (pid: 22824, try: 1) ***
2015-05-20 15:10:30 Wed May 20 15:10:29 2015 - HARAKIRI !!! worker 1 status !!!
2015-05-20 15:10:30 Wed May 20 15:10:29 2015 - HARAKIRI [core 0] 10.9.180.95 - GET /product/product/24/search_in/?shortname=&fullname=&description=&product_type=0 since 1432134328
2015-05-20 15:10:30 Wed May 20 15:10:29 2015 - HARAKIRI !!! end of worker 1 status !!!
2015-05-20 15:10:30 DAMN ! worker 1 (pid: 22824) died, killed by signal 9 :( trying respawn ...
2015-05-20 15:10:30 Respawned uWSGI worker 1 (new pid: 22874)
2015-05-20 15:10:30 spawned 2 offload threads for uWSGI worker 1
2015-05-20 15:10:31 Wed May 20 15:10:31 2015 - SIGPIPE: writing to a closed pipe/socket/fd (probably the client disconnected) on request /product/edit_enum_property/6834 (ip 10.9.180.95) !!!
2015-05-20 15:10:31 Wed May 20 15:10:31 2015 - uwsgi_response_write_headers_do(): Broken pipe [core/writer.c line 229] during GET /product/edit_enum_property/6834 (10.9.180.95)
2015-05-20 15:10:31 announcing my loyalty to the Emperor...
2015-05-20 15:10:31 Wed May 20 15:10:31 2015 - SIGPIPE: writing to a closed pipe/socket/fd (probably the client disconnected) on request /product/category/8/add_product/46/ (ip 10.9.180.95) !!!

Hi there, that's probably right -- the harakiri only kicks in after a request fails to respond within 5 minutes.

Have you got any indexes on your tables? They make a big difference to query speed...