Hello all ,I just upgraded my server from 8gb ram ,4 core to 16gb ram and 8 core.I tried to increase the buffer pool seize to 8gb and buffer pool instance to 8.I restarted the mysql and all went well.I later changed the buffer size to 6gb and the instance to 6 and restarted the mysql.I tried to log in to the instance,I have INTERNAL SERVER ERROR.The console reported same. @root13F and other friends,any suggestion?.Below is the htop
16150614983568473953015242033163|375x500
any suggestion ?
Any help? This is the error log
[ERROR] 2021-03-08 02:33:57,525 | /home/fred/frappe-bench/apps/frappe/frappe/utils/error.py:
New Exception collected with id: 2021-03-08 02:33:57.505180-197.210.70.243-b94
[ERROR] 2021-03-08 02:34:00,619 | /home/fred/frappe-bench/apps/frappe/frappe/app.py:
Site: xxxxx
Request Error
Traceback (most recent call last):
File “/home/fred/frappe-bench/apps/frappe/frappe/website/render.py”, line 50, in render
data = render_page_by_language(path)
File “/home/fred/frappe-bench/apps/frappe/frappe/website/render.py”, line 177, in render_page_by_language
return render_page(path)
File “/home/fred/frappe-bench/apps/frappe/frappe/website/render.py”, line 193, in render_page
return build(path)
File “/home/fred/frappe-bench/apps/frappe/frappe/website/render.py”, line 200, in build
return build_page(path)
File “/home/fred/frappe-bench/apps/frappe/frappe/website/render.py”, line 224, in build_page
html = frappe.get_template(context.template).render(context)
File “/home/fred/frappe-bench/env/lib/python3.6/site-packages/jinja2/asyncsupport.py”, line 76, in render
return original_render(self, *args, **kwargs)
File “/home/fred/frappe-bench/env/lib/python3.6/site-packages/jinja2/environment.py”, line 1008, in render
return self.environment.handle_exception(exc_info, True)
File “/home/fred/frappe-bench/env/lib/python3.6/site-packages/jinja2/environment.py”, line 780, in handle_exception
reraise(exc_type, exc_value, tb)
File “/home/fred/frappe-bench/env/lib/python3.6/site-packages/jinja2/_compat.py”, line 37, in reraise
raise value.with_traceback(tb)
File “/home/fred/frappe-bench/apps/frappe/frappe/./website/doctype/web_page/templates/web_page.html”, line 1, in top-level template code
{% extends “templates/web.html” %}
File “/home/fred/frappe-bench/apps/frappe/frappe/./templates/web.html”, line 1, in top-level template code
{% extends base_template_path %}
File “/home/fred/frappe-bench/apps/frappe/frappe/./templates/base.html”, line 74, in top-level template code
{%- block footer -%}
File “/home/fred/frappe-bench/apps/frappe/frappe/./templates/base.html”, line 75, in block “footer”
{% include “templates/includes/footer/footer.html” %}
File “/home/fred/frappe-bench/apps/frappe/frappe/./templates/includes/footer/footer.html”, line 32, in top-level template code
{% block powered %}
File “/home/fred/frappe-bench/apps/frappe/frappe/./templates/includes/footer/footer.html”, line 33, in block “powered”
{% include “templates/includes/footer/footer_powered.html” %}
File “/home/fred/frappe-bench/apps/erpnext/erpnext/./templates/includes/footer/footer_powered.html”, line 1, in top-level template code
{% set domains = frappe.get_doc(“Domain Settings”).active_domains %}
File “/home/fred/frappe-bench/env/lib/python3.6/site-packages/jinja2/sandbox.py”, line 440, in call
return __context.call(__obj, *args, **kwargs)
File “/home/fred/frappe-bench/apps/frappe/frappe/init.py”, line 762, in get_doc
doc = frappe.model.document.get_doc(*args, **kwargs)
File “/home/fred/frappe-bench/apps/frappe/frappe/model/document.py”, line 69, in get_doc
controller = get_controller(doctype)
File “/home/fred/frappe-bench/apps/frappe/frappe/model/base_document.py”, line 38, in get_controller
module_name, custom = frappe.db.get_value(“DocType”, doctype, (“module”, “custom”), cache=True)
File “/home/fred/frappe-bench/apps/frappe/frappe/database/database.py”, line 401, in get_value
order_by, cache=cache)
File “/home/fred/frappe-bench/apps/frappe/frappe/database/database.py”, line 445, in get_values
out = self._get_values_from_table(fields, filters, doctype, as_dict, debug, order_by, update)
File “/home/fred/frappe-bench/apps/frappe/frappe/database/database.py”, line 592, in _get_values_from_table
as_dict=as_dict, debug=debug, update=update)
File “/home/fred/frappe-bench/apps/frappe/frappe/recorder.py”, line 27, in sql
stack = list(get_current_stack_frames())
File “/home/fred/frappe-bench/apps/frappe/frappe/recorder.py”, line 57, in get_current_stack_frames
frames = inspect.getouterframes(current, context=10)
File “/usr/lib/python3.6/inspect.py”, line 1478, in getouterframes
frameinfo = (frame,) + getframeinfo(frame, context)
File “/usr/lib/python3.6/inspect.py”, line 1452, in getframeinfo
lines, lnum = findsource(frame)
File “/usr/lib/python3.6/inspect.py”, line 828, in findsource
if pat.match(lines[lnum]): break
IndexError: list index out of range
This solved the problem