#28957: Django database error
-------------------------------------+-------------------------------------
Reporter: nishit | Owner: nobody
Type: Bug | Status: closed
Component: Database layer | Version: 1.11
(models, ORM) |
Severity: Release blocker | Resolution: invalid
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Description changed by Tim Graham:
Old description:
> I have RDS read only permission.In my code i am not violating to read
> permission.
>
> following the error.
>
> /usr/local/lib/python3.6/site-packages/fuzzywuzzy/fuzz.py:35:
> UserWarning: Using slow pure-python SequenceMatcher. Install python-
> Levenshtein to remove this warning
> warnings.warn('Using slow pure-python SequenceMatcher. Install python-
> Levenshtein to remove this warning')
> System check identified no issues (0 silenced).
> December 22, 2017 - 02:32:23
> Django version 1.11.5, using settings 'scoretool.settings'
> Starting development server at http://0.0.0.0:80/
> Quit the server with CONTROL-C.
> unavailable: Database error
> Traceback (most recent call last):
> File "/usr/local/lib/python3.6/site-
> packages/django/db/backends/utils.py", line 65, in execute
> return self.cursor.execute(sql, params)
> File "/usr/local/lib/python3.6/site-
> packages/django/db/backends/mysql/base.py", line 101, in execute
> return self.cursor.execute(query, args)
> File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
> 250, in execute
> self.errorhandler(self, exc, value)
> File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py",
> line 50, in defaulterrorhandler
> raise errorvalue
> File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
> 247, in execute
> res = self._query(query)
> File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
> 411, in _query
> rowcount = self._do_query(q)
> File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
> 374, in _do_query
> db.query(q)
> File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py",
> line 277, in query
> _mysql.connection.query(self, query)
> _mysql_exceptions.OperationalError: (1290, 'The MySQL server is running
> with the --read-only option so it cannot execute this statement')
> The above exception was the direct cause of the following exception:
> Traceback (most recent call last):
> File "/usr/local/lib/python3.6/site-
> packages/health_check/db/backends.py", line 15, in check_status
> obj = TestModel.objects.create(title="test")
> File "/usr/local/lib/python3.6/site-
> packages/django/db/models/manager.py", line 85, in manager_method
> return getattr(self.get_queryset(), name)(*args, **kwargs)
> File "/usr/local/lib/python3.6/site-
> packages/django/db/models/query.py", line 394, in create
> obj.save(force_insert=True, using=self.db)
> File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py",
> line 807, in save
> force_update=force_update, update_fields=update_fields)
> File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py",
> line 837, in save_base
> updated = self._save_table(raw, cls, force_insert, force_update,
> using, update_fields)
> File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py",
> line 923, in _save_table
> result = self._do_insert(cls._base_manager, using, fields, update_pk,
> raw)
> File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py",
> line 962, in _do_insert
> using=using, raw=raw)
> File "/usr/local/lib/python3.6/site-
> packages/django/db/models/manager.py", line 85, in manager_method
> return getattr(self.get_queryset(), name)(*args, **kwargs)
> File "/usr/local/lib/python3.6/site-
> packages/django/db/models/query.py", line 1076, in _insert
> return query.get_compiler(using=using).execute_sql(return_id)
> File "/usr/local/lib/python3.6/site-
> packages/django/db/models/sql/compiler.py", line 1107, in execute_sql
> cursor.execute(sql, params)
> File "/usr/local/lib/python3.6/site-
> packages/django/db/backends/utils.py", line 80, in execute
> return super(CursorDebugWrapper, self).execute(sql, params)
> File "/usr/local/lib/python3.6/site-
> packages/django/db/backends/utils.py", line 65, in execute
> return self.cursor.execute(sql, params)
> File "/usr/local/lib/python3.6/site-packages/django/db/utils.py", line
> 94, in __exit__
> six.reraise(dj_exc_type, dj_exc_value, traceback)
> File "/usr/local/lib/python3.6/site-packages/django/utils/six.py", line
> 685, in reraise
> raise value.with_traceback(tb)
> File "/usr/local/lib/python3.6/site-
> packages/django/db/backends/utils.py", line 65, in execute
> return self.cursor.execute(sql, params)
> File "/usr/local/lib/python3.6/site-
> packages/django/db/backends/mysql/base.py", line 101, in execute
> return self.cursor.execute(query, args)
> File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
> 250, in execute
> self.errorhandler(self, exc, value)
> File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py",
> line 50, in defaulterrorhandler
> raise errorvalue
> File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
> 247, in execute
> res = self._query(query)
> File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
> 411, in _query
> rowcount = self._do_query(q)
> File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
> 374, in _do_query
> db.query(q)
> File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py",
> line 277, in query
> _mysql.connection.query(self, query)
> django.db.utils.OperationalError: (1290, 'The MySQL server is running
> with the --read-only option so it cannot execute this statement')
New description:
I have RDS read only permission.In my code i am not violating to read
permission.
following the error.
{{{
/usr/local/lib/python3.6/site-packages/fuzzywuzzy/fuzz.py:35: UserWarning:
Using slow pure-python SequenceMatcher. Install python-Levenshtein to
remove this warning
warnings.warn('Using slow pure-python SequenceMatcher. Install python-
Levenshtein to remove this warning')
System check identified no issues (0 silenced).
December 22, 2017 - 02:32:23
Django version 1.11.5, using settings 'scoretool.settings'
Starting development server at http://0.0.0.0:80/
Quit the server with CONTROL-C.
unavailable: Database error
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-
packages/django/db/backends/utils.py", line 65, in execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/python3.6/site-
packages/django/db/backends/mysql/base.py", line 101, in execute
return self.cursor.execute(query, args)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
250, in execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py",
line 50, in defaulterrorhandler
raise errorvalue
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
247, in execute
res = self._query(query)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
411, in _query
rowcount = self._do_query(q)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
374, in _do_query
db.query(q)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py",
line 277, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1290, 'The MySQL server is running
with the --read-only option so it cannot execute this statement')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-
packages/health_check/db/backends.py", line 15, in check_status
obj = TestModel.objects.create(title="test")
File "/usr/local/lib/python3.6/site-
packages/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py",
line 394, in create
obj.save(force_insert=True, using=self.db)
File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py",
line 807, in save
force_update=force_update, update_fields=update_fields)
File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py",
line 837, in save_base
updated = self._save_table(raw, cls, force_insert, force_update,
using, update_fields)
File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py",
line 923, in _save_table
result = self._do_insert(cls._base_manager, using, fields, update_pk,
raw)
File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py",
line 962, in _do_insert
using=using, raw=raw)
File "/usr/local/lib/python3.6/site-
packages/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py",
line 1076, in _insert
return query.get_compiler(using=using).execute_sql(return_id)
File "/usr/local/lib/python3.6/site-
packages/django/db/models/sql/compiler.py", line 1107, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.6/site-
packages/django/db/backends/utils.py", line 80, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "/usr/local/lib/python3.6/site-
packages/django/db/backends/utils.py", line 65, in execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/python3.6/site-packages/django/db/utils.py", line
94, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python3.6/site-packages/django/utils/six.py", line
685, in reraise
raise value.with_traceback(tb)
File "/usr/local/lib/python3.6/site-
packages/django/db/backends/utils.py", line 65, in execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/python3.6/site-
packages/django/db/backends/mysql/base.py", line 101, in execute
return self.cursor.execute(query, args)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
250, in execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py",
line 50, in defaulterrorhandler
raise errorvalue
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
247, in execute
res = self._query(query)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
411, in _query
rowcount = self._do_query(q)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
374, in _do_query
db.query(q)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py",
line 277, in query
_mysql.connection.query(self, query)
django.db.utils.OperationalError: (1290, 'The MySQL server is running with
the --read-only option so it cannot execute this statement')
}}}
--
--
Ticket URL: <https://code.djangoproject.com/ticket/28957#comment:3>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/070.0402451cfbe9bbf5e2b8ce1bb20f74dc%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
