Database Migration Failed

Started by Storm-Donovan, March 11, 2022, 08:43:36 PM

Previous topic - Next topic

Storm-Donovan

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!

Storm-Donovan

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.

Storm-Donovan

After 16 hours my migration is complete.