Hello, 1. Is the above issue related to DB being changed to FS for attachments?
I've seen that crashed table message when moving a database without stopping the mysql deamon. To repair it just run repair table_name on the mysql prompt and check your replication process, it might have something wrong 2. How to I ensure sync of var/article on realtime basis. You can do a bash script using ssh and rsync called by cron to move attachments from one server to another 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) Cron scripts are fine as long as they're well written. Maybe sharing your script here will motivate people to propose improvements Leonardo Certuche www.itconsultores.com.co Medellín, Colombia On 3 June 2011 23:42, Amit Sharma <amit_...@yahoo.com> wrote: > 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 > Thanks and Regards, > *Amit Sharma* > > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs >
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
