ofbiz hangs during startup
Locked
 
|
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 |
|
|
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 > |
|
|
In reply to this post by Mark Thomas-10
have you set up ofbiz, from the sVN using the
OFBizBasicProductionSetup.pdf? define hangs, as in minutes, hours? There is no errors in your log. Mark Thomas sent the following on 8/3/2006 1:31 AM: > 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 > |
Re: ofbiz hangs during startup
|
|
In reply to this post by Midhat
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 >> > |
|
|
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 >>> >> > > |
Re: ofbiz hangs during startup
|
|
In reply to this post by Mark Thomas-10
Mark Thomas wrote:
> I have tried installing ofBiz on freeBSD 4.11, but it hangs during startup. First, the only testing I have done with Apache OFBiz is on a 6.1 box. What's the hardware like on your box? FreeBSD 4.11 will run in character mode just fine with just 32 Meg of memory, which from my limited POV will not run ofBiz at all. Also, threads have been drastically improved with current 5 and 6 series so it may behoove you to pick up a cheap box for testing with 1 gig memory and work with enough memory for ofBiz to do its thing (Note: FreeBSD 6 will also run on 32 meg memory, my point is that you may be running out of resources) Second, what Java SDK did you use? Native or Linux? Did you use the ports collection method to install? Mine looks like this: $ java -version java version "1.4.2-p8" Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2-p8-filepro_04_may_2006_11_30) Java HotSpot(TM) Client VM (build 1.4.2-p8-filepro_04_may_2006_11_30, mixed mode) Third, what user are you starting up as? Are you logging in as a member of the wheel group and su'ing into root, or running from the console as root? -- Walter |
Re: ofbiz hangs during startup
|
|
In reply to this post by BJ Freeman
BJ Freeman wrote:
> Just on vague chance, dose the data folder have permissions to write. > Thanks for the ideas : yes, the data folder has write permissions, and I'm logged in as root. No errors show in the log - that's the problem, only some WARNings and the usual debug messages, but maybe there's something important in there for the more knowledgeable of us. Here's a complete dump of my ./ant run-install : Buildfile: build.xml build: [echo] [build] ========== Start Building (Compile) ========== ofbiz-init: dir-init: copy-derby-props: build: [echo] [build] ========== Start Building Framework (Compile) ========== init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/base/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/base/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/base/build/lib/ofbiz.jar [jar] Building jar: /usr/local/ofbiz/framework/base/build/lib/ofbiz-base.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/entity/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/entity/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/entity/build/lib/ofbiz-entity.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/geronimo/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/geronimo/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/geronimo/build/lib/ofbiz-geronimo.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/catalina/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/catalina/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/catalina/build/lib/ofbiz-catalina.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/jetty/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/jetty/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/jetty/build/lib/ofbiz-jetty.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/security/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/security/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/security/build/lib/ofbiz-security.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/service/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/service/build/lib classpath: classes: stubs: main-jar: [jar] Building jar: /usr/local/ofbiz/framework/service/build/lib/ofbiz-service.jar rmi-jar: [jar] Building jar: /usr/local/ofbiz/framework/service/build/lib/ofbiz-service-rmi.raj jar: init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/entityext/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/entityext/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/entityext/build/lib/ofbiz-entityext.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/datafile/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/datafile/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/datafile/build/lib/ofbiz-datafile.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/minilang/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/minilang/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/minilang/build/lib/ofbiz-minilang.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/common/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/common/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/common/build/lib/ofbiz-common.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/workflow/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/workflow/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/workflow/build/lib/ofbiz-workflow.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/webapp/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/webapp/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/webapp/build/lib/ofbiz-webapp.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/guiapp/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/guiapp/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/guiapp/build/lib/ofbiz-guiapp.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/widget/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/widget/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/widget/build/lib/ofbiz-widget.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/testtools/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/testtools/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/testtools/build/lib/ofbiz-testtools.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/appserver/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/appserver/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/appserver/build/lib/ofbiz-appsvrs.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/framework/webtools/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/framework/webtools/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/framework/webtools/build/lib/ofbiz-webtools.jar [copy] Copying 1 file to /usr/local/ofbiz [echo] [build] ========== Done Building Framework (Compile) ========== build: [echo] [build] ========== Start Building Applications (Compile) ========== init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/applications/content/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/applications/content/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/applications/content/build/lib/ofbiz-content.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/applications/party/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/applications/party/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/applications/party/build/lib/ofbiz-party.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/applications/workeffort/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/applications/workeffort/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/applications/workeffort/build/lib/ofbiz-workeffort.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/applications/product/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/applications/product/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/applications/product/build/lib/ofbiz-product.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/applications/marketing/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/applications/marketing/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/applications/marketing/build/lib/ofbiz-marketing.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/applications/order/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/applications/order/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/applications/order/build/lib/ofbiz-order.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/applications/manufacturing/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/applications/manufacturing/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/applications/manufacturing/build/lib/ofbiz-manufacturing.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/applications/accounting/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/applications/accounting/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/applications/accounting/build/lib/ofbiz-accounting.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/applications/ecommerce/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/applications/ecommerce/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/applications/ecommerce/build/lib/ofbiz-ecommerce.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/applications/securityext/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/applications/securityext/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/applications/securityext/build/lib/ofbiz-securityext.jar init: clean-lib: [delete] Deleting directory /usr/local/ofbiz/applications/pos/build/lib prepare: [mkdir] Created dir: /usr/local/ofbiz/applications/pos/build/lib classpath: classes: jar: [jar] Building jar: /usr/local/ofbiz/applications/pos/build/lib/ofbiz-pos.jar [echo] [build] ========== Done Building Applications (Compile) ========== [echo] [build] ========== Done Building (Compile) ========== run-install: [java] Set OFBIZ_HOME to - /usr/local/ofbiz [java] Admin socket not configured; set to port 0 [java] 2006-08-04 08:16:30,449 (main) [ ContainerLoader.java:48 :INFO ] [Startup] Loading containers... [java] 2006-08-04 08:16:32,204 (main) [ UtilXml.java:255:DEBUG] XML Read 1.663s: file:/usr/local/ofbiz/framework/base/config/install-containers.xml [java] 2006-08-04 08:16:32,345 (main) [ UtilXml.java:255:DEBUG] XML Read 0.034s: file:/usr/local/ofbiz/framework/base/config/component-load.xml [java] 2006-08-04 08:16:32,387 (main) [ ComponentContainer.java:146:INFO ] Auto-Loading component directory : [/usr/local/ofbiz/framework] [java] 2006-08-04 08:16:32,447 (main) [ UtilXml.java:255:DEBUG] XML Read 0.058s: file:/usr/local/ofbiz/framework/component-load.xml [java] 2006-08-04 08:16:32,546 (main) [ UtilXml.java:255:DEBUG] XML Read 0.084s: file:/usr/local/ofbiz/framework/geronimo/ofbiz-component.xml [java] 2006-08-04 08:16:32,554 (main) [ ComponentContainer.java:208:INFO ] Loading component : [geronimo] [java] 2006-08-04 08:16:32,677 (main) [ UtilXml.java:255:DEBUG] XML Read 0.104s: file:/usr/local/ofbiz/framework/entity/ofbiz-component.xml [java] 2006-08-04 08:16:32,688 (main) [ ComponentContainer.java:208:INFO ] Loading component : [entity] [java] 2006-08-04 08:16:32,772 (main) [ UtilXml.java:255:DEBUG] XML Read 0.075s: file:/usr/local/ofbiz/framework/catalina/ofbiz-component.xml [java] 2006-08-04 08:16:32,776 (main) [ ComponentContainer.java:208:INFO ] Loading component : [catalina] [java] 2006-08-04 08:16:32,907 (main) [ UtilXml.java:255:DEBUG] XML Read 0.127s: file:/usr/local/ofbiz/framework/security/ofbiz-component.xml [java] 2006-08-04 08:16:32,913 (main) [ ComponentContainer.java:208:INFO ] Loading component : [security] [java] 2006-08-04 08:16:32,969 (main) [ UtilXml.java:255:DEBUG] XML Read 0.053s: file:/usr/local/ofbiz/framework/datafile/ofbiz-component.xml [java] 2006-08-04 08:16:32,973 (main) [ ComponentContainer.java:208:INFO ] Loading component : [datafile] [java] 2006-08-04 08:16:33,057 (main) [ UtilXml.java:255:DEBUG] XML Read 0.082s: file:/usr/local/ofbiz/framework/minilang/ofbiz-component.xml [java] 2006-08-04 08:16:33,060 (main) [ ComponentContainer.java:208:INFO ] Loading component : [minilang] [java] 2006-08-04 08:16:33,112 (main) [ UtilXml.java:255:DEBUG] XML Read 0.049s: file:/usr/local/ofbiz/framework/common/ofbiz-component.xml [java] 2006-08-04 08:16:33,121 (main) [ ComponentContainer.java:208:INFO ] Loading component : [common] [java] 2006-08-04 08:16:33,223 (main) [ UtilXml.java:255:DEBUG] XML Read 0.099s: file:/usr/local/ofbiz/framework/service/ofbiz-component.xml [java] 2006-08-04 08:16:33,227 (main) [ ComponentContainer.java:208:INFO ] Loading component : [service] [java] 2006-08-04 08:16:33,297 (main) [ UtilXml.java:255:DEBUG] XML Read 0.061s: file:/usr/local/ofbiz/framework/entityext/ofbiz-component.xml [java] 2006-08-04 08:16:33,304 (main) [ ComponentContainer.java:208:INFO ] Loading component : [entityext] [java] 2006-08-04 08:16:33,369 (main) [ UtilXml.java:255:DEBUG] XML Read 0.062s: file:/usr/local/ofbiz/framework/webapp/ofbiz-component.xml [java] 2006-08-04 08:16:33,375 (main) [ ComponentContainer.java:208:INFO ] Loading component : [webapp] [java] 2006-08-04 08:16:33,501 (main) [ UtilXml.java:255:DEBUG] XML Read 0.122s: file:/usr/local/ofbiz/framework/guiapp/ofbiz-component.xml [java] 2006-08-04 08:16:33,509 (main) [ ComponentContainer.java:208:INFO ] Loading component : [guiapp] [java] 2006-08-04 08:16:33,557 (main) [ UtilXml.java:255:DEBUG] XML Read 0.043s: file:/usr/local/ofbiz/framework/widget/ofbiz-component.xml [java] 2006-08-04 08:16:33,560 (main) [ ComponentContainer.java:208:INFO ] Loading component : [widget] [java] 2006-08-04 08:16:33,595 (main) [ UtilXml.java:255:DEBUG] XML Read 0.032s: file:/usr/local/ofbiz/framework/appserver/ofbiz-component.xml [java] 2006-08-04 08:16:33,597 (main) [ ComponentContainer.java:208:INFO ] Loading component : [appservers] [java] 2006-08-04 08:16:33,646 (main) [ UtilXml.java:255:DEBUG] XML Read 0.044s: file:/usr/local/ofbiz/framework/workflow/ofbiz-component.xml [java] 2006-08-04 08:16:33,650 (main) [ ComponentContainer.java:208:INFO ] Loading component : [workflow] [java] 2006-08-04 08:16:33,688 (main) [ UtilXml.java:255:DEBUG] XML Read 0.034s: file:/usr/local/ofbiz/framework/shark/ofbiz-component.xml [java] 2006-08-04 08:16:33,711 (main) [ ComponentContainer.java:208:INFO ] Loading component : [shark] [java] 2006-08-04 08:16:33,715 (main) [ ComponentContainer.java:249:WARN ] Location '/usr/local/ofbiz/framework/shark/build/lib' does not exist [java] 2006-08-04 08:16:33,757 (main) [ UtilXml.java:255:DEBUG] XML Read 0.039s: file:/usr/local/ofbiz/framework/testtools/ofbiz-component.xml [java] 2006-08-04 08:16:33,762 (main) [ ComponentContainer.java:208:INFO ] Loading component : [example] [java] 2006-08-04 08:16:33,802 (main) [ UtilXml.java:255:DEBUG] XML Read 0.037s: file:/usr/local/ofbiz/framework/webtools/ofbiz-component.xml [java] 2006-08-04 08:16:33,805 (main) [ ComponentContainer.java:208:INFO ] Loading component : [webtools] [java] 2006-08-04 08:16:33,929 (main) [ UtilXml.java:255:DEBUG] XML Read 0.121s: file:/usr/local/ofbiz/framework/images/ofbiz-component.xml [java] 2006-08-04 08:16:33,934 (main) [ ComponentContainer.java:208:INFO ] Loading component : [images] [java] 2006-08-04 08:16:34,005 (main) [ UtilXml.java:255:DEBUG] XML Read 0.069s: file:/usr/local/ofbiz/framework/example/ofbiz-component.xml [java] 2006-08-04 08:16:34,009 (main) [ ComponentConfig.java:76 :WARN ] WARNING: Loading ofbiz-component using a global name that already exists, will over-write: example [java] 2006-08-04 08:16:34,011 (main) [ ComponentContainer.java:208:INFO ] Loading component : [example] [java] 2006-08-04 08:16:34,013 (main) [ ComponentContainer.java:249:WARN ] Location '/usr/local/ofbiz/framework/example/build/lib' does not exist [java] 2006-08-04 08:16:34,015 (main) [ ComponentContainer.java:146:INFO ] Auto-Loading component directory : [/usr/local/ofbiz/applications] [java] 2006-08-04 08:16:34,054 (main) [ UtilXml.java:255:DEBUG] XML Read 0.034s: file:/usr/local/ofbiz/applications/component-load.xml [java] 2006-08-04 08:16:34,090 (main) [ UtilXml.java:255:DEBUG] XML Read 0.03s: file:/usr/local/ofbiz/applications/party/ofbiz-component.xml [java] 2006-08-04 08:16:34,102 (main) [ ComponentContainer.java:208:INFO ] Loading component : [party] [java] 2006-08-04 08:16:34,136 (main) [ UtilXml.java:255:DEBUG] XML Read 0.031s: file:/usr/local/ofbiz/applications/securityext/ofbiz-component.xml [java] 2006-08-04 08:16:34,141 (main) [ ComponentContainer.java:208:INFO ] Loading component : [securityext] [java] 2006-08-04 08:16:34,178 (main) [ UtilXml.java:255:DEBUG] XML Read 0.033s: file:/usr/local/ofbiz/applications/content/ofbiz-component.xml [java] 2006-08-04 08:16:34,185 (main) [ ComponentContainer.java:208:INFO ] Loading component : [content] [java] 2006-08-04 08:16:34,325 (main) [ UtilXml.java:255:DEBUG] XML Read 0.134s: file:/usr/local/ofbiz/applications/workeffort/ofbiz-component.xml [java] 2006-08-04 08:16:34,335 (main) [ ComponentContainer.java:208:INFO ] Loading component : [workeffort] [java] 2006-08-04 08:16:34,380 (main) [ UtilXml.java:255:DEBUG] XML Read 0.033s: file:/usr/local/ofbiz/applications/humanres/ofbiz-component.xml [java] 2006-08-04 08:16:34,387 (main) [ ComponentContainer.java:208:INFO ] Loading component : [humanres] [java] 2006-08-04 08:16:34,400 (main) [ ComponentContainer.java:249:WARN ] Location '/usr/local/ofbiz/applications/humanres/build/lib' does not exist [java] 2006-08-04 08:16:34,429 (main) [ UtilXml.java:255:DEBUG] XML Read 0.027s: file:/usr/local/ofbiz/applications/product/ofbiz-component.xml [java] 2006-08-04 08:16:34,454 (main) [ ComponentContainer.java:208:INFO ] Loading component : [product] [java] 2006-08-04 08:16:34,525 (main) [ UtilXml.java:255:DEBUG] XML Read 0.061s: file:/usr/local/ofbiz/applications/manufacturing/ofbiz-component.xml [java] 2006-08-04 08:16:34,530 (main) [ ComponentContainer.java:208:INFO ] Loading component : [manufacturing] [java] 2006-08-04 08:16:34,584 (main) [ UtilXml.java:255:DEBUG] XML Read 0.049s: file:/usr/local/ofbiz/applications/accounting/ofbiz-component.xml [java] 2006-08-04 08:16:34,590 (main) [ ComponentContainer.java:208:INFO ] Loading component : [accounting] [java] 2006-08-04 08:16:34,593 (main) [ ComponentContainer.java:249:WARN ] Location '/usr/local/ofbiz/applications/accounting/lib/cybersource' does not exist [java] 2006-08-04 08:16:34,595 (main) [ ComponentContainer.java:249:WARN ] Location '/usr/local/ofbiz/applications/accounting/lib/worldpay' does not exist [java] 2006-08-04 08:16:34,647 (main) [ UtilXml.java:255:DEBUG] XML Read 0.05s: file:/usr/local/ofbiz/applications/order/ofbiz-component.xml [java] 2006-08-04 08:16:34,659 (main) [ ComponentContainer.java:208:INFO ] Loading component : [order] [java] 2006-08-04 08:16:34,696 (main) [ UtilXml.java:255:DEBUG] XML Read 0.033s: file:/usr/local/ofbiz/applications/marketing/ofbiz-component.xml [java] 2006-08-04 08:16:34,698 (main) [ ComponentContainer.java:208:INFO ] Loading component : [marketing] [java] 2006-08-04 08:16:34,740 (main) [ UtilXml.java:255:DEBUG] XML Read 0.039s: file:/usr/local/ofbiz/applications/ecommerce/ofbiz-component.xml [java] 2006-08-04 08:16:34,827 (main) [ ComponentContainer.java:208:INFO ] Loading component : [ecommerce] [java] 2006-08-04 08:16:34,876 (main) [ UtilXml.java:255:DEBUG] XML Read 0.041s: file:/usr/local/ofbiz/applications/pos/ofbiz-component.xml [java] 2006-08-04 08:16:34,881 (main) [ ComponentContainer.java:208:INFO ] Loading component : [pos] [java] 2006-08-04 08:16:34,885 (main) [ ComponentContainer.java:146:INFO ] Auto-Loading component directory : [/usr/local/ofbiz/specialized] [java] 2006-08-04 08:16:34,887 (main) [ ComponentContainer.java:146:INFO ] Auto-Loading component directory : [/usr/local/ofbiz/hot-deploy] [java] 2006-08-04 08:16:34,899 (main) [ ComponentContainer.java:121:INFO ] All components loaded [java] 2006-08-04 08:16:35,000 (main) [ClassLoaderContainer.java:50 :INFO ] CachedClassLoader created [java] Shutdown hook disabled [java] 2006-08-04 08:16:35,100 (main) [ ContainerLoader.java:74 :INFO ] [Startup] Starting containers... [java] 2006-08-04 08:16:35,199 (main) [ GenericDelegator.java:124:INFO ] Creating new delegator [default] (main) [java] 2006-08-04 08:16:35,362 (main) [ UtilXml.java:255:DEBUG] XML Read 0.12s: file:/usr/local/ofbiz/framework/entity/config/entityengine.xml [java] 2006-08-04 08:16:35,637 (main) [ UtilXml.java:255:DEBUG] XML Read 0.07s: /usr/local/ofbiz/framework/entity/entitydef/entitymodel.xml [java] 2006-08-04 08:16:35,738 (main) [ UtilXml.java:255:DEBUG] XML Read 0.041s: /usr/local/ofbiz/framework/entity/entitydef/entitymodel_test.xml [java] 2006-08-04 08:16:35,859 (main) [ UtilXml.java:255:DEBUG] XML Read 0.071s: /usr/local/ofbiz/framework/catalina/entitydef/entitymodel.xml [java] 2006-08-04 08:16:36,012 (main) [ UtilXml.java:255:DEBUG] XML Read 0.129s: /usr/local/ofbiz/framework/security/entitydef/entitymodel.xml [java] 2006-08-04 08:16:36,095 (main) [ UtilXml.java:255:DEBUG] XML Read 0.057s: /usr/local/ofbiz/framework/common/entitydef/entitymodel.xml [java] 2006-08-04 08:16:36,186 (main) [ UtilXml.java:255:DEBUG] XML Read 0.041s: /usr/local/ofbiz/framework/service/entitydef/entitymodel.xml [java] 2006-08-04 08:16:36,267 (main) [ UtilXml.java:255:DEBUG] XML Read 0.063s: /usr/local/ofbiz/framework/entityext/entitydef/entitymodel.xml [java] 2006-08-04 08:16:36,457 (main) [ UtilXml.java:255:DEBUG] XML Read 0.048s: /usr/local/ofbiz/framework/webapp/entitydef/entitymodel.xml [java] 2006-08-04 08:16:36,654 (main) [ UtilXml.java:255:DEBUG] XML Read 0.178s: /usr/local/ofbiz/framework/workflow/entitydef/entitymodel.xml [java] 2006-08-04 08:16:36,915 (main) [ UtilXml.java:255:DEBUG] XML Read 0.203s: /usr/local/ofbiz/framework/shark/entitydef/entitymodel.xml [java] 2006-08-04 08:16:36,959 (main) [ UtilXml.java:255:DEBUG] XML Read 0.03s: /usr/local/ofbiz/framework/example/entitydef/entitymodel.xml [java] 2006-08-04 08:16:37,074 (main) [ UtilXml.java:255:DEBUG] XML Read 0.104s: /usr/local/ofbiz/applications/party/entitydef/entitymodel.xml [java] 2006-08-04 08:16:37,373 (main) [ UtilXml.java:255:DEBUG] XML Read 0.081s: /usr/local/ofbiz/applications/content/entitydef/entitymodel.xml [java] 2006-08-04 08:16:37,475 (main) [ UtilXml.java:255:DEBUG] XML Read 0.058s: /usr/local/ofbiz/applications/workeffort/entitydef/entitymodel.xml [java] 2006-08-04 08:16:37,744 (main) [ UtilXml.java:255:DEBUG] XML Read 0.236s: /usr/local/ofbiz/applications/workeffort/entitydef/entitymodel_view.xml [java] 2006-08-04 08:16:37,813 (main) [ UtilXml.java:255:DEBUG] XML Read 0.047s: /usr/local/ofbiz/applications/humanres/entitydef/entitymodel.xml [java] 2006-08-04 08:16:38,083 (main) [ UtilXml.java:255:DEBUG] XML Read 0.249s: /usr/local/ofbiz/applications/product/entitydef/entitymodel.xml [java] 2006-08-04 08:16:38,419 (main) [ UtilXml.java:255:DEBUG] XML Read 0.035s: /usr/local/ofbiz/applications/product/entitydef/entitymodel_odbc.xml [java] 2006-08-04 08:16:38,501 (main) [ UtilXml.java:255:DEBUG] XML Read 0.069s: /usr/local/ofbiz/applications/product/entitydef/entitymodel_shipment.xml [java] 2006-08-04 08:16:38,623 (main) [ UtilXml.java:255:DEBUG] XML Read 0.093s: /usr/local/ofbiz/applications/manufacturing/entitydef/entitymodel.xml [java] 2006-08-04 08:16:38,910 (main) [ UtilXml.java:255:DEBUG] XML Read 0.282s: /usr/local/ofbiz/applications/accounting/entitydef/entitymodel.xml [java] 2006-08-04 08:16:39,024 (main) [ UtilXml.java:255:DEBUG] XML Read 0.042s: /usr/local/ofbiz/applications/accounting/entitydef/entitymodel_old.xml [java] 2006-08-04 08:16:39,125 (main) [ UtilXml.java:255:DEBUG] XML Read 0.098s: /usr/local/ofbiz/applications/order/entitydef/entitymodel.xml [java] 2006-08-04 08:16:39,219 (main) [ UtilXml.java:255:DEBUG] XML Read 0.033s: /usr/local/ofbiz/applications/order/entitydef/entitymodel_old.xml [java] 2006-08-04 08:16:39,503 (main) [ UtilXml.java:255:DEBUG] XML Read 0.28s: /usr/local/ofbiz/applications/order/entitydef/entitymodel_view.xml [java] 2006-08-04 08:16:39,585 (main) [ UtilXml.java:255:DEBUG] XML Read 0.047s: /usr/local/ofbiz/applications/marketing/entitydef/entitymodel.xml [java] 2006-08-04 08:16:39,628 (main) [ UtilXml.java:255:DEBUG] XML Read 0.034s: /usr/local/ofbiz/applications/pos/entitydef/entitymodel.xml [java] 2006-08-04 08:16:40,559 (main) [ ModelReader.java:382:INFO ] FINISHED LOADING ENTITIES - ALL FILES; #Entities=735 #ViewEntities=140 #Fields=7452 #Relationships=2417 #AutoRelationships=1781 [java] 2006-08-04 08:16:40,602 (main) [ UtilXml.java:255:DEBUG] XML Read 0.023s: /usr/local/ofbiz/framework/entity/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,620 (main) [ UtilXml.java:255:DEBUG] XML Read 0.0080s: /usr/local/ofbiz/framework/entity/entitydef/entitygroup_test.xml [java] 2006-08-04 08:16:40,635 (main) [ UtilXml.java:255:DEBUG] XML Read 0.013s: /usr/local/ofbiz/framework/catalina/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,653 (main) [ UtilXml.java:255:DEBUG] XML Read 0.015s: /usr/local/ofbiz/framework/security/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,669 (main) [ UtilXml.java:255:DEBUG] XML Read 0.013s: /usr/local/ofbiz/framework/common/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,692 (main) [ UtilXml.java:255:DEBUG] XML Read 0.021s: /usr/local/ofbiz/framework/service/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,705 (main) [ UtilXml.java:255:DEBUG] XML Read 0.0080s: /usr/local/ofbiz/framework/entityext/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,722 (main) [ UtilXml.java:255:DEBUG] XML Read 0.015s: /usr/local/ofbiz/framework/webapp/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,734 (main) [ UtilXml.java:255:DEBUG] XML Read 0.0070s: /usr/local/ofbiz/framework/workflow/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,751 (main) [ UtilXml.java:255:DEBUG] XML Read 0.015s: /usr/local/ofbiz/framework/shark/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,767 (main) [ UtilXml.java:255:DEBUG] XML Read 0.013s: /usr/local/ofbiz/framework/example/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,786 (main) [ UtilXml.java:255:DEBUG] XML Read 0.017s: /usr/local/ofbiz/applications/party/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,808 (main) [ UtilXml.java:255:DEBUG] XML Read 0.019s: /usr/local/ofbiz/applications/content/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,822 (main) [ UtilXml.java:255:DEBUG] XML Read 0.011s: /usr/local/ofbiz/applications/workeffort/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,836 (main) [ UtilXml.java:255:DEBUG] XML Read 0.011s: /usr/local/ofbiz/applications/humanres/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,855 (main) [ UtilXml.java:255:DEBUG] XML Read 0.016s: /usr/local/ofbiz/applications/product/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,878 (main) [ UtilXml.java:255:DEBUG] XML Read 0.017s: /usr/local/ofbiz/applications/manufacturing/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,895 (main) [ UtilXml.java:255:DEBUG] XML Read 0.015s: /usr/local/ofbiz/applications/accounting/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,919 (main) [ UtilXml.java:255:DEBUG] XML Read 0.019s: /usr/local/ofbiz/applications/order/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,938 (main) [ UtilXml.java:255:DEBUG] XML Read 0.015s: /usr/local/ofbiz/applications/marketing/entitydef/entitygroup.xml [java] 2006-08-04 08:16:40,963 (main) [ UtilXml.java:255:DEBUG] XML Read 0.023s: /usr/local/ofbiz/applications/pos/entitydef/entitygroup.xml [java] 2006-08-04 08:16:41,002 (main) [ GenericDelegator.java:159:INFO ] Doing entity definition check... [java] 2006-08-04 08:16:41,034 (main) [ ModelEntityChecker.java:514:INFO ] [initReservedWords] array length=1023 [java] 2006-08-04 08:16:41,107 (main) [ UtilXml.java:255:DEBUG] XML Read 0.023s: entityengine.xml [java] 2006-08-04 08:16:41,279 (main) [ UtilXml.java:255:DEBUG] XML Read 0.027s: entityengine.xml [java] 2006-08-04 08:16:41,529 (main) [ GenericDelegator.java:176:INFO ] Delegator "default" initializing helper "localpostgres" for entity group "org.ofbiz". [java] 2006-08-04 08:16:41,549 (main) [ GenericDelegator.java:193:INFO ] Doing database check as requested in entityengine.xml with addMissing=true [java] 2006-08-04 08:16:42,396 (main) [ DatabaseUtil.java:765:INFO ] Database Product Name is PostgreSQL [java] 2006-08-04 08:16:42,398 (main) [ DatabaseUtil.java:766:INFO ] Database Product Version is 8.0.1 [java] 2006-08-04 08:16:42,400 (main) [ DatabaseUtil.java:774:INFO ] Database Driver Name is PostgreSQL Native Driver [java] 2006-08-04 08:16:42,412 (main) [ DatabaseUtil.java:775:INFO ] Database Driver Version is PostgreSQL 8.0 JDBC3 with SSL (build 317) [java] 2006-08-04 08:16:42,414 (main) [ DatabaseUtil.java:776:INFO ] Database Driver JDBC Version is 3.0 [java] 2006-08-04 08:16:42,415 (main) [ DatabaseUtil.java:786:INFO ] Database Setting/Support Information (those with a * should be true): [java] 2006-08-04 08:16:42,417 (main) [ DatabaseUtil.java:787:INFO ] - supports transactions [true]* [java] 2006-08-04 08:16:42,418 (main) [ DatabaseUtil.java:788:INFO ] - isolation None [false] [java] 2006-08-04 08:16:42,420 (main) [ DatabaseUtil.java:789:INFO ] - isolation ReadCommitted [true] [java] 2006-08-04 08:16:42,423 (main) [ DatabaseUtil.java:790:INFO ] - isolation ReadUncommitted[true] [java] 2006-08-04 08:16:42,425 (main) [ DatabaseUtil.java:791:INFO ] - isolation RepeatableRead [true] [java] 2006-08-04 08:16:42,426 (main) [ DatabaseUtil.java:792:INFO ] - isolation Serializable [true] [java] 2006-08-04 08:16:42,435 (main) [ DatabaseUtil.java:793:INFO ] - default fetchsize [0] [java] 2006-08-04 08:16:42,437 (main) [ DatabaseUtil.java:794:INFO ] - forward only type [true] [java] 2006-08-04 08:16:42,439 (main) [ DatabaseUtil.java:795:INFO ] - scroll sensitive type [false] [java] 2006-08-04 08:16:42,440 (main) [ DatabaseUtil.java:796:INFO ] - scroll insensitive type [true] [java] 2006-08-04 08:16:42,441 (main) [ DatabaseUtil.java:797:INFO ] - is case sensitive [false] [java] 2006-08-04 08:16:42,443 (main) [ DatabaseUtil.java:798:INFO ] - stores LowerCase [true] [java] 2006-08-04 08:16:42,444 (main) [ DatabaseUtil.java:799:INFO ] - stores MixedCase [false] [java] 2006-08-04 08:16:42,446 (main) [ DatabaseUtil.java:800:INFO ] - stores UpperCase [false] [java] 2006-08-04 08:16:42,508 (main) [ DatabaseUtil.java:801:INFO ] - max table name length [63] [java] 2006-08-04 08:16:42,510 (main) [ DatabaseUtil.java:802:INFO ] - max column name length [63] [java] 2006-08-04 08:16:42,512 (main) [ DatabaseUtil.java:803:INFO ] - max schema name length [63] [java] 2006-08-04 08:16:42,513 (main) [ DatabaseUtil.java:804:INFO ] - concurrent connections [8192] [java] 2006-08-04 08:16:42,515 (main) [ DatabaseUtil.java:805:INFO ] - concurrent statements [1] [java] 2006-08-04 08:16:42,516 (main) [ DatabaseUtil.java:806:INFO ] - ANSI SQL92 Entry [true] [java] 2006-08-04 08:16:42,518 (main) [ DatabaseUtil.java:807:INFO ] - ANSI SQL92 Itermediate [false] [java] 2006-08-04 08:16:42,535 (main) [ DatabaseUtil.java:808:INFO ] - ANSI SQL92 Full [false] [java] 2006-08-04 08:16:42,536 (main) [ DatabaseUtil.java:809:INFO ] - ODBC SQL Grammar Core [false] [java] 2006-08-04 08:16:42,538 (main) [ DatabaseUtil.java:810:INFO ] - ODBC SQL Grammar Extended[false] [java] 2006-08-04 08:16:42,539 (main) [ DatabaseUtil.java:811:INFO ] - ODBC SQL Grammar Minimum [true] [java] 2006-08-04 08:16:42,542 (main) [ DatabaseUtil.java:812:INFO ] - outer joins [true]* [java] 2006-08-04 08:16:42,545 (main) [ DatabaseUtil.java:813:INFO ] - limited outer joins [true] [java] 2006-08-04 08:16:42,547 (main) [ DatabaseUtil.java:814:INFO ] - full outer joins [true] [java] 2006-08-04 08:16:42,548 (main) [ DatabaseUtil.java:815:INFO ] - group by [true]* [java] 2006-08-04 08:16:42,549 (main) [ DatabaseUtil.java:816:INFO ] - group by not in select [true] [java] 2006-08-04 08:16:42,551 (main) [ DatabaseUtil.java:817:INFO ] - column aliasing [true] [java] 2006-08-04 08:16:42,553 (main) [ DatabaseUtil.java:818:INFO ] - order by not in select [true] [java] 2006-08-04 08:16:42,556 (main) [ DatabaseUtil.java:820:INFO ] - alter table add column [true]* [java] 2006-08-04 08:16:42,558 (main) [ DatabaseUtil.java:821:INFO ] - non-nullable column [true]* [java] 2006-08-04 08:16:42,563 (main) [ DatabaseUtil.java:858:INFO ] Getting Table Info From Database [java] 2006-08-04 08:16:42,739 (main) [ DatabaseUtil.java:993:INFO ] Getting Column Info From Database [java] 2006-08-04 08:16:46,387 (main) [ GenericDelegator.java:176:INFO ] Delegator "default" initializing helper "localderbyodbc" for entity group "org.ofbiz.odbc". [java] 2006-08-04 08:16:46,389 (main) [ GenericDelegator.java:193:INFO ] Doing database check as requested in entityengine.xml with addMissing=true [java] 2006-08-04 08:16:49,960 (main) [ DatabaseUtil.java:765:INFO ] Database Product Name is Apache Derby [java] 2006-08-04 08:16:49,962 (main) [ DatabaseUtil.java:766:INFO ] Database Product Version is 10.1.3.1 [java] 2006-08-04 08:16:49,963 (main) [ DatabaseUtil.java:774:INFO ] Database Driver Name is Apache Derby Embedded JDBC Driver [java] 2006-08-04 08:16:49,965 (main) [ DatabaseUtil.java:775:INFO ] Database Driver Version is 10.1.3.1 [java] 2006-08-04 08:16:49,966 (main) [ DatabaseUtil.java:776:INFO ] Database Driver JDBC Version is 3.0 [java] 2006-08-04 08:16:49,967 (main) [ DatabaseUtil.java:786:INFO ] Database Setting/Support Information (those with a * should be true): [java] 2006-08-04 08:16:49,969 (main) [ DatabaseUtil.java:787:INFO ] - supports transactions [true]* [java] 2006-08-04 08:16:49,973 (main) [ DatabaseUtil.java:788:INFO ] - isolation None [false] [java] 2006-08-04 08:16:49,977 (main) [ DatabaseUtil.java:789:INFO ] - isolation ReadCommitted [true] [java] 2006-08-04 08:16:49,978 (main) [ DatabaseUtil.java:790:INFO ] - isolation ReadUncommitted[true] [java] 2006-08-04 08:16:49,980 (main) [ DatabaseUtil.java:791:INFO ] - isolation RepeatableRead [true] [java] 2006-08-04 08:16:49,982 (main) [ DatabaseUtil.java:792:INFO ] - isolation Serializable [true] [java] 2006-08-04 08:16:49,997 (main) [ DatabaseUtil.java:793:INFO ] - default fetchsize [1] [java] 2006-08-04 08:16:49,999 (main) [ DatabaseUtil.java:794:INFO ] - forward only type [true] [java] 2006-08-04 08:16:50,000 (main) [ DatabaseUtil.java:795:INFO ] - scroll sensitive type [false] [java] 2006-08-04 08:16:50,002 (main) [ DatabaseUtil.java:796:INFO ] - scroll insensitive type [true] [java] 2006-08-04 08:16:50,003 (main) [ DatabaseUtil.java:797:INFO ] - is case sensitive [false] [java] 2006-08-04 08:16:50,009 (main) [ DatabaseUtil.java:798:INFO ] - stores LowerCase [false] [java] 2006-08-04 08:16:50,011 (main) [ DatabaseUtil.java:799:INFO ] - stores MixedCase [false] [java] 2006-08-04 08:16:50,012 (main) [ DatabaseUtil.java:800:INFO ] - stores UpperCase [true] [java] 2006-08-04 08:16:50,014 (main) [ DatabaseUtil.java:801:INFO ] - max table name length [128] [java] 2006-08-04 08:16:50,015 (main) [ DatabaseUtil.java:802:INFO ] - max column name length [128] [java] 2006-08-04 08:16:50,016 (main) [ DatabaseUtil.java:803:INFO ] - max schema name length [128] [java] 2006-08-04 08:16:50,020 (main) [ DatabaseUtil.java:804:INFO ] - concurrent connections [0] [java] 2006-08-04 08:16:50,021 (main) [ DatabaseUtil.java:805:INFO ] - concurrent statements [0] [java] 2006-08-04 08:16:50,023 (main) [ DatabaseUtil.java:806:INFO ] - ANSI SQL92 Entry [false] [java] 2006-08-04 08:16:50,024 (main) [ DatabaseUtil.java:807:INFO ] - ANSI SQL92 Itermediate [false] [java] 2006-08-04 08:16:50,025 (main) [ DatabaseUtil.java:808:INFO ] - ANSI SQL92 Full [false] [java] 2006-08-04 08:16:50,027 (main) [ DatabaseUtil.java:809:INFO ] - ODBC SQL Grammar Core [false] [java] 2006-08-04 08:16:50,028 (main) [ DatabaseUtil.java:810:INFO ] - ODBC SQL Grammar Extended[false] [java] 2006-08-04 08:16:50,029 (main) [ DatabaseUtil.java:811:INFO ] - ODBC SQL Grammar Minimum [true] [java] 2006-08-04 08:16:50,031 (main) [ DatabaseUtil.java:812:INFO ] - outer joins [true]* [java] 2006-08-04 08:16:50,032 (main) [ DatabaseUtil.java:813:INFO ] - limited outer joins [true] [java] 2006-08-04 08:16:50,034 (main) [ DatabaseUtil.java:814:INFO ] - full outer joins [false] [java] 2006-08-04 08:16:50,035 (main) [ DatabaseUtil.java:815:INFO ] - group by [true]* [java] 2006-08-04 08:16:50,036 (main) [ DatabaseUtil.java:816:INFO ] - group by not in select [true] [java] 2006-08-04 08:16:50,038 (main) [ DatabaseUtil.java:817:INFO ] - column aliasing [true] [java] 2006-08-04 08:16:50,039 (main) [ DatabaseUtil.java:818:INFO ] - order by not in select [false] [java] 2006-08-04 08:16:50,041 (main) [ DatabaseUtil.java:820:INFO ] - alter table add column [true]* [java] 2006-08-04 08:16:50,042 (main) [ DatabaseUtil.java:821:INFO ] - non-nullable column [true]* [java] 2006-08-04 08:16:50,043 (main) [ DatabaseUtil.java:858:INFO ] Getting Table Info From Database [java] 2006-08-04 08:16:52,277 (main) [ DatabaseUtil.java:993:INFO ] Getting Column Info From Database |
Re: ofbiz hangs during startup
|
|
In reply to this post by BJ Freeman
BJ Freeman wrote:
> have you set up ofbiz, from the sVN using the > OFBizBasicProductionSetup.pdf? > define hangs, as in minutes, hours? > There is no errors in your log. > Yep, been through that document and every other document I could find on OFBiz installation. I've also been through the forum archives etc. and can't find that anyone has had anything similar - normally there are error messages shown in the log, but I don't get any errors - it just hangs until I ctrl C out of it. |
Re: ofbiz hangs during startup
|
|
In reply to this post by Walter Vaughan
Walter Vaughan wrote:
> Mark Thomas wrote: > >> I have tried installing ofBiz on freeBSD 4.11, but it hangs during >> startup. > > > First, the only testing I have done with Apache OFBiz is on a 6.1 box. > What's the hardware like on your box? FreeBSD 4.11 will run in > character mode just fine with just 32 Meg of memory, which from my > limited POV will not run ofBiz at all. Also, threads have been > drastically improved with current 5 and 6 series so it may behoove you > to pick up a cheap box for testing with 1 gig memory and work with > enough memory for ofBiz to do its thing (Note: FreeBSD 6 will also run > on 32 meg memory, my point is that you may be running out of resources) Thanks for the ideas there, I hadn't thought about resources being the problem. The box is an HP Netserver, Pentium III, 1.2Gb with 1gb of RAM, so I would have thought it had enough grunt. My 'top' looks like this after the OFBiz has been running and hanging for a few minutes : last pid: 31168; load averages: 0.00, 0.04, 0.04 up 3+20:33:48 08:33:34 96 processes: 1 running, 95 sleeping CPU states: 0.0% user, 0.0% nice, 0.0% system, 0.0% interrupt, 100% idle Mem: 213M Active, 604M Inact, 109M Wired, 42M Cache, 112M Buf, 36M Free Swap: 2032M Total, 132K Used, 2032M Free PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND 31168 root 28 0 2036K 1020K RUN 0:00 1.92% 0.63% top 298 root 2 0 4936K 3832K select 36:03 0.00% 0.00% snmpd 258 mysql 2 0 289M 20228K poll 2:14 0.00% 0.00% mysqld 143 root -6 0 872K 296K piperd 0:23 0.00% 0.00% readproctitle 30150 root 2 0 580M 73596K poll 0:23 0.00% 0.00% java 29853 root 2 0 218M 22092K poll 0:16 0.00% 0.00% java 142 root 10 0 924K 444K nanslp 0:08 0.00% 0.00% svscan 350 uucp 2 0 968K 632K select 0:07 0.00% 0.00% upsd 274 root 10 0 928K 436K nanslp 0:07 0.00% 0.00% svscan 16412 zope 2 0 34868K 32968K poll 0:07 0.00% 0.00% python2.3 285 qmails 2 0 976K 544K select 0:06 0.00% 0.00% qmail-send 153 root 2 0 14832K 6300K select 0:06 0.00% 0.00% httpd 100 root 2 0 992K 624K select 0:05 0.00% 0.00% syslogd 365 zope 2 0 6108K 4600K poll 0:04 0.00% 0.00% python2.3 294 qmaill -6 0 904K 444K piperd 0:04 0.00% 0.00% multilog 112 root 2 0 2604K 1240K select 0:03 0.00% 0.00% sshd 287 root 2 0 1308K 752K accept 0:03 0.00% 0.00% tcpserver The two java processes are the OFBiz processes - they do seem to be taking a lot of memory there, perhaps that's the prob? a 'vmstat' shows this : procs memory page disks faults cpu r b w avm fre flt re pi po fr sr am0 md0 in sy cs us sy id 2 11 0 1360368 76500 149 0 0 0 135 5 0 0 233 4333 57 3 1 96 > > Second, what Java SDK did you use? Native or Linux? Did you use the > ports collection method to install? Mine looks like this: > > $ java -version > java version "1.4.2-p8" > Java(TM) 2 Runtime Environment, Standard Edition (build > 1.4.2-p8-filepro_04_may_2006_11_30) > Java HotSpot(TM) Client VM (build 1.4.2-p8-filepro_04_may_2006_11_30, > mixed mode) > java version "1.4.2-p7" Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2-p7-mark_07_may_2005_14_30) Java HotSpot(TM) Client VM (build 1.4.2-p7-mark_07_may_2005_14_30, mixed mode) > Third, what user are you starting up as? Are you logging in as a > member of the wheel group and su'ing into root, or running from the > console as root? > I'm logging in remotely (the box is in a server room a few hours drive away) and su'ing to root. I'm then doing the "./ant run-install" as root. Thanks again, Mark |
|
|
Java(TM) 2 Runtime Environment, Standard Edition (build
1.4.2-p7-mark_07_may_2005_14_30) need SDK but I doubt that will fix this problem. Mark Thomas sent the following on 8/3/2006 3:39 PM: > Walter Vaughan wrote: > >> Mark Thomas wrote: >> >>> I have tried installing ofBiz on freeBSD 4.11, but it hangs during >>> startup. >> >> >> First, the only testing I have done with Apache OFBiz is on a 6.1 box. >> What's the hardware like on your box? FreeBSD 4.11 will run in >> character mode just fine with just 32 Meg of memory, which from my >> limited POV will not run ofBiz at all. Also, threads have been >> drastically improved with current 5 and 6 series so it may behoove you >> to pick up a cheap box for testing with 1 gig memory and work with >> enough memory for ofBiz to do its thing (Note: FreeBSD 6 will also run >> on 32 meg memory, my point is that you may be running out of resources) > > Thanks for the ideas there, I hadn't thought about resources being the > problem. The box is an HP Netserver, Pentium III, 1.2Gb with 1gb of > RAM, so I would have thought it had enough grunt. > > My 'top' looks like this after the OFBiz has been running and hanging > for a few minutes : > > last pid: 31168; load averages: 0.00, 0.04, 0.04 up 3+20:33:48 > 08:33:34 > 96 processes: 1 running, 95 sleeping > CPU states: 0.0% user, 0.0% nice, 0.0% system, 0.0% interrupt, 100% > idle > Mem: 213M Active, 604M Inact, 109M Wired, 42M Cache, 112M Buf, 36M Free > Swap: 2032M Total, 132K Used, 2032M Free > > PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND > 31168 root 28 0 2036K 1020K RUN 0:00 1.92% 0.63% top > 298 root 2 0 4936K 3832K select 36:03 0.00% 0.00% snmpd > 258 mysql 2 0 289M 20228K poll 2:14 0.00% 0.00% mysqld > 143 root -6 0 872K 296K piperd 0:23 0.00% 0.00% > readproctitle > 30150 root 2 0 580M 73596K poll 0:23 0.00% 0.00% java > 29853 root 2 0 218M 22092K poll 0:16 0.00% 0.00% java > 142 root 10 0 924K 444K nanslp 0:08 0.00% 0.00% svscan > 350 uucp 2 0 968K 632K select 0:07 0.00% 0.00% upsd > 274 root 10 0 928K 436K nanslp 0:07 0.00% 0.00% svscan > 16412 zope 2 0 34868K 32968K poll 0:07 0.00% 0.00% python2.3 > 285 qmails 2 0 976K 544K select 0:06 0.00% 0.00% qmail-send > 153 root 2 0 14832K 6300K select 0:06 0.00% 0.00% httpd > 100 root 2 0 992K 624K select 0:05 0.00% 0.00% syslogd > 365 zope 2 0 6108K 4600K poll 0:04 0.00% 0.00% python2.3 > 294 qmaill -6 0 904K 444K piperd 0:04 0.00% 0.00% multilog > 112 root 2 0 2604K 1240K select 0:03 0.00% 0.00% sshd > 287 root 2 0 1308K 752K accept 0:03 0.00% 0.00% tcpserver > > The two java processes are the OFBiz processes - they do seem to be > taking a lot of memory there, perhaps that's the prob? > > > a 'vmstat' shows this : > procs memory page disks faults cpu > r b w avm fre flt re pi po fr sr am0 md0 in sy cs us > sy id > 2 11 0 1360368 76500 149 0 0 0 135 5 0 0 233 4333 57 3 > 1 96 > > >> >> Second, what Java SDK did you use? Native or Linux? Did you use the >> ports collection method to install? Mine looks like this: >> >> $ java -version >> java version "1.4.2-p8" >> Java(TM) 2 Runtime Environment, Standard Edition (build >> 1.4.2-p8-filepro_04_may_2006_11_30) >> Java HotSpot(TM) Client VM (build 1.4.2-p8-filepro_04_may_2006_11_30, >> mixed mode) >> > My Java should be ok, here's what I get : > java version "1.4.2-p7" > Java(TM) 2 Runtime Environment, Standard Edition (build > 1.4.2-p7-mark_07_may_2005_14_30) > Java HotSpot(TM) Client VM (build 1.4.2-p7-mark_07_may_2005_14_30, mixed > mode) > >> Third, what user are you starting up as? Are you logging in as a >> member of the wheel group and su'ing into root, or running from the >> console as root? >> > I'm logging in remotely (the box is in a server room a few hours drive > away) and su'ing to root. I'm then doing the "./ant run-install" as root. > > Thanks again, > Mark > > |
Re: ofbiz hangs during startup
|
|
I have JAVA_HOME pointed to /usr/local/jdk1.4.2, so I'm assuming the
development kit is available for OFBiz. Also, all the builds seemed to work, so I guess the SDK is being used. BJ Freeman wrote: > Java(TM) 2 Runtime Environment, Standard Edition (build > 1.4.2-p7-mark_07_may_2005_14_30) > > need SDK but I doubt that will fix this problem. > > Mark Thomas sent the following on 8/3/2006 3:39 PM: > >> Walter Vaughan wrote: >> >>> Mark Thomas wrote: >>> >>>> I have tried installing ofBiz on freeBSD 4.11, but it hangs during >>>> startup. >>> >>> >>> >>> First, the only testing I have done with Apache OFBiz is on a 6.1 box. >>> What's the hardware like on your box? FreeBSD 4.11 will run in >>> character mode just fine with just 32 Meg of memory, which from my >>> limited POV will not run ofBiz at all. Also, threads have been >>> drastically improved with current 5 and 6 series so it may behoove >>> you to pick up a cheap box for testing with 1 gig memory and work >>> with enough memory for ofBiz to do its thing (Note: FreeBSD 6 will >>> also run on 32 meg memory, my point is that you may be running out >>> of resources) >> >> >> Thanks for the ideas there, I hadn't thought about resources being >> the problem. The box is an HP Netserver, Pentium III, 1.2Gb with 1gb >> of RAM, so I would have thought it had enough grunt. >> >> My 'top' looks like this after the OFBiz has been running and hanging >> for a few minutes : >> >> last pid: 31168; load averages: 0.00, 0.04, 0.04 up >> 3+20:33:48 08:33:34 >> 96 processes: 1 running, 95 sleeping >> CPU states: 0.0% user, 0.0% nice, 0.0% system, 0.0% interrupt, >> 100% idle >> Mem: 213M Active, 604M Inact, 109M Wired, 42M Cache, 112M Buf, 36M Free >> Swap: 2032M Total, 132K Used, 2032M Free >> >> PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND >> 31168 root 28 0 2036K 1020K RUN 0:00 1.92% 0.63% top >> 298 root 2 0 4936K 3832K select 36:03 0.00% 0.00% snmpd >> 258 mysql 2 0 289M 20228K poll 2:14 0.00% 0.00% mysqld >> 143 root -6 0 872K 296K piperd 0:23 0.00% 0.00% >> readproctitle >> 30150 root 2 0 580M 73596K poll 0:23 0.00% 0.00% java >> 29853 root 2 0 218M 22092K poll 0:16 0.00% 0.00% java >> 142 root 10 0 924K 444K nanslp 0:08 0.00% 0.00% svscan >> 350 uucp 2 0 968K 632K select 0:07 0.00% 0.00% upsd >> 274 root 10 0 928K 436K nanslp 0:07 0.00% 0.00% svscan >> 16412 zope 2 0 34868K 32968K poll 0:07 0.00% 0.00% >> python2.3 >> 285 qmails 2 0 976K 544K select 0:06 0.00% 0.00% >> qmail-send >> 153 root 2 0 14832K 6300K select 0:06 0.00% 0.00% httpd >> 100 root 2 0 992K 624K select 0:05 0.00% 0.00% syslogd >> 365 zope 2 0 6108K 4600K poll 0:04 0.00% 0.00% >> python2.3 >> 294 qmaill -6 0 904K 444K piperd 0:04 0.00% 0.00% multilog >> 112 root 2 0 2604K 1240K select 0:03 0.00% 0.00% sshd >> 287 root 2 0 1308K 752K accept 0:03 0.00% 0.00% >> tcpserver >> >> The two java processes are the OFBiz processes - they do seem to be >> taking a lot of memory there, perhaps that's the prob? >> >> >> a 'vmstat' shows this : >> procs memory page disks faults cpu >> r b w avm fre flt re pi po fr sr am0 md0 in sy cs >> us sy id >> 2 11 0 1360368 76500 149 0 0 0 135 5 0 0 233 4333 57 >> 3 1 96 >> >> >>> >>> Second, what Java SDK did you use? Native or Linux? Did you use the >>> ports collection method to install? Mine looks like this: >>> >>> $ java -version >>> java version "1.4.2-p8" >>> Java(TM) 2 Runtime Environment, Standard Edition (build >>> 1.4.2-p8-filepro_04_may_2006_11_30) >>> Java HotSpot(TM) Client VM (build >>> 1.4.2-p8-filepro_04_may_2006_11_30, mixed mode) >>> >> My Java should be ok, here's what I get : >> java version "1.4.2-p7" >> Java(TM) 2 Runtime Environment, Standard Edition (build >> 1.4.2-p7-mark_07_may_2005_14_30) >> Java HotSpot(TM) Client VM (build 1.4.2-p7-mark_07_may_2005_14_30, >> mixed mode) >> >>> Third, what user are you starting up as? Are you logging in as a >>> member of the wheel group and su'ing into root, or running from the >>> console as root? >>> >> I'm logging in remotely (the box is in a server room a few hours >> drive away) and su'ing to root. I'm then doing the "./ant >> run-install" as root. >> >> Thanks again, >> Mark >> >> > > |
|
|
the last suggestion I have is to make the debug verbose and see if you
are getting anything that would indicate what is happening. Mark Thomas sent the following on 8/3/2006 10:21 PM: > I have JAVA_HOME pointed to /usr/local/jdk1.4.2, so I'm assuming the > development kit is available for OFBiz. Also, all the builds seemed to > work, so I guess the SDK is being used. > > > BJ Freeman wrote: > >> Java(TM) 2 Runtime Environment, Standard Edition (build >> 1.4.2-p7-mark_07_may_2005_14_30) >> >> need SDK but I doubt that will fix this problem. >> >> Mark Thomas sent the following on 8/3/2006 3:39 PM: >> >>> Walter Vaughan wrote: >>> >>>> Mark Thomas wrote: >>>> >>>>> I have tried installing ofBiz on freeBSD 4.11, but it hangs during >>>>> startup. >>>> >>>> >>>> >>>> First, the only testing I have done with Apache OFBiz is on a 6.1 box. >>>> What's the hardware like on your box? FreeBSD 4.11 will run in >>>> character mode just fine with just 32 Meg of memory, which from my >>>> limited POV will not run ofBiz at all. Also, threads have been >>>> drastically improved with current 5 and 6 series so it may behoove >>>> you to pick up a cheap box for testing with 1 gig memory and work >>>> with enough memory for ofBiz to do its thing (Note: FreeBSD 6 will >>>> also run on 32 meg memory, my point is that you may be running out >>>> of resources) >>> >>> >>> Thanks for the ideas there, I hadn't thought about resources being >>> the problem. The box is an HP Netserver, Pentium III, 1.2Gb with 1gb >>> of RAM, so I would have thought it had enough grunt. >>> >>> My 'top' looks like this after the OFBiz has been running and hanging >>> for a few minutes : >>> >>> last pid: 31168; load averages: 0.00, 0.04, 0.04 up >>> 3+20:33:48 08:33:34 >>> 96 processes: 1 running, 95 sleeping >>> CPU states: 0.0% user, 0.0% nice, 0.0% system, 0.0% interrupt, >>> 100% idle >>> Mem: 213M Active, 604M Inact, 109M Wired, 42M Cache, 112M Buf, 36M Free >>> Swap: 2032M Total, 132K Used, 2032M Free >>> >>> PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND >>> 31168 root 28 0 2036K 1020K RUN 0:00 1.92% 0.63% top >>> 298 root 2 0 4936K 3832K select 36:03 0.00% 0.00% snmpd >>> 258 mysql 2 0 289M 20228K poll 2:14 0.00% 0.00% mysqld >>> 143 root -6 0 872K 296K piperd 0:23 0.00% 0.00% >>> readproctitle >>> 30150 root 2 0 580M 73596K poll 0:23 0.00% 0.00% java >>> 29853 root 2 0 218M 22092K poll 0:16 0.00% 0.00% java >>> 142 root 10 0 924K 444K nanslp 0:08 0.00% 0.00% svscan >>> 350 uucp 2 0 968K 632K select 0:07 0.00% 0.00% upsd >>> 274 root 10 0 928K 436K nanslp 0:07 0.00% 0.00% svscan >>> 16412 zope 2 0 34868K 32968K poll 0:07 0.00% 0.00% >>> python2.3 >>> 285 qmails 2 0 976K 544K select 0:06 0.00% 0.00% >>> qmail-send >>> 153 root 2 0 14832K 6300K select 0:06 0.00% 0.00% httpd >>> 100 root 2 0 992K 624K select 0:05 0.00% 0.00% syslogd >>> 365 zope 2 0 6108K 4600K poll 0:04 0.00% 0.00% >>> python2.3 >>> 294 qmaill -6 0 904K 444K piperd 0:04 0.00% 0.00% multilog >>> 112 root 2 0 2604K 1240K select 0:03 0.00% 0.00% sshd >>> 287 root 2 0 1308K 752K accept 0:03 0.00% 0.00% >>> tcpserver >>> >>> The two java processes are the OFBiz processes - they do seem to be >>> taking a lot of memory there, perhaps that's the prob? >>> >>> >>> a 'vmstat' shows this : >>> procs memory page disks faults cpu >>> r b w avm fre flt re pi po fr sr am0 md0 in sy cs >>> us sy id >>> 2 11 0 1360368 76500 149 0 0 0 135 5 0 0 233 4333 57 >>> 3 1 96 >>> >>> >>>> >>>> Second, what Java SDK did you use? Native or Linux? Did you use the >>>> ports collection method to install? Mine looks like this: >>>> >>>> $ java -version >>>> java version "1.4.2-p8" >>>> Java(TM) 2 Runtime Environment, Standard Edition (build >>>> 1.4.2-p8-filepro_04_may_2006_11_30) >>>> Java HotSpot(TM) Client VM (build >>>> 1.4.2-p8-filepro_04_may_2006_11_30, mixed mode) >>>> >>> My Java should be ok, here's what I get : >>> java version "1.4.2-p7" >>> Java(TM) 2 Runtime Environment, Standard Edition (build >>> 1.4.2-p7-mark_07_may_2005_14_30) >>> Java HotSpot(TM) Client VM (build 1.4.2-p7-mark_07_may_2005_14_30, >>> mixed mode) >>> >>>> Third, what user are you starting up as? Are you logging in as a >>>> member of the wheel group and su'ing into root, or running from the >>>> console as root? >>>> >>> I'm logging in remotely (the box is in a server room a few hours >>> drive away) and su'ing to root. I'm then doing the "./ant >>> run-install" as root. >>> >>> Thanks again, >>> Mark >>> >>> >> >> > > |
Re: ofbiz hangs during startup
|
|
In reply to this post by Mark Thomas-10
Mark Thomas wrote:
>>>> Mark Thomas wrote: >>>>> I have tried installing ofBiz on freeBSD 4.11, but it hangs during >>>>> startup. Okay I don't have anything new to help you other than showing than you could update everything to current and Apache OFBiz still works on FreeBSD. Our test server was running FreeBSD 6.0 instead of 6.1 like I had thought, and it was running jdk-1.4.2p8_3. So to monkey things up since I am wanting to experiment with Bizgres as a datastore, I need to run jdk-1.5 level, so here's what I did this morning... I updated the ports collection and did a portupgrade -aR I did a binary update from 6.0 to 6.1 using recipe at http://www.daemonology.net/freebsd-upgrade-6.0-to-6.1/ There was no really good automatic upgrade path from 4.* which sucks for you. Best practice is a reformat, however the machine that I'm talking about started out life as a 4.10-beta box, and has been upgraded continually without reformatting so it's still formatted UFS (Pre 5.*) instead of the modern UFS2 disk format. rebooted installed JDK5 from freeBSD foundation site at http://www.freebsdfoundation.org/downloads/java.shtml removed (pkg_delete) apache-ant-1.6.5_1 jdk-1.4.2p8_3 junit-3.8.2 log4j-1.2.13 mysql-connector-java-5.0.3 Reinstalled via ports collection and not binary packages apache-ant junit log4j mysql-connector-java Ran ant run-install in ofbiz directory ./startofbiz.sh and everything "seems" to work. I am connecting to mysql-server-5.0.22, rather than the default Java dbms, which is where you are hanging, and I have apache running ofbiz directly via mod_jk, but that should not be an issue. Why don't you install mysql-5.X and follow the directions at http://www.opentaps.org/index.php?option=com_content&task=view&id=37&Itemid=62 Or see if your hosting company will upgrade you to FreeBSD 6.1? -- Walter |
Re: ofbiz hangs during startup
|
|
Thanks very much for all that info Walter, it looks like an upgrade of
freeBSD is the way to go. I'll attempt that when I can, and get back with my own feedback then (our baby boy was born on the weekend, so it could be a little while before I get to it now. :-) ). Cheers, Mark Walter Vaughan wrote: > Mark Thomas wrote: > >>>>> Mark Thomas wrote: >>>>> >>>>>> I have tried installing ofBiz on freeBSD 4.11, but it hangs >>>>>> during startup. >>>>> > > Okay I don't have anything new to help you other than showing than you > could update everything to current and Apache OFBiz still works on > FreeBSD. > > Our test server was running FreeBSD 6.0 instead of 6.1 like I had > thought, and it was running jdk-1.4.2p8_3. > > So to monkey things up since I am wanting to experiment with Bizgres > as a datastore, I need to run jdk-1.5 level, so here's what I did this > morning... > > I updated the ports collection and did a portupgrade -aR > > I did a binary update from 6.0 to 6.1 using recipe at > http://www.daemonology.net/freebsd-upgrade-6.0-to-6.1/ > There was no really good automatic upgrade path from 4.* which sucks > for you. > Best practice is a reformat, however the machine that I'm talking > about started out life as a 4.10-beta box, and has been upgraded > continually without reformatting so it's still formatted UFS (Pre 5.*) > instead of the modern UFS2 disk format. > > rebooted > > installed JDK5 from freeBSD foundation site at > http://www.freebsdfoundation.org/downloads/java.shtml > > removed (pkg_delete) > apache-ant-1.6.5_1 > jdk-1.4.2p8_3 > junit-3.8.2 > log4j-1.2.13 > mysql-connector-java-5.0.3 > > Reinstalled via ports collection and not binary packages > apache-ant > junit > log4j > mysql-connector-java > > Ran ant run-install in ofbiz directory > > ./startofbiz.sh and everything "seems" to work. I am connecting to > mysql-server-5.0.22, rather than the default Java dbms, which is where > you are hanging, and I have apache running ofbiz directly via mod_jk, > but that should not be an issue. > > Why don't you install mysql-5.X and follow the directions at > http://www.opentaps.org/index.php?option=com_content&task=view&id=37&Itemid=62 > > > Or see if your hosting company will upgrade you to FreeBSD 6.1? > > -- > Walter > > |
|
|
Congrats Mark - don't worry 'bout that upgrade for a while.
-- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 Mark Thomas wrote: > Thanks very much for all that info Walter, it looks like an upgrade of > freeBSD is the way to go. I'll attempt that when I can, and get back > with my own feedback then (our baby boy was born on the weekend, so it > could be a little while before I get to it now. :-) ). > > Cheers, > Mark > > > Walter Vaughan wrote: > >> Mark Thomas wrote: >> >>>>>> Mark Thomas wrote: >>>>>> >>>>>>> I have tried installing ofBiz on freeBSD 4.11, but it hangs >>>>>>> during startup. >>>>>> >> >> Okay I don't have anything new to help you other than showing than >> you could update everything to current and Apache OFBiz still works >> on FreeBSD. >> >> Our test server was running FreeBSD 6.0 instead of 6.1 like I had >> thought, and it was running jdk-1.4.2p8_3. >> >> So to monkey things up since I am wanting to experiment with Bizgres >> as a datastore, I need to run jdk-1.5 level, so here's what I did >> this morning... >> >> I updated the ports collection and did a portupgrade -aR >> >> I did a binary update from 6.0 to 6.1 using recipe at >> http://www.daemonology.net/freebsd-upgrade-6.0-to-6.1/ >> There was no really good automatic upgrade path from 4.* which sucks >> for you. >> Best practice is a reformat, however the machine that I'm talking >> about started out life as a 4.10-beta box, and has been upgraded >> continually without reformatting so it's still formatted UFS (Pre >> 5.*) instead of the modern UFS2 disk format. >> >> rebooted >> >> installed JDK5 from freeBSD foundation site at >> http://www.freebsdfoundation.org/downloads/java.shtml >> >> removed (pkg_delete) >> apache-ant-1.6.5_1 >> jdk-1.4.2p8_3 >> junit-3.8.2 >> log4j-1.2.13 >> mysql-connector-java-5.0.3 >> >> Reinstalled via ports collection and not binary packages >> apache-ant >> junit >> log4j >> mysql-connector-java >> >> Ran ant run-install in ofbiz directory >> >> ./startofbiz.sh and everything "seems" to work. I am connecting to >> mysql-server-5.0.22, rather than the default Java dbms, which is where >> you are hanging, and I have apache running ofbiz directly via mod_jk, >> but that should not be an issue. >> >> Why don't you install mysql-5.X and follow the directions at >> http://www.opentaps.org/index.php?option=com_content&task=view&id=37&Itemid=62 >> >> >> Or see if your hosting company will upgrade you to FreeBSD 6.1? >> >> -- >> Walter >> >> |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |