Login  Register

Re: ofbiz hangs during startup

Posted by BJ Freeman on Aug 03, 2006; 1:08pm
URL: http://ofbiz.116.s1.nabble.com/ofbiz-hangs-during-startup-tp141106p141119.html

Just on vague chance, dose the data folder have permissions to write.

Mark Thomas sent the following on 8/3/2006 4:40 AM:

> Thanks for the ideas :
>
> I have let it run for at least 30 minutes and have also checked the cpu
> usage over that time.  The cpu usage dies down to 0% as if the process
> is doing nothing.  I've also checked several of the system logs in case
> there's any errors logged - but have found nothing.
>
>
>
> Midhat Ali wrote:
>
>> maybe you could allow it to run fo a longer period of time. or use a
>> database admin sotware to see if it is doing any activity on hte db or
>> ust
>> staying there
>>
>> On 8/3/06, Mark Thomas <[hidden email]> wrote:
>>
>>>
>>> Hi,
>>>
>>> I have tried installing ofBiz on freeBSD 4.11, but it hangs during
>>> startup.
>>>
>>> I first tried downloading the opentravel zip file and running that, then
>>> I tried loading ofBiz from svn - but in both cases, the console screen
>>> just stops at a particular point during startup.
>>>
>>> For instance, if I do this in my ofbiz home directory : ./ant
>>> run-install
>>>
>>> Everything seems to work nicely up to the bit where it gets information
>>> from the database : specifically the localderbyodbc database.
>>> The last few lines of the hang are :
>>>
>>>      [java] 2006-08-03 18:24:47,145 (main) [
>>> GenericDelegator.java:176:INFO ] Delegator "default" initializing helper
>>> "localderbyodbc" for entity group "org.ofbiz.odbc".
>>>      [java] 2006-08-03 18:24:47,147 (main) [
>>> GenericDelegator.java:193:INFO ] Doing database check as requested in
>>> entityengine.xml with addMissing=true
>>>      [java] 2006-08-03 18:24:50,609 (main) [
>>> DatabaseUtil.java:765:INFO ] Database Product Name is Apache Derby
>>>      [java] 2006-08-03 18:24:50,612 (main) [
>>> DatabaseUtil.java:766:INFO ] Database Product Version is 10.1.3.1
>>>      [java] 2006-08-03 18:24:50,613 (main) [
>>> DatabaseUtil.java:774:INFO ] Database Driver Name is Apache Derby
>>> Embedded JDBC Driver
>>>      [java] 2006-08-03 18:24:50,614 (main) [
>>> DatabaseUtil.java:775:INFO ] Database Driver Version is 10.1.3.1
>>>      [java] 2006-08-03 18:24:50,616 (main) [
>>> DatabaseUtil.java:776:INFO ] Database Driver JDBC Version is 3.0
>>>      [java] 2006-08-03 18:24:50,617 (main) [
>>> DatabaseUtil.java:786:INFO ] Database Setting/Support Information (those
>>> with a * should be true):
>>>      [java] 2006-08-03 18:24:50,618 (main) [
>>> DatabaseUtil.java:787:INFO ] - supports transactions    [true]*
>>>      [java] 2006-08-03 18:24:50,623 (main) [
>>> DatabaseUtil.java:788:INFO ] - isolation None           [false]
>>>      [java] 2006-08-03 18:24:50,625 (main) [
>>> DatabaseUtil.java:789:INFO ] - isolation ReadCommitted  [true]
>>>      [java] 2006-08-03 18:24:50,626 (main) [
>>> DatabaseUtil.java:790:INFO ] - isolation ReadUncommitted[true]
>>>      [java] 2006-08-03 18:24:50,630 (main) [
>>> DatabaseUtil.java:791:INFO ] - isolation RepeatableRead [true]
>>>      [java] 2006-08-03 18:24:50,632 (main) [
>>> DatabaseUtil.java:792:INFO ] - isolation Serializable   [true]
>>>      [java] 2006-08-03 18:24:50,647 (main) [
>>> DatabaseUtil.java:793:INFO ] - default fetchsize        [1]
>>>      [java] 2006-08-03 18:24:50,649 (main) [
>>> DatabaseUtil.java:794:INFO ] - forward only type        [true]
>>>      [java] 2006-08-03 18:24:50,650 (main) [
>>> DatabaseUtil.java:795:INFO ] - scroll sensitive type    [false]
>>>      [java] 2006-08-03 18:24:50,652 (main) [
>>> DatabaseUtil.java:796:INFO ] - scroll insensitive type  [true]
>>>      [java] 2006-08-03 18:24:50,653 (main) [
>>> DatabaseUtil.java:797:INFO ] - is case sensitive        [false]
>>>      [java] 2006-08-03 18:24:50,660 (main) [
>>> DatabaseUtil.java:798:INFO ] - stores LowerCase         [false]
>>>      [java] 2006-08-03 18:24:50,663 (main) [
>>> DatabaseUtil.java:799:INFO ] - stores MixedCase         [false]
>>>      [java] 2006-08-03 18:24:50,664 (main) [
>>> DatabaseUtil.java:800:INFO ] - stores UpperCase         [true]
>>>      [java] 2006-08-03 18:24:50,666 (main) [
>>> DatabaseUtil.java:801:INFO ] - max table name length    [128]
>>>      [java] 2006-08-03 18:24:50,667 (main) [
>>> DatabaseUtil.java:802:INFO ] - max column name length   [128]
>>>      [java] 2006-08-03 18:24:50,669 (main) [
>>> DatabaseUtil.java:803:INFO ] - max schema name length   [128]
>>>      [java] 2006-08-03 18:24:50,672 (main) [
>>> DatabaseUtil.java:804:INFO ] - concurrent connections   [0]
>>>      [java] 2006-08-03 18:24:50,673 (main) [
>>> DatabaseUtil.java:805:INFO ] - concurrent statements    [0]
>>>      [java] 2006-08-03 18:24:50,675 (main) [
>>> DatabaseUtil.java:806:INFO ] - ANSI SQL92 Entry         [false]
>>>      [java] 2006-08-03 18:24:50,676 (main) [
>>> DatabaseUtil.java:807:INFO ] - ANSI SQL92 Itermediate   [false]
>>>      [java] 2006-08-03 18:24:50,677 (main) [
>>> DatabaseUtil.java:808:INFO ] - ANSI SQL92 Full          [false]
>>>      [java] 2006-08-03 18:24:50,679 (main) [
>>> DatabaseUtil.java:809:INFO ] - ODBC SQL Grammar Core    [false]
>>>      [java] 2006-08-03 18:24:50,680 (main) [
>>> DatabaseUtil.java:810:INFO ] - ODBC SQL Grammar Extended[false]
>>>      [java] 2006-08-03 18:24:50,681 (main) [
>>> DatabaseUtil.java:811:INFO ] - ODBC SQL Grammar Minimum [true]
>>>      [java] 2006-08-03 18:24:50,683 (main) [
>>> DatabaseUtil.java:812:INFO ] - outer joins              [true]*
>>>      [java] 2006-08-03 18:24:50,684 (main) [
>>> DatabaseUtil.java:813:INFO ] - limited outer joins      [true]
>>>      [java] 2006-08-03 18:24:50,685 (main) [
>>> DatabaseUtil.java:814:INFO ] - full outer joins         [false]
>>>      [java] 2006-08-03 18:24:50,687 (main) [
>>> DatabaseUtil.java:815:INFO ] - group by                 [true]*
>>>      [java] 2006-08-03 18:24:50,688 (main) [
>>> DatabaseUtil.java:816:INFO ] - group by not in select   [true]
>>>      [java] 2006-08-03 18:24:50,689 (main) [
>>> DatabaseUtil.java:817:INFO ] - column aliasing          [true]
>>>      [java] 2006-08-03 18:24:50,691 (main) [
>>> DatabaseUtil.java:818:INFO ] - order by not in select   [false]
>>>      [java] 2006-08-03 18:24:50,692 (main) [
>>> DatabaseUtil.java:820:INFO ] - alter table add column   [true]*
>>>      [java] 2006-08-03 18:24:50,693 (main) [
>>> DatabaseUtil.java:821:INFO ] - non-nullable column      [true]*
>>>      [java] 2006-08-03 18:24:50,695 (main) [
>>> DatabaseUtil.java:858:INFO ] Getting Table Info From Database
>>>      [java] 2006-08-03 18:24:52,967 (main) [
>>> DatabaseUtil.java:993:INFO ] Getting Column Info From Database
>>>
>>> I'm not sure what's supposed to come next, but it is probably that next
>>> bit which is holding me up.
>>>
>>> I tried starting with the 'startup' script too and checked the log files
>>> - it stopped at the same point.
>>>
>>> I also tried using a postgresql database instead of the default derby
>>> database - once again, same problem - so I'm assuming the problem is
>>> with this 'odbc' database or whatever is supposed to start next.
>>>
>>> Any help greatly appreciated.
>>>
>>> Thanks,
>>> Mark
>>>
>>
>
>