homepage Welcome to WebmasterWorld Guest from 54.211.73.232
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Table giving some strange error
xeye

10+ Year Member



 
Msg#: 73 posted 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#: 73 posted 8:14 pm on Oct 9, 2005 (gmt 0)

First.. what kind of DBMS are you using?

xeye

10+ Year Member



 
Msg#: 73 posted 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#: 73 posted 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.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved