[Question] Server Error 500 - Database does not exist

[olli991]

Pre-work

• I have read the docs.
• I have searched open and closed issues.
• I agree to follow this project's Code of Conduct.

Description

I've gotten the same error as in closed issues #1758 and #2292 but those issues couldn't solve my issue.

The container ran fine and suddelny crashed. I already completly deleted the container files, the image and everything to setup it from new but i'ts always the same.

I am running anothe rinstance on another machine without any problems with the same compose (other encryption)

Expected Behavior

A not crashing container.

Steps to Reproduce

1. Completly deleted the /config directory and image
2. Built new from docker-compose
3. Same error every time

Deployment Environment

Docker Compose

Application Information

root@speedtest-tracker:/# php artisan about --json
Could not open input file: artisan

What browser(s) are you seeing the problem on?

Chrome

Logs

Log from Container:

[2025-12-09 22:34:33] production.ERROR: Database file at path [/app/www/database/database.sqlite] does not exist. Ensure this is an absolute path to the database. (Connection: sqlite, SQL: select * from "cache" where "key" in (laravel_cache_illuminate:queue:restart)) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 0): Database file at path [/app/www/database/database.sqlite] does not exist. Ensure this is an absolute path to the database. (Connection: sqlite, SQL: select * from \"cache\" where \"key\" in (laravel_cache_illuminate:queue:restart)) at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:826)

�
[stacktrace]

#0 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(780): Illuminate\\Database\\Connection->runQueryCallback()

#1 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(397): Illuminate\\Database\\Connection->run()

#2 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3188): Illuminate\\Database\\Connection->select()

#3 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3173): Illuminate\\Database\\Query\\Builder->runSelect()

#4 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3763): Illuminate\\Database\\Query\\Builder->{closure:Illuminate\\Database\\Query\\Builder::get():3172}()

#5 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3172): Illuminate\\Database\\Query\\Builder->onceWithColumns()

#6 /app/www/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php(130): Illuminate\\Database\\Query\\Builder->get()

#7 /app/www/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php(105): Illuminate\\Cache\\DatabaseStore->many()

#8 /app/www/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(119): Illuminate\\Cache\\DatabaseStore->get()

#9 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(780): Illuminate\\Cache\\Repository->get()

#10 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(160): Illuminate\\Queue\\Worker->getTimestampOfLastQueueRestart()

#11 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\\Queue\\Worker->daemon()

#12 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\\Queue\\Console\\WorkCommand->runWorker()

#13 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()

#14 /app/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()

#15 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\\Container\\Util::unwrapIfClosure()

#16 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()

#17 /app/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(807): Illuminate\\Container\\BoundMethod::call()

#18 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call()

#19 /app/www/vendor/symfony/console/Command/Command.php(335): Illuminate\\Console\\Command->execute()

#20 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run()

#21 /app/www/vendor/symfony/console/Application.php(1103): Illuminate\\Console\\Command->run()

#22 /app/www/vendor/symfony/console/Application.php(356): Symfony\\Component\\Console\\Application->doRunCommand()

#23 /app/www/vendor/symfony/console/Application.php(195): Symfony\\Component\\Console\\Application->doRun()

#24 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()

#25 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1235): Illuminate\\Foundation\\Console\\Kernel->handle()

#26 /app/www/artisan(16): Illuminate\\Foundation\\Application->handleCommand()

#27 {main}

[previous exception] [object] (Illuminate\\Database\\SQLiteDatabaseDoesNotExistException(code: 0): Database file at path [/app/www/database/database.sqlite] does not exist. Ensure this is an absolute path to the database. at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connectors/SQLiteConnector.php:60)

�
[stacktrace]

#0 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connectors/SQLiteConnector.php(19): Illuminate\\Database\\Connectors\\SQLiteConnector->parseDatabasePath()

#1 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(223): Illuminate\\Database\\Connectors\\SQLiteConnector->connect()

#2 [internal function]: Illuminate\\Database\\Connectors\\ConnectionFactory->{closure:Illuminate\\Database\\Connectors\\ConnectionFactory::createPdoResolverWithoutHosts():223}()

#3 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1236): call_user_func()

#4 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1272): Illuminate\\Database\\Connection->getPdo()

#5 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(511): Illuminate\\Database\\Connection->getReadPdo()

#6 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(406): Illuminate\\Database\\Connection->getPdoForSelect()

#7 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(813): Illuminate\\Database\\Connection->{closure:Illuminate\\Database\\Connection::select():397}()

#8 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(780): Illuminate\\Database\\Connection->runQueryCallback()

#9 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(397): Illuminate\\Database\\Connection->run()

#10 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3188): Illuminate\\Database\\Connection->select()

#11 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3173): Illuminate\\Database\\Query\\Builder->runSelect()

#12 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3763): Illuminate\\Database\\Query\\Builder->{closure:Illuminate\\Database\\Query\\Builder::get():3172}()

#13 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3172): Illuminate\\Database\\Query\\Builder->onceWithColumns()

#14 /app/www/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php(130): Illuminate\\Database\\Query\\Builder->get()

#15 /app/www/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php(105): Illuminate\\Cache\\DatabaseStore->many()

#16 /app/www/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(119): Illuminate\\Cache\\DatabaseStore->get()

#17 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(780): Illuminate\\Cache\\Repository->get()

#18 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(160): Illuminate\\Queue\\Worker->getTimestampOfLastQueueRestart()

#19 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\\Queue\\Worker->daemon()

#20 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\\Queue\\Console\\WorkCommand->runWorker()

#21 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()

#22 /app/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()

#23 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\\Container\\Util::unwrapIfClosure()

#24 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()

#25 /app/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(807): Illuminate\\Container\\BoundMethod::call()

#26 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call()

#27 /app/www/vendor/symfony/console/Command/Command.php(335): Illuminate\\Console\\Command->execute()

#28 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run()

#29 /app/www/vendor/symfony/console/Application.php(1103): Illuminate\\Console\\Command->run()

#30 /app/www/vendor/symfony/console/Application.php(356): Symfony\\Component\\Console\\Application->doRunCommand()

#31 /app/www/vendor/symfony/console/Application.php(195): Symfony\\Component\\Console\\Application->doRun()

#32 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()

#33 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1235): Illuminate\\Foundation\\Console\\Kernel->handle()

#34 /app/www/artisan(16): Illuminate\\Foundation\\Application->handleCommand()

#35 {main}

"} 

In Connection.php line 826:

                                                                               

  Database file at path [/app/www/database/database.sqlite] does not exist. E  

  nsure this is an absolute path to the database. (Connection: sqlite, SQL: s  

  elect * from "cache" where "key" in (laravel_cache_illuminate:queue:restart  

  ))                                                                           

                                                                               

In SQLiteConnector.php line 60:

                                                                               

  Database file at path [/app/www/database/database.sqlite] does not exist. E  

  nsure this is an absolute path to the database.

Info from APP_DEBUG:

Illuminate\Database\QueryException - Internal Server Error

Database file at path [/app/www/database/database.sqlite] does not exist. Ensure this is an absolute path to the database. (Connection: sqlite, SQL: select * from "sessions" where "id" = sDMoIJsEQTheqrh17DvqUwFZeSsqvz6rEW8ze89Y limit 1)

PHP 8.4.14
Laravel 12.41.1
speed.SECRET.tld

## Stack Trace

0 - vendor/laravel/framework/src/Illuminate/Database/Connection.php:826
1 - vendor/laravel/framework/src/Illuminate/Database/Connection.php:780
2 - vendor/laravel/framework/src/Illuminate/Database/Connection.php:397
3 - vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3188
4 - vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3173
5 - vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3763
6 - vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3172
7 - vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php:366
8 - vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3095
9 - vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:96
10 - vendor/laravel/framework/src/Illuminate/Session/Store.php:117
11 - vendor/laravel/framework/src/Illuminate/Session/Store.php:105
12 - vendor/laravel/framework/src/Illuminate/Session/Store.php:89
13 - vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:146
14 - vendor/laravel/framework/src/Illuminate/Support/helpers.php:485
15 - vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:143
16 - vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:115
17 - vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
18 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
19 - vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:36
20 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
21 - vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:74
22 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
23 - app/Http/Middleware/AllowedIpAddressesMiddleware.php:19
24 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
25 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:137
26 - vendor/laravel/framework/src/Illuminate/Routing/Router.php:821
27 - vendor/laravel/framework/src/Illuminate/Routing/Router.php:800
28 - vendor/laravel/framework/src/Illuminate/Routing/Router.php:764
29 - vendor/laravel/framework/src/Illuminate/Routing/Router.php:753
30 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:200
31 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
32 - vendor/livewire/livewire/src/Features/SupportDisablingBackButtonCache/DisableBackButtonCacheMiddleware.php:19
33 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
34 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
35 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31
36 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
37 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
38 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:51
39 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
40 - vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php:27
41 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
42 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:109
43 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
44 - vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php:48
45 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
46 - vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php:58
47 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
48 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php:22
49 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
50 - vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php:26
51 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
52 - vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:137
53 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:175
54 - vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:144
55 - vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1220
56 - public/index.php:20

## Request

GET /

## Headers

* **cookie**: remember_web_59ba36addc2b2f9401580f014c7f58ea4e30989d=eyJpdiI6ImR2eUZ3anQ0WEw3QVlTU3hsd3FHZkE9PSIsInZhbHVlIjoiaFpaNVl0NUFGVFYxRGtKdG9Td2dhbmMwZmJ4Wi92VlRrNmw3ZkROQ3RNNWt2L2YzS2sweUdDczNkYms1ZmlWdEJjTTBVQW9JOHlOQUI4d0s5VnFMd0ZkL1BoMitheUhRU0h4cXVPUGI3d2dBQm1SczhHdFVWSHM4bHRLbXhIdUJKTXdjd1hFTG42dG51bUl0SjB0dVlETzN5L1ZjLzNnY3VwcWdwU1R1Uys1d3BhZzVqNllpTklpLzh4MlJqSTRicDdNcXhpODJiRjBXNXVvUVdaTHJ2YUw0dEVIcFpXTFJBZmdBODFDVWdFVT0iLCJtYWMiOiJiZWVhYzcyZmE0ODVmMDlhOTllNmYyOTIwZjQwZTgwNDdlNTc1ZjNhZWU4ZDYzNjhmYzk2NDRjYzEyNzBlN2IzIiwidGFnIjoiIn0%3D; cf_clearance=ARx5PhUD97TUlSvDXg5YQWHP8ikNUZiGBVbIcAS6Luo-1765313562-1.2.1.1-UjxomsYaHMBNnHJA15.E9XDUtnUE.DLjgRkzMlwmnIv1ElG.ENeCzMJPAdd8mZyjrAmPPcjAMFQmInALOj6eOgGASp4eAPD1HSV3mD3BfraYX7ztVYIomSQxHSJqhOWM6HbIYlS0JjP4DHSeig0D4XbpuPwLlSj3c8RN_NrnP_5hEz2_Pz.QcYtNN.kGvtFEIBcyqoXfait0dEEYoDdVaOopSf9iLTnCw5rUY8Y8q0c
* **cf-visitor**: {"scheme":"https"}
* **cf-ipcountry**: DE
* **cf-connecting-ip**: 212.53.224.246
* **cdn-loop**: cloudflare; loops=1
* **sec-fetch-user**: ?1
* **sec-fetch-mode**: navigate
* **sec-fetch-site**: none
* **accept**: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7
* **user-agent**: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36
* **upgrade-insecure-requests**: 1
* **dnt**: 1
* **sec-ch-ua-platform**: "Windows"
* **sec-ch-ua-mobile**: ?0
* **sec-ch-ua**: "Google Chrome";v="143", "Chromium";v="143", "Not A(Brand";v="24"
* **accept-language**: de-DE,de;q=0.9,en-US;q=0.8,en;q=0.7
* **cf-ray**: 9ab77c696d09dcca-FRA
* **priority**: u=0, i
* **accept-encoding**: gzip, br
* **sec-fetch-dest**: document
* **x-real-ip**: SECRET
* **x-forwarded-for**: SECRET
* **x-forwarded-proto**: https
* **x-forwarded-scheme**: https
* **host**: speed.SECRET.tld

## Route Context

controller: App\Http\Controllers\HomeController
route name: home
middleware: web, getting-started, public-dashboard

## Route Parameters

No route parameter data available.

## Database Queries

No database queries detected.

Docker Compose:

version: '3.9'
services:
  speedtest-tracker:
    image: lscr.io/linuxserver/speedtest-tracker:latest
    container_name: speedtest-tracker
    hostname: speedtest-tracker
    security_opt:
      - no-new-privileges:true
    environment:
      - PUID=${PUID}
      - PGID=${PGID}
      - APP_TIMEZONE=${TZ}
      - APP_KEY=${SPEEDTEST_TRACKER_KEY}
      - APP_URL=${SPEEDTEST_TRACKER_URL}
      - DB_CONNECTION=sqlite
      - SPEEDTEST_SCHEDULE=9 */1 * * *
      - DATETIME_FORMAT=j M Y - G:i:s
      - DISPLAY_TIMEZONE=${TZ}
      - PUBLIC_DASHBOARD=false
      - APP_DEBUG=true
    ports:
      - 8082:80
      - 8143:443
    volumes:
      - ${DOCKER_DATA}/speedtest-tracker:/config
      #- /path/to-custom-ssl-keys:/config/keys
    labels:
      - homepage.group=Infra 1
      - homepage.weight=1
      - homepage.name=Internet
      - homepage.icon=mdi-web
      - homepage.href=${FRITZ_URL}
      - homepage.siteMonitor=${FRITZ_URL}
      - homepage.description=FRITZ!Box 7590 AX & Speedtest Tracker
      - homepage.widgets[0].type=fritzbox
      - homepage.widgets[0].url=http://${FRITZ_IP}
      - homepage.widgets[0].fields=["connectionStatus","uptime"]
      - homepage.widgets[1].type=speedtest
      - homepage.widgets[1].url=${SPEEDTEST_TRACKER_URL}
      - homepage.widgets[1].version=2
      - homepage.widgets[1].key=${SPEEDTEST_TRACKER_API}
      - com.centurylinklabs.watchtower.enable=true
    restart: unless-stopped  

[svenvg93]

Is the path defined for the volume still accessible for the PUID/PGID running the container? Seems that does not have the rights to create the DB file at the initial start up.

[olli991]

The user is the local admin user.
Also the folder gets populated on startup with several folders. Also a database file is placed in the root of the folder.

[alexjustesen]

Even though the host's user is the local admin you'll still want to pass in the PUID and the PGID. If that still doesn't work just touch database/database.sqlite into the mounted /config directory.

[olli991]

I'm a bit buzzled because my config folder has no database folder... the same as on my running machine.

performing touch on the existing one doesn't change anything.

also I'm passing over my PUID and GUID
The variables translate to:
1000:10

also from within the cointainer this seems right

[alexjustesen]

@olli991 can you make sure in /app/www another .env file doesn't exist?

[olli991]

Looks like there are two:

but looks the same on my working machine

[olli991]

Just a heads up: I'm happy to help and investigate to clear this issue once and for all.

But I'm on vacation now for a week and will not have access to my system. Just to let you know 🙃

[alexjustesen]

But I'm on vacation now for a week and will not have access to my system. Just to let you know 🙃

All good, enjoy your time off. I'm coming up on vacation soon as well so this might sit if I can't dig into it before Wednesday

[olli991]

I completly reinstalled docker on my machine from a barebone and still run into the exact same error and can't setup the container anymore :(

[alexjustesen]

You're running on a Synology DS right? If so make sure in the container settings the OS isn't trying to overwrite any environment variables. From what I've seen above everything is configured correctly.

[olli991]

It's running on a UGREEN NAS and doing it all via portainer on there.