Mailing-List: contact ofbiz-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ofbiz-user@incubator.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Message-ID: <44D1E0BB.6020307@americancomputertechnics.com>
Date: Thu, 03 Aug 2006 21:40:43 +1000
From: Mark Thomas <markt@americancomputertechnics.com>
User-Agent: Mozilla Thunderbird 1.0.6 (Macintosh/20050716)
MIME-Version: 1.0
To: ofbiz-user@incubator.apache.org
Subject: Re: ofbiz hangs during startup
References: <44D1B460.5050800@americancomputertechnics.com>
 <253c119c0608030318p67c868b6m1ded3f092f804169@mail.gmail.com>
In-Reply-To: <253c119c0608030318p67c868b6m1ded3f092f804169@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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 <markt@americancomputertechnics.com> 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
>>
>