2025-10-05 08:20:15,183 [2] INFO gnocchi.service: Gnocchi version 4.4.6.dev2+gff96e73d 2025-10-05 08:20:15,183 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:15,183 [2] DEBUG gnocchi.service: Configuration options gathered from: 2025-10-05 08:20:15,183 [2] DEBUG gnocchi.service: command line args: [] 2025-10-05 08:20:15,184 [2] DEBUG gnocchi.service: config files: ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:15,184 [2] DEBUG gnocchi.service: ================================================================================ 2025-10-05 08:20:15,184 [2] DEBUG gnocchi.service: config_dir = [] 2025-10-05 08:20:15,184 [2] DEBUG gnocchi.service: config_file = ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:15,184 [2] DEBUG gnocchi.service: config_source = [] 2025-10-05 08:20:15,184 [2] DEBUG gnocchi.service: coordination_url = **** 2025-10-05 08:20:15,184 [2] DEBUG gnocchi.service: debug = True 2025-10-05 08:20:15,184 [2] DEBUG gnocchi.service: log_dir = /var/log/gnocchi 2025-10-05 08:20:15,184 [2] DEBUG gnocchi.service: log_file = None 2025-10-05 08:20:15,184 [2] DEBUG gnocchi.service: parallel_operations = 8 2025-10-05 08:20:15,184 [2] DEBUG gnocchi.service: syslog_log_facility = user 2025-10-05 08:20:15,184 [2] DEBUG gnocchi.service: use_journal = False 2025-10-05 08:20:15,184 [2] DEBUG gnocchi.service: use_syslog = False 2025-10-05 08:20:15,184 [2] DEBUG gnocchi.service: verbose = True 2025-10-05 08:20:15,184 [2] DEBUG gnocchi.service: database.backend = sqlalchemy 2025-10-05 08:20:15,184 [2] DEBUG gnocchi.service: database.connection = **** 2025-10-05 08:20:15,185 [2] DEBUG gnocchi.service: database.connection_debug = 0 2025-10-05 08:20:15,185 [2] DEBUG gnocchi.service: database.connection_parameters = 2025-10-05 08:20:15,185 [2] DEBUG gnocchi.service: database.connection_recycle_time = 3600 2025-10-05 08:20:15,185 [2] DEBUG gnocchi.service: database.connection_trace = False 2025-10-05 08:20:15,185 [2] DEBUG gnocchi.service: database.db_inc_retry_interval = True 2025-10-05 08:20:15,185 [2] DEBUG gnocchi.service: database.db_max_retries = 20 2025-10-05 08:20:15,185 [2] DEBUG gnocchi.service: database.db_max_retry_interval = 10 2025-10-05 08:20:15,185 [2] DEBUG gnocchi.service: database.db_retry_interval = 1 2025-10-05 08:20:15,185 [2] DEBUG gnocchi.service: database.max_overflow = 50 2025-10-05 08:20:15,185 [2] DEBUG gnocchi.service: database.max_pool_size = 5 2025-10-05 08:20:15,185 [2] DEBUG gnocchi.service: database.max_retries = 10 2025-10-05 08:20:15,185 [2] DEBUG gnocchi.service: database.mysql_enable_ndb = False 2025-10-05 08:20:15,185 [2] DEBUG gnocchi.service: database.mysql_sql_mode = TRADITIONAL 2025-10-05 08:20:15,185 [2] DEBUG gnocchi.service: database.pool_timeout = None 2025-10-05 08:20:15,185 [2] DEBUG gnocchi.service: database.retry_interval = 10 2025-10-05 08:20:15,186 [2] DEBUG gnocchi.service: database.slave_connection = **** 2025-10-05 08:20:15,186 [2] DEBUG gnocchi.service: database.sqlite_synchronous = True 2025-10-05 08:20:15,186 [2] DEBUG gnocchi.service: database.use_db_reconnect = False 2025-10-05 08:20:15,186 [2] DEBUG gnocchi.service: indexer.url = **** 2025-10-05 08:20:15,186 [2] DEBUG gnocchi.service: metricd.greedy = True 2025-10-05 08:20:15,186 [2] DEBUG gnocchi.service: metricd.metric_cleanup_delay = 300 2025-10-05 08:20:15,186 [2] DEBUG gnocchi.service: metricd.metric_processing_delay = 30 2025-10-05 08:20:15,186 [2] DEBUG gnocchi.service: metricd.metric_reporting_delay = 120 2025-10-05 08:20:15,186 [2] DEBUG gnocchi.service: metricd.processing_replicas = 3 2025-10-05 08:20:15,186 [2] DEBUG gnocchi.service: metricd.workers = 1 2025-10-05 08:20:15,186 [2] DEBUG gnocchi.service: api.auth_mode = keystone 2025-10-05 08:20:15,187 [2] WARNING oslo_config.cfg: Deprecated: Option "enable_proxy_headers_parsing" from group "oslo_middleware" is deprecated. Use option "enable_proxy_headers_parsing" from group "api". 2025-10-05 08:20:15,187 [2] DEBUG gnocchi.service: api.enable_proxy_headers_parsing = True 2025-10-05 08:20:15,187 [2] DEBUG gnocchi.service: api.host = 0.0.0.0 2025-10-05 08:20:15,187 [2] DEBUG gnocchi.service: api.max_limit = 1000 2025-10-05 08:20:15,187 [2] DEBUG gnocchi.service: api.operation_timeout = 10 2025-10-05 08:20:15,187 [2] DEBUG gnocchi.service: api.paste_config = api-paste.ini 2025-10-05 08:20:15,187 [2] DEBUG gnocchi.service: api.port = 8041 2025-10-05 08:20:15,187 [2] DEBUG gnocchi.service: api.uwsgi_mode = http 2025-10-05 08:20:15,188 [2] DEBUG gnocchi.service: storage.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:15,188 [2] DEBUG gnocchi.service: storage.ceph_keyring = None 2025-10-05 08:20:15,188 [2] DEBUG gnocchi.service: storage.ceph_pool = gnocchi 2025-10-05 08:20:15,188 [2] DEBUG gnocchi.service: storage.ceph_secret = **** 2025-10-05 08:20:15,188 [2] DEBUG gnocchi.service: storage.ceph_timeout = 30 2025-10-05 08:20:15,188 [2] DEBUG gnocchi.service: storage.ceph_username = None 2025-10-05 08:20:15,188 [2] DEBUG gnocchi.service: storage.driver = swift 2025-10-05 08:20:15,188 [2] DEBUG gnocchi.service: storage.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:15,188 [2] DEBUG gnocchi.service: storage.file_subdir_len = 2 2025-10-05 08:20:15,188 [2] DEBUG gnocchi.service: storage.redis_url = **** 2025-10-05 08:20:15,188 [2] DEBUG gnocchi.service: storage.s3_access_key_id = None 2025-10-05 08:20:15,188 [2] DEBUG gnocchi.service: storage.s3_bucket_prefix = gnocchi 2025-10-05 08:20:15,188 [2] DEBUG gnocchi.service: storage.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:15,189 [2] DEBUG gnocchi.service: storage.s3_endpoint_url = None 2025-10-05 08:20:15,189 [2] DEBUG gnocchi.service: storage.s3_max_pool_connections = 50 2025-10-05 08:20:15,189 [2] DEBUG gnocchi.service: storage.s3_region_name = None 2025-10-05 08:20:15,189 [2] DEBUG gnocchi.service: storage.s3_secret_access_key = None 2025-10-05 08:20:15,189 [2] DEBUG gnocchi.service: storage.swift_auth_insecure = False 2025-10-05 08:20:15,189 [2] DEBUG gnocchi.service: storage.swift_auth_version = 3 2025-10-05 08:20:15,189 [2] DEBUG gnocchi.service: storage.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:15,189 [2] DEBUG gnocchi.service: storage.swift_cacert = None 2025-10-05 08:20:15,189 [2] DEBUG gnocchi.service: storage.swift_container_prefix = gnocchi 2025-10-05 08:20:15,189 [2] DEBUG gnocchi.service: storage.swift_endpoint_type = internalURL 2025-10-05 08:20:15,189 [2] DEBUG gnocchi.service: storage.swift_key = **** 2025-10-05 08:20:15,189 [2] DEBUG gnocchi.service: storage.swift_preauthtoken = **** 2025-10-05 08:20:15,189 [2] DEBUG gnocchi.service: storage.swift_project_domain_name = Default 2025-10-05 08:20:15,189 [2] DEBUG gnocchi.service: storage.swift_project_name = None 2025-10-05 08:20:15,189 [2] DEBUG gnocchi.service: storage.swift_region = None 2025-10-05 08:20:15,190 [2] DEBUG gnocchi.service: storage.swift_service_type = object-store 2025-10-05 08:20:15,190 [2] DEBUG gnocchi.service: storage.swift_timeout = 300 2025-10-05 08:20:15,190 [2] DEBUG gnocchi.service: storage.swift_url = None 2025-10-05 08:20:15,190 [2] DEBUG gnocchi.service: storage.swift_user = service:gnocchi 2025-10-05 08:20:15,190 [2] DEBUG gnocchi.service: storage.swift_user_domain_name = Default 2025-10-05 08:20:15,190 [2] DEBUG gnocchi.service: incoming.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:15,190 [2] DEBUG gnocchi.service: incoming.ceph_keyring = 2025-10-05 08:20:15,190 [2] DEBUG gnocchi.service: incoming.ceph_pool = gnocchi 2025-10-05 08:20:15,190 [2] DEBUG gnocchi.service: incoming.ceph_secret = **** 2025-10-05 08:20:15,190 [2] DEBUG gnocchi.service: incoming.ceph_timeout = 30 2025-10-05 08:20:15,191 [2] DEBUG gnocchi.service: incoming.ceph_username = 2025-10-05 08:20:15,191 [2] DEBUG gnocchi.service: incoming.driver = redis 2025-10-05 08:20:15,191 [2] DEBUG gnocchi.service: incoming.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:15,191 [2] DEBUG gnocchi.service: incoming.file_subdir_len = 2 2025-10-05 08:20:15,191 [2] DEBUG gnocchi.service: incoming.redis_url = **** 2025-10-05 08:20:15,191 [2] DEBUG gnocchi.service: incoming.s3_access_key_id = 2025-10-05 08:20:15,191 [2] DEBUG gnocchi.service: incoming.s3_bucket_prefix = gnocchi 2025-10-05 08:20:15,191 [2] DEBUG gnocchi.service: incoming.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:15,192 [2] DEBUG gnocchi.service: incoming.s3_endpoint_url = 2025-10-05 08:20:15,192 [2] DEBUG gnocchi.service: incoming.s3_max_pool_connections = 50 2025-10-05 08:20:15,192 [2] DEBUG gnocchi.service: incoming.s3_region_name = 2025-10-05 08:20:15,192 [2] DEBUG gnocchi.service: incoming.s3_secret_access_key = 2025-10-05 08:20:15,192 [2] DEBUG gnocchi.service: incoming.swift_auth_insecure = False 2025-10-05 08:20:15,192 [2] DEBUG gnocchi.service: incoming.swift_auth_version = 3 2025-10-05 08:20:15,192 [2] DEBUG gnocchi.service: incoming.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:15,192 [2] DEBUG gnocchi.service: incoming.swift_cacert = 2025-10-05 08:20:15,193 [2] DEBUG gnocchi.service: incoming.swift_container_prefix = gnocchi 2025-10-05 08:20:15,193 [2] DEBUG gnocchi.service: incoming.swift_endpoint_type = internalURL 2025-10-05 08:20:15,193 [2] DEBUG gnocchi.service: incoming.swift_key = **** 2025-10-05 08:20:15,193 [2] DEBUG gnocchi.service: incoming.swift_preauthtoken = **** 2025-10-05 08:20:15,193 [2] DEBUG gnocchi.service: incoming.swift_project_domain_name = Default 2025-10-05 08:20:15,193 [2] DEBUG gnocchi.service: incoming.swift_project_name = 2025-10-05 08:20:15,193 [2] DEBUG gnocchi.service: incoming.swift_region = 2025-10-05 08:20:15,193 [2] DEBUG gnocchi.service: incoming.swift_service_type = object-store 2025-10-05 08:20:15,194 [2] DEBUG gnocchi.service: incoming.swift_timeout = 300 2025-10-05 08:20:15,194 [2] DEBUG gnocchi.service: incoming.swift_url = 2025-10-05 08:20:15,194 [2] DEBUG gnocchi.service: incoming.swift_user = service:gnocchi 2025-10-05 08:20:15,194 [2] DEBUG gnocchi.service: incoming.swift_user_domain_name = Default 2025-10-05 08:20:15,194 [2] DEBUG gnocchi.service: statsd.archive_policy_name = low 2025-10-05 08:20:15,194 [2] DEBUG gnocchi.service: statsd.creator = None 2025-10-05 08:20:15,194 [2] DEBUG gnocchi.service: statsd.flush_delay = 10.0 2025-10-05 08:20:15,194 [2] DEBUG gnocchi.service: statsd.host = 0.0.0.0 2025-10-05 08:20:15,194 [2] DEBUG gnocchi.service: statsd.port = 8125 2025-10-05 08:20:15,194 [2] DEBUG gnocchi.service: statsd.resource_id = 0a8b55df-f90f-491c-8cb9-7cdecec6fc26 2025-10-05 08:20:15,194 [2] DEBUG gnocchi.service: amqp1d.creator = None 2025-10-05 08:20:15,195 [2] DEBUG gnocchi.service: amqp1d.data_source = collectd 2025-10-05 08:20:15,195 [2] DEBUG gnocchi.service: amqp1d.flush_delay = 10.0 2025-10-05 08:20:15,195 [2] DEBUG gnocchi.service: amqp1d.resource_type = collectd_amqp1d 2025-10-05 08:20:15,195 [2] DEBUG gnocchi.service: amqp1d.url = localhost:5672/u/collectd/telemetry 2025-10-05 08:20:15,195 [2] DEBUG gnocchi.service: archive_policy.default_aggregation_methods = ['mean', 'min', 'max', 'sum', 'std', 'count'] 2025-10-05 08:20:15,195 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:15,516 [2] CRITICAL root: Traceback (most recent call last): File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.ProgrammingError: (1146, "Table 'gnocchi.resource_type' doesn't exist") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/bin/gnocchi-statsd", line 33, in sys.exit(load_entry_point('gnocchi==4.4.6.dev2+gff96e73d', 'console_scripts', 'gnocchi-statsd')()) File "/usr/lib/python3.9/site-packages/gnocchi/cli/statsd.py", line 20, in statsd statsd_service.start() File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 174, in start stats = Stats(conf) File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 41, in __init__ self.indexer.create_resource('generic', File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 154, in wrapper ectxt.value = e.inner_exc File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 227, in __exit__ self.force_reraise() File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 200, in force_reraise raise self.value File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 142, in wrapper return f(*args, **kwargs) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 811, in create_resource resource_cls = self._resource_type_to_mappers( File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 587, in _resource_type_to_mappers resource_type = self._get_resource_type(session, name) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 482, in _get_resource_type resource_type = session.query(ResourceType).get(name) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1018, in get return self._get_impl(ident, loading.load_on_pk_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1135, in _get_impl return db_load_fn(self, primary_key_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/loading.py", line 286, in load_on_pk_identity return q.one() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3490, in one ret = self.one_or_none() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none ret = list(self) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__ return self._execute_and_instances(context) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute return meth(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement ret = self._execute_context( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context self._handle_dbapi_exception( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1508, in _handle_dbapi_exception util.raise_(newraise, with_traceback=exc_info[2], from_=e) File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_ raise exception File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'gnocchi.resource_type' doesn't exist") [SQL: SELECT resource_type.name AS resource_type_name, resource_type.tablename AS resource_type_tablename, resource_type.attributes AS resource_type_attributes, resource_type.state AS resource_type_state, resource_type.updated_at AS resource_type_updated_at FROM resource_type WHERE resource_type.name = %(param_1)s] [parameters: {'param_1': 'generic'}] (Background on this error at: http://sqlalche.me/e/13/f405) 2025-10-05 08:20:27,504 [2] INFO gnocchi.service: Gnocchi version 4.4.6.dev2+gff96e73d 2025-10-05 08:20:27,505 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:27,505 [2] DEBUG gnocchi.service: Configuration options gathered from: 2025-10-05 08:20:27,505 [2] DEBUG gnocchi.service: command line args: [] 2025-10-05 08:20:27,505 [2] DEBUG gnocchi.service: config files: ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:27,505 [2] DEBUG gnocchi.service: ================================================================================ 2025-10-05 08:20:27,505 [2] DEBUG gnocchi.service: config_dir = [] 2025-10-05 08:20:27,505 [2] DEBUG gnocchi.service: config_file = ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:27,505 [2] DEBUG gnocchi.service: config_source = [] 2025-10-05 08:20:27,505 [2] DEBUG gnocchi.service: coordination_url = **** 2025-10-05 08:20:27,505 [2] DEBUG gnocchi.service: debug = True 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: log_dir = /var/log/gnocchi 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: log_file = None 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: parallel_operations = 8 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: syslog_log_facility = user 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: use_journal = False 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: use_syslog = False 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: verbose = True 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: database.backend = sqlalchemy 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: database.connection = **** 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: database.connection_debug = 0 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: database.connection_parameters = 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: database.connection_recycle_time = 3600 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: database.connection_trace = False 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: database.db_inc_retry_interval = True 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: database.db_max_retries = 20 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: database.db_max_retry_interval = 10 2025-10-05 08:20:27,506 [2] DEBUG gnocchi.service: database.db_retry_interval = 1 2025-10-05 08:20:27,507 [2] DEBUG gnocchi.service: database.max_overflow = 50 2025-10-05 08:20:27,507 [2] DEBUG gnocchi.service: database.max_pool_size = 5 2025-10-05 08:20:27,507 [2] DEBUG gnocchi.service: database.max_retries = 10 2025-10-05 08:20:27,507 [2] DEBUG gnocchi.service: database.mysql_enable_ndb = False 2025-10-05 08:20:27,507 [2] DEBUG gnocchi.service: database.mysql_sql_mode = TRADITIONAL 2025-10-05 08:20:27,507 [2] DEBUG gnocchi.service: database.pool_timeout = None 2025-10-05 08:20:27,507 [2] DEBUG gnocchi.service: database.retry_interval = 10 2025-10-05 08:20:27,507 [2] DEBUG gnocchi.service: database.slave_connection = **** 2025-10-05 08:20:27,507 [2] DEBUG gnocchi.service: database.sqlite_synchronous = True 2025-10-05 08:20:27,507 [2] DEBUG gnocchi.service: database.use_db_reconnect = False 2025-10-05 08:20:27,507 [2] DEBUG gnocchi.service: indexer.url = **** 2025-10-05 08:20:27,508 [2] DEBUG gnocchi.service: metricd.greedy = True 2025-10-05 08:20:27,508 [2] DEBUG gnocchi.service: metricd.metric_cleanup_delay = 300 2025-10-05 08:20:27,508 [2] DEBUG gnocchi.service: metricd.metric_processing_delay = 30 2025-10-05 08:20:27,508 [2] DEBUG gnocchi.service: metricd.metric_reporting_delay = 120 2025-10-05 08:20:27,508 [2] DEBUG gnocchi.service: metricd.processing_replicas = 3 2025-10-05 08:20:27,508 [2] DEBUG gnocchi.service: metricd.workers = 1 2025-10-05 08:20:27,508 [2] DEBUG gnocchi.service: api.auth_mode = keystone 2025-10-05 08:20:27,508 [2] WARNING oslo_config.cfg: Deprecated: Option "enable_proxy_headers_parsing" from group "oslo_middleware" is deprecated. Use option "enable_proxy_headers_parsing" from group "api". 2025-10-05 08:20:27,509 [2] DEBUG gnocchi.service: api.enable_proxy_headers_parsing = True 2025-10-05 08:20:27,509 [2] DEBUG gnocchi.service: api.host = 0.0.0.0 2025-10-05 08:20:27,509 [2] DEBUG gnocchi.service: api.max_limit = 1000 2025-10-05 08:20:27,509 [2] DEBUG gnocchi.service: api.operation_timeout = 10 2025-10-05 08:20:27,509 [2] DEBUG gnocchi.service: api.paste_config = api-paste.ini 2025-10-05 08:20:27,509 [2] DEBUG gnocchi.service: api.port = 8041 2025-10-05 08:20:27,509 [2] DEBUG gnocchi.service: api.uwsgi_mode = http 2025-10-05 08:20:27,509 [2] DEBUG gnocchi.service: storage.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:27,509 [2] DEBUG gnocchi.service: storage.ceph_keyring = None 2025-10-05 08:20:27,509 [2] DEBUG gnocchi.service: storage.ceph_pool = gnocchi 2025-10-05 08:20:27,509 [2] DEBUG gnocchi.service: storage.ceph_secret = **** 2025-10-05 08:20:27,509 [2] DEBUG gnocchi.service: storage.ceph_timeout = 30 2025-10-05 08:20:27,509 [2] DEBUG gnocchi.service: storage.ceph_username = None 2025-10-05 08:20:27,509 [2] DEBUG gnocchi.service: storage.driver = swift 2025-10-05 08:20:27,510 [2] DEBUG gnocchi.service: storage.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:27,510 [2] DEBUG gnocchi.service: storage.file_subdir_len = 2 2025-10-05 08:20:27,510 [2] DEBUG gnocchi.service: storage.redis_url = **** 2025-10-05 08:20:27,510 [2] DEBUG gnocchi.service: storage.s3_access_key_id = None 2025-10-05 08:20:27,510 [2] DEBUG gnocchi.service: storage.s3_bucket_prefix = gnocchi 2025-10-05 08:20:27,510 [2] DEBUG gnocchi.service: storage.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:27,510 [2] DEBUG gnocchi.service: storage.s3_endpoint_url = None 2025-10-05 08:20:27,510 [2] DEBUG gnocchi.service: storage.s3_max_pool_connections = 50 2025-10-05 08:20:27,510 [2] DEBUG gnocchi.service: storage.s3_region_name = None 2025-10-05 08:20:27,510 [2] DEBUG gnocchi.service: storage.s3_secret_access_key = None 2025-10-05 08:20:27,510 [2] DEBUG gnocchi.service: storage.swift_auth_insecure = False 2025-10-05 08:20:27,510 [2] DEBUG gnocchi.service: storage.swift_auth_version = 3 2025-10-05 08:20:27,510 [2] DEBUG gnocchi.service: storage.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:27,510 [2] DEBUG gnocchi.service: storage.swift_cacert = None 2025-10-05 08:20:27,510 [2] DEBUG gnocchi.service: storage.swift_container_prefix = gnocchi 2025-10-05 08:20:27,511 [2] DEBUG gnocchi.service: storage.swift_endpoint_type = internalURL 2025-10-05 08:20:27,511 [2] DEBUG gnocchi.service: storage.swift_key = **** 2025-10-05 08:20:27,511 [2] DEBUG gnocchi.service: storage.swift_preauthtoken = **** 2025-10-05 08:20:27,511 [2] DEBUG gnocchi.service: storage.swift_project_domain_name = Default 2025-10-05 08:20:27,511 [2] DEBUG gnocchi.service: storage.swift_project_name = None 2025-10-05 08:20:27,511 [2] DEBUG gnocchi.service: storage.swift_region = None 2025-10-05 08:20:27,511 [2] DEBUG gnocchi.service: storage.swift_service_type = object-store 2025-10-05 08:20:27,511 [2] DEBUG gnocchi.service: storage.swift_timeout = 300 2025-10-05 08:20:27,511 [2] DEBUG gnocchi.service: storage.swift_url = None 2025-10-05 08:20:27,511 [2] DEBUG gnocchi.service: storage.swift_user = service:gnocchi 2025-10-05 08:20:27,511 [2] DEBUG gnocchi.service: storage.swift_user_domain_name = Default 2025-10-05 08:20:27,511 [2] DEBUG gnocchi.service: incoming.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:27,511 [2] DEBUG gnocchi.service: incoming.ceph_keyring = 2025-10-05 08:20:27,512 [2] DEBUG gnocchi.service: incoming.ceph_pool = gnocchi 2025-10-05 08:20:27,512 [2] DEBUG gnocchi.service: incoming.ceph_secret = **** 2025-10-05 08:20:27,512 [2] DEBUG gnocchi.service: incoming.ceph_timeout = 30 2025-10-05 08:20:27,512 [2] DEBUG gnocchi.service: incoming.ceph_username = 2025-10-05 08:20:27,512 [2] DEBUG gnocchi.service: incoming.driver = redis 2025-10-05 08:20:27,512 [2] DEBUG gnocchi.service: incoming.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:27,512 [2] DEBUG gnocchi.service: incoming.file_subdir_len = 2 2025-10-05 08:20:27,512 [2] DEBUG gnocchi.service: incoming.redis_url = **** 2025-10-05 08:20:27,512 [2] DEBUG gnocchi.service: incoming.s3_access_key_id = 2025-10-05 08:20:27,513 [2] DEBUG gnocchi.service: incoming.s3_bucket_prefix = gnocchi 2025-10-05 08:20:27,513 [2] DEBUG gnocchi.service: incoming.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:27,513 [2] DEBUG gnocchi.service: incoming.s3_endpoint_url = 2025-10-05 08:20:27,513 [2] DEBUG gnocchi.service: incoming.s3_max_pool_connections = 50 2025-10-05 08:20:27,513 [2] DEBUG gnocchi.service: incoming.s3_region_name = 2025-10-05 08:20:27,513 [2] DEBUG gnocchi.service: incoming.s3_secret_access_key = 2025-10-05 08:20:27,513 [2] DEBUG gnocchi.service: incoming.swift_auth_insecure = False 2025-10-05 08:20:27,513 [2] DEBUG gnocchi.service: incoming.swift_auth_version = 3 2025-10-05 08:20:27,513 [2] DEBUG gnocchi.service: incoming.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:27,514 [2] DEBUG gnocchi.service: incoming.swift_cacert = 2025-10-05 08:20:27,514 [2] DEBUG gnocchi.service: incoming.swift_container_prefix = gnocchi 2025-10-05 08:20:27,514 [2] DEBUG gnocchi.service: incoming.swift_endpoint_type = internalURL 2025-10-05 08:20:27,514 [2] DEBUG gnocchi.service: incoming.swift_key = **** 2025-10-05 08:20:27,514 [2] DEBUG gnocchi.service: incoming.swift_preauthtoken = **** 2025-10-05 08:20:27,514 [2] DEBUG gnocchi.service: incoming.swift_project_domain_name = Default 2025-10-05 08:20:27,514 [2] DEBUG gnocchi.service: incoming.swift_project_name = 2025-10-05 08:20:27,514 [2] DEBUG gnocchi.service: incoming.swift_region = 2025-10-05 08:20:27,514 [2] DEBUG gnocchi.service: incoming.swift_service_type = object-store 2025-10-05 08:20:27,515 [2] DEBUG gnocchi.service: incoming.swift_timeout = 300 2025-10-05 08:20:27,515 [2] DEBUG gnocchi.service: incoming.swift_url = 2025-10-05 08:20:27,515 [2] DEBUG gnocchi.service: incoming.swift_user = service:gnocchi 2025-10-05 08:20:27,515 [2] DEBUG gnocchi.service: incoming.swift_user_domain_name = Default 2025-10-05 08:20:27,515 [2] DEBUG gnocchi.service: statsd.archive_policy_name = low 2025-10-05 08:20:27,515 [2] DEBUG gnocchi.service: statsd.creator = None 2025-10-05 08:20:27,515 [2] DEBUG gnocchi.service: statsd.flush_delay = 10.0 2025-10-05 08:20:27,515 [2] DEBUG gnocchi.service: statsd.host = 0.0.0.0 2025-10-05 08:20:27,515 [2] DEBUG gnocchi.service: statsd.port = 8125 2025-10-05 08:20:27,515 [2] DEBUG gnocchi.service: statsd.resource_id = 0a8b55df-f90f-491c-8cb9-7cdecec6fc26 2025-10-05 08:20:27,515 [2] DEBUG gnocchi.service: amqp1d.creator = None 2025-10-05 08:20:27,516 [2] DEBUG gnocchi.service: amqp1d.data_source = collectd 2025-10-05 08:20:27,516 [2] DEBUG gnocchi.service: amqp1d.flush_delay = 10.0 2025-10-05 08:20:27,516 [2] DEBUG gnocchi.service: amqp1d.resource_type = collectd_amqp1d 2025-10-05 08:20:27,516 [2] DEBUG gnocchi.service: amqp1d.url = localhost:5672/u/collectd/telemetry 2025-10-05 08:20:27,516 [2] DEBUG gnocchi.service: archive_policy.default_aggregation_methods = ['mean', 'min', 'max', 'sum', 'std', 'count'] 2025-10-05 08:20:27,516 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:27,765 [2] CRITICAL root: Traceback (most recent call last): File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.ProgrammingError: (1146, "Table 'gnocchi.resource_type' doesn't exist") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/bin/gnocchi-statsd", line 33, in sys.exit(load_entry_point('gnocchi==4.4.6.dev2+gff96e73d', 'console_scripts', 'gnocchi-statsd')()) File "/usr/lib/python3.9/site-packages/gnocchi/cli/statsd.py", line 20, in statsd statsd_service.start() File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 174, in start stats = Stats(conf) File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 41, in __init__ self.indexer.create_resource('generic', File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 154, in wrapper ectxt.value = e.inner_exc File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 227, in __exit__ self.force_reraise() File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 200, in force_reraise raise self.value File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 142, in wrapper return f(*args, **kwargs) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 811, in create_resource resource_cls = self._resource_type_to_mappers( File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 587, in _resource_type_to_mappers resource_type = self._get_resource_type(session, name) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 482, in _get_resource_type resource_type = session.query(ResourceType).get(name) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1018, in get return self._get_impl(ident, loading.load_on_pk_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1135, in _get_impl return db_load_fn(self, primary_key_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/loading.py", line 286, in load_on_pk_identity return q.one() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3490, in one ret = self.one_or_none() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none ret = list(self) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__ return self._execute_and_instances(context) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute return meth(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement ret = self._execute_context( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context self._handle_dbapi_exception( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1508, in _handle_dbapi_exception util.raise_(newraise, with_traceback=exc_info[2], from_=e) File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_ raise exception File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'gnocchi.resource_type' doesn't exist") [SQL: SELECT resource_type.name AS resource_type_name, resource_type.tablename AS resource_type_tablename, resource_type.attributes AS resource_type_attributes, resource_type.state AS resource_type_state, resource_type.updated_at AS resource_type_updated_at FROM resource_type WHERE resource_type.name = %(param_1)s] [parameters: {'param_1': 'generic'}] (Background on this error at: http://sqlalche.me/e/13/f405) 2025-10-05 08:20:29,376 [2] INFO gnocchi.service: Gnocchi version 4.4.6.dev2+gff96e73d 2025-10-05 08:20:29,376 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:29,377 [2] DEBUG gnocchi.service: Configuration options gathered from: 2025-10-05 08:20:29,377 [2] DEBUG gnocchi.service: command line args: [] 2025-10-05 08:20:29,377 [2] DEBUG gnocchi.service: config files: ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:29,377 [2] DEBUG gnocchi.service: ================================================================================ 2025-10-05 08:20:29,377 [2] DEBUG gnocchi.service: config_dir = [] 2025-10-05 08:20:29,377 [2] DEBUG gnocchi.service: config_file = ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:29,377 [2] DEBUG gnocchi.service: config_source = [] 2025-10-05 08:20:29,377 [2] DEBUG gnocchi.service: coordination_url = **** 2025-10-05 08:20:29,377 [2] DEBUG gnocchi.service: debug = True 2025-10-05 08:20:29,377 [2] DEBUG gnocchi.service: log_dir = /var/log/gnocchi 2025-10-05 08:20:29,377 [2] DEBUG gnocchi.service: log_file = None 2025-10-05 08:20:29,377 [2] DEBUG gnocchi.service: parallel_operations = 8 2025-10-05 08:20:29,377 [2] DEBUG gnocchi.service: syslog_log_facility = user 2025-10-05 08:20:29,377 [2] DEBUG gnocchi.service: use_journal = False 2025-10-05 08:20:29,377 [2] DEBUG gnocchi.service: use_syslog = False 2025-10-05 08:20:29,377 [2] DEBUG gnocchi.service: verbose = True 2025-10-05 08:20:29,378 [2] DEBUG gnocchi.service: database.backend = sqlalchemy 2025-10-05 08:20:29,378 [2] DEBUG gnocchi.service: database.connection = **** 2025-10-05 08:20:29,378 [2] DEBUG gnocchi.service: database.connection_debug = 0 2025-10-05 08:20:29,378 [2] DEBUG gnocchi.service: database.connection_parameters = 2025-10-05 08:20:29,378 [2] DEBUG gnocchi.service: database.connection_recycle_time = 3600 2025-10-05 08:20:29,378 [2] DEBUG gnocchi.service: database.connection_trace = False 2025-10-05 08:20:29,378 [2] DEBUG gnocchi.service: database.db_inc_retry_interval = True 2025-10-05 08:20:29,378 [2] DEBUG gnocchi.service: database.db_max_retries = 20 2025-10-05 08:20:29,378 [2] DEBUG gnocchi.service: database.db_max_retry_interval = 10 2025-10-05 08:20:29,378 [2] DEBUG gnocchi.service: database.db_retry_interval = 1 2025-10-05 08:20:29,378 [2] DEBUG gnocchi.service: database.max_overflow = 50 2025-10-05 08:20:29,378 [2] DEBUG gnocchi.service: database.max_pool_size = 5 2025-10-05 08:20:29,378 [2] DEBUG gnocchi.service: database.max_retries = 10 2025-10-05 08:20:29,378 [2] DEBUG gnocchi.service: database.mysql_enable_ndb = False 2025-10-05 08:20:29,379 [2] DEBUG gnocchi.service: database.mysql_sql_mode = TRADITIONAL 2025-10-05 08:20:29,382 [2] DEBUG gnocchi.service: database.pool_timeout = None 2025-10-05 08:20:29,382 [2] DEBUG gnocchi.service: database.retry_interval = 10 2025-10-05 08:20:29,382 [2] DEBUG gnocchi.service: database.slave_connection = **** 2025-10-05 08:20:29,382 [2] DEBUG gnocchi.service: database.sqlite_synchronous = True 2025-10-05 08:20:29,382 [2] DEBUG gnocchi.service: database.use_db_reconnect = False 2025-10-05 08:20:29,382 [2] DEBUG gnocchi.service: indexer.url = **** 2025-10-05 08:20:29,382 [2] DEBUG gnocchi.service: metricd.greedy = True 2025-10-05 08:20:29,382 [2] DEBUG gnocchi.service: metricd.metric_cleanup_delay = 300 2025-10-05 08:20:29,382 [2] DEBUG gnocchi.service: metricd.metric_processing_delay = 30 2025-10-05 08:20:29,382 [2] DEBUG gnocchi.service: metricd.metric_reporting_delay = 120 2025-10-05 08:20:29,382 [2] DEBUG gnocchi.service: metricd.processing_replicas = 3 2025-10-05 08:20:29,382 [2] DEBUG gnocchi.service: metricd.workers = 1 2025-10-05 08:20:29,382 [2] DEBUG gnocchi.service: api.auth_mode = keystone 2025-10-05 08:20:29,383 [2] WARNING oslo_config.cfg: Deprecated: Option "enable_proxy_headers_parsing" from group "oslo_middleware" is deprecated. Use option "enable_proxy_headers_parsing" from group "api". 2025-10-05 08:20:29,385 [2] DEBUG gnocchi.service: api.enable_proxy_headers_parsing = True 2025-10-05 08:20:29,386 [2] DEBUG gnocchi.service: api.host = 0.0.0.0 2025-10-05 08:20:29,386 [2] DEBUG gnocchi.service: api.max_limit = 1000 2025-10-05 08:20:29,386 [2] DEBUG gnocchi.service: api.operation_timeout = 10 2025-10-05 08:20:29,386 [2] DEBUG gnocchi.service: api.paste_config = api-paste.ini 2025-10-05 08:20:29,387 [2] DEBUG gnocchi.service: api.port = 8041 2025-10-05 08:20:29,387 [2] DEBUG gnocchi.service: api.uwsgi_mode = http 2025-10-05 08:20:29,387 [2] DEBUG gnocchi.service: storage.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:29,387 [2] DEBUG gnocchi.service: storage.ceph_keyring = None 2025-10-05 08:20:29,387 [2] DEBUG gnocchi.service: storage.ceph_pool = gnocchi 2025-10-05 08:20:29,387 [2] DEBUG gnocchi.service: storage.ceph_secret = **** 2025-10-05 08:20:29,388 [2] DEBUG gnocchi.service: storage.ceph_timeout = 30 2025-10-05 08:20:29,388 [2] DEBUG gnocchi.service: storage.ceph_username = None 2025-10-05 08:20:29,388 [2] DEBUG gnocchi.service: storage.driver = swift 2025-10-05 08:20:29,388 [2] DEBUG gnocchi.service: storage.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:29,388 [2] DEBUG gnocchi.service: storage.file_subdir_len = 2 2025-10-05 08:20:29,388 [2] DEBUG gnocchi.service: storage.redis_url = **** 2025-10-05 08:20:29,389 [2] DEBUG gnocchi.service: storage.s3_access_key_id = None 2025-10-05 08:20:29,389 [2] DEBUG gnocchi.service: storage.s3_bucket_prefix = gnocchi 2025-10-05 08:20:29,389 [2] DEBUG gnocchi.service: storage.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:29,389 [2] DEBUG gnocchi.service: storage.s3_endpoint_url = None 2025-10-05 08:20:29,389 [2] DEBUG gnocchi.service: storage.s3_max_pool_connections = 50 2025-10-05 08:20:29,389 [2] DEBUG gnocchi.service: storage.s3_region_name = None 2025-10-05 08:20:29,390 [2] DEBUG gnocchi.service: storage.s3_secret_access_key = None 2025-10-05 08:20:29,390 [2] DEBUG gnocchi.service: storage.swift_auth_insecure = False 2025-10-05 08:20:29,390 [2] DEBUG gnocchi.service: storage.swift_auth_version = 3 2025-10-05 08:20:29,390 [2] DEBUG gnocchi.service: storage.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:29,390 [2] DEBUG gnocchi.service: storage.swift_cacert = None 2025-10-05 08:20:29,390 [2] DEBUG gnocchi.service: storage.swift_container_prefix = gnocchi 2025-10-05 08:20:29,390 [2] DEBUG gnocchi.service: storage.swift_endpoint_type = internalURL 2025-10-05 08:20:29,391 [2] DEBUG gnocchi.service: storage.swift_key = **** 2025-10-05 08:20:29,391 [2] DEBUG gnocchi.service: storage.swift_preauthtoken = **** 2025-10-05 08:20:29,391 [2] DEBUG gnocchi.service: storage.swift_project_domain_name = Default 2025-10-05 08:20:29,391 [2] DEBUG gnocchi.service: storage.swift_project_name = None 2025-10-05 08:20:29,391 [2] DEBUG gnocchi.service: storage.swift_region = None 2025-10-05 08:20:29,391 [2] DEBUG gnocchi.service: storage.swift_service_type = object-store 2025-10-05 08:20:29,392 [2] DEBUG gnocchi.service: storage.swift_timeout = 300 2025-10-05 08:20:29,392 [2] DEBUG gnocchi.service: storage.swift_url = None 2025-10-05 08:20:29,392 [2] DEBUG gnocchi.service: storage.swift_user = service:gnocchi 2025-10-05 08:20:29,392 [2] DEBUG gnocchi.service: storage.swift_user_domain_name = Default 2025-10-05 08:20:29,392 [2] DEBUG gnocchi.service: incoming.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:29,393 [2] DEBUG gnocchi.service: incoming.ceph_keyring = 2025-10-05 08:20:29,393 [2] DEBUG gnocchi.service: incoming.ceph_pool = gnocchi 2025-10-05 08:20:29,393 [2] DEBUG gnocchi.service: incoming.ceph_secret = **** 2025-10-05 08:20:29,394 [2] DEBUG gnocchi.service: incoming.ceph_timeout = 30 2025-10-05 08:20:29,394 [2] DEBUG gnocchi.service: incoming.ceph_username = 2025-10-05 08:20:29,394 [2] DEBUG gnocchi.service: incoming.driver = redis 2025-10-05 08:20:29,394 [2] DEBUG gnocchi.service: incoming.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:29,395 [2] DEBUG gnocchi.service: incoming.file_subdir_len = 2 2025-10-05 08:20:29,395 [2] DEBUG gnocchi.service: incoming.redis_url = **** 2025-10-05 08:20:29,395 [2] DEBUG gnocchi.service: incoming.s3_access_key_id = 2025-10-05 08:20:29,396 [2] DEBUG gnocchi.service: incoming.s3_bucket_prefix = gnocchi 2025-10-05 08:20:29,396 [2] DEBUG gnocchi.service: incoming.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:29,396 [2] DEBUG gnocchi.service: incoming.s3_endpoint_url = 2025-10-05 08:20:29,396 [2] DEBUG gnocchi.service: incoming.s3_max_pool_connections = 50 2025-10-05 08:20:29,397 [2] DEBUG gnocchi.service: incoming.s3_region_name = 2025-10-05 08:20:29,397 [2] DEBUG gnocchi.service: incoming.s3_secret_access_key = 2025-10-05 08:20:29,397 [2] DEBUG gnocchi.service: incoming.swift_auth_insecure = False 2025-10-05 08:20:29,397 [2] DEBUG gnocchi.service: incoming.swift_auth_version = 3 2025-10-05 08:20:29,398 [2] DEBUG gnocchi.service: incoming.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:29,398 [2] DEBUG gnocchi.service: incoming.swift_cacert = 2025-10-05 08:20:29,398 [2] DEBUG gnocchi.service: incoming.swift_container_prefix = gnocchi 2025-10-05 08:20:29,398 [2] DEBUG gnocchi.service: incoming.swift_endpoint_type = internalURL 2025-10-05 08:20:29,399 [2] DEBUG gnocchi.service: incoming.swift_key = **** 2025-10-05 08:20:29,399 [2] DEBUG gnocchi.service: incoming.swift_preauthtoken = **** 2025-10-05 08:20:29,399 [2] DEBUG gnocchi.service: incoming.swift_project_domain_name = Default 2025-10-05 08:20:29,400 [2] DEBUG gnocchi.service: incoming.swift_project_name = 2025-10-05 08:20:29,400 [2] DEBUG gnocchi.service: incoming.swift_region = 2025-10-05 08:20:29,400 [2] DEBUG gnocchi.service: incoming.swift_service_type = object-store 2025-10-05 08:20:29,400 [2] DEBUG gnocchi.service: incoming.swift_timeout = 300 2025-10-05 08:20:29,401 [2] DEBUG gnocchi.service: incoming.swift_url = 2025-10-05 08:20:29,401 [2] DEBUG gnocchi.service: incoming.swift_user = service:gnocchi 2025-10-05 08:20:29,401 [2] DEBUG gnocchi.service: incoming.swift_user_domain_name = Default 2025-10-05 08:20:29,401 [2] DEBUG gnocchi.service: statsd.archive_policy_name = low 2025-10-05 08:20:29,402 [2] DEBUG gnocchi.service: statsd.creator = None 2025-10-05 08:20:29,402 [2] DEBUG gnocchi.service: statsd.flush_delay = 10.0 2025-10-05 08:20:29,402 [2] DEBUG gnocchi.service: statsd.host = 0.0.0.0 2025-10-05 08:20:29,402 [2] DEBUG gnocchi.service: statsd.port = 8125 2025-10-05 08:20:29,402 [2] DEBUG gnocchi.service: statsd.resource_id = 0a8b55df-f90f-491c-8cb9-7cdecec6fc26 2025-10-05 08:20:29,403 [2] DEBUG gnocchi.service: amqp1d.creator = None 2025-10-05 08:20:29,403 [2] DEBUG gnocchi.service: amqp1d.data_source = collectd 2025-10-05 08:20:29,403 [2] DEBUG gnocchi.service: amqp1d.flush_delay = 10.0 2025-10-05 08:20:29,403 [2] DEBUG gnocchi.service: amqp1d.resource_type = collectd_amqp1d 2025-10-05 08:20:29,403 [2] DEBUG gnocchi.service: amqp1d.url = localhost:5672/u/collectd/telemetry 2025-10-05 08:20:29,403 [2] DEBUG gnocchi.service: archive_policy.default_aggregation_methods = ['mean', 'min', 'max', 'sum', 'std', 'count'] 2025-10-05 08:20:29,403 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:29,763 [2] CRITICAL root: Traceback (most recent call last): File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.ProgrammingError: (1146, "Table 'gnocchi.resource_type' doesn't exist") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/bin/gnocchi-statsd", line 33, in sys.exit(load_entry_point('gnocchi==4.4.6.dev2+gff96e73d', 'console_scripts', 'gnocchi-statsd')()) File "/usr/lib/python3.9/site-packages/gnocchi/cli/statsd.py", line 20, in statsd statsd_service.start() File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 174, in start stats = Stats(conf) File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 41, in __init__ self.indexer.create_resource('generic', File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 154, in wrapper ectxt.value = e.inner_exc File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 227, in __exit__ self.force_reraise() File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 200, in force_reraise raise self.value File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 142, in wrapper return f(*args, **kwargs) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 811, in create_resource resource_cls = self._resource_type_to_mappers( File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 587, in _resource_type_to_mappers resource_type = self._get_resource_type(session, name) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 482, in _get_resource_type resource_type = session.query(ResourceType).get(name) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1018, in get return self._get_impl(ident, loading.load_on_pk_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1135, in _get_impl return db_load_fn(self, primary_key_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/loading.py", line 286, in load_on_pk_identity return q.one() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3490, in one ret = self.one_or_none() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none ret = list(self) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__ return self._execute_and_instances(context) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute return meth(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement ret = self._execute_context( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context self._handle_dbapi_exception( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1508, in _handle_dbapi_exception util.raise_(newraise, with_traceback=exc_info[2], from_=e) File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_ raise exception File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'gnocchi.resource_type' doesn't exist") [SQL: SELECT resource_type.name AS resource_type_name, resource_type.tablename AS resource_type_tablename, resource_type.attributes AS resource_type_attributes, resource_type.state AS resource_type_state, resource_type.updated_at AS resource_type_updated_at FROM resource_type WHERE resource_type.name = %(param_1)s] [parameters: {'param_1': 'generic'}] (Background on this error at: http://sqlalche.me/e/13/f405) 2025-10-05 08:20:31,554 [2] INFO gnocchi.service: Gnocchi version 4.4.6.dev2+gff96e73d 2025-10-05 08:20:31,555 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:31,555 [2] DEBUG gnocchi.service: Configuration options gathered from: 2025-10-05 08:20:31,555 [2] DEBUG gnocchi.service: command line args: [] 2025-10-05 08:20:31,555 [2] DEBUG gnocchi.service: config files: ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:31,555 [2] DEBUG gnocchi.service: ================================================================================ 2025-10-05 08:20:31,555 [2] DEBUG gnocchi.service: config_dir = [] 2025-10-05 08:20:31,555 [2] DEBUG gnocchi.service: config_file = ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:31,555 [2] DEBUG gnocchi.service: config_source = [] 2025-10-05 08:20:31,555 [2] DEBUG gnocchi.service: coordination_url = **** 2025-10-05 08:20:31,555 [2] DEBUG gnocchi.service: debug = True 2025-10-05 08:20:31,555 [2] DEBUG gnocchi.service: log_dir = /var/log/gnocchi 2025-10-05 08:20:31,555 [2] DEBUG gnocchi.service: log_file = None 2025-10-05 08:20:31,555 [2] DEBUG gnocchi.service: parallel_operations = 8 2025-10-05 08:20:31,555 [2] DEBUG gnocchi.service: syslog_log_facility = user 2025-10-05 08:20:31,555 [2] DEBUG gnocchi.service: use_journal = False 2025-10-05 08:20:31,556 [2] DEBUG gnocchi.service: use_syslog = False 2025-10-05 08:20:31,556 [2] DEBUG gnocchi.service: verbose = True 2025-10-05 08:20:31,556 [2] DEBUG gnocchi.service: database.backend = sqlalchemy 2025-10-05 08:20:31,556 [2] DEBUG gnocchi.service: database.connection = **** 2025-10-05 08:20:31,556 [2] DEBUG gnocchi.service: database.connection_debug = 0 2025-10-05 08:20:31,556 [2] DEBUG gnocchi.service: database.connection_parameters = 2025-10-05 08:20:31,556 [2] DEBUG gnocchi.service: database.connection_recycle_time = 3600 2025-10-05 08:20:31,556 [2] DEBUG gnocchi.service: database.connection_trace = False 2025-10-05 08:20:31,556 [2] DEBUG gnocchi.service: database.db_inc_retry_interval = True 2025-10-05 08:20:31,556 [2] DEBUG gnocchi.service: database.db_max_retries = 20 2025-10-05 08:20:31,556 [2] DEBUG gnocchi.service: database.db_max_retry_interval = 10 2025-10-05 08:20:31,556 [2] DEBUG gnocchi.service: database.db_retry_interval = 1 2025-10-05 08:20:31,556 [2] DEBUG gnocchi.service: database.max_overflow = 50 2025-10-05 08:20:31,556 [2] DEBUG gnocchi.service: database.max_pool_size = 5 2025-10-05 08:20:31,556 [2] DEBUG gnocchi.service: database.max_retries = 10 2025-10-05 08:20:31,557 [2] DEBUG gnocchi.service: database.mysql_enable_ndb = False 2025-10-05 08:20:31,557 [2] DEBUG gnocchi.service: database.mysql_sql_mode = TRADITIONAL 2025-10-05 08:20:31,557 [2] DEBUG gnocchi.service: database.pool_timeout = None 2025-10-05 08:20:31,557 [2] DEBUG gnocchi.service: database.retry_interval = 10 2025-10-05 08:20:31,557 [2] DEBUG gnocchi.service: database.slave_connection = **** 2025-10-05 08:20:31,557 [2] DEBUG gnocchi.service: database.sqlite_synchronous = True 2025-10-05 08:20:31,557 [2] DEBUG gnocchi.service: database.use_db_reconnect = False 2025-10-05 08:20:31,557 [2] DEBUG gnocchi.service: indexer.url = **** 2025-10-05 08:20:31,557 [2] DEBUG gnocchi.service: metricd.greedy = True 2025-10-05 08:20:31,557 [2] DEBUG gnocchi.service: metricd.metric_cleanup_delay = 300 2025-10-05 08:20:31,557 [2] DEBUG gnocchi.service: metricd.metric_processing_delay = 30 2025-10-05 08:20:31,557 [2] DEBUG gnocchi.service: metricd.metric_reporting_delay = 120 2025-10-05 08:20:31,557 [2] DEBUG gnocchi.service: metricd.processing_replicas = 3 2025-10-05 08:20:31,557 [2] DEBUG gnocchi.service: metricd.workers = 1 2025-10-05 08:20:31,557 [2] DEBUG gnocchi.service: api.auth_mode = keystone 2025-10-05 08:20:31,558 [2] WARNING oslo_config.cfg: Deprecated: Option "enable_proxy_headers_parsing" from group "oslo_middleware" is deprecated. Use option "enable_proxy_headers_parsing" from group "api". 2025-10-05 08:20:31,558 [2] DEBUG gnocchi.service: api.enable_proxy_headers_parsing = True 2025-10-05 08:20:31,558 [2] DEBUG gnocchi.service: api.host = 0.0.0.0 2025-10-05 08:20:31,558 [2] DEBUG gnocchi.service: api.max_limit = 1000 2025-10-05 08:20:31,558 [2] DEBUG gnocchi.service: api.operation_timeout = 10 2025-10-05 08:20:31,559 [2] DEBUG gnocchi.service: api.paste_config = api-paste.ini 2025-10-05 08:20:31,559 [2] DEBUG gnocchi.service: api.port = 8041 2025-10-05 08:20:31,559 [2] DEBUG gnocchi.service: api.uwsgi_mode = http 2025-10-05 08:20:31,559 [2] DEBUG gnocchi.service: storage.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:31,559 [2] DEBUG gnocchi.service: storage.ceph_keyring = None 2025-10-05 08:20:31,559 [2] DEBUG gnocchi.service: storage.ceph_pool = gnocchi 2025-10-05 08:20:31,559 [2] DEBUG gnocchi.service: storage.ceph_secret = **** 2025-10-05 08:20:31,559 [2] DEBUG gnocchi.service: storage.ceph_timeout = 30 2025-10-05 08:20:31,559 [2] DEBUG gnocchi.service: storage.ceph_username = None 2025-10-05 08:20:31,559 [2] DEBUG gnocchi.service: storage.driver = swift 2025-10-05 08:20:31,559 [2] DEBUG gnocchi.service: storage.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:31,559 [2] DEBUG gnocchi.service: storage.file_subdir_len = 2 2025-10-05 08:20:31,559 [2] DEBUG gnocchi.service: storage.redis_url = **** 2025-10-05 08:20:31,559 [2] DEBUG gnocchi.service: storage.s3_access_key_id = None 2025-10-05 08:20:31,559 [2] DEBUG gnocchi.service: storage.s3_bucket_prefix = gnocchi 2025-10-05 08:20:31,560 [2] DEBUG gnocchi.service: storage.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:31,560 [2] DEBUG gnocchi.service: storage.s3_endpoint_url = None 2025-10-05 08:20:31,560 [2] DEBUG gnocchi.service: storage.s3_max_pool_connections = 50 2025-10-05 08:20:31,560 [2] DEBUG gnocchi.service: storage.s3_region_name = None 2025-10-05 08:20:31,560 [2] DEBUG gnocchi.service: storage.s3_secret_access_key = None 2025-10-05 08:20:31,560 [2] DEBUG gnocchi.service: storage.swift_auth_insecure = False 2025-10-05 08:20:31,560 [2] DEBUG gnocchi.service: storage.swift_auth_version = 3 2025-10-05 08:20:31,560 [2] DEBUG gnocchi.service: storage.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:31,560 [2] DEBUG gnocchi.service: storage.swift_cacert = None 2025-10-05 08:20:31,560 [2] DEBUG gnocchi.service: storage.swift_container_prefix = gnocchi 2025-10-05 08:20:31,560 [2] DEBUG gnocchi.service: storage.swift_endpoint_type = internalURL 2025-10-05 08:20:31,560 [2] DEBUG gnocchi.service: storage.swift_key = **** 2025-10-05 08:20:31,560 [2] DEBUG gnocchi.service: storage.swift_preauthtoken = **** 2025-10-05 08:20:31,560 [2] DEBUG gnocchi.service: storage.swift_project_domain_name = Default 2025-10-05 08:20:31,560 [2] DEBUG gnocchi.service: storage.swift_project_name = None 2025-10-05 08:20:31,561 [2] DEBUG gnocchi.service: storage.swift_region = None 2025-10-05 08:20:31,561 [2] DEBUG gnocchi.service: storage.swift_service_type = object-store 2025-10-05 08:20:31,561 [2] DEBUG gnocchi.service: storage.swift_timeout = 300 2025-10-05 08:20:31,561 [2] DEBUG gnocchi.service: storage.swift_url = None 2025-10-05 08:20:31,561 [2] DEBUG gnocchi.service: storage.swift_user = service:gnocchi 2025-10-05 08:20:31,561 [2] DEBUG gnocchi.service: storage.swift_user_domain_name = Default 2025-10-05 08:20:31,561 [2] DEBUG gnocchi.service: incoming.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:31,561 [2] DEBUG gnocchi.service: incoming.ceph_keyring = 2025-10-05 08:20:31,561 [2] DEBUG gnocchi.service: incoming.ceph_pool = gnocchi 2025-10-05 08:20:31,561 [2] DEBUG gnocchi.service: incoming.ceph_secret = **** 2025-10-05 08:20:31,562 [2] DEBUG gnocchi.service: incoming.ceph_timeout = 30 2025-10-05 08:20:31,562 [2] DEBUG gnocchi.service: incoming.ceph_username = 2025-10-05 08:20:31,562 [2] DEBUG gnocchi.service: incoming.driver = redis 2025-10-05 08:20:31,562 [2] DEBUG gnocchi.service: incoming.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:31,562 [2] DEBUG gnocchi.service: incoming.file_subdir_len = 2 2025-10-05 08:20:31,562 [2] DEBUG gnocchi.service: incoming.redis_url = **** 2025-10-05 08:20:31,562 [2] DEBUG gnocchi.service: incoming.s3_access_key_id = 2025-10-05 08:20:31,562 [2] DEBUG gnocchi.service: incoming.s3_bucket_prefix = gnocchi 2025-10-05 08:20:31,562 [2] DEBUG gnocchi.service: incoming.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:31,563 [2] DEBUG gnocchi.service: incoming.s3_endpoint_url = 2025-10-05 08:20:31,563 [2] DEBUG gnocchi.service: incoming.s3_max_pool_connections = 50 2025-10-05 08:20:31,563 [2] DEBUG gnocchi.service: incoming.s3_region_name = 2025-10-05 08:20:31,563 [2] DEBUG gnocchi.service: incoming.s3_secret_access_key = 2025-10-05 08:20:31,563 [2] DEBUG gnocchi.service: incoming.swift_auth_insecure = False 2025-10-05 08:20:31,563 [2] DEBUG gnocchi.service: incoming.swift_auth_version = 3 2025-10-05 08:20:31,563 [2] DEBUG gnocchi.service: incoming.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:31,563 [2] DEBUG gnocchi.service: incoming.swift_cacert = 2025-10-05 08:20:31,564 [2] DEBUG gnocchi.service: incoming.swift_container_prefix = gnocchi 2025-10-05 08:20:31,564 [2] DEBUG gnocchi.service: incoming.swift_endpoint_type = internalURL 2025-10-05 08:20:31,564 [2] DEBUG gnocchi.service: incoming.swift_key = **** 2025-10-05 08:20:31,564 [2] DEBUG gnocchi.service: incoming.swift_preauthtoken = **** 2025-10-05 08:20:31,564 [2] DEBUG gnocchi.service: incoming.swift_project_domain_name = Default 2025-10-05 08:20:31,564 [2] DEBUG gnocchi.service: incoming.swift_project_name = 2025-10-05 08:20:31,564 [2] DEBUG gnocchi.service: incoming.swift_region = 2025-10-05 08:20:31,564 [2] DEBUG gnocchi.service: incoming.swift_service_type = object-store 2025-10-05 08:20:31,564 [2] DEBUG gnocchi.service: incoming.swift_timeout = 300 2025-10-05 08:20:31,565 [2] DEBUG gnocchi.service: incoming.swift_url = 2025-10-05 08:20:31,565 [2] DEBUG gnocchi.service: incoming.swift_user = service:gnocchi 2025-10-05 08:20:31,565 [2] DEBUG gnocchi.service: incoming.swift_user_domain_name = Default 2025-10-05 08:20:31,565 [2] DEBUG gnocchi.service: statsd.archive_policy_name = low 2025-10-05 08:20:31,565 [2] DEBUG gnocchi.service: statsd.creator = None 2025-10-05 08:20:31,565 [2] DEBUG gnocchi.service: statsd.flush_delay = 10.0 2025-10-05 08:20:31,565 [2] DEBUG gnocchi.service: statsd.host = 0.0.0.0 2025-10-05 08:20:31,565 [2] DEBUG gnocchi.service: statsd.port = 8125 2025-10-05 08:20:31,565 [2] DEBUG gnocchi.service: statsd.resource_id = 0a8b55df-f90f-491c-8cb9-7cdecec6fc26 2025-10-05 08:20:31,565 [2] DEBUG gnocchi.service: amqp1d.creator = None 2025-10-05 08:20:31,565 [2] DEBUG gnocchi.service: amqp1d.data_source = collectd 2025-10-05 08:20:31,566 [2] DEBUG gnocchi.service: amqp1d.flush_delay = 10.0 2025-10-05 08:20:31,566 [2] DEBUG gnocchi.service: amqp1d.resource_type = collectd_amqp1d 2025-10-05 08:20:31,566 [2] DEBUG gnocchi.service: amqp1d.url = localhost:5672/u/collectd/telemetry 2025-10-05 08:20:31,566 [2] DEBUG gnocchi.service: archive_policy.default_aggregation_methods = ['mean', 'min', 'max', 'sum', 'std', 'count'] 2025-10-05 08:20:31,566 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:31,816 [2] CRITICAL root: Traceback (most recent call last): File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.ProgrammingError: (1146, "Table 'gnocchi.resource_type' doesn't exist") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/bin/gnocchi-statsd", line 33, in sys.exit(load_entry_point('gnocchi==4.4.6.dev2+gff96e73d', 'console_scripts', 'gnocchi-statsd')()) File "/usr/lib/python3.9/site-packages/gnocchi/cli/statsd.py", line 20, in statsd statsd_service.start() File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 174, in start stats = Stats(conf) File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 41, in __init__ self.indexer.create_resource('generic', File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 154, in wrapper ectxt.value = e.inner_exc File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 227, in __exit__ self.force_reraise() File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 200, in force_reraise raise self.value File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 142, in wrapper return f(*args, **kwargs) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 811, in create_resource resource_cls = self._resource_type_to_mappers( File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 587, in _resource_type_to_mappers resource_type = self._get_resource_type(session, name) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 482, in _get_resource_type resource_type = session.query(ResourceType).get(name) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1018, in get return self._get_impl(ident, loading.load_on_pk_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1135, in _get_impl return db_load_fn(self, primary_key_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/loading.py", line 286, in load_on_pk_identity return q.one() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3490, in one ret = self.one_or_none() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none ret = list(self) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__ return self._execute_and_instances(context) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute return meth(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement ret = self._execute_context( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context self._handle_dbapi_exception( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1508, in _handle_dbapi_exception util.raise_(newraise, with_traceback=exc_info[2], from_=e) File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_ raise exception File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'gnocchi.resource_type' doesn't exist") [SQL: SELECT resource_type.name AS resource_type_name, resource_type.tablename AS resource_type_tablename, resource_type.attributes AS resource_type_attributes, resource_type.state AS resource_type_state, resource_type.updated_at AS resource_type_updated_at FROM resource_type WHERE resource_type.name = %(param_1)s] [parameters: {'param_1': 'generic'}] (Background on this error at: http://sqlalche.me/e/13/f405) 2025-10-05 08:20:33,675 [2] INFO gnocchi.service: Gnocchi version 4.4.6.dev2+gff96e73d 2025-10-05 08:20:33,675 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:33,675 [2] DEBUG gnocchi.service: Configuration options gathered from: 2025-10-05 08:20:33,675 [2] DEBUG gnocchi.service: command line args: [] 2025-10-05 08:20:33,675 [2] DEBUG gnocchi.service: config files: ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:33,675 [2] DEBUG gnocchi.service: ================================================================================ 2025-10-05 08:20:33,675 [2] DEBUG gnocchi.service: config_dir = [] 2025-10-05 08:20:33,675 [2] DEBUG gnocchi.service: config_file = ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:33,676 [2] DEBUG gnocchi.service: config_source = [] 2025-10-05 08:20:33,676 [2] DEBUG gnocchi.service: coordination_url = **** 2025-10-05 08:20:33,676 [2] DEBUG gnocchi.service: debug = True 2025-10-05 08:20:33,676 [2] DEBUG gnocchi.service: log_dir = /var/log/gnocchi 2025-10-05 08:20:33,676 [2] DEBUG gnocchi.service: log_file = None 2025-10-05 08:20:33,676 [2] DEBUG gnocchi.service: parallel_operations = 8 2025-10-05 08:20:33,676 [2] DEBUG gnocchi.service: syslog_log_facility = user 2025-10-05 08:20:33,676 [2] DEBUG gnocchi.service: use_journal = False 2025-10-05 08:20:33,676 [2] DEBUG gnocchi.service: use_syslog = False 2025-10-05 08:20:33,676 [2] DEBUG gnocchi.service: verbose = True 2025-10-05 08:20:33,676 [2] DEBUG gnocchi.service: database.backend = sqlalchemy 2025-10-05 08:20:33,676 [2] DEBUG gnocchi.service: database.connection = **** 2025-10-05 08:20:33,676 [2] DEBUG gnocchi.service: database.connection_debug = 0 2025-10-05 08:20:33,676 [2] DEBUG gnocchi.service: database.connection_parameters = 2025-10-05 08:20:33,676 [2] DEBUG gnocchi.service: database.connection_recycle_time = 3600 2025-10-05 08:20:33,676 [2] DEBUG gnocchi.service: database.connection_trace = False 2025-10-05 08:20:33,677 [2] DEBUG gnocchi.service: database.db_inc_retry_interval = True 2025-10-05 08:20:33,677 [2] DEBUG gnocchi.service: database.db_max_retries = 20 2025-10-05 08:20:33,677 [2] DEBUG gnocchi.service: database.db_max_retry_interval = 10 2025-10-05 08:20:33,677 [2] DEBUG gnocchi.service: database.db_retry_interval = 1 2025-10-05 08:20:33,677 [2] DEBUG gnocchi.service: database.max_overflow = 50 2025-10-05 08:20:33,677 [2] DEBUG gnocchi.service: database.max_pool_size = 5 2025-10-05 08:20:33,677 [2] DEBUG gnocchi.service: database.max_retries = 10 2025-10-05 08:20:33,677 [2] DEBUG gnocchi.service: database.mysql_enable_ndb = False 2025-10-05 08:20:33,677 [2] DEBUG gnocchi.service: database.mysql_sql_mode = TRADITIONAL 2025-10-05 08:20:33,677 [2] DEBUG gnocchi.service: database.pool_timeout = None 2025-10-05 08:20:33,677 [2] DEBUG gnocchi.service: database.retry_interval = 10 2025-10-05 08:20:33,677 [2] DEBUG gnocchi.service: database.slave_connection = **** 2025-10-05 08:20:33,677 [2] DEBUG gnocchi.service: database.sqlite_synchronous = True 2025-10-05 08:20:33,677 [2] DEBUG gnocchi.service: database.use_db_reconnect = False 2025-10-05 08:20:33,677 [2] DEBUG gnocchi.service: indexer.url = **** 2025-10-05 08:20:33,678 [2] DEBUG gnocchi.service: metricd.greedy = True 2025-10-05 08:20:33,678 [2] DEBUG gnocchi.service: metricd.metric_cleanup_delay = 300 2025-10-05 08:20:33,678 [2] DEBUG gnocchi.service: metricd.metric_processing_delay = 30 2025-10-05 08:20:33,678 [2] DEBUG gnocchi.service: metricd.metric_reporting_delay = 120 2025-10-05 08:20:33,678 [2] DEBUG gnocchi.service: metricd.processing_replicas = 3 2025-10-05 08:20:33,678 [2] DEBUG gnocchi.service: metricd.workers = 1 2025-10-05 08:20:33,678 [2] DEBUG gnocchi.service: api.auth_mode = keystone 2025-10-05 08:20:33,679 [2] WARNING oslo_config.cfg: Deprecated: Option "enable_proxy_headers_parsing" from group "oslo_middleware" is deprecated. Use option "enable_proxy_headers_parsing" from group "api". 2025-10-05 08:20:33,679 [2] DEBUG gnocchi.service: api.enable_proxy_headers_parsing = True 2025-10-05 08:20:33,679 [2] DEBUG gnocchi.service: api.host = 0.0.0.0 2025-10-05 08:20:33,679 [2] DEBUG gnocchi.service: api.max_limit = 1000 2025-10-05 08:20:33,679 [2] DEBUG gnocchi.service: api.operation_timeout = 10 2025-10-05 08:20:33,679 [2] DEBUG gnocchi.service: api.paste_config = api-paste.ini 2025-10-05 08:20:33,679 [2] DEBUG gnocchi.service: api.port = 8041 2025-10-05 08:20:33,679 [2] DEBUG gnocchi.service: api.uwsgi_mode = http 2025-10-05 08:20:33,679 [2] DEBUG gnocchi.service: storage.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:33,679 [2] DEBUG gnocchi.service: storage.ceph_keyring = None 2025-10-05 08:20:33,679 [2] DEBUG gnocchi.service: storage.ceph_pool = gnocchi 2025-10-05 08:20:33,679 [2] DEBUG gnocchi.service: storage.ceph_secret = **** 2025-10-05 08:20:33,679 [2] DEBUG gnocchi.service: storage.ceph_timeout = 30 2025-10-05 08:20:33,680 [2] DEBUG gnocchi.service: storage.ceph_username = None 2025-10-05 08:20:33,680 [2] DEBUG gnocchi.service: storage.driver = swift 2025-10-05 08:20:33,680 [2] DEBUG gnocchi.service: storage.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:33,680 [2] DEBUG gnocchi.service: storage.file_subdir_len = 2 2025-10-05 08:20:33,680 [2] DEBUG gnocchi.service: storage.redis_url = **** 2025-10-05 08:20:33,680 [2] DEBUG gnocchi.service: storage.s3_access_key_id = None 2025-10-05 08:20:33,680 [2] DEBUG gnocchi.service: storage.s3_bucket_prefix = gnocchi 2025-10-05 08:20:33,680 [2] DEBUG gnocchi.service: storage.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:33,680 [2] DEBUG gnocchi.service: storage.s3_endpoint_url = None 2025-10-05 08:20:33,680 [2] DEBUG gnocchi.service: storage.s3_max_pool_connections = 50 2025-10-05 08:20:33,680 [2] DEBUG gnocchi.service: storage.s3_region_name = None 2025-10-05 08:20:33,680 [2] DEBUG gnocchi.service: storage.s3_secret_access_key = None 2025-10-05 08:20:33,680 [2] DEBUG gnocchi.service: storage.swift_auth_insecure = False 2025-10-05 08:20:33,681 [2] DEBUG gnocchi.service: storage.swift_auth_version = 3 2025-10-05 08:20:33,681 [2] DEBUG gnocchi.service: storage.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:33,681 [2] DEBUG gnocchi.service: storage.swift_cacert = None 2025-10-05 08:20:33,681 [2] DEBUG gnocchi.service: storage.swift_container_prefix = gnocchi 2025-10-05 08:20:33,681 [2] DEBUG gnocchi.service: storage.swift_endpoint_type = internalURL 2025-10-05 08:20:33,681 [2] DEBUG gnocchi.service: storage.swift_key = **** 2025-10-05 08:20:33,681 [2] DEBUG gnocchi.service: storage.swift_preauthtoken = **** 2025-10-05 08:20:33,681 [2] DEBUG gnocchi.service: storage.swift_project_domain_name = Default 2025-10-05 08:20:33,681 [2] DEBUG gnocchi.service: storage.swift_project_name = None 2025-10-05 08:20:33,681 [2] DEBUG gnocchi.service: storage.swift_region = None 2025-10-05 08:20:33,681 [2] DEBUG gnocchi.service: storage.swift_service_type = object-store 2025-10-05 08:20:33,681 [2] DEBUG gnocchi.service: storage.swift_timeout = 300 2025-10-05 08:20:33,681 [2] DEBUG gnocchi.service: storage.swift_url = None 2025-10-05 08:20:33,681 [2] DEBUG gnocchi.service: storage.swift_user = service:gnocchi 2025-10-05 08:20:33,682 [2] DEBUG gnocchi.service: storage.swift_user_domain_name = Default 2025-10-05 08:20:33,682 [2] DEBUG gnocchi.service: incoming.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:33,682 [2] DEBUG gnocchi.service: incoming.ceph_keyring = 2025-10-05 08:20:33,682 [2] DEBUG gnocchi.service: incoming.ceph_pool = gnocchi 2025-10-05 08:20:33,682 [2] DEBUG gnocchi.service: incoming.ceph_secret = **** 2025-10-05 08:20:33,682 [2] DEBUG gnocchi.service: incoming.ceph_timeout = 30 2025-10-05 08:20:33,682 [2] DEBUG gnocchi.service: incoming.ceph_username = 2025-10-05 08:20:33,682 [2] DEBUG gnocchi.service: incoming.driver = redis 2025-10-05 08:20:33,683 [2] DEBUG gnocchi.service: incoming.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:33,683 [2] DEBUG gnocchi.service: incoming.file_subdir_len = 2 2025-10-05 08:20:33,683 [2] DEBUG gnocchi.service: incoming.redis_url = **** 2025-10-05 08:20:33,683 [2] DEBUG gnocchi.service: incoming.s3_access_key_id = 2025-10-05 08:20:33,683 [2] DEBUG gnocchi.service: incoming.s3_bucket_prefix = gnocchi 2025-10-05 08:20:33,683 [2] DEBUG gnocchi.service: incoming.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:33,683 [2] DEBUG gnocchi.service: incoming.s3_endpoint_url = 2025-10-05 08:20:33,683 [2] DEBUG gnocchi.service: incoming.s3_max_pool_connections = 50 2025-10-05 08:20:33,683 [2] DEBUG gnocchi.service: incoming.s3_region_name = 2025-10-05 08:20:33,684 [2] DEBUG gnocchi.service: incoming.s3_secret_access_key = 2025-10-05 08:20:33,684 [2] DEBUG gnocchi.service: incoming.swift_auth_insecure = False 2025-10-05 08:20:33,684 [2] DEBUG gnocchi.service: incoming.swift_auth_version = 3 2025-10-05 08:20:33,684 [2] DEBUG gnocchi.service: incoming.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:33,684 [2] DEBUG gnocchi.service: incoming.swift_cacert = 2025-10-05 08:20:33,684 [2] DEBUG gnocchi.service: incoming.swift_container_prefix = gnocchi 2025-10-05 08:20:33,684 [2] DEBUG gnocchi.service: incoming.swift_endpoint_type = internalURL 2025-10-05 08:20:33,684 [2] DEBUG gnocchi.service: incoming.swift_key = **** 2025-10-05 08:20:33,685 [2] DEBUG gnocchi.service: incoming.swift_preauthtoken = **** 2025-10-05 08:20:33,685 [2] DEBUG gnocchi.service: incoming.swift_project_domain_name = Default 2025-10-05 08:20:33,685 [2] DEBUG gnocchi.service: incoming.swift_project_name = 2025-10-05 08:20:33,685 [2] DEBUG gnocchi.service: incoming.swift_region = 2025-10-05 08:20:33,685 [2] DEBUG gnocchi.service: incoming.swift_service_type = object-store 2025-10-05 08:20:33,685 [2] DEBUG gnocchi.service: incoming.swift_timeout = 300 2025-10-05 08:20:33,685 [2] DEBUG gnocchi.service: incoming.swift_url = 2025-10-05 08:20:33,685 [2] DEBUG gnocchi.service: incoming.swift_user = service:gnocchi 2025-10-05 08:20:33,686 [2] DEBUG gnocchi.service: incoming.swift_user_domain_name = Default 2025-10-05 08:20:33,686 [2] DEBUG gnocchi.service: statsd.archive_policy_name = low 2025-10-05 08:20:33,686 [2] DEBUG gnocchi.service: statsd.creator = None 2025-10-05 08:20:33,686 [2] DEBUG gnocchi.service: statsd.flush_delay = 10.0 2025-10-05 08:20:33,686 [2] DEBUG gnocchi.service: statsd.host = 0.0.0.0 2025-10-05 08:20:33,686 [2] DEBUG gnocchi.service: statsd.port = 8125 2025-10-05 08:20:33,686 [2] DEBUG gnocchi.service: statsd.resource_id = 0a8b55df-f90f-491c-8cb9-7cdecec6fc26 2025-10-05 08:20:33,686 [2] DEBUG gnocchi.service: amqp1d.creator = None 2025-10-05 08:20:33,686 [2] DEBUG gnocchi.service: amqp1d.data_source = collectd 2025-10-05 08:20:33,686 [2] DEBUG gnocchi.service: amqp1d.flush_delay = 10.0 2025-10-05 08:20:33,686 [2] DEBUG gnocchi.service: amqp1d.resource_type = collectd_amqp1d 2025-10-05 08:20:33,686 [2] DEBUG gnocchi.service: amqp1d.url = localhost:5672/u/collectd/telemetry 2025-10-05 08:20:33,686 [2] DEBUG gnocchi.service: archive_policy.default_aggregation_methods = ['mean', 'min', 'max', 'sum', 'std', 'count'] 2025-10-05 08:20:33,686 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:33,938 [2] CRITICAL root: Traceback (most recent call last): File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.ProgrammingError: (1146, "Table 'gnocchi.resource_type' doesn't exist") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/bin/gnocchi-statsd", line 33, in sys.exit(load_entry_point('gnocchi==4.4.6.dev2+gff96e73d', 'console_scripts', 'gnocchi-statsd')()) File "/usr/lib/python3.9/site-packages/gnocchi/cli/statsd.py", line 20, in statsd statsd_service.start() File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 174, in start stats = Stats(conf) File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 41, in __init__ self.indexer.create_resource('generic', File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 154, in wrapper ectxt.value = e.inner_exc File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 227, in __exit__ self.force_reraise() File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 200, in force_reraise raise self.value File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 142, in wrapper return f(*args, **kwargs) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 811, in create_resource resource_cls = self._resource_type_to_mappers( File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 587, in _resource_type_to_mappers resource_type = self._get_resource_type(session, name) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 482, in _get_resource_type resource_type = session.query(ResourceType).get(name) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1018, in get return self._get_impl(ident, loading.load_on_pk_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1135, in _get_impl return db_load_fn(self, primary_key_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/loading.py", line 286, in load_on_pk_identity return q.one() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3490, in one ret = self.one_or_none() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none ret = list(self) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__ return self._execute_and_instances(context) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute return meth(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement ret = self._execute_context( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context self._handle_dbapi_exception( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1508, in _handle_dbapi_exception util.raise_(newraise, with_traceback=exc_info[2], from_=e) File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_ raise exception File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'gnocchi.resource_type' doesn't exist") [SQL: SELECT resource_type.name AS resource_type_name, resource_type.tablename AS resource_type_tablename, resource_type.attributes AS resource_type_attributes, resource_type.state AS resource_type_state, resource_type.updated_at AS resource_type_updated_at FROM resource_type WHERE resource_type.name = %(param_1)s] [parameters: {'param_1': 'generic'}] (Background on this error at: http://sqlalche.me/e/13/f405) 2025-10-05 08:20:35,687 [2] INFO gnocchi.service: Gnocchi version 4.4.6.dev2+gff96e73d 2025-10-05 08:20:35,687 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:35,687 [2] DEBUG gnocchi.service: Configuration options gathered from: 2025-10-05 08:20:35,687 [2] DEBUG gnocchi.service: command line args: [] 2025-10-05 08:20:35,687 [2] DEBUG gnocchi.service: config files: ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:35,687 [2] DEBUG gnocchi.service: ================================================================================ 2025-10-05 08:20:35,687 [2] DEBUG gnocchi.service: config_dir = [] 2025-10-05 08:20:35,687 [2] DEBUG gnocchi.service: config_file = ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:35,687 [2] DEBUG gnocchi.service: config_source = [] 2025-10-05 08:20:35,687 [2] DEBUG gnocchi.service: coordination_url = **** 2025-10-05 08:20:35,687 [2] DEBUG gnocchi.service: debug = True 2025-10-05 08:20:35,687 [2] DEBUG gnocchi.service: log_dir = /var/log/gnocchi 2025-10-05 08:20:35,687 [2] DEBUG gnocchi.service: log_file = None 2025-10-05 08:20:35,687 [2] DEBUG gnocchi.service: parallel_operations = 8 2025-10-05 08:20:35,687 [2] DEBUG gnocchi.service: syslog_log_facility = user 2025-10-05 08:20:35,688 [2] DEBUG gnocchi.service: use_journal = False 2025-10-05 08:20:35,688 [2] DEBUG gnocchi.service: use_syslog = False 2025-10-05 08:20:35,688 [2] DEBUG gnocchi.service: verbose = True 2025-10-05 08:20:35,688 [2] DEBUG gnocchi.service: database.backend = sqlalchemy 2025-10-05 08:20:35,688 [2] DEBUG gnocchi.service: database.connection = **** 2025-10-05 08:20:35,688 [2] DEBUG gnocchi.service: database.connection_debug = 0 2025-10-05 08:20:35,688 [2] DEBUG gnocchi.service: database.connection_parameters = 2025-10-05 08:20:35,688 [2] DEBUG gnocchi.service: database.connection_recycle_time = 3600 2025-10-05 08:20:35,688 [2] DEBUG gnocchi.service: database.connection_trace = False 2025-10-05 08:20:35,688 [2] DEBUG gnocchi.service: database.db_inc_retry_interval = True 2025-10-05 08:20:35,688 [2] DEBUG gnocchi.service: database.db_max_retries = 20 2025-10-05 08:20:35,688 [2] DEBUG gnocchi.service: database.db_max_retry_interval = 10 2025-10-05 08:20:35,688 [2] DEBUG gnocchi.service: database.db_retry_interval = 1 2025-10-05 08:20:35,688 [2] DEBUG gnocchi.service: database.max_overflow = 50 2025-10-05 08:20:35,688 [2] DEBUG gnocchi.service: database.max_pool_size = 5 2025-10-05 08:20:35,689 [2] DEBUG gnocchi.service: database.max_retries = 10 2025-10-05 08:20:35,689 [2] DEBUG gnocchi.service: database.mysql_enable_ndb = False 2025-10-05 08:20:35,689 [2] DEBUG gnocchi.service: database.mysql_sql_mode = TRADITIONAL 2025-10-05 08:20:35,689 [2] DEBUG gnocchi.service: database.pool_timeout = None 2025-10-05 08:20:35,689 [2] DEBUG gnocchi.service: database.retry_interval = 10 2025-10-05 08:20:35,689 [2] DEBUG gnocchi.service: database.slave_connection = **** 2025-10-05 08:20:35,689 [2] DEBUG gnocchi.service: database.sqlite_synchronous = True 2025-10-05 08:20:35,689 [2] DEBUG gnocchi.service: database.use_db_reconnect = False 2025-10-05 08:20:35,689 [2] DEBUG gnocchi.service: indexer.url = **** 2025-10-05 08:20:35,689 [2] DEBUG gnocchi.service: metricd.greedy = True 2025-10-05 08:20:35,689 [2] DEBUG gnocchi.service: metricd.metric_cleanup_delay = 300 2025-10-05 08:20:35,689 [2] DEBUG gnocchi.service: metricd.metric_processing_delay = 30 2025-10-05 08:20:35,689 [2] DEBUG gnocchi.service: metricd.metric_reporting_delay = 120 2025-10-05 08:20:35,689 [2] DEBUG gnocchi.service: metricd.processing_replicas = 3 2025-10-05 08:20:35,689 [2] DEBUG gnocchi.service: metricd.workers = 1 2025-10-05 08:20:35,689 [2] DEBUG gnocchi.service: api.auth_mode = keystone 2025-10-05 08:20:35,690 [2] WARNING oslo_config.cfg: Deprecated: Option "enable_proxy_headers_parsing" from group "oslo_middleware" is deprecated. Use option "enable_proxy_headers_parsing" from group "api". 2025-10-05 08:20:35,690 [2] DEBUG gnocchi.service: api.enable_proxy_headers_parsing = True 2025-10-05 08:20:35,690 [2] DEBUG gnocchi.service: api.host = 0.0.0.0 2025-10-05 08:20:35,690 [2] DEBUG gnocchi.service: api.max_limit = 1000 2025-10-05 08:20:35,690 [2] DEBUG gnocchi.service: api.operation_timeout = 10 2025-10-05 08:20:35,690 [2] DEBUG gnocchi.service: api.paste_config = api-paste.ini 2025-10-05 08:20:35,690 [2] DEBUG gnocchi.service: api.port = 8041 2025-10-05 08:20:35,691 [2] DEBUG gnocchi.service: api.uwsgi_mode = http 2025-10-05 08:20:35,691 [2] DEBUG gnocchi.service: storage.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:35,691 [2] DEBUG gnocchi.service: storage.ceph_keyring = None 2025-10-05 08:20:35,691 [2] DEBUG gnocchi.service: storage.ceph_pool = gnocchi 2025-10-05 08:20:35,691 [2] DEBUG gnocchi.service: storage.ceph_secret = **** 2025-10-05 08:20:35,691 [2] DEBUG gnocchi.service: storage.ceph_timeout = 30 2025-10-05 08:20:35,691 [2] DEBUG gnocchi.service: storage.ceph_username = None 2025-10-05 08:20:35,691 [2] DEBUG gnocchi.service: storage.driver = swift 2025-10-05 08:20:35,691 [2] DEBUG gnocchi.service: storage.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:35,691 [2] DEBUG gnocchi.service: storage.file_subdir_len = 2 2025-10-05 08:20:35,691 [2] DEBUG gnocchi.service: storage.redis_url = **** 2025-10-05 08:20:35,691 [2] DEBUG gnocchi.service: storage.s3_access_key_id = None 2025-10-05 08:20:35,691 [2] DEBUG gnocchi.service: storage.s3_bucket_prefix = gnocchi 2025-10-05 08:20:35,691 [2] DEBUG gnocchi.service: storage.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:35,692 [2] DEBUG gnocchi.service: storage.s3_endpoint_url = None 2025-10-05 08:20:35,692 [2] DEBUG gnocchi.service: storage.s3_max_pool_connections = 50 2025-10-05 08:20:35,692 [2] DEBUG gnocchi.service: storage.s3_region_name = None 2025-10-05 08:20:35,692 [2] DEBUG gnocchi.service: storage.s3_secret_access_key = None 2025-10-05 08:20:35,692 [2] DEBUG gnocchi.service: storage.swift_auth_insecure = False 2025-10-05 08:20:35,692 [2] DEBUG gnocchi.service: storage.swift_auth_version = 3 2025-10-05 08:20:35,692 [2] DEBUG gnocchi.service: storage.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:35,692 [2] DEBUG gnocchi.service: storage.swift_cacert = None 2025-10-05 08:20:35,692 [2] DEBUG gnocchi.service: storage.swift_container_prefix = gnocchi 2025-10-05 08:20:35,692 [2] DEBUG gnocchi.service: storage.swift_endpoint_type = internalURL 2025-10-05 08:20:35,692 [2] DEBUG gnocchi.service: storage.swift_key = **** 2025-10-05 08:20:35,692 [2] DEBUG gnocchi.service: storage.swift_preauthtoken = **** 2025-10-05 08:20:35,692 [2] DEBUG gnocchi.service: storage.swift_project_domain_name = Default 2025-10-05 08:20:35,692 [2] DEBUG gnocchi.service: storage.swift_project_name = None 2025-10-05 08:20:35,693 [2] DEBUG gnocchi.service: storage.swift_region = None 2025-10-05 08:20:35,693 [2] DEBUG gnocchi.service: storage.swift_service_type = object-store 2025-10-05 08:20:35,693 [2] DEBUG gnocchi.service: storage.swift_timeout = 300 2025-10-05 08:20:35,693 [2] DEBUG gnocchi.service: storage.swift_url = None 2025-10-05 08:20:35,693 [2] DEBUG gnocchi.service: storage.swift_user = service:gnocchi 2025-10-05 08:20:35,693 [2] DEBUG gnocchi.service: storage.swift_user_domain_name = Default 2025-10-05 08:20:35,693 [2] DEBUG gnocchi.service: incoming.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:35,693 [2] DEBUG gnocchi.service: incoming.ceph_keyring = 2025-10-05 08:20:35,693 [2] DEBUG gnocchi.service: incoming.ceph_pool = gnocchi 2025-10-05 08:20:35,693 [2] DEBUG gnocchi.service: incoming.ceph_secret = **** 2025-10-05 08:20:35,693 [2] DEBUG gnocchi.service: incoming.ceph_timeout = 30 2025-10-05 08:20:35,694 [2] DEBUG gnocchi.service: incoming.ceph_username = 2025-10-05 08:20:35,694 [2] DEBUG gnocchi.service: incoming.driver = redis 2025-10-05 08:20:35,694 [2] DEBUG gnocchi.service: incoming.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:35,694 [2] DEBUG gnocchi.service: incoming.file_subdir_len = 2 2025-10-05 08:20:35,694 [2] DEBUG gnocchi.service: incoming.redis_url = **** 2025-10-05 08:20:35,694 [2] DEBUG gnocchi.service: incoming.s3_access_key_id = 2025-10-05 08:20:35,694 [2] DEBUG gnocchi.service: incoming.s3_bucket_prefix = gnocchi 2025-10-05 08:20:35,694 [2] DEBUG gnocchi.service: incoming.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:35,695 [2] DEBUG gnocchi.service: incoming.s3_endpoint_url = 2025-10-05 08:20:35,695 [2] DEBUG gnocchi.service: incoming.s3_max_pool_connections = 50 2025-10-05 08:20:35,695 [2] DEBUG gnocchi.service: incoming.s3_region_name = 2025-10-05 08:20:35,695 [2] DEBUG gnocchi.service: incoming.s3_secret_access_key = 2025-10-05 08:20:35,695 [2] DEBUG gnocchi.service: incoming.swift_auth_insecure = False 2025-10-05 08:20:35,695 [2] DEBUG gnocchi.service: incoming.swift_auth_version = 3 2025-10-05 08:20:35,695 [2] DEBUG gnocchi.service: incoming.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:35,695 [2] DEBUG gnocchi.service: incoming.swift_cacert = 2025-10-05 08:20:35,696 [2] DEBUG gnocchi.service: incoming.swift_container_prefix = gnocchi 2025-10-05 08:20:35,696 [2] DEBUG gnocchi.service: incoming.swift_endpoint_type = internalURL 2025-10-05 08:20:35,696 [2] DEBUG gnocchi.service: incoming.swift_key = **** 2025-10-05 08:20:35,696 [2] DEBUG gnocchi.service: incoming.swift_preauthtoken = **** 2025-10-05 08:20:35,696 [2] DEBUG gnocchi.service: incoming.swift_project_domain_name = Default 2025-10-05 08:20:35,696 [2] DEBUG gnocchi.service: incoming.swift_project_name = 2025-10-05 08:20:35,696 [2] DEBUG gnocchi.service: incoming.swift_region = 2025-10-05 08:20:35,696 [2] DEBUG gnocchi.service: incoming.swift_service_type = object-store 2025-10-05 08:20:35,697 [2] DEBUG gnocchi.service: incoming.swift_timeout = 300 2025-10-05 08:20:35,697 [2] DEBUG gnocchi.service: incoming.swift_url = 2025-10-05 08:20:35,697 [2] DEBUG gnocchi.service: incoming.swift_user = service:gnocchi 2025-10-05 08:20:35,697 [2] DEBUG gnocchi.service: incoming.swift_user_domain_name = Default 2025-10-05 08:20:35,697 [2] DEBUG gnocchi.service: statsd.archive_policy_name = low 2025-10-05 08:20:35,697 [2] DEBUG gnocchi.service: statsd.creator = None 2025-10-05 08:20:35,697 [2] DEBUG gnocchi.service: statsd.flush_delay = 10.0 2025-10-05 08:20:35,697 [2] DEBUG gnocchi.service: statsd.host = 0.0.0.0 2025-10-05 08:20:35,697 [2] DEBUG gnocchi.service: statsd.port = 8125 2025-10-05 08:20:35,697 [2] DEBUG gnocchi.service: statsd.resource_id = 0a8b55df-f90f-491c-8cb9-7cdecec6fc26 2025-10-05 08:20:35,697 [2] DEBUG gnocchi.service: amqp1d.creator = None 2025-10-05 08:20:35,697 [2] DEBUG gnocchi.service: amqp1d.data_source = collectd 2025-10-05 08:20:35,698 [2] DEBUG gnocchi.service: amqp1d.flush_delay = 10.0 2025-10-05 08:20:35,698 [2] DEBUG gnocchi.service: amqp1d.resource_type = collectd_amqp1d 2025-10-05 08:20:35,698 [2] DEBUG gnocchi.service: amqp1d.url = localhost:5672/u/collectd/telemetry 2025-10-05 08:20:35,698 [2] DEBUG gnocchi.service: archive_policy.default_aggregation_methods = ['mean', 'min', 'max', 'sum', 'std', 'count'] 2025-10-05 08:20:35,698 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:35,949 [2] CRITICAL root: Traceback (most recent call last): File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.ProgrammingError: (1146, "Table 'gnocchi.resource_type' doesn't exist") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/bin/gnocchi-statsd", line 33, in sys.exit(load_entry_point('gnocchi==4.4.6.dev2+gff96e73d', 'console_scripts', 'gnocchi-statsd')()) File "/usr/lib/python3.9/site-packages/gnocchi/cli/statsd.py", line 20, in statsd statsd_service.start() File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 174, in start stats = Stats(conf) File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 41, in __init__ self.indexer.create_resource('generic', File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 154, in wrapper ectxt.value = e.inner_exc File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 227, in __exit__ self.force_reraise() File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 200, in force_reraise raise self.value File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 142, in wrapper return f(*args, **kwargs) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 811, in create_resource resource_cls = self._resource_type_to_mappers( File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 587, in _resource_type_to_mappers resource_type = self._get_resource_type(session, name) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 482, in _get_resource_type resource_type = session.query(ResourceType).get(name) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1018, in get return self._get_impl(ident, loading.load_on_pk_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1135, in _get_impl return db_load_fn(self, primary_key_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/loading.py", line 286, in load_on_pk_identity return q.one() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3490, in one ret = self.one_or_none() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none ret = list(self) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__ return self._execute_and_instances(context) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute return meth(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement ret = self._execute_context( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context self._handle_dbapi_exception( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1508, in _handle_dbapi_exception util.raise_(newraise, with_traceback=exc_info[2], from_=e) File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_ raise exception File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'gnocchi.resource_type' doesn't exist") [SQL: SELECT resource_type.name AS resource_type_name, resource_type.tablename AS resource_type_tablename, resource_type.attributes AS resource_type_attributes, resource_type.state AS resource_type_state, resource_type.updated_at AS resource_type_updated_at FROM resource_type WHERE resource_type.name = %(param_1)s] [parameters: {'param_1': 'generic'}] (Background on this error at: http://sqlalche.me/e/13/f405) 2025-10-05 08:20:37,667 [2] INFO gnocchi.service: Gnocchi version 4.4.6.dev2+gff96e73d 2025-10-05 08:20:37,667 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:37,667 [2] DEBUG gnocchi.service: Configuration options gathered from: 2025-10-05 08:20:37,667 [2] DEBUG gnocchi.service: command line args: [] 2025-10-05 08:20:37,668 [2] DEBUG gnocchi.service: config files: ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:37,668 [2] DEBUG gnocchi.service: ================================================================================ 2025-10-05 08:20:37,668 [2] DEBUG gnocchi.service: config_dir = [] 2025-10-05 08:20:37,668 [2] DEBUG gnocchi.service: config_file = ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:37,668 [2] DEBUG gnocchi.service: config_source = [] 2025-10-05 08:20:37,668 [2] DEBUG gnocchi.service: coordination_url = **** 2025-10-05 08:20:37,668 [2] DEBUG gnocchi.service: debug = True 2025-10-05 08:20:37,668 [2] DEBUG gnocchi.service: log_dir = /var/log/gnocchi 2025-10-05 08:20:37,668 [2] DEBUG gnocchi.service: log_file = None 2025-10-05 08:20:37,668 [2] DEBUG gnocchi.service: parallel_operations = 8 2025-10-05 08:20:37,668 [2] DEBUG gnocchi.service: syslog_log_facility = user 2025-10-05 08:20:37,668 [2] DEBUG gnocchi.service: use_journal = False 2025-10-05 08:20:37,669 [2] DEBUG gnocchi.service: use_syslog = False 2025-10-05 08:20:37,669 [2] DEBUG gnocchi.service: verbose = True 2025-10-05 08:20:37,669 [2] DEBUG gnocchi.service: database.backend = sqlalchemy 2025-10-05 08:20:37,669 [2] DEBUG gnocchi.service: database.connection = **** 2025-10-05 08:20:37,669 [2] DEBUG gnocchi.service: database.connection_debug = 0 2025-10-05 08:20:37,669 [2] DEBUG gnocchi.service: database.connection_parameters = 2025-10-05 08:20:37,669 [2] DEBUG gnocchi.service: database.connection_recycle_time = 3600 2025-10-05 08:20:37,669 [2] DEBUG gnocchi.service: database.connection_trace = False 2025-10-05 08:20:37,669 [2] DEBUG gnocchi.service: database.db_inc_retry_interval = True 2025-10-05 08:20:37,669 [2] DEBUG gnocchi.service: database.db_max_retries = 20 2025-10-05 08:20:37,670 [2] DEBUG gnocchi.service: database.db_max_retry_interval = 10 2025-10-05 08:20:37,670 [2] DEBUG gnocchi.service: database.db_retry_interval = 1 2025-10-05 08:20:37,670 [2] DEBUG gnocchi.service: database.max_overflow = 50 2025-10-05 08:20:37,670 [2] DEBUG gnocchi.service: database.max_pool_size = 5 2025-10-05 08:20:37,670 [2] DEBUG gnocchi.service: database.max_retries = 10 2025-10-05 08:20:37,670 [2] DEBUG gnocchi.service: database.mysql_enable_ndb = False 2025-10-05 08:20:37,670 [2] DEBUG gnocchi.service: database.mysql_sql_mode = TRADITIONAL 2025-10-05 08:20:37,670 [2] DEBUG gnocchi.service: database.pool_timeout = None 2025-10-05 08:20:37,670 [2] DEBUG gnocchi.service: database.retry_interval = 10 2025-10-05 08:20:37,670 [2] DEBUG gnocchi.service: database.slave_connection = **** 2025-10-05 08:20:37,670 [2] DEBUG gnocchi.service: database.sqlite_synchronous = True 2025-10-05 08:20:37,671 [2] DEBUG gnocchi.service: database.use_db_reconnect = False 2025-10-05 08:20:37,671 [2] DEBUG gnocchi.service: indexer.url = **** 2025-10-05 08:20:37,671 [2] DEBUG gnocchi.service: metricd.greedy = True 2025-10-05 08:20:37,671 [2] DEBUG gnocchi.service: metricd.metric_cleanup_delay = 300 2025-10-05 08:20:37,671 [2] DEBUG gnocchi.service: metricd.metric_processing_delay = 30 2025-10-05 08:20:37,671 [2] DEBUG gnocchi.service: metricd.metric_reporting_delay = 120 2025-10-05 08:20:37,671 [2] DEBUG gnocchi.service: metricd.processing_replicas = 3 2025-10-05 08:20:37,671 [2] DEBUG gnocchi.service: metricd.workers = 1 2025-10-05 08:20:37,671 [2] DEBUG gnocchi.service: api.auth_mode = keystone 2025-10-05 08:20:37,672 [2] WARNING oslo_config.cfg: Deprecated: Option "enable_proxy_headers_parsing" from group "oslo_middleware" is deprecated. Use option "enable_proxy_headers_parsing" from group "api". 2025-10-05 08:20:37,672 [2] DEBUG gnocchi.service: api.enable_proxy_headers_parsing = True 2025-10-05 08:20:37,672 [2] DEBUG gnocchi.service: api.host = 0.0.0.0 2025-10-05 08:20:37,672 [2] DEBUG gnocchi.service: api.max_limit = 1000 2025-10-05 08:20:37,673 [2] DEBUG gnocchi.service: api.operation_timeout = 10 2025-10-05 08:20:37,673 [2] DEBUG gnocchi.service: api.paste_config = api-paste.ini 2025-10-05 08:20:37,673 [2] DEBUG gnocchi.service: api.port = 8041 2025-10-05 08:20:37,673 [2] DEBUG gnocchi.service: api.uwsgi_mode = http 2025-10-05 08:20:37,673 [2] DEBUG gnocchi.service: storage.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:37,673 [2] DEBUG gnocchi.service: storage.ceph_keyring = None 2025-10-05 08:20:37,673 [2] DEBUG gnocchi.service: storage.ceph_pool = gnocchi 2025-10-05 08:20:37,673 [2] DEBUG gnocchi.service: storage.ceph_secret = **** 2025-10-05 08:20:37,673 [2] DEBUG gnocchi.service: storage.ceph_timeout = 30 2025-10-05 08:20:37,673 [2] DEBUG gnocchi.service: storage.ceph_username = None 2025-10-05 08:20:37,674 [2] DEBUG gnocchi.service: storage.driver = swift 2025-10-05 08:20:37,674 [2] DEBUG gnocchi.service: storage.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:37,674 [2] DEBUG gnocchi.service: storage.file_subdir_len = 2 2025-10-05 08:20:37,674 [2] DEBUG gnocchi.service: storage.redis_url = **** 2025-10-05 08:20:37,674 [2] DEBUG gnocchi.service: storage.s3_access_key_id = None 2025-10-05 08:20:37,674 [2] DEBUG gnocchi.service: storage.s3_bucket_prefix = gnocchi 2025-10-05 08:20:37,674 [2] DEBUG gnocchi.service: storage.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:37,674 [2] DEBUG gnocchi.service: storage.s3_endpoint_url = None 2025-10-05 08:20:37,674 [2] DEBUG gnocchi.service: storage.s3_max_pool_connections = 50 2025-10-05 08:20:37,674 [2] DEBUG gnocchi.service: storage.s3_region_name = None 2025-10-05 08:20:37,674 [2] DEBUG gnocchi.service: storage.s3_secret_access_key = None 2025-10-05 08:20:37,675 [2] DEBUG gnocchi.service: storage.swift_auth_insecure = False 2025-10-05 08:20:37,675 [2] DEBUG gnocchi.service: storage.swift_auth_version = 3 2025-10-05 08:20:37,675 [2] DEBUG gnocchi.service: storage.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:37,675 [2] DEBUG gnocchi.service: storage.swift_cacert = None 2025-10-05 08:20:37,675 [2] DEBUG gnocchi.service: storage.swift_container_prefix = gnocchi 2025-10-05 08:20:37,675 [2] DEBUG gnocchi.service: storage.swift_endpoint_type = internalURL 2025-10-05 08:20:37,675 [2] DEBUG gnocchi.service: storage.swift_key = **** 2025-10-05 08:20:37,675 [2] DEBUG gnocchi.service: storage.swift_preauthtoken = **** 2025-10-05 08:20:37,675 [2] DEBUG gnocchi.service: storage.swift_project_domain_name = Default 2025-10-05 08:20:37,675 [2] DEBUG gnocchi.service: storage.swift_project_name = None 2025-10-05 08:20:37,676 [2] DEBUG gnocchi.service: storage.swift_region = None 2025-10-05 08:20:37,676 [2] DEBUG gnocchi.service: storage.swift_service_type = object-store 2025-10-05 08:20:37,676 [2] DEBUG gnocchi.service: storage.swift_timeout = 300 2025-10-05 08:20:37,676 [2] DEBUG gnocchi.service: storage.swift_url = None 2025-10-05 08:20:37,676 [2] DEBUG gnocchi.service: storage.swift_user = service:gnocchi 2025-10-05 08:20:37,676 [2] DEBUG gnocchi.service: storage.swift_user_domain_name = Default 2025-10-05 08:20:37,676 [2] DEBUG gnocchi.service: incoming.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:37,676 [2] DEBUG gnocchi.service: incoming.ceph_keyring = 2025-10-05 08:20:37,677 [2] DEBUG gnocchi.service: incoming.ceph_pool = gnocchi 2025-10-05 08:20:37,677 [2] DEBUG gnocchi.service: incoming.ceph_secret = **** 2025-10-05 08:20:37,677 [2] DEBUG gnocchi.service: incoming.ceph_timeout = 30 2025-10-05 08:20:37,677 [2] DEBUG gnocchi.service: incoming.ceph_username = 2025-10-05 08:20:37,677 [2] DEBUG gnocchi.service: incoming.driver = redis 2025-10-05 08:20:37,677 [2] DEBUG gnocchi.service: incoming.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:37,678 [2] DEBUG gnocchi.service: incoming.file_subdir_len = 2 2025-10-05 08:20:37,678 [2] DEBUG gnocchi.service: incoming.redis_url = **** 2025-10-05 08:20:37,678 [2] DEBUG gnocchi.service: incoming.s3_access_key_id = 2025-10-05 08:20:37,678 [2] DEBUG gnocchi.service: incoming.s3_bucket_prefix = gnocchi 2025-10-05 08:20:37,678 [2] DEBUG gnocchi.service: incoming.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:37,678 [2] DEBUG gnocchi.service: incoming.s3_endpoint_url = 2025-10-05 08:20:37,678 [2] DEBUG gnocchi.service: incoming.s3_max_pool_connections = 50 2025-10-05 08:20:37,679 [2] DEBUG gnocchi.service: incoming.s3_region_name = 2025-10-05 08:20:37,679 [2] DEBUG gnocchi.service: incoming.s3_secret_access_key = 2025-10-05 08:20:37,679 [2] DEBUG gnocchi.service: incoming.swift_auth_insecure = False 2025-10-05 08:20:37,679 [2] DEBUG gnocchi.service: incoming.swift_auth_version = 3 2025-10-05 08:20:37,679 [2] DEBUG gnocchi.service: incoming.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:37,679 [2] DEBUG gnocchi.service: incoming.swift_cacert = 2025-10-05 08:20:37,680 [2] DEBUG gnocchi.service: incoming.swift_container_prefix = gnocchi 2025-10-05 08:20:37,680 [2] DEBUG gnocchi.service: incoming.swift_endpoint_type = internalURL 2025-10-05 08:20:37,680 [2] DEBUG gnocchi.service: incoming.swift_key = **** 2025-10-05 08:20:37,680 [2] DEBUG gnocchi.service: incoming.swift_preauthtoken = **** 2025-10-05 08:20:37,680 [2] DEBUG gnocchi.service: incoming.swift_project_domain_name = Default 2025-10-05 08:20:37,680 [2] DEBUG gnocchi.service: incoming.swift_project_name = 2025-10-05 08:20:37,681 [2] DEBUG gnocchi.service: incoming.swift_region = 2025-10-05 08:20:37,681 [2] DEBUG gnocchi.service: incoming.swift_service_type = object-store 2025-10-05 08:20:37,681 [2] DEBUG gnocchi.service: incoming.swift_timeout = 300 2025-10-05 08:20:37,681 [2] DEBUG gnocchi.service: incoming.swift_url = 2025-10-05 08:20:37,681 [2] DEBUG gnocchi.service: incoming.swift_user = service:gnocchi 2025-10-05 08:20:37,682 [2] DEBUG gnocchi.service: incoming.swift_user_domain_name = Default 2025-10-05 08:20:37,682 [2] DEBUG gnocchi.service: statsd.archive_policy_name = low 2025-10-05 08:20:37,682 [2] DEBUG gnocchi.service: statsd.creator = None 2025-10-05 08:20:37,682 [2] DEBUG gnocchi.service: statsd.flush_delay = 10.0 2025-10-05 08:20:37,682 [2] DEBUG gnocchi.service: statsd.host = 0.0.0.0 2025-10-05 08:20:37,682 [2] DEBUG gnocchi.service: statsd.port = 8125 2025-10-05 08:20:37,682 [2] DEBUG gnocchi.service: statsd.resource_id = 0a8b55df-f90f-491c-8cb9-7cdecec6fc26 2025-10-05 08:20:37,682 [2] DEBUG gnocchi.service: amqp1d.creator = None 2025-10-05 08:20:37,683 [2] DEBUG gnocchi.service: amqp1d.data_source = collectd 2025-10-05 08:20:37,683 [2] DEBUG gnocchi.service: amqp1d.flush_delay = 10.0 2025-10-05 08:20:37,683 [2] DEBUG gnocchi.service: amqp1d.resource_type = collectd_amqp1d 2025-10-05 08:20:37,683 [2] DEBUG gnocchi.service: amqp1d.url = localhost:5672/u/collectd/telemetry 2025-10-05 08:20:37,683 [2] DEBUG gnocchi.service: archive_policy.default_aggregation_methods = ['mean', 'min', 'max', 'sum', 'std', 'count'] 2025-10-05 08:20:37,683 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:37,941 [2] CRITICAL root: Traceback (most recent call last): File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.ProgrammingError: (1146, "Table 'gnocchi.resource_type' doesn't exist") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/bin/gnocchi-statsd", line 33, in sys.exit(load_entry_point('gnocchi==4.4.6.dev2+gff96e73d', 'console_scripts', 'gnocchi-statsd')()) File "/usr/lib/python3.9/site-packages/gnocchi/cli/statsd.py", line 20, in statsd statsd_service.start() File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 174, in start stats = Stats(conf) File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 41, in __init__ self.indexer.create_resource('generic', File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 154, in wrapper ectxt.value = e.inner_exc File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 227, in __exit__ self.force_reraise() File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 200, in force_reraise raise self.value File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 142, in wrapper return f(*args, **kwargs) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 811, in create_resource resource_cls = self._resource_type_to_mappers( File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 587, in _resource_type_to_mappers resource_type = self._get_resource_type(session, name) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 482, in _get_resource_type resource_type = session.query(ResourceType).get(name) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1018, in get return self._get_impl(ident, loading.load_on_pk_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1135, in _get_impl return db_load_fn(self, primary_key_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/loading.py", line 286, in load_on_pk_identity return q.one() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3490, in one ret = self.one_or_none() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none ret = list(self) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__ return self._execute_and_instances(context) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute return meth(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement ret = self._execute_context( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context self._handle_dbapi_exception( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1508, in _handle_dbapi_exception util.raise_(newraise, with_traceback=exc_info[2], from_=e) File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_ raise exception File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'gnocchi.resource_type' doesn't exist") [SQL: SELECT resource_type.name AS resource_type_name, resource_type.tablename AS resource_type_tablename, resource_type.attributes AS resource_type_attributes, resource_type.state AS resource_type_state, resource_type.updated_at AS resource_type_updated_at FROM resource_type WHERE resource_type.name = %(param_1)s] [parameters: {'param_1': 'generic'}] (Background on this error at: http://sqlalche.me/e/13/f405) 2025-10-05 08:20:39,579 [2] INFO gnocchi.service: Gnocchi version 4.4.6.dev2+gff96e73d 2025-10-05 08:20:39,579 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:39,579 [2] DEBUG gnocchi.service: Configuration options gathered from: 2025-10-05 08:20:39,579 [2] DEBUG gnocchi.service: command line args: [] 2025-10-05 08:20:39,579 [2] DEBUG gnocchi.service: config files: ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:39,579 [2] DEBUG gnocchi.service: ================================================================================ 2025-10-05 08:20:39,579 [2] DEBUG gnocchi.service: config_dir = [] 2025-10-05 08:20:39,580 [2] DEBUG gnocchi.service: config_file = ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:39,580 [2] DEBUG gnocchi.service: config_source = [] 2025-10-05 08:20:39,580 [2] DEBUG gnocchi.service: coordination_url = **** 2025-10-05 08:20:39,580 [2] DEBUG gnocchi.service: debug = True 2025-10-05 08:20:39,580 [2] DEBUG gnocchi.service: log_dir = /var/log/gnocchi 2025-10-05 08:20:39,580 [2] DEBUG gnocchi.service: log_file = None 2025-10-05 08:20:39,580 [2] DEBUG gnocchi.service: parallel_operations = 8 2025-10-05 08:20:39,580 [2] DEBUG gnocchi.service: syslog_log_facility = user 2025-10-05 08:20:39,580 [2] DEBUG gnocchi.service: use_journal = False 2025-10-05 08:20:39,580 [2] DEBUG gnocchi.service: use_syslog = False 2025-10-05 08:20:39,580 [2] DEBUG gnocchi.service: verbose = True 2025-10-05 08:20:39,580 [2] DEBUG gnocchi.service: database.backend = sqlalchemy 2025-10-05 08:20:39,580 [2] DEBUG gnocchi.service: database.connection = **** 2025-10-05 08:20:39,580 [2] DEBUG gnocchi.service: database.connection_debug = 0 2025-10-05 08:20:39,581 [2] DEBUG gnocchi.service: database.connection_parameters = 2025-10-05 08:20:39,581 [2] DEBUG gnocchi.service: database.connection_recycle_time = 3600 2025-10-05 08:20:39,581 [2] DEBUG gnocchi.service: database.connection_trace = False 2025-10-05 08:20:39,581 [2] DEBUG gnocchi.service: database.db_inc_retry_interval = True 2025-10-05 08:20:39,581 [2] DEBUG gnocchi.service: database.db_max_retries = 20 2025-10-05 08:20:39,581 [2] DEBUG gnocchi.service: database.db_max_retry_interval = 10 2025-10-05 08:20:39,581 [2] DEBUG gnocchi.service: database.db_retry_interval = 1 2025-10-05 08:20:39,581 [2] DEBUG gnocchi.service: database.max_overflow = 50 2025-10-05 08:20:39,581 [2] DEBUG gnocchi.service: database.max_pool_size = 5 2025-10-05 08:20:39,581 [2] DEBUG gnocchi.service: database.max_retries = 10 2025-10-05 08:20:39,581 [2] DEBUG gnocchi.service: database.mysql_enable_ndb = False 2025-10-05 08:20:39,581 [2] DEBUG gnocchi.service: database.mysql_sql_mode = TRADITIONAL 2025-10-05 08:20:39,581 [2] DEBUG gnocchi.service: database.pool_timeout = None 2025-10-05 08:20:39,582 [2] DEBUG gnocchi.service: database.retry_interval = 10 2025-10-05 08:20:39,582 [2] DEBUG gnocchi.service: database.slave_connection = **** 2025-10-05 08:20:39,582 [2] DEBUG gnocchi.service: database.sqlite_synchronous = True 2025-10-05 08:20:39,582 [2] DEBUG gnocchi.service: database.use_db_reconnect = False 2025-10-05 08:20:39,582 [2] DEBUG gnocchi.service: indexer.url = **** 2025-10-05 08:20:39,582 [2] DEBUG gnocchi.service: metricd.greedy = True 2025-10-05 08:20:39,582 [2] DEBUG gnocchi.service: metricd.metric_cleanup_delay = 300 2025-10-05 08:20:39,582 [2] DEBUG gnocchi.service: metricd.metric_processing_delay = 30 2025-10-05 08:20:39,582 [2] DEBUG gnocchi.service: metricd.metric_reporting_delay = 120 2025-10-05 08:20:39,582 [2] DEBUG gnocchi.service: metricd.processing_replicas = 3 2025-10-05 08:20:39,582 [2] DEBUG gnocchi.service: metricd.workers = 1 2025-10-05 08:20:39,582 [2] DEBUG gnocchi.service: api.auth_mode = keystone 2025-10-05 08:20:39,583 [2] WARNING oslo_config.cfg: Deprecated: Option "enable_proxy_headers_parsing" from group "oslo_middleware" is deprecated. Use option "enable_proxy_headers_parsing" from group "api". 2025-10-05 08:20:39,583 [2] DEBUG gnocchi.service: api.enable_proxy_headers_parsing = True 2025-10-05 08:20:39,583 [2] DEBUG gnocchi.service: api.host = 0.0.0.0 2025-10-05 08:20:39,583 [2] DEBUG gnocchi.service: api.max_limit = 1000 2025-10-05 08:20:39,583 [2] DEBUG gnocchi.service: api.operation_timeout = 10 2025-10-05 08:20:39,583 [2] DEBUG gnocchi.service: api.paste_config = api-paste.ini 2025-10-05 08:20:39,583 [2] DEBUG gnocchi.service: api.port = 8041 2025-10-05 08:20:39,583 [2] DEBUG gnocchi.service: api.uwsgi_mode = http 2025-10-05 08:20:39,583 [2] DEBUG gnocchi.service: storage.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:39,583 [2] DEBUG gnocchi.service: storage.ceph_keyring = None 2025-10-05 08:20:39,584 [2] DEBUG gnocchi.service: storage.ceph_pool = gnocchi 2025-10-05 08:20:39,584 [2] DEBUG gnocchi.service: storage.ceph_secret = **** 2025-10-05 08:20:39,584 [2] DEBUG gnocchi.service: storage.ceph_timeout = 30 2025-10-05 08:20:39,584 [2] DEBUG gnocchi.service: storage.ceph_username = None 2025-10-05 08:20:39,584 [2] DEBUG gnocchi.service: storage.driver = swift 2025-10-05 08:20:39,584 [2] DEBUG gnocchi.service: storage.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:39,584 [2] DEBUG gnocchi.service: storage.file_subdir_len = 2 2025-10-05 08:20:39,584 [2] DEBUG gnocchi.service: storage.redis_url = **** 2025-10-05 08:20:39,584 [2] DEBUG gnocchi.service: storage.s3_access_key_id = None 2025-10-05 08:20:39,584 [2] DEBUG gnocchi.service: storage.s3_bucket_prefix = gnocchi 2025-10-05 08:20:39,584 [2] DEBUG gnocchi.service: storage.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:39,584 [2] DEBUG gnocchi.service: storage.s3_endpoint_url = None 2025-10-05 08:20:39,584 [2] DEBUG gnocchi.service: storage.s3_max_pool_connections = 50 2025-10-05 08:20:39,584 [2] DEBUG gnocchi.service: storage.s3_region_name = None 2025-10-05 08:20:39,584 [2] DEBUG gnocchi.service: storage.s3_secret_access_key = None 2025-10-05 08:20:39,585 [2] DEBUG gnocchi.service: storage.swift_auth_insecure = False 2025-10-05 08:20:39,585 [2] DEBUG gnocchi.service: storage.swift_auth_version = 3 2025-10-05 08:20:39,585 [2] DEBUG gnocchi.service: storage.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:39,585 [2] DEBUG gnocchi.service: storage.swift_cacert = None 2025-10-05 08:20:39,585 [2] DEBUG gnocchi.service: storage.swift_container_prefix = gnocchi 2025-10-05 08:20:39,585 [2] DEBUG gnocchi.service: storage.swift_endpoint_type = internalURL 2025-10-05 08:20:39,585 [2] DEBUG gnocchi.service: storage.swift_key = **** 2025-10-05 08:20:39,585 [2] DEBUG gnocchi.service: storage.swift_preauthtoken = **** 2025-10-05 08:20:39,585 [2] DEBUG gnocchi.service: storage.swift_project_domain_name = Default 2025-10-05 08:20:39,585 [2] DEBUG gnocchi.service: storage.swift_project_name = None 2025-10-05 08:20:39,585 [2] DEBUG gnocchi.service: storage.swift_region = None 2025-10-05 08:20:39,585 [2] DEBUG gnocchi.service: storage.swift_service_type = object-store 2025-10-05 08:20:39,585 [2] DEBUG gnocchi.service: storage.swift_timeout = 300 2025-10-05 08:20:39,585 [2] DEBUG gnocchi.service: storage.swift_url = None 2025-10-05 08:20:39,585 [2] DEBUG gnocchi.service: storage.swift_user = service:gnocchi 2025-10-05 08:20:39,586 [2] DEBUG gnocchi.service: storage.swift_user_domain_name = Default 2025-10-05 08:20:39,586 [2] DEBUG gnocchi.service: incoming.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:39,586 [2] DEBUG gnocchi.service: incoming.ceph_keyring = 2025-10-05 08:20:39,586 [2] DEBUG gnocchi.service: incoming.ceph_pool = gnocchi 2025-10-05 08:20:39,586 [2] DEBUG gnocchi.service: incoming.ceph_secret = **** 2025-10-05 08:20:39,586 [2] DEBUG gnocchi.service: incoming.ceph_timeout = 30 2025-10-05 08:20:39,586 [2] DEBUG gnocchi.service: incoming.ceph_username = 2025-10-05 08:20:39,586 [2] DEBUG gnocchi.service: incoming.driver = redis 2025-10-05 08:20:39,586 [2] DEBUG gnocchi.service: incoming.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:39,587 [2] DEBUG gnocchi.service: incoming.file_subdir_len = 2 2025-10-05 08:20:39,587 [2] DEBUG gnocchi.service: incoming.redis_url = **** 2025-10-05 08:20:39,587 [2] DEBUG gnocchi.service: incoming.s3_access_key_id = 2025-10-05 08:20:39,587 [2] DEBUG gnocchi.service: incoming.s3_bucket_prefix = gnocchi 2025-10-05 08:20:39,587 [2] DEBUG gnocchi.service: incoming.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:39,587 [2] DEBUG gnocchi.service: incoming.s3_endpoint_url = 2025-10-05 08:20:39,587 [2] DEBUG gnocchi.service: incoming.s3_max_pool_connections = 50 2025-10-05 08:20:39,587 [2] DEBUG gnocchi.service: incoming.s3_region_name = 2025-10-05 08:20:39,587 [2] DEBUG gnocchi.service: incoming.s3_secret_access_key = 2025-10-05 08:20:39,588 [2] DEBUG gnocchi.service: incoming.swift_auth_insecure = False 2025-10-05 08:20:39,588 [2] DEBUG gnocchi.service: incoming.swift_auth_version = 3 2025-10-05 08:20:39,588 [2] DEBUG gnocchi.service: incoming.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:39,588 [2] DEBUG gnocchi.service: incoming.swift_cacert = 2025-10-05 08:20:39,588 [2] DEBUG gnocchi.service: incoming.swift_container_prefix = gnocchi 2025-10-05 08:20:39,588 [2] DEBUG gnocchi.service: incoming.swift_endpoint_type = internalURL 2025-10-05 08:20:39,588 [2] DEBUG gnocchi.service: incoming.swift_key = **** 2025-10-05 08:20:39,588 [2] DEBUG gnocchi.service: incoming.swift_preauthtoken = **** 2025-10-05 08:20:39,588 [2] DEBUG gnocchi.service: incoming.swift_project_domain_name = Default 2025-10-05 08:20:39,589 [2] DEBUG gnocchi.service: incoming.swift_project_name = 2025-10-05 08:20:39,589 [2] DEBUG gnocchi.service: incoming.swift_region = 2025-10-05 08:20:39,589 [2] DEBUG gnocchi.service: incoming.swift_service_type = object-store 2025-10-05 08:20:39,589 [2] DEBUG gnocchi.service: incoming.swift_timeout = 300 2025-10-05 08:20:39,589 [2] DEBUG gnocchi.service: incoming.swift_url = 2025-10-05 08:20:39,589 [2] DEBUG gnocchi.service: incoming.swift_user = service:gnocchi 2025-10-05 08:20:39,589 [2] DEBUG gnocchi.service: incoming.swift_user_domain_name = Default 2025-10-05 08:20:39,589 [2] DEBUG gnocchi.service: statsd.archive_policy_name = low 2025-10-05 08:20:39,589 [2] DEBUG gnocchi.service: statsd.creator = None 2025-10-05 08:20:39,590 [2] DEBUG gnocchi.service: statsd.flush_delay = 10.0 2025-10-05 08:20:39,590 [2] DEBUG gnocchi.service: statsd.host = 0.0.0.0 2025-10-05 08:20:39,590 [2] DEBUG gnocchi.service: statsd.port = 8125 2025-10-05 08:20:39,590 [2] DEBUG gnocchi.service: statsd.resource_id = 0a8b55df-f90f-491c-8cb9-7cdecec6fc26 2025-10-05 08:20:39,590 [2] DEBUG gnocchi.service: amqp1d.creator = None 2025-10-05 08:20:39,590 [2] DEBUG gnocchi.service: amqp1d.data_source = collectd 2025-10-05 08:20:39,590 [2] DEBUG gnocchi.service: amqp1d.flush_delay = 10.0 2025-10-05 08:20:39,590 [2] DEBUG gnocchi.service: amqp1d.resource_type = collectd_amqp1d 2025-10-05 08:20:39,590 [2] DEBUG gnocchi.service: amqp1d.url = localhost:5672/u/collectd/telemetry 2025-10-05 08:20:39,590 [2] DEBUG gnocchi.service: archive_policy.default_aggregation_methods = ['mean', 'min', 'max', 'sum', 'std', 'count'] 2025-10-05 08:20:39,590 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:39,843 [2] CRITICAL root: Traceback (most recent call last): File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.ProgrammingError: (1146, "Table 'gnocchi.resource_type' doesn't exist") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/bin/gnocchi-statsd", line 33, in sys.exit(load_entry_point('gnocchi==4.4.6.dev2+gff96e73d', 'console_scripts', 'gnocchi-statsd')()) File "/usr/lib/python3.9/site-packages/gnocchi/cli/statsd.py", line 20, in statsd statsd_service.start() File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 174, in start stats = Stats(conf) File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 41, in __init__ self.indexer.create_resource('generic', File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 154, in wrapper ectxt.value = e.inner_exc File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 227, in __exit__ self.force_reraise() File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 200, in force_reraise raise self.value File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 142, in wrapper return f(*args, **kwargs) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 811, in create_resource resource_cls = self._resource_type_to_mappers( File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 587, in _resource_type_to_mappers resource_type = self._get_resource_type(session, name) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 482, in _get_resource_type resource_type = session.query(ResourceType).get(name) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1018, in get return self._get_impl(ident, loading.load_on_pk_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1135, in _get_impl return db_load_fn(self, primary_key_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/loading.py", line 286, in load_on_pk_identity return q.one() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3490, in one ret = self.one_or_none() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none ret = list(self) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__ return self._execute_and_instances(context) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute return meth(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement ret = self._execute_context( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context self._handle_dbapi_exception( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1508, in _handle_dbapi_exception util.raise_(newraise, with_traceback=exc_info[2], from_=e) File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_ raise exception File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'gnocchi.resource_type' doesn't exist") [SQL: SELECT resource_type.name AS resource_type_name, resource_type.tablename AS resource_type_tablename, resource_type.attributes AS resource_type_attributes, resource_type.state AS resource_type_state, resource_type.updated_at AS resource_type_updated_at FROM resource_type WHERE resource_type.name = %(param_1)s] [parameters: {'param_1': 'generic'}] (Background on this error at: http://sqlalche.me/e/13/f405) 2025-10-05 08:20:41,427 [2] INFO gnocchi.service: Gnocchi version 4.4.6.dev2+gff96e73d 2025-10-05 08:20:41,427 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:41,427 [2] DEBUG gnocchi.service: Configuration options gathered from: 2025-10-05 08:20:41,427 [2] DEBUG gnocchi.service: command line args: [] 2025-10-05 08:20:41,427 [2] DEBUG gnocchi.service: config files: ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:41,427 [2] DEBUG gnocchi.service: ================================================================================ 2025-10-05 08:20:41,427 [2] DEBUG gnocchi.service: config_dir = [] 2025-10-05 08:20:41,427 [2] DEBUG gnocchi.service: config_file = ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:41,427 [2] DEBUG gnocchi.service: config_source = [] 2025-10-05 08:20:41,427 [2] DEBUG gnocchi.service: coordination_url = **** 2025-10-05 08:20:41,427 [2] DEBUG gnocchi.service: debug = True 2025-10-05 08:20:41,427 [2] DEBUG gnocchi.service: log_dir = /var/log/gnocchi 2025-10-05 08:20:41,427 [2] DEBUG gnocchi.service: log_file = None 2025-10-05 08:20:41,427 [2] DEBUG gnocchi.service: parallel_operations = 8 2025-10-05 08:20:41,427 [2] DEBUG gnocchi.service: syslog_log_facility = user 2025-10-05 08:20:41,428 [2] DEBUG gnocchi.service: use_journal = False 2025-10-05 08:20:41,428 [2] DEBUG gnocchi.service: use_syslog = False 2025-10-05 08:20:41,428 [2] DEBUG gnocchi.service: verbose = True 2025-10-05 08:20:41,428 [2] DEBUG gnocchi.service: database.backend = sqlalchemy 2025-10-05 08:20:41,428 [2] DEBUG gnocchi.service: database.connection = **** 2025-10-05 08:20:41,428 [2] DEBUG gnocchi.service: database.connection_debug = 0 2025-10-05 08:20:41,428 [2] DEBUG gnocchi.service: database.connection_parameters = 2025-10-05 08:20:41,428 [2] DEBUG gnocchi.service: database.connection_recycle_time = 3600 2025-10-05 08:20:41,428 [2] DEBUG gnocchi.service: database.connection_trace = False 2025-10-05 08:20:41,428 [2] DEBUG gnocchi.service: database.db_inc_retry_interval = True 2025-10-05 08:20:41,428 [2] DEBUG gnocchi.service: database.db_max_retries = 20 2025-10-05 08:20:41,428 [2] DEBUG gnocchi.service: database.db_max_retry_interval = 10 2025-10-05 08:20:41,428 [2] DEBUG gnocchi.service: database.db_retry_interval = 1 2025-10-05 08:20:41,428 [2] DEBUG gnocchi.service: database.max_overflow = 50 2025-10-05 08:20:41,429 [2] DEBUG gnocchi.service: database.max_pool_size = 5 2025-10-05 08:20:41,429 [2] DEBUG gnocchi.service: database.max_retries = 10 2025-10-05 08:20:41,429 [2] DEBUG gnocchi.service: database.mysql_enable_ndb = False 2025-10-05 08:20:41,429 [2] DEBUG gnocchi.service: database.mysql_sql_mode = TRADITIONAL 2025-10-05 08:20:41,429 [2] DEBUG gnocchi.service: database.pool_timeout = None 2025-10-05 08:20:41,429 [2] DEBUG gnocchi.service: database.retry_interval = 10 2025-10-05 08:20:41,429 [2] DEBUG gnocchi.service: database.slave_connection = **** 2025-10-05 08:20:41,429 [2] DEBUG gnocchi.service: database.sqlite_synchronous = True 2025-10-05 08:20:41,429 [2] DEBUG gnocchi.service: database.use_db_reconnect = False 2025-10-05 08:20:41,429 [2] DEBUG gnocchi.service: indexer.url = **** 2025-10-05 08:20:41,429 [2] DEBUG gnocchi.service: metricd.greedy = True 2025-10-05 08:20:41,429 [2] DEBUG gnocchi.service: metricd.metric_cleanup_delay = 300 2025-10-05 08:20:41,429 [2] DEBUG gnocchi.service: metricd.metric_processing_delay = 30 2025-10-05 08:20:41,429 [2] DEBUG gnocchi.service: metricd.metric_reporting_delay = 120 2025-10-05 08:20:41,429 [2] DEBUG gnocchi.service: metricd.processing_replicas = 3 2025-10-05 08:20:41,429 [2] DEBUG gnocchi.service: metricd.workers = 1 2025-10-05 08:20:41,430 [2] DEBUG gnocchi.service: api.auth_mode = keystone 2025-10-05 08:20:41,430 [2] WARNING oslo_config.cfg: Deprecated: Option "enable_proxy_headers_parsing" from group "oslo_middleware" is deprecated. Use option "enable_proxy_headers_parsing" from group "api". 2025-10-05 08:20:41,430 [2] DEBUG gnocchi.service: api.enable_proxy_headers_parsing = True 2025-10-05 08:20:41,430 [2] DEBUG gnocchi.service: api.host = 0.0.0.0 2025-10-05 08:20:41,431 [2] DEBUG gnocchi.service: api.max_limit = 1000 2025-10-05 08:20:41,431 [2] DEBUG gnocchi.service: api.operation_timeout = 10 2025-10-05 08:20:41,431 [2] DEBUG gnocchi.service: api.paste_config = api-paste.ini 2025-10-05 08:20:41,431 [2] DEBUG gnocchi.service: api.port = 8041 2025-10-05 08:20:41,431 [2] DEBUG gnocchi.service: api.uwsgi_mode = http 2025-10-05 08:20:41,431 [2] DEBUG gnocchi.service: storage.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:41,431 [2] DEBUG gnocchi.service: storage.ceph_keyring = None 2025-10-05 08:20:41,431 [2] DEBUG gnocchi.service: storage.ceph_pool = gnocchi 2025-10-05 08:20:41,431 [2] DEBUG gnocchi.service: storage.ceph_secret = **** 2025-10-05 08:20:41,431 [2] DEBUG gnocchi.service: storage.ceph_timeout = 30 2025-10-05 08:20:41,431 [2] DEBUG gnocchi.service: storage.ceph_username = None 2025-10-05 08:20:41,431 [2] DEBUG gnocchi.service: storage.driver = swift 2025-10-05 08:20:41,431 [2] DEBUG gnocchi.service: storage.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:41,431 [2] DEBUG gnocchi.service: storage.file_subdir_len = 2 2025-10-05 08:20:41,432 [2] DEBUG gnocchi.service: storage.redis_url = **** 2025-10-05 08:20:41,432 [2] DEBUG gnocchi.service: storage.s3_access_key_id = None 2025-10-05 08:20:41,432 [2] DEBUG gnocchi.service: storage.s3_bucket_prefix = gnocchi 2025-10-05 08:20:41,432 [2] DEBUG gnocchi.service: storage.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:41,432 [2] DEBUG gnocchi.service: storage.s3_endpoint_url = None 2025-10-05 08:20:41,432 [2] DEBUG gnocchi.service: storage.s3_max_pool_connections = 50 2025-10-05 08:20:41,432 [2] DEBUG gnocchi.service: storage.s3_region_name = None 2025-10-05 08:20:41,432 [2] DEBUG gnocchi.service: storage.s3_secret_access_key = None 2025-10-05 08:20:41,432 [2] DEBUG gnocchi.service: storage.swift_auth_insecure = False 2025-10-05 08:20:41,432 [2] DEBUG gnocchi.service: storage.swift_auth_version = 3 2025-10-05 08:20:41,432 [2] DEBUG gnocchi.service: storage.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:41,432 [2] DEBUG gnocchi.service: storage.swift_cacert = None 2025-10-05 08:20:41,432 [2] DEBUG gnocchi.service: storage.swift_container_prefix = gnocchi 2025-10-05 08:20:41,432 [2] DEBUG gnocchi.service: storage.swift_endpoint_type = internalURL 2025-10-05 08:20:41,433 [2] DEBUG gnocchi.service: storage.swift_key = **** 2025-10-05 08:20:41,433 [2] DEBUG gnocchi.service: storage.swift_preauthtoken = **** 2025-10-05 08:20:41,433 [2] DEBUG gnocchi.service: storage.swift_project_domain_name = Default 2025-10-05 08:20:41,433 [2] DEBUG gnocchi.service: storage.swift_project_name = None 2025-10-05 08:20:41,433 [2] DEBUG gnocchi.service: storage.swift_region = None 2025-10-05 08:20:41,433 [2] DEBUG gnocchi.service: storage.swift_service_type = object-store 2025-10-05 08:20:41,433 [2] DEBUG gnocchi.service: storage.swift_timeout = 300 2025-10-05 08:20:41,433 [2] DEBUG gnocchi.service: storage.swift_url = None 2025-10-05 08:20:41,433 [2] DEBUG gnocchi.service: storage.swift_user = service:gnocchi 2025-10-05 08:20:41,433 [2] DEBUG gnocchi.service: storage.swift_user_domain_name = Default 2025-10-05 08:20:41,433 [2] DEBUG gnocchi.service: incoming.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:41,433 [2] DEBUG gnocchi.service: incoming.ceph_keyring = 2025-10-05 08:20:41,434 [2] DEBUG gnocchi.service: incoming.ceph_pool = gnocchi 2025-10-05 08:20:41,434 [2] DEBUG gnocchi.service: incoming.ceph_secret = **** 2025-10-05 08:20:41,434 [2] DEBUG gnocchi.service: incoming.ceph_timeout = 30 2025-10-05 08:20:41,434 [2] DEBUG gnocchi.service: incoming.ceph_username = 2025-10-05 08:20:41,434 [2] DEBUG gnocchi.service: incoming.driver = redis 2025-10-05 08:20:41,434 [2] DEBUG gnocchi.service: incoming.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:41,434 [2] DEBUG gnocchi.service: incoming.file_subdir_len = 2 2025-10-05 08:20:41,434 [2] DEBUG gnocchi.service: incoming.redis_url = **** 2025-10-05 08:20:41,434 [2] DEBUG gnocchi.service: incoming.s3_access_key_id = 2025-10-05 08:20:41,435 [2] DEBUG gnocchi.service: incoming.s3_bucket_prefix = gnocchi 2025-10-05 08:20:41,435 [2] DEBUG gnocchi.service: incoming.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:41,435 [2] DEBUG gnocchi.service: incoming.s3_endpoint_url = 2025-10-05 08:20:41,435 [2] DEBUG gnocchi.service: incoming.s3_max_pool_connections = 50 2025-10-05 08:20:41,435 [2] DEBUG gnocchi.service: incoming.s3_region_name = 2025-10-05 08:20:41,435 [2] DEBUG gnocchi.service: incoming.s3_secret_access_key = 2025-10-05 08:20:41,435 [2] DEBUG gnocchi.service: incoming.swift_auth_insecure = False 2025-10-05 08:20:41,435 [2] DEBUG gnocchi.service: incoming.swift_auth_version = 3 2025-10-05 08:20:41,435 [2] DEBUG gnocchi.service: incoming.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:41,436 [2] DEBUG gnocchi.service: incoming.swift_cacert = 2025-10-05 08:20:41,436 [2] DEBUG gnocchi.service: incoming.swift_container_prefix = gnocchi 2025-10-05 08:20:41,436 [2] DEBUG gnocchi.service: incoming.swift_endpoint_type = internalURL 2025-10-05 08:20:41,436 [2] DEBUG gnocchi.service: incoming.swift_key = **** 2025-10-05 08:20:41,436 [2] DEBUG gnocchi.service: incoming.swift_preauthtoken = **** 2025-10-05 08:20:41,436 [2] DEBUG gnocchi.service: incoming.swift_project_domain_name = Default 2025-10-05 08:20:41,436 [2] DEBUG gnocchi.service: incoming.swift_project_name = 2025-10-05 08:20:41,436 [2] DEBUG gnocchi.service: incoming.swift_region = 2025-10-05 08:20:41,437 [2] DEBUG gnocchi.service: incoming.swift_service_type = object-store 2025-10-05 08:20:41,437 [2] DEBUG gnocchi.service: incoming.swift_timeout = 300 2025-10-05 08:20:41,437 [2] DEBUG gnocchi.service: incoming.swift_url = 2025-10-05 08:20:41,437 [2] DEBUG gnocchi.service: incoming.swift_user = service:gnocchi 2025-10-05 08:20:41,437 [2] DEBUG gnocchi.service: incoming.swift_user_domain_name = Default 2025-10-05 08:20:41,437 [2] DEBUG gnocchi.service: statsd.archive_policy_name = low 2025-10-05 08:20:41,437 [2] DEBUG gnocchi.service: statsd.creator = None 2025-10-05 08:20:41,437 [2] DEBUG gnocchi.service: statsd.flush_delay = 10.0 2025-10-05 08:20:41,437 [2] DEBUG gnocchi.service: statsd.host = 0.0.0.0 2025-10-05 08:20:41,437 [2] DEBUG gnocchi.service: statsd.port = 8125 2025-10-05 08:20:41,437 [2] DEBUG gnocchi.service: statsd.resource_id = 0a8b55df-f90f-491c-8cb9-7cdecec6fc26 2025-10-05 08:20:41,438 [2] DEBUG gnocchi.service: amqp1d.creator = None 2025-10-05 08:20:41,438 [2] DEBUG gnocchi.service: amqp1d.data_source = collectd 2025-10-05 08:20:41,438 [2] DEBUG gnocchi.service: amqp1d.flush_delay = 10.0 2025-10-05 08:20:41,438 [2] DEBUG gnocchi.service: amqp1d.resource_type = collectd_amqp1d 2025-10-05 08:20:41,438 [2] DEBUG gnocchi.service: amqp1d.url = localhost:5672/u/collectd/telemetry 2025-10-05 08:20:41,438 [2] DEBUG gnocchi.service: archive_policy.default_aggregation_methods = ['mean', 'min', 'max', 'sum', 'std', 'count'] 2025-10-05 08:20:41,438 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:41,711 [2] CRITICAL root: Traceback (most recent call last): File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.ProgrammingError: (1146, "Table 'gnocchi.resource_type' doesn't exist") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/bin/gnocchi-statsd", line 33, in sys.exit(load_entry_point('gnocchi==4.4.6.dev2+gff96e73d', 'console_scripts', 'gnocchi-statsd')()) File "/usr/lib/python3.9/site-packages/gnocchi/cli/statsd.py", line 20, in statsd statsd_service.start() File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 174, in start stats = Stats(conf) File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 41, in __init__ self.indexer.create_resource('generic', File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 154, in wrapper ectxt.value = e.inner_exc File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 227, in __exit__ self.force_reraise() File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 200, in force_reraise raise self.value File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 142, in wrapper return f(*args, **kwargs) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 811, in create_resource resource_cls = self._resource_type_to_mappers( File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 587, in _resource_type_to_mappers resource_type = self._get_resource_type(session, name) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 482, in _get_resource_type resource_type = session.query(ResourceType).get(name) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1018, in get return self._get_impl(ident, loading.load_on_pk_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1135, in _get_impl return db_load_fn(self, primary_key_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/loading.py", line 286, in load_on_pk_identity return q.one() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3490, in one ret = self.one_or_none() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none ret = list(self) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__ return self._execute_and_instances(context) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute return meth(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement ret = self._execute_context( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context self._handle_dbapi_exception( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1508, in _handle_dbapi_exception util.raise_(newraise, with_traceback=exc_info[2], from_=e) File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_ raise exception File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'gnocchi.resource_type' doesn't exist") [SQL: SELECT resource_type.name AS resource_type_name, resource_type.tablename AS resource_type_tablename, resource_type.attributes AS resource_type_attributes, resource_type.state AS resource_type_state, resource_type.updated_at AS resource_type_updated_at FROM resource_type WHERE resource_type.name = %(param_1)s] [parameters: {'param_1': 'generic'}] (Background on this error at: http://sqlalche.me/e/13/f405) 2025-10-05 08:20:43,433 [2] INFO gnocchi.service: Gnocchi version 4.4.6.dev2+gff96e73d 2025-10-05 08:20:43,434 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:43,434 [2] DEBUG gnocchi.service: Configuration options gathered from: 2025-10-05 08:20:43,434 [2] DEBUG gnocchi.service: command line args: [] 2025-10-05 08:20:43,434 [2] DEBUG gnocchi.service: config files: ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:43,434 [2] DEBUG gnocchi.service: ================================================================================ 2025-10-05 08:20:43,434 [2] DEBUG gnocchi.service: config_dir = [] 2025-10-05 08:20:43,434 [2] DEBUG gnocchi.service: config_file = ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:43,434 [2] DEBUG gnocchi.service: config_source = [] 2025-10-05 08:20:43,434 [2] DEBUG gnocchi.service: coordination_url = **** 2025-10-05 08:20:43,434 [2] DEBUG gnocchi.service: debug = True 2025-10-05 08:20:43,434 [2] DEBUG gnocchi.service: log_dir = /var/log/gnocchi 2025-10-05 08:20:43,434 [2] DEBUG gnocchi.service: log_file = None 2025-10-05 08:20:43,434 [2] DEBUG gnocchi.service: parallel_operations = 8 2025-10-05 08:20:43,434 [2] DEBUG gnocchi.service: syslog_log_facility = user 2025-10-05 08:20:43,434 [2] DEBUG gnocchi.service: use_journal = False 2025-10-05 08:20:43,434 [2] DEBUG gnocchi.service: use_syslog = False 2025-10-05 08:20:43,435 [2] DEBUG gnocchi.service: verbose = True 2025-10-05 08:20:43,435 [2] DEBUG gnocchi.service: database.backend = sqlalchemy 2025-10-05 08:20:43,435 [2] DEBUG gnocchi.service: database.connection = **** 2025-10-05 08:20:43,435 [2] DEBUG gnocchi.service: database.connection_debug = 0 2025-10-05 08:20:43,435 [2] DEBUG gnocchi.service: database.connection_parameters = 2025-10-05 08:20:43,435 [2] DEBUG gnocchi.service: database.connection_recycle_time = 3600 2025-10-05 08:20:43,435 [2] DEBUG gnocchi.service: database.connection_trace = False 2025-10-05 08:20:43,435 [2] DEBUG gnocchi.service: database.db_inc_retry_interval = True 2025-10-05 08:20:43,435 [2] DEBUG gnocchi.service: database.db_max_retries = 20 2025-10-05 08:20:43,435 [2] DEBUG gnocchi.service: database.db_max_retry_interval = 10 2025-10-05 08:20:43,435 [2] DEBUG gnocchi.service: database.db_retry_interval = 1 2025-10-05 08:20:43,435 [2] DEBUG gnocchi.service: database.max_overflow = 50 2025-10-05 08:20:43,435 [2] DEBUG gnocchi.service: database.max_pool_size = 5 2025-10-05 08:20:43,436 [2] DEBUG gnocchi.service: database.max_retries = 10 2025-10-05 08:20:43,436 [2] DEBUG gnocchi.service: database.mysql_enable_ndb = False 2025-10-05 08:20:43,436 [2] DEBUG gnocchi.service: database.mysql_sql_mode = TRADITIONAL 2025-10-05 08:20:43,436 [2] DEBUG gnocchi.service: database.pool_timeout = None 2025-10-05 08:20:43,436 [2] DEBUG gnocchi.service: database.retry_interval = 10 2025-10-05 08:20:43,436 [2] DEBUG gnocchi.service: database.slave_connection = **** 2025-10-05 08:20:43,436 [2] DEBUG gnocchi.service: database.sqlite_synchronous = True 2025-10-05 08:20:43,436 [2] DEBUG gnocchi.service: database.use_db_reconnect = False 2025-10-05 08:20:43,436 [2] DEBUG gnocchi.service: indexer.url = **** 2025-10-05 08:20:43,436 [2] DEBUG gnocchi.service: metricd.greedy = True 2025-10-05 08:20:43,436 [2] DEBUG gnocchi.service: metricd.metric_cleanup_delay = 300 2025-10-05 08:20:43,436 [2] DEBUG gnocchi.service: metricd.metric_processing_delay = 30 2025-10-05 08:20:43,436 [2] DEBUG gnocchi.service: metricd.metric_reporting_delay = 120 2025-10-05 08:20:43,436 [2] DEBUG gnocchi.service: metricd.processing_replicas = 3 2025-10-05 08:20:43,436 [2] DEBUG gnocchi.service: metricd.workers = 1 2025-10-05 08:20:43,436 [2] DEBUG gnocchi.service: api.auth_mode = keystone 2025-10-05 08:20:43,437 [2] WARNING oslo_config.cfg: Deprecated: Option "enable_proxy_headers_parsing" from group "oslo_middleware" is deprecated. Use option "enable_proxy_headers_parsing" from group "api". 2025-10-05 08:20:43,437 [2] DEBUG gnocchi.service: api.enable_proxy_headers_parsing = True 2025-10-05 08:20:43,437 [2] DEBUG gnocchi.service: api.host = 0.0.0.0 2025-10-05 08:20:43,437 [2] DEBUG gnocchi.service: api.max_limit = 1000 2025-10-05 08:20:43,438 [2] DEBUG gnocchi.service: api.operation_timeout = 10 2025-10-05 08:20:43,438 [2] DEBUG gnocchi.service: api.paste_config = api-paste.ini 2025-10-05 08:20:43,438 [2] DEBUG gnocchi.service: api.port = 8041 2025-10-05 08:20:43,438 [2] DEBUG gnocchi.service: api.uwsgi_mode = http 2025-10-05 08:20:43,438 [2] DEBUG gnocchi.service: storage.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:43,438 [2] DEBUG gnocchi.service: storage.ceph_keyring = None 2025-10-05 08:20:43,438 [2] DEBUG gnocchi.service: storage.ceph_pool = gnocchi 2025-10-05 08:20:43,438 [2] DEBUG gnocchi.service: storage.ceph_secret = **** 2025-10-05 08:20:43,438 [2] DEBUG gnocchi.service: storage.ceph_timeout = 30 2025-10-05 08:20:43,438 [2] DEBUG gnocchi.service: storage.ceph_username = None 2025-10-05 08:20:43,438 [2] DEBUG gnocchi.service: storage.driver = swift 2025-10-05 08:20:43,438 [2] DEBUG gnocchi.service: storage.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:43,438 [2] DEBUG gnocchi.service: storage.file_subdir_len = 2 2025-10-05 08:20:43,439 [2] DEBUG gnocchi.service: storage.redis_url = **** 2025-10-05 08:20:43,439 [2] DEBUG gnocchi.service: storage.s3_access_key_id = None 2025-10-05 08:20:43,439 [2] DEBUG gnocchi.service: storage.s3_bucket_prefix = gnocchi 2025-10-05 08:20:43,439 [2] DEBUG gnocchi.service: storage.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:43,439 [2] DEBUG gnocchi.service: storage.s3_endpoint_url = None 2025-10-05 08:20:43,439 [2] DEBUG gnocchi.service: storage.s3_max_pool_connections = 50 2025-10-05 08:20:43,439 [2] DEBUG gnocchi.service: storage.s3_region_name = None 2025-10-05 08:20:43,439 [2] DEBUG gnocchi.service: storage.s3_secret_access_key = None 2025-10-05 08:20:43,439 [2] DEBUG gnocchi.service: storage.swift_auth_insecure = False 2025-10-05 08:20:43,439 [2] DEBUG gnocchi.service: storage.swift_auth_version = 3 2025-10-05 08:20:43,439 [2] DEBUG gnocchi.service: storage.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:43,439 [2] DEBUG gnocchi.service: storage.swift_cacert = None 2025-10-05 08:20:43,439 [2] DEBUG gnocchi.service: storage.swift_container_prefix = gnocchi 2025-10-05 08:20:43,439 [2] DEBUG gnocchi.service: storage.swift_endpoint_type = internalURL 2025-10-05 08:20:43,440 [2] DEBUG gnocchi.service: storage.swift_key = **** 2025-10-05 08:20:43,440 [2] DEBUG gnocchi.service: storage.swift_preauthtoken = **** 2025-10-05 08:20:43,440 [2] DEBUG gnocchi.service: storage.swift_project_domain_name = Default 2025-10-05 08:20:43,440 [2] DEBUG gnocchi.service: storage.swift_project_name = None 2025-10-05 08:20:43,440 [2] DEBUG gnocchi.service: storage.swift_region = None 2025-10-05 08:20:43,440 [2] DEBUG gnocchi.service: storage.swift_service_type = object-store 2025-10-05 08:20:43,440 [2] DEBUG gnocchi.service: storage.swift_timeout = 300 2025-10-05 08:20:43,440 [2] DEBUG gnocchi.service: storage.swift_url = None 2025-10-05 08:20:43,440 [2] DEBUG gnocchi.service: storage.swift_user = service:gnocchi 2025-10-05 08:20:43,440 [2] DEBUG gnocchi.service: storage.swift_user_domain_name = Default 2025-10-05 08:20:43,440 [2] DEBUG gnocchi.service: incoming.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:43,440 [2] DEBUG gnocchi.service: incoming.ceph_keyring = 2025-10-05 08:20:43,441 [2] DEBUG gnocchi.service: incoming.ceph_pool = gnocchi 2025-10-05 08:20:43,441 [2] DEBUG gnocchi.service: incoming.ceph_secret = **** 2025-10-05 08:20:43,441 [2] DEBUG gnocchi.service: incoming.ceph_timeout = 30 2025-10-05 08:20:43,441 [2] DEBUG gnocchi.service: incoming.ceph_username = 2025-10-05 08:20:43,441 [2] DEBUG gnocchi.service: incoming.driver = redis 2025-10-05 08:20:43,441 [2] DEBUG gnocchi.service: incoming.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:43,441 [2] DEBUG gnocchi.service: incoming.file_subdir_len = 2 2025-10-05 08:20:43,441 [2] DEBUG gnocchi.service: incoming.redis_url = **** 2025-10-05 08:20:43,441 [2] DEBUG gnocchi.service: incoming.s3_access_key_id = 2025-10-05 08:20:43,442 [2] DEBUG gnocchi.service: incoming.s3_bucket_prefix = gnocchi 2025-10-05 08:20:43,442 [2] DEBUG gnocchi.service: incoming.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:43,442 [2] DEBUG gnocchi.service: incoming.s3_endpoint_url = 2025-10-05 08:20:43,442 [2] DEBUG gnocchi.service: incoming.s3_max_pool_connections = 50 2025-10-05 08:20:43,442 [2] DEBUG gnocchi.service: incoming.s3_region_name = 2025-10-05 08:20:43,442 [2] DEBUG gnocchi.service: incoming.s3_secret_access_key = 2025-10-05 08:20:43,442 [2] DEBUG gnocchi.service: incoming.swift_auth_insecure = False 2025-10-05 08:20:43,443 [2] DEBUG gnocchi.service: incoming.swift_auth_version = 3 2025-10-05 08:20:43,443 [2] DEBUG gnocchi.service: incoming.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:43,443 [2] DEBUG gnocchi.service: incoming.swift_cacert = 2025-10-05 08:20:43,443 [2] DEBUG gnocchi.service: incoming.swift_container_prefix = gnocchi 2025-10-05 08:20:43,443 [2] DEBUG gnocchi.service: incoming.swift_endpoint_type = internalURL 2025-10-05 08:20:43,443 [2] DEBUG gnocchi.service: incoming.swift_key = **** 2025-10-05 08:20:43,444 [2] DEBUG gnocchi.service: incoming.swift_preauthtoken = **** 2025-10-05 08:20:43,444 [2] DEBUG gnocchi.service: incoming.swift_project_domain_name = Default 2025-10-05 08:20:43,444 [2] DEBUG gnocchi.service: incoming.swift_project_name = 2025-10-05 08:20:43,444 [2] DEBUG gnocchi.service: incoming.swift_region = 2025-10-05 08:20:43,444 [2] DEBUG gnocchi.service: incoming.swift_service_type = object-store 2025-10-05 08:20:43,444 [2] DEBUG gnocchi.service: incoming.swift_timeout = 300 2025-10-05 08:20:43,444 [2] DEBUG gnocchi.service: incoming.swift_url = 2025-10-05 08:20:43,445 [2] DEBUG gnocchi.service: incoming.swift_user = service:gnocchi 2025-10-05 08:20:43,445 [2] DEBUG gnocchi.service: incoming.swift_user_domain_name = Default 2025-10-05 08:20:43,445 [2] DEBUG gnocchi.service: statsd.archive_policy_name = low 2025-10-05 08:20:43,445 [2] DEBUG gnocchi.service: statsd.creator = None 2025-10-05 08:20:43,445 [2] DEBUG gnocchi.service: statsd.flush_delay = 10.0 2025-10-05 08:20:43,445 [2] DEBUG gnocchi.service: statsd.host = 0.0.0.0 2025-10-05 08:20:43,445 [2] DEBUG gnocchi.service: statsd.port = 8125 2025-10-05 08:20:43,445 [2] DEBUG gnocchi.service: statsd.resource_id = 0a8b55df-f90f-491c-8cb9-7cdecec6fc26 2025-10-05 08:20:43,445 [2] DEBUG gnocchi.service: amqp1d.creator = None 2025-10-05 08:20:43,445 [2] DEBUG gnocchi.service: amqp1d.data_source = collectd 2025-10-05 08:20:43,445 [2] DEBUG gnocchi.service: amqp1d.flush_delay = 10.0 2025-10-05 08:20:43,445 [2] DEBUG gnocchi.service: amqp1d.resource_type = collectd_amqp1d 2025-10-05 08:20:43,445 [2] DEBUG gnocchi.service: amqp1d.url = localhost:5672/u/collectd/telemetry 2025-10-05 08:20:43,446 [2] DEBUG gnocchi.service: archive_policy.default_aggregation_methods = ['mean', 'min', 'max', 'sum', 'std', 'count'] 2025-10-05 08:20:43,446 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:43,718 [2] CRITICAL root: Traceback (most recent call last): File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.ProgrammingError: (1146, "Table 'gnocchi.resource_type' doesn't exist") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/bin/gnocchi-statsd", line 33, in sys.exit(load_entry_point('gnocchi==4.4.6.dev2+gff96e73d', 'console_scripts', 'gnocchi-statsd')()) File "/usr/lib/python3.9/site-packages/gnocchi/cli/statsd.py", line 20, in statsd statsd_service.start() File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 174, in start stats = Stats(conf) File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 41, in __init__ self.indexer.create_resource('generic', File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 154, in wrapper ectxt.value = e.inner_exc File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 227, in __exit__ self.force_reraise() File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 200, in force_reraise raise self.value File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 142, in wrapper return f(*args, **kwargs) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 811, in create_resource resource_cls = self._resource_type_to_mappers( File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 587, in _resource_type_to_mappers resource_type = self._get_resource_type(session, name) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 482, in _get_resource_type resource_type = session.query(ResourceType).get(name) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1018, in get return self._get_impl(ident, loading.load_on_pk_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1135, in _get_impl return db_load_fn(self, primary_key_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/loading.py", line 286, in load_on_pk_identity return q.one() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3490, in one ret = self.one_or_none() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none ret = list(self) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__ return self._execute_and_instances(context) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute return meth(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement ret = self._execute_context( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context self._handle_dbapi_exception( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1508, in _handle_dbapi_exception util.raise_(newraise, with_traceback=exc_info[2], from_=e) File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_ raise exception File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'gnocchi.resource_type' doesn't exist") [SQL: SELECT resource_type.name AS resource_type_name, resource_type.tablename AS resource_type_tablename, resource_type.attributes AS resource_type_attributes, resource_type.state AS resource_type_state, resource_type.updated_at AS resource_type_updated_at FROM resource_type WHERE resource_type.name = %(param_1)s] [parameters: {'param_1': 'generic'}] (Background on this error at: http://sqlalche.me/e/13/f405) 2025-10-05 08:20:45,448 [2] INFO gnocchi.service: Gnocchi version 4.4.6.dev2+gff96e73d 2025-10-05 08:20:45,448 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:45,448 [2] DEBUG gnocchi.service: Configuration options gathered from: 2025-10-05 08:20:45,448 [2] DEBUG gnocchi.service: command line args: [] 2025-10-05 08:20:45,449 [2] DEBUG gnocchi.service: config files: ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:45,449 [2] DEBUG gnocchi.service: ================================================================================ 2025-10-05 08:20:45,449 [2] DEBUG gnocchi.service: config_dir = [] 2025-10-05 08:20:45,449 [2] DEBUG gnocchi.service: config_file = ['/usr/share/gnocchi/gnocchi-dist.conf', '/etc/gnocchi/gnocchi.conf'] 2025-10-05 08:20:45,449 [2] DEBUG gnocchi.service: config_source = [] 2025-10-05 08:20:45,449 [2] DEBUG gnocchi.service: coordination_url = **** 2025-10-05 08:20:45,449 [2] DEBUG gnocchi.service: debug = True 2025-10-05 08:20:45,449 [2] DEBUG gnocchi.service: log_dir = /var/log/gnocchi 2025-10-05 08:20:45,449 [2] DEBUG gnocchi.service: log_file = None 2025-10-05 08:20:45,449 [2] DEBUG gnocchi.service: parallel_operations = 8 2025-10-05 08:20:45,449 [2] DEBUG gnocchi.service: syslog_log_facility = user 2025-10-05 08:20:45,449 [2] DEBUG gnocchi.service: use_journal = False 2025-10-05 08:20:45,449 [2] DEBUG gnocchi.service: use_syslog = False 2025-10-05 08:20:45,450 [2] DEBUG gnocchi.service: verbose = True 2025-10-05 08:20:45,450 [2] DEBUG gnocchi.service: database.backend = sqlalchemy 2025-10-05 08:20:45,450 [2] DEBUG gnocchi.service: database.connection = **** 2025-10-05 08:20:45,450 [2] DEBUG gnocchi.service: database.connection_debug = 0 2025-10-05 08:20:45,450 [2] DEBUG gnocchi.service: database.connection_parameters = 2025-10-05 08:20:45,450 [2] DEBUG gnocchi.service: database.connection_recycle_time = 3600 2025-10-05 08:20:45,450 [2] DEBUG gnocchi.service: database.connection_trace = False 2025-10-05 08:20:45,450 [2] DEBUG gnocchi.service: database.db_inc_retry_interval = True 2025-10-05 08:20:45,450 [2] DEBUG gnocchi.service: database.db_max_retries = 20 2025-10-05 08:20:45,451 [2] DEBUG gnocchi.service: database.db_max_retry_interval = 10 2025-10-05 08:20:45,451 [2] DEBUG gnocchi.service: database.db_retry_interval = 1 2025-10-05 08:20:45,451 [2] DEBUG gnocchi.service: database.max_overflow = 50 2025-10-05 08:20:45,451 [2] DEBUG gnocchi.service: database.max_pool_size = 5 2025-10-05 08:20:45,451 [2] DEBUG gnocchi.service: database.max_retries = 10 2025-10-05 08:20:45,451 [2] DEBUG gnocchi.service: database.mysql_enable_ndb = False 2025-10-05 08:20:45,451 [2] DEBUG gnocchi.service: database.mysql_sql_mode = TRADITIONAL 2025-10-05 08:20:45,451 [2] DEBUG gnocchi.service: database.pool_timeout = None 2025-10-05 08:20:45,451 [2] DEBUG gnocchi.service: database.retry_interval = 10 2025-10-05 08:20:45,452 [2] DEBUG gnocchi.service: database.slave_connection = **** 2025-10-05 08:20:45,452 [2] DEBUG gnocchi.service: database.sqlite_synchronous = True 2025-10-05 08:20:45,452 [2] DEBUG gnocchi.service: database.use_db_reconnect = False 2025-10-05 08:20:45,452 [2] DEBUG gnocchi.service: indexer.url = **** 2025-10-05 08:20:45,452 [2] DEBUG gnocchi.service: metricd.greedy = True 2025-10-05 08:20:45,452 [2] DEBUG gnocchi.service: metricd.metric_cleanup_delay = 300 2025-10-05 08:20:45,452 [2] DEBUG gnocchi.service: metricd.metric_processing_delay = 30 2025-10-05 08:20:45,452 [2] DEBUG gnocchi.service: metricd.metric_reporting_delay = 120 2025-10-05 08:20:45,452 [2] DEBUG gnocchi.service: metricd.processing_replicas = 3 2025-10-05 08:20:45,452 [2] DEBUG gnocchi.service: metricd.workers = 1 2025-10-05 08:20:45,452 [2] DEBUG gnocchi.service: api.auth_mode = keystone 2025-10-05 08:20:45,454 [2] WARNING oslo_config.cfg: Deprecated: Option "enable_proxy_headers_parsing" from group "oslo_middleware" is deprecated. Use option "enable_proxy_headers_parsing" from group "api". 2025-10-05 08:20:45,454 [2] DEBUG gnocchi.service: api.enable_proxy_headers_parsing = True 2025-10-05 08:20:45,454 [2] DEBUG gnocchi.service: api.host = 0.0.0.0 2025-10-05 08:20:45,454 [2] DEBUG gnocchi.service: api.max_limit = 1000 2025-10-05 08:20:45,454 [2] DEBUG gnocchi.service: api.operation_timeout = 10 2025-10-05 08:20:45,454 [2] DEBUG gnocchi.service: api.paste_config = api-paste.ini 2025-10-05 08:20:45,455 [2] DEBUG gnocchi.service: api.port = 8041 2025-10-05 08:20:45,455 [2] DEBUG gnocchi.service: api.uwsgi_mode = http 2025-10-05 08:20:45,455 [2] DEBUG gnocchi.service: storage.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:45,455 [2] DEBUG gnocchi.service: storage.ceph_keyring = None 2025-10-05 08:20:45,455 [2] DEBUG gnocchi.service: storage.ceph_pool = gnocchi 2025-10-05 08:20:45,455 [2] DEBUG gnocchi.service: storage.ceph_secret = **** 2025-10-05 08:20:45,455 [2] DEBUG gnocchi.service: storage.ceph_timeout = 30 2025-10-05 08:20:45,455 [2] DEBUG gnocchi.service: storage.ceph_username = None 2025-10-05 08:20:45,456 [2] DEBUG gnocchi.service: storage.driver = swift 2025-10-05 08:20:45,456 [2] DEBUG gnocchi.service: storage.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:45,456 [2] DEBUG gnocchi.service: storage.file_subdir_len = 2 2025-10-05 08:20:45,456 [2] DEBUG gnocchi.service: storage.redis_url = **** 2025-10-05 08:20:45,456 [2] DEBUG gnocchi.service: storage.s3_access_key_id = None 2025-10-05 08:20:45,456 [2] DEBUG gnocchi.service: storage.s3_bucket_prefix = gnocchi 2025-10-05 08:20:45,456 [2] DEBUG gnocchi.service: storage.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:45,456 [2] DEBUG gnocchi.service: storage.s3_endpoint_url = None 2025-10-05 08:20:45,457 [2] DEBUG gnocchi.service: storage.s3_max_pool_connections = 50 2025-10-05 08:20:45,457 [2] DEBUG gnocchi.service: storage.s3_region_name = None 2025-10-05 08:20:45,457 [2] DEBUG gnocchi.service: storage.s3_secret_access_key = None 2025-10-05 08:20:45,457 [2] DEBUG gnocchi.service: storage.swift_auth_insecure = False 2025-10-05 08:20:45,457 [2] DEBUG gnocchi.service: storage.swift_auth_version = 3 2025-10-05 08:20:45,457 [2] DEBUG gnocchi.service: storage.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:45,457 [2] DEBUG gnocchi.service: storage.swift_cacert = None 2025-10-05 08:20:45,457 [2] DEBUG gnocchi.service: storage.swift_container_prefix = gnocchi 2025-10-05 08:20:45,457 [2] DEBUG gnocchi.service: storage.swift_endpoint_type = internalURL 2025-10-05 08:20:45,458 [2] DEBUG gnocchi.service: storage.swift_key = **** 2025-10-05 08:20:45,458 [2] DEBUG gnocchi.service: storage.swift_preauthtoken = **** 2025-10-05 08:20:45,458 [2] DEBUG gnocchi.service: storage.swift_project_domain_name = Default 2025-10-05 08:20:45,458 [2] DEBUG gnocchi.service: storage.swift_project_name = None 2025-10-05 08:20:45,458 [2] DEBUG gnocchi.service: storage.swift_region = None 2025-10-05 08:20:45,458 [2] DEBUG gnocchi.service: storage.swift_service_type = object-store 2025-10-05 08:20:45,458 [2] DEBUG gnocchi.service: storage.swift_timeout = 300 2025-10-05 08:20:45,459 [2] DEBUG gnocchi.service: storage.swift_url = None 2025-10-05 08:20:45,459 [2] DEBUG gnocchi.service: storage.swift_user = service:gnocchi 2025-10-05 08:20:45,459 [2] DEBUG gnocchi.service: storage.swift_user_domain_name = Default 2025-10-05 08:20:45,459 [2] DEBUG gnocchi.service: incoming.ceph_conffile = /etc/ceph/ceph.conf 2025-10-05 08:20:45,459 [2] DEBUG gnocchi.service: incoming.ceph_keyring = 2025-10-05 08:20:45,460 [2] DEBUG gnocchi.service: incoming.ceph_pool = gnocchi 2025-10-05 08:20:45,460 [2] DEBUG gnocchi.service: incoming.ceph_secret = **** 2025-10-05 08:20:45,460 [2] DEBUG gnocchi.service: incoming.ceph_timeout = 30 2025-10-05 08:20:45,460 [2] DEBUG gnocchi.service: incoming.ceph_username = 2025-10-05 08:20:45,460 [2] DEBUG gnocchi.service: incoming.driver = redis 2025-10-05 08:20:45,461 [2] DEBUG gnocchi.service: incoming.file_basepath = /var/lib/gnocchi 2025-10-05 08:20:45,461 [2] DEBUG gnocchi.service: incoming.file_subdir_len = 2 2025-10-05 08:20:45,461 [2] DEBUG gnocchi.service: incoming.redis_url = **** 2025-10-05 08:20:45,461 [2] DEBUG gnocchi.service: incoming.s3_access_key_id = 2025-10-05 08:20:45,461 [2] DEBUG gnocchi.service: incoming.s3_bucket_prefix = gnocchi 2025-10-05 08:20:45,461 [2] DEBUG gnocchi.service: incoming.s3_check_consistency_timeout = 60.0 2025-10-05 08:20:45,462 [2] DEBUG gnocchi.service: incoming.s3_endpoint_url = 2025-10-05 08:20:45,462 [2] DEBUG gnocchi.service: incoming.s3_max_pool_connections = 50 2025-10-05 08:20:45,462 [2] DEBUG gnocchi.service: incoming.s3_region_name = 2025-10-05 08:20:45,462 [2] DEBUG gnocchi.service: incoming.s3_secret_access_key = 2025-10-05 08:20:45,462 [2] DEBUG gnocchi.service: incoming.swift_auth_insecure = False 2025-10-05 08:20:45,463 [2] DEBUG gnocchi.service: incoming.swift_auth_version = 3 2025-10-05 08:20:45,463 [2] DEBUG gnocchi.service: incoming.swift_authurl = http://172.17.0.227:5000/v3 2025-10-05 08:20:45,463 [2] DEBUG gnocchi.service: incoming.swift_cacert = 2025-10-05 08:20:45,464 [2] DEBUG gnocchi.service: incoming.swift_container_prefix = gnocchi 2025-10-05 08:20:45,464 [2] DEBUG gnocchi.service: incoming.swift_endpoint_type = internalURL 2025-10-05 08:20:45,464 [2] DEBUG gnocchi.service: incoming.swift_key = **** 2025-10-05 08:20:45,464 [2] DEBUG gnocchi.service: incoming.swift_preauthtoken = **** 2025-10-05 08:20:45,464 [2] DEBUG gnocchi.service: incoming.swift_project_domain_name = Default 2025-10-05 08:20:45,465 [2] DEBUG gnocchi.service: incoming.swift_project_name = 2025-10-05 08:20:45,465 [2] DEBUG gnocchi.service: incoming.swift_region = 2025-10-05 08:20:45,465 [2] DEBUG gnocchi.service: incoming.swift_service_type = object-store 2025-10-05 08:20:45,465 [2] DEBUG gnocchi.service: incoming.swift_timeout = 300 2025-10-05 08:20:45,465 [2] DEBUG gnocchi.service: incoming.swift_url = 2025-10-05 08:20:45,465 [2] DEBUG gnocchi.service: incoming.swift_user = service:gnocchi 2025-10-05 08:20:45,466 [2] DEBUG gnocchi.service: incoming.swift_user_domain_name = Default 2025-10-05 08:20:45,466 [2] DEBUG gnocchi.service: statsd.archive_policy_name = low 2025-10-05 08:20:45,466 [2] DEBUG gnocchi.service: statsd.creator = None 2025-10-05 08:20:45,466 [2] DEBUG gnocchi.service: statsd.flush_delay = 10.0 2025-10-05 08:20:45,466 [2] DEBUG gnocchi.service: statsd.host = 0.0.0.0 2025-10-05 08:20:45,466 [2] DEBUG gnocchi.service: statsd.port = 8125 2025-10-05 08:20:45,466 [2] DEBUG gnocchi.service: statsd.resource_id = 0a8b55df-f90f-491c-8cb9-7cdecec6fc26 2025-10-05 08:20:45,466 [2] DEBUG gnocchi.service: amqp1d.creator = None 2025-10-05 08:20:45,467 [2] DEBUG gnocchi.service: amqp1d.data_source = collectd 2025-10-05 08:20:45,467 [2] DEBUG gnocchi.service: amqp1d.flush_delay = 10.0 2025-10-05 08:20:45,467 [2] DEBUG gnocchi.service: amqp1d.resource_type = collectd_amqp1d 2025-10-05 08:20:45,467 [2] DEBUG gnocchi.service: amqp1d.url = localhost:5672/u/collectd/telemetry 2025-10-05 08:20:45,467 [2] DEBUG gnocchi.service: archive_policy.default_aggregation_methods = ['mean', 'min', 'max', 'sum', 'std', 'count'] 2025-10-05 08:20:45,467 [2] DEBUG gnocchi.service: ******************************************************************************** 2025-10-05 08:20:45,755 [2] CRITICAL root: Traceback (most recent call last): File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.ProgrammingError: (1146, "Table 'gnocchi.resource_type' doesn't exist") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/bin/gnocchi-statsd", line 33, in sys.exit(load_entry_point('gnocchi==4.4.6.dev2+gff96e73d', 'console_scripts', 'gnocchi-statsd')()) File "/usr/lib/python3.9/site-packages/gnocchi/cli/statsd.py", line 20, in statsd statsd_service.start() File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 174, in start stats = Stats(conf) File "/usr/lib/python3.9/site-packages/gnocchi/statsd.py", line 41, in __init__ self.indexer.create_resource('generic', File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 154, in wrapper ectxt.value = e.inner_exc File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 227, in __exit__ self.force_reraise() File "/usr/lib/python3.9/site-packages/oslo_utils/excutils.py", line 200, in force_reraise raise self.value File "/usr/lib/python3.9/site-packages/oslo_db/api.py", line 142, in wrapper return f(*args, **kwargs) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 811, in create_resource resource_cls = self._resource_type_to_mappers( File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 587, in _resource_type_to_mappers resource_type = self._get_resource_type(session, name) File "/usr/lib/python3.9/site-packages/gnocchi/indexer/sqlalchemy.py", line 482, in _get_resource_type resource_type = session.query(ResourceType).get(name) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1018, in get return self._get_impl(ident, loading.load_on_pk_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 1135, in _get_impl return db_load_fn(self, primary_key_identity) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/loading.py", line 286, in load_on_pk_identity return q.one() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3490, in one ret = self.one_or_none() File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none ret = list(self) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__ return self._execute_and_instances(context) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute return meth(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement ret = self._execute_context( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context self._handle_dbapi_exception( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1508, in _handle_dbapi_exception util.raise_(newraise, with_traceback=exc_info[2], from_=e) File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_ raise exception File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'gnocchi.resource_type' doesn't exist") [SQL: SELECT resource_type.name AS resource_type_name, resource_type.tablename AS resource_type_tablename, resource_type.attributes AS resource_type_attributes, resource_type.state AS resource_type_state, resource_type.updated_at AS resource_type_updated_at FROM resource_type WHERE resource_type.name = %(param_1)s] [parameters: {'param_1': 'generic'}] (Background on this error at: http://sqlalche.me/e/13/f405)