NetXMS Support Forum

English Support => General Support => Topic started by: murtalit on April 11, 2026, 05:32:12 AM

Title: Database Upgrade Fails
Post by: murtalit on April 11, 2026, 05:32:12 AM
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 failed

How can I fix this ?
Thank you
Title: Re: Database Upgrade Fails
Post by: Filipp Sudanov on April 16, 2026, 03:11:44 PM
Which database you are using?
Title: Re: Database Upgrade Fails
Post by: murtalit on April 17, 2026, 12:22:23 PM
mariadb