Create connection error "Internal message: unable to open database file" #51552
-
I have created a no-code connector to communicate with a REST API, however when trying to deploy the connector, after running the "testing" phase it throws this error.
Traceback (most recent call last):
File "/airbyte/integration_code/main.py", line 4, in <module>
run()
File "/airbyte/integration_code/source_declarative_manifest/run.py", line 230, in run
handle_command(args)
File "/airbyte/integration_code/source_declarative_manifest/run.py", line 89, in handle_command
handle_remote_manifest_command(args)
File "/airbyte/integration_code/source_declarative_manifest/run.py", line 149, in handle_remote_manifest_command
launch(
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/entrypoint.py", line 341, in launch
for message in source_entrypoint.run(parsed_args):
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/entrypoint.py", line 158, in run
yield from map(
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/entrypoint.py", line 201, in check
check_result = self.source.check(self.logger, config)
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/declarative/manifest_declarative_source.py", line 202, in check
return super().check(logger, config)
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/abstract_source.py", line 96, in check
check_succeeded, error = self.check_connection(logger, config)
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/declarative/declarative_source.py", line 36, in check_connection
return self.connection_checker.check_connection(self, logger, config)
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/declarative/checks/check_stream.py", line 33, in check_connection
streams = source.streams(config=config)
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/declarative/concurrent_declarative_source.py", line 170, in streams
return super().streams(config)
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/declarative/manifest_declarative_source.py", line 131, in streams
source_streams = [
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/declarative/manifest_declarative_source.py", line 132, in <listcomp>
self._constructor.create_component(
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/declarative/parsers/model_to_component_factory.py", line 600, in create_component
return self._create_component_from_model(
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/declarative/parsers/model_to_component_factory.py", line 612, in _create_component_from_model
return component_constructor(model=model, config=config, **kwargs)
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/declarative/parsers/model_to_component_factory.py", line 1355, in create_declarative_stream
retriever = self._create_component_from_model(
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/declarative/parsers/model_to_component_factory.py", line 612, in _create_component_from_model
return component_constructor(model=model, config=config, **kwargs)
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/declarative/parsers/model_to_component_factory.py", line 2107, in create_simple_retriever
requester = self._create_component_from_model(
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/declarative/parsers/model_to_component_factory.py", line 612, in _create_component_from_model
return component_constructor(model=model, config=config, **kwargs)
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/declarative/parsers/model_to_component_factory.py", line 1633, in create_http_requester
return HttpRequester(
File "<string>", line 17, in __init__
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/declarative/requesters/http_requester.py", line 90, in __post_init__
self._http_client = HttpClient(
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/streams/http/http_client.py", line 101, in __init__
self._session = self._request_session()
File "/usr/local/lib/python3.10/site-packages/airbyte_cdk/sources/streams/http/http_client.py", line 154, in _request_session
backend = requests_cache.SQLiteCache(sqlite_path, fast_save=True, wal=True)
File "/usr/local/lib/python3.10/site-packages/requests_cache/backends/sqlite.py", line 62, in __init__
self.responses: SQLiteDict = SQLiteDict(db_path, table_name='responses', **skwargs)
File "/usr/local/lib/python3.10/site-packages/requests_cache/backends/sqlite.py", line 226, in __init__
self.init_db()
File "/usr/local/lib/python3.10/site-packages/requests_cache/backends/sqlite.py", line 231, in init_db
with self.connection(commit=True) as con:
File "/usr/local/lib/python3.10/contextlib.py", line 135, in __enter__
return next(self.gen)
File "/usr/local/lib/python3.10/site-packages/requests_cache/backends/sqlite.py", line 253, in connection
self._connection = sqlite3.connect(self.db_path, **self.connection_kwargs)
sqlite3.OperationalError: unable to open database file |
Beta Was this translation helpful? Give feedback.
Answered by
GamesmenJordan
Jan 15, 2025
Replies: 1 comment
-
The issue was using "/" in the stream names, apparently stream names are not validated. |
Beta Was this translation helpful? Give feedback.
0 replies
Answer selected by
GamesmenJordan
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
The issue was using "/" in the stream names, apparently stream names are not validated.