Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util sda 0.00 142.000.00 57.00 0.00 1592.0027.93 1.31 22.93 3.51 20.00 It normally comes when I hit anything. On Fri, Jun 22, 2012 at 2:42 AM, Deepak Agarwa

Re: Ofbiz with MySQL or PostgreSQL

2012-06-21 Thread Brett Palmer
Sanjeev, We've used MySQL for several years now. I think most ofbiz user prefer Postgres. We like Postgres but the one feature that keeps us with MySQL is its replication feature. Replication in MySQL is very good and easy to administer. We use them for running reports which helps us scale our

Re: Deal product / promotion for a time period with counddown timer

2012-06-21 Thread Robert G.
k got it... found the related class "PriceServices" -- View this message in context: http://ofbiz.135035.n4.nabble.com/Deal-product-promotion-for-a-time-period-with-counddown-timer-tp4633849p4633908.html Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Ofbiz with MySQL or PostgreSQL

2012-06-21 Thread Sanjeev Gupta
Thanks Ruth. I've also been told that the demo data upload in Postgres takes half as time as MySQL - so I'm guessing that the production env performance should also be better with Postgres. - Rgds Sanjeev www.sanjeevg.com @sanjeevgcom -- View this message in context: http://ofbiz.135035.n4.n

Re: Has anyone implemented Faceted Search using SOLR?

2012-06-21 Thread Rajbir Saini
Hello Sanjeev, What is that did not work? I will be happy to help if you can share the problems you had faced. Regards, Raj On Friday 22 June 2012 12:10 AM, Sanjeev Gupta wrote: Hi Rajbir, I spent a couple of days trying to play around with the approach you recommended but couldn't get it t

Re: Deal product / promotion for a time period with counddown timer

2012-06-21 Thread Robert G.
do someone know, how I can check on productdetail site (ecommerce) if a ProductPriceCond entity exists for this product id? and than find the From and thrudate, that I can create the countdown timer? would be great, thanks -- View this message in context: http://ofbiz.135035.n4.nabble.com/Deal

Re: Deal product / promotion for a time period with counddown timer

2012-06-21 Thread Robert G.
ok, this I got now...in documentation I read: * .2.3.11.3.3 IMPORTANT: Price rules will only be run if an item has a List Price associated with it.* Dont know understand why, but ok it works :) Robert G. wrote > > btw. I tried to define a price rule for a product, but I cannot see the > price

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
Ok. Thanks. I will do that and paste the results here tomorrow. On Fri, Jun 22, 2012 at 2:31 AM, Mike wrote: > If you run "iostat -x 5", for about 1 minute, what is the "%util" value? > > On Thu, Jun 21, 2012 at 1:53 PM, Deepak Agarwal >wrote: > > > Will run it again. Had done it before getting

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Mike
If you run "iostat -x 5", for about 1 minute, what is the "%util" value? On Thu, Jun 21, 2012 at 1:53 PM, Deepak Agarwal wrote: > Will run it again. Had done it before getting load on mysql. > > On Fri, Jun 22, 2012 at 2:22 AM, Deepak Agarwal >wrote: > > > Yes. All set. > > > > > > On Fri, Jun 2

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
Will run it again. Had done it before getting load on mysql. On Fri, Jun 22, 2012 at 2:22 AM, Deepak Agarwal wrote: > Yes. All set. > > > On Fri, Jun 22, 2012 at 2:21 AM, Mike wrote: > >> Have you tried the mysql tuning primer script? >> >> https://launchpad.net/mysql-tuning-primer >> >> Downloa

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
Yes. All set. On Fri, Jun 22, 2012 at 2:21 AM, Mike wrote: > Have you tried the mysql tuning primer script? > > https://launchpad.net/mysql-tuning-primer > > Download, execute, and double any recommendations. > > > On Thu, Jun 21, 2012 at 1:06 PM, Deepak Agarwal >wrote: > > > Latest mysql with

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Mike
Have you tried the mysql tuning primer script? https://launchpad.net/mysql-tuning-primer Download, execute, and double any recommendations. On Thu, Jun 21, 2012 at 1:06 PM, Deepak Agarwal wrote: > Latest mysql with timestamp truncation problem. > > On Fri, Jun 22, 2012 at 1:31 AM, Deepak Agarw

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
Latest mysql with timestamp truncation problem. On Fri, Jun 22, 2012 at 1:31 AM, Deepak Agarwal wrote: > mysql latest version. > > > On Fri, Jun 22, 2012 at 1:18 AM, Mike wrote: > >> Postgresql/mysql? >> >> On Thu, Jun 21, 2012 at 12:04 PM, Deepak Agarwal > >wrote: >> >> > I actually did that. B

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
mysql latest version. On Fri, Jun 22, 2012 at 1:18 AM, Mike wrote: > Postgresql/mysql? > > On Thu, Jun 21, 2012 at 12:04 PM, Deepak Agarwal >wrote: > > > I actually did that. But, now I am facing issue while quickly > > removing/adding items from/to shopping cart. May be I need to look > databa

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Mike
Postgresql/mysql? On Thu, Jun 21, 2012 at 12:04 PM, Deepak Agarwal wrote: > I actually did that. But, now I am facing issue while quickly > removing/adding items from/to shopping cart. May be I need to look database > closely. > > On Thu, Jun 21, 2012 at 11:32 PM, Mike wrote: > > > Here is what

Re: Ofbiz with MySQL or PostgreSQL

2012-06-21 Thread Ruth Hoffman
Hi Sanjeev: If you use MySQL in its current state, be aware of Timestamp truncation. Since OFBiz uses timestamps in many places as part of a primary-key, you can (and do) loose precision and ultimately you may not be able to find records. You may not even know this is happening until it is too

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
I actually did that. But, now I am facing issue while quickly removing/adding items from/to shopping cart. May be I need to look database closely. On Thu, Jun 21, 2012 at 11:32 PM, Mike wrote: > Here is what I would do: > > Update framework/webapp/config/serverstats.properties > > stats.persist.

Ofbiz with MySQL or PostgreSQL

2012-06-21 Thread Sanjeev Gupta
I'm looking to decide on the database to be used with OfBiz in the production environment. Any thoughts on which database works well with Ofbiz - MySQL or PostgreSQL and why ? - Rgds Sanjeev www.sanjeevg.com @sanjeevgcom -- View this message in context: http://ofbiz.135035.n4.nabble.com/Ofbiz

Re: Has anyone implemented Faceted Search using SOLR?

2012-06-21 Thread Sanjeev Gupta
Hi Rajbir, I spent a couple of days trying to play around with the approach you recommended but couldn't get it to work for me. So finally gave it up. Will probably wait for someone to contribute the feature to the trunk. - Rgds Sanjeev www.sanjeevg.com @sanjeevgcom -- View this message

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Mike
Here is what I would do: Update framework/webapp/config/serverstats.properties stats.persist.visit=false stats.persist.visitor=false I have ALL of the 'stats' set to 'false'. Restart ofbiz, and blow away the contents of server_hit and optionally visit: delete from server_hit; delete from visit

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
visit: 7400 server_hit: 94000 communication_event: 51 On Thu, Jun 21, 2012 at 10:44 PM, Mike wrote: > Take a look at visit, server_hit, and communication_event tables. > > select count(*) from visit; > select count(*) from server_hit; > select count(*) from communication_event; > > What do yo ge

Re: Extract parameters from external call

2012-06-21 Thread bhargav.tri
Thanks for the reply Raj. I was under the same impression and I was not able to fetch the parameters using getparameter. But I was able to retrieve them using the Utility class (UtilHttp). That was helpful. Thank you, Bhargav -- View this message in context: http://ofbiz.135035.n4.nabble.co

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Mike
Take a look at visit, server_hit, and communication_event tables. select count(*) from visit; select count(*) from server_hit; select count(*) from communication_event; What do yo get? On Thu, Jun 21, 2012 at 9:02 AM, Deepak Agarwal wrote: > Alright. I will try this. However, Basically database

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Adrian Crum
That might have been true for JRE 1.4, but newer versions have multi-generation garbage collectors that seldom cause program pauses. It sounds to me like there is a problem in the connection pool or in the database itself. -Adrian On 6/21/2012 4:52 PM, Mike wrote: Sounds like classic garbag

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
Alright. I will try this. However, Basically database queries are timing out. I checked from 'Show processlist' command and I can see the queries are stuck. On Thu, Jun 21, 2012 at 9:22 PM, Mike wrote: > Sounds like classic garbage collection. Java freezes while it sifts > through memory lookin

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Mike
Sounds like classic garbage collection. Java freezes while it sifts through memory looking for stuff to delete. The larger the memory, the longer it takes. -Xms2048M -Xmx2048M -server -Xincgc Try the above. The -Xincgc will continuously GC on a separate, slow running thread. Also, run a separ

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
Memory and CPU remain good. memory hardly reaches 1 GB and cpu few percentage. On Thu, Jun 21, 2012 at 9:14 PM, Mike wrote: > What does the "Memory Total" line say on the "WebToosl/Cache Maintenance" > menu? > > On Thu, Jun 21, 2012 at 8:38 AM, Deepak Agarwal >wrote: > > > -Xms2048M -Xmx2048M -

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Mike
What does the "Memory Total" line say on the "WebToosl/Cache Maintenance" menu? On Thu, Jun 21, 2012 at 8:38 AM, Deepak Agarwal wrote: > -Xms2048M -Xmx2048M -XX:MaxPermSize=1024m -server > > On Thu, Jun 21, 2012 at 9:03 PM, Mike wrote: > > > What are the java memory settings for starting OFBiz?

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
-Xms2048M -Xmx2048M -XX:MaxPermSize=1024m -server On Thu, Jun 21, 2012 at 9:03 PM, Mike wrote: > What are the java memory settings for starting OFBiz? Mine: > > JAVA_VMOPTIONS="-Xms1280M -Xmx1524M -server -Xincgc" > > > > On Thu, Jun 21, 2012 at 8:14 AM, Deepak Agarwal >wrote: > > > We are exp

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Mike
What are the java memory settings for starting OFBiz? Mine: JAVA_VMOPTIONS="-Xms1280M -Xmx1524M -server -Xincgc" On Thu, Jun 21, 2012 at 8:14 AM, Deepak Agarwal wrote: > We are expereicing frequent table locks for Shipping table , visit and > server_hit table. Even with 3-4 users working we a

Ilscipio - still hiring

2012-06-21 Thread Paul Piper
Hello guys, A few months ago we asked for OFBiz experts to join our small but growing eCommerce Agency team. Fortunately today we’re again in the position to hire additional team members. So we are on the lookout for new developers for permanent employment and freelancers as well to meet the t

Re: How to include ftl from another module using a variable?

2012-06-21 Thread Atul Vani
Try this <#include StringUtil.wrapString(myTemplate)> Thanks& Regards Atul Vani Enterprise Software Developer HotWax Media Pvt. Ltd. http://www.hotwaxmedia.com/ We are the Global Leaders in Apache OFBiz, Google 'ofbiz' and see for yourself. On 06/21/2012 01:28 AM, Colin Rooney wrote: hint: lo

Re: Deal product / promotion for a time period with counddown timer

2012-06-21 Thread Robert G.
btw. I tried to define a price rule for a product, but I cannot see the price change in my webstore. I use Euro currency, but I also try to applie this rule to the currency and the product, still the standard price visible. Do you know anything about that? Thanks :) -- View this message in cont

Re: Apachecon EU 2012

2012-06-21 Thread Christian Geisert
Pierre Smits schrieb: > Dear All, > > ApacheCON EU 2012 will be held in Sinsheim , Germany on November, 5th till > 9th. > > I was wondering if there intentions to participate and/or hold some > presentations or get-togethers. As I'm living less than 100 km away from the location I'll be there (i