this error is coming when i try to create two attributes with 10000 size each what seems to be the problem??
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.
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
Why would you need to use 10,000 characters if you don't mind me asking @Ansh 🤔
no no i do mind🤣
Recommended threads
- Unknown column 'sourceSize' in 'field li...
After migrating from 1.6.1 to 1.7.4 I noticed this message in the logs: `appwrite-worker-stats-resources | 2025-10-26T10:32:38.289577112Z Failed: SQLSTATE[...
- Invalid document structure: Missing requ...
After migrating from 1.6.1 to 1.7.4 I noticed this message in the logs: appwrite-worker-audits | 2025-10-26T11:15:24.062537020Z Error processing a...
- New attribute stuck on processing?
I was running out of disk space and after creating an attribute and restarting my appwrite (self hosted) I have an attribute stuck on creation. Any way to remov...