[Engine-devel] [SOLVED] Re: Failed to start service jboss.deployment.subunit."engine.ear"

[Michael Pasternak]

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 at redhat.com>
>> To: "engine-devel" <engine-devel at 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 at ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/engine-devel
>>


-- 

Michael Pasternak
RedHat, ENG-Virtualization R&D