debug dataset crashes on mysql due to missing feature
django.db.utils.NotSupportedError: (1235, "This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'")
When adding coordinates to the list of objects.
~$ sudo failmap-admin create-test-dataset -o -> test_dataset_12nov2017.json 201711-12 20:11 INFO - Database settings: django.db.backends.mysql, failmap, failmap, /var/run/mysqld/mysqld.sock Traceback (most recent call last): File "/pyenv/lib/python3.6/site-packages/django/db/backends/utils.py", line 65, in execute return self.cursor.execute(sql, params) File "/pyenv/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 101, in execute return self.cursor.execute(query, args) File "/pyenv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 250, in execute self.errorhandler(self, exc, value) File "/pyenv/lib/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler raise errorvalue File "/pyenv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 247, in execute res = self._query(query) File "/pyenv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 411, in _query rowcount = self._do_query(q) File "/pyenv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 374, in _do_query db.query(q) File "/pyenv/lib/python3.6/site-packages/MySQLdb/connections.py", line 277, in query _mysql.connection.query(self, query) _mysql_exceptions.NotSupportedError: (1235, "This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'")
The above exception was the direct cause of the following exception:
Traceback (most recent call last): File "/usr/local/bin/failmap-admin", line 11, in load_entry_point('failmap-admin', 'console_scripts', 'failmap-admin')() File "/source/failmap_admin/manage.py", line 11, in main execute_from_command_line(sys.argv) File "/pyenv/lib/python3.6/site-packages/django/core/management/init.py", line 364, in execute_from_command_line utility.execute() File "/pyenv/lib/python3.6/site-packages/django/core/management/init.py", line 356, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/pyenv/lib/python3.6/site-packages/django/core/management/base.py", line 283, in run_from_argv self.execute(*args, **cmd_options) File "/pyenv/lib/python3.6/site-packages/django/core/management/base.py", line 330, in execute output = self.handle(*args, **options) File "/source/failmap_admin/organizations/management/commands/create-test-dataset.py", line 66, in handle objects += coordinates File "/pyenv/lib/python3.6/site-packages/django/db/models/query.py", line 250, in iter self._fetch_all() File "/pyenv/lib/python3.6/site-packages/django/db/models/query.py", line 1118, in _fetch_all self._result_cache = list(self._iterable_class(self)) File "/pyenv/lib/python3.6/site-packages/django/db/models/query.py", line 53, in iter results = compiler.execute_sql(chunked_fetch=self.chunked_fetch) File "/pyenv/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 894, in execute_sql raise original_exception File "/pyenv/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 884, in execute_sql cursor.execute(sql, params) File "/pyenv/lib/python3.6/site-packages/django_statsd/patches/utils.py", line 12, in wrapper return patch_function(original_function, *args, **kw) File "/pyenv/lib/python3.6/site-packages/django_statsd/patches/db.py", line 20, in patched_execute return orig_execute(self, query, *args, **kwargs) File "/pyenv/lib/python3.6/site-packages/django/db/backends/utils.py", line 65, in execute return self.cursor.execute(sql, params) File "/pyenv/lib/python3.6/site-packages/django/db/utils.py", line 94, in exit six.reraise(dj_exc_type, dj_exc_value, traceback) File "/pyenv/lib/python3.6/site-packages/django/utils/six.py", line 685, in reraise raise value.with_traceback(tb) File "/pyenv/lib/python3.6/site-packages/django/db/backends/utils.py", line 65, in execute return self.cursor.execute(sql, params) File "/pyenv/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 101, in execute return self.cursor.execute(query, args) File "/pyenv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 250, in execute self.errorhandler(self, exc, value) File "/pyenv/lib/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler raise errorvalue File "/pyenv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 247, in execute res = self._query(query) File "/pyenv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 411, in _query rowcount = self._do_query(q) File "/pyenv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 374, in _do_query db.query(q) File "/pyenv/lib/python3.6/site-packages/MySQLdb/connections.py", line 277, in query _mysql.connection.query(self, query) django.db.utils.NotSupportedError: (1235, "This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'")