RE: error please help

2015-11-24 Thread Shahzad Riaz
reminder From: Shahzad Riaz [mailto:shahzadr...@um.com.pk] Sent: Thursday, November 12, 2015 4:16 PM To: 'd...@ofbiz.apache.org' Cc: 'user@ofbiz.apache.org' Subject: error please help Hello I am trying to install but get the following error. Please help D:\test\apache-ofbiz-13.07.02>"

AW: error please help

2015-11-24 Thread Ingo Wolfmayr
Have you tried D:\test\apache-ofbiz-13.07.02>ant build D:\test\apache-ofbiz-13.07.02>ant load-demo D:\test\apache-ofbiz-13.07.02>ant start -Ursprüngliche Nachricht- Von: Shahzad Riaz [mailto:shahzadr...@um.com.pk] Gesendet: ienstag, 24. November 2015 08:21 An: d...@ofbiz.apache.org Cc: us

Re: OFBiz demos all down

2015-11-24 Thread Jacques Le Roux
BTW they had to power cycle the VM, so it was really "fucked up" indeed, crossing fingers... Jacques Le 24/11/2015 16:33, Jacques Le Roux a écrit : This time, as said someone of the infra team "the issue is the underlying host looks fucked." All demos are now restarting, sorry for the delay

VISIT and VISITOR Entities

2015-11-24 Thread Len Shein
All, We have a LIVE application in which the VISIT AND VISITOR entities have grown to over 19 and 18 million rows respectively. Has anyone experienced any performance issues when these entities have grown to such capacity? We recently had a performance issue and decided to turn off the visit

Re: OFBiz demos all down

2015-11-24 Thread Jacques Le Roux
This time, as said someone of the infra team "the issue is the underlying host looks fucked." All demos are now restarting, sorry for the delay Jacques Le 18/11/2015 11:30, Jacques Le Roux a écrit : FYI: We got another old demo (R12.04) crash yesterday. So it seems Java 8 is not the issue. I'l

Re: VISIT and VISITOR Entities

2015-11-24 Thread Adrian Crum
Did the setting change improve performance? You could write a service that deletes data older than xxx days, then make it a scheduled job. Adrian Crum Sandglass Software www.sandglass-software.com On 11/24/2015 7:48 AM, Len Shein wrote: All, We have a LIVE application in which the VISIT AN

RE: VISIT and VISITOR Entities

2015-11-24 Thread Nick Rosser
Thanks Mike -- don't think this is a cache issue -- at least not OFBiz cache since it is not showing up in the OFBiz Cache maintenance page. Nick -Original Message- From: Mike [mailto:mz4whee...@gmail.com] Sent: Tuesday, November 24, 2015 11:31 AM To: user Subject: Re: VISIT and VISITO

Re: VISIT and VISITOR Entities

2015-11-24 Thread Mike
Most likely this table is stealing cache memory from the rest of the tables. Either increase cache memory, delete the rows, write to a separate database, or keep the table trim to xxx rows (as Adrian said) via an internal ofbiz job or external script (via crontab). On Tue, Nov 24, 2015 at 7:48 AM

RE: VISIT and VISITOR Entities

2015-11-24 Thread Nick Rosser
Adrian, Not entirely sure if it made a difference -- site was going down every now and again, initially we thought that some scheduled jobs were the culprit (since outages were in or around the scheduled job time). However, we had problems yesterday when no scheduled jobs were running (we disab

Re: VISIT and VISITOR Entities

2015-11-24 Thread Adrian Crum
Hmmm... it could be the job scheduler. It was refactored a few years ago to fix problems like that. Try C&Ping R13 job scheduler into R10 (framework\service\src\org\ofbiz\service\job). Adrian Crum Sandglass Software www.sandglass-software.com On 11/24/2015 8:29 AM, Nick Rosser wrote: Adrian

RE: VISIT and VISITOR Entities

2015-11-24 Thread Nick Rosser
Thanks Adrian -- we'll take a look at the latest version. Maybe a complete red herring -- but a couple of weeks ago our client requested that we change the password for the primary "admin" user. We deleted and re-added main scheduled jobs but we've had problems since ... Nick -Original Me

Re: VISIT and VISITOR Entities

2015-11-24 Thread Mike
> at least not OFBiz cache since I didn't mean the ofbiz cache. I meant the database (mysql/postgres) cache settings. On Tue, Nov 24, 2015 at 8:34 AM, Nick Rosser wrote: > Thanks Mike -- don't think this is a cache issue -- at least not OFBiz > cache since it is not showing up in the OFBiz Cac

RE: VISIT and VISITOR Entities

2015-11-24 Thread Nick Rosser
Got it, thanks Mike. Nick -Original Message- From: Mike [mailto:mz4whee...@gmail.com] Sent: Tuesday, November 24, 2015 12:23 PM To: user Subject: Re: VISIT and VISITOR Entities > at least not OFBiz cache since I didn't mean the ofbiz cache. I meant the database (mysql/postgres) cache

Re: OFBiz demos all down

2015-11-24 Thread Taher Alkhateeb
Hi Jacques, So does this now exclude Java 8? Taher Alkhateeb On Tue, Nov 24, 2015 at 6:33 PM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > This time, as said someone of the infra team "the issue is the underlying > host looks fucked." > > All demos are now restarting, sorry for the

Re: OFBiz demos all down

2015-11-24 Thread Jacques Le Roux
Sincerely I have no sure ideas, I tried to look at the OFBiz and system logs but found anything. But I believe Java 8 is not part of the problem indeed, because the same appears with Java 7. Could be that the machine really needed a power restart, let's see... Jacques Le 24/11/2015 19:00, Tahe

Re: VISIT and VISITOR Entities

2015-11-24 Thread Jacques Le Roux
That's why using another DB, as suggested Mike ("write to a separate database"), could be a good test... Jacques Le 24/11/2015 18:23, Nick Rosser a écrit : Got it, thanks Mike. Nick -Original Message- From: Mike [mailto:mz4whee...@gmail.com] Sent: Tuesday, November 24, 2015 12:23 PM

Re: VISIT and VISITOR Entities

2015-11-24 Thread Mike
For mysql, there is tuning_primer.sh: https://launchpad.net/mysql-tuning-primer For postgresql, there is pgtune: http://pgfoundry.org/projects/pgtune Most folks just use yum/apt-get to get pgtune: apt-get install pgtune --or-- yum install pgtune Although neither are perfect, both utilities atte