[SOLVED] PDOException : MySQLServer has gone away when uploading into the storage bucket

Check the docker logs for your mariadb container

is this mysqld error 6 issue ? i am really lost understanding the logs...

mysqld signal 6 sorry...

starting with docker compose up .. i see that appwrite-worker is deleting a lot of documents...

and this is what always rolls up...

my latest flutter app is built flutter 3.7.8 ... dart sdk 2.19.5 i'm using appwrite 8.2.0 in pubspec yml... and i'm running appwrite 1.2.0...

iirc last time i updated my flutter apps built flutter 3.3.3 dart sdk 2.18 and with the same appwrite 1.2.0...

maybe upgrading may fix this ?

2 things:

1. FTS auxillary line is caused by a corrupted index. See https://dba.stackexchange.com/questions/195310/how-to-resolve-innodb-error-duplicate-key-writing-word-node-to-fts-auxiliary

2. MySQLd error 6 is another corrupt DB error. You can search online for that

appwrite-worker deletes a lot

Are you deleting things?

ALTER TABLE tablename ENGINE=InnoDB; how can i run this command though ?

You might also run docker stats to see how your system is handling things

i was deleting files from storage bukcet..but this always happens when starting up...

Then that might explain the deletes.

Your database is already corrupted so...ya, you'll have problems until it's fixed

i must admit i have no knowledge on mariadb... how do i got about fixing this ?

Can't help you there. I guess it's time for you to do some research 😜

gee.. i mean i use appwrite because i thought i don't have to deal with the underlying databases..

i find this thread https://github.com/appwrite/appwrite/issues/5157

docker compose exec mariadb sh -c 'mysql -uroot -p$MYSQL_ROOT_PASSWORD $MYSQL_DATABASE -e "show indexes from _2_database_3_collection_1"'

if i run the aboe... do i change $MYSQL_ROOT_PASSWORD with the rootpassword in my .env ?

When you self host, you have to manage and take care of the system including the database

No, $name dereferences an environment variable

@Steven Levey ALTER TABLE tablename ENGINE=InnoDB; is there a general guide on mariadb appwrite overview ? do i run this using docker compose exec 'mysql .. ' as well ?

These aren't appwrite specific things so I'm sure any resource you find online will suffice

this does the trick, as the how to i got the hint from https://discord.com/channels/564160730845151244/1087377262640365728/1087377262640365728 albeit i'm not able to follow the guide using datagrip but was able to find another way by use of docker exec -it into the mariadb container. can be marked as solved.

[SOLVED] PDOException : MySQLServer has gone away when uploading into the storage bucket