Skip to content

Index-worker does not fill the postgresql database with data #90

@artemrootman

Description

@artemrootman

There is a working archive node TON (lite-server). I deployed ton-indexer via docker compose following the instructions in the Readme.
Everything looks as it should at first look.
The problem is that the data from the worker does not get into the indexer database.
The postgres database is created automatically, it shows tables but they are empty. There are no error messages.

NAME                          IMAGE                       COMMAND                  SERVICE            CREATED        STATUS                  PORTS
ton-test-event-cache-1        redis:latest                "docker-entrypoint.s…"   event-cache        25 hours ago   Up 25 hours             6379/tcp
ton-test-event-classifier-1   ton-test-event-classifier   "/app/entrypoint.sh …"   event-classifier   25 hours ago   Up 25 hours             
ton-test-index-api-1          ton-test-index-api          "/app/entrypoint.sh …"   index-api          25 hours ago   Up 25 hours             0.0.0.0:8081->8081/tcp
ton-test-index-worker-1       ton-test-index-worker       "/entrypoint.sh --fr…"   index-worker       25 hours ago   Up 25 hours             
ton-test-postgres-1           postgres:16                 "docker-entrypoint.s…"   postgres           25 hours ago   Up 25 hours (healthy)   5432/tcp

.env:

# TON Indexer config
POSTGRES_HOST=postgres
POSTGRES_PORT=5432
POSTGRES_USER=postgres
POSTGRES_PASSWORD_FILE=private/postgres_password
POSTGRES_DBNAME=ton_index
POSTGRES_PUBLISH_PORT=5432

TON_INDEXER_API_ROOT_PATH=
TON_INDEXER_API_PORT=8081
TON_INDEXER_API_TITLE=TON Indexer
TON_INDEXER_WORKERS=4

TON_INDEXER_TON_HTTP_API_ENDPOINT=http://XXX.XXX.XXX.XXX:8000

TON_WORKER_DBROOT=`

worker's log:

index-worker-1      | [ 3][t 1][2024-10-30 14:53:41.229627788][IndexScheduler.cpp:235][!indexscheduler] 0 / 41542464    0.000000/s (-8s)        Q[0M, 0b, 0t, 0m, 0T]
index-worker-1      | [ 3][t 7][2024-10-30 14:53:48.200522228][TraceAssembler.cpp:109][!trace_assembler]         Pending traces: 0 Pending edges: 0 Broken traces: 0
index-worker-1      | [ 3][t 7][2024-10-30 14:53:51.239941176][IndexScheduler.cpp:235][!indexscheduler] 0 / 41542467    0.000000/s (-8s)        Q[0M, 0b, 0t, 0m, 0T]
index-worker-1      | [ 3][t 7][2024-10-30 14:53:58.201758514][TraceAssembler.cpp:109][!trace_assembler]         Pending traces: 0 Pending edges: 0 Broken traces: 0
index-worker-1      | [ 3][t 5][2024-10-30 14:54:01.249626628][IndexScheduler.cpp:235][!indexscheduler] 0 / 41542471    0.000000/s (-8s)        Q[0M, 0b, 0t, 0m, 0T]
index-worker-1      | [ 3][t 1][2024-10-30 14:54:08.203359336][TraceAssembler.cpp:109][!trace_assembler]         Pending traces: 0 Pending edges: 0 Broken traces: 0
index-worker-1      | [ 3][t 1][2024-10-30 14:54:11.259789345][IndexScheduler.cpp:235][!indexscheduler] 0 / 41542474    0.000000/s (-8s)        Q[0M, 0b, 0t, 0m, 0T]
index-worker-1      | [ 3][t 7][2024-10-30 14:54:18.204516997][TraceAssembler.cpp:109][!trace_assembler]         Pending traces: 0 Pending edges: 0 Broken traces: 0
index-worker-1      | [ 3][t 4][2024-10-30 14:54:21.269606936][IndexScheduler.cpp:235][!indexscheduler] 0 / 41542478    0.000000/s (-8s)        Q[0M, 0b, 0t, 0m, 0T]
index-worker-1      | [ 3][t 2][2024-10-30 14:54:28.205766883][TraceAssembler.cpp:109][!trace_assembler]         Pending traces: 0 Pending edges: 0 Broken traces: 0
index-worker-1      | [ 3][t 7][2024-10-30 14:54:31.279170783][IndexScheduler.cpp:235][!indexscheduler] 0 / 41542482    0.000000/s (-8s)        Q[0M, 0b, 0t, 0m, 0T]
index-worker-1      | [ 3][t 5][2024-10-30 14:54:38.207529684][TraceAssembler.cpp:109][!trace_assembler]         Pending traces: 0 Pending edges: 0 Broken traces: 0

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions