Out of Memory Error - merged threads

[McTedo]

I am having problems with the Powweb install of OsCommerce on my client's site.

Every so often, all afternoon, I get error messages like:
5 - Out of memory (Needed 1677696 bytes)

select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name

[TEP STOP]

Simply refreshing the page resolves the problem.

I took this to be a temporary glitch, but after 6 hours, I've just got annoyed.

Any suggestions?

UPDATE:
This error is also occurring inside PHPMyAdmin:
"Error

SQL query: Edit

SHOW TABLE STATUS LIKE 'configuration';

MySQL said: Documentation
#5 - Out of memory (Needed 1676240 bytes) "

[Txbubba]

I have been getting random error messages like this one:

5 Out of memory (Needed 1372680 bytes)
in:
[select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = 1 and b.banners_id = bh.banners_id group by b.banners_id, b.expires_date, b.expires_impressions]
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.


and when I log into myphp, I get random errors like this one:

Error
SQL query:

SHOW TABLE STATUS LIKE 'banners_history';

MySQL said:

#5 - Out of memory (Needed 1676240 bytes)



They don't happen all the time and not always in the same place. Sometimes I hit refresh and it loads right up with no problems. This all just started today for whatever reason.

I am on Server: custsql-pow15

Any ideas? Am I the only one?

thanks!

[YvetteKuhns]

Log into phpmyadmin and check tables with overhead. Optimized and repair tables if necessary. Out of memory meant that mysql tried to allocate more memory than exists (in cache).

[YvetteKuhns]

I just posted in another out of memory error thread (http://forum.powweb.com/showthread.php?t=77270).

[Txbubba]

Log into phpmyadmin and check tables with overhead. Optimized and repair tables if necessary. Out of memory meant that mysql tried to allocate more memory than exists (in cache).

Tried that to no avail. Everything checked out fine. While I am in mysqladmin these these sort of errors generate as well.

[YvetteKuhns]

Try editing your php.ini file or your config file.

If sort_buffer_size = 128K, then try sort_buffer_size = 256K

[Txbubba]

Try editing your php.ini file or your config file.

If sort_buffer_size = 128K, then try sort_buffer_size = 256K

Forgive my ignorance, but where would I find that file? Thanks

[Txbubba]

Update from Customer Service:

Hello Jeff,


I am writing regarding your ticket #3527203.


We have increased the memory limit for scripts in your account. Now the site is loading fine without any errors. Please check this at your end. Now you should also be able to administer the database without any issues.

If you continue to experience the same issue, please feel free to contact us back.

[YvetteKuhns]

Wow! Support fixed it for you?!

[Txbubba]

Of course the error just ocurred again, so we are still working on it. :(

[Txbubba]

Try editing your php.ini file or your config file.

If sort_buffer_size = 128K, then try sort_buffer_size = 256K

According to mysqladmin, sort buffer size is set at 67,108,856.

[YvetteKuhns]

Of course the error just ocurred again, so we are still working on it.

Sorry (but not surprised) to hear that. I will be busy this weekend, but if a thought pops into my head, I will post it.

[kathylene]

Forgive my ignorance, but where would I find that file? Thanks

Did someone answer this, I did not see it. Where can we access our php.ini file to try and adjust the buffer size? I am getting the same error messages in MySQL

I did check MySQL Admin and it shows sort buffer size 67,108,856


Error
SQL query:

SHOW CHARACTER SET;

MySQL said:

#5 - Out of memory (Needed 1677360 bytes)

[snowmaker]

Where can we access our php.ini file..
Login to OPS, here, http://members.powweb.com/member/cgiManagement/PHPplus.bml

[fieroloki]

Im getting the same stuff on mine as well.. :(


SQL Error : 5 Out of memory (Needed 1677676 bytes)

SELECT u.user_id, u.username, u.user_session_time, u.user_session_page, s.session_logged_in, s.session_ip, s.session_start FROM phpbb_users u, phpbb_sessions s WHERE s.session_logged_in = 1 AND u.user_id = s.session_user_id AND u.user_id <> -1 AND s.session_time >= 1198087914 ORDER BY u.user_session_time DESC

[HalfaBee]

That option is a mysql setting not php.

The error is reported from MYSQL not PHP, it is basically just a overloaded mysql server issue.

[fieroloki]

Noting is working... just hit and miss all day.. on a chat with support now

[DebbieH]

This is happening to me as well. I spent 58 minutes on the phone with tech support only to get some BS answer about something being wrong on my end. If everyone is having these issues, it's obviously not something on our end. I'm back on the phone, so far 28 minutes and trying to do the live chat thing....no luck.

[iocean]

Yes, these exact same errors are occurring on my site and I haven't changed any code or settings recently. I can;t edit the database with mysqladmin and my online store pages generate the same error.

[DebbieH]

I did end up getting someone on the live chat thing, which was useless. She said they were working on it and it would be fixed shortly. It did come up finally but I still get that error message at random times. I wonder if they ever even look at these boards to see that others are having issues. I wish I had checked here before I let them give me some BS answer on the phone after an hour.

[fieroloki]

They had me get a screen shot of it and email in cause of course to them "it works fine", the only way I got them to send to tier 2 support was showing them this thread.. sheesh

[maniel]

Hi guys,
I've had the same problem with the 5 - Out of memory (Needed 1677696 bytes).
For those of you using shopping carts like OsCommerce this worked for me.

Want to Optimising your database? Looking for a good OPTIMIZE / REPAIR specific tables, databases, or servers? Here is a code that may help. Very easy to install. No files to change.

I take no credit for this contribution. I merely found it in osCommerce add ons trying to find ways to improve my site performance. Here is the link to the original file and article:-

http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html

This did help me but I am no expert, so please beware!!!!

Here is the address to the contribution: http://addons.oscommerce.com/info/4647

Simply to install one file only.