Cannot find relation tx_calls

[samuel-rufi]

Bug description

The docker postgres logs mention following issue with the Indexer tx_calls relation. It seems like that it's unable to find the relation. There however exist more detailed tx_calls_{fun,mod,pkg} indicating that the query needs to be updated:

postgres  | 2024-11-11 11:01:11.985 UTC [450] ERROR:  relation "tx_calls" does not exist at character 288
postgres  | 2024-11-11 11:01:11.985 UTC [450] STATEMENT:  INSERT INTO move_calls
postgres  | 	    SELECT
postgres  | 	        m.tx_sequence_number AS transaction_sequence_number,
postgres  | 	        c.sequence_number AS checkpoint_sequence_number,
postgres  | 	        c.epoch AS epoch,
postgres  | 	        m.package AS move_package,
postgres  | 	        m.module AS move_module,
postgres  | 	        m.func AS move_function
postgres  | 	    FROM tx_calls m
postgres  | 	    INNER JOIN transactions t
postgres  | 	        ON m.tx_sequence_number = t.tx_sequence_number
postgres  | 	    INNER JOIN checkpoints c
postgres  | 	        ON t.checkpoint_sequence_number = c.sequence_number
postgres  | 	    WHERE m.tx_sequence_number >= 72000 AND m.tx_sequence_number < 80000
postgres  | 	    ON CONFLICT (transaction_sequence_number, move_package, move_module, move_function) DO NOTHING;
postgres  |
postgres  | 2024-11-11 11:01:12.461 UTC [450] ERROR:  relation "tx_calls" does not exist at character 288
postgres  | 2024-11-11 11:01:12.461 UTC [450] STATEMENT:  INSERT INTO move_calls
postgres  | 	    SELECT
postgres  | 	        m.tx_sequence_number AS transaction_sequence_number,
postgres  | 	        c.sequence_number AS checkpoint_sequence_number,
postgres  | 	        c.epoch AS epoch,
postgres  | 	        m.package AS move_package,
postgres  | 	        m.module AS move_module,
postgres  | 	        m.func AS move_function
postgres  | 	    FROM tx_calls m
postgres  | 	    INNER JOIN transactions t
postgres  | 	        ON m.tx_sequence_number = t.tx_sequence_number
postgres  | 	    INNER JOIN checkpoints c
postgres  | 	        ON t.checkpoint_sequence_number = c.sequence_number
postgres  | 	    WHERE m.tx_sequence_number >= 8000 AND m.tx_sequence_number < 16000
postgres  | 	    ON CONFLICT (transaction_sequence_number, move_package, move_module, move_function) DO NOTHING;