Self HostedFunctionsDatabases

MongoDb Database Breaks integer[] & bigint[]

Aug 7, 2026, 17:00Last activity 2 weeks ago

View on Discord

Votes

Replies

Participants

Messages

Tanner MeadeOriginal post

Rank 4: Virtual Machine

Aug 7, 2026, 16:03

I've got a table with the below column created. When I try to insert the value [-3408048000] into it, the dart sdk cloud function call is successful (no error logs in selfhosted docker). However, any attempt at loading the Rows tab in the console breaks: the UI breaks, a network request to /rows?queries... fails with error 500 ({"message":"Server Error","code":500,"type":"general_unknown","version":"1.9.6"}) and the docker logs has the below error:

http.request · 5.2ms · 59ffc126

  level              error
  http.method        GET
  http.path          /v1/tablesdb/:databaseId/tables/:tableId/rows
  http.response.code 500

  Error: Cannot use object of type MongoDB\BSON\Int64 as array
    at /usr/src/code/vendor/utopia-php/database/src/Database/Document.php:49
    at /usr/src/code/vendor/utopia-php/database/src/Database/Adapter/Mongo.php:2236
    at /usr/src/code/vendor/utopia-php/database/src/Database/Adapter/Pool.php:79
    at /usr/src/code/vendor/utopia-php/pools/src/Pools/Pool.php:229
    ... 13 more

Column CLI create command:

sudo appwrite databases create-integer-attribute \
            --database-id "$DATABASE_ID" \
            --collection-id "$COL_ID" \
            --key "listOfIntegers" \
            --array true \
            --required true

Summary

MongoDb Database has issues with integer[] and bigint[]. A GitHub issue has been created: https://github.com/appwrite/appwrite/issues/13175.

Tanner Meade

Rank 4: Virtual Machine

Aug 7, 2026, 16:05

I think the implication here is that -3408048000 can't fit in an integer data type, however it shouldn't break the database (only recovery I can find is to delete the entire table) and probably ought to throw an error when trying to write a number that is too large.

Tanner Meade

Rank 4: Virtual Machine

Aug 7, 2026, 16:10

Since the non-string data type list item writing was just fixed (https://discord.com/channels/564160730845151244/1534992967293603920/1535184001097269279) I can't test this in the console as a list, but when I create a non-list column of integer data type and create a row with -3408048000 for that column in the console, it works (saves correctly, doesn't break the table, and displays the full number for the column).

Tanner Meade

Rank 4: Virtual Machine

Aug 7, 2026, 17:15

MongoDb Database Breaks integer[] & bigint[]

Tanner Meade

Rank 4: Virtual Machine

Aug 7, 2026, 17:16

Still happens with a BigInt, so I don't think it's a data size issue:

sudo appwrite databases create-big-int-attribute \
            --database-id "$DATABASE_ID" \
            --collection-id "$COL_ID" \
            --key "listOfIntegers" \
            --array true \
            --required true

Tanner Meade

Rank 4: Virtual Machine

Aug 7, 2026, 17:19

The table doesn't appear to break until the row is inserted via the dart server sdk that has [-3408048000] for a integer or bigint data list column. I've logged the exact variable being saved to that column and it's exactly as I've described, and if I set it to [-42] it will work correctly (no breaking in the console).

Tanner Meade

Rank 4: Virtual Machine

Aug 10, 2026, 15:08

I believe the bug is caused by this line: https://github.com/utopia-php/database/blob/ce4e14e11cf8f9e6897015d5a7f8bb44a4b74949/src/Database/Document.php#L48

Tanner Meade

Rank 4: Virtual Machine

Aug 10, 2026, 15:10

My best guess is because the console had the array bug here mongoDB was never tested for array data types other than String, so currently mongoDB doesn't support bigint arrays because of this bug.

Tanner Meade

Rank 4: Virtual Machine

Aug 10, 2026, 19:54

Created github issue for this bug: https://github.com/appwrite/appwrite/issues/13175

MongoDb Database Breaks integer[] & bigint[]

Need support?_