Queue of letters stuck in postal

[Dmit84]

When sending 15500 letters, the queue hung on 1197 letters. Tried to restart postal and mysql and rabbit did not help, HELP

[willpower232]

You will need to check your memory and disk usages.

[Dmit84]

root@postal:~# free
              total        used        free      shared  buff/cache   available
Mem:        4026068     1706636     1173888       32700     1145544     2015416
Swap:             0           0           0

root@postal:~# df -h
Filesystem      Size  Used Avail Use% Mounted on
udev            1.9G     0  1.9G   0% /dev
tmpfs           394M  1.7M  392M   1% /run
/dev/vda1        19G   15G  3.7G  80% /
tmpfs           2.0G     0  2.0G   0% /dev/shm
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs           2.0G     0  2.0G   0% /sys/fs/cgroup
/dev/loop1       56M   56M     0 100% /snap/core18/2632
/dev/loop0       56M   56M     0 100% /snap/core18/2620
/dev/loop2       64M   64M     0 100% /snap/core20/1738
/dev/loop4       92M   92M     0 100% /snap/lxd/24061
/dev/loop5       64M   64M     0 100% /snap/core20/1695
/dev/loop3       92M   92M     0 100% /snap/lxd/23991
/dev/loop6       50M   50M     0 100% /snap/snapd/17883
tmpfs           394M     0  394M   0% /run/user/0
overlay          19G   15G  3.7G  80% /var/lib/docker/overlay2/0c10396bbc1efab76ece9241622f44e21072a6d4dedaeb28e381e728aedb366a/merged
overlay          19G   15G  3.7G  80% /var/lib/docker/overlay2/9ab45f7000d7ae972bdbce0dbada4ad5e3cd1ddab5f8867deccde63149f42710/merged
overlay          19G   15G  3.7G  80% /var/lib/docker/overlay2/52b0ae6ae78e2f9f016ebcd036cb0eb8a5bd406d9a394224edc7c24ecf41bdaf/merged
overlay          19G   15G  3.7G  80% /var/lib/docker/overlay2/fa94c8da8bb58e33f60b0b5b720662b40b6ab3981114298d4bcc13d5783d16e0/merged
overlay          19G   15G  3.7G  80% /var/lib/docker/overlay2/38679ba29adde5448e0c36c5fce42938e0ef659f59ceab7cbd8b6354a52e2c88/merged
overlay          19G   15G  3.7G  80% /var/lib/docker/overlay2/f2743036ed359a745fca0935061c41c93e8e25f5bb02d1fdaac6c0727fbb75fe/merged
overlay          19G   15G  3.7G  80% /var/lib/docker/overlay2/36984064e19db763c9c17931255bf2aa1b7b66fef4a3fcfd9c1d00161fed32b7/merged
overlay          19G   15G  3.7G  80% /var/lib/docker/overlay2/36771d1a25b8c12ebc9ae7f37c519cfe275b381f59882d5dfdf142744c83aba3/merged
overlay          19G   15G  3.7G  80% /var/lib/docker/overlay2/7d08a25833ae8b8bbcf93c98dd93c2852fa46ff43820effb0320a29090bc04bf/merged

[willpower232]

Have you modified the mysql server configuration like this? #324 (comment)

Also if you've had to restart then it might be that the messages are trapped in the queued_messages table, I think you need to clear the locked columns to free them up.

[Dmit84]

got into mysql and there I don't see the queued_messages table. How to unlock columns??

[willpower232]

there should be a table called queued_messages in the main postal database, if you see rows in there from a long time ago, there will be a few columns with names starting with locked so you should set them to null for the rows from a long time ago so they get attempted by newer queue workers