MySQL Forums
Forum List  »  Newbie

django.db.utils.OperationalError: (2013, 'Lost connection to MySQL server during query')
Posted by: prusa seo
Date: December 29, 2022 02:04PM

I create a django app to shared hosting. Everything is good but when i came to createsuperuser i see this problem...

I made lots of things, i increased connect timeout and read timeout but nothing changed. How can i solve this?

i made connect_timeout=100000, i made read_timeout=120,

i tried to shell for create super user, i wrote username, no error, i wrote email, no error, i wrote pass and i got this error....

((endustrio:3.9)) [endustri1@cp66 endustrio]$ python manage.py createsuperuser
Kullanıcı adı (leave blank to use 'endustri1'): admin
E-posta adresi: xxxx@gmail.com
Password:
Password (again):
Traceback (most recent call last):
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 75, in execute
return self.cursor.execute(query, args)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/pymysql/connections.py", line 701, in _read_packet
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query')

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/home/endustri1/endustrio/manage.py", line 22, in <module>
main()
File "/home/endustri1/endustrio/manage.py", line 18, in main
execute_from_command_line(sys.argv)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/core/management/__init__.py", line 446, in execute_from_command_line
utility.execute()
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/core/management/__init__.py", line 440, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/core/management/base.py", line 402, in run_from_argv
self.execute(*args, **cmd_options)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/contrib/auth/management/commands/createsuperuser.py", line 88, in execute
return super().execute(*args, **options)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/core/management/base.py", line 448, in execute
output = self.handle(*args, **options)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/contrib/auth/management/commands/createsuperuser.py", line 233, in handle
self.UserModel._default_manager.db_manager(database).create_superuser(
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/contrib/auth/models.py", line 172, in create_superuser
return self._create_user(username, email, password, **extra_fields)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/contrib/auth/models.py", line 155, in _create_user
user.save(using=self._db)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/contrib/auth/base_user.py", line 68, in save
super().save(*args, **kwargs)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/db/models/base.py", line 812, in save
self.save_base(
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/db/models/base.py", line 863, in save_base
updated = self._save_table(
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/db/models/base.py", line 1006, in _save_table
results = self._do_insert(
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/db/models/base.py", line 1047, in _do_insert
return manager._insert(
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/db/models/query.py", line 1791, in _insert
return query.get_compiler(using=using).execute_sql(returning_fields)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1660, in execute_sql
cursor.execute(sql, params)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/db/backends/utils.py", line 103, in execute
return super().execute(sql, params)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/db/backends/utils.py", line 67, in execute
return self._execute_with_wrappers(
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/db/utils.py", line 91, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 75, in execute
return self.cursor.execute(query, args)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/endustri1/virtualenv/endustrio/3.9/lib/python3.9/site-packages/pymysql/connections.py", line 701, in _read_packet
raise err.OperationalError(
django.db.utils.OperationalError: (2013, 'Lost connection to MySQL server during query')

Options: ReplyQuote


Subject
Written By
Posted
django.db.utils.OperationalError: (2013, 'Lost connection to MySQL server during query')
December 29, 2022 02:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.