From b4138831713078f09a0bc00e9aaead82b27c6142 Mon Sep 17 00:00:00 2001 From: Aron Roberts Date: Mon, 7 Mar 2011 23:07:44 +0000 Subject: [PATCH] CSPACE-3621: Increasing log level of post-init operations that add indices or modify field datatypes to 'info', as these operations may be expensive if performed on large datasets. --- .../collectionspace/services/common/init/AddIndices.java | 6 +++--- .../services/common/init/ModifyFieldDatatypes.java | 6 ++++-- 2 files changed, 7 insertions(+), 5 deletions(-) diff --git a/services/common/src/main/java/org/collectionspace/services/common/init/AddIndices.java b/services/common/src/main/java/org/collectionspace/services/common/init/AddIndices.java index 1b4a5438f..617f20fc7 100755 --- a/services/common/src/main/java/org/collectionspace/services/common/init/AddIndices.java +++ b/services/common/src/main/java/org/collectionspace/services/common/init/AddIndices.java @@ -122,11 +122,11 @@ public class AddIndices extends InitHandler implements IInitHandler { // mechanism for retrieving and populating catalog/DDL-type SQL statements // appropriate to a particular database product. if (databaseProductType == DatabaseProductType.MYSQL) { - logger.trace("Creating index for column " + columnName + " in table " + tableName); + logger.info("Creating index for column " + columnName + " in table " + tableName); sql = "CREATE INDEX " + indexName + " ON " + tableName + " (" + columnName + ")"; } else if (databaseProductType == DatabaseProductType.POSTGRESQL) { - logger.trace("Creating index for column " + columnName + " in table " + tableName); - sql = "CREATE INDEX ON " + tableName + " (" + columnName + ")"; + logger.info("Creating index for column " + columnName + " in table " + tableName); + sql = "CREATE INDEX ON " + tableName + " (" + columnName + ")"; } else { throw new Exception("Unrecognized database system " + databaseProductType); } diff --git a/services/common/src/main/java/org/collectionspace/services/common/init/ModifyFieldDatatypes.java b/services/common/src/main/java/org/collectionspace/services/common/init/ModifyFieldDatatypes.java index 7678df184..bde2aeaa4 100644 --- a/services/common/src/main/java/org/collectionspace/services/common/init/ModifyFieldDatatypes.java +++ b/services/common/src/main/java/org/collectionspace/services/common/init/ModifyFieldDatatypes.java @@ -72,11 +72,13 @@ public class ModifyFieldDatatypes extends InitHandler implements IInitHandler { // mechanism for retrieving and populating catalog/DDL-type SQL statements // appropriate to a particular database product. if (databaseProductType == DatabaseProductType.MYSQL) { - logger.trace("Modifying field " + field.getTable() + "." + logger.info("Modifying field " + field.getTable() + "." + field.getCol() + " to datatype " + datatype); sql = "ALTER TABLE " + field.getTable() + " MODIFY COLUMN " + field.getCol() + " " + datatype; } else if (databaseProductType == DatabaseProductType.POSTGRESQL) { - sql = "ALTER TABLE " + field.getTable() + " ALTER COLUMN " + field.getCol() + " " + datatype; + logger.info("Modifying field " + field.getTable() + "." + + field.getCol() + " to datatype " + datatype); + sql = "ALTER TABLE " + field.getTable() + " ALTER COLUMN " + field.getCol() + " " + datatype; } else { throw new Exception("Unrecognized database system."); } -- 2.47.3