2 DbIds

Vitalii Koshura edited this page 2023-04-10 01:29:01 +02:00

Table of Contents

• What to do when you run out of database IDs

What to do when you run out of database IDs

If your project processes 2^32^ jobs you'll run out of IDs in the result table. If this happens you can compress the ID space using the following queries:

alter table result add column tmpid int;

set @count = 0;
update result set tmpid = @count:= @count + 1;

update workunit inner join result on result.id = workunit.canonical_resultid set workunit.canonical_resultid = result.tmpid;

update result set id = tmpid;

alter table result auto_increment = 1;

Home

• Scientists
• Volunteers
• BOINC developers
• Add-on developers
• BOINC admin
• Community