Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (SD, Gizmo), 24 Guests and 10 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/07/06
Posts: 365
Top Posters (30 Days)
Ruben 122
SD 89
Gizmo 65
gliderdad 33
Dunny 31
Mark S 27
Iann128 19
driv 18
dbremer 16
Steve C 15
Latest Photos
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Gizzo Marx
Page 1 of 3 1 2 3 >
Topic Options
#194600 - 08/18/07 11:03 AM My UBB Has crashed again. Dead in the water.
PopWireless Offline
journeyman
Registered: 04/05/07
Posts: 59
Loc: Huntingtown, MD
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.
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."
#194601 - 08/18/07 11:06 AM Re: My UBB Has crashed again. Dead in the water. [Re: PopWireless]
PopWireless Offline
journeyman
Registered: 04/05/07
Posts: 59
Loc: Huntingtown, MD
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
Top
#194602 - 08/18/07 11:10 AM Re: My UBB Has crashed again. Dead in the water. [Re: PopWireless]
PopWireless Offline
journeyman
Registered: 04/05/07
Posts: 59
Loc: Huntingtown, MD
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
Top
#194603 - 08/18/07 11:12 AM Re: My UBB Has crashed again. Dead in the water. [Re: PopWireless]
PopWireless Offline
journeyman
Registered: 04/05/07
Posts: 59
Loc: Huntingtown, MD
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.
Top
#194604 - 08/18/07 11:14 AM Re: My UBB Has crashed again. Dead in the water. [Re: PopWireless]
PopWireless Offline
journeyman
Registered: 04/05/07
Posts: 59
Loc: Huntingtown, MD
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.
Top
#194605 - 08/18/07 11:16 AM Re: My UBB Has crashed again. Dead in the water. [Re: PopWireless]
PopWireless Offline
journeyman
Registered: 04/05/07
Posts: 59
Loc: Huntingtown, MD
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.
Top
#194606 - 08/18/07 11:24 AM Re: My UBB Has crashed again. Dead in the water. [Re: PopWireless]
PopWireless Offline
journeyman
Registered: 04/05/07
Posts: 59
Loc: Huntingtown, MD
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.
Top
#194607 - 08/18/07 11:30 AM Re: My UBB Has crashed again. Dead in the water. [Re: PopWireless]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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?
Top
#194608 - 08/18/07 11:37 AM Re: My UBB Has crashed again. Dead in the water. [Re: PopWireless]
PopWireless Offline
journeyman
Registered: 04/05/07
Posts: 59
Loc: Huntingtown, MD
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.
Top
#194609 - 08/18/07 11:40 AM Re: My UBB Has crashed again. Dead in the water. [Re: PopWireless]
PopWireless Offline
journeyman
Registered: 04/05/07
Posts: 59
Loc: Huntingtown, MD
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.
Top
Page 1 of 3 1 2 3 >



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

Today's Birthdays
No Birthdays
Recent Topics
Tools for comparing two db schemas?
by cascadeclimbers
06:31 PM
Moderator notification issue
by Flanuva
02/02/12 11:22 AM
how do I regain control of my HACKED site?
by VaGunTrader
01/28/12 11:00 PM
PayPal Error Message
by Outdoorking
01/28/12 07:16 AM
Top posters format
by dbremer
01/25/12 05:00 PM
Forum Stats
10190 Members
36 Forums
33654 Topics
180824 Posts

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