Re: ofbiz hangs during startup

Thu, 03 Aug 2006 05:09:22 -0700 

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 <[EMAIL PROTECTED]> 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

Reply via email to