No such archive file error

[tsunejui]

hi toncenter,

I encountered the following issue while using ton-index-worker for TON node with testnet, and it seems that a archive file cannot be found:

I replaced the IP address of the database with <my-ip>

sudo ./ton-index-postgres --db /var/ton-work/db --host <my-ip> --port 5432 --user postgres --password <my-password> --dbname ton_index --from 26578204
...
[ 2][t 4][2024-12-31 10:26:06.635645908][IndexScheduler.cpp:115][!indexscheduler]	Rescheduling seqno 26578300
[ 2][t 4][2024-12-31 10:26:06.635654866][IndexScheduler.cpp:115][!indexscheduler]	Rescheduling seqno 26578301
[ 1][t 7][2024-12-31 10:26:06.635658222][archive-slice.cpp:820][!slice]	failed to open/create archive '/var/ton-work/db/archive/packages/arch0265/archive.26584469.pack': [PosixError : No such file or directory : 2 : File "/var/ton-work/db/archive/packages/arch0265/archive.26584469.pack" can't be opened for reading]
[ 2][t 4][2024-12-31 10:26:06.635663061][IndexScheduler.cpp:115][!indexscheduler]	Rescheduling seqno 26578299
[ 1][t 7][2024-12-31 10:26:06.635670555][archive-slice.cpp:820][!slice]	failed to open/create archive '/var/ton-work/db/archive/packages/arch0265/archive.26584569.pack': [PosixError : No such file or directory : 2 : File "/var/ton-work/db/archive/packages/arch0265/archive.26584569.pack" can't be opened for reading]
[ 2][t 4][2024-12-31 10:26:06.635672519][IndexScheduler.cpp:115][!indexscheduler]	Rescheduling seqno 26578298
[ 1][t 7][2024-12-31 10:26:06.635687918][archive-slice.cpp:820][!slice]	failed to open/create archive '/var/ton-work/db/archive/packages/arch0265/archive.26584669.pack': [PosixError : No such file or directory : 2 : File "/var/ton-work/db/archive/packages/arch0265/archive.26584669.pack" can't be opened for reading]
[ 1][t 7][2024-12-31 10:26:06.635703077][archive-slice.cpp:820][!slice]	failed to open/create archive '/var/ton-work/db/archive/packages/arch0265/archive.26584769.pack': [PosixError : No such file or directory : 2 : File "/var/ton-work/db/archive/packages/arch0265/archive.26584769.pack" can't be opened for reading]
...
[ 1][t 6][2024-12-31 10:27:50.074385247][archive-slice.cpp:820][!slice]	failed to open/create archive '/var/ton-work/db/archive/packages/arch0265/archive.26584669.pack': [PosixError : No such file or directory : 2 : File "/var/ton-work/db/archive/packages/arch0265/archive.26584669.pack" can't be opened for reading]
[ 1][t 6][2024-12-31 10:27:50.074397400][archive-slice.cpp:820][!slice]	failed to open/create archive '/var/ton-work/db/archive/packages/arch0265/archive.26584769.pack': [PosixError : No such file or directory : 2 : File "/var/ton-work/db/archive/packages/arch0265/archive.26584769.pack" can't be opened for reading]
[ 1][t 6][2024-12-31 10:27:50.074417417][archive-slice.cpp:820][!slice]	failed to open/create archive '/var/ton-work/db/archive/packages/arch0265/archive.26584869.pack': [PosixError : No such file or directory : 2 : File "/var/ton-work/db/archive/packages/arch0265/archive.26584869.pack" can't be opened for reading]
[ 1][t 6][2024-12-31 10:27:50.074428298][archive-slice.cpp:820][!slice]	failed to open/create archive '/var/ton-work/db/archive/packages/arch0265/archive.26584969.pack': [PosixError : No such file or directory : 2 : File "/var/ton-work/db/archive/packages/arch0265/archive.26584969.pack" can't be opened for reading]
[ 1][t 6][2024-12-31 10:27:50.074449107][archive-slice.cpp:820][!slice]	failed to open/create archive '/var/ton-work/db/archive/packages/arch0265/archive.26585069.pack': [PosixError : No such file or directory : 2 : File "/var/ton-work/db/archive/packages/arch0265/archive.26585069.pack" can't be opened for reading]
[ 1][t 6][2024-12-31 10:27:50.074460649][archive-slice.cpp:820][!slice]	failed to open/create archive '/var/ton-work/db/archive/packages/arch0265/archive.26585169.pack': [PosixError : No such file or directory : 2 : File "/var/ton-work/db/archive/packages/arch0265/archive.26585169.pack" can't be opened for reading]
[ 1][t 6][2024-12-31 10:27:50.074477682][archive-slice.cpp:820][!slice]	failed to open/create archive '/var/ton-work/db/archive/packages/arch0265/archive.26585269.pack': [PosixError : No such file or directory : 2 : File "/var/ton-work/db/archive/packages/arch0265/archive.26585269.pack" can't be opened for reading]
...

here is my environment:

NAME="Ubuntu"
VERSION="20.04.6 LTS (Focal Fossa)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 20.04.6 LTS"
VERSION_ID="20.04"
HOME_URL="https://www.ubuntu.com/"
SUPPORT_URL="https://help.ubuntu.com/"
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
VERSION_CODENAME=focal
UBUNTU_CODENAME=focal

The steps I use to set up the TON indexer:

1. clone the new codes of ton-index-worker with tag 22a3755f158c792c35601e33b32e8c20ca7ba160

This is the latest version currently on the master branch.

2. compile it using the following command:

mkdir -p build
cd build
cmake -DCMAKE_BUILD_TYPE=Release -DBUILD_SHARED_LIBS=off -GNinja ..
ninja -j$(nproc) ton-index-postgres
sudo cmake --install ton-index-postgres

3. go to the directory bin, and execute the program

sudo ./ton-index-postgres --db /var/ton-work/db --host <my-ip> --port 5432 --user postgres --password <my-password> --dbname ton_index --from 26578204

there is no data being written to PostgreSQL, how can I resolve this issue?