Back

Attribute limit exceeded

  • 0
  • Self Hosted
  • Flutter
  • Users
Ansh
18 May, 2023, 21:38

this error is coming when i try to create two attributes with 10000 size each what seems to be the problem??

TL;DR
The user is asking why they need to use 10,000 characters and the solution is to increase the size to avoid exceeding the attribute limit. The error is occurring when trying to create two attributes with a size of 10,000 each.
Drake
18 May, 2023, 21:44

because Appwrite uses utf8mb4 charset, 10,000 chars = 40,000 bytes. 2 attributes = 80,000 bytes. The maximum row size in mariadb is 65,535 bytes: https://mariadb.com/kb/en/innodb-limitations/#:~:text=MariaDB%20imposes%20a%20row%2Dsize,file%20size%20limit%20of%202GB.

Drake
18 May, 2023, 21:46

the solution is to use a bigger size so that the data isn't actually stored in the row, but a pointer is used. bigger than 16,383

🍜Udon🍜
18 May, 2023, 23:09

Why would you need to use 10,000 characters if you don't mind me asking @Ansh 🤔

Ansh
19 May, 2023, 10:18

no no i do mind🤣

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