Database Upgrade Fails
-
Hi,
when I tray to upgrade the database, I'll get the following error:
Upgrading database...
Upgrading from version 60.7 to 60.8
SQL query failed (BIGINT value is out of range in '`netxms`.`raw_dci_values`.`last_poll_time` * 1000'):
UPDATE raw_dci_values SET last_poll_time = last_poll_time * 1000, cache_timestamp = CASE WHEN cache_timestamp > 1 THEN cache_timestamp * 1000 ELSE cache_timestamp END
Rolling back last stage due to upgrade errors...
Database upgrade failedHow can I fix this ?
Thank you -
Which database you are using?
-
-
raw_dci_values table is just a cache of most recent DCI values. You can just truncate it and proceed with the upgrade:
TRUNCATE TABLE raw_dci_values;
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login