[rt-users] Re: RT Database - RESOLVED

[Odhiambo Washington]

* Paul.Taylor at equifax.com <Paul.Taylor at equifax.com> [20020930 10:03]: wrote:
> Wash,
> 
> This may not help (or even match your scenario), but then again it may so
> ......
> 
> Last week our machine crashed - following a recovery RT was behaving
> weirdly - could see stuff and create tickets but couldn't add comments.
> 
> We are use MySQL and it turned out a couple of tables (indexes actually)
> were marked as corrupt - running repair table resolved the problems.
> 
> Corruption was identified with :-
> mysqlcheck --defaults-file=.my.cnf  --all-databases --check --extended
> 
> Tables repaired  using 'mysql> repair table', full details in MySQL
> documentation.



It turned out that complex queries in MySQL need write access to the temp
directory, and permissions were denying this.


-Wash

-- 
Odhiambo Washington   <wash at wananchi.com>  "The box said 'Requires
Wananchi Online Ltd.  www.wananchi.com      Windows 95, NT, or better,'
Tel: +254 2 313985-9  +254 2 313922         so I installed FreeBSD."   
GSM: +254 72 743223   +254 733 744121       This sig is McQ!  :-)


Meeting, n.:
	An assembly of people coming together to decide what person or
department not represented in the room must solve a problem.