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
It turned out that complex queries in MySQL need write access to the temp
directory, and permissions were denying this.
Odhiambo Washington email@example.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!
An assembly of people coming together to decide what person or
department not represented in the room must solve a problem.