starred/healthchecks
1
0
Fork 0
mirror of https://github.com/healthchecks/healthchecks.git synced 2026-04-25 06:55:53 +03:00
Code Issues 56 Projects Releases 10 Packages Wiki Activity

[GH-ISSUE #623] DB_NAME for sqlite different than /tmp/hc.sqlite #451

New issue
Closed
opened 2026-02-25 23:42:30 +03:00 by kerem · 2 comments
kerem commented 2026-02-25 23:42:30 +03:00
Owner
Copy link

Originally created by @alyvusal on GitHub (Mar 24, 2022).
Original GitHub issue: https://github.com/healthchecks/healthchecks/issues/623

Hi, When I use different location for DB_NAME like DB_NAME=/db/hc.sqlite
Error says can not find location

healthchecks-hc-1  | sendreports is now running
healthchecks-hc-1  | Traceback (most recent call last):
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 244, in ensure_connection
healthchecks-hc-1  |     self.connect()
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
healthchecks-hc-1  |     return func(*args, **kwargs)
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 225, in connect
healthchecks-hc-1  |     self.connection = self.get_new_connection(conn_params)
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
healthchecks-hc-1  |     return func(*args, **kwargs)
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/backends/sqlite3/base.py", line 206, in get_new_connection
healthchecks-hc-1  |     conn = Database.connect(**conn_params)
healthchecks-hc-1  | sqlite3.OperationalError: unable to open database file
healthchecks-hc-1  | 
healthchecks-hc-1  | The above exception was the direct cause of the following exception:
healthchecks-hc-1  | 
healthchecks-hc-1  | Traceback (most recent call last):
healthchecks-hc-1  |   File "/opt/healthchecks/./manage.py", line 10, in <module>
healthchecks-hc-1  |     execute_from_command_line(sys.argv)
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/core/management/__init__.py", line 446, in execute_from_command_line
healthchecks-hc-1  |     utility.execute()
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/core/management/__init__.py", line 440, in execute
healthchecks-hc-1  |     self.fetch_command(subcommand).run_from_argv(self.argv)
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 414, in run_from_argv
healthchecks-hc-1  |     self.execute(*args, **cmd_options)
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 460, in execute
healthchecks-hc-1  |     output = self.handle(*args, **options)
healthchecks-hc-1  |   File "/opt/healthchecks/hc/api/management/commands/sendreports.py", line 105, in handle
healthchecks-hc-1  |     while not self.sigterm and self.handle_one_report():
healthchecks-hc-1  |   File "/opt/healthchecks/hc/api/management/commands/sendreports.py", line 39, in handle_one_report
healthchecks-hc-1  |     profile = q.first()
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 753, in first
healthchecks-hc-1  |     for obj in (self if self.ordered else self.order_by("pk"))[:1]:
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 320, in __iter__
healthchecks-hc-1  |     self._fetch_all()
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 1507, in _fetch_all
healthchecks-hc-1  |     self._result_cache = list(self._iterable_class(self))
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 57, in __iter__
healthchecks-hc-1  |     results = compiler.execute_sql(
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1359, in execute_sql
healthchecks-hc-1  |     cursor = self.connection.cursor()
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
healthchecks-hc-1  |     return func(*args, **kwargs)
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 284, in cursor
healthchecks-hc-1  |     return self._cursor()
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 260, in _cursor
healthchecks-hc-1  |     self.ensure_connection()
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
healthchecks-hc-1  |     return func(*args, **kwargs)
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 243, in ensure_connection
healthchecks-hc-1  |     with self.wrap_database_errors:
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in __exit__
healthchecks-hc-1  |     raise dj_exc_value.with_traceback(traceback) from exc_value
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 244, in ensure_connection
healthchecks-hc-1  |     self.connect()
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
healthchecks-hc-1  |     return func(*args, **kwargs)
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 225, in connect
healthchecks-hc-1  |     self.connection = self.get_new_connection(conn_params)
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
healthchecks-hc-1  |     return func(*args, **kwargs)
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/backends/sqlite3/base.py", line 206, in get_new_connection
healthchecks-hc-1  |     conn = Database.connect(**conn_params)
healthchecks-hc-1  | django.db.utils.OperationalError: unable to open database file
healthchecks-hc-1  | sendalerts is now running
healthchecks-hc-1  | Traceback (most recent call last):
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 244, in ensure_connection
healthchecks-hc-1  |     self.connect()
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
healthchecks-hc-1  |     return func(*args, **kwargs)
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 225, in connect
healthchecks-hc-1  |     self.connection = self.get_new_connection(conn_params)
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
healthchecks-hc-1  |     return func(*args, **kwargs)
healthchecks-hc-1  |   File "/usr/local/lib/python3.10/site-packages/django/db/backends/sqlite3/base.py", line 206, in get_new_connection
healthchecks-hc-1  |     conn = Database.connect(**conn_params)
healthchecks-hc-1  | sqlite3.OperationalError: unable to open database file
Originally created by @alyvusal on GitHub (Mar 24, 2022). Original GitHub issue: https://github.com/healthchecks/healthchecks/issues/623 Hi, When I use different location for DB_NAME like `DB_NAME=/db/hc.sqlite` Error says can not find location ``` healthchecks-hc-1 | sendreports is now running healthchecks-hc-1 | Traceback (most recent call last): healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 244, in ensure_connection healthchecks-hc-1 | self.connect() healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner healthchecks-hc-1 | return func(*args, **kwargs) healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 225, in connect healthchecks-hc-1 | self.connection = self.get_new_connection(conn_params) healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner healthchecks-hc-1 | return func(*args, **kwargs) healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/sqlite3/base.py", line 206, in get_new_connection healthchecks-hc-1 | conn = Database.connect(**conn_params) healthchecks-hc-1 | sqlite3.OperationalError: unable to open database file healthchecks-hc-1 | healthchecks-hc-1 | The above exception was the direct cause of the following exception: healthchecks-hc-1 | healthchecks-hc-1 | Traceback (most recent call last): healthchecks-hc-1 | File "/opt/healthchecks/./manage.py", line 10, in <module> healthchecks-hc-1 | execute_from_command_line(sys.argv) healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/core/management/__init__.py", line 446, in execute_from_command_line healthchecks-hc-1 | utility.execute() healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/core/management/__init__.py", line 440, in execute healthchecks-hc-1 | self.fetch_command(subcommand).run_from_argv(self.argv) healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 414, in run_from_argv healthchecks-hc-1 | self.execute(*args, **cmd_options) healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 460, in execute healthchecks-hc-1 | output = self.handle(*args, **options) healthchecks-hc-1 | File "/opt/healthchecks/hc/api/management/commands/sendreports.py", line 105, in handle healthchecks-hc-1 | while not self.sigterm and self.handle_one_report(): healthchecks-hc-1 | File "/opt/healthchecks/hc/api/management/commands/sendreports.py", line 39, in handle_one_report healthchecks-hc-1 | profile = q.first() healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 753, in first healthchecks-hc-1 | for obj in (self if self.ordered else self.order_by("pk"))[:1]: healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 320, in __iter__ healthchecks-hc-1 | self._fetch_all() healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 1507, in _fetch_all healthchecks-hc-1 | self._result_cache = list(self._iterable_class(self)) healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/models/query.py", line 57, in __iter__ healthchecks-hc-1 | results = compiler.execute_sql( healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1359, in execute_sql healthchecks-hc-1 | cursor = self.connection.cursor() healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner healthchecks-hc-1 | return func(*args, **kwargs) healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 284, in cursor healthchecks-hc-1 | return self._cursor() healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 260, in _cursor healthchecks-hc-1 | self.ensure_connection() healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner healthchecks-hc-1 | return func(*args, **kwargs) healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 243, in ensure_connection healthchecks-hc-1 | with self.wrap_database_errors: healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in __exit__ healthchecks-hc-1 | raise dj_exc_value.with_traceback(traceback) from exc_value healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 244, in ensure_connection healthchecks-hc-1 | self.connect() healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner healthchecks-hc-1 | return func(*args, **kwargs) healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 225, in connect healthchecks-hc-1 | self.connection = self.get_new_connection(conn_params) healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner healthchecks-hc-1 | return func(*args, **kwargs) healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/sqlite3/base.py", line 206, in get_new_connection healthchecks-hc-1 | conn = Database.connect(**conn_params) healthchecks-hc-1 | django.db.utils.OperationalError: unable to open database file healthchecks-hc-1 | sendalerts is now running healthchecks-hc-1 | Traceback (most recent call last): healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 244, in ensure_connection healthchecks-hc-1 | self.connect() healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner healthchecks-hc-1 | return func(*args, **kwargs) healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 225, in connect healthchecks-hc-1 | self.connection = self.get_new_connection(conn_params) healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner healthchecks-hc-1 | return func(*args, **kwargs) healthchecks-hc-1 | File "/usr/local/lib/python3.10/site-packages/django/db/backends/sqlite3/base.py", line 206, in get_new_connection healthchecks-hc-1 | conn = Database.connect(**conn_params) healthchecks-hc-1 | sqlite3.OperationalError: unable to open database file ```
kerem closed this issue 2026-02-25 23:42:30 +03:00
kerem commented 2026-02-25 23:42:31 +03:00
Author
Owner
Copy link

@cuu508 commented on GitHub (Mar 25, 2022):

Does the directory /db/ exist? Do you have write permission on it?

<!-- gh-comment-id:1079376370 --> @cuu508 commented on GitHub (Mar 25, 2022): Does the directory `/db/` exist? Do you have write permission on it?
kerem commented 2026-02-25 23:42:31 +03:00
Author
Owner
Copy link

@alyvusal commented on GitHub (Mar 26, 2022):

Hi, I did not read about it on docs and docker hub. Now adding 999:999 solved issue. Thanks

<!-- gh-comment-id:1079674694 --> @alyvusal commented on GitHub (Mar 26, 2022): Hi, I did not read about it on docs and docker hub. Now adding 999:999 solved issue. Thanks
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
py2
v4.1.1
v4.1
v4.0
v3.13
v3.12
v3.11.2
v3.11.1
v3.11
v3.10
v3.9
v3.8.2
v3.8.1
v3.8
v3.7
v3.6
v3.5.2
v3.5.1
v3.5
v3.4
v3.3
v3.2
v3.1
v3.0.1
v3.0
v2.10
v2.9.2
v2.9.1
v2.9
v2.8.1
v2.8
v2.7
v2.6.1
v2.6
v2.5
v2.4.1
v2.4
v2.3
v2.2.1
v2.2
v2.1
v2.0.1
v2.0
v1.25.0
v1.24.1
v1.24.0
v1.23.1
v1.23.0
v1.22.0
v1.21.0
v1.20.0
v1.19.0
v1.18.0
v1.17.0
v1.16.0
v1.15.0
v1.14.0
v1.13.0
v1.12.0
v1.11.0
v1.10.0
v1.9.0
v1.8.0
v1.7.0
v1.6.0
v1.5.0
v1.4.0
v1.3.0
v1.2.0
v1.1.0
v1.0.4
v1.0.3
v1.0.2
1.0.2
v1.0.1
v1.0
Labels
Clear labels   
bug

   
bug

   
bug

   
feature

   
good-first-issue

   
new integration

   
pull-request

Mirrored from GitHub Pull Request

  
question
No labels
bug
bug
bug
feature
good-first-issue
new integration
pull-request
question
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/healthchecks#451
No description provided.