Previous Thread
Next Thread
Print Thread
Hop To
#227417 06/29/2009 6:55 PM
Joined: Jun 2008
Posts: 32
newbie
newbie
Joined: Jun 2008
Posts: 32
Got a lot of help here last month while trying to move to a new host- thanks again everyone.

Today is the second time in the last 6 weeks that I have received this type of page when checking the board.

[Linked Image from livc.net]

[Linked Image from livc.net]

The error either resolves itself (?) or the webhost is fixing something on receipt of my support ticket(s).

From webhost:
Quote
We have restarted mysql service in the server and it is running fine now.

I'd like to understand whats going on so I have the control to fix it myself if possible- any suggestions
Thanks



Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Not sure about the first message.
But the second one looks like it is reporting that the table need to be repaired.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
Pooh-Bah
Joined: Jul 2006
Posts: 2,143
The first one says the MySQL server ran out of memory. The second says that the server has gone away. That means crashed.

The first one seems to indicate that it needs but doesn't have an OMG! amount of memory for the query. The query that it mentions is the one that gets the moderators list. That's only 13 forums. No idea how large the membership is, your URL is not in your profile.

The second says the server has crashed. Your server's MYSQL error log will contain any information available on that.


This thread for sale. Click here! [Linked Image from navaho.infopop.cc]
Joined: Jun 2008
Posts: 32
newbie
newbie
Joined: Jun 2008
Posts: 32
The forum is at: http://www.livc.net/ubbthreads/
(Updated my profile, thanks)

It seems to be running fine now.
Can I prevent this from happening again?
Thanks

Joined: Jun 2008
Posts: 32
newbie
newbie
Joined: Jun 2008
Posts: 32
Once again this morning:
Quote
UBB Message
We encountered a problem. The reason reported was
Script: /home/livc/public_html/ubbthreads/libs/functions_forums.inc.php
Line#: 109
SQL Error: Out of memory (Needed 16775224 bytes)
SQL Error #: 5
Query: SELECT ONLINE_BROWSING_FORUM, COUNT(*) AS COUNT, ONLINE_USER_TYPE FROM ubbt_ONLINE WHERE ONLINE_LAST_ACTIVITY > 1246362339 GROUP BY ONLINE_BROWSING_FORUM, ONLINE_USER_TYPE

Please click back to return to the previous page.
What's out of memory and how do I resolve it?
Is there a setting in the UBB control panel or is this an issue for my web host to resolve?
If its for the web host, what should I direct them to do?
Thanks

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
For some reason it would appear that your ONLINE table isn't being purged often enough. It looks like it's possibly around 16 megs in size, which even on an extremely busy board it shouldn't grow that big.

I'd run 2 queries. First see how many rows are actually in the table with this:

SQL Query
select count(*) from ubbt_ONLINE

Then purge everything in the table

SQL Query
delete from ubbt_ONLINE

Joined: Jul 2006
Posts: 2,143
Pooh-Bah
Pooh-Bah
Joined: Jul 2006
Posts: 2,143
I'd ask the host why the server is running out of memory at only 13 megabytes. That's really not a lot of memory but the server is saying OMG! NO! and dying.

13 megs? I mean, my cell phone has more than that, and it's old.


This thread for sale. Click here! [Linked Image from navaho.infopop.cc]
Joined: Jun 2008
Posts: 32
newbie
newbie
Joined: Jun 2008
Posts: 32
From the web host:
Quote
The problem was caused due to mysql memory shortage. We have now fixed the problem. The site is working fine now.
Please verify the screenshot of the site attached below. Also Mysql service is up and working fine. We are monitoring the mysql service to check if any further problem occurs.
Whatever they did the board seems to be running smoothly now. Thanks for the help.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 744 guests, and 147 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)