为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:Linux
【CPU】:
【问题描述】*:
python flask 框架内进行数据库表查询发生异常:Error
dmPython.DatabaseError: [CODE:-70028]创建SOCKET连接失败
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "D:\project\nari\py_demo\tests\data_quality_change_monitor_test.py", line 10, in test_alarm
data_quality_change_monitor.alarm()
File "D:\project\nari\py_demo\src\service\data_quality_change_monitor.py", line 28, in alarm
monitor_result = DataQualityChangeMonitor(cache_initializer=CacheInitializer("data_quality")).differ()
File "D:\project\nari\py_demo\src\utils\data_change_monitor.py", line 55, in init
self.get_current_data()
File "D:\project\nari\py_demo\src\service\data_quality_change_monitor.py", line 15, in get_current_data
data = WjzDataStatusNew.query.all()
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\orm\query.py", line 2693, in all
return self._iter().all() # type: ignore
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\orm\query.py", line 2847, in _iter
result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\orm\session.py", line 2306, in execute
return self._execute_internal(
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\orm\session.py", line 2178, in _execute_internal
conn = self._connection_for_bind(bind)
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\orm\session.py", line 2045, in _connection_for_bind
return trans._connection_for_bind(engine, execution_options)
File "<string>", line 2, in _connection_for_bind
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\orm\state_changes.py", line 139, in _go
ret_value = fn(self, *arg, **kw)
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\orm\session.py", line 1143, in _connection_for_bind
conn = bind.connect()
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\engine\base.py", line 3268, in connect
return self._connection_cls(self)
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\engine\base.py", line 145, in init
self._dbapi_connection = engine.raw_connection()
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\engine\base.py", line 3292, in raw_connection
return self.pool.connect()
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\pool\base.py", line 452, in connect
return _ConnectionFairy._checkout(self)
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\pool\base.py", line 1269, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\pool\base.py", line 716, in checkout
rec = pool._do_get()
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\pool\impl.py", line 170, in _do_get
self._dec_overflow()
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in exit
raise exc_value.with_traceback(exc_tb)
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\pool\impl.py", line 167, in _do_get
return self._create_connection()
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\pool\base.py", line 393, in _create_connection
return _ConnectionRecord(self)
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\pool\base.py", line 678, in init
self.__connect()
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\pool\base.py", line 903, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in exit
raise exc_value.with_traceback(exc_tb)
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\pool\base.py", line 898, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy\engine\create.py", line 637, in connect
return dialect.connect(*cargs, **cparams)
File "D:\DevelopTool\python\3.9.13\lib\site-packages\sqlalchemy_dm-2.0.0-py3.9.egg\sqlalchemy_dm\dmPython.py", line 309, in connect
conn = self.dbapi.connect(*cargs, **cparams)
SystemError: <class 'dmPython.Connection'> returned a result with an error set
已解决,host 地址写错了!无语~
disql能连上吗?连接数据库的配置发一下