Bug #4832
Updated by Vincent MEMBRÉ over 10 years ago
Since #4831, type of reports have as changed from integer to bigint. We will not have to migrate table automatically: it can take existing instalation using a very long time to perform and therefore could not fit in an automatic migration script. We will provide a script available in /opt/rudder/... that will make the migration whenever the user is ok to run it. In the migration process we will check if there is a still a table that needs migration and warn the user that there is something he can do! there is 3 tables to look at : ruddersysevents (id), archivedruddersysevents (id), and statusUpdated (lastId) The process to update reports table is more complicated: * In a transaction: ** Rename table to old_table ** drop all indexes ** create new "table" with bigint as id * Outside the transaction: * create new indexes on the new table * copy latest 1000 reports of each node in the table * Drop "old_table"