How to re-subscription automatically in kdb-tick?

[k-mambo]

I understand that kdb-tick should be run in order from ticker.

However, if ticker is terminated for some reason, rdb does not subscribe to the re-run ticker. 

Need a way to re-subscribe or a reference for implementation.

[James-Massey · Accepted solution]

Hi, TorQ provides re-subscribe logic in subscriptions.q provided below. 

.sub.subscribe calls a function .sub.autoreconnect which tries to reconnect to any previously subscribed tables/instruments. Initially two variables are checked .sub.AUTORECONNECT which is set to 1b in the script and if .sub.reconnectinit.  

TorQ/subscriptions.q at master · AquaQAnalytics/TorQ (github.com)

[gyorokpeter-kx]

It can be done using the built-in handlers .z.pc  (connection close) and .z.ts (timer). When the connection closes, you could set up a periodic timer that tries to reopen the connection.

Because doing this at the low level is cumbersome and is kind of reinventing the wheel, there are open source implementations that allow setting timers and auto-reconnecting connections, such as this one:

kdb/q/conn at main · finos/kdb (github.com)

This allows you to set up a connection that is automatically reopened using a timer. You could put the subscription code in the connect callback.