Ranger upgrade times out while updating the DB schema from 0.4 to 0.5 (bunch of new tables, alter tables to add new columns, etc).
This can happen, for example, while adding 3 columns to the audit table - as adding a column to an exiting table could be an expensive/time consuming task in MySQL (it involves: 1 - create temp table with new columns 2 - copy old table contents to new table 3 - drop the old table 4 - rename the new table to old table name). And patch script audit/015-auditlogaggregation.sql executes 3 ALTER TABLE statements, to add 3 columns to xa_access_audit table.
This issue is likely to be hit in deployments that have large number of records in audit table. To be able to address this scenario, we should:
- Optimize Audit db upgrade patches to minimize timeout issues
- links to