Bug #4849
Updated by Vincent MEMBRÉ over 10 years ago
We need Altering directly reports table to add an entry in our FAQ on http://rudder-project.org to explain have bigint ids takes too long and lock the problem, how database during this time. Reports cannot be inserted by rsyslog, which make its load grow very fast, making it not working, and maybe break other systems We decided With mister ncharles, to detect it, how t analyse it, and replace it with the available solutions. following behavior: * It should include In a request transaction: ** Rename table to see if the problem islikely to occur (select max(id) from ruddersysevents) old_table ** drop all indexes ** create new "table" with bigint ** Create new indexes * Some explanation (we use integeer id which is limiter to 2 billion ...) End of transaction * Copy all lines of "old_table" int "table" * Drop "old_table" * Some different workaround ( upgrade to 2.10.2, This will be faster and run will not lock the script ...) database