turns out there were few issues with dbscripts, commits [1] fixed that.
[1] 30d68953b89b5b0a78564075acb9f69f25c4ffc1, 4fe8562e24008c415dda2e046596257586127cf2
On 12/12/2012 01:02 PM, Laszlo Hornyak wrote:
Looks like your DB is destroyed, or JBoss is connecting to the wrong
DB.
----- Original Message -----
> From: "Michael Pasternak" <mpastern(a)redhat.com>
> To: "engine-devel" <engine-devel(a)ovirt.org>
> Sent: Wednesday, December 12, 2012 11:56:35 AM
> Subject: [Engine-devel] Failed to start
service jboss.deployment.subunit."engine.ear"
>
>
> any clue what it might be? (latest sources + db)
>
> 2012-12-12 12:51:27,658 INFO [org.ovirt.engine.core.bll.Backend]
> (MSC service thread 1-7) Start time: 12/12/12 12:51 PM
> 2012-12-12 12:51:27,685 ERROR [org.jboss.msc.service.fail] (MSC
> service thread 1-7) MSC00001: Failed to start service
>
jboss.deployment.subunit."engine.ear"."engine-bll.jar".component.Backend.START:
> org.jboss.msc.service.StartException in service
>
jboss.deployment.subunit."engine.ear"."engine-bll.jar".component.Backend.START:
> Failed to start service
> at
>
org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1767)
> [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
> at
>
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> [rt.jar:1.6.0_20]
> at
>
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> [rt.jar:1.6.0_20]
> at java.lang.Thread.run(Thread.java:636) [rt.jar:1.6.0_20]
> Caused by: java.lang.IllegalStateException: JBAS011048: Failed to
> construct component instance
> at
>
org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:163)
> at
>
org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:85)
> at
>
org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:116)
> at
>
org.jboss.as.ejb3.component.singleton.SingletonComponent.start(SingletonComponent.java:130)
> at
>
org.jboss.as.ee.component.ComponentStartService.start(ComponentStartService.java:44)
> at
>
org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811)
> [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
> at
>
org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)
> [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
> ... 3 more
> Caused by: javax.ejb.EJBException:
> org.springframework.jdbc.BadSqlGrammarException:
> PreparedStatementCallback; bad SQL grammar [select * from
> get_all_commands()]; nested
> exception is org.postgresql.util.PSQLException: ERROR: function
> get_all_commands() does not exist
> Hint: No function matches the given name and argument types. You
> might need to add explicit type casts.
> Position: 16
>
>
> ...
>
>
> --
>
> Michael Pasternak
> RedHat, ENG-Virtualization R&D
> _______________________________________________
> Engine-devel mailing list
> Engine-devel(a)ovirt.org
>
http://lists.ovirt.org/mailman/listinfo/engine-devel
>
--
Michael Pasternak
RedHat, ENG-Virtualization R&D