- Paul.Taylor@equifax.com Paul.Taylor@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 --extendedTables 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@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.