GitHub user PARKER-X added a comment to the discussion: Not Able to login
Superset key decryption error
, line 72, in run
raise InvalidParametersError(errors)
superset.commands.database.exceptions.InvalidParametersError:
[SupersetError(message='The port is closed.',
error_type=<SupersetErrorType.CONNECTION_PORT_CLOSED_ERROR:
'CONNECTION_PORT_CLOSED_ERROR'>, level=<ErrorLevel.ERROR: 'error'>,
extra={'invalid': ['port'], 'issue_codes': [{'code': 1008, 'message': 'Issue
1008 - The port is closed.'}]})]
2026-08-17 10:34:30,603:INFO:werkzeug:127.0.0.1 - - [17/Aug/2026 10:34:30]
"POST /api/v1/database/validate_parameters/ HTTP/1.1" 422 -
2026-08-17 10:34:36,275:ERROR:root:DBEventLogger failed to log event(s)
2026-08-17 10:34:36,275:ERROR:root:(sqlite3.OperationalError) database is locked
[SQL: INSERT INTO logs (action, user_id, json, dttm, referrer) VALUES (?, ?, ?,
?, ?)]
[parameters: ('validation_error', 1, '{"path":
"/api/v1/database/validate_parameters/", "database_name": "PostgreSQL",
"engine": "postgresql", "configuration_method": "dynamic_form", "eng ... (338
characters truncated) ... : true, "parameters": {"username":
"dashboard_read_only_user", "password": "Zup1!whb", "host": "172.16.0.119",
"port": "5432", "database": "org_db"}}', '2026-08-17 05:04:30.725830',
'http://127.0.0.1:8088/databaseview/list/?pageIndex=0&sortColumn=changed_on_delta_humanized&sortOrder=desc')]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Traceback (most recent call last):
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 1910, in _execute_context
self.dialect.do_execute(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\default.py",
line 736, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: database is locked
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\superset\utils\log.py",
line 412, in log
db.session.bulk_save_objects(logs)
File "<string>", line 2, in bulk_save_objects
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\orm\session.py",
line 3705, in bulk_save_objects
self._bulk_save_mappings(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\orm\session.py",
line 3912, in _bulk_save_mappings
with util.safe_reraise():
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\util\langhelpers.py",
line 70, in __exit__
compat.raise_(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\util\compat.py",
line 211, in raise_
raise exception
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\orm\session.py",
line 3901, in _bulk_save_mappings
persistence._bulk_insert(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\orm\persistence.py",
line 107, in _bulk_insert
_emit_insert_statements(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\orm\persistence.py",
line 1097, in _emit_insert_statements
c = connection._execute_20(
^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 1710, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\sql\elements.py",
line 334, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 1577, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 1953, in _execute_context
self._handle_dbapi_exception(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 2134, in _handle_dbapi_exception
util.raise_(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\util\compat.py",
line 211, in raise_
raise exception
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 1910, in _execute_context
self.dialect.do_execute(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\default.py",
line 736, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: INSERT INTO logs (action, user_id, json, dttm, referrer) VALUES (?, ?, ?,
?, ?)]
[parameters: ('validation_error', 1, '{"path":
"/api/v1/database/validate_parameters/", "database_name": "PostgreSQL",
"engine": "postgresql", "configuration_method": "dynamic_form", "eng ... (338
characters truncated) ... : true, "parameters": {"username":
"dashboard_read_only_user", "password": "Zup1!whb", "host": "172.16.0.119",
"port": "5432", "database": "org_db"}}', '2026-08-17 05:04:30.725830',
'http://127.0.0.1:8088/databaseview/list/?pageIndex=0&sortColumn=changed_on_delta_humanized&sortOrder=desc')]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
2026-08-17
10:34:36,278:WARNING:superset.views.error_handling:SupersetErrorsException
Traceback (most recent call last):
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\flask\app.py",
line 917, in full_dispatch_request
rv = self.dispatch_request()
^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\flask\app.py",
line 902, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) #
type: ignore[no-any-return]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\flask_appbuilder\security\decorators.py",
line 128, in wraps
return f(self, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\superset\views\base_api.py",
line 120, in wraps
duration, response = time_function(f, self, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\superset\utils\core.py",
line 1559, in time_function
response = func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\superset\utils\log.py",
line 301, in wrapper
value = f(*args, **kwargs)
^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\superset\views\base_api.py",
line 92, in wraps
return f(self, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\superset\databases\api.py",
line 2005, in validate_parameters
command.run()
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\superset\commands\database\validate.py",
line 72, in run
raise InvalidParametersError(errors)
superset.commands.database.exceptions.InvalidParametersError:
[SupersetError(message='The port is closed.',
error_type=<SupersetErrorType.CONNECTION_PORT_CLOSED_ERROR:
'CONNECTION_PORT_CLOSED_ERROR'>, level=<ErrorLevel.ERROR: 'error'>,
extra={'invalid': ['port'], 'issue_codes': [{'code': 1008, 'message': 'Issue
1008 - The port is closed.'}]})]
2026-08-17 10:34:36,278:INFO:werkzeug:127.0.0.1 - - [17/Aug/2026 10:34:36]
"POST /api/v1/database/validate_parameters/ HTTP/1.1" 422 -
2026-08-17 10:34:41,890:ERROR:root:DBEventLogger failed to log event(s)
2026-08-17 10:34:41,890:ERROR:root:(sqlite3.OperationalError) database is locked
[SQL: INSERT INTO logs (action, user_id, json, dttm, referrer) VALUES (?, ?, ?,
?, ?)]
[parameters:
('db_connection_failed.DatabaseInvalidError.DatabaseExistsValidationError', 1,
'{"path": "/api/v1/database/", "database_name": "PostgreSQL",
"configuration_method": "dynamic_form", "engine_information":
{"disable_ssh_tunneling": ... (264 characters truncated) ... _sqllab": true,
"masked_encrypted_extra": "{}", "sqlalchemy_uri":
"postgresql+psycopg2://dashboard_read_only_user:[email protected]:5432/org_db"}',
'2026-08-17 05:04:36.362146',
'http://127.0.0.1:8088/databaseview/list/?pageIndex=0&sortColumn=changed_on_delta_humanized&sortOrder=desc')]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Traceback (most recent call last):
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 1910, in _execute_context
self.dialect.do_execute(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\default.py",
line 736, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: database is locked
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\superset\utils\log.py",
line 412, in log
db.session.bulk_save_objects(logs)
File "<string>", line 2, in bulk_save_objects
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\orm\session.py",
line 3705, in bulk_save_objects
self._bulk_save_mappings(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\orm\session.py",
line 3912, in _bulk_save_mappings
with util.safe_reraise():
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\util\langhelpers.py",
line 70, in __exit__
compat.raise_(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\util\compat.py",
line 211, in raise_
raise exception
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\orm\session.py",
line 3901, in _bulk_save_mappings
persistence._bulk_insert(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\orm\persistence.py",
line 107, in _bulk_insert
_emit_insert_statements(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\orm\persistence.py",
line 1097, in _emit_insert_statements
c = connection._execute_20(
^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 1710, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\sql\elements.py",
line 334, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 1577, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 1953, in _execute_context
self._handle_dbapi_exception(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 2134, in _handle_dbapi_exception
util.raise_(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\util\compat.py",
line 211, in raise_
raise exception
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 1910, in _execute_context
self.dialect.do_execute(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\default.py",
line 736, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: INSERT INTO logs (action, user_id, json, dttm, referrer) VALUES (?, ?, ?,
?, ?)]
[parameters:
('db_connection_failed.DatabaseInvalidError.DatabaseExistsValidationError', 1,
'{"path": "/api/v1/database/", "database_name": "PostgreSQL",
"configuration_method": "dynamic_form", "engine_information":
{"disable_ssh_tunneling": ... (264 characters truncated) ... _sqllab": true,
"masked_encrypted_extra": "{}", "sqlalchemy_uri":
"postgresql+psycopg2://dashboard_read_only_user:[email protected]:5432/org_db"}',
'2026-08-17 05:04:36.362146',
'http://127.0.0.1:8088/databaseview/list/?pageIndex=0&sortColumn=changed_on_delta_humanized&sortOrder=desc')]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
2026-08-17 10:34:47,477:ERROR:root:DBEventLogger failed to log event(s)
2026-08-17 10:34:47,477:ERROR:root:(sqlite3.OperationalError) database is locked
[SQL: INSERT INTO logs (action, user_id, json, dttm, duration_ms, referrer)
VALUES (?, ?, ?, ?, ?, ?)]
[parameters: ('DatabaseRestApi.post', 1, '{"path": "/api/v1/database/",
"database_name": "PostgreSQL", "configuration_method": "dynamic_form",
"engine_information": {"disable_ssh_tunneling": ... (302 characters truncated)
... a": "{}", "sqlalchemy_uri":
"postgresql+psycopg2://dashboard_read_only_user:[email protected]:5432/org_db",
"object_ref": "DatabaseRestApi.post"}', '2026-08-17 05:04:41.901314', 5559,
'http://127.0.0.1:8088/databaseview/list/?pageIndex=0&sortColumn=changed_on_delta_humanized&sortOrder=desc')]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Traceback (most recent call last):
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 1910, in _execute_context
self.dialect.do_execute(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\default.py",
line 736, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: database is locked
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\superset\utils\log.py",
line 412, in log
db.session.bulk_save_objects(logs)
File "<string>", line 2, in bulk_save_objects
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\orm\session.py",
line 3705, in bulk_save_objects
self._bulk_save_mappings(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\orm\session.py",
line 3912, in _bulk_save_mappings
with util.safe_reraise():
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\util\langhelpers.py",
line 70, in __exit__
compat.raise_(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\util\compat.py",
line 211, in raise_
raise exception
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\orm\session.py",
line 3901, in _bulk_save_mappings
persistence._bulk_insert(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\orm\persistence.py",
line 107, in _bulk_insert
_emit_insert_statements(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\orm\persistence.py",
line 1097, in _emit_insert_statements
c = connection._execute_20(
^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 1710, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\sql\elements.py",
line 334, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 1577, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 1953, in _execute_context
self._handle_dbapi_exception(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 2134, in _handle_dbapi_exception
util.raise_(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\util\compat.py",
line 211, in raise_
raise exception
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\base.py",
line 1910, in _execute_context
self.dialect.do_execute(
File
"C:\Users\Administrator\Desktop\SamarthX_New\superset\venv\Lib\site-packages\sqlalchemy\engine\default.py",
line 736, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: INSERT INTO logs (action, user_id, json, dttm, duration_ms, referrer)
VALUES (?, ?, ?, ?, ?, ?)]
[parameters: ('DatabaseRestApi.post', 1, '{"path": "/api/v1/database/",
"database_name": "PostgreSQL", "configuration_method": "dynamic_form",
"engine_information": {"disable_ssh_tunneling": ... (302 characters truncated)
... a": "{}", "sqlalchemy_uri":
"postgresql+psycopg2://dashboard_read_only_user:[email protected]:5432/org_db",
"object_ref": "DatabaseRestApi.post"}', '2026-08-17 05:04:41.901314', 5559,
'http://127.0.0.1:8088/databaseview/list/?pageIndex=0&sortColumn=changed_on_delta_humanized&sortOrder=desc')]
(Background on this error at: https://sqlalche.me/e/14/e3q8) error port closed
and same database connection already exist similar error i delete it from my
database sqlite @dosu
GitHub link:
https://github.com/apache/superset/discussions/43227#discussioncomment-18047227
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
