search

alexjustesen / speedtest-tracker

Speedtest Tracker is a self-hosted internet performance tracking application that runs speedtest checks against Ookla's Speedtest service.
https://speedtest-tracker.dev/
MIT License
2.89k stars 106 forks source link

Broken since this morning #1088

Closed Jaxel closed 9 months ago

Jaxel commented 9 months ago

Will not boot since this morning. On Synology Container Manager.

2024/02/02 07:05:45 | stderr | prog: fatal: stopping the container.
-- | -- | --
2024/02/02 07:05:45 | stderr | /run/s6/basedir/scripts/rc.init: warning: s6-rc failed to properly bring all the services up! Check your logs (in /run/uncaught-logs/current if you have in-container logging) for more information.
2024/02/02 07:05:45 | stderr | s6-rc: warning: unable to start service laravel-automations: command exited 1
2024/02/02 07:05:45 | stdout |  
2024/02/02 07:05:45 | stdout |  
2024/02/02 07:05:45 | stdout | SQLSTATE[HY000] [2002] Connection refused
2024/02/02 07:05:45 | stdout |  
2024/02/02 07:05:45 | stdout | In Connector.php line 65:
2024/02/02 07:05:45 | stdout |  
2024/02/02 07:05:45 | stdout |  
2024/02/02 07:05:45 | stdout | rom `cache`)
2024/02/02 07:05:45 | stdout | SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: delete f
2024/02/02 07:05:45 | stdout |  
2024/02/02 07:05:45 | stdout | In Connection.php line 829:
2024/02/02 07:05:45 | stderr | "}
2024/02/02 07:05:45 | stderr | #47 {main}
2024/02/02 07:05:45 | stderr | #46 /var/www/html/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
2024/02/02 07:05:45 | stderr | #45 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(201): Symfony\\Component\\Console\\Application->run()
2024/02/02 07:05:45 | stderr | #44 /var/www/html/vendor/symfony/console/Application.php(175): Symfony\\Component\\Console\\Application->doRun()
2024/02/02 07:05:45 | stderr | #43 /var/www/html/vendor/symfony/console/Application.php(324): Symfony\\Component\\Console\\Application->doRunCommand()
2024/02/02 07:05:45 | stderr | #42 /var/www/html/vendor/symfony/console/Application.php(1096): Illuminate\\Console\\Command->run()
2024/02/02 07:05:45 | stderr | #41 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run()
2024/02/02 07:05:45 | stderr | #40 /var/www/html/vendor/symfony/console/Command/Command.php(326): Illuminate\\Console\\Command->execute()
2024/02/02 07:05:45 | stderr | #39 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call()
2024/02/02 07:05:45 | stderr | #38 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
2024/02/02 07:05:45 | stderr | #37 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
2024/02/02 07:05:45 | stderr | #36 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
2024/02/02 07:05:45 | stderr | #35 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
2024/02/02 07:05:45 | stderr | #34 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Foundation\\Console\\OptimizeClearCommand->handle()
2024/02/02 07:05:45 | stderr | #33 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/OptimizeClearCommand.php(41): Illuminate\\Support\\Collection->each()
2024/02/02 07:05:45 | stderr | #32 /var/www/html/vendor/laravel/framework/src/Illuminate/Collections/Traits/EnumeratesValues.php(240): Illuminate\\Foundation\\Console\\OptimizeClearCommand->Illuminate\\Foundation\\Console\\{closure}()
2024/02/02 07:05:45 | stderr | #31 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/OptimizeClearCommand.php(41): Illuminate\\Console\\View\\Components\\Factory->__call()
2024/02/02 07:05:45 | stderr | #30 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/View/Components/Factory.php(58): Illuminate\\Console\\View\\Components\\Task->render()
2024/02/02 07:05:45 | stderr | #29 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(37): Illuminate\\Foundation\\Console\\OptimizeClearCommand->Illuminate\\Foundation\\Console\\{closure}()
2024/02/02 07:05:45 | stderr | #28 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/OptimizeClearCommand.php(37): Illuminate\\Console\\Command->callSilent()
2024/02/02 07:05:45 | stderr | #27 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(40): Illuminate\\Console\\Command->runCommand()
2024/02/02 07:05:45 | stderr | #26 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(67): Illuminate\\Console\\Command->run()
2024/02/02 07:05:45 | stderr | #25 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run()
2024/02/02 07:05:45 | stderr | #24 /var/www/html/vendor/symfony/console/Command/Command.php(326): Illuminate\\Console\\Command->execute()
2024/02/02 07:05:45 | stderr | #23 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call()
2024/02/02 07:05:45 | stderr | #22 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
2024/02/02 07:05:45 | stderr | #21 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
2024/02/02 07:05:45 | stderr | #20 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
2024/02/02 07:05:45 | stderr | #19 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
2024/02/02 07:05:45 | stderr | #18 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Cache\\Console\\ClearCommand->handle()
2024/02/02 07:05:45 | stderr | #17 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/Console/ClearCommand.php(69): Illuminate\\Cache\\Repository->__call()
2024/02/02 07:05:45 | stderr | #16 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(693): Illuminate\\Cache\\DatabaseStore->flush()
2024/02/02 07:05:45 | stderr | #15 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php(342): Illuminate\\Database\\Query\\Builder->delete()
2024/02/02 07:05:45 | stderr | #14 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3634): Illuminate\\Database\\Connection->delete()
2024/02/02 07:05:45 | stderr | #13 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(564): Illuminate\\Database\\Connection->affectingStatement()
2024/02/02 07:05:45 | stderr | #12 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(600): Illuminate\\Database\\Connection->run()
2024/02/02 07:05:45 | stderr | #11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(785): Illuminate\\Database\\Connection->handleQueryException()
2024/02/02 07:05:45 | stderr | #10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(962): Illuminate\\Database\\Connection->tryAgainIfCausedByLostConnection()
2024/02/02 07:05:45 | stderr | #9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(983): Illuminate\\Database\\Connection->runQueryCallback()
2024/02/02 07:05:45 | stderr | #8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(816): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
2024/02/02 07:05:45 | stderr | #7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(608): Illuminate\\Database\\Connection->getPdo()
2024/02/02 07:05:45 | stderr | #6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1339): call_user_func()
2024/02/02 07:05:45 | stderr | #5 [internal function]: Illuminate\\Database\\Connectors\\ConnectionFactory->Illuminate\\Database\\Connectors\\{closure}()
2024/02/02 07:05:45 | stderr | #4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\\Database\\Connectors\\MySqlConnector->connect()
2024/02/02 07:05:45 | stderr | #3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\\Database\\Connectors\\Connector->createConnection()
2024/02/02 07:05:45 | stderr | #2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(48): Illuminate\\Database\\Connectors\\Connector->tryAgainIfCausedByLostConnection()
2024/02/02 07:05:45 | stderr | #1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(83): Illuminate\\Database\\Connectors\\Connector->createPdoConnection()
2024/02/02 07:05:45 | stderr | #0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(65): PDO->__construct()
2024/02/02 07:05:45 | stderr | [stacktrace]
2024/02/02 07:05:45 | stderr | [previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:65)
2024/02/02 07:05:45 | stderr |  
2024/02/02 07:05:45 | stderr | #38 {main}
2024/02/02 07:05:45 | stderr | #37 /var/www/html/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
2024/02/02 07:05:45 | stderr | #36 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(201): Symfony\\Component\\Console\\Application->run()
2024/02/02 07:05:45 | stderr | #35 /var/www/html/vendor/symfony/console/Application.php(175): Symfony\\Component\\Console\\Application->doRun()
2024/02/02 07:05:45 | stderr | #34 /var/www/html/vendor/symfony/console/Application.php(324): Symfony\\Component\\Console\\Application->doRunCommand()
2024/02/02 07:05:45 | stderr | #33 /var/www/html/vendor/symfony/console/Application.php(1096): Illuminate\\Console\\Command->run()
2024/02/02 07:05:45 | stderr | #32 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run()
2024/02/02 07:05:45 | stderr | #31 /var/www/html/vendor/symfony/console/Command/Command.php(326): Illuminate\\Console\\Command->execute()
2024/02/02 07:05:45 | stderr | #30 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call()
2024/02/02 07:05:45 | stderr | #29 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
2024/02/02 07:05:45 | stderr | #28 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
2024/02/02 07:05:45 | stderr | #27 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
2024/02/02 07:05:45 | stderr | #26 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
2024/02/02 07:05:45 | stderr | #25 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Foundation\\Console\\OptimizeClearCommand->handle()
2024/02/02 07:05:45 | stderr | #24 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/OptimizeClearCommand.php(41): Illuminate\\Support\\Collection->each()
2024/02/02 07:05:45 | stderr | #23 /var/www/html/vendor/laravel/framework/src/Illuminate/Collections/Traits/EnumeratesValues.php(240): Illuminate\\Foundation\\Console\\OptimizeClearCommand->Illuminate\\Foundation\\Console\\{closure}()
2024/02/02 07:05:45 | stderr | #22 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/OptimizeClearCommand.php(41): Illuminate\\Console\\View\\Components\\Factory->__call()
2024/02/02 07:05:45 | stderr | #21 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/View/Components/Factory.php(58): Illuminate\\Console\\View\\Components\\Task->render()
2024/02/02 07:05:45 | stderr | #20 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(37): Illuminate\\Foundation\\Console\\OptimizeClearCommand->Illuminate\\Foundation\\Console\\{closure}()
2024/02/02 07:05:45 | stderr | #19 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/OptimizeClearCommand.php(37): Illuminate\\Console\\Command->callSilent()
2024/02/02 07:05:45 | stderr | #18 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(40): Illuminate\\Console\\Command->runCommand()
2024/02/02 07:05:45 | stderr | #17 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(67): Illuminate\\Console\\Command->run()
2024/02/02 07:05:45 | stderr | #16 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run()
2024/02/02 07:05:45 | stderr | #15 /var/www/html/vendor/symfony/console/Command/Command.php(326): Illuminate\\Console\\Command->execute()
2024/02/02 07:05:45 | stderr | #14 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call()
2024/02/02 07:05:45 | stderr | #13 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
2024/02/02 07:05:45 | stderr | #12 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
2024/02/02 07:05:45 | stderr | #11 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
2024/02/02 07:05:45 | stderr | #10 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
2024/02/02 07:05:45 | stderr | #9 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Cache\\Console\\ClearCommand->handle()
2024/02/02 07:05:45 | stderr | #8 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/Console/ClearCommand.php(69): Illuminate\\Cache\\Repository->__call()
2024/02/02 07:05:45 | stderr | #7 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(693): Illuminate\\Cache\\DatabaseStore->flush()
2024/02/02 07:05:45 | stderr | #6 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php(342): Illuminate\\Database\\Query\\Builder->delete()
2024/02/02 07:05:45 | stdout |  
2024/02/02 07:05:45 | stderr | #5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3634): Illuminate\\Database\\Connection->delete()
2024/02/02 07:05:45 | stderr | #4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(564): Illuminate\\Database\\Connection->affectingStatement()
2024/02/02 07:05:45 | stderr | #3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(600): Illuminate\\Database\\Connection->run()
2024/02/02 07:05:45 | stderr | #2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(785): Illuminate\\Database\\Connection->handleQueryException()
2024/02/02 07:05:45 | stderr | #1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(962): Illuminate\\Database\\Connection->tryAgainIfCausedByLostConnection()
2024/02/02 07:05:45 | stderr | #0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(983): Illuminate\\Database\\Connection->runQueryCallback()
2024/02/02 07:05:45 | stderr | [stacktrace]
2024/02/02 07:05:45 | stderr | [2024-02-02 12:05:45] production.ERROR: SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: delete from `cache`) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 2002): SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: delete from `cache`) at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829)
2024/02/02 07:05:44 | stdout | 🧹  Clearing any previous caches...
2024/02/02 07:05:44 | stdout |  
2024/02/02 07:05:44 | stdout | ✅  Permissions fixed.
2024/02/02 07:05:44 | stdout | 🔒  Fixing app path file permissions...
2024/02/02 07:05:44 | stdout |  
2024/02/02 07:05:44 | stdout | 🐇  Configuring Speedtest Tracker...
2024/02/02 07:05:44 | stdout |  
2024/02/02 07:05:44 | stdout | 🔒 SSL_MODE has been set to MIXED, setting the web server to work in HTTP + HTTPS...
2024/02/02 07:05:44 | stdout |  
2024/02/02 07:05:44 | stdout | -------------------------------------
2024/02/02 07:05:44 | stdout | User gid:    100
2024/02/02 07:05:44 | stdout | User uid:    1028
2024/02/02 07:05:44 | stdout |  
2024/02/02 07:05:44 | stdout | -------------------------------------
2024/02/02 07:05:44 | stdout | GID/UID
2024/02/02 07:05:44 | stdout | -------------------------------------
2024/02/02 07:05:44 | stdout | https://github.com/alexjustesen/speedtest-tracker
2024/02/02 07:05:44 | stdout | To support Speedtest Tracker visit:
2024/02/02 07:05:44 | stdout |  
2024/02/02 07:05:44 | stdout | --------------------------------------------------------------------
2024/02/02 07:05:44 | stdout |  
2024/02/02 07:05:44 | stdout |  
2024/02/02 07:05:44 | stdout | \|___\|  \|__\| \|___._\|____\|\|__\|__\|_____\|__\|
2024/02/02 07:05:44 | stdout | \|   \|  \|   _\|  _  \|  __\|\|    <\|  -__\|   _\|
2024/02/02 07:05:44 | stdout | \|_     _\|.----.---.-.----.\|  \|--.-----.----.
2024/02/02 07:05:44 | stdout | _______                   __
2024/02/02 07:05:44 | stdout | \|__\|
2024/02/02 07:05:44 | stdout | \|_______\|\|   __\|_____\|_____\|_____\|____\|_____\|_____\|\|____\|
2024/02/02 07:05:44 | stdout | \|__     \|\|  _  \|  -__\|  -__\|  _  \|   _\|  -__\|__ --\|\|   _\|
2024/02/02 07:05:44 | stdout | \|     __\|.-----.-----.-----.--\|  \|  \|_.-----.-----.\|  \|_
2024/02/02 07:05:44 | stdout | _______                       __ __                __
2024/02/02 07:05:44 | stdout |  
2024/02/02 07:05:44 | stdout | --------------------------------------------------------------------
masterwishx commented 9 months ago

having same issue ,using sqlite in Unraid docker lasted version

masterwishx commented 9 months ago

image

image

hummelmose commented 9 months ago

I have t he same issue on Portainer - Docker

running: ghcr.io/alexjustesen/speedtest-tracker:latest

Gets the following error:

In Connection.php line 829:

SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: delete f
rom cache)

In Connector.php line 65:

SQLSTATE[HY000] [2002] Connection refused

spupuz commented 9 months ago

same error here since this morning.

grimsi commented 9 months ago

The issue is caused by #1084. To revert back to the old default behaviour, set the environment variable CACHE_DRIVER to file.

@alexjustesen Breaking changes like this should probably be moved to major version upgrades or at least have better logging so the users know what is causing the issue and can fix this without needing to look at the commit history.

hummelmose commented 9 months ago

Until the error is fixed you can go back to last working version, by changing image line to:

image: 'ghcr.io/alexjustesen/speedtest-tracker:v0.14.4'

Jaxel commented 9 months ago

The issue is caused by #1084. To revert back to the old default behaviour, set the environment variable CACHE_DRIVER to file.

@alexjustesen Breaking changes like this should probably be moved to major version upgrades or at least have better logging so the users know what is causing the issue and can fix this without needing to look at the commit history.

Doing this return a new error about missing encryption keys. Don't know what that is.

hummelmose commented 9 months ago

@Jaxel tried:

It still broken

yllekz commented 9 months ago

Confirmed adding this to my yml in my environment variables section fixed it:

- CACHE_DRIVER="file"

Ja50n-Kru commented 9 months ago

Confirmed, adding CACHE_DRIVER as a new variable in the UnRaid template fixes it and it now works.

vdrover commented 9 months ago

Following. Will you report here when a new verison is released that solves the issue? Will the new environment variable be needed in future versions?

thezoggy commented 9 months ago

when there is breaking changes like this being done on a version, can you kindly add them to a changelog/release notes for that version so people would know how to fix vs just having it break and having to stumble across a github issue

Aiakio commented 9 months ago

The issue is caused by #1084. To revert back to the old default behaviour, set the environment variable CACHE_DRIVER to file.

Sadly this doesnt work for me. Still the exact same error.

simonspg commented 9 months ago

I am attempting to install speedtest-tracker with a new Postgres database. First, using 0.14.4 fixed the issue. But my log is different from what has been pointed out by existing users, so I thought that I would add it FWIW: 2024-02-02T07:50:42.132509923-08:00 stdout F 🐇 Configuring Speedtest Tracker... 2024-02-02T07:50:42.132511472-08:00 stdout F 2024-02-02T07:50:42.132512796-08:00 stdout F 🔒 Fixing app path file permissions... 2024-02-02T07:50:42.141796543-08:00 stdout F ✅ Permissions fixed. 2024-02-02T07:50:42.14180724-08:00 stdout F 2024-02-02T07:50:42.141809294-08:00 stdout F 🧹 Clearing any previous caches... 2024-02-02T07:50:42.339491616-08:00 stderr F [2024-02-02 15:50:42] production.ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "cache" does not exist 2024-02-02T07:50:42.339505037-08:00 stderr F LINE 1: delete from "cache" 2024-02-02T07:50:42.339506737-08:00 stderr F ^ (Connection: pgsql, SQL: delete from "cache") {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42P01): SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"cache\" does not exist 2024-02-02T07:50:42.339508029-08:00 stderr F LINE 1: delete from \"cache\" 2024-02-02T07:50:42.339518148-08:00 stderr F ^ (Connection: pgsql, SQL: delete from \"cache\") at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829) 2024-02-02T07:50:42.339519517-08:00 stderr F [stacktrace] I won't bore you with the stacktrace.

alexjustesen commented 9 months ago

For those having cache issues, follow the debug steps in this comment: https://github.com/alexjustesen/speedtest-tracker/issues/1035#issuecomment-1924907035

masterwishx commented 9 months ago

For those having cache issues, follow the debug steps in this comment: #1035 (comment)

have: CACHE_DRIVER=database in .env file

image

image

hoorna commented 9 months ago

@alexjustesen Since upgrading speedtest-tracker to v0.14.5 I have the same issue as the topic starter. I did not changed anything before upgrading (from v0.14.4). I just created a new container with the new v10.14.5 image. I had no environment variable CACHE_DRIVER in my .env file (nor in my docker compose file) so speedtest-tracker used the default value 'file'.

Setting the environment CACHE_DRIVER to database does not solve the issue. I have now reverted back to image v0.14.4; speedtest-tracker is working again.

hummelmose commented 9 months ago

Here's my Portainer YAML file - The CACHE_DRIVER setting didn't solve it for me either, so I also stay on 0.14.4

services: speedtest-tracker: container_name: speedtest-tracker ports:

pbek commented 9 months ago

Setting CACHE_DRIVER=file only worked for me after I manually removed the container and then did a docker compose up -d again. Now I'm at latest and speedtest-tracker is working again. It doesn't work if you don't remove the old container.

Aiakio commented 9 months ago

Setting CACHE_DRIVER=file only worked for me after I manually removed the container and then did a docker compose up -d again. Now I'm at latest and speedtest-tracker is working again. It doesn't work if you don't remove the old container.

I did remove the old container/image and redownloaded it, all through Portainer. Didn't work for me.

alexjustesen commented 9 months ago

Setting the environment CACHE_DRIVER to database does not solve the issue. I have now reverted back to image v0.14.4; speedtest-tracker is working again.

Did you restart the container after changing the config?

hoorna commented 9 months ago

@alexjustesen, sure I did. After that I checked in the container with "php artisan about" if "cache" indeed was set to database; it was.

Jaxel commented 9 months ago

CACHE_DRIVER worked for me, ONLY after I completely deleted the /config/www folder.

Rahzadan commented 9 months ago

The solution for me was to change DB_HOST env variable to DB_DATABASE. After that, no need to manually specify CACHE_DRIVER.