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

6 messages · Page 1 of 1 (latest)

sinful moat
#

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:

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
sinful moat
#

@high sinew 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.

high sinew
sinful moat
#

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

high sinew
sinful moat
#

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