Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
6 registered (Bjab, Gizmo, nims2, Ruben, Mike L, Dunny), 29 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 04/22/10
Posts: 5
Top Posters (30 Days)
Ruben 64
SD 54
Gizmo 48
gliderdad 33
Dunny 21
driv 18
Iann128 16
dbremer 16
Stan 15
Mark S 13
Latest Photos
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Gizzo Marx
Topic Options
#227417 - 06/29/09 06:55 PM Error messages at new host
maria Offline
newbie
Registered: 06/23/08
Posts: 30
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
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#227418 - 06/29/09 07:31 PM Re: Error messages at new host [Re: maria]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4268
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.
_________________________
Blue Man Group
Top
#227420 - 06/29/09 07:52 PM Re: Error messages at new host [Re: Ruben]
David Dreezer Offline

Pooh-Bah
Registered: 07/21/06
Posts: 2199
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!
Top
#227423 - 06/29/09 09:10 PM Re: Error messages at new host [Re: David Dreezer]
maria Offline
newbie
Registered: 06/23/08
Posts: 30
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 07:50 AM Re: Error messages at new host [Re: maria]
maria Offline
newbie
Registered: 06/23/08
Posts: 30
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 08:13 AM Re: Error messages at new host [Re: maria]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
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
Top
#227466 - 07/01/09 08:21 PM Re: Error messages at new host [Re: Rick]
David Dreezer Offline

Pooh-Bah
Registered: 07/21/06
Posts: 2199
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!
Top
#227501 - 07/05/09 10:58 AM Re: Error messages at new host [Re: David Dreezer]
maria Offline
newbie
Registered: 06/23/08
Posts: 30
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, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Edit Post
by Bert
01:19 PM
A positive note
by SteveS
09:36 PM
How to locate links to particular site if they are only used in images?
by Conrad
02/10/12 09:41 PM
Pictures not displaying
by Marker23
02/09/12 10:04 PM
Issue with logging out constantly
by Flanuva
02/09/12 07:05 PM
Forum Stats
10213 Members
36 Forums
33667 Topics
180917 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image