|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
That is quite complicated.
All I am looking for is the command line/info specific to this particular table, which you could look up for me in your own database for this particular table.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
Ian,
I hope you can help me here as I see you are online.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
Thank you Ian for the command line information, which I am also placing here, just in case somebody else has this type of problem.
create table %%TABLE_PREFIX%%TOPIC_VIEWS (
TOPIC_ID int(11) unsigned not null,
index topic_ndx (TOPIC_ID)
)
|
|
|
|
Joined: Jun 2006
Posts: 16,302 Likes: 116
|
Joined: Jun 2006
Posts: 16,302 Likes: 116 |
CREATE TABLE `ubbt_TOPIC_VIEWS` (
`TOPIC_ID` int(11) unsigned NOT NULL default '0',
KEY `topic_ndx` (`TOPIC_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Here ya go. We'll just go ahead and create this as a heap table as 7.1 will do which should stop the corruption:
create table ubbt_TOPIC_VIEWS ( TOPIC_ID int(11) unsigned not null, index topic_ndx (TOPIC_ID) ) TYPE=heap
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I forgot to edit the table into that quote, therefore, thank you for correcting that oversight. I will also now do the alter command and see what happens.
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
Sorry to leave you hanging Daryl. I was on my way out when I replied to some of your requests.
Glad to see it looks like you've got it back under control again.
Rick is this something to do with PHP coding? It's not normal for a table to get corrupted especially on modern hardware.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
It was the third time for me in regards to a corrupted table, and the same corrupted table at that.
I am now in "heap" mode, therefore, we will see how that goes.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Corruption can happen to tables that are updated frequently. Since every update requires a write to the table, sometimes tables can become corrupted especially on slower hard drives. The TOPIC_VIEWS table is updated every time someone views a topic so it is an extremely active table.
Since this table only stores temporary data, we can convert it to a heap table so it doesn't write it to disk, it just stores it in memory, which should stop the corruption.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I am still having the problem from last evening, therefore, I thought I would place it here as it seems to be related somewhat. The ubbt_POSTS table isn't working. My server provider tried repairing it, but received this error: [quote] [root@squishee maritime-sda-online_org_-_forums]# myisamchk -o ubbt_POSTS.MYI - recovering (with keycache) MyISAM-table 'ubbt_POSTS.MYI' Data records: 19460 myisamchk: error: Can't create new tempfile: 'ubbt_POSTS.TMD' MyISAM-table 'ubbt_POSTS.MYI' is not fixed because of errors Try fixing it by using the --safe-recover (-o) or the --force (-f) option
[root@squishee maritime-sda-online_org_-_forums]# myisamchk -f ubbt_POSTS.MYI Checking MyISAM file: ubbt_POSTS.MYI Data records: 19460 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed and last repair failed - check file-size myisamchk: warning: Size of indexfile is: 75627520 Should be: 17152000 myisamchk: error: Size of datafile is: 227115008 Should be: 227115096 - recovering (with keycache) MyISAM-table 'ubbt_POSTS.MYI' Data records: 19460 18000 Is this a temporary table that the delete from ubbt_POSTS command can be used followed by the repair table ubbt_POSTS command? From what I have read, it doesn't sound like a temporary table. What can be done next?
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
Is this something only Rick can answer?
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I will be gone for a few hours, but I will check back here and elsewhere after I return.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I tried the delete from command which gave a failed message pertaining to zero rows. I then tried the repair command that said: Can't create new tempfile: './maritime-sda-online_org_-_forums/ubbt_POSTS.TMD'
Operation failed It seems that they tried to do the same thing.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
What is really needed is a _forums/ubbt_POSTS.MYD file.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
From the database it is saying ubbt_POSTS in use, which is exactly what the ubbt_TOPIC_VIEWS used to say before it was altered to HEAP.
I sure do hope Rick will be on here soon as it has been over 24 hours since this happened.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
What would happen if I tried the following command?
create file ubbt_POSTS.MYD ???
Or is this even a valid command?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Talked with you via your PM, Daryl.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I also just now answered you there.
|
|
|
|
Test
by Phun - 05/28/2024 7:31 PM
|
|
0 members (),
441
guests, and
174
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|