Database migrations skipped

Warning future visitors. Dropping the migrations table may not be the correct move. Maybe only DELETE FROM migrations where batch=1;

Due to a bug some database migrations may have been skipped. The bug is fixed, but you may have issues with your install if it wasn’t up-to-date before the bug.

Run ./validate.php if you have a large amount of differences and your schema version is 1000, LibreNMS may have skipped some database structure changes.

Check logs/daily.log for ? -> 1000 ... done to figure out the previous version. If this is anything other than 281 -> 1000 you have skipped schema changes.

Run SQL (filling in the correct version from above):

UPDATE dbSchema SET version=? LIMIT 1;
DROP TABLE migrations;

Run daily:

./daily.sh
1 Like