jinmengcheng commented on issue #29836: URL: https://github.com/apache/superset/issues/29836#issuecomment-2295973180
Hi @mistercrunch thanks for help on chekcing the db upgrade issue, below is a log list showing full logs of my superset_init job when I running "TAG=4.0.2 docker compose -f docker-compose-non-dev.yml up" command line to launch superset via docker, from the log seems everything worked fine, from the screenshot, step 1 applying DB migration will run "superset db upgrade" command  `superset_init | Installing local overrides at /app/docker/requirements-local.txt superset_init | Collecting sqlalchemy-trino superset_init | Downloading sqlalchemy_trino-0.5.0-py3-none-any.whl (6.8 kB) superset_init | Collecting Authlib superset_init | Downloading Authlib-1.3.1-py2.py3-none-any.whl (223 kB) superset_init | ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 223.8/223.8 kB 267.5 kB/s eta 0:00:00 superset_init | Collecting statsd superset_init | Downloading statsd-4.0.1-py2.py3-none-any.whl (13 kB) superset_init | Collecting trino[sqlalchemy]>=0.310 superset_init | Downloading trino-0.329.0-py3-none-any.whl (53 kB) superset_init | ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 53.0/53.0 kB 1.9 MB/s eta 0:00:00 superset_init | Requirement already satisfied: cryptography in /usr/local/lib/python3.9/site-packages (from Authlib->-r /app/docker/requirements-local.txt (line 2)) (42.0.4) superset_init | Requirement already satisfied: python-dateutil in /usr/local/lib/python3.9/site-packages (from trino[sqlalchemy]>=0.310->sqlalchemy-trino->-r /app/docker/requirements-local.txt (line 1)) (2.8.2) superset_init | Requirement already satisfied: pytz in /usr/local/lib/python3.9/site-packages (from trino[sqlalchemy]>=0.310->sqlalchemy-trino->-r /app/docker/requirements-local.txt (line 1)) (2021.3) superset_init | Requirement already satisfied: requests>=2.31.0 in /usr/local/lib/python3.9/site-packages (from trino[sqlalchemy]>=0.310->sqlalchemy-trino->-r /app/docker/requirements-local.txt (line 1)) (2.31.0) superset_init | Collecting tzlocal superset_init | Downloading tzlocal-5.2-py3-none-any.whl (17 kB) superset_init | Requirement already satisfied: sqlalchemy>=1.3 in /usr/local/lib/python3.9/site-packages (from trino[sqlalchemy]>=0.310->sqlalchemy-trino->-r /app/docker/requirements-local.txt (line 1)) (1.4.36) superset_init | Requirement already satisfied: cffi>=1.12 in /usr/local/lib/python3.9/site-packages (from cryptography->Authlib->-r /app/docker/requirements-local.txt (line 2)) (1.15.1) superset_init | Requirement already satisfied: pycparser in /usr/local/lib/python3.9/site-packages (from cffi>=1.12->cryptography->Authlib->-r /app/docker/requirements-local.txt (line 2)) (2.20) superset_init | Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.9/site-packages (from requests>=2.31.0->trino[sqlalchemy]>=0.310->sqlalchemy-trino->-r /app/docker/requirements-local.txt (line 1)) (2023.7.22) superset_init | Requirement already satisfied: charset-normalizer<4,>=2 in /usr/local/lib/python3.9/site-packages (from requests>=2.31.0->trino[sqlalchemy]>=0.310->sqlalchemy-trino->-r /app/docker/requirements-local.txt (line 1)) (3.2.0) superset_init | Requirement already satisfied: urllib3<3,>=1.21.1 in /usr/local/lib/python3.9/site-packages (from requests>=2.31.0->trino[sqlalchemy]>=0.310->sqlalchemy-trino->-r /app/docker/requirements-local.txt (line 1)) (1.26.18) superset_init | Requirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.9/site-packages (from requests>=2.31.0->trino[sqlalchemy]>=0.310->sqlalchemy-trino->-r /app/docker/requirements-local.txt (line 1)) (3.2) superset_init | Requirement already satisfied: greenlet!=0.4.17 in /usr/local/lib/python3.9/site-packages (from sqlalchemy>=1.3->trino[sqlalchemy]>=0.310->sqlalchemy-trino->-r /app/docker/requirements-local.txt (line 1)) (3.0.3) superset_init | Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.9/site-packages (from python-dateutil->trino[sqlalchemy]>=0.310->sqlalchemy-trino->-r /app/docker/requirements-local.txt (line 1)) (1.16.0) superset_init | Installing collected packages: statsd, tzlocal, trino, Authlib, sqlalchemy-trino superset_init | Successfully installed Authlib-1.3.1 sqlalchemy-trino-0.5.0 statsd-4.0.1 trino-0.329.0 tzlocal-5.2 superset_init | WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv superset_init | superset_init | [notice] A new release of pip is available: 23.0.1 -> 24.2 superset_init | [notice] To update, run: pip install --upgrade pip superset_init | Unknown Operation!!! superset_init | superset_init | ###################################################################### superset_init | superset_init | superset_init | Init Step 1/4 [Starting] -- Applying DB migrations superset_init | superset_init | superset_init | ###################################################################### superset_init | superset_init | logging was configured successfully superset_init | 2024-08-19 08:18:26,023:INFO:superset.utils.logging_configurator:logging was configured successfully superset_init | 2024-08-19 08:18:26,029:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'> superset_init | We haven't found any Content Security Policy (CSP) defined in the configurations. Please make sure to configure CSP using the TALISMAN_ENABLED and TALISMAN_CONFIG keys or any other external software. Failing to configure CSP have serious security implications. Check https://developer.mozilla.org/en-US/docs/Web/HTTP/CSP for more information. You can disable this warning using the CONTENT_SECURITY_POLICY_WARNING key. superset_init | 2024-08-19 08:18:26,030:WARNING:superset.initialization:We haven't found any Content Security Policy (CSP) defined in the configurations. Please make sure to configure CSP using the TALISMAN_ENABLED and TALISMAN_CONFIG keys or any other external software. Failing to configure CSP have serious security implications. Check https://developer.mozilla.org/en-US/docs/Web/HTTP/CSP for more information. You can disable this warning using the CONTENT_SECURITY_POLICY_WARNING key. superset_init | /usr/local/lib/python3.9/site-packages/flask_limiter/extension.py:293: UserWarning: Using the in-memory storage for tracking rate limits as no storage was explicitly specified. This is not recommended for production use. See: https://flask-limiter.readthedocs.io#configuring-a-storage-backend for documentation about configuring the storage backend. superset_init | warnings.warn( superset_init | INFO [alembic.runtime.migration] Context impl PostgresqlImpl. superset_init | INFO [alembic.runtime.migration] Will assume transactional DDL. superset_init | ##### DEBUG: False superset_init | Loaded your LOCAL configuration at [/app/docker/pythonpath_dev/superset_config.py] superset_init | ##### LOG_LEVEL in configuration: 20 superset_init | ##### debug_mode in parameter: False, DEBUG: False superset_init | superset_init | ###################################################################### superset_init | superset_init | superset_init | Init Step 1/4 [Complete] -- Applying DB migrations superset_init | superset_init | superset_init | ###################################################################### superset_init | superset_init | superset_init | ###################################################################### superset_init | superset_init | superset_init | Init Step 2/4 [Starting] -- Setting up admin user ( admin / admin ) superset_init | superset_init | superset_init | ###################################################################### superset_init | superset_init | logging was configured successfully superset_init | 2024-08-19 08:18:32,744:INFO:superset.utils.logging_configurator:logging was configured successfully superset_init | 2024-08-19 08:18:32,751:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'> superset_init | We haven't found any Content Security Policy (CSP) defined in the configurations. Please make sure to configure CSP using the TALISMAN_ENABLED and TALISMAN_CONFIG keys or any other external software. Failing to configure CSP have serious security implications. Check https://developer.mozilla.org/en-US/docs/Web/HTTP/CSP for more information. You can disable this warning using the CONTENT_SECURITY_POLICY_WARNING key. superset_init | 2024-08-19 08:18:32,752:WARNING:superset.initialization:We haven't found any Content Security Policy (CSP) defined in the configurations. Please make sure to configure CSP using the TALISMAN_ENABLED and TALISMAN_CONFIG keys or any other external software. Failing to configure CSP have serious security implications. Check https://developer.mozilla.org/en-US/docs/Web/HTTP/CSP for more information. You can disable this warning using the CONTENT_SECURITY_POLICY_WARNING key. superset_init | /usr/local/lib/python3.9/site-packages/flask_limiter/extension.py:293: UserWarning: Using the in-memory storage for tracking rate limits as no storage was explicitly specified. This is not recommended for production use. See: https://flask-limiter.readthedocs.io#configuring-a-storage-backend for documentation about configuring the storage backend. superset_init | warnings.warn( superset_init | ##### DEBUG: False superset_init | Loaded your LOCAL configuration at [/app/docker/pythonpath_dev/superset_config.py] superset_init | ##### LOG_LEVEL in configuration: 20 superset_init | ##### debug_mode in parameter: False, DEBUG: False superset_init | Recognized OAuth Authentication. superset_init | Error! User already exists admin superset_init | superset_init | ###################################################################### superset_init | superset_init | superset_init | Init Step 2/4 [Complete] -- Setting up admin user superset_init | superset_init | superset_init | ###################################################################### superset_init | superset_init | superset_init | ###################################################################### superset_init | superset_init | superset_init | Init Step 3/4 [Starting] -- Setting up roles and perms superset_init | superset_init | superset_init | ###################################################################### superset_init | superset_init | logging was configured successfully superset_init | 2024-08-19 08:18:38,234:INFO:superset.utils.logging_configurator:logging was configured successfully superset_init | 2024-08-19 08:18:38,241:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'> superset_init | We haven't found any Content Security Policy (CSP) defined in the configurations. Please make sure to configure CSP using the TALISMAN_ENABLED and TALISMAN_CONFIG keys or any other external software. Failing to configure CSP have serious security implications. Check https://developer.mozilla.org/en-US/docs/Web/HTTP/CSP for more information. You can disable this warning using the CONTENT_SECURITY_POLICY_WARNING key. superset_init | 2024-08-19 08:18:38,242:WARNING:superset.initialization:We haven't found any Content Security Policy (CSP) defined in the configurations. Please make sure to configure CSP using the TALISMAN_ENABLED and TALISMAN_CONFIG keys or any other external software. Failing to configure CSP have serious security implications. Check https://developer.mozilla.org/en-US/docs/Web/HTTP/CSP for more information. You can disable this warning using the CONTENT_SECURITY_POLICY_WARNING key. superset_init | /usr/local/lib/python3.9/site-packages/flask_limiter/extension.py:293: UserWarning: Using the in-memory storage for tracking rate limits as no storage was explicitly specified. This is not recommended for production use. See: https://flask-limiter.readthedocs.io#configuring-a-storage-backend for documentation about configuring the storage backend. superset_init | warnings.warn( superset_init | Syncing role definition superset_init | 2024-08-19 08:18:41,650:INFO:superset.security.manager:Syncing role definition superset_init | Syncing Admin perms superset_init | 2024-08-19 08:18:41,692:INFO:superset.security.manager:Syncing Admin perms superset_init | Syncing Alpha perms superset_init | 2024-08-19 08:18:41,707:INFO:superset.security.manager:Syncing Alpha perms superset_init | Syncing Gamma perms superset_init | 2024-08-19 08:18:42,366:INFO:superset.security.manager:Syncing Gamma perms superset_init | Syncing sql_lab perms superset_init | 2024-08-19 08:18:43,264:INFO:superset.security.manager:Syncing sql_lab perms superset_init | Fetching a set of all perms to lookup which ones are missing superset_init | 2024-08-19 08:18:43,922:INFO:superset.security.manager:Fetching a set of all perms to lookup which ones are missing superset_init | Creating missing datasource permissions. superset_init | 2024-08-19 08:18:43,939:INFO:superset.security.manager:Creating missing datasource permissions. superset_init | Creating missing database permissions. superset_init | 2024-08-19 08:18:43,950:INFO:superset.security.manager:Creating missing database permissions. superset_init | Cleaning faulty perms superset_init | 2024-08-19 08:18:43,959:INFO:superset.security.manager:Cleaning faulty perms superset_init | ##### DEBUG: False superset_init | Loaded your LOCAL configuration at [/app/docker/pythonpath_dev/superset_config.py] superset_init | ##### LOG_LEVEL in configuration: 20 superset_init | ##### debug_mode in parameter: False, DEBUG: False superset_init | superset_init | ###################################################################### superset_init | superset_init | superset_init | Init Step 3/4 [Complete] -- Setting up roles and perms superset_init | superset_init | superset_init | ###################################################################### superset_init | superset_init exited with code 0` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
