【E - QS Network】

本文深入探讨了最小生成树算法的一个特殊应用场景,其中边的权重由基础权重加上两个顶点的特定值构成。通过详细解释代码实现,包括初始化、松弛操作和Prim算法的具体步骤,帮助读者理解如何高效地求解此类问题。

思路:

  • 最小生成树,唯一特殊在于 mp[i][j] = w + p[i] + p[j]

代码:

  • 60ms 4244kB
//60ms		4244kB


#include <iostream>
#include <cstring>
#include <cstdio>
#include <queue>
#define INF 0x3f3f3f3f

using namespace std;

const int maxn = 1005;

int N;
int ans;
int mp[maxn][maxn];
int p[maxn];
bool vis[maxn];
int dis[maxn];
struct NODE{
	int id;
	int dis;
	friend bool operator > (NODE a , NODE b)
	{
		return a.dis > b.dis;
	}
	NODE(int id,int dis) : id(id) , dis(dis) {} ;
};
priority_queue <NODE , vector<NODE> , greater<NODE> > Q;

void INIT(){
	ans = 0;
	memset(vis , 0 , sizeof(vis));
	memset(dis , INF , sizeof(dis));
	return ;
}

void PRIM(){
	dis[1] = 0;
	Q.push(NODE(1 , 0));
	while(Q.size()){
		NODE cur = Q.top() ; Q.pop() ;
		int id = cur.id ;
		if(vis[id])
			continue;
		ans += dis[id];
		vis[id] = true;
		for(int i=1;i<=N;i++)
			if(!vis[i] && dis[i] > mp[id][i]){
				dis[i] = mp[id][i];
				Q.push(NODE(i , dis[i]));
			}
	}
	return ;
}

int main(){
	int T;cin>>T;
	while(T--){
		INIT();
		cin>>N;
		for(int i=1;i<=N;i++)
			scanf("%d" , p+i);
		for(int i=1;i<=N;i++)
			for(int j=1;j<=N;j++){
				int w;
				scanf("%d" , &w);
				mp[i][j] = w + p[i] + p[j] ;
			}
		PRIM();
		cout<<ans<<endl;
	}
	return 0;
}
Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: 2025-11-05 11:07:00,598:ERROR:superset.views.error_handling:'username' Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: Traceback (most recent call last): Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "src/pymssql/_pymssql.pyx", line 650, in pymssql._pymssql.connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "src/pymssql/_mssql.pyx", line 2158, in pymssql._mssql.connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "src/pymssql/_mssql.pyx", line 712, in pymssql._mssql.MSSQLConnection.__init__ Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "src/pymssql/_mssql.pyx", line 1884, in pymssql._mssql.maybe_raise_MSSQLDatabaseException Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "src/pymssql/_mssql.pyx", line 1901, in pymssql._mssql.raise_MSSQLDatabaseException Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: pymssql._mssql.MSSQLDatabaseException: (20002, b'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.110.219)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.110.219)\n') Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: During handling of the above exception, another exception occurred: Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: Traceback (most recent call last): Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3371, in _wrap_pool_connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return fn() Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 327, in connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return _ConnectionFairy._checkout(self) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 894, in _checkout Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: fairy = _ConnectionRecord.checkout(pool) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 493, in checkout Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: rec = pool._do_get() Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 256, in _do_get Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self._create_connection() Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 273, in _create_connection Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return _ConnectionRecord(self) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 388, in __init__ Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: self.__connect() Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 690, in __connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: with util.safe_reraise(): Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: compat.raise_( Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: raise exception Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 686, in __connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: self.dbapi_connection = connection = pool._invoke_creator(self) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 574, in connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return dialect.connect(*cargs, **cparams) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 598, in connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self.dbapi.connect(*cargs, **cparams) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "src/pymssql/_pymssql.pyx", line 659, in pymssql._pymssql.connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: pymssql.exceptions.OperationalError: (20002, b'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.110.219)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.110.219)\n') Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: The above exception was the direct cause of the following exception: Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: Traceback (most recent call last): Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/connectors/sqla/models.py", line 1748, in query Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: df = self.database.get_df( Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/models/core.py", line 695, in get_df Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: with self.get_raw_connection(catalog=catalog, schema=schema) as conn: Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/usr/lib/python3.10/contextlib.py", line 135, in __enter__ Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return next(self.gen) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/models/core.py", line 592, in get_raw_connection Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: with closing(engine.raw_connection()) as conn: Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3404, in raw_connection Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self._wrap_pool_connect(self.pool.connect, _connection) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3374, in _wrap_pool_connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: Connection._handle_dbapi_exception_noconnection( Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2208, in _handle_dbapi_exception_noconnection Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: util.raise_( Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: raise exception Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3371, in _wrap_pool_connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return fn() Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 327, in connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return _ConnectionFairy._checkout(self) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 894, in _checkout Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: fairy = _ConnectionRecord.checkout(pool) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 493, in checkout Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: rec = pool._do_get() Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 256, in _do_get Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self._create_connection() Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 273, in _create_connection Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return _ConnectionRecord(self) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 388, in __init__ Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: self.__connect() Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 690, in __connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: with util.safe_reraise(): Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: compat.raise_( Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: raise exception Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 686, in __connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: self.dbapi_connection = connection = pool._invoke_creator(self) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 574, in connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return dialect.connect(*cargs, **cparams) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 598, in connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self.dbapi.connect(*cargs, **cparams) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "src/pymssql/_pymssql.pyx", line 659, in pymssql._pymssql.connect Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: sqlalchemy.exc.OperationalError: (pymssql.exceptions.OperationalError) (20002, b'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.110.219)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.110.219)\n') Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: (Background on this error at: https://sqlalche.me/e/14/e3q8) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: During handling of the above exception, another exception occurred: Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: Traceback (most recent call last): Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: rv = self.dispatch_request() Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 109, in wraps Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return f(self, *args, **kwargs) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/views/base_api.py", line 120, in wraps Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: duration, response = time_function(f, self, *args, **kwargs) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/utils/core.py", line 1369, in time_function Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: response = func(*args, **kwargs) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/utils/log.py", line 304, in wrapper Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: value = f(*args, **kwargs) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/charts/data/api.py", line 260, in data Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self._get_data_response( Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/utils/log.py", line 304, in wrapper Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: value = f(*args, **kwargs) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/charts/data/api.py", line 423, in _get_data_response Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: result = command.run(force_cached=force_cached) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/commands/chart/data/get_data_command.py", line 45, in run Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: payload = self._query_context.get_payload( Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/common/query_context.py", line 102, in get_payload Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self._processor.get_payload(cache_query_context, force_cached) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/common/query_context_processor.py", line 752, in get_payload Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: query_results = [ Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/common/query_context_processor.py", line 753, in <listcomp> Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: get_query_results( Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/common/query_actions.py", line 227, in get_query_results Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return result_func(query_context, query_obj, force_cached) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/common/query_actions.py", line 103, in _get_full Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: payload = query_context.get_df_payload(query_obj, force_cached=force_cached) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/common/query_context.py", line 123, in get_df_payload Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self._processor.get_df_payload( Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/common/query_context_processor.py", line 162, in get_df_payload Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: query_result = self.get_query_result(query_obj) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/common/query_context_processor.py", line 265, in get_query_result Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: result = query_context.datasource.query(query_object.to_dict()) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/connectors/sqla/models.py", line 1770, in query Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: dataclasses.asdict(error) for error in db_engine_spec.extract_errors(ex) Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/db_engine_specs/base.py", line 1378, in extract_errors Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: message=message % params, Nov 05 11:07:00 DESKTOP-9QS7RL5 start_superset.sh[50500]: KeyError: 'username'
11-06
Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: 2025-11-05 10:22:59,392:ERROR:superset.views.error_handling:'username' Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: Traceback (most recent call last): Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "src/pymssql/_pymssql.pyx", line 650, in pymssql._pymssql.connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "src/pymssql/_mssql.pyx", line 2158, in pymssql._mssql.connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "src/pymssql/_mssql.pyx", line 712, in pymssql._mssql.MSSQLConnection.__init__ Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "src/pymssql/_mssql.pyx", line 1884, in pymssql._mssql.maybe_raise_MSSQLDatabaseException Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "src/pymssql/_mssql.pyx", line 1901, in pymssql._mssql.raise_MSSQLDatabaseException Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: pymssql._mssql.MSSQLDatabaseException: (20002, b'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.110.219)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.110.219)\n') Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: During handling of the above exception, another exception occurred: Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: Traceback (most recent call last): Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3371, in _wrap_pool_connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return fn() Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 327, in connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return _ConnectionFairy._checkout(self) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 894, in _checkout Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: fairy = _ConnectionRecord.checkout(pool) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 493, in checkout Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: rec = pool._do_get() Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 256, in _do_get Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self._create_connection() Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 273, in _create_connection Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return _ConnectionRecord(self) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 388, in __init__ Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: self.__connect() Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 690, in __connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: with util.safe_reraise(): Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: compat.raise_( Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: raise exception Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 686, in __connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: self.dbapi_connection = connection = pool._invoke_creator(self) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 574, in connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return dialect.connect(*cargs, **cparams) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 598, in connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self.dbapi.connect(*cargs, **cparams) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "src/pymssql/_pymssql.pyx", line 659, in pymssql._pymssql.connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: pymssql.exceptions.OperationalError: (20002, b'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.110.219)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.110.219)\n') Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: The above exception was the direct cause of the following exception: Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: Traceback (most recent call last): Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/connectors/sqla/models.py", line 1748, in query Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: df = self.database.get_df( Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/models/core.py", line 695, in get_df Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: with self.get_raw_connection(catalog=catalog, schema=schema) as conn: Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/usr/lib/python3.10/contextlib.py", line 135, in __enter__ Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return next(self.gen) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/models/core.py", line 592, in get_raw_connection Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: with closing(engine.raw_connection()) as conn: Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3404, in raw_connection Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self._wrap_pool_connect(self.pool.connect, _connection) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3374, in _wrap_pool_connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: Connection._handle_dbapi_exception_noconnection( Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2208, in _handle_dbapi_exception_noconnection Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: util.raise_( Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: raise exception Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3371, in _wrap_pool_connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return fn() Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 327, in connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return _ConnectionFairy._checkout(self) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 894, in _checkout Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: fairy = _ConnectionRecord.checkout(pool) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 493, in checkout Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: rec = pool._do_get() Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 256, in _do_get Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self._create_connection() Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 273, in _create_connection Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return _ConnectionRecord(self) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 388, in __init__ Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: self.__connect() Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 690, in __connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: with util.safe_reraise(): Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: compat.raise_( Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: raise exception Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 686, in __connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: self.dbapi_connection = connection = pool._invoke_creator(self) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 574, in connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return dialect.connect(*cargs, **cparams) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 598, in connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self.dbapi.connect(*cargs, **cparams) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "src/pymssql/_pymssql.pyx", line 659, in pymssql._pymssql.connect Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: sqlalchemy.exc.OperationalError: (pymssql.exceptions.OperationalError) (20002, b'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.110.219)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.110.219)\n') Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: (Background on this error at: https://sqlalche.me/e/14/e3q8) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: During handling of the above exception, another exception occurred: Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: Traceback (most recent call last): Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: rv = self.dispatch_request() Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 109, in wraps Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return f(self, *args, **kwargs) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/views/base_api.py", line 120, in wraps Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: duration, response = time_function(f, self, *args, **kwargs) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/utils/core.py", line 1369, in time_function Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: response = func(*args, **kwargs) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/utils/log.py", line 304, in wrapper Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: value = f(*args, **kwargs) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/charts/data/api.py", line 260, in data Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self._get_data_response( Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/utils/log.py", line 304, in wrapper Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: value = f(*args, **kwargs) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/charts/data/api.py", line 423, in _get_data_response Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: result = command.run(force_cached=force_cached) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/commands/chart/data/get_data_command.py", line 45, in run Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: payload = self._query_context.get_payload( Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/common/query_context.py", line 102, in get_payload Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self._processor.get_payload(cache_query_context, force_cached) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/common/query_context_processor.py", line 752, in get_payload Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: query_results = [ Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/common/query_context_processor.py", line 753, in <listcomp> Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: get_query_results( Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/common/query_actions.py", line 227, in get_query_results Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return result_func(query_context, query_obj, force_cached) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/common/query_actions.py", line 103, in _get_full Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: payload = query_context.get_df_payload(query_obj, force_cached=force_cached) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/common/query_context.py", line 123, in get_df_payload Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: return self._processor.get_df_payload( Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/common/query_context_processor.py", line 162, in get_df_payload Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: query_result = self.get_query_result(query_obj) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/common/query_context_processor.py", line 265, in get_query_result Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: result = query_context.datasource.query(query_object.to_dict()) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/connectors/sqla/models.py", line 1770, in query Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: dataclasses.asdict(error) for error in db_engine_spec.extract_errors(ex) Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: File "/home/gapinyc/superset/superset/db_engine_specs/base.py", line 1378, in extract_errors Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: message=message % params, Nov 05 10:22:59 DESKTOP-9QS7RL5 start_superset.sh[50500]: KeyError: 'username'
11-06
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值