Store Manager processes and Memory Time outs

10 Oct 2009, 21:33

#1

Zen Follower

Join Date:: Aug 2006
Posts:: 252
Plugin Contributions:: 0

Store Manager processes and Memory Time outs - Any workaround?

1.3.8a all security updates.

I’m on a shared server on Dreamhost and sometime back I was getting server errors when trying to run the Reset Master Category ID in Store Manager. After a lot of back and forth and noting that my store was not a big one (about 5,000 items) they adjusted for that one process so I can run it again.

However, I still could not run things like Google sitemap and when I noticed (:blush: for the first time!) that the price sort wasn’t working for new items I tried to run the Update Price Sorter and got similar time out related errors. The process was killed by the server essentially as it was for the master ID.

My question is, is there anyway to do any/all of the Store Manager procedures via the SQL database itself or some other method?

Thanks for reading!

10 Oct 2009, 22:30

#2

jeffey

Zen Follower

Join Date:: Aug 2006
Posts:: 252
Plugin Contributions:: 0

Re: Store Manager processes and Memory Time outs - Any workaround?

Mmm, seems to only be a couple of categories I recently added to and looking at past, but recent, updates most of those seem ok so maybe it will sort itself out?

Still interested in what can be done outside of the Admin. if anyone knows.

10 Oct 2009, 22:36

#3

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Store Manager processes and Memory Time outs - Any workaround?

Edit the file:
/admin/store_manager.php

around line 25 is:
zen_set_time_limit(600);

Set that to 900 ... does it work? If not, how about 1200?

How many categories do you have?

Do you use Specials? Sales? Attributes? Price by Attributes?

10 Oct 2009, 22:49

#4

jeffey

Zen Follower

Join Date:: Aug 2006
Posts:: 252
Plugin Contributions:: 0

Re: Store Manager processes and Memory Time outs - Any workaround?

Thanks!

I got/get different responses with each try but these are typical (along with page not found).

900:

Fatal error: Out of memory (allocated 16777216) (tried to allocate 75 bytes) in /home/SITE/includes/classes/db/mysql/query_factory.php on line 246

1200:

0
in:
[select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call from products where products_id = '11790' limit 1]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

1500:

Fatal error: Out of memory (allocated 16777216) (tried to allocate 512 bytes) in /home/SITE/includes/classes/db/mysql/query_factory.php on line 248

About 285 Categories/subcategories.

All items have a sale price. Product price update works from Store Manager though I think the host may have made an exception with that particular process. It was a back and forth discussion and frankly all I can remember is it started to work again (could also have been a DB issue with restart to fix).

Very few attributes. Only a handful.

10 Oct 2009, 23:08

#5

jeffey

Zen Follower

Join Date:: Aug 2006
Posts:: 252
Plugin Contributions:: 0

Re: Store Manager processes and Memory Time outs - Any workaround?

Another 1500 resulted in:

2008 MySQL client ran out of memory
in:
[select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included from products_attributes where products_id = '11787' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, price_prefix, options_values_price]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

10 Oct 2009, 23:25

#6

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Store Manager processes and Memory Time outs - Any workaround?

You really appear to be on a server with memory limitations ...

Sale Maker does add a lot to what has to be done on the calculations, but I would not think it would be that sever ...

Without actually trying your database on another server ...

What happens if you turn off the Sales?

11 Oct 2009, 00:06

#7

jeffey

Zen Follower

Join Date:: Aug 2006
Posts:: 252
Plugin Contributions:: 0

Re: Store Manager processes and Memory Time outs - Any workaround?

Thanks for the help.

Yeah, silly too for a host that provides a one click install of Zen and this store is not large by any means. Things work on a smaller store on the same host but ridiculous to break on 6,000 items. Used to work until they "upgraded".

Turning off sales isn't an option.

I already do my metas via SQL query and trying the same with price sorter but must have the update command wrong.

Could you suggest the query to simply update the price sorter based on the product_id?

Sorry for the newbie one, I usually just update and insert and not sure why update isn't working - just get "failed" with no information. I've tried a couple of formats already.

11 Oct 2009, 00:33

#8

jeffey

Zen Follower

Join Date:: Aug 2006
Posts:: 252
Plugin Contributions:: 0

Re: Store Manager processes and Memory Time outs - Any workaround?

Got it, must have typed wrong:

UPDATE products
SET products_price_sorter=65
WHERE products_id=15017

Will that work or do I need to do something else?

11 Oct 2009, 00:44

#9

jeffey

Zen Follower

Join Date:: Aug 2006
Posts:: 252
Plugin Contributions:: 0

Re: Store Manager processes and Memory Time outs - Any workaround?

Ooops, only one at a time?

Scratch that and "Duh!", needed to end each with ; and not ,

11 Oct 2009, 01:06

#10

jeffey

Zen Follower

Join Date:: Aug 2006
Posts:: 252
Plugin Contributions:: 0

Re: Store Manager processes and Memory Time outs - Any workaround?

Thanks again for the time, always appreciate it.

Ok, seems to work but do let me know if anything else needs to be done/updated.

My updates are getting pretty intensive!
I'm lucky to have an legacy offline database but had to do similar steps to create scripts for metas, google maps & base and now price sorting! Of course easy populate too (thanks for that at least! :D though I have to stop that one but it populates before it craps out).

Dread the idea but have to move eventually, kind of waiting on the new version as it sounds like it might help.

11 Oct 2009, 03:02

#11

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Store Manager processes and Memory Time outs - Any workaround?

I would not wait ... I'd get a hosting provider that can handle your site ... and your site is not that huge ...

Perhaps one of our Certified Hosts can help you out ... talk to them as they can generally do the move for you ... :smile:

11 Oct 2009, 03:25

#12

jeffey

Zen Follower

Join Date:: Aug 2006
Posts:: 252
Plugin Contributions:: 0

Re: Store Manager processes and Memory Time outs - Any workaround?

I know your right and I've looked around a couple of times but dread the switch/move.

Fortunately things work, albeit with some workarounds from time to time.

It is nice to know that most will do it for you as you cross your fingers but still need to have my head straight for a potential all-nighter which I thankfully haven't had in a while with Zen (and haven't wanted!).

I also end up not quite knowing what levels of service to get since my host doesn't provide enough information for me to make an informed decision and I do have some other potential sites in the works that may effect my needs.

One of these days I'll have to do the final step and have already looked at the Zen approved list and basically narrowed it to one but then didn't find their site to look very professional and that's all I needed to put it off!

Is that enough excuses? Just let me know, I got a million of them!!

Thanks again for your help and sound advice.

11 Oct 2009, 04:18

#13

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Store Manager processes and Memory Time outs - Any workaround?

As a start you could ask your host to increase the PHP memory_limit higher than the default 16 MB to something more functional like 64 MB.
You *might* even be able to do it with a customized php.ini file in your /admin/ folder. There are various references to that at www.php.net

11 Oct 2009, 04:35

#14

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Store Manager processes and Memory Time outs - Any workaround?

I just played with a database with
categories: 548
products: 8,452
products_options: 204
products_options_values: 1,498
products_attributes: 123,137

No problems with the Update Products Price Sorter ...

Added a bunch o Sales with Sale Maker and re-ran the Products Price Sorter ... still no problems ...

Again, without your exact database to test ... I can just tell you what I can test with this large database and nothing is dying ... so, definitely time to go shopping if your current hosting provider cannot resolve this issue the right way ... :lamo:

11 Oct 2009, 04:46

#15

jeffey

Zen Follower

Join Date:: Aug 2006
Posts:: 252
Plugin Contributions:: 0

Re: Store Manager processes and Memory Time outs - Any workaround?

Thanks for the additional hints Dr.! Always good to see you.

I certainly agree it's stingy.

Unfortunately, many including myself have asked and apparently you have to do a custom install of PHP so that you can have access to your php.ini. They wont adjust their install and you can't edit the php.ini.

It's a procedure I don't think I want to do and they make it clear you wont get any support.....which I need!

To be fair, I'm not paying a whole hell of a lot for the service and for the most part I've been happy. Occasional bumps just started the last year or so when they changed servers.

11 Oct 2009, 04:53

#16

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Store Manager processes and Memory Time outs - Any workaround?

Just to be fair ... the server that I am testing on has the memory limit 32M

just so you know it is higher than your server is allow, but not as high as I like, yet, good enough ... :cool:

11 Oct 2009, 04:57

#17

jeffey

Zen Follower

Join Date:: Aug 2006
Posts:: 252
Plugin Contributions:: 0

Re: Store Manager processes and Memory Time outs - Any workaround?

Yeah Linda, I've seen tests you've done for others which told me my product count should not be a big factor. Thanks for that.

Also yeah, I think 32M is a bare minimum these days given what people are using.