I'm trying to migrate our database from MariaDB to TimeScaleDB. I ran nxdbmgr migrate and it was humming along nicely and then failed with the following error:
Migrating table zmq_subscription
ERROR: unable to read data from source table (Table 'netxms.zmq_subscription' doesn't exist)
Database migration failed.
What should I do to resolve this? I'm really not sure why this table doesnt exist.
Thanks!
I did some more digging and realized I can tell nxdbmgr to skip that table, migration is going now and well past the last failure point.
After 16 hours my migration is complete.