Hi,
I have been using Meilisync to sync data into Meilisearch for a while. Currently, I am facing "full-storage" issue with RDS (PostgreSQL).
With this query:
"SELECT slot_name, pg_current_wal_lsn(), restart_lsn,
pg_size_pretty(pg_wal_lsn_diff(pg_current_wal_lsn(), restart_lsn)) AS retained_wal
FROM pg_replication_slots
WHERE slot_name = 'meilisync';"
The restart_lsn result never changes when an Insert or Update event occurs, which leads to an increase in the amount of storage (Since the RDS retains the WAL log from the restart_lsn result). In my case, I set 1TB for the storage, and RDS reached the "full-storage" situation quickly (I couldn't connect to RDS until I increased the storage size).
Currently, I have to restart Meilisync and make an Insert or Update event (using the cron job). So that the restart_lsn will be updated, and the old WAL log will be removed.
Your app is very convenient, and I hope that you can improve it. If someone is facing the same problem, can use the way above to fix it temporarily.
Thanks.
Hi,
I have been using Meilisync to sync data into Meilisearch for a while. Currently, I am facing "full-storage" issue with RDS (PostgreSQL).
With this query:
"SELECT slot_name, pg_current_wal_lsn(), restart_lsn,
pg_size_pretty(pg_wal_lsn_diff(pg_current_wal_lsn(), restart_lsn)) AS retained_wal
FROM pg_replication_slots
WHERE slot_name = 'meilisync';"
The restart_lsn result never changes when an Insert or Update event occurs, which leads to an increase in the amount of storage (Since the RDS retains the WAL log from the restart_lsn result). In my case, I set 1TB for the storage, and RDS reached the "full-storage" situation quickly (I couldn't connect to RDS until I increased the storage size).
Currently, I have to restart Meilisync and make an Insert or Update event (using the cron job). So that the restart_lsn will be updated, and the old WAL log will be removed.
Your app is very convenient, and I hope that you can improve it. If someone is facing the same problem, can use the way above to fix it temporarily.
Thanks.