Database not been created correctly with jboss and postgresql

181 views

Skip to first unread message

Carlos Carneiro

unread,

Oct 20, 2013, 12:08:22 PM10/20/13

to dot...@googlegroups.com

Hello all.

I am trying to deploy a exploded .war into jboss with postgres database but when I start the server, I get a lot of errors saying that some relations does not exists;

When I connect to the database, I can see that it did not create the tables, some logs:

13:01:09,338 FATAL [com.dotmarketing.startup.runalways.Task00001LoadSchema] (ServerService Thread Pool -- 69) Error: ERROR: current transaction is aborted, commands ignored until end of transaction blockwhile trying to execute create table ABContact (

contactId varchar(100) not null primary key,

userId varchar(100) not null,

firstName varchar(100) null,

middleName varchar(100) null,

lastName varchar(100) null,

nickName varchar(100) null,

emailAddress varchar(100) null,

homeStreet varchar(100) null,

homeCity varchar(100) null,

homeState varchar(100) null,

homeZip varchar(100) null,

homeCountry varchar(100) null,

homePhone varchar(100) null,

homeFax varchar(100) null,

homeCell varchar(100) null,

homePager varchar(100) null,

homeTollFree varchar(100) null,

homeEmailAddress varchar(100) null,

businessCompany varchar(100) null,

businessStreet varchar(100) null,

businessCity varchar(100) null,

businessState varchar(100) null,

businessZip varchar(100) null,

businessCountry varchar(100) null,

businessPhone varchar(100) null,

businessFax varchar(100) null,

businessCell varchar(100) null,

businessPager varchar(100) null,

businessTollFree varchar(100) null,

businessEmailAddress varchar(100) null,

employeeNumber varchar(100) null,

jobTitle varchar(100) null,

jobClass varchar(100) null,

hoursOfOperation text null,

birthday timestamp null,

timeZoneId varchar(100) null,

instantMessenger varchar(100) null,

website varchar(100) null,

comments text null

) proccessed 1 statements: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)

at org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:157)

at com.dotmarketing.common.db.DotConnect.executeStatement(DotConnect.java:222) [dotcms_2.5.jar:]

at com.dotmarketing.startup.runalways.Task00001LoadSchema.executeUpgrade(Task00001LoadSchema.java:80) [dotcms_2.5.jar:]

at com.dotmarketing.startup.StartupTasksExecutor.executeUpgrades(StartupTasksExecutor.java:201) [dotcms_2.5.jar:]

at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:117) [dotcms_2.5.jar:]

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1194) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1100) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3591) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]

at org.apache.catalina.core.StandardContext.start(StandardContext.java:3798) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]

at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:156) [jboss-as-web-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]

at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:60) [jboss-as-web-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]

at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:93) [jboss-as-web-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.7.0_25]

at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]

at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]

at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]

at org.jboss.threads.JBossThread.run(JBossThread.java:122)

13:01:09,349 FATAL [com.dotmarketing.startup.runalways.Task00001LoadSchema] (ServerService Thread Pool -- 69) Error: ERROR: current transaction is aborted, commands ignored until end of transaction block proccessed 1 statements: com.dotmarketing.exception.DotDataException: ERROR: current transaction is aborted, commands ignored until end of transaction block

at com.dotmarketing.startup.runalways.Task00001LoadSchema.executeUpgrade(Task00001LoadSchema.java:84) [dotcms_2.5.jar:]