Out of range value for column 'value' at row 1

I'm running a self-hosted instance of Appwrite integrated with Sentry to track errors. The following error trace is very frequent. Based on the trace, it seems like it is something related to createOrUpdateMetric

TypeScript

#1 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(2626): Utopia\Database\Adapter\MariaDB->createDocument('stats', Object(Utopia\Database\Document))
#2 /usr/src/code/src/Appwrite/Usage/Calculators/TimeSeries.php(439): Utopia\Database\Database->createDocument(Object(Utopia\Database\Document), Object(Utopia\Database\Document))
#3 /usr/src/code/src/Appwrite/Usage/Calculators/TimeSeries.php(521): Appwrite\Usage\Calculators\TimeSeries->createOrUpdateMetric('64f0d151afbeeea...', '2023-09-02T18:0...', '1h', 'users.$all.coun...', -1, 0)
#4 /usr/src/code/src/Appwrite/Usage/Calculators/TimeSeries.php(546): Appwrite\Usage\Calculators\TimeSeries->syncFromInfluxDB('users.$all.coun...', Array, Array)
#5 /usr/src/code/src/Appwrite/Platform/Tasks/Usage.php(53): Appwrite\Usage\Calculators\TimeSeries->collect()
#6 /usr/src/code/vendor/utopia-php/cli/src/CLI/Console.php(219): Appwrite\Platform\Tasks\Usage->Appwrite\Platform\Tasks\{closure}()
#7 /usr/src/code/src/Appwrite/Platform/Tasks/Usage.php(58): Utopia\CLI\Console::loop(Object(Closure), 30)
#8 /usr/src/code/src/Appwrite/Platform/Tasks/Usage.php(30): Appwrite\Platform\Tasks\Usage->action(Object(Utopia\Database\Database), Object(InfluxDB\Database), Object(Utopia\Registry\Registry), Object(Closure), Object(Closure))
#9 /usr/src/code/vendor/utopia-php/cli/src/CLI/CLI.php(320): Appwrite\Platform\Tasks\Usage->Appwrite\Platform\Tasks\{closure}(Object(Utopia\Database\Database), Object(InfluxDB\Database), Object(Utopia\Registry\Registry), Object(Closure), Object(Closure))
#10 /usr/src/code/app/cli.php(195): Utopia\CLI\CLI->run()
#11 {main}```

TL;DR

The user is facing an error in their self-hosted instance of Appwrite. The error message states "Out of range value for column 'value' at row 1." The error trace suggests that the issue is related to the `createOrUpdateMetric` function. The user mentions a related GitHub issue but doesn't provide any additional information. However, they mention that they plan to release a rewrite to address the problems with usage. Solution: The TL;DR only provides information about the issue and doesn't include a solution.

yes....we have problems with usage and have planned to release a rewrite.

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more

Recommended threads

Need support?

Join our Discord

Get premium support