Re: Users - JOB _SANDBOX

Posted by Andrew Dupa on
URL: http://ofbiz.116.s1.nabble.com/Users-JOB-SANDBOX-tp137182p137185.html

I'll stick to the facts -

 

1st problem

Webtools admin screen around scheduled jobs doesn not work due to the large amount of data in the database. to get around this probem how I would like to delete the old un-used records. i would like to understand or hear form someone who has this problem before how to best go about it. I don't want to guess about what records to delete, if someone can give me a definitive answer than great.

 

2nd problem

I have scheduled jobs that are failing but are reschedlued to run later, they have no hope of runing sucessfully so I would like to cancel/stop/delete them. again I can't do this thru the admin screen in webtools because it doens't work (because there's a lot of records in the database) if someone could tell me how to stop the scheduled jobs, i.e. not stop important ones but just the ones i identify as problem jobs I would appreciate that. remember the admin tools provided don't work because of the large amount of data in the database. So I can log in to the databse and do it thru SQL if someone can describe the data model or what to look for.

 

I was hoping this was a known problem that someone could provide a known fix for.

 

 

 

 

 

On 2/1/06, David E. Jones <[hidden email]> wrote:

Andrew,

That's enough. This is totally inappropriate and does not help you or
anyone. This sort of direct personal attack on someone who is trying
to help in the spirit of a community effort is simply not acceptable
in an open source community. If this is how you get along in your day
job fine, but don't bring it here.

I'll encourage everyone to give you the benefit of the doubt because
it's late and you may be going through caffeine withdrawals or
something.

While there have been some rough threads on this mailing list this
sort of direct insult is pretty much a first. We have never kicked
anyone off the list, but if this continues I'll personally call for a
vote.

As for this question: I have no idea what you are asking anymore, so
please start over. Trying to pick it out of the ranting is difficult.

-David


On Feb 1, 2006, at 9:58 PM, Andrew Dupa wrote:

> Oh but you're not the voice of reason and you like David failed to
> read first before replying. You just look like an idiot now
>
> Sure David gave me an answer but it wasn't helpful, not even close
> if you understand what it is i was actually asking. read it again.
>
> SO what if you are runnign with "semi-production" site with 110,000
> products?? So am I except mine really is production. wtf has that
> got to do with 25,000 JOB_SANDBOX record when you hit webtools? Do
> you have this and can you hit webtools job scheduler?
>
> I know why they are failing and the best soltuoin is to kil them
> from trying again except and I repeat the admin tools around this
> don't work when JOB_SANBOX is above 20K records. Want me to say it
> again? I think next you'll tell me that it's possible to delete

> records form a database wow really??!!! You genius you
>
> You're an idiot...I'll persist because someone smart out there must
> understand what it is I'm asking and realise that the Webtools code
> in 3.0 is such a pile of crap it can't handle 25,000 records....so
> how do i fix this problem by purging the data no longer required?
>
> sorry just used to working a professional team of senior java devs
> here in seattle who develop real world products....if they posted
> an answer like you they'd be a laughing stock
>
>
>
>
>
> On 2/1/06, Chris Howe <[hidden email]> wrote: Andrew,
>
> Not to be the voice of reason in your frustration, but
> David answered precisely what you actually asked.  It
> may not have been the answer you wanted, if that's the
> case, you didn't ask the question that you wanted
> either.
>
> 25,000 records isn't really that much.  We're running
> a semi-production site that has 115,000 products and
> about 10 catalogs, so there are some tables that have
> close to a half million records running on 640 MB RAM
> of a desktop box.  I'm not saying it's the world's
> smoothest ride in the world...But I can access
> webtools and follow the advice that David gave to your
> question.  But then again, I'm using recent SVN
> instead of 3.0.  That's more of your problem than
> anything though.  I'm sure it would be very difficult
> for you to update to something written in the last 2
> years though as the two projects barely resemble each
> other (4721 revisions since 3.0.0).  Since there are
> only about 4 or 5 regular people on this list that
> have even installed 3.0.0, much less have written code
> toward it you may want to be a bit more patient as to
> not alienate them if you're needing help.
>
> If you're worried about the failed jobs rescheduling,
> try finding why the jobs are failing and fix that or
> supress them from rerunning, then you won't have to
> worry about "clean up routines".  Since most of that
> is written in java you'd have to stop the system
> anyway, so why not just stop the system and use
> another database manager to trim the fat?
>
> But, this reply has even less of a point than David's
> so please, flame away.
>
>
> ==========Andrew wrote:
>
> David,
>
> Thanks for your response but the problem is the
> WebTools app doesn't work
> when you have 25,000+ records. Not even on a 2gig
> machine with all the
> memory dedicated to the Java app running ofbiz....!!!!
>
> Hence my question in the first place.
>
> I know I can remove records from the database....I was
> asking if anyone else
> run into this problem and could they please help me to

> understand the data
> model so I may intelligently delete from a live
> system. What issues are
> there? etc....please c'mon..
>
> I'm trying very hard not to be rude and please take
> the following with a

> grain of salt as I'm very frustrated here. Honestly
> your response was
> pointless....I know you're one of the main
> contributors but if you have
> nothing to contribute to my questions please don't
> respond. I'm not a
> complete idiot. I was asking for help, not the
> obvious.
>
> I understand that the Webtools area of the application
> may have improved in
> the latest version, I vcertainly hope it didn't get
> worse. Here's my growing
> concern from reading the list that maybe Ofbiz is lost
> in it's own never
> ending development cycle. What about real world
> scenarios and users who have
> current live systems. arrrgghh...
>
> Come on please..
> Andrew.
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users