envio local db-migrate fails - how to simply create tables and exit #797
Description
I’m using Envio as my indexer alongside an off-chain service. I’d like to access Envio’s tables within my own SQL migration files.
To do that, I need Envio’s migrations to run before my application’s migrations.
On the docs page I found I can run the db-migrate up command for that. I did run the command and the tables were created. However the logs show there is an issue which I can't understand.
cmd >> envio local db-migrate up
[09:26:20.410] INFO (281230): Initializing the indexer storage...
[09:26:20.726] INFO (281230): No cache found to upload.
[09:26:20.729] INFO (281230): The indexer storage is ready. Starting indexing!
Error: Failed cli execution
Caused by:
0: Failed to upsert persisted state table
1: pool timed out while waiting for an open connection
ELIFECYCLE Command failed with exit code 1.
I expected the command to simply set up the tables and exit.
Instead, it prints the line
“The indexer storage is ready. Starting indexing!”
waits for a few seconds, and then fails.