[rt-users] Db errors

[Geert Theys]

I know the command repair:

Repair table sessions; 

But when I log into mysql I get following:

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'FM_ArticleCFValues'
Didn't find any fields in table 'FM_Articles'
Didn't find any fields in table 'FM_ClassCustomFields'
Didn't find any fields in table 'FM_Classes'
Didn't find any fields in table 'FM_CustomFieldValues'
Didn't find any fields in table 'FM_CustomFields'
Didn't find any fields in table 'FM_Transactions'


I try to:

mysql> repair table FM_ArticleCFValues;
+-------------------------+--------+----------+------------------------------------------------------+
| Table                   | Op     | Msg_type | Msg_text                                             |
+-------------------------+--------+----------+------------------------------------------------------+
| rtdb.FM_ArticleCFValues | repair | error    | Can't open file: 'FM_ArticleCFValues.ibd' (errno: 1) |
+-------------------------+--------+----------+------------------------------------------------------+
1 row in set (0.00 sec)



How to optimise the tables I don't know...

Regards,
Geert Theys.

> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com 
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf 
> Of Judson Main
> Sent: Friday, September 29, 2006 4:39 PM
> To: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] Db errors
> 
> Hmm.  Have you repaired and optimized the tables after the recovery?
> 
> my mysql, in the rt3 database use this command:  "show table status;"
> 
> Jud.
> 
> 
>  On Fri Sep 29  8:19 , 'Geert Theys' <gt at eu.pearldoc.net> sent:
> 
> >Hello,
> >
> >I have googled and looked around what the error means but I 
> can’t find a answer.
> >
> >I had a default debian Sarge RT 3.4 installation and my 
> server crashed. I recovered the mysql DB with a mysqldump. I 
> have installed a new debian machine and loaded de data into 
> the new machine. Everything seems to work ok apart from the 
> fact it is quite slow.
> >
> >So I checked /var/log/syslog and every second(even few times 
> during one second) I see following:
> >
> >Sep 29 13:04:59 localhost RT: DBD::mysql::st execute failed: 
> MySQL server has gone away at 
> /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 480.  
> (/usr/share/request-tracker3.4/lib/RT.pm:277)  
> >Sep 29 13:04:59 localhost RT: RT::Handle=HASH(0x8d58898) 
> couldn't execute the query 'SELECT main.* FROM Attributes 
> main   WHERE ((main.ObjectId = 609)) AND ((main.ObjectType = 
> 'RT::Ticket')) ' at 
> /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494.  
> (/usr/share/request-tracker3.4/lib/RT.pm:277)  
> >Sep 29 13:05:01 localhost /USR/SBIN/CRON[18281]: (rt) CMD (fetchmail 
> >-s) Sep 29 13:05:01 localhost RT: DBD::mysql::st execute 
> failed: MySQL 
> >server has gone away at 
> /usr/share/perl5/DBIx/SearchBuilder/Handle.pm 
> >line 480.  (/usr/share/request-tracker3.4/lib/RT.pm:277)
> >Sep 29 13:05:01 localhost RT: RT::Handle=HASH(0x8d58898) 
> >((main.ObjectId = 610)) AND ((main.ObjectType = 'RT::Ticket')) ' at 
> >/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494.  
> >(/usr/share/request-tracker3.4/lib/RT.pm:277)
> >
> >
> >Can someone guide me to a solution?
> >
> >Regards,
> >Geert Theys.
> >
> >--
> >No virus found in this outgoing message.
> >Checked by AVG Free Edition.
> >Version: 7.1.407 / Virus Database: 268.12.9/458 - Release Date: 
> >9/27/2006
> > 
> >_______________________________________________
> >http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> >Community help: http://wiki.bestpractical.com Commercial support: 
> >sales at bestpractical.com
> >
> >
> >Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> >Buy a copy at http://rtbook.bestpractical.com
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com Commercial 
> support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.407 / Virus Database: 268.12.9/458 - Release 
> Date: 9/27/2006
>  
> 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.407 / Virus Database: 268.12.11/460 - Release Date: 10/1/2006