Created
February 23, 2017 16:28
-
-
Save amir-qayyum-khan/020709bb1b885830a5ba8f84481696ba to your computer and use it in GitHub Desktop.
Lock wait timeout exceeded; try restarting transaction
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
- When user tries to register platform its gets held | |
- On log there is exception | |
- changed to tx commit level to READ-COMMITTED but not fix same error. | |
- `SHOW ENGINE INNODB STATUS\G` it show some thead blocking and taking time | |
```---TRANSACTION 3269084, ACTIVE 122 sec | |
5 lock struct(s), heap size 1184, 1 row lock(s), undo log entries 4 | |
MySQL thread id 212, OS thread handle 0x7fc86fa15700, query id 2914 localhost edxapp001 cleaning up | |
Trx read view will not see trx with id >= 3269085, sees < 3268825``` | |
- Sometimes it give us error like gateway time our, and screen gets halt of registration but after soe time lets say a min, | |
it mysql creates record from backhround, but form left halt, we will refresh to resubmit it say you are already register. | |
And recoreds are there in db. | |
Feb 23 15:54:16 ip-172-31-60-241 [service_variant=lms][root][env:sandbox] ERROR [ip-172-31-60-241 24023] [exceptions.py:9] - Uncaught exception from <class 'django.core.handlers.wsgi.WSGIHandler'> | |
Traceback (most recent call last): | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/core/handlers/base.py", line 132, in get_response | |
response = wrapped_callback(request, *callback_args, **callback_kwargs) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/utils/decorators.py", line 145, in inner | |
return func(*args, **kwargs) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/views/decorators/csrf.py", line 58, in wrapped_view | |
return view_func(*args, **kwargs) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/views/generic/base.py", line 71, in view | |
return self.dispatch(request, *args, **kwargs) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/rest_framework/views.py", line 466, in dispatch | |
response = self.handle_exception(exc) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/rest_framework/views.py", line 463, in dispatch | |
response = handler(request, *args, **kwargs) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/utils/decorators.py", line 34, in _wrapper | |
return bound_func(*args, **kwargs) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/views/decorators/csrf.py", line 58, in wrapped_view | |
return view_func(*args, **kwargs) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/utils/decorators.py", line 30, in bound_func | |
return func.__get__(self, type(self))(*args2, **kwargs2) | |
File "/edx/app/edxapp/edx-platform/openedx/core/djangoapps/user_api/views.py", line 343, in post | |
user = create_account_with_params(request, data) | |
File "/edx/app/edxapp/edx-platform/common/djangoapps/student/views.py", line 1766, in create_account_with_params | |
(user, profile, registration) = _do_create_account(form, custom_form) | |
File "/edx/app/edxapp/edx-platform/common/djangoapps/student/views.py", line 1634, in _do_create_account | |
user.save() | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/base.py", line 734, in save | |
force_update=force_update, update_fields=update_fields) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/base.py", line 762, in save_base | |
updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/base.py", line 846, in _save_table | |
result = self._do_insert(cls._base_manager, using, fields, update_pk, raw) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/base.py", line 885, in _do_insert | |
using=using, raw=raw) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/manager.py", line 127, in manager_method | |
return getattr(self.get_queryset(), name)(*args, **kwargs) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/query.py", line 920, in _insert | |
return query.get_compiler(using=using).execute_sql(return_id) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 974, in execute_sql | |
cursor.execute(sql, params) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute | |
return self.cursor.execute(sql, params) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/utils.py", line 98, in __exit__ | |
six.reraise(dj_exc_type, dj_exc_value, traceback) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute | |
return self.cursor.execute(sql, params) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 124, in execute | |
return self.cursor.execute(query, args) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute | |
self.errorhandler(self, exc, value) | |
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler | |
raise errorclass, errorvalue | |
OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment