Ask Questions and Find Answers

hi
i use liferay 6.2 with service builder.my problem is, when i add new column in service builder, and restart server, it will take very long time to backup something.i can add column information direct to my database by myself, and very sure the name and type is right.is there any way to avoid the backup time?
thank you.

<code>
10:18:51,705 INFO  [localhost-startStop-1][PortletHotDeployListener:492] 1 portlet for AdminMasterData-portlet is available for use
10:18:51,706 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying SNM-Raritan-portlet from queue
10:18:51,706 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for SNM-Raritan-portlet
Loading file:/Liferay/6.2_GA6/liferay-portal-6.2-ce-ga6/tomcat-7.0.62/webapps/SNM-Raritan-portlet/WEB-INF/classes/portlet.properties
Loading file:/Liferay/6.2_GA6/liferay-portal-6.2-ce-ga6/tomcat-7.0.62/webapps/SNM-Raritan-portlet/WEB-INF/classes/service.properties
10:18:51,922 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:332] Upgrading SNM database to build number 268
10:18:51,923 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:339] Upgrading database with tables.sql
10:18:51,951 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_Mac_Address' already exists: create table SNM_Mac_Address (macAddress bigint not null primary key) engine InnoDB;_ [Sanitized]
10:18:51,953 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_ODM_Customer' already exists: create table SNM_ODM_Customer (customerId bigint not null primary key,name varchar(75) null,customerCodeOfJDE varchar(75) null,description varchar(255) null) engine InnoDB;_ [Sanitized]
10:18:51,955 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_ODM_Part_Rule' already exists: create table SNM_ODM_Part_Rule (partNumber varchar(75) not null primary key,ruleId bigint) engine InnoDB;_ [Sanitized]
10:18:51,957 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_ODM_Rule' already exists: create table SNM_ODM_Rule (ruleId bigint not null primary key,customerId bigint,ruleObject varchar(75) null,description varchar(255) null) engine InnoDB;_ [Sanitized]
10:18:51,958 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_Prefix_Record' already exists: create table SNM_Prefix_Record (partNumber varchar(75) not null primary key,modelName varchar(75) null,prefixOfSerialNumber varchar(75) null,ean13Code varchar(75) null,macQuantity integer,lengthOfSerialNumber integer,createdDate datetime null,creatorId bigint,statusId integer,description varchar(75) null,independentSerialNumberNecessary tinyint) engine InnoDB;_ [Sanitized]
10:18:51,959 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_Prefix_Record_Status' already exists: create table SNM_Prefix_Record_Status (statusId integer not null primary key,name varchar(75) null,description varchar(75) null) engine InnoDB;_ [Sanitized]
10:18:51,961 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_Product_Record' already exists: create table SNM_Product_Record (prefixOfSerialNumber varchar(75) not null,midfixOfSerialNumber varchar(75) not null,suffixOfSerialNumber bigint not null,lotNumber varchar(75) null,hardware1 varchar(75) null,hardware2 varchar(75) null,hardware3 varchar(75) null,hardware4 varchar(75) null,hardware5 varchar(75) null,hardware6 varchar(75) null,software1 varchar(75) null,software2 varchar(75) null,software3 varchar(75) null,software4 varchar(75) null,software5 varchar(75) null,software6 varchar(75) null,operatorId bigint,noteOfTag3 varchar(75) null,engineeringChangeNoticeNumber varchar(75) null,types varchar(75) null,grossWeight double,netWeight double,amountOfPerBox integer,ean13Code varchar(75) null,exportQuantity integer,description varchar(75) null,cartonLogoIndex varchar(75) null,primary key (prefixOfSerialNumber, midfixOfSerialNumber, suffixOfSerialNumber)) engine InnoDB;_ [Sanitized]
10:18:51,963 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_Serial_Number' already exists: create table SNM_Serial_Number (prefixOfSerialNumber varchar(75) not null,midfixOfSerialNumber varchar(75) not null,suffixOfSerialNumber bigint not null,partNumber varchar(75) null,fixedModelName varchar(75) null,fixedPartDescription varchar(75) null,orderType varchar(75) null,orderNumber bigint,organizationId bigint,recorderId bigint,recordedDate datetime null,operationType integer,inHouse tinyint,affiliationSupplierNumberOfJDE varchar(75) null,lastStatusId integer,parentPrefixOfSerialNumber varchar(75) null,parentMidfixOfSerialNumber varchar(75) null,parentSuffixOfSerialNumber bigint,wholeProductIdentifier varchar(75) null,primary key (prefixOfSerialNumber, midfixOfSerialNumber, suffixOfSerialNumber)) engine InnoDB;_ [Sanitized]
10:18:51,965 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_Serial_Number_Change_Order_Note' already exists: create table SNM_Serial_Number_Change_Order_Note (prefixOfSerialNumber varchar(75) not null,midfixOfSerialNumber varchar(75) not null,suffixOfSerialNumber bigint not null,parentOrderType varchar(75) not null,parentOrderNumber bigint not null,recorderId bigint,recordedDate datetime null,description varchar(255) null,primary key (prefixOfSerialNumber, midfixOfSerialNumber, suffixOfSerialNumber, parentOrderType, parentOrderNumber)) engine InnoDB;_ [Sanitized]
10:18:51,967 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_Serial_Number_Generating_Queue' already exists: create table SNM_Serial_Number_Generating_Queue (prefixOfSerialNumber varchar(75) not null,sequence bigint not null,orderType varchar(75) null,orderNumber bigint,secondItemNumber varchar(75) null,quantity integer,operationType integer,userId bigint,inHouse tinyint,affiliationSupplierNumberOfJDE varchar(75) null,createdDate datetime null,startDate datetime null,endDate datetime null,statusId integer,message varchar(75) null,lotNumber varchar(75) null,amountOfPerBox integer,grossWeight double,netWeight double,queueDate datetime null,wholeProductIdentifier varchar(75) null,rootPartNumberOfWholeProduct varchar(75) null,primary key (prefixOfSerialNumber, sequence)) engine InnoDB;_ [Sanitized]
10:18:51,969 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_Serial_Number_Generating_Queue_Status' already exists: create table SNM_Serial_Number_Generating_Queue_Status (statusId integer not null primary key,name varchar(75) null,description varchar(75) null) engine InnoDB;_ [Sanitized]
10:18:51,971 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_Serial_Number_JDE_Interlinked' already exists: create table SNM_Serial_Number_JDE_Interlinked (prefixOfSerialNumber varchar(75) not null,midfixOfSerialNumber varchar(75) not null,Interval_Max_0_39999 bigint,Interval_Max_40000_49999 bigint,Interval_Max_50000_53999 bigint,Interval_Max_54000_54999 bigint,Interval_Max_55000_57999 bigint,Interval_Max_58000_58999 bigint,Interval_Max_59000_59999 bigint,Interval_Max_60000_63999 bigint,Interval_Max_64000_64999 bigint,Interval_Max_65000_67999 bigint,Interval_Max_68000_68999 bigint,Interval_Max_69000_79999 bigint,Interval_Max_80000_89999 bigint,Interval_Max_90000_99999 bigint,primary key (prefixOfSerialNumber, midfixOfSerialNumber)) engine InnoDB;_ [Sanitized]
10:18:51,972 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_Serial_Number_JDE_Interlinked_Early' already exists: create table SNM_Serial_Number_JDE_Interlinked_Early (prefixOfSerialNumber varchar(75) not null,midfixOfSerialNumber varchar(75) not null,Interval_Max_0_3999 bigint,Interval_Max_4000_4999 bigint,Interval_Max_5000_5399 bigint,Interval_Max_5400_5499 bigint,Interval_Max_5500_5799 bigint,Interval_Max_5800_5899 bigint,Interval_Max_5900_5999 bigint,Interval_Max_6000_6399 bigint,Interval_Max_6400_6499 bigint,Interval_Max_6500_6799 bigint,Interval_Max_6800_6899 bigint,Interval_Max_6900_7999 bigint,Interval_Max_8000_8999 bigint,Interval_Max_9000_9999 bigint,primary key (prefixOfSerialNumber, midfixOfSerialNumber)) engine InnoDB;_ [Sanitized]
10:18:51,974 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_Serial_Number_Mac' already exists: create table SNM_Serial_Number_Mac (prefixOfSerialNumber varchar(75) not null,midfixOfSerialNumber varchar(75) not null,suffixOfSerialNumber bigint not null,macAddress bigint not null,orderType varchar(75) null,orderNumber bigint,primary key (prefixOfSerialNumber, midfixOfSerialNumber, suffixOfSerialNumber, macAddress)) engine InnoDB;_ [Sanitized]
10:18:51,976 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_Serial_Number_Regenerate_Order' already exists: create table SNM_Serial_Number_Regenerate_Order (regenerateOrderNumber bigint not null primary key,partNumber varchar(75) null,createdDate datetime null,creatorId bigint,note varchar(75) null) engine InnoDB;_ [Sanitized]
10:18:51,977 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_Serial_Number_Regenerate_Record' already exists: create table SNM_Serial_Number_Regenerate_Record (originalSerialNumber varchar(75) not null primary key,regenerateOrderNumber bigint,prefixOfSerialNumber varchar(75) null,midfixOfSerialNumber varchar(75) null,suffixOfSerialNumber bigint) engine InnoDB;_ [Sanitized]
10:18:51,979 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_Serial_Number_Status' already exists: create table SNM_Serial_Number_Status (statusId integer not null primary key,name varchar(75) null,description varchar(75) null) engine InnoDB;_ [Sanitized]
10:18:51,980 WARN  [localhost-startStop-1][BaseDB:457] Table 'SNM_Serial_Number_Status_Log' already exists: create table SNM_Serial_Number_Status_Log (sequence bigint not null primary key,prefixOfSerialNumber varchar(75) null,midfixOfSerialNumber varchar(75) null,suffixOfSerialNumber bigint,serialNumberDescription varchar(75) null,recorderId bigint,recordedTime datetime null,statusId integer,message varchar(75) null) engine InnoDB;_ [Sanitized]
10:18:51,982 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:387] No optional file META-INF/portlet-model-hints-ext.xml found
Loading file:/Liferay/6.2_GA6/liferay-portal-6.2-ce-ga6/tomcat-7.0.62/webapps/SNM-Raritan-portlet/WEB-INF/classes/service.properties
10:18:52,011 INFO  [localhost-startStop-1][Table:157] Starting backup of SNM_Serial_Number to /Liferay/6.2_GA6/liferay-portal-6.2-ce-ga6/tomcat-7.0.62/temp/temp-db-SNM_Serial_Number-1590718732011
10:20:14,296 INFO  [localhost-startStop-1][Table:191] Finished backup of SNM_Serial_Number to /Liferay/6.2_GA6/liferay-portal-6.2-ce-ga6/tomcat-7.0.62/temp/temp-db-SNM_Serial_Number-1590718732011 in 82285 ms
</code>