【 使用环境 】测试环境
【 OB or 其他组件 】OMS
【 使用版本 】4.2.9-ce
【问题描述】单体部署模式启动部署工具后提示初始化失败
【复现路径】sh docker_remote_deploy.sh -o <OMS 容器挂载目录> -i <本机 IP 地址> -d <OMS_IMAGE>
【附件及日志】
2025-06-16 15:00:56,390-Oms-DEBUG units.create_engine_wrapper.70 :create a new sqlalchemy engine wrapped Engine(mysql+pymysql://root:***@172.16.2.42:2883/oms_cm?charset=utf8)
Traceback (most recent call last):
File “/usr/lib64/python2.7/runpy.py”, line 162, in _run_module_as_main
“main”, fname, loader, pkg_name)
File “/usr/lib64/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/root/omsflow/scripts/units/oms_init_manager.py”, line 1230, in
main()
File “/root/omsflow/scripts/units/oms_init_manager.py”, line 1209, in main
init_manager.init_data()
File “/root/omsflow/scripts/units/oms_init_manager.py”, line 692, in init_data
self.init_cm()
File “/root/omsflow/scripts/units/oms_init_manager.py”, line 728, in init_cm
cm_engine = self.get_cm_engine()
File “/root/omsflow/scripts/units/oms_init_manager.py”, line 72, in get_cm_engine
return self.get_safe_engine(’_drc_cm_meta_uri’)
File “/root/omsflow/scripts/units/oms_init_manager.py”, line 54, in get_safe_engine
if not database_exists(engine.url):
File “/usr/lib/python2.7/site-packages/sqlalchemy_utils/functions/database.py”, line 479, in database_exists
return bool(get_scalar_result(engine, text))
File “/usr/lib/python2.7/site-packages/sqlalchemy_utils/functions/database.py”, line 448, in get_scalar_result
result_proxy = engine.execute(sql)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py”, line 2165, in execute
connection = self._contextual_connect(close_with_result=True)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py”, line 2226, in _contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py”, line 2266, in _wrap_pool_connect
e, dialect, self
File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py”, line 1536, in _handle_dbapi_exception_noconnection
util.raise_from_cause(sqlalchemy_exception, exc_info)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py”, line 383, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py”, line 2262, in _wrap_pool_connect
return fn()
File “/usr/lib64/python2.7/site-packages/sqlalchemy/pool/base.py”, line 354, in connect
return _ConnectionFairy._checkout(self)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/pool/base.py”, line 751, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/pool/base.py”, line 483, in checkout
rec = pool._do_get()
File “/usr/lib64/python2.7/site-packages/sqlalchemy/pool/impl.py”, line 138, in _do_get
self._dec_overflow()
File “/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py”, line 68, in exit
compat.reraise(exc_type, exc_value, exc_tb)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/pool/impl.py”, line 135, in _do_get
return self._create_connection()
File “/usr/lib64/python2.7/site-packages/sqlalchemy/pool/base.py”, line 299, in _create_connection
return _ConnectionRecord(self)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/pool/base.py”, line 428, in init
self.__connect(first_connect_check=True)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/pool/base.py”, line 630, in __connect
connection = pool._invoke_creator(self)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/strategies.py”, line 114, in connect
return dialect.connect(*cargs, **cparams)
File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py”, line 453, in connect
return self.dbapi.connect(*cargs, **cparams)
File “/usr/lib/python2.7/site-packages/pymysql/init.py”, line 94, in Connect
return Connection(*args, **kwargs)
File “/usr/lib/python2.7/site-packages/pymysql/connections.py”, line 327, in init
self.connect()
File “/usr/lib/python2.7/site-packages/pymysql/connections.py”, line 587, in connect
self._get_server_information()
File “/usr/lib/python2.7/site-packages/pymysql/connections.py”, line 969, in _get_server_information
packet = self._read_packet()
File “/usr/lib/python2.7/site-packages/pymysql/connections.py”, line 646, in _read_packet
packet_header = self._read_bytes(4)
File “/usr/lib/python2.7/site-packages/pymysql/connections.py”, line 699, in _read_bytes
CR.CR_SERVER_LOST, “Lost connection to MySQL server during query”)
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, ‘Lost connection to MySQL server during query’)
(Background on this error at: http://sqlalche.me/e/e3q8)
【结束】初始化失败，当前命令: python -m omsflow.scripts.units.oms_init_manager --init-db
【备注】
