I'm beginning to wonder if I am under attack. Second total crash related to the database in two days. The other mySQL database in my account has also stopped again.

We encountered a problem. The reason reported was

Script: /data/4/0/138/114/301929/user/306957/htdocs/forum/libs/ubbthreads.inc.php
Line#: 2095
SQL Error: Got error 127 from storage engine
SQL Error #: 1030
Query: select USER_ID,CACHED_PERMISSION_DATA from ubbt_CACHED_PERMISSIONS where USER_ID = 4

Please use your back button to return to the previous page.

Here is the repair from the ubbt_cached_permisisons table:

ubbwireless.ubbt_CACHED_PERMISSIONS repair warning Duplicate key for record at 16180 against record a...
ubbwireless.ubbt_CACHED_PERMISSIONS repair warning Duplicate key for record at 55012 against record a...
ubbwireless.ubbt_CACHED_PERMISSIONS repair warning Duplicate key for record at 42068 against record a...
ubbwireless.ubbt_CACHED_PERMISSIONS repair warning Number of rows changed from 20 to 17
ubbwireless.ubbt_CACHED_PERMISSIONS repair status OK

The second database issued these warnings when the affected table was repaired:

shipdata.shipinfo repair warning Duplicate key for record at 1496 against record at...
shipdata.shipinfo repair warning Duplicate key for record at 1612 against record at...
shipdata.shipinfo repair warning Duplicate key for record at 1072 against record at...
shipdata.shipinfo repair warning Duplicate key for record at 976 against record at ...
shipdata.shipinfo repair warning Duplicate key for record at 796 against record at ...
shipdata.shipinfo repair warning Number of rows changed from 17 to 12
shipdata.shipinfo repair status OK

Here's what I'm thinking. This started about a week after I started using a database application that added data from two Internet sources. Two IP's send strings of data to a PHP application and the data is stored then displayed on a Google Map when a website user visits the page. Could the database be under to heavy a load with the BB and this second BB in use at the same time? There is also the WordPress blog.

My UBB appears to be back on the air after the table repair. I went less than 24 hors since the last one. My users and I have also seen occasional server errors and slow performance at Network Solutions in the last few days.

oops it was now I get this:

We encountered a problem. The reason reported was

Script: /data/4/0/138/114/301929/user/306957/htdocs/forum/libs/ubbthreads.inc.php
Line#: 2179
SQL Error: Can't open file: 'ubbt_USERS.MYI' (errno: 145)
SQL Error #: 1016
Query: select t2.USER_TIME_OFFSET,t2.USER_TOPIC_VIEW_TYPE,t2.USER_TIME_FORMAT,t1.USER_DISPLAY_NAME,t1.USER_PASSWORD,t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t2.USER_TOTAL_PM, t1.USER_ID, t1.USER_IS_BANNED,t1.USER_IS_UNDERAGE, t2.USER_STYLE,t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN,t2.USER_LANGUAGE,t2.USER_MOOD,t2.USER_RELATIVE_TIME from ubbt_USERS AS t1, ubbt_USER_PROFILE as t2 where t1.USER_ID = 4 and t1.USER_ID = t2.USER_ID

Please use your back button to return to the previous page.

Table Op Msg_type Msg_text
ubbwireless.ubbt_USERS repair status OK

This time the second smaller database did not have a corrupt table. Hmmm. I have my BB turn off at the moment.

If someone had it in for a user or me or some content he didn't like could he attack the BB in a way that would repeatedly;y shut it down? Naw, I'm paranoid. Perhaps the database is large enough to need maintenance? Yesterday I had 191,267 rows, 113.47 MB in one table and 58.78 MB in another.

Database/table corruption can be caused by a variety of things, including hardware problems, the mysql server crashing or being shut down unexpectedly, and various others.

Since it looks like you had multiple tables crashed this would commonly point to the mysql server unexpectedly being shutdown. Not sure what type of server you have or if you have access to information on how long the server and/or mysql has been running. If the server or mysql have only been running for a few hours (since about the time of the crashed tables) then that could be the case.

The CACHED_PERMISSIONS table is a fairly active table so that one is more apt to corrupt. The USERS table isn't as active, normally only changing when a new user is added, someone logs in, etc.

Any idea what version of mysql you are currently using?

We encountered a problem. The reason reported was

Script:
Line#:
SQL Error: Lost connection to MySQL server during query
Please verify that your MySQL server is running
SQL Error #: 2013
Query: Unable to connect to the database!

Please use your back button to return to the previous page.

This last one happened when I tried to send a reply to a message and was still in the myPHP admin screen for the database. I exited the myPHP screen and the message went through.