The indexer gets stuck with PostgreSQL

[qbzzt]

This is on MacOS with PostgreSQL 15.

1. Clear the database.

   cd ~/Library/Application\ Support/Postgres
   rm -rf var-15 

2. Start the database UI and click Initialize.

3. Create fresh installation.

   git clone https://github.com/latticexyz/mud.git && cd mud && pnpm install && pnpm build
   cd ..
   pnpm create mud@main app
   # I selected vanilla, but it shouldn't matter

4. Run the app.

   cd app; pnpm dev

5. Wait until the app is initialized.

6. In a separate command line, run the indexer.

   cd mud
   cd packages/store-indexer
   pnpm start:postgres:local

   Wait until it is all caught up.

7. Get the last block indexed from the indexer.

   curl 'http://localhost:3001/trpc/findAll?batch=1&input=%7B%220%22%3A%7B%22json%22%3A%7B%22chainId%22%3A31337%2C%22address%22%3A%220x5FbDB2315678afecb367f032d93F642f64180aa3%22%7D%7D%7D' | jq '.[0].result.data.json.blockNumber'

8. Wait a few minutes and run the same command again, see the results are unchanged.

   curl 'http://localhost:3001/trpc/findAll?batch=1&input=%7B%220%22%3A%7B%22json%22%3A%7B%22chainId%22%3A31337%2C%22address%22%3A%220x5FbDB2315678afecb367f032d93F642f64180aa3%22%7D%7D%7D' | jq '.[0].result.data.json.blockNumber'

To see in PostgreSQL:

1. Open the psql app
2. select * from __mud_internal.chain;
3. Wait a few minutes
4. select * from __mud_internal.chain;

Again, you'll see an unchanged value.

[holic]

Thanks for the good repro steps! Fix is up: #1514