Hi everyone,

I wanted to give everyone a heads-up that there will be a Liquibase
migration in OpenNMS 17 that will remove some columns and triggers from
the database in the ipInterface, ifServices, and outages tables.

These columns and triggers were in place to preserve backwards
compatibility with older JDBC code that used a node/ipAddr/service
composite key instead of the simpler numeric primary keys that we use
with Hibernate. However, since Capsd has been removed and a lot of
refactoring has been done to remove old JDBC code and replace it with
Hibernate, we can now get rid of these database columns without causing
problems. This will increase performance because of the reduced number
of database calls due to the removal of the triggers.

If you are working in the 'develop' branch and upgrade to
17.0.0-SNAPSHOT after the Liquibase migration is committed, the
migration will remove the database columns. If you want to go back to
developing on an older version or a branch that does not contain the
database changes, you will need to have A BACKUP OF YOUR DATABASE that
you can restore that has the columns and triggers (or you will need to
install from scratch). Otherwise, the older version of OpenNMS will
undoubtedly crash because of queries that are expecting those columns in
the database.

The changes are not yet committed to 'develop' for inclusion in 17 but I
expect them to pass unit tests today and be ready to merge by tomorrow.

Heads up!!
Seth Leger
The OpenNMS Group


------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this 
page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel

Reply via email to