Is it possible to use
cdb_replay_subscriptions() to reply subscription events from an arbitrary old transaction id.
The UG says
The caller specifies the transaction id of the last transaction that the application has completely seen and acted on. This verifies that the application has only missed (part of) the last transaction. If a different (older) transaction ID is specified, an error is returned and no subscriptions will be triggered. If the transaction id is the latest transaction ID (i.e. the caller is already up to date) nothing is triggered and CONFD_OK is returned.
What is the scope of this older transaction id? If we want to trigger subscription from an old transaction id (say 5-10 transactions behind current tid), do we need to reconnect with confd? Currently if we attempt this (w/o reconnecting) confd throws error like
DEBUG internal error - Failed to restore replay information .