Hi, I have OTRS 2.4.7 working successfully on Linux box from past 1 year. MySQL was configured in replication mode and the DB was getting successfully replicated when the attachments were begin stored in DB. Of late I have moved to FS for attachments and from them on replication has started giving trouble. I get the following error at mysql prompt: Last_SQL_Error: Error 'Table 'ticket' is marked as crashed and should be repaired' on query. Default database: 'otrs'. Query: 'UPDATE ticket SET escalation_response_time = '0' WHERE id = '101233''
My questions are: 1. Is the above issue related to DB being changed to FS for attachments? 2. How to I ensure sync of var/article on realtime basis. 3. Is there any other option of having realtime copy of OTRS so that in case primary servers crashes, the backup server takes over as primary almost immediately. (Earlier it was working fine and it used to get switched to backup server almost immediately. This was done thru cron scripts) regards, Amit Sharma _______________________________________________ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd