Блог

У меня был надсет, работающий в Docker около двух месяцев, и сегодня после перезагрузки сервера я не могу снова загрузить надсет. Одна из наших баз данных, к которой подключается суперсеть, изменила IP-адрес, я думаю, что это может быть причиной. Но я не знаю, где надмножество хранит информацию о подключении к базе данных.

Вот журнал ошибок, который приводит к отключению надмножества:

 superset_app | 2021-11-01 19:43:22,132:INFO:superset.utils.logging_configurator:logging was configured successfully superset_app | 2021-11-01 19:43:22,133:INFO:root:Configured event logger of type lt;class 'superset.utils.log.DBEventLogger'gt; superset_app | 2021-11-01 19:43:22,152:ERROR:superset.app:Failed to create app superset_app | Traceback (most recent call last): superset_app | File "/app/superset/app.py", line 37, in create_app superset_app | app_initializer.init_app() superset_app | File "/app/superset/initialization/__init__.py", line 577, in init_app superset_app | self.init_app_in_ctx() superset_app | File "/app/superset/initialization/__init__.py", line 553, in init_app_in_ctx superset_app | self.init_views() superset_app | File "/app/superset/initialization/__init__.py", line 116, in init_views superset_app | from superset.annotation_layers.api import AnnotationLayerRestApi superset_app | File "/app/superset/annotation_layers/api.py", line 52, in lt;modulegt; superset_app | from superset.views.base_api import BaseSupersetModelRestApi, statsd_metrics superset_app | File "/app/superset/views/__init__.py", line 17, in lt;modulegt; superset_app | from . import ( superset_app | File "/app/superset/views/access_requests.py", line 25, in lt;modulegt; superset_app | from superset.views.core import DAR superset_app | File "/app/superset/views/core.py", line 49, in lt;modulegt; superset_app | from superset import ( superset_app | File "/app/superset/sql_lab.py", line 69, in lt;modulegt; superset_app | SQLLAB_TIMEOUT = config["SQLLAB_ASYNC_TIME_LIMIT_SEC",6000] superset_app | KeyError: ('SQLLAB_ASYNC_TIME_LIMIT_SEC', 6000)  

И вот еще один журнал ошибок, который, я думаю, вызван этим:

 superset_websocket |  superset_websocket | gt; superset-websocket@0.0.1 start /home/superset-websocket superset_websocket | gt; node dist/index.js start superset_websocket |  superset_websocket | config.json file not found superset_worker_beat | Starting Celery beat... superset_websocket | {"error":{},"level":"error","message":"uncaughtException: Please provide a JWT secret at least 32 bytes longnError: Please provide a JWT secret at least 32 bytes longn at Object.lt;anonymousgt; (/home/superset-websocket/dist/index.js:71:11)n at Module._compile (internal/modules/cjs/loader.js:1063:30)n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1092:10)n at Module.load (internal/modules/cjs/loader.js:928:32)n at Function.Module._load (internal/modules/cjs/loader.js:769:14)n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:72:12)n at internal/main/run_main_module.js:17:47","stack":"Error: Please provide a JWT secret at least 32 bytes longn at Object.lt;anonymousgt; (/home/superset-websocket/dist/index.js:71:11)n at Module._compile (internal/modules/cjs/loader.js:1063:30)n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1092:10)n at Module.load (internal/modules/cjs/loader.js:928:32)n at Function.Module._load (internal/modules/cjs/loader.js:769:14)n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:72:12)n at internal/main/run_main_module.js:17:47","exception":true,"date":"Mon Nov 01 2021 19:46:17 GMT 0000 (Coordinated Universal Time)","process":{"pid":19,"uid":0,"gid":0,"cwd":"/home/superset-websocket","execPath":"/usr/local/bin/node","version":"v14.16.1","argv":["/usr/local/bin/node","/home/superset-websocket/dist/index.js","start"],"memoryUsage":{"rss":50339840,"heapTotal":17633280,"heapUsed":12026480,"external":1761448,"arrayBuffers":323630}},"os":{"loadavg":[0.2,0.38,0.52],"uptime":2089},"trace":[{"column":11,"file":"/home/superset-websocket/dist/index.js","function":null,"line":71,"method":null,"native":false},{"column":30,"file":"internal/modules/cjs/loader.js","function":"Module._compile","line":1063,"method":"_compile","native":false},{"column":10,"file":"internal/modules/cjs/loader.js","function":"Module._extensions..js","line":1092,"method":".js","native":false},{"column":32,"file":"internal/modules/cjs/loader.js","function":"Module.load","line":928,"method":"load","native":false},{"column":14,"file":"internal/modules/cjs/loader.js","function":"Module._load","line":769,"method":"_load","native":false},{"column":12,"file":"internal/modules/run_main.js","function":"Function.executeUserEntryPoint [as runMain]","line":72,"method":"executeUserEntryPoint [as runMain]","native":false},{"column":47,"file":"internal/main/run_main_module.js","function":null,"line":17,"method":null,"native":false}]} db_1 | 2021-11-01 19:46:17.059 UTC [25] LOG: database system was shut down at 2021-11-01 19:46:08 UTC db_1 | 2021-11-01 19:46:17.067 UTC [1] LOG: database system is ready to accept connections superset_tests_worker | 2021-11-01 19:46:18,806:INFO:superset.utils.logging_configurator:logging was configured successfully superset_tests_worker | 2021-11-01 19:46:18,812:INFO:root:Configured event logger of type lt;class 'superset.utils.log.DBEventLogger'gt; db_1 | 2021-11-01 19:46:18.840 UTC [32] FATAL: database "test" does not exist superset_tests_worker | /usr/local/lib/python3.7/site-packages/flask_caching/__init__.py:202: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled. superset_tests_worker | "Flask-Caching: CACHE_TYPE is set to null, " superset_tests_worker | 2021-11-01 19:46:18,840:ERROR:flask_appbuilder.security.sqla.manager:DB Creation and initialization failed: (psycopg2.OperationalError) FATAL: database "test" does not exist  

Если мне не удалось сохранить этот надмножество, возможно ли восстановить диаграммы, созданные с помощью этого надмножества?