2.0.8 to 2.1 on Ubuntu 14.04
-
Upgrading to 2.1 today. Post-install scripts in package trigger a database upgrade, and all updates succeed up to:
Setting up netxms-server:amd64 (2.1.0-1) ... NetXMS Database Manager Version 2.1 Build 9012 (2.1-RELEASE) (UNICODE) Upgrading database... Upgrading from version 404 to 405 Upgrading from version 405 to 406 Upgrading from version 406 to 407 Upgrading from version 407 to 408 Upgrading from version 408 to 409 Upgrading from version 409 to 410 Upgrading from version 410 to 411 Converting table tdata_100: done Converting table tdata_938: done Converting table tdata_945: done Converting table tdata_1053: done Converting table tdata_1054: done Converting table tdata_1249: done Converting table tdata_1451: done Converting table tdata_1458: done Converting table tdata_1465: done Converting table tdata_1468: done Converting table tdata_1470: done Converting table tdata_1474: done Converting table tdata_1487: done Converting table tdata_1496: done Converting table tdata_1501: done Converting table tdata_1553: done Converting table tdata_1586: done Converting table tdata_1588: done Converting table tdata_1595: done Converting table tdata_1597: done Converting table tdata_1599: done Converting table tdata_1623: done Converting table tdata_1628: done Converting table tdata_1639: done Converting table tdata_1652: done Converting table tdata_1660: done Converting table tdata_1668: done Converting table tdata_1670: done Converting table tdata_1702: done Converting table tdata_1704: done Converting table tdata_1706: done Converting table tdata_1708: done Converting table tdata_1710: done Converting table tdata_1712: done Converting table tdata_1714: done Converting table tdata_1716: done Converting table tdata_1718: done Converting table tdata_1720: done Converting table tdata_1722: done Converting table tdata_1724: done Converting table tdata_1726: done Converting table tdata_1728: done Converting table tdata_1730: done Converting table tdata_1732: done Converting table tdata_1773: done Converting table tdata_1816: done Converting table tdata_1823: done Converting table tdata_1970: done Converting table tdata_5662: done Converting table tdata_5706: done Converting table tdata_5746: done Converting table tdata_5748: done Converting table tdata_5750: done Converting table tdata_5752: done Converting table tdata_5755: done Converting table tdata_5757: done Converting table tdata_5770: done Converting table tdata_5776: done Converting table tdata_5796: done Converting table tdata_5801: done Converting table tdata_5803: done Converting table tdata_5805: done Converting table tdata_5807: done Converting table tdata_5811: done Converting table tdata_5845: done Converting table tdata_5879: done Converting table tdata_5880: done Converting table tdata_5915: done Converting table tdata_5927: done Converting table tdata_5653: done Converting table tdata_5655: done Converting table tdata_5656: done Converting table tdata_5657: done Converting table tdata_5658: done Converting table tdata_5660: done Converting table tdata_5779: done Upgrading from version 411 to 412 Upgrading from version 412 to 413 Upgrading from version 413 to 414 Upgrading from version 414 to 415 Upgrading from version 415 to 416 Upgrading from version 416 to 417 Upgrading from version 417 to 418 Upgrading from version 418 to 419 Upgrading from version 419 to 420 Upgrading from version 420 to 421 Upgrading from version 421 to 422 Upgrading from version 422 to 423 Upgrading from version 423 to 424 Upgrading from version 424 to 425 Upgrading from version 425 to 426 Upgrading from version 426 to 427 Upgrading from version 427 to 428 Upgrading from version 428 to 429 Upgrading from version 429 to 430 Upgrading from version 430 to 431 Upgrading from version 431 to 432Been sat at 431 to 432 for 30 minutes. Server load average is 1.2 so not heavily loaded. Mysql is working fine.
-
Of course, starting moving as soon as I posted this. So we're here now:
SQL query failed (Duplicate key name 'idx_syslog_source'): CREATE INDEX idx_syslog_source ON syslog(source_object_id) Rolling back last stage due to upgrade errors... Database upgrade failedRunning with trace:
# nxdbmgr upgrade -t NetXMS Database Manager Version 2.1 Build 9012 (2.1-RELEASE) (UNICODE) Upgrading database... Upgrading from version 431 to 432 >>> CREATE INDEX idx_syslog_source ON syslog(source_object_id) SQL query failed (Duplicate key name 'idx_syslog_source'): CREATE INDEX idx_syslog_source ON syslog(source_object_id) Rolling back last stage due to upgrade errors... Database upgrade failedInspecting with phpmyadmin, I can see this index already exists on this column.
-
I guess this thread is pretty much an "FYI" now, because I've sorted it. I renamed the index to .old and the upgrade has succeeded. I don't really know enough about databases to know what terrible consequences this will have, but I guess I'll find out.
The reason it spent so long on that upgrade step is that the syslog table is 7GB.
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