Previous Thread
Next Thread
Print Thread
Hop To
Joined: Oct 2007
Posts: 464
Likes: 11
Addict
Addict
Joined: Oct 2007
Posts: 464
Likes: 11
We got the following error (see attached screenshot) this morning, and no pages of the forum were accessible. Whatever the problem was, it resolved on its own. Uncaught mysqli_sql_exception: the table 'sbf_ONLINE' is full. (We have debugging enabled at this time.)

No idea what could have caused this.

This is the table information at this time.
Code
sbf_ONLINE	MEMORY	443	15.61 MB	402.56 KB	utf8mb4_general_ci
Attachments
Report snapshot sent by fellow Bolter Waveski - early morning 10-23-2024 (failed attempt to access the Stovebolt Main Forum Page).jpg.jpeg


The Stovebolt Geek
https://www.stovebolt.com/ubbthreads/ubbthreads.php

Server Information
UBB.threads Version 8.0.0
Release 20240826
Server OS Linux
Server Load 0.11
Web Server Apache/2.4.37
PHP Version 8.3.11
MYSQL Version 8.0.39
Database Size 1.82 GB
Joined: Jun 2006
Posts: 16,365
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,365
Likes: 126
That is extremely strange, the first part of the altertable portion of the v8 upgrade utility was supposed to convert the two memory tables (ubbt_ONLINE and ubbt_TOPIC_VIEWS) to a standard MyISAM table from a MEMORY/HEAP table.

The initial fix in ~v7.1 was to make this high resource table exist only in MEMORY so that it wasn't constantly writing to the disk, but now adays this isn't needed as SSD disks are common and the speed improvement isn't really happening anymore. You can read more in the in a support page here.

You have two choices, either convert the table to a MyISAM table in PHPMyAdmin (I believe under operations) or empty the table and leave it as a MEMORY type.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Oct 2007
Posts: 464
Likes: 11
Addict
Addict
Joined: Oct 2007
Posts: 464
Likes: 11
convert to MySAIM or MyISAM?


The Stovebolt Geek
https://www.stovebolt.com/ubbthreads/ubbthreads.php

Server Information
UBB.threads Version 8.0.0
Release 20240826
Server OS Linux
Server Load 0.11
Web Server Apache/2.4.37
PHP Version 8.3.11
MYSQL Version 8.0.39
Database Size 1.82 GB
Joined: Jun 2006
Posts: 16,365
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,365
Likes: 126
MyISAM will be the only one of those to display in the "Storage Engine" dropdown, under Operations, in PHPMyAdmin


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Oct 2007
Posts: 464
Likes: 11
Addict
Addict
Joined: Oct 2007
Posts: 464
Likes: 11
Thank you. I converted both tables to MyISAM.


The Stovebolt Geek
https://www.stovebolt.com/ubbthreads/ubbthreads.php

Server Information
UBB.threads Version 8.0.0
Release 20240826
Server OS Linux
Server Load 0.11
Web Server Apache/2.4.37
PHP Version 8.3.11
MYSQL Version 8.0.39
Database Size 1.82 GB

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Post Counts zeroed out
by Baldeagle - 11/03/2024 3:05 PM
Upgraded to ver8 - now can't login
by phoenix011235 - 10/24/2024 7:50 AM
Very weird error this morning.
by Baldeagle - 10/23/2024 4:35 PM
Help error and stop forum spam
by ehill - 10/23/2024 11:13 AM
Very slow web server response times
by Baldeagle - 10/18/2024 3:22 PM
Who's Online Now
1 members (Ruben), 353 guests, and 53 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.1
(Snapshot build 20240918)