必须重启seahub才能解决这问题
一样的问题,seahub.log里频繁出现数据库连接失败,在大量并发查询的时候就出现,我的MySQL是windows版,其余所有运行环境都在Docker里
2020-03-07 11:31:20,696 [ERROR] django.request:135 handle_uncaught_exception Internal Server Error: /api/v2.1/repos/cbc4110e-dbd2-4f92-a5d4-29349c009a3c/
Traceback (most recent call last):
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/core/handlers/exception.py", line 41, in inner
response = get_response(request)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/core/handlers/base.py", line 244, in _legacy_get_response
response = middleware_method(request)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/middleware/locale.py", line 25, in process_request
language = translation.get_language_from_request(request, check_path=i18n_patterns_used)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/utils/translation/__init__.py", line 211, in get_language_from_request
return _trans.get_language_from_request(request, check_path)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/utils/translation/trans_real.py", line 519, in get_language_from_request
lang_code = request.session.get(LANGUAGE_SESSION_KEY)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/contrib/sessions/backends/base.py", line 68, in get
return self._session.get(key, default)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/contrib/sessions/backends/base.py", line 207, in _get_session
self._session_cache = self.load()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/contrib/sessions/backends/db.py", line 35, in load
expire_date__gt=timezone.now()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/query.py", line 374, in get
num = len(clone)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/query.py", line 232, in __len__
self._fetch_all()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/query.py", line 1118, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/sql/compiler.py", line 887, in execute_sql
cursor = self.connection.cursor()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 254, in cursor
return self._cursor()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 229, in _cursor
self.ensure_connection()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 213, in ensure_connection
self.connect()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/utils.py", line 94, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 213, in ensure_connection
self.connect()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 189, in connect
self.connection = self.get_new_connection(conn_params)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/mysql/base.py", line 274, in get_new_connection
conn = Database.connect(**conn_params)
File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 86, in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 204, in __init__
super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (2003, "Can't connect to MySQL server on '192.168.9.13' (110)")
2020-03-07 11:32:05,752 [ERROR] django.request:135 handle_uncaught_exception Internal Server Error: /api/v2.1/repos/
Traceback (most recent call last):
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/core/handlers/exception.py", line 41, in inner
response = get_response(request)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/core/handlers/base.py", line 244, in _legacy_get_response
response = middleware_method(request)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/middleware/locale.py", line 25, in process_request
language = translation.get_language_from_request(request, check_path=i18n_patterns_used)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/utils/translation/__init__.py", line 211, in get_language_from_request
return _trans.get_language_from_request(request, check_path)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/utils/translation/trans_real.py", line 519, in get_language_from_request
lang_code = request.session.get(LANGUAGE_SESSION_KEY)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/contrib/sessions/backends/base.py", line 68, in get
return self._session.get(key, default)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/contrib/sessions/backends/base.py", line 207, in _get_session
self._session_cache = self.load()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/contrib/sessions/backends/db.py", line 35, in load
expire_date__gt=timezone.now()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/query.py", line 374, in get
num = len(clone)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/query.py", line 232, in __len__
self._fetch_all()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/query.py", line 1118, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/sql/compiler.py", line 887, in execute_sql
cursor = self.connection.cursor()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 254, in cursor
return self._cursor()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 229, in _cursor
self.ensure_connection()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 213, in ensure_connection
self.connect()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/utils.py", line 94, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 213, in ensure_connection
self.connect()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 189, in connect
self.connection = self.get_new_connection(conn_params)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/mysql/base.py", line 274, in get_new_connection
conn = Database.connect(**conn_params)
File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 86, in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 204, in __init__
super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (2003, "Can't connect to MySQL server on '192.168.9.13' (110)")
2020-03-07 11:37:37,532 [ERROR] django.request:135 handle_uncaught_exception Internal Server Error: /api/v2.1/notifications/
Traceback (most recent call last):
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/core/handlers/exception.py", line 41, in inner
response = get_response(request)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/core/handlers/base.py", line 244, in _legacy_get_response
response = middleware_method(request)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/middleware/locale.py", line 25, in process_request
language = translation.get_language_from_request(request, check_path=i18n_patterns_used)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/utils/translation/__init__.py", line 211, in get_language_from_request
return _trans.get_language_from_request(request, check_path)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/utils/translation/trans_real.py", line 519, in get_language_from_request
lang_code = request.session.get(LANGUAGE_SESSION_KEY)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/contrib/sessions/backends/base.py", line 68, in get
return self._session.get(key, default)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/contrib/sessions/backends/base.py", line 207, in _get_session
self._session_cache = self.load()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/contrib/sessions/backends/db.py", line 35, in load
expire_date__gt=timezone.now()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/query.py", line 374, in get
num = len(clone)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/query.py", line 232, in __len__
self._fetch_all()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/query.py", line 1118, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/sql/compiler.py", line 887, in execute_sql
cursor = self.connection.cursor()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 254, in cursor
return self._cursor()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 229, in _cursor
self.ensure_connection()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 213, in ensure_connection
self.connect()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/utils.py", line 94, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 213, in ensure_connection
self.connect()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 189, in connect
self.connection = self.get_new_connection(conn_params)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/mysql/base.py", line 274, in get_new_connection
conn = Database.connect(**conn_params)
File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 86, in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 204, in __init__
super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (2003, "Can't connect to MySQL server on '192.168.9.13' (110)")
2020-03-07 11:37:37,529 [ERROR] django.request:135 handle_uncaught_exception Internal Server Error: /api/v2.1/repos/cbc4110e-dbd2-4f92-a5d4-29349c009a3c/repo-tags/
Traceback (most recent call last):
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/core/handlers/exception.py", line 41, in inner
response = get_response(request)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/core/handlers/base.py", line 244, in _legacy_get_response
response = middleware_method(request)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/middleware/locale.py", line 25, in process_request
language = translation.get_language_from_request(request, check_path=i18n_patterns_used)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/utils/translation/__init__.py", line 211, in get_language_from_request
return _trans.get_language_from_request(request, check_path)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/utils/translation/trans_real.py", line 519, in get_language_from_request
lang_code = request.session.get(LANGUAGE_SESSION_KEY)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/contrib/sessions/backends/base.py", line 68, in get
return self._session.get(key, default)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/contrib/sessions/backends/base.py", line 207, in _get_session
self._session_cache = self.load()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/contrib/sessions/backends/db.py", line 35, in load
expire_date__gt=timezone.now()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/query.py", line 374, in get
num = len(clone)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/query.py", line 232, in __len__
self._fetch_all()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/query.py", line 1118, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/models/sql/compiler.py", line 887, in execute_sql
cursor = self.connection.cursor()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 254, in cursor
return self._cursor()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 229, in _cursor
self.ensure_connection()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 213, in ensure_connection
self.connect()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/utils.py", line 94, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 213, in ensure_connection
self.connect()
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/base/base.py", line 189, in connect
self.connection = self.get_new_connection(conn_params)
File "/opt/seafile/seafile-pro-server-7.0.13/seahub/thirdpart/django/db/backends/mysql/base.py", line 274, in get_new_connection
conn = Database.connect(**conn_params)
File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 86, in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 204, in __init__
super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (2003, "Can't connect to MySQL server on '192.168.9.13' (110)")
我是ubuntu server,我解决不了
我这边破案了,是我的MySQL一直给INNODB缓存池分配的内存太小了,没想到默认只有512M,提到2G后一切正常了
感谢