Падает клиент mysql, в чем проблема?

[ericovva]

Internal Server Error: /admin/fias/suggest.json Traceback (most recent call last): File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/django/core/handlers/exception.py", line 42, in inner response = get_response(request) File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/django/core/handlers/base.py", line 187, in _get_response response = self.process_exception_by_middleware(e, request) File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/django/core/handlers/base.py", line 185, in _get_response response = wrapped_callback(request, *callback_args, callback_kwargs) File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/django/views/generic/base.py", line 68, in view return self.dispatch(request, *args, *kwargs) File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/django/views/generic/base.py", line 88, in dispatch return handler(request, args, kwargs) File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/fias/suggest/backends/sphinx/views.py", line 46, in get self.object_list = self.get_queryset() File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/fias/suggest/backends/sphinx/views.py", line 64, in get_queryset cur = connections['fias_search'].cursor() File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/django/db/backends/base/base.py", line 231, in cursor cursor = self.make_debug_cursor(self._cursor()) File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/django/db/backends/base/base.py", line 204, in _cursor self.ensure_connection() File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/django/db/backends/base/base.py", line 199, in ensure_connection self.connect() File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/django/db/backends/base/base.py", line 173, in connect self.init_connection_state() File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 269, in init_connection_state if self.features.is_sql_auto_is_null_enabled: File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/django/utils/functional.py", line 35, in get res = instance.dict[self.name] = self.func(instance) File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/django/db/backends/mysql/features.py", line 77, in is_sql_auto_is_null_enabled cursor.execute('SELECT @@SQL_AUTO_IS_NULL') File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/django/db/backends/utils.py", line 79, in execute return super(CursorDebugWrapper, self).execute(sql, params) File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/django/db/backends/utils.py", line 62, in execute return self.cursor.execute(sql) File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 110, in execute return self.cursor.execute(query, args) File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/MySQLdb/cursors.py", line 250, in execute self.errorhandler(self, exc, value) File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler raise errorvalue File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/MySQLdb/cursors.py", line 247, in execute res = self._query(query) File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/MySQLdb/cursors.py", line 412, in _query self._post_get_result() File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/MySQLdb/cursors.py", line 416, in _post_get_result self._rows = self._fetch_row(0) File "/Users/e.ovsepyan/.virtualenvs/ganesha_fias3/lib/python3.6/site-packages/MySQLdb/cursors.py", line 384, in _fetch_row return self._result.fetch_row(size, self._fetch_type) ValueError: invalid literal for int() with base 10: ''

база psql, python 3.6, настроил sphinx

[RomanKovalev]

Есть ли у кого подобная проблема? Как решали?

[ericovva]

@RomanKovalev Да, проблема решается изменением версии сфинкса. Если детализировать отправляемые запросы, то перед каждым коннектом mysql клиент запрашивает статус какой-то там переменной у mysql, но в сфинкс не поддерживает валидный ответ. Поиграйтесь с версией sphinx и проблема будет решена. Если хотите побороть с любой версией, то переопределите mysql клиент в месте, где выполняется этот запрос, я сделал таким образом

[ericovva]

@RomanKovalev чтобы найти этот запрос, включите режим DEBUG в логгере django

[RomanKovalev]

Вот мой лог запросов, запрос в сфинкс выделил жирным. Не могу найти проблему.

(0.004) SELECT c.relname, c.relkind FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('r', 'v') AND n.nspname NOT IN ('pg_catalog', 'pg_toast') AND pg_catalog.pg_table_is_visible(c.oid); args=None

(0.001) SELECT "django_migrations"."app", "django_migrations"."name" FROM "django_migrations"; args=()

(0.002) SELECT "django_session"."session_key", "django_session"."session_data", "django_session"."expire_date" FROM "django_session" WHERE ("django_session"."session_key" = 'db2l38t0skrfptus7cr1gxysk6jyvdrp' AND "django_session"."expire_date" > '2018-08-07T07:05:46.319630+00:00'::timestamptz); args=('db2l38t0skrfptus7cr1gxysk6jyvdrp', datetime.datetime(2018, 8, 7, 7, 5, 46, 319630, tzinfo=))

(0.001) SELECT "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1; args=(1,) (0.001) SELECT "django_content_type"."id", "django_content_type"."app_label", "django_content_type"."model" FROM "django_content_type" WHERE ("django_content_type"."app_label" = 'search' AND "django_content_type"."model" = 'item'); args=('search', 'item')

(0.003) SELECT "django_session"."session_key", "django_session"."session_data", "django_session"."expire_date" FROM "django_session" WHERE ("django_session"."session_key" = 'db2l38t0skrfptus7cr1gxysk6jyvdrp' AND "django_session"."expire_date" > '2018-08-07T07:05:46.480753+00:00'::timestamptz); args=('db2l38t0skrfptus7cr1gxysk6jyvdrp', datetime.datetime(2018, 8, 7, 7, 5, 46, 480753, tzinfo=))

(0.002) SELECT "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1; args=(1,)

(0.001) SELECT "aoguid", "fullname" FROM "default_addrobj" WHERE MATCH("''") ORDER BY item_weight DESC,weight() DESC LIMIT 30; args=('',)

(0.002) SELECT "django_session"."session_key", "django_session"."session_data", "django_session"."expire_date" FROM "django_session" WHERE ("django_session"."session_key" = 'db2l38t0skrfptus7cr1gxysk6jyvdrp' AND "django_session"."expire_date" > '2018-08-07T07:05:47.912403+00:00'::timestamptz); args=('db2l38t0skrfptus7cr1gxysk6jyvdrp', datetime.datetime(2018, 8, 7, 7, 5, 47, 912403, tzinfo=))

(0.001) SELECT "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1; args=(1,) (0.001) SELECT "aoguid", "fullname" FROM "default_addrobj" WHERE MATCH("'М'") ORDER BY item_weight DESC,weight() DESC LIMIT 30; args=('М',) (0.002) SELECT "django_session"."session_key", "django_session"."session_data", "django_session"."expire_date" FROM "django_session" WHERE ("django_session"."session_key" = 'db2l38t0skrfptus7cr1gxysk6jyvdrp' AND "django_session"."expire_date" > '2018-08-07T07:05:49.856030+00:00'::timestamptz); args=('db2l38t0skrfptus7cr1gxysk6jyvdrp', datetime.datetime(2018, 8, 7, 7, 5, 49, 856030, tzinfo=))

(0.001) SELECT "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1; args=(1,)

(0.001) SELECT "aoguid", "fullname" FROM "default_addrobj" WHERE MATCH("'Мо'") ORDER BY item_weight DESC,weight() DESC LIMIT 30; args=('Мо',)

(0.002) SELECT "django_session"."session_key", "django_session"."session_data", "django_session"."expire_date" FROM "django_session" WHERE ("django_session"."session_key" = 'db2l38t0skrfptus7cr1gxysk6jyvdrp' AND "django_session"."expire_date" > '2018-08-07T07:05:50.224246+00:00'::timestamptz); args=('db2l38t0skrfptus7cr1gxysk6jyvdrp', datetime.datetime(2018, 8, 7, 7, 5, 50, 224246, tzinfo=))

(0.001) SELECT "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1; args=(1,)

(0.001) SELECT "aoguid", "fullname" FROM "default_addrobj" WHERE MATCH("'Мос'") ORDER BY item_weight DESC,weight() DESC LIMIT 30; args=('Мос',)

(0.002) SELECT "django_session"."session_key", "django_session"."session_data", "django_session"."expire_date" FROM "django_session" WHERE ("django_session"."session_key" = 'db2l38t0skrfptus7cr1gxysk6jyvdrp' AND "django_session"."expire_date" > '2018-08-07T07:05:50.569152+00:00'::timestamptz); args=('db2l38t0skrfptus7cr1gxysk6jyvdrp', datetime.datetime(2018, 8, 7, 7, 5, 50, 569152, tzinfo=))

(0.001) SELECT "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1; args=(1,)

[RomanKovalev]

А вот, походу, и проблема.

Запатчил так: django.db.backends.mysql.features def is_sql_auto_is_null_enabled(self): pass

Трейс: (0.004) SELECT c.relname, c.relkind FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('r', 'v') AND n.nspname NOT IN ('pg_catalog', 'pg_toast') AND pg_catalog.pg_table_is_visible(c.oid); args=None

(0.001) SELECT "django_migrations"."app", "django_migrations"."name" FROM "django_migrations"; args=()

(0.002) SELECT "django_session"."session_key", "django_session"."session_data", "django_session"."expire_date" FROM "django_session" WHERE ("django_session"."session_key" = 'db2l38t0skrfptus7cr1gxysk6jyvdrp' AND "django_session"."expire_date" > '2018-08-07T08:46:26.336757+00:00'::timestamptz); args=('db2l38t0skrfptus7cr1gxysk6jyvdrp', datetime.datetime(2018, 8, 7, 8, 46, 26, 336757, tzinfo=))

(0.001) SELECT "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1; args=(1,)

(0.001) SELECT "django_content_type"."id", "django_content_type"."app_label", "django_content_type"."model" FROM "django_content_type" WHERE ("django_content_type"."app_label" = 'search' AND "django_content_type"."model" = 'item'); args=('search', 'item')

(0.002) SELECT "django_session"."session_key", "django_session"."session_data", "django_session"."expire_date" FROM "django_session" WHERE ("django_session"."session_key" = 'db2l38t0skrfptus7cr1gxysk6jyvdrp' AND "django_session"."expire_date" > '2018-08-07T08:46:26.489612+00:00'::timestamptz); args=('db2l38t0skrfptus7cr1gxysk6jyvdrp', datetime.datetime(2018, 8, 7, 8, 46, 26, 489612, tzinfo=))

(0.002) SELECT "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1; args=(1,)

(0.000) SELECT @@SQL_AUTO_IS_NULL; args=None

(0.002) SELECT "django_session"."session_key", "django_session"."session_data", "django_session"."expire_date" FROM "django_session" WHERE ("django_session"."session_key" = 'db2l38t0skrfptus7cr1gxysk6jyvdrp' AND "django_session"."expire_date" > '2018-08-07T08:46:28.670015+00:00'::timestamptz); args=('db2l38t0skrfptus7cr1gxysk6jyvdrp', datetime.datetime(2018, 8, 7, 8, 46, 28, 670015, tzinfo=)) (0.001) SELECT "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1; args=(1,)

(0.000) SELECT @@SQL_AUTO_IS_NULL; args=None

(0.002) SELECT "django_session"."session_key", "django_session"."session_data", "django_session"."expire_date" FROM "django_session" WHERE ("django_session"."session_key" = 'db2l38t0skrfptus7cr1gxysk6jyvdrp' AND "django_session"."expire_date" > '2018-08-07T08:46:29.986753+00:00'::timestamptz); args=('db2l38t0skrfptus7cr1gxysk6jyvdrp', datetime.datetime(2018, 8, 7, 8, 46, 29, 986753, tzinfo=))

(0.001) SELECT "auth_user"."id", "auth_user"."password", "auth_user"."last_login", "auth_user"."is_superuser", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."id" = 1; args=(1,)