Bug #4831
Updated by Vincent MEMBRÉ over 10 years ago
All our ids in reports database are based on integer which limit 2147483647 Since it's a rather big change, we will not fix it in our stable version but in a latest one (2.10) What we will do: * Fix Scala code and database schema (#4831) ** So new installations will not have replacing by bigint should solve the problem anymore ** That will have no impact on existing installation issue * Add two scripts (#4832) ** One that We should be ran manually to migrate change the database ** One that will only warn the user that their table is tile using int declaration to use bigint and modify all code. * Add an entry in the FAQ that This will explain how need some migration script to detect it, analyse it, fix the issue. update db schema ALTER TABLE ruddersysevents ALTER COLUMN id TYPE bigint; ALTER TABLE archivedruddersysevents ALTER COLUMN id TYPE bigint; ALTER TABLE statusupdate ALTER COLUMN lastid TYPE bigint; Note: command used to get type of column: psql -U rudder -h localhost -p 15432 -Atc "select data_type from information_schema.columns where table_name='archivedruddersysevents' and column_name='id';"