homepage Welcome to WebmasterWorld Guest from 184.73.52.98
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Table giving some strange error
xeye




msg:1580664
 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




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

First.. what kind of DBMS are you using?

xeye




msg:1580666
 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




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

[dev.mysql.com...]

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved