Log in /var/log/kolla/designate/designate-mdns.log

[SQL: SELECT recordsets.id, recordsets.type, recordsets.ttl, recordsets.name, records.data, records.action
FROM records INNER JOIN recordsets ON records.recordset_id = recordsets.id
WHERE records.action != %(action_1)s AND recordsets.zone_id = %(zone_id_1)s AND recordsets.type = %(type_1)s ORDER BY recordsets.id]
[parameters: {'action_1': 'DELETE', 'zone_id_1': '7727393d216f46c4ac74e60ec741abf5', 'type_1': 'SOA'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
2023-03-21 09:40:42.321 20 ERROR designate.service Traceback (most recent call last):
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1803, in _execute_context
2023-03-21 09:40:42.321 20 ERROR designate.service     cursor, statement, parameters, context
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
2023-03-21 09:40:42.321 20 ERROR designate.service     cursor.execute(statement, parameters)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/cursors.py", line 148, in execute
2023-03-21 09:40:42.321 20 ERROR designate.service     result = self._query(query)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/cursors.py", line 310, in _query
2023-03-21 09:40:42.321 20 ERROR designate.service     conn.query(q)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/connections.py", line 548, in query
2023-03-21 09:40:42.321 20 ERROR designate.service     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/connections.py", line 775, in _read_query_result
2023-03-21 09:40:42.321 20 ERROR designate.service     result.read()
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/connections.py", line 1163, in read
2023-03-21 09:40:42.321 20 ERROR designate.service     self._read_result_packet(first_packet)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/connections.py", line 1236, in _read_result_packet
2023-03-21 09:40:42.321 20 ERROR designate.service     self._read_rowdata_packet()
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/connections.py", line 1270, in _read_rowdata_packet
2023-03-21 09:40:42.321 20 ERROR designate.service     packet = self.connection._read_packet()
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/connections.py", line 725, in _read_packet
2023-03-21 09:40:42.321 20 ERROR designate.service     packet.raise_for_error()
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/protocol.py", line 221, in raise_for_error
2023-03-21 09:40:42.321 20 ERROR designate.service     err.raise_mysql_exception(self._data)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
2023-03-21 09:40:42.321 20 ERROR designate.service     raise errorclass(errno, errval)
2023-03-21 09:40:42.321 20 ERROR designate.service pymysql.err.OperationalError: (1712, 'Index records is corrupted')
2023-03-21 09:40:42.321 20 ERROR designate.service
2023-03-21 09:40:42.321 20 ERROR designate.service The above exception was the direct cause of the following exception:
2023-03-21 09:40:42.321 20 ERROR designate.service
2023-03-21 09:40:42.321 20 ERROR designate.service Traceback (most recent call last):
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/designate/service.py", line 276, in _dns_handle_tcp_conn
2023-03-21 09:40:42.321 20 ERROR designate.service     {'payload': query, 'addr': addr}):
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/designate/dnsutils.py", line 128, in __call__
2023-03-21 09:40:42.321 20 ERROR designate.service     for response in self.application(message):
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/designate/mdns/handler.py", line 75, in __call__
2023-03-21 09:40:42.321 20 ERROR designate.service     for response in self._handle_axfr(request):
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/designate/mdns/handler.py", line 233, in _handle_axfr
2023-03-21 09:40:42.321 20 ERROR designate.service     soa_records = self.storage.find_recordsets_axfr(context, criterion)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/designate/storage/impl_sqlalchemy/__init__.py", line 651, in find_recordsets_axfr
2023-03-21 09:40:42.321 20 ERROR designate.service     context, tables.recordsets, criterion, query)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/designate/sqlalchemy/base.py", line 616, in _select_raw
2023-03-21 09:40:42.321 20 ERROR designate.service     resultproxy = self.session.execute(query)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib64/python3.6/site-packages/sqlalchemy/orm/session.py", line 1692, in execute
2023-03-21 09:40:42.321 20 ERROR designate.service     result = conn._execute_20(statement, params or {}, execution_options)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1614, in _execute_20
2023-03-21 09:40:42.321 20 ERROR designate.service     return meth(self, args_10style, kwargs_10style, execution_options)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib64/python3.6/site-packages/sqlalchemy/sql/elements.py", line 326, in _execute_on_connection
2023-03-21 09:40:42.321 20 ERROR designate.service     self, multiparams, params, execution_options
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1491, in _execute_clauseelement
2023-03-21 09:40:42.321 20 ERROR designate.service     cache_hit=cache_hit,
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
2023-03-21 09:40:42.321 20 ERROR designate.service     e, statement, parameters, cursor, context
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 2024, in _handle_dbapi_exception
2023-03-21 09:40:42.321 20 ERROR designate.service     util.raise_(newraise, with_traceback=exc_info[2], from_=e)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
2023-03-21 09:40:42.321 20 ERROR designate.service     raise exception
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1803, in _execute_context
2023-03-21 09:40:42.321 20 ERROR designate.service     cursor, statement, parameters, context
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
2023-03-21 09:40:42.321 20 ERROR designate.service     cursor.execute(statement, parameters)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/cursors.py", line 148, in execute
2023-03-21 09:40:42.321 20 ERROR designate.service     result = self._query(query)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/cursors.py", line 310, in _query
2023-03-21 09:40:42.321 20 ERROR designate.service     conn.query(q)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/connections.py", line 548, in query
2023-03-21 09:40:42.321 20 ERROR designate.service     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/connections.py", line 775, in _read_query_result
2023-03-21 09:40:42.321 20 ERROR designate.service     result.read()
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/connections.py", line 1163, in read
2023-03-21 09:40:42.321 20 ERROR designate.service     self._read_result_packet(first_packet)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/connections.py", line 1236, in _read_result_packet
2023-03-21 09:40:42.321 20 ERROR designate.service     self._read_rowdata_packet()
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/connections.py", line 1270, in _read_rowdata_packet
2023-03-21 09:40:42.321 20 ERROR designate.service     packet = self.connection._read_packet()
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/connections.py", line 725, in _read_packet
2023-03-21 09:40:42.321 20 ERROR designate.service     packet.raise_for_error()
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/protocol.py", line 221, in raise_for_error
2023-03-21 09:40:42.321 20 ERROR designate.service     err.raise_mysql_exception(self._data)
2023-03-21 09:40:42.321 20 ERROR designate.service   File "/var/lib/kolla/venv/lib/python3.6/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
2023-03-21 09:40:42.321 20 ERROR designate.service     raise errorclass(errno, errval)
2023-03-21 09:40:42.321 20 ERROR designate.service sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1712, 'Index records is corrupted')
2023-03-21 09:40:42.321 20 ERROR designate.service [SQL: SELECT recordsets.id, recordsets.type, recordsets.ttl, recordsets.name, records.data, records.action
2023-03-21 09:40:42.321 20 ERROR designate.service FROM records INNER JOIN recordsets ON records.recordset_id = recordsets.id
2023-03-21 09:40:42.321 20 ERROR designate.service WHERE records.action != %(action_1)s AND recordsets.zone_id = %(zone_id_1)s AND recordsets.type = %(type_1)s ORDER BY recordsets.id]
2023-03-21 09:40:42.321 20 ERROR designate.service [parameters: {'action_1': 'DELETE', 'zone_id_1': '7727393d216f46c4ac74e60ec741abf5', 'type_1': 'SOA'}]
2023-03-21 09:40:42.321 20 ERROR designate.service (Background on this error at: https://sqlalche.me/e/14/e3q8)
2023-03-21 09:40:42.321 20 ERROR designate.service