Welcome to WebmasterWorld Guest from 54.144.68.27

Forum Moderators: open

Message Too Old, No Replies

Table giving some strange error

     

xeye

3:46 pm on Oct 8, 2005 (gmt 0)



i am facing a very strange problem with a table in my site that holds the record of bids. when my table statistics come the following
-----------------
Space usage:
Type Usage
Data 65,516 Bytes
Index 1,024 Bytes
Total 66,540 Bytes
-----------

Row Statistics:
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 570
Row length 114
Row size 117 Bytes
Creation May 01, 2005 at 08:55 PM
Last update Oct 08, 2005 at 07:53 AM
Last check Oct 07, 2005 at 06:28 PM
-----------------

then it stops working and when user place bids so it doesnt take more date and gives the following error

the table TABLE NAME is full

and my customer cant place bid....
pls help me why is so happening i never put any check on my tables size and there is enough space left for my database then why is this happening and please note that when i remove some rows from the tb then it again start working .......

curiously waiting for ur response.

R e b r a n d t

8:14 pm on Oct 9, 2005 (gmt 0)



First.. what kind of DBMS are you using?

xeye

12:03 am on Oct 10, 2005 (gmt 0)



i am using MySQL DB,
--> lastnight i executed Table Repair and Table Optimize queries and after sometime table started working again.... then after five hours it again corrupted and now giving the same error again i.e TABLE IS FULL...and now i executed the same two queries again but this time its not working,,,

i suspect its something from HOST, their server goes down and my table is corrupted,,,do u agree?

R e b r a n d t

6:18 am on Oct 10, 2005 (gmt 0)
 

Featured Threads

Hot Threads This Week

Hot Threads This Month