Welcome to docs.opsview.com

Differences

This shows you the differences between two versions of the page.

opsview-core:upgrading:odwtableindexchange [2012/04/30 15:38] (current)
Line 1: Line 1:
 +===== ODW table index change =====
 +There was a bug in the Runtime to ODW import process which meant that the ODW table service_saved_state was not being cleared down correctly.
 +
 +If you upgrading through Opsview version 3.3.0, there will be a new index created. You may want to remove old records otherwise the upgrade may take a long time if you have a lot of data in ODW.
 +
 +<code>
 +mysql> DELETE FROM odw.service_saved_state WHERE start_timev <= UNIX_TIMESTAMP(NOW()) - 60*60*24*7;
 +</code>
Navigation
Print/export
Toolbox