[rt-users] RT intermittent failures due to Mysql problems

[uzee]

Anyone please.............??



uzee wrote:
> 
> I just found out that my post was rejected cause I hadn't subscribed to
> the mailing list. My bad, the rejection message actually went to the junk
> folder so didn't see it right away. I'm posting this message again.
> 
> Hi All, 
> I'm hoping someone here could help me out or give any suggestions or
> advice. I have inherited an environment where RT was setup as 2 front-end
> application servers (round robin via DNS) and 2 mysql db servers (mysql
> servers are setup with replication). 
> Recently one of our mysql server's root partition bacame full which I
> think messed up the replication. Now we are seeing intermittent failures
> when we try to access RT. I have attached the error file. 
>  http://old.nabble.com/file/p30283778/rt_error.txt rt_error.txt 
> 
> Google came up with a very simple solution here:
> http://www.articlesbase.com/software-articles/rt-couldnt-store-your-session-mysql-error-985674.html
> - unfortunately I tried that and it did not work in my case. The mysql
> servers are configured with a mysqldump cronjob but for some weird reason
> the last good dump for the RT database I have is from a month ago, I would
> probably consider that as a LAST resort because if I understand correctly,
> restoring from that dump would mean I would lose all the data that was
> created after that dump... 
> 
> I have tried repairing the tables via mysqlcheck and although it clearly
> showed that it did fix issues with the tables... we still see the same RT
> error intermittently... (Also, I dont understand why the errors are
> intermittent, sometimes it works fine and we can do everything, and then a
> few minutes later, its down and shows the error) 
> 
> Just wondering if anyone has seen this or can offer any suggestions, I
> would truly appreciate it.... 
> thanks very much 
> -uzee
> 
> 

-- 
View this message in context: http://old.nabble.com/RT-intermittent-failures-due-to-Mysql-problems-tp30283778p30324945.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.