Complete
Details
Details
Assignee
Vladimir Vinogradenko
Vladimir VinogradenkoReporter
Mark Stega
Mark StegaLabels
Time remaining
0m
Components
Fix versions
Affects versions
Priority
Katalon Platform
Katalon Platform
Created November 15, 2021 at 2:04 PM
Updated July 1, 2022 at 5:51 PM
Resolved January 19, 2022 at 6:46 PM
Failed to check for alert CertificateRevoked: Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1247, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such column: system_advanced.adv_syslog_tls_certificate_authority_id The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/middlewared/plugins/alert.py", line 740, in _run_source alerts = (await alert_source.check()) or [] File "/usr/local/lib/python3.9/site-packages/middlewared/alert/source/certificates.py", line 90, in check (await self.middleware.call('system.advanced.config'))['syslog_tls_certificate'], File "/usr/local/lib/python3.9/site-packages/middlewared/main.py", line 1256, in call return await self._call( File "/usr/local/lib/python3.9/site-packages/middlewared/main.py", line 1213, in _call return await methodobj(*prepared_call.args) File "/usr/local/lib/python3.9/site-packages/middlewared/schema.py", line 975, in nf return await f(*args, **kwargs) File "/usr/local/lib/python3.9/site-packages/middlewared/service.py", line 373, in config return await self._get_or_insert(self._config.datastore, options) File "/usr/local/lib/python3.9/site-packages/middlewared/service.py", line 385, in _get_or_insert return await self.middleware.call('datastore.config', datastore, options) File "/usr/local/lib/python3.9/site-packages/middlewared/main.py", line 1256, in call return await self._call( File "/usr/local/lib/python3.9/site-packages/middlewared/main.py", line 1213, in _call return await methodobj(*prepared_call.args) File "/usr/local/lib/python3.9/site-packages/middlewared/schema.py", line 975, in nf return await f(*args, **kwargs) File "/usr/local/lib/python3.9/site-packages/middlewared/plugins/datastore/read.py", line 186, in config return await self.query(name, [], options) File "/usr/local/lib/python3.9/site-packages/middlewared/schema.py", line 975, in nf return await f(*args, **kwargs) File "/usr/local/lib/python3.9/site-packages/middlewared/plugins/datastore/read.py", line 157, in query result = await self.middleware.call("datastore.fetchall", qs) File "/usr/local/lib/python3.9/site-packages/middlewared/main.py", line 1256, in call return await self._call( File "/usr/local/lib/python3.9/site-packages/middlewared/main.py", line 1213, in _call return await methodobj(*prepared_call.args) File "/usr/local/lib/python3.9/site-packages/middlewared/plugins/datastore/connection.py", line 81, in fetchall return await self.middleware.run_in_executor(self.thread_pool, self._fetchall, *args) File "/usr/local/lib/python3.9/site-packages/middlewared/main.py", line 1128, in run_in_executor return await loop.run_in_executor(pool, functools.partial(method, *args, **kwargs)) File "/usr/local/lib/python3.9/concurrent/futures/thread.py", line 52, in run result = self.fn(*self.args, **self.kwargs) File "/usr/local/lib/python3.9/site-packages/middlewared/plugins/datastore/connection.py", line 84, in _fetchall cursor = self.connection.execute(query, params or []) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 984, in execute return meth(self, multiparams, params) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 293, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1097, in _execute_clauseelement ret = self._execute_context( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1287, in _execute_context self._handle_dbapi_exception( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1481, in _handle_dbapi_exception util.raise( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 178, in raise_ raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1247, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: system_advanced.adv_syslog_tls_certificate_authority_id [SQL: SELECT system_advanced.id, system_advanced.adv_consolemenu, system_advanced.adv_serialconsole, system_advanced.adv_serialport, system_advanced.adv_serialspeed, system_advanced.adv_powerdaemon, system_advanced.adv_swapondrive, system_advanced.adv_overprovision, system_advanced.adv_consolemsg, system_advanced.adv_traceback, system_advanced.adv_advancedmode, system_advanced.adv_autotune, system_advanced.adv_debugkernel, system_advanced.adv_uploadcrash, system_advanced.adv_anonstats, system_advanced.adv_anonstats_token, system_advanced.adv_motd, system_advanced.adv_boot_scrub, system_advanced.adv_fqdn_syslog, system_advanced.adv_sed_user, system_advanced.adv_sed_passwd, system_advanced.adv_sysloglevel, system_advanced.adv_syslogserver, system_advanced.adv_syslog_transport, system_advanced.adv_syslog_tls_certificate_id, system_advanced.adv_syslog_tls_certificate_authority_id, system_advanced.adv_kmip_uid, system_certificate_1.id, system_certificate_1.cert_type, system_certificate_1.cert_name, system_certificate_1.cert_certificate, system_certificate_1.cert_privatekey, system_certificate_1."cert_CSR", system_certificate_1.cert_signedby_id, system_certificate_1.cert_acme_uri, system_certificate_1.cert_domains_authenticators, system_certificate_1.cert_renew_days, system_certificate_1.cert_acme_id, system_certificate_1.cert_revoked_date, system_certificateauthority_1.id, system_certificateauthority_1.cert_type, system_certificateauthority_1.cert_name, system_certificateauthority_1.cert_certificate, system_certificateauthority_1.cert_privatekey, system_certificateauthority_1."cert_CSR", system_certificateauthority_1.cert_revoked_date, system_certificateauthority_1.cert_signedby_id, system_certificateauthority_2.id, system_certificateauthority_2.cert_type, system_certificateauthority_2.cert_name, system_certificateauthority_2.cert_certificate, system_certificateauthority_2.cert_privatekey, system_certificateauthority_2."cert_CSR", system_certificateauthority_2.cert_revoked_date, system_certificateauthority_2.cert_signedby_id, system_acmeregistration_1.id, system_acmeregistration_1.uri, system_acmeregistration_1.directory, system_acmeregistration_1.tos, system_acmeregistration_1.new_account_uri, system_acmeregistration_1.new_nonce_uri, system_acmeregistration_1.new_order_uri, system_acmeregistration_1.revoke_cert_uri, system_certificateauthority_3.id, system_certificateauthority_3.cert_type, system_certificateauthority_3.cert_name, system_certificateauthority_3.cert_certificate, system_certificateauthority_3.cert_privatekey, system_certificateauthority_3."cert_CSR", system_certificateauthority_3.cert_revoked_date, system_certificateauthority_3.cert_signedby_id, system_certificateauthority_4.id, system_certificateauthority_4.cert_type, system_certificateauthority_4.cert_name, system_certificateauthority_4.cert_certificate, system_certificateauthority_4.cert_privatekey, system_certificateauthority_4."cert_CSR", system_certificateauthority_4.cert_revoked_date, system_certificateauthority_4.cert_signedby_id FROM system_advanced LEFT OUTER JOIN system_certificate AS system_certificate_1 ON system_certificate_1.id = system_advanced.adv_syslog_tls_certificate_id LEFT OUTER JOIN system_certificateauthority AS system_certificateauthority_1 ON system_certificateauthority_1.id = system_certificate_1.cert_signedby_id LEFT OUTER JOIN system_certificateauthority AS system_certificateauthority_2 ON system_certificateauthority_2.id = system_certificateauthority_1.cert_signedby_id LEFT OUTER JOIN system_acmeregistration AS system_acmeregistration_1 ON system_acmeregistration_1.id = system_certificate_1.cert_acme_id LEFT OUTER JOIN system_certificateauthority AS system_certificateauthority_3 ON system_certificateauthority_3.id = system_advanced.adv_syslog_tls_certificate_authority_id LEFT OUTER JOIN system_certificateauthority AS system_certificateauthority_4 ON system_certificateauthority_4.id = system_certificateauthority_3.cert_signedby_id] (Background on this error at: http://sqlalche.me/e/e3q8)