-- Logs begin at Mon 2022-10-17 17:18:51 UTC, end at Mon 2022-10-17 20:21:19 UTC. -- Oct 17 18:00:31.578859 dv-cinder-861566-2-smb systemd[1]: Started Devstack devstack@c-sch.service. Oct 17 18:00:34.562796 dv-cinder-861566-2-smb cinder-scheduler[112108]: INFO dbcounter [None req-1da7e77b-b109-4b88-b1fd-999bb3bdecf2 None None] Registered counter for database cinder Oct 17 18:00:34.581972 dv-cinder-861566-2-smb cinder-scheduler[112108]: DEBUG oslo_db.sqlalchemy.engines [None req-1da7e77b-b109-4b88-b1fd-999bb3bdecf2 None None] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION {{(pid=112108) _check_effective_sql_mode /usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/engines.py:314}} Oct 17 18:00:34.590560 dv-cinder-861566-2-smb cinder-scheduler[112108]: DEBUG dbcounter [-] [112108] Writer thread running {{(pid=112108) stat_writer /usr/local/lib/python3.8/dist-packages/dbcounter.py:99}} Oct 17 18:00:34.795510 dv-cinder-861566-2-smb cinder-scheduler[112108]: /usr/lib/python3/dist-packages/secretstorage/dhcrypto.py:15: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 18:00:34.795510 dv-cinder-861566-2-smb cinder-scheduler[112108]: from cryptography.utils import int_from_bytes Oct 17 18:00:34.795510 dv-cinder-861566-2-smb cinder-scheduler[112108]: /usr/lib/python3/dist-packages/secretstorage/util.py:19: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 18:00:34.795510 dv-cinder-861566-2-smb cinder-scheduler[112108]: from cryptography.utils import int_from_bytes Oct 17 18:00:34.808131 dv-cinder-861566-2-smb cinder-scheduler[112108]: CRITICAL cinder [None req-1da7e77b-b109-4b88-b1fd-999bb3bdecf2 None None] Unhandled error: sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 18:00:34.808131 dv-cinder-861566-2-smb cinder-scheduler[112108]: [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 18:00:34.808131 dv-cinder-861566-2-smb cinder-scheduler[112108]: FROM services Oct 17 18:00:34.808131 dv-cinder-861566-2-smb cinder-scheduler[112108]: WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:00:34.808131 dv-cinder-861566-2-smb cinder-scheduler[112108]: FROM clusters Oct 17 18:00:34.808131 dv-cinder-861566-2-smb cinder-scheduler[112108]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:00:34.808131 dv-cinder-861566-2-smb cinder-scheduler[112108]: FROM clusters Oct 17 18:00:34.808131 dv-cinder-861566-2-smb cinder-scheduler[112108]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 18:00:34.808131 dv-cinder-861566-2-smb cinder-scheduler[112108]: [parameters: {'topic_1': 'cinder-volume'}] Oct 17 18:00:34.808131 dv-cinder-861566-2-smb cinder-scheduler[112108]: (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 18:00:34.808131 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder Traceback (most recent call last): Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder self.dialect.do_execute( Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder cursor.execute(statement, parameters) Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder result = self._query(query) Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder conn.query(q) Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder result.read() Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder packet.raise_for_error() Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder raise errorclass(errno, errval) Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder pymysql.err.ProgrammingError: (1146, "Table 'cinder.services' doesn't exist") Oct 17 18:00:34.808884 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder The above exception was the direct cause of the following exception: Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder Traceback (most recent call last): Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/bin/cinder-scheduler", line 10, in Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder sys.exit(main()) Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/opt/stack/cinder/cinder/cmd/scheduler.py", line 59, in main Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder server = service.Service.create(binary='cinder-scheduler') Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 417, in create Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder service_obj = cls(host, binary, topic, manager, Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 158, in __init__ Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder self.manager = manager_class(host=self.host, Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/manager.py", line 103, in __init__ Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder self.driver = importutils.import_object(scheduler_driver) Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/filter_scheduler.py", line 48, in __init__ Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder super(FilterScheduler, self).__init__(*args, **kwargs) Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/driver.py", line 77, in __init__ Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder self.host_manager = importutils.import_object( Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 488, in __init__ Oct 17 18:00:34.810436 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder self._update_backend_state_map(cinder_context.get_admin_context()) Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 685, in _update_backend_state_map Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder volume_services = objects.ServiceList.get_all(context, Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/opt/stack/cinder/cinder/objects/service.py", line 224, in get_all Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder services = db.service_get_all(context, **(filters or {})) Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/opt/stack/cinder/cinder/db/api.py", line 286, in service_get_all Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder return IMPL.service_get_all(context, backend_match_level, **filters) Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 161, in wrapper Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder return f(*args, **kwargs) Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1010, in wrapper Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder return fn(*args, **kwargs) Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 914, in service_get_all Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder return [] if not query else query.all() Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2772, in all Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder return self._iter().all() Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2907, in _iter Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder result = self.session.execute( Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1712, in execute Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder result = conn._execute_20(statement, params or {}, execution_options) Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 Oct 17 18:00:34.811737 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder return meth(self, args_10style, kwargs_10style, execution_options) Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder return connection._execute_clauseelement( Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder ret = self._execute_context( Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder self._handle_dbapi_exception( Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder util.raise_(newraise, with_traceback=exc_info[2], from_=e) Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 208, in raise_ Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder raise exception Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder self.dialect.do_execute( Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder cursor.execute(statement, parameters) Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder result = self._query(query) Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder conn.query(q) Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 18:00:34.814192 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 18:00:34.816868 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder result.read() Oct 17 18:00:34.816868 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 18:00:34.816868 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 18:00:34.816868 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 18:00:34.816868 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder packet.raise_for_error() Oct 17 18:00:34.816868 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 18:00:34.816868 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 18:00:34.816868 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 18:00:34.816868 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder raise errorclass(errno, errval) Oct 17 18:00:34.816868 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 18:00:34.816868 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 18:00:34.816868 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder FROM services Oct 17 18:00:34.818419 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:00:34.818419 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder FROM clusters Oct 17 18:00:34.818419 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:00:34.818419 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder FROM clusters Oct 17 18:00:34.818419 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 18:00:34.818419 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder [parameters: {'topic_1': 'cinder-volume'}] Oct 17 18:00:34.818419 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 18:00:34.818419 dv-cinder-861566-2-smb cinder-scheduler[112108]: ERROR cinder Oct 17 18:00:35.206754 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Main process exited, code=exited, status=1/FAILURE Oct 17 18:00:35.206783 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Failed with result 'exit-code'. Oct 17 18:12:08.117123 dv-cinder-861566-2-smb systemd[1]: Started Devstack devstack@c-sch.service. Oct 17 18:12:11.084452 dv-cinder-861566-2-smb cinder-scheduler[176593]: INFO dbcounter [None req-7db8bb1b-f7bd-4623-824e-ae6039fd2dda None None] Registered counter for database cinder Oct 17 18:12:11.104022 dv-cinder-861566-2-smb cinder-scheduler[176593]: DEBUG oslo_db.sqlalchemy.engines [None req-7db8bb1b-f7bd-4623-824e-ae6039fd2dda None None] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION {{(pid=176593) _check_effective_sql_mode /usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/engines.py:314}} Oct 17 18:12:11.111117 dv-cinder-861566-2-smb cinder-scheduler[176593]: DEBUG dbcounter [-] [176593] Writer thread running {{(pid=176593) stat_writer /usr/local/lib/python3.8/dist-packages/dbcounter.py:99}} Oct 17 18:12:11.318927 dv-cinder-861566-2-smb cinder-scheduler[176593]: /usr/lib/python3/dist-packages/secretstorage/dhcrypto.py:15: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 18:12:11.318927 dv-cinder-861566-2-smb cinder-scheduler[176593]: from cryptography.utils import int_from_bytes Oct 17 18:12:11.318927 dv-cinder-861566-2-smb cinder-scheduler[176593]: /usr/lib/python3/dist-packages/secretstorage/util.py:19: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 18:12:11.318927 dv-cinder-861566-2-smb cinder-scheduler[176593]: from cryptography.utils import int_from_bytes Oct 17 18:12:11.330888 dv-cinder-861566-2-smb cinder-scheduler[176593]: CRITICAL cinder [None req-7db8bb1b-f7bd-4623-824e-ae6039fd2dda None None] Unhandled error: sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 18:12:11.330888 dv-cinder-861566-2-smb cinder-scheduler[176593]: [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 18:12:11.330888 dv-cinder-861566-2-smb cinder-scheduler[176593]: FROM services Oct 17 18:12:11.330888 dv-cinder-861566-2-smb cinder-scheduler[176593]: WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:12:11.330888 dv-cinder-861566-2-smb cinder-scheduler[176593]: FROM clusters Oct 17 18:12:11.330888 dv-cinder-861566-2-smb cinder-scheduler[176593]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:12:11.330888 dv-cinder-861566-2-smb cinder-scheduler[176593]: FROM clusters Oct 17 18:12:11.330888 dv-cinder-861566-2-smb cinder-scheduler[176593]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 18:12:11.330888 dv-cinder-861566-2-smb cinder-scheduler[176593]: [parameters: {'topic_1': 'cinder-volume'}] Oct 17 18:12:11.330888 dv-cinder-861566-2-smb cinder-scheduler[176593]: (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 18:12:11.330888 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder Traceback (most recent call last): Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder self.dialect.do_execute( Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder cursor.execute(statement, parameters) Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder result = self._query(query) Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder conn.query(q) Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder result.read() Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder packet.raise_for_error() Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder raise errorclass(errno, errval) Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder pymysql.err.ProgrammingError: (1146, "Table 'cinder.services' doesn't exist") Oct 17 18:12:11.331584 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder The above exception was the direct cause of the following exception: Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder Traceback (most recent call last): Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/bin/cinder-scheduler", line 10, in Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder sys.exit(main()) Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/opt/stack/cinder/cinder/cmd/scheduler.py", line 59, in main Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder server = service.Service.create(binary='cinder-scheduler') Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 417, in create Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder service_obj = cls(host, binary, topic, manager, Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 158, in __init__ Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder self.manager = manager_class(host=self.host, Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/manager.py", line 103, in __init__ Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder self.driver = importutils.import_object(scheduler_driver) Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/filter_scheduler.py", line 48, in __init__ Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder super(FilterScheduler, self).__init__(*args, **kwargs) Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/driver.py", line 77, in __init__ Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder self.host_manager = importutils.import_object( Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 488, in __init__ Oct 17 18:12:11.332633 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder self._update_backend_state_map(cinder_context.get_admin_context()) Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 685, in _update_backend_state_map Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder volume_services = objects.ServiceList.get_all(context, Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/opt/stack/cinder/cinder/objects/service.py", line 224, in get_all Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder services = db.service_get_all(context, **(filters or {})) Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/opt/stack/cinder/cinder/db/api.py", line 286, in service_get_all Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder return IMPL.service_get_all(context, backend_match_level, **filters) Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 161, in wrapper Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder return f(*args, **kwargs) Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1010, in wrapper Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder return fn(*args, **kwargs) Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 914, in service_get_all Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder return [] if not query else query.all() Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2772, in all Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder return self._iter().all() Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2907, in _iter Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder result = self.session.execute( Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1712, in execute Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder result = conn._execute_20(statement, params or {}, execution_options) Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 Oct 17 18:12:11.333805 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder return meth(self, args_10style, kwargs_10style, execution_options) Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder return connection._execute_clauseelement( Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder ret = self._execute_context( Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder self._handle_dbapi_exception( Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder util.raise_(newraise, with_traceback=exc_info[2], from_=e) Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 208, in raise_ Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder raise exception Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder self.dialect.do_execute( Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder cursor.execute(statement, parameters) Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder result = self._query(query) Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder conn.query(q) Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 18:12:11.334928 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 18:12:11.335946 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder result.read() Oct 17 18:12:11.335946 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 18:12:11.335946 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 18:12:11.335946 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 18:12:11.335946 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder packet.raise_for_error() Oct 17 18:12:11.335946 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 18:12:11.335946 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 18:12:11.335946 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 18:12:11.335946 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder raise errorclass(errno, errval) Oct 17 18:12:11.335946 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 18:12:11.335946 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 18:12:11.335946 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder FROM services Oct 17 18:12:11.336583 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:12:11.336583 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder FROM clusters Oct 17 18:12:11.336583 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:12:11.336583 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder FROM clusters Oct 17 18:12:11.336583 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 18:12:11.336583 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder [parameters: {'topic_1': 'cinder-volume'}] Oct 17 18:12:11.336583 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 18:12:11.336583 dv-cinder-861566-2-smb cinder-scheduler[176593]: ERROR cinder Oct 17 18:12:11.741827 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Main process exited, code=exited, status=1/FAILURE Oct 17 18:12:11.741854 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Failed with result 'exit-code'. Oct 17 18:23:54.842150 dv-cinder-861566-2-smb systemd[1]: Started Devstack devstack@c-sch.service. Oct 17 18:23:57.896409 dv-cinder-861566-2-smb cinder-scheduler[241044]: INFO dbcounter [None req-d5ab7dca-5668-4ffe-a78d-0d6850fb26ee None None] Registered counter for database cinder Oct 17 18:23:57.915990 dv-cinder-861566-2-smb cinder-scheduler[241044]: DEBUG oslo_db.sqlalchemy.engines [None req-d5ab7dca-5668-4ffe-a78d-0d6850fb26ee None None] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION {{(pid=241044) _check_effective_sql_mode /usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/engines.py:314}} Oct 17 18:23:57.924754 dv-cinder-861566-2-smb cinder-scheduler[241044]: DEBUG dbcounter [-] [241044] Writer thread running {{(pid=241044) stat_writer /usr/local/lib/python3.8/dist-packages/dbcounter.py:99}} Oct 17 18:23:58.133155 dv-cinder-861566-2-smb cinder-scheduler[241044]: /usr/lib/python3/dist-packages/secretstorage/dhcrypto.py:15: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 18:23:58.133155 dv-cinder-861566-2-smb cinder-scheduler[241044]: from cryptography.utils import int_from_bytes Oct 17 18:23:58.133155 dv-cinder-861566-2-smb cinder-scheduler[241044]: /usr/lib/python3/dist-packages/secretstorage/util.py:19: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 18:23:58.133155 dv-cinder-861566-2-smb cinder-scheduler[241044]: from cryptography.utils import int_from_bytes Oct 17 18:23:58.145903 dv-cinder-861566-2-smb cinder-scheduler[241044]: CRITICAL cinder [None req-d5ab7dca-5668-4ffe-a78d-0d6850fb26ee None None] Unhandled error: sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 18:23:58.145903 dv-cinder-861566-2-smb cinder-scheduler[241044]: [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 18:23:58.145903 dv-cinder-861566-2-smb cinder-scheduler[241044]: FROM services Oct 17 18:23:58.145903 dv-cinder-861566-2-smb cinder-scheduler[241044]: WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:23:58.145903 dv-cinder-861566-2-smb cinder-scheduler[241044]: FROM clusters Oct 17 18:23:58.145903 dv-cinder-861566-2-smb cinder-scheduler[241044]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:23:58.145903 dv-cinder-861566-2-smb cinder-scheduler[241044]: FROM clusters Oct 17 18:23:58.145903 dv-cinder-861566-2-smb cinder-scheduler[241044]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 18:23:58.145903 dv-cinder-861566-2-smb cinder-scheduler[241044]: [parameters: {'topic_1': 'cinder-volume'}] Oct 17 18:23:58.145903 dv-cinder-861566-2-smb cinder-scheduler[241044]: (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 18:23:58.145903 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder Traceback (most recent call last): Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder self.dialect.do_execute( Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder cursor.execute(statement, parameters) Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder result = self._query(query) Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder conn.query(q) Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder result.read() Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder packet.raise_for_error() Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder raise errorclass(errno, errval) Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder pymysql.err.ProgrammingError: (1146, "Table 'cinder.services' doesn't exist") Oct 17 18:23:58.146826 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder The above exception was the direct cause of the following exception: Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder Traceback (most recent call last): Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/bin/cinder-scheduler", line 10, in Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder sys.exit(main()) Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/opt/stack/cinder/cinder/cmd/scheduler.py", line 59, in main Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder server = service.Service.create(binary='cinder-scheduler') Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 417, in create Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder service_obj = cls(host, binary, topic, manager, Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 158, in __init__ Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder self.manager = manager_class(host=self.host, Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/manager.py", line 103, in __init__ Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder self.driver = importutils.import_object(scheduler_driver) Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/filter_scheduler.py", line 48, in __init__ Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder super(FilterScheduler, self).__init__(*args, **kwargs) Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/driver.py", line 77, in __init__ Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder self.host_manager = importutils.import_object( Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 488, in __init__ Oct 17 18:23:58.148079 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder self._update_backend_state_map(cinder_context.get_admin_context()) Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 685, in _update_backend_state_map Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder volume_services = objects.ServiceList.get_all(context, Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/opt/stack/cinder/cinder/objects/service.py", line 224, in get_all Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder services = db.service_get_all(context, **(filters or {})) Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/opt/stack/cinder/cinder/db/api.py", line 286, in service_get_all Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder return IMPL.service_get_all(context, backend_match_level, **filters) Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 161, in wrapper Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder return f(*args, **kwargs) Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1010, in wrapper Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder return fn(*args, **kwargs) Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 914, in service_get_all Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder return [] if not query else query.all() Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2772, in all Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder return self._iter().all() Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2907, in _iter Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder result = self.session.execute( Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1712, in execute Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder result = conn._execute_20(statement, params or {}, execution_options) Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 Oct 17 18:23:58.149332 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder return meth(self, args_10style, kwargs_10style, execution_options) Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder return connection._execute_clauseelement( Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder ret = self._execute_context( Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder self._handle_dbapi_exception( Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder util.raise_(newraise, with_traceback=exc_info[2], from_=e) Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 208, in raise_ Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder raise exception Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder self.dialect.do_execute( Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder cursor.execute(statement, parameters) Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder result = self._query(query) Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder conn.query(q) Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 18:23:58.154005 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 18:23:58.159262 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder result.read() Oct 17 18:23:58.159262 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 18:23:58.159262 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 18:23:58.159262 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 18:23:58.159262 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder packet.raise_for_error() Oct 17 18:23:58.159262 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 18:23:58.159262 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 18:23:58.159262 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 18:23:58.159262 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder raise errorclass(errno, errval) Oct 17 18:23:58.159262 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 18:23:58.159262 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 18:23:58.159262 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder FROM services Oct 17 18:23:58.160998 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:23:58.160998 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder FROM clusters Oct 17 18:23:58.160998 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:23:58.160998 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder FROM clusters Oct 17 18:23:58.160998 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 18:23:58.160998 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder [parameters: {'topic_1': 'cinder-volume'}] Oct 17 18:23:58.160998 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 18:23:58.160998 dv-cinder-861566-2-smb cinder-scheduler[241044]: ERROR cinder Oct 17 18:23:58.560656 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Main process exited, code=exited, status=1/FAILURE Oct 17 18:23:58.560684 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Failed with result 'exit-code'. Oct 17 18:35:43.403446 dv-cinder-861566-2-smb systemd[1]: Started Devstack devstack@c-sch.service. Oct 17 18:35:46.409620 dv-cinder-861566-2-smb cinder-scheduler[312229]: INFO dbcounter [None req-61eb4c13-7b4d-4562-960a-b1225e41926c None None] Registered counter for database cinder Oct 17 18:35:46.427845 dv-cinder-861566-2-smb cinder-scheduler[312229]: DEBUG oslo_db.sqlalchemy.engines [None req-61eb4c13-7b4d-4562-960a-b1225e41926c None None] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION {{(pid=312229) _check_effective_sql_mode /usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/engines.py:314}} Oct 17 18:35:46.435634 dv-cinder-861566-2-smb cinder-scheduler[312229]: DEBUG dbcounter [-] [312229] Writer thread running {{(pid=312229) stat_writer /usr/local/lib/python3.8/dist-packages/dbcounter.py:99}} Oct 17 18:35:46.651121 dv-cinder-861566-2-smb cinder-scheduler[312229]: /usr/lib/python3/dist-packages/secretstorage/dhcrypto.py:15: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 18:35:46.651121 dv-cinder-861566-2-smb cinder-scheduler[312229]: from cryptography.utils import int_from_bytes Oct 17 18:35:46.651121 dv-cinder-861566-2-smb cinder-scheduler[312229]: /usr/lib/python3/dist-packages/secretstorage/util.py:19: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 18:35:46.651121 dv-cinder-861566-2-smb cinder-scheduler[312229]: from cryptography.utils import int_from_bytes Oct 17 18:35:46.663212 dv-cinder-861566-2-smb cinder-scheduler[312229]: CRITICAL cinder [None req-61eb4c13-7b4d-4562-960a-b1225e41926c None None] Unhandled error: sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 18:35:46.663212 dv-cinder-861566-2-smb cinder-scheduler[312229]: [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 18:35:46.663212 dv-cinder-861566-2-smb cinder-scheduler[312229]: FROM services Oct 17 18:35:46.663212 dv-cinder-861566-2-smb cinder-scheduler[312229]: WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:35:46.663212 dv-cinder-861566-2-smb cinder-scheduler[312229]: FROM clusters Oct 17 18:35:46.663212 dv-cinder-861566-2-smb cinder-scheduler[312229]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:35:46.663212 dv-cinder-861566-2-smb cinder-scheduler[312229]: FROM clusters Oct 17 18:35:46.663212 dv-cinder-861566-2-smb cinder-scheduler[312229]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 18:35:46.663212 dv-cinder-861566-2-smb cinder-scheduler[312229]: [parameters: {'topic_1': 'cinder-volume'}] Oct 17 18:35:46.663212 dv-cinder-861566-2-smb cinder-scheduler[312229]: (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 18:35:46.663212 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder Traceback (most recent call last): Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder self.dialect.do_execute( Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder cursor.execute(statement, parameters) Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder result = self._query(query) Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder conn.query(q) Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder result.read() Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder packet.raise_for_error() Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder raise errorclass(errno, errval) Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder pymysql.err.ProgrammingError: (1146, "Table 'cinder.services' doesn't exist") Oct 17 18:35:46.664058 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder The above exception was the direct cause of the following exception: Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder Traceback (most recent call last): Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/bin/cinder-scheduler", line 10, in Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder sys.exit(main()) Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/opt/stack/cinder/cinder/cmd/scheduler.py", line 59, in main Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder server = service.Service.create(binary='cinder-scheduler') Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 417, in create Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder service_obj = cls(host, binary, topic, manager, Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 158, in __init__ Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder self.manager = manager_class(host=self.host, Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/manager.py", line 103, in __init__ Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder self.driver = importutils.import_object(scheduler_driver) Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/filter_scheduler.py", line 48, in __init__ Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder super(FilterScheduler, self).__init__(*args, **kwargs) Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/driver.py", line 77, in __init__ Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder self.host_manager = importutils.import_object( Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 488, in __init__ Oct 17 18:35:46.665391 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder self._update_backend_state_map(cinder_context.get_admin_context()) Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 685, in _update_backend_state_map Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder volume_services = objects.ServiceList.get_all(context, Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/opt/stack/cinder/cinder/objects/service.py", line 224, in get_all Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder services = db.service_get_all(context, **(filters or {})) Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/opt/stack/cinder/cinder/db/api.py", line 286, in service_get_all Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder return IMPL.service_get_all(context, backend_match_level, **filters) Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 161, in wrapper Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder return f(*args, **kwargs) Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1010, in wrapper Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder return fn(*args, **kwargs) Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 914, in service_get_all Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder return [] if not query else query.all() Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2772, in all Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder return self._iter().all() Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2907, in _iter Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder result = self.session.execute( Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1712, in execute Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder result = conn._execute_20(statement, params or {}, execution_options) Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 Oct 17 18:35:46.667021 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder return meth(self, args_10style, kwargs_10style, execution_options) Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder return connection._execute_clauseelement( Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder ret = self._execute_context( Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder self._handle_dbapi_exception( Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder util.raise_(newraise, with_traceback=exc_info[2], from_=e) Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 208, in raise_ Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder raise exception Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder self.dialect.do_execute( Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder cursor.execute(statement, parameters) Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder result = self._query(query) Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder conn.query(q) Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 18:35:46.668252 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 18:35:46.670778 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder result.read() Oct 17 18:35:46.670778 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 18:35:46.670778 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 18:35:46.670778 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 18:35:46.670778 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder packet.raise_for_error() Oct 17 18:35:46.670778 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 18:35:46.670778 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 18:35:46.670778 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 18:35:46.670778 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder raise errorclass(errno, errval) Oct 17 18:35:46.670778 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 18:35:46.670778 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 18:35:46.670778 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder FROM services Oct 17 18:35:46.672516 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:35:46.672516 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder FROM clusters Oct 17 18:35:46.672516 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:35:46.672516 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder FROM clusters Oct 17 18:35:46.672516 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 18:35:46.672516 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder [parameters: {'topic_1': 'cinder-volume'}] Oct 17 18:35:46.672516 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 18:35:46.672516 dv-cinder-861566-2-smb cinder-scheduler[312229]: ERROR cinder Oct 17 18:35:47.069813 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Main process exited, code=exited, status=1/FAILURE Oct 17 18:35:47.069842 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Failed with result 'exit-code'. Oct 17 18:50:46.502438 dv-cinder-861566-2-smb systemd[1]: Started Devstack devstack@c-sch.service. Oct 17 18:50:49.489714 dv-cinder-861566-2-smb cinder-scheduler[382566]: INFO dbcounter [None req-2059f88d-85e8-41fb-ae1e-01056a60309f None None] Registered counter for database cinder Oct 17 18:50:49.508880 dv-cinder-861566-2-smb cinder-scheduler[382566]: DEBUG oslo_db.sqlalchemy.engines [None req-2059f88d-85e8-41fb-ae1e-01056a60309f None None] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION {{(pid=382566) _check_effective_sql_mode /usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/engines.py:314}} Oct 17 18:50:49.515703 dv-cinder-861566-2-smb cinder-scheduler[382566]: DEBUG dbcounter [-] [382566] Writer thread running {{(pid=382566) stat_writer /usr/local/lib/python3.8/dist-packages/dbcounter.py:99}} Oct 17 18:50:49.719978 dv-cinder-861566-2-smb cinder-scheduler[382566]: /usr/lib/python3/dist-packages/secretstorage/dhcrypto.py:15: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 18:50:49.719978 dv-cinder-861566-2-smb cinder-scheduler[382566]: from cryptography.utils import int_from_bytes Oct 17 18:50:49.719978 dv-cinder-861566-2-smb cinder-scheduler[382566]: /usr/lib/python3/dist-packages/secretstorage/util.py:19: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 18:50:49.719978 dv-cinder-861566-2-smb cinder-scheduler[382566]: from cryptography.utils import int_from_bytes Oct 17 18:50:49.732781 dv-cinder-861566-2-smb cinder-scheduler[382566]: CRITICAL cinder [None req-2059f88d-85e8-41fb-ae1e-01056a60309f None None] Unhandled error: sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 18:50:49.732781 dv-cinder-861566-2-smb cinder-scheduler[382566]: [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 18:50:49.732781 dv-cinder-861566-2-smb cinder-scheduler[382566]: FROM services Oct 17 18:50:49.732781 dv-cinder-861566-2-smb cinder-scheduler[382566]: WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:50:49.732781 dv-cinder-861566-2-smb cinder-scheduler[382566]: FROM clusters Oct 17 18:50:49.732781 dv-cinder-861566-2-smb cinder-scheduler[382566]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:50:49.732781 dv-cinder-861566-2-smb cinder-scheduler[382566]: FROM clusters Oct 17 18:50:49.732781 dv-cinder-861566-2-smb cinder-scheduler[382566]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 18:50:49.732781 dv-cinder-861566-2-smb cinder-scheduler[382566]: [parameters: {'topic_1': 'cinder-volume'}] Oct 17 18:50:49.732781 dv-cinder-861566-2-smb cinder-scheduler[382566]: (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 18:50:49.732781 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder Traceback (most recent call last): Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder self.dialect.do_execute( Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder cursor.execute(statement, parameters) Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder result = self._query(query) Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder conn.query(q) Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder result.read() Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder packet.raise_for_error() Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder raise errorclass(errno, errval) Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder pymysql.err.ProgrammingError: (1146, "Table 'cinder.services' doesn't exist") Oct 17 18:50:49.733719 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder The above exception was the direct cause of the following exception: Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder Traceback (most recent call last): Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/bin/cinder-scheduler", line 10, in Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder sys.exit(main()) Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/opt/stack/cinder/cinder/cmd/scheduler.py", line 59, in main Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder server = service.Service.create(binary='cinder-scheduler') Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 417, in create Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder service_obj = cls(host, binary, topic, manager, Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 158, in __init__ Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder self.manager = manager_class(host=self.host, Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/manager.py", line 103, in __init__ Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder self.driver = importutils.import_object(scheduler_driver) Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/filter_scheduler.py", line 48, in __init__ Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder super(FilterScheduler, self).__init__(*args, **kwargs) Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/driver.py", line 77, in __init__ Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder self.host_manager = importutils.import_object( Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 488, in __init__ Oct 17 18:50:49.735243 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder self._update_backend_state_map(cinder_context.get_admin_context()) Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 685, in _update_backend_state_map Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder volume_services = objects.ServiceList.get_all(context, Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/opt/stack/cinder/cinder/objects/service.py", line 224, in get_all Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder services = db.service_get_all(context, **(filters or {})) Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/opt/stack/cinder/cinder/db/api.py", line 286, in service_get_all Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder return IMPL.service_get_all(context, backend_match_level, **filters) Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 161, in wrapper Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder return f(*args, **kwargs) Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1010, in wrapper Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder return fn(*args, **kwargs) Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 914, in service_get_all Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder return [] if not query else query.all() Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2772, in all Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder return self._iter().all() Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2907, in _iter Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder result = self.session.execute( Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1712, in execute Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder result = conn._execute_20(statement, params or {}, execution_options) Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 Oct 17 18:50:49.736765 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder return meth(self, args_10style, kwargs_10style, execution_options) Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder return connection._execute_clauseelement( Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder ret = self._execute_context( Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder self._handle_dbapi_exception( Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder util.raise_(newraise, with_traceback=exc_info[2], from_=e) Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 208, in raise_ Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder raise exception Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder self.dialect.do_execute( Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder cursor.execute(statement, parameters) Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder result = self._query(query) Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder conn.query(q) Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 18:50:49.739637 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 18:50:49.742570 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder result.read() Oct 17 18:50:49.742570 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 18:50:49.742570 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 18:50:49.742570 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 18:50:49.742570 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder packet.raise_for_error() Oct 17 18:50:49.742570 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 18:50:49.742570 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 18:50:49.742570 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 18:50:49.742570 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder raise errorclass(errno, errval) Oct 17 18:50:49.742570 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 18:50:49.742570 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 18:50:49.742570 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder FROM services Oct 17 18:50:49.744247 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:50:49.744247 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder FROM clusters Oct 17 18:50:49.744247 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 18:50:49.744247 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder FROM clusters Oct 17 18:50:49.744247 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 18:50:49.744247 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder [parameters: {'topic_1': 'cinder-volume'}] Oct 17 18:50:49.744247 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 18:50:49.744247 dv-cinder-861566-2-smb cinder-scheduler[382566]: ERROR cinder Oct 17 18:50:50.136638 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Main process exited, code=exited, status=1/FAILURE Oct 17 18:50:50.136653 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Failed with result 'exit-code'. Oct 17 19:02:34.664329 dv-cinder-861566-2-smb systemd[1]: Started Devstack devstack@c-sch.service. Oct 17 19:02:37.726834 dv-cinder-861566-2-smb cinder-scheduler[447451]: INFO dbcounter [None req-cc9cf00d-4ba4-4b51-9cd2-146e8f2fa186 None None] Registered counter for database cinder Oct 17 19:02:37.746611 dv-cinder-861566-2-smb cinder-scheduler[447451]: DEBUG oslo_db.sqlalchemy.engines [None req-cc9cf00d-4ba4-4b51-9cd2-146e8f2fa186 None None] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION {{(pid=447451) _check_effective_sql_mode /usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/engines.py:314}} Oct 17 19:02:37.753990 dv-cinder-861566-2-smb cinder-scheduler[447451]: DEBUG dbcounter [-] [447451] Writer thread running {{(pid=447451) stat_writer /usr/local/lib/python3.8/dist-packages/dbcounter.py:99}} Oct 17 19:02:37.979273 dv-cinder-861566-2-smb cinder-scheduler[447451]: /usr/lib/python3/dist-packages/secretstorage/dhcrypto.py:15: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 19:02:37.979273 dv-cinder-861566-2-smb cinder-scheduler[447451]: from cryptography.utils import int_from_bytes Oct 17 19:02:37.979273 dv-cinder-861566-2-smb cinder-scheduler[447451]: /usr/lib/python3/dist-packages/secretstorage/util.py:19: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 19:02:37.979273 dv-cinder-861566-2-smb cinder-scheduler[447451]: from cryptography.utils import int_from_bytes Oct 17 19:02:37.991814 dv-cinder-861566-2-smb cinder-scheduler[447451]: CRITICAL cinder [None req-cc9cf00d-4ba4-4b51-9cd2-146e8f2fa186 None None] Unhandled error: sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 19:02:37.991814 dv-cinder-861566-2-smb cinder-scheduler[447451]: [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 19:02:37.991814 dv-cinder-861566-2-smb cinder-scheduler[447451]: FROM services Oct 17 19:02:37.991814 dv-cinder-861566-2-smb cinder-scheduler[447451]: WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:02:37.991814 dv-cinder-861566-2-smb cinder-scheduler[447451]: FROM clusters Oct 17 19:02:37.991814 dv-cinder-861566-2-smb cinder-scheduler[447451]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:02:37.991814 dv-cinder-861566-2-smb cinder-scheduler[447451]: FROM clusters Oct 17 19:02:37.991814 dv-cinder-861566-2-smb cinder-scheduler[447451]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 19:02:37.991814 dv-cinder-861566-2-smb cinder-scheduler[447451]: [parameters: {'topic_1': 'cinder-volume'}] Oct 17 19:02:37.991814 dv-cinder-861566-2-smb cinder-scheduler[447451]: (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 19:02:37.991814 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder Traceback (most recent call last): Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder self.dialect.do_execute( Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder cursor.execute(statement, parameters) Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder result = self._query(query) Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder conn.query(q) Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder result.read() Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder packet.raise_for_error() Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder raise errorclass(errno, errval) Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder pymysql.err.ProgrammingError: (1146, "Table 'cinder.services' doesn't exist") Oct 17 19:02:37.992728 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder The above exception was the direct cause of the following exception: Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder Traceback (most recent call last): Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/bin/cinder-scheduler", line 10, in Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder sys.exit(main()) Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/opt/stack/cinder/cinder/cmd/scheduler.py", line 59, in main Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder server = service.Service.create(binary='cinder-scheduler') Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 417, in create Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder service_obj = cls(host, binary, topic, manager, Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 158, in __init__ Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder self.manager = manager_class(host=self.host, Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/manager.py", line 103, in __init__ Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder self.driver = importutils.import_object(scheduler_driver) Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/filter_scheduler.py", line 48, in __init__ Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder super(FilterScheduler, self).__init__(*args, **kwargs) Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/driver.py", line 77, in __init__ Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder self.host_manager = importutils.import_object( Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 488, in __init__ Oct 17 19:02:37.994153 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder self._update_backend_state_map(cinder_context.get_admin_context()) Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 685, in _update_backend_state_map Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder volume_services = objects.ServiceList.get_all(context, Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/opt/stack/cinder/cinder/objects/service.py", line 224, in get_all Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder services = db.service_get_all(context, **(filters or {})) Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/opt/stack/cinder/cinder/db/api.py", line 286, in service_get_all Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder return IMPL.service_get_all(context, backend_match_level, **filters) Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 161, in wrapper Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder return f(*args, **kwargs) Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1010, in wrapper Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder return fn(*args, **kwargs) Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 914, in service_get_all Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder return [] if not query else query.all() Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2772, in all Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder return self._iter().all() Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2907, in _iter Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder result = self.session.execute( Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1712, in execute Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder result = conn._execute_20(statement, params or {}, execution_options) Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 Oct 17 19:02:37.995673 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder return meth(self, args_10style, kwargs_10style, execution_options) Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder return connection._execute_clauseelement( Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder ret = self._execute_context( Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder self._handle_dbapi_exception( Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder util.raise_(newraise, with_traceback=exc_info[2], from_=e) Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 208, in raise_ Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder raise exception Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder self.dialect.do_execute( Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder cursor.execute(statement, parameters) Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder result = self._query(query) Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder conn.query(q) Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 19:02:37.996722 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 19:02:37.997966 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder result.read() Oct 17 19:02:37.997966 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 19:02:37.997966 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 19:02:37.997966 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 19:02:37.997966 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder packet.raise_for_error() Oct 17 19:02:37.997966 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 19:02:37.997966 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 19:02:37.997966 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 19:02:37.997966 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder raise errorclass(errno, errval) Oct 17 19:02:37.997966 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 19:02:37.997966 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 19:02:37.997966 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder FROM services Oct 17 19:02:37.998720 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:02:37.998720 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder FROM clusters Oct 17 19:02:37.998720 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:02:37.998720 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder FROM clusters Oct 17 19:02:37.998720 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 19:02:37.998720 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder [parameters: {'topic_1': 'cinder-volume'}] Oct 17 19:02:37.998720 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 19:02:37.998720 dv-cinder-861566-2-smb cinder-scheduler[447451]: ERROR cinder Oct 17 19:02:38.401494 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Main process exited, code=exited, status=1/FAILURE Oct 17 19:02:38.401518 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Failed with result 'exit-code'. Oct 17 19:14:26.943189 dv-cinder-861566-2-smb systemd[1]: Started Devstack devstack@c-sch.service. Oct 17 19:14:29.962391 dv-cinder-861566-2-smb cinder-scheduler[511962]: INFO dbcounter [None req-a24358af-eefd-4b6d-b758-4181c371f202 None None] Registered counter for database cinder Oct 17 19:14:29.980362 dv-cinder-861566-2-smb cinder-scheduler[511962]: DEBUG oslo_db.sqlalchemy.engines [None req-a24358af-eefd-4b6d-b758-4181c371f202 None None] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION {{(pid=511962) _check_effective_sql_mode /usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/engines.py:314}} Oct 17 19:14:29.989113 dv-cinder-861566-2-smb cinder-scheduler[511962]: DEBUG dbcounter [-] [511962] Writer thread running {{(pid=511962) stat_writer /usr/local/lib/python3.8/dist-packages/dbcounter.py:99}} Oct 17 19:14:30.192670 dv-cinder-861566-2-smb cinder-scheduler[511962]: /usr/lib/python3/dist-packages/secretstorage/dhcrypto.py:15: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 19:14:30.192670 dv-cinder-861566-2-smb cinder-scheduler[511962]: from cryptography.utils import int_from_bytes Oct 17 19:14:30.192670 dv-cinder-861566-2-smb cinder-scheduler[511962]: /usr/lib/python3/dist-packages/secretstorage/util.py:19: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 19:14:30.192670 dv-cinder-861566-2-smb cinder-scheduler[511962]: from cryptography.utils import int_from_bytes Oct 17 19:14:30.205355 dv-cinder-861566-2-smb cinder-scheduler[511962]: CRITICAL cinder [None req-a24358af-eefd-4b6d-b758-4181c371f202 None None] Unhandled error: sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 19:14:30.205355 dv-cinder-861566-2-smb cinder-scheduler[511962]: [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 19:14:30.205355 dv-cinder-861566-2-smb cinder-scheduler[511962]: FROM services Oct 17 19:14:30.205355 dv-cinder-861566-2-smb cinder-scheduler[511962]: WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:14:30.205355 dv-cinder-861566-2-smb cinder-scheduler[511962]: FROM clusters Oct 17 19:14:30.205355 dv-cinder-861566-2-smb cinder-scheduler[511962]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:14:30.205355 dv-cinder-861566-2-smb cinder-scheduler[511962]: FROM clusters Oct 17 19:14:30.205355 dv-cinder-861566-2-smb cinder-scheduler[511962]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 19:14:30.205355 dv-cinder-861566-2-smb cinder-scheduler[511962]: [parameters: {'topic_1': 'cinder-volume'}] Oct 17 19:14:30.205355 dv-cinder-861566-2-smb cinder-scheduler[511962]: (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 19:14:30.205355 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder Traceback (most recent call last): Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder self.dialect.do_execute( Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder cursor.execute(statement, parameters) Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder result = self._query(query) Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder conn.query(q) Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder result.read() Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder packet.raise_for_error() Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder raise errorclass(errno, errval) Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder pymysql.err.ProgrammingError: (1146, "Table 'cinder.services' doesn't exist") Oct 17 19:14:30.206311 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder The above exception was the direct cause of the following exception: Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder Traceback (most recent call last): Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/bin/cinder-scheduler", line 10, in Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder sys.exit(main()) Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/opt/stack/cinder/cinder/cmd/scheduler.py", line 59, in main Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder server = service.Service.create(binary='cinder-scheduler') Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 417, in create Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder service_obj = cls(host, binary, topic, manager, Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 158, in __init__ Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder self.manager = manager_class(host=self.host, Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/manager.py", line 103, in __init__ Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder self.driver = importutils.import_object(scheduler_driver) Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/filter_scheduler.py", line 48, in __init__ Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder super(FilterScheduler, self).__init__(*args, **kwargs) Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/driver.py", line 77, in __init__ Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder self.host_manager = importutils.import_object( Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 488, in __init__ Oct 17 19:14:30.207889 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder self._update_backend_state_map(cinder_context.get_admin_context()) Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 685, in _update_backend_state_map Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder volume_services = objects.ServiceList.get_all(context, Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/opt/stack/cinder/cinder/objects/service.py", line 224, in get_all Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder services = db.service_get_all(context, **(filters or {})) Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/opt/stack/cinder/cinder/db/api.py", line 286, in service_get_all Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder return IMPL.service_get_all(context, backend_match_level, **filters) Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 161, in wrapper Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder return f(*args, **kwargs) Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1010, in wrapper Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder return fn(*args, **kwargs) Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 914, in service_get_all Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder return [] if not query else query.all() Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2772, in all Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder return self._iter().all() Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2907, in _iter Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder result = self.session.execute( Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1712, in execute Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder result = conn._execute_20(statement, params or {}, execution_options) Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 Oct 17 19:14:30.209451 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder return meth(self, args_10style, kwargs_10style, execution_options) Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder return connection._execute_clauseelement( Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder ret = self._execute_context( Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder self._handle_dbapi_exception( Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder util.raise_(newraise, with_traceback=exc_info[2], from_=e) Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 208, in raise_ Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder raise exception Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder self.dialect.do_execute( Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder cursor.execute(statement, parameters) Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder result = self._query(query) Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder conn.query(q) Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 19:14:30.210567 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 19:14:30.211686 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder result.read() Oct 17 19:14:30.211686 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 19:14:30.211686 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 19:14:30.211686 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 19:14:30.211686 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder packet.raise_for_error() Oct 17 19:14:30.211686 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 19:14:30.211686 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 19:14:30.211686 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 19:14:30.211686 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder raise errorclass(errno, errval) Oct 17 19:14:30.211686 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 19:14:30.211686 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 19:14:30.211686 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder FROM services Oct 17 19:14:30.212327 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:14:30.212327 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder FROM clusters Oct 17 19:14:30.212327 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:14:30.212327 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder FROM clusters Oct 17 19:14:30.212327 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 19:14:30.212327 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder [parameters: {'topic_1': 'cinder-volume'}] Oct 17 19:14:30.212327 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 19:14:30.212327 dv-cinder-861566-2-smb cinder-scheduler[511962]: ERROR cinder Oct 17 19:14:30.605562 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Main process exited, code=exited, status=1/FAILURE Oct 17 19:14:30.605576 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Failed with result 'exit-code'. Oct 17 19:26:20.358860 dv-cinder-861566-2-smb systemd[1]: Started Devstack devstack@c-sch.service. Oct 17 19:26:23.443137 dv-cinder-861566-2-smb cinder-scheduler[576831]: INFO dbcounter [None req-bbd2120c-ac32-401d-9fe8-52fe1f4088f3 None None] Registered counter for database cinder Oct 17 19:26:23.462636 dv-cinder-861566-2-smb cinder-scheduler[576831]: DEBUG oslo_db.sqlalchemy.engines [None req-bbd2120c-ac32-401d-9fe8-52fe1f4088f3 None None] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION {{(pid=576831) _check_effective_sql_mode /usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/engines.py:314}} Oct 17 19:26:23.469090 dv-cinder-861566-2-smb cinder-scheduler[576831]: DEBUG dbcounter [-] [576831] Writer thread running {{(pid=576831) stat_writer /usr/local/lib/python3.8/dist-packages/dbcounter.py:99}} Oct 17 19:26:23.686752 dv-cinder-861566-2-smb cinder-scheduler[576831]: /usr/lib/python3/dist-packages/secretstorage/dhcrypto.py:15: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 19:26:23.686752 dv-cinder-861566-2-smb cinder-scheduler[576831]: from cryptography.utils import int_from_bytes Oct 17 19:26:23.686752 dv-cinder-861566-2-smb cinder-scheduler[576831]: /usr/lib/python3/dist-packages/secretstorage/util.py:19: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 19:26:23.686752 dv-cinder-861566-2-smb cinder-scheduler[576831]: from cryptography.utils import int_from_bytes Oct 17 19:26:23.700435 dv-cinder-861566-2-smb cinder-scheduler[576831]: CRITICAL cinder [None req-bbd2120c-ac32-401d-9fe8-52fe1f4088f3 None None] Unhandled error: sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 19:26:23.700435 dv-cinder-861566-2-smb cinder-scheduler[576831]: [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 19:26:23.700435 dv-cinder-861566-2-smb cinder-scheduler[576831]: FROM services Oct 17 19:26:23.700435 dv-cinder-861566-2-smb cinder-scheduler[576831]: WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:26:23.700435 dv-cinder-861566-2-smb cinder-scheduler[576831]: FROM clusters Oct 17 19:26:23.700435 dv-cinder-861566-2-smb cinder-scheduler[576831]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:26:23.700435 dv-cinder-861566-2-smb cinder-scheduler[576831]: FROM clusters Oct 17 19:26:23.700435 dv-cinder-861566-2-smb cinder-scheduler[576831]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 19:26:23.700435 dv-cinder-861566-2-smb cinder-scheduler[576831]: [parameters: {'topic_1': 'cinder-volume'}] Oct 17 19:26:23.700435 dv-cinder-861566-2-smb cinder-scheduler[576831]: (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 19:26:23.700435 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder Traceback (most recent call last): Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder self.dialect.do_execute( Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder cursor.execute(statement, parameters) Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder result = self._query(query) Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder conn.query(q) Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder result.read() Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder packet.raise_for_error() Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder raise errorclass(errno, errval) Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder pymysql.err.ProgrammingError: (1146, "Table 'cinder.services' doesn't exist") Oct 17 19:26:23.701321 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder The above exception was the direct cause of the following exception: Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder Traceback (most recent call last): Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/bin/cinder-scheduler", line 10, in Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder sys.exit(main()) Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/opt/stack/cinder/cinder/cmd/scheduler.py", line 59, in main Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder server = service.Service.create(binary='cinder-scheduler') Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 417, in create Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder service_obj = cls(host, binary, topic, manager, Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 158, in __init__ Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder self.manager = manager_class(host=self.host, Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/manager.py", line 103, in __init__ Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder self.driver = importutils.import_object(scheduler_driver) Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/filter_scheduler.py", line 48, in __init__ Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder super(FilterScheduler, self).__init__(*args, **kwargs) Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/driver.py", line 77, in __init__ Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder self.host_manager = importutils.import_object( Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 488, in __init__ Oct 17 19:26:23.703011 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder self._update_backend_state_map(cinder_context.get_admin_context()) Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 685, in _update_backend_state_map Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder volume_services = objects.ServiceList.get_all(context, Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/opt/stack/cinder/cinder/objects/service.py", line 224, in get_all Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder services = db.service_get_all(context, **(filters or {})) Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/opt/stack/cinder/cinder/db/api.py", line 286, in service_get_all Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder return IMPL.service_get_all(context, backend_match_level, **filters) Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 161, in wrapper Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder return f(*args, **kwargs) Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1010, in wrapper Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder return fn(*args, **kwargs) Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 914, in service_get_all Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder return [] if not query else query.all() Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2772, in all Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder return self._iter().all() Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2907, in _iter Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder result = self.session.execute( Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1712, in execute Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder result = conn._execute_20(statement, params or {}, execution_options) Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 Oct 17 19:26:23.704483 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder return meth(self, args_10style, kwargs_10style, execution_options) Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder return connection._execute_clauseelement( Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder ret = self._execute_context( Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder self._handle_dbapi_exception( Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder util.raise_(newraise, with_traceback=exc_info[2], from_=e) Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 208, in raise_ Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder raise exception Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder self.dialect.do_execute( Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder cursor.execute(statement, parameters) Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder result = self._query(query) Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder conn.query(q) Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 19:26:23.706972 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 19:26:23.709924 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder result.read() Oct 17 19:26:23.709924 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 19:26:23.709924 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 19:26:23.709924 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 19:26:23.709924 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder packet.raise_for_error() Oct 17 19:26:23.709924 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 19:26:23.709924 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 19:26:23.709924 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 19:26:23.709924 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder raise errorclass(errno, errval) Oct 17 19:26:23.709924 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 19:26:23.709924 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 19:26:23.709924 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder FROM services Oct 17 19:26:23.711572 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:26:23.711572 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder FROM clusters Oct 17 19:26:23.711572 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:26:23.711572 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder FROM clusters Oct 17 19:26:23.711572 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 19:26:23.711572 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder [parameters: {'topic_1': 'cinder-volume'}] Oct 17 19:26:23.711572 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 19:26:23.711572 dv-cinder-861566-2-smb cinder-scheduler[576831]: ERROR cinder Oct 17 19:26:24.106651 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Main process exited, code=exited, status=1/FAILURE Oct 17 19:26:24.106679 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Failed with result 'exit-code'. Oct 17 19:41:01.558190 dv-cinder-861566-2-smb systemd[1]: Started Devstack devstack@c-sch.service. Oct 17 19:41:04.587338 dv-cinder-861566-2-smb cinder-scheduler[647239]: INFO dbcounter [None req-9954bacc-e591-4db8-8c20-221dc9b9914c None None] Registered counter for database cinder Oct 17 19:41:04.605067 dv-cinder-861566-2-smb cinder-scheduler[647239]: DEBUG oslo_db.sqlalchemy.engines [None req-9954bacc-e591-4db8-8c20-221dc9b9914c None None] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION {{(pid=647239) _check_effective_sql_mode /usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/engines.py:314}} Oct 17 19:41:04.612818 dv-cinder-861566-2-smb cinder-scheduler[647239]: DEBUG dbcounter [-] [647239] Writer thread running {{(pid=647239) stat_writer /usr/local/lib/python3.8/dist-packages/dbcounter.py:99}} Oct 17 19:41:04.814414 dv-cinder-861566-2-smb cinder-scheduler[647239]: /usr/lib/python3/dist-packages/secretstorage/dhcrypto.py:15: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 19:41:04.814414 dv-cinder-861566-2-smb cinder-scheduler[647239]: from cryptography.utils import int_from_bytes Oct 17 19:41:04.814414 dv-cinder-861566-2-smb cinder-scheduler[647239]: /usr/lib/python3/dist-packages/secretstorage/util.py:19: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 19:41:04.814414 dv-cinder-861566-2-smb cinder-scheduler[647239]: from cryptography.utils import int_from_bytes Oct 17 19:41:04.826123 dv-cinder-861566-2-smb cinder-scheduler[647239]: CRITICAL cinder [None req-9954bacc-e591-4db8-8c20-221dc9b9914c None None] Unhandled error: sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 19:41:04.826123 dv-cinder-861566-2-smb cinder-scheduler[647239]: [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 19:41:04.826123 dv-cinder-861566-2-smb cinder-scheduler[647239]: FROM services Oct 17 19:41:04.826123 dv-cinder-861566-2-smb cinder-scheduler[647239]: WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:41:04.826123 dv-cinder-861566-2-smb cinder-scheduler[647239]: FROM clusters Oct 17 19:41:04.826123 dv-cinder-861566-2-smb cinder-scheduler[647239]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:41:04.826123 dv-cinder-861566-2-smb cinder-scheduler[647239]: FROM clusters Oct 17 19:41:04.826123 dv-cinder-861566-2-smb cinder-scheduler[647239]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 19:41:04.826123 dv-cinder-861566-2-smb cinder-scheduler[647239]: [parameters: {'topic_1': 'cinder-volume'}] Oct 17 19:41:04.826123 dv-cinder-861566-2-smb cinder-scheduler[647239]: (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 19:41:04.826123 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder Traceback (most recent call last): Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder self.dialect.do_execute( Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder cursor.execute(statement, parameters) Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder result = self._query(query) Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder conn.query(q) Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder result.read() Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder packet.raise_for_error() Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder raise errorclass(errno, errval) Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder pymysql.err.ProgrammingError: (1146, "Table 'cinder.services' doesn't exist") Oct 17 19:41:04.826769 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder The above exception was the direct cause of the following exception: Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder Traceback (most recent call last): Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/bin/cinder-scheduler", line 10, in Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder sys.exit(main()) Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/opt/stack/cinder/cinder/cmd/scheduler.py", line 59, in main Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder server = service.Service.create(binary='cinder-scheduler') Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 417, in create Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder service_obj = cls(host, binary, topic, manager, Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 158, in __init__ Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder self.manager = manager_class(host=self.host, Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/manager.py", line 103, in __init__ Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder self.driver = importutils.import_object(scheduler_driver) Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/filter_scheduler.py", line 48, in __init__ Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder super(FilterScheduler, self).__init__(*args, **kwargs) Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/driver.py", line 77, in __init__ Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder self.host_manager = importutils.import_object( Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 488, in __init__ Oct 17 19:41:04.827805 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder self._update_backend_state_map(cinder_context.get_admin_context()) Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 685, in _update_backend_state_map Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder volume_services = objects.ServiceList.get_all(context, Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/opt/stack/cinder/cinder/objects/service.py", line 224, in get_all Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder services = db.service_get_all(context, **(filters or {})) Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/opt/stack/cinder/cinder/db/api.py", line 286, in service_get_all Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder return IMPL.service_get_all(context, backend_match_level, **filters) Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 161, in wrapper Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder return f(*args, **kwargs) Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1010, in wrapper Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder return fn(*args, **kwargs) Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 914, in service_get_all Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder return [] if not query else query.all() Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2772, in all Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder return self._iter().all() Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2907, in _iter Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder result = self.session.execute( Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1712, in execute Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder result = conn._execute_20(statement, params or {}, execution_options) Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 Oct 17 19:41:04.828870 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder return meth(self, args_10style, kwargs_10style, execution_options) Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder return connection._execute_clauseelement( Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder ret = self._execute_context( Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder self._handle_dbapi_exception( Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder util.raise_(newraise, with_traceback=exc_info[2], from_=e) Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 208, in raise_ Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder raise exception Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder self.dialect.do_execute( Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder cursor.execute(statement, parameters) Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder result = self._query(query) Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder conn.query(q) Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 19:41:04.829850 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 19:41:04.832821 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder result.read() Oct 17 19:41:04.832821 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 19:41:04.832821 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 19:41:04.832821 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 19:41:04.832821 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder packet.raise_for_error() Oct 17 19:41:04.832821 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 19:41:04.832821 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 19:41:04.832821 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 19:41:04.832821 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder raise errorclass(errno, errval) Oct 17 19:41:04.832821 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 19:41:04.832821 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 19:41:04.832821 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder FROM services Oct 17 19:41:04.834639 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:41:04.834639 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder FROM clusters Oct 17 19:41:04.834639 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:41:04.834639 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder FROM clusters Oct 17 19:41:04.834639 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 19:41:04.834639 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder [parameters: {'topic_1': 'cinder-volume'}] Oct 17 19:41:04.834639 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 19:41:04.834639 dv-cinder-861566-2-smb cinder-scheduler[647239]: ERROR cinder Oct 17 19:41:05.226079 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Main process exited, code=exited, status=1/FAILURE Oct 17 19:41:05.226101 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Failed with result 'exit-code'. Oct 17 19:53:11.169753 dv-cinder-861566-2-smb systemd[1]: Started Devstack devstack@c-sch.service. Oct 17 19:53:14.181385 dv-cinder-861566-2-smb cinder-scheduler[712026]: INFO dbcounter [None req-d48fc860-6fe5-4fc3-aad8-094015bcf655 None None] Registered counter for database cinder Oct 17 19:53:14.200295 dv-cinder-861566-2-smb cinder-scheduler[712026]: DEBUG oslo_db.sqlalchemy.engines [None req-d48fc860-6fe5-4fc3-aad8-094015bcf655 None None] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION {{(pid=712026) _check_effective_sql_mode /usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/engines.py:314}} Oct 17 19:53:14.209622 dv-cinder-861566-2-smb cinder-scheduler[712026]: DEBUG dbcounter [-] [712026] Writer thread running {{(pid=712026) stat_writer /usr/local/lib/python3.8/dist-packages/dbcounter.py:99}} Oct 17 19:53:14.420094 dv-cinder-861566-2-smb cinder-scheduler[712026]: /usr/lib/python3/dist-packages/secretstorage/dhcrypto.py:15: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 19:53:14.420094 dv-cinder-861566-2-smb cinder-scheduler[712026]: from cryptography.utils import int_from_bytes Oct 17 19:53:14.420094 dv-cinder-861566-2-smb cinder-scheduler[712026]: /usr/lib/python3/dist-packages/secretstorage/util.py:19: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 19:53:14.420094 dv-cinder-861566-2-smb cinder-scheduler[712026]: from cryptography.utils import int_from_bytes Oct 17 19:53:14.431419 dv-cinder-861566-2-smb cinder-scheduler[712026]: CRITICAL cinder [None req-d48fc860-6fe5-4fc3-aad8-094015bcf655 None None] Unhandled error: sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 19:53:14.431419 dv-cinder-861566-2-smb cinder-scheduler[712026]: [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 19:53:14.431419 dv-cinder-861566-2-smb cinder-scheduler[712026]: FROM services Oct 17 19:53:14.431419 dv-cinder-861566-2-smb cinder-scheduler[712026]: WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:53:14.431419 dv-cinder-861566-2-smb cinder-scheduler[712026]: FROM clusters Oct 17 19:53:14.431419 dv-cinder-861566-2-smb cinder-scheduler[712026]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:53:14.431419 dv-cinder-861566-2-smb cinder-scheduler[712026]: FROM clusters Oct 17 19:53:14.431419 dv-cinder-861566-2-smb cinder-scheduler[712026]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 19:53:14.431419 dv-cinder-861566-2-smb cinder-scheduler[712026]: [parameters: {'topic_1': 'cinder-volume'}] Oct 17 19:53:14.431419 dv-cinder-861566-2-smb cinder-scheduler[712026]: (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 19:53:14.431419 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder Traceback (most recent call last): Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder self.dialect.do_execute( Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder cursor.execute(statement, parameters) Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder result = self._query(query) Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder conn.query(q) Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder result.read() Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder packet.raise_for_error() Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder raise errorclass(errno, errval) Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder pymysql.err.ProgrammingError: (1146, "Table 'cinder.services' doesn't exist") Oct 17 19:53:14.432335 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder The above exception was the direct cause of the following exception: Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder Traceback (most recent call last): Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/bin/cinder-scheduler", line 10, in Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder sys.exit(main()) Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/opt/stack/cinder/cinder/cmd/scheduler.py", line 59, in main Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder server = service.Service.create(binary='cinder-scheduler') Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 417, in create Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder service_obj = cls(host, binary, topic, manager, Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 158, in __init__ Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder self.manager = manager_class(host=self.host, Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/manager.py", line 103, in __init__ Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder self.driver = importutils.import_object(scheduler_driver) Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/filter_scheduler.py", line 48, in __init__ Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder super(FilterScheduler, self).__init__(*args, **kwargs) Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/driver.py", line 77, in __init__ Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder self.host_manager = importutils.import_object( Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 488, in __init__ Oct 17 19:53:14.433786 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder self._update_backend_state_map(cinder_context.get_admin_context()) Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 685, in _update_backend_state_map Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder volume_services = objects.ServiceList.get_all(context, Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/opt/stack/cinder/cinder/objects/service.py", line 224, in get_all Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder services = db.service_get_all(context, **(filters or {})) Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/opt/stack/cinder/cinder/db/api.py", line 286, in service_get_all Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder return IMPL.service_get_all(context, backend_match_level, **filters) Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 161, in wrapper Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder return f(*args, **kwargs) Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1010, in wrapper Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder return fn(*args, **kwargs) Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 914, in service_get_all Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder return [] if not query else query.all() Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2772, in all Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder return self._iter().all() Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2907, in _iter Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder result = self.session.execute( Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1712, in execute Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder result = conn._execute_20(statement, params or {}, execution_options) Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 Oct 17 19:53:14.435297 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder return meth(self, args_10style, kwargs_10style, execution_options) Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder return connection._execute_clauseelement( Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder ret = self._execute_context( Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder self._handle_dbapi_exception( Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder util.raise_(newraise, with_traceback=exc_info[2], from_=e) Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 208, in raise_ Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder raise exception Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder self.dialect.do_execute( Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder cursor.execute(statement, parameters) Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder result = self._query(query) Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder conn.query(q) Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 19:53:14.436606 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 19:53:14.438005 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder result.read() Oct 17 19:53:14.438005 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 19:53:14.438005 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 19:53:14.438005 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 19:53:14.438005 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder packet.raise_for_error() Oct 17 19:53:14.438005 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 19:53:14.438005 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 19:53:14.438005 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 19:53:14.438005 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder raise errorclass(errno, errval) Oct 17 19:53:14.438005 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 19:53:14.438005 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 19:53:14.438005 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder FROM services Oct 17 19:53:14.438802 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:53:14.438802 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder FROM clusters Oct 17 19:53:14.438802 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 19:53:14.438802 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder FROM clusters Oct 17 19:53:14.438802 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 19:53:14.438802 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder [parameters: {'topic_1': 'cinder-volume'}] Oct 17 19:53:14.438802 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 19:53:14.438802 dv-cinder-861566-2-smb cinder-scheduler[712026]: ERROR cinder Oct 17 19:53:14.836617 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Main process exited, code=exited, status=1/FAILURE Oct 17 19:53:14.836630 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Failed with result 'exit-code'. Oct 17 20:05:08.938953 dv-cinder-861566-2-smb systemd[1]: Started Devstack devstack@c-sch.service. Oct 17 20:05:11.946662 dv-cinder-861566-2-smb cinder-scheduler[776917]: INFO dbcounter [None req-cda371db-d840-4d8a-83ec-e306f202600f None None] Registered counter for database cinder Oct 17 20:05:11.965015 dv-cinder-861566-2-smb cinder-scheduler[776917]: DEBUG oslo_db.sqlalchemy.engines [None req-cda371db-d840-4d8a-83ec-e306f202600f None None] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION {{(pid=776917) _check_effective_sql_mode /usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/engines.py:314}} Oct 17 20:05:11.972170 dv-cinder-861566-2-smb cinder-scheduler[776917]: DEBUG dbcounter [-] [776917] Writer thread running {{(pid=776917) stat_writer /usr/local/lib/python3.8/dist-packages/dbcounter.py:99}} Oct 17 20:05:12.183220 dv-cinder-861566-2-smb cinder-scheduler[776917]: /usr/lib/python3/dist-packages/secretstorage/dhcrypto.py:15: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 20:05:12.183220 dv-cinder-861566-2-smb cinder-scheduler[776917]: from cryptography.utils import int_from_bytes Oct 17 20:05:12.183220 dv-cinder-861566-2-smb cinder-scheduler[776917]: /usr/lib/python3/dist-packages/secretstorage/util.py:19: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 20:05:12.183220 dv-cinder-861566-2-smb cinder-scheduler[776917]: from cryptography.utils import int_from_bytes Oct 17 20:05:12.194856 dv-cinder-861566-2-smb cinder-scheduler[776917]: CRITICAL cinder [None req-cda371db-d840-4d8a-83ec-e306f202600f None None] Unhandled error: sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 20:05:12.194856 dv-cinder-861566-2-smb cinder-scheduler[776917]: [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 20:05:12.194856 dv-cinder-861566-2-smb cinder-scheduler[776917]: FROM services Oct 17 20:05:12.194856 dv-cinder-861566-2-smb cinder-scheduler[776917]: WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 20:05:12.194856 dv-cinder-861566-2-smb cinder-scheduler[776917]: FROM clusters Oct 17 20:05:12.194856 dv-cinder-861566-2-smb cinder-scheduler[776917]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 20:05:12.194856 dv-cinder-861566-2-smb cinder-scheduler[776917]: FROM clusters Oct 17 20:05:12.194856 dv-cinder-861566-2-smb cinder-scheduler[776917]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 20:05:12.194856 dv-cinder-861566-2-smb cinder-scheduler[776917]: [parameters: {'topic_1': 'cinder-volume'}] Oct 17 20:05:12.194856 dv-cinder-861566-2-smb cinder-scheduler[776917]: (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 20:05:12.194856 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder Traceback (most recent call last): Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder self.dialect.do_execute( Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder cursor.execute(statement, parameters) Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder result = self._query(query) Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder conn.query(q) Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder result.read() Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder packet.raise_for_error() Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder raise errorclass(errno, errval) Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder pymysql.err.ProgrammingError: (1146, "Table 'cinder.services' doesn't exist") Oct 17 20:05:12.195683 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder The above exception was the direct cause of the following exception: Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder Traceback (most recent call last): Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/bin/cinder-scheduler", line 10, in Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder sys.exit(main()) Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/opt/stack/cinder/cinder/cmd/scheduler.py", line 59, in main Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder server = service.Service.create(binary='cinder-scheduler') Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 417, in create Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder service_obj = cls(host, binary, topic, manager, Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 158, in __init__ Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder self.manager = manager_class(host=self.host, Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/manager.py", line 103, in __init__ Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder self.driver = importutils.import_object(scheduler_driver) Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/filter_scheduler.py", line 48, in __init__ Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder super(FilterScheduler, self).__init__(*args, **kwargs) Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/driver.py", line 77, in __init__ Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder self.host_manager = importutils.import_object( Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 488, in __init__ Oct 17 20:05:12.196881 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder self._update_backend_state_map(cinder_context.get_admin_context()) Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 685, in _update_backend_state_map Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder volume_services = objects.ServiceList.get_all(context, Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/opt/stack/cinder/cinder/objects/service.py", line 224, in get_all Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder services = db.service_get_all(context, **(filters or {})) Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/opt/stack/cinder/cinder/db/api.py", line 286, in service_get_all Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder return IMPL.service_get_all(context, backend_match_level, **filters) Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 161, in wrapper Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder return f(*args, **kwargs) Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1010, in wrapper Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder return fn(*args, **kwargs) Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 914, in service_get_all Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder return [] if not query else query.all() Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2772, in all Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder return self._iter().all() Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2907, in _iter Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder result = self.session.execute( Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1712, in execute Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder result = conn._execute_20(statement, params or {}, execution_options) Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 Oct 17 20:05:12.198271 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder return meth(self, args_10style, kwargs_10style, execution_options) Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder return connection._execute_clauseelement( Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder ret = self._execute_context( Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder self._handle_dbapi_exception( Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder util.raise_(newraise, with_traceback=exc_info[2], from_=e) Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 208, in raise_ Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder raise exception Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder self.dialect.do_execute( Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder cursor.execute(statement, parameters) Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder result = self._query(query) Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder conn.query(q) Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 20:05:12.199388 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 20:05:12.200606 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder result.read() Oct 17 20:05:12.200606 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 20:05:12.200606 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 20:05:12.200606 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 20:05:12.200606 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder packet.raise_for_error() Oct 17 20:05:12.200606 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 20:05:12.200606 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 20:05:12.200606 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 20:05:12.200606 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder raise errorclass(errno, errval) Oct 17 20:05:12.200606 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 20:05:12.200606 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 20:05:12.200606 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder FROM services Oct 17 20:05:12.201324 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 20:05:12.201324 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder FROM clusters Oct 17 20:05:12.201324 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 20:05:12.201324 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder FROM clusters Oct 17 20:05:12.201324 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 20:05:12.201324 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder [parameters: {'topic_1': 'cinder-volume'}] Oct 17 20:05:12.201324 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 20:05:12.201324 dv-cinder-861566-2-smb cinder-scheduler[776917]: ERROR cinder Oct 17 20:05:12.600928 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Main process exited, code=exited, status=1/FAILURE Oct 17 20:05:12.600956 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Failed with result 'exit-code'. Oct 17 20:17:07.248596 dv-cinder-861566-2-smb systemd[1]: Started Devstack devstack@c-sch.service. Oct 17 20:17:10.287349 dv-cinder-861566-2-smb cinder-scheduler[841445]: INFO dbcounter [None req-0ae4db76-d6ab-4dd4-8998-e0135941f8dc None None] Registered counter for database cinder Oct 17 20:17:10.306739 dv-cinder-861566-2-smb cinder-scheduler[841445]: DEBUG oslo_db.sqlalchemy.engines [None req-0ae4db76-d6ab-4dd4-8998-e0135941f8dc None None] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION {{(pid=841445) _check_effective_sql_mode /usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/engines.py:314}} Oct 17 20:17:10.313341 dv-cinder-861566-2-smb cinder-scheduler[841445]: DEBUG dbcounter [-] [841445] Writer thread running {{(pid=841445) stat_writer /usr/local/lib/python3.8/dist-packages/dbcounter.py:99}} Oct 17 20:17:10.522936 dv-cinder-861566-2-smb cinder-scheduler[841445]: /usr/lib/python3/dist-packages/secretstorage/dhcrypto.py:15: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 20:17:10.522936 dv-cinder-861566-2-smb cinder-scheduler[841445]: from cryptography.utils import int_from_bytes Oct 17 20:17:10.522936 dv-cinder-861566-2-smb cinder-scheduler[841445]: /usr/lib/python3/dist-packages/secretstorage/util.py:19: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead Oct 17 20:17:10.522936 dv-cinder-861566-2-smb cinder-scheduler[841445]: from cryptography.utils import int_from_bytes Oct 17 20:17:10.535897 dv-cinder-861566-2-smb cinder-scheduler[841445]: CRITICAL cinder [None req-0ae4db76-d6ab-4dd4-8998-e0135941f8dc None None] Unhandled error: sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 20:17:10.535897 dv-cinder-861566-2-smb cinder-scheduler[841445]: [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 20:17:10.535897 dv-cinder-861566-2-smb cinder-scheduler[841445]: FROM services Oct 17 20:17:10.535897 dv-cinder-861566-2-smb cinder-scheduler[841445]: WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 20:17:10.535897 dv-cinder-861566-2-smb cinder-scheduler[841445]: FROM clusters Oct 17 20:17:10.535897 dv-cinder-861566-2-smb cinder-scheduler[841445]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 20:17:10.535897 dv-cinder-861566-2-smb cinder-scheduler[841445]: FROM clusters Oct 17 20:17:10.535897 dv-cinder-861566-2-smb cinder-scheduler[841445]: WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 20:17:10.535897 dv-cinder-861566-2-smb cinder-scheduler[841445]: [parameters: {'topic_1': 'cinder-volume'}] Oct 17 20:17:10.535897 dv-cinder-861566-2-smb cinder-scheduler[841445]: (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 20:17:10.535897 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder Traceback (most recent call last): Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder self.dialect.do_execute( Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder cursor.execute(statement, parameters) Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder result = self._query(query) Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder conn.query(q) Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder result.read() Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder packet.raise_for_error() Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder raise errorclass(errno, errval) Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder pymysql.err.ProgrammingError: (1146, "Table 'cinder.services' doesn't exist") Oct 17 20:17:10.536846 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder The above exception was the direct cause of the following exception: Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder Traceback (most recent call last): Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/bin/cinder-scheduler", line 10, in Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder sys.exit(main()) Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/opt/stack/cinder/cinder/cmd/scheduler.py", line 59, in main Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder server = service.Service.create(binary='cinder-scheduler') Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 417, in create Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder service_obj = cls(host, binary, topic, manager, Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/opt/stack/cinder/cinder/service.py", line 158, in __init__ Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder self.manager = manager_class(host=self.host, Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/manager.py", line 103, in __init__ Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder self.driver = importutils.import_object(scheduler_driver) Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/filter_scheduler.py", line 48, in __init__ Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder super(FilterScheduler, self).__init__(*args, **kwargs) Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/driver.py", line 77, in __init__ Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder self.host_manager = importutils.import_object( Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_utils/importutils.py", line 44, in import_object Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder return import_class(import_str)(*args, **kwargs) Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 488, in __init__ Oct 17 20:17:10.538346 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder self._update_backend_state_map(cinder_context.get_admin_context()) Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/opt/stack/cinder/cinder/scheduler/host_manager.py", line 685, in _update_backend_state_map Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder volume_services = objects.ServiceList.get_all(context, Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/opt/stack/cinder/cinder/objects/service.py", line 224, in get_all Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder services = db.service_get_all(context, **(filters or {})) Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/opt/stack/cinder/cinder/db/api.py", line 286, in service_get_all Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder return IMPL.service_get_all(context, backend_match_level, **filters) Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 161, in wrapper Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder return f(*args, **kwargs) Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1010, in wrapper Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder return fn(*args, **kwargs) Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 914, in service_get_all Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder return [] if not query else query.all() Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2772, in all Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder return self._iter().all() Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/query.py", line 2907, in _iter Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder result = self.session.execute( Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1712, in execute Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder result = conn._execute_20(statement, params or {}, execution_options) Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 Oct 17 20:17:10.541512 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder return meth(self, args_10style, kwargs_10style, execution_options) Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder return connection._execute_clauseelement( Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder ret = self._execute_context( Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder self._handle_dbapi_exception( Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder util.raise_(newraise, with_traceback=exc_info[2], from_=e) Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 208, in raise_ Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder raise exception Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder self.dialect.do_execute( Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder cursor.execute(statement, parameters) Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder result = self._query(query) Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder conn.query(q) Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder self._affected_rows = self._read_query_result(unbuffered=unbuffered) Oct 17 20:17:10.542914 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Oct 17 20:17:10.544198 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder result.read() Oct 17 20:17:10.544198 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Oct 17 20:17:10.544198 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder first_packet = self.connection._read_packet() Oct 17 20:17:10.544198 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Oct 17 20:17:10.544198 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder packet.raise_for_error() Oct 17 20:17:10.544198 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Oct 17 20:17:10.544198 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder err.raise_mysql_exception(self._data) Oct 17 20:17:10.544198 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Oct 17 20:17:10.544198 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder raise errorclass(errno, errval) Oct 17 20:17:10.544198 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.services' doesn't exist") Oct 17 20:17:10.544198 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder [SQL: SELECT services.created_at AS services_created_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.cluster_name AS services_cluster_name, services.host AS services_host, services.`binary` AS services_binary, services.updated_at AS services_updated_at, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone, services.disabled_reason AS services_disabled_reason, services.modified_at AS services_modified_at, services.rpc_current_version AS services_rpc_current_version, services.object_current_version AS services_object_current_version, services.replication_status AS services_replication_status, services.active_backend_id AS services_active_backend_id, services.frozen AS services_frozen Oct 17 20:17:10.544198 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder FROM services Oct 17 20:17:10.545015 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder WHERE services.deleted = false AND NOT (services.cluster_name IS NULL AND services.disabled = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 20:17:10.545015 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder FROM clusters Oct 17 20:17:10.545015 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.disabled = 1))) AND NOT (services.cluster_name IS NULL AND services.frozen = 1 OR services.cluster_name IS NOT NULL AND (EXISTS (SELECT * Oct 17 20:17:10.545015 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder FROM clusters Oct 17 20:17:10.545015 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder WHERE clusters.name = services.cluster_name AND clusters.`binary` = services.`binary` AND clusters.deleted = 0 AND clusters.frozen = 1))) AND services.topic = %(topic_1)s] Oct 17 20:17:10.545015 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder [parameters: {'topic_1': 'cinder-volume'}] Oct 17 20:17:10.545015 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder (Background on this error at: https://sqlalche.me/e/14/f405) Oct 17 20:17:10.545015 dv-cinder-861566-2-smb cinder-scheduler[841445]: ERROR cinder Oct 17 20:17:10.948643 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Main process exited, code=exited, status=1/FAILURE Oct 17 20:17:10.948673 dv-cinder-861566-2-smb systemd[1]: devstack@c-sch.service: Failed with result 'exit-code'.