From adac6daa5e71b96a54c1e37df74119bdf9c9cbe9 Mon Sep 17 00:00:00 2001 From: simonbrandhof Date: Wed, 17 Nov 2010 21:00:41 +0000 Subject: [PATCH] SONAR-1990 ORA-01795: maximum number of expressions in a list is 1000 --- .../WEB-INF/db/migrate/152_delete_duplicated_lib_snapshots.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sonar-server/src/main/webapp/WEB-INF/db/migrate/152_delete_duplicated_lib_snapshots.rb b/sonar-server/src/main/webapp/WEB-INF/db/migrate/152_delete_duplicated_lib_snapshots.rb index c6c747532cd..d7b317bd3e1 100644 --- a/sonar-server/src/main/webapp/WEB-INF/db/migrate/152_delete_duplicated_lib_snapshots.rb +++ b/sonar-server/src/main/webapp/WEB-INF/db/migrate/152_delete_duplicated_lib_snapshots.rb @@ -48,7 +48,7 @@ class DeleteDuplicatedLibSnapshots < ActiveRecord::Migration if snapshots.size > 0 say_with_time "Deleting #{snapshots.size} orphan snapshots..." do sids=snapshots.map{|s| s.id} - page_size=950 + page_size=100 page_count=(sids.size/page_size) page_count+=1 if (sids.size % page_size)>0 page_count.times do |page_index| -- 2.39.5