[BUG] No Exchange Rate Data Since 2023-08-29

[dan-tang-ssd]

Describe the bug There is no exchange rate data since 2023-08-29.

To Reproduce Yesterday's exchange rate data will be retrieved by daily schedule job automatically.

Expected behavior Yesterday's exchange rate data should be retrieved after 6:30 AM.

Screenshots

Additional context

Checked queue log message in Forge, it looks like the storage space is used up...

---

I did the following to free up storage space, but it seems not helpful...

Compress tempdump.sql into tempdump.sql.gz, filesize changed from 462 MB to 334 MB

---

Remove old telescope logs in database by below command: php artisan telescope:prune

BEFORE:

-- 166613 select count(*) from telescope_entries;

-- 159601 select count(*) from telescope_entries_tags;

-- 0 select count(*) from telescope_monitoring;

==========

AFTER:

-- 34 select count(*) from telescope_entries;

-- 0 select count(*) from telescope_entries_tags;

-- 0 select count(*) from telescope_monitoring;

==========

Execute below SQL to optimize telescope 3 tables:

optimize table telescope_entries;

optimize table telescope_entries_tags;

optimize table telescope_monitoring;

==========

Latest storage space:

forge@tpp-projects:~/agroecology-coalition.stats4sdtest.online$ df
Filesystem     1K-blocks     Used Available Use% Mounted on
udev             1966868        0   1966868   0% /dev
tmpfs             402608      748    401860   1% /run
/dev/sda        51027480 44605820   3810116  93% /
tmpfs            2013036        0   2013036   0% /dev/shm
tmpfs               5120        0      5120   0% /run/lock
tmpfs            2013036        0   2013036   0% /sys/fs/cgroup
tmpfs             402604        0    402604   0% /run/user/1000
forge@tpp-projects:~/agroecology-coalition.stats4sdtest.online$

---

I cleared the queue, run command to get one day exchange rate again. It is now working properly to retrieve exchange rate.

I would consider this issue is resolved.