Back

SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'value' at row 1

  • 0
  • Databases
  • Accounts
  • General
  • Self Hosted
  • Users
kathelia.dokgu
19 Jul, 2023, 16:07

So I'm not sure what caused this but the only thing I know I did was testing out multiple Sign in with Google - I used my personal account and a disposable Gmail account. Once I was happy with it, I went into the Appwrite console and deleted the disposable account from the list of users under the Auth page.

Now Sentry is reporting this error for me regularly. I've gotten over 1.3k events since last night.

Here's the stack trace from Sentry:

TypeScript
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'value' at row 1: null
#10 /usr/src/code/src/Appwrite/Extend/PDOStatement.php(88): execute
#9 /usr/src/code/vendor/utopia-php/database/src/Database/Adapter/MariaDB.php(607): execute
#8 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(2511): createDocument
#7 /usr/src/code/src/Appwrite/Usage/Calculators/TimeSeries.php(421): createDocument
#6 /usr/src/code/src/Appwrite/Usage/Calculators/TimeSeries.php(503): createOrUpdateMetric
#5 /usr/src/code/src/Appwrite/Usage/Calculators/TimeSeries.php(528): syncFromInfluxDB
#4 /usr/src/code/app/tasks/usage.php(132): collect
#3 /usr/src/code/vendor/utopia-php/cli/src/CLI/Console.php(208): {closure}
#2 /usr/src/code/app/tasks/usage.php(137): loop
#1 /usr/src/code/vendor/utopia-php/cli/src/CLI/CLI.php(233): {closure}
#0 /usr/src/code/app/cli.php(32): run
TL;DR
The user is experiencing an error message regarding a numeric value being out of range for a column in their database. They noticed high RAM usage but did not find any issues with the dashboard. They are seeking advice on how to fix this issue. There is a suggestion to ignore the errors temporarily while the usage is being rewritten. The user mentions that they were testing multiple sign-ins with Google and deleted a disposable account from the user list in the Appwrite console before experiencing these errors. The stack trace from Sentry is provided. Solution: It is recommended to ignore the errors temporarily as they may be caused by a bug in the usage system, which
kathelia.dokgu
19 Jul, 2023, 17:10

@Steven Do you have any idea what this could be and how to fix it? I've temporarily ignored these events in Sentry for a day because it was eating up a lot of my usage limits and I'm hoping I could get this sorted out before then.

Drake
19 Jul, 2023, 17:11

it could be a bug with the usage. We're rewriting it so best to ignore these for now

kathelia.dokgu
19 Jul, 2023, 17:15

Okay thank you. Hopefully it doesn't break anything.

Drake
19 Jul, 2023, 17:19

your usage info just might look incorrect

kathelia.dokgu
19 Jul, 2023, 17:36

That's fine, I don't look at it that much anyway.

D5
19 Jul, 2023, 17:37

I'm seeing similar errors in sentry. Usage in the dashboard seems to be correct, but high ram usage 🤔

Reply

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