Hello,
Over the last few weeks, i noticed that my site crashes intermittently without any back-end processes being carried out. i checked my web.error.log and every other logs in bench and they came up empty. The only way to get my instance up is to reboot the machine. I even backed up my site, reinstalled my server from scratch and restored my backup to the new installation but the issue still won’t go away.
I did a bit of research and a query directed me to the frappe log. This is what i found:
[ERROR] 2017-10-06 07:34:44,678 | /home/frappe/frappe-bench/apps/frappe/frappe/$
Site: site1.local
Request Error
Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 54, in appli$
init_request(request)
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 116, in init$
frappe.local.http_request = frappe.auth.HTTPRequest()
File “/home/frappe/frappe-bench/apps/frappe/frappe/auth.py”, line 53, in __in$
frappe.local.login_manager = LoginManager()
File “/home/frappe/frappe-bench/apps/frappe/frappe/auth.py”, line 116, in __i$
self.set_user_info(resume=True)
File “/home/frappe/frappe-bench/apps/frappe/frappe/auth.py”, line 145, in set$
[“user_type”, “first_name”, “last_name”, “user_image”], as_dict=1)
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 429, in$
order_by, cache=cache)
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 473, in$
out = self._get_values_from_table(fields, filters, doctype, as_dict, debug,$
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 605, in$
as_dict=as_dict, debug=debug, update=update)
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 123, in$
self.connect()
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 69, in $
use_unicode=True, charset=‘utf8mb4’)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb$
return Connection(*args, **kwargs)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb$
super(Connection, self).init(*args, **kwargs2)
OperationalError: (2002, 'Can't connect to local MySQL server through socket $
The error timelines are pretty consistent with the times my website goes down and gives the internal server error. Can anyone point me to how i can resolve this?