You are not logged in. [Log In] UBB.threads Community » Forums » UBB.threads 7 Discussion » General Assistance (How Do I?) » Error messages at new host
Register User    Portal Page     Forum List        Calendar     Active Topics     Search     FAQ
Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Affiliate Program
UBBDev.com
UBBSkins.com
Who's Online
5 registered (Ruben, Sirdude, Rick, Gizmo, 1 invisible), 18 Guests and 48 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 03/05/10
Posts: 2
Top Posters (30 Days)
Sirdude 90
Gizmo 74
Rick 62
Ruben 55
lightningrod 46
Chosen 26
Wisc.Tiger 24
Bad Frog 21
David Dreezer 21
SteveS 20
Latest Photos
Tower Speakers, everyone needs them!
Going old style
the Frog
My Tractor Design and Build Project
Tombstone AZ
Topic Options
Rate This Topic
#227417 - 06/29/09 03:55 PM Error messages at new host
maria Offline
newbie 		Registered: 06/23/08
Posts: 26
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.





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
Top
#227418 - 06/29/09 04:31 PM Re: Error messages at new host [Re: maria]
Ruben Online content
Registered: 12/20/03
Posts: 2605
Loc: Lutz,FL ***
Not sure about the first message.
But the second one looks like it is reporting that the table need to be repaired.
_________________________
I am not an expert.
I just use the stuff!
If you receive help here at least post back to let us know what the outcome is.
In case you did not know we are just users!
And don't forget, There is no such thing as stupid questions. Just stupid answers.
Top
#227420 - 06/29/09 04:52 PM Re: Error messages at new host [Re: Ruben]
David Dreezer Offline
Pooh-Bah 		Registered: 07/21/06
Posts: 2044 ****
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.
_________________________
Top
#227423 - 06/29/09 06:10 PM Re: Error messages at new host [Re: David Dreezer]
maria Offline
newbie 		Registered: 06/23/08
Posts: 26
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
Top
#227428 - 06/30/09 04:50 AM Re: Error messages at new host [Re: maria]
maria Offline
newbie 		Registered: 06/23/08
Posts: 26
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
Top
#227429 - 06/30/09 05:13 AM Re: Error messages at new host [Re: maria]
Rick Online happy

Registered: 06/04/06
Posts: 9477
Loc: Aberdeen, WA *****
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
_________________________
UBB.threads™ Developer
My Blog | Facebook Page | Twitter
Top
#227466 - 07/01/09 05:21 PM Re: Error messages at new host [Re: Rick]
David Dreezer Offline
Pooh-Bah 		Registered: 07/21/06
Posts: 2044 ****
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.
_________________________
Top
#227501 - 07/05/09 07:58 AM Re: Error messages at new host [Re: David Dreezer]
maria Offline
newbie 		Registered: 06/23/08
Posts: 26
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.
Top


Moderator:  AllenAyres, Gizmo, Harold, Ian, Ron M, Sirdude 
Shout Box

Facebook Page
Today's Birthdays
No Birthdays
Recent Topics
Where do I change the Forums Powered by UBB.Threads ?
by lightningrod
Yesterday at 08:46 AM
date problem
by ovarian cancer
03/17/10 10:12 PM
How do I add recaptcha to UBB threads 6.2?
by hvan
03/17/10 01:00 PM
donwoutdoors.com (Outdoors Forum)
by Hook them Lipps
03/16/10 07:25 PM
Put gallery at top of website
by Hook them Lipps
03/16/10 02:45 PM
Forum Stats
6816 Members
35 Forums
32481 Topics
170272 Posts

Max Online: 978 @ 06/24/07 08:19 PM
Random Image
Board Rules · Mark all read
Contact Us · UBBCentral · Top