data base dead

[shivendra]

from few days otrs database is giving error.
mysql got dead on load of 1 - 2 .

i have to restart server every time and at boot i have to run fsck -A -y
i repair database and run sucessful.
But after few time again it got crush.this is a continous process.

i try to repaired data base of ticket but it gives error ---

mysqlcheck -auto-repair -u root -p ticket
Enter password:
ticket.article Table is already up to date
ticket.article_attachment Table is already up to date
ticket.article_flag Table is already up to date
ticket.article_plain Table is already up to date
ticket.article_search
error : Table 'ticket.article_search' is read only
ticket.article_sender_type
error : Table 'ticket.article_sender_type' is read only
ticket.article_type
error : Table 'ticket.article_type' is read only
ticket.auto_response
error : Table 'ticket.auto_response' is read only
ticket.auto_response_type
error : Table 'ticket.auto_response_type' is read only
ticket.customer_company Table is already up to date
ticket.customer_preferences Table is already up to date
ticket.customer_user Table is already up to date
ticket.dynamic_field Table is already up to date
ticket.dynamic_field_value Table is already up to date
ticket.follow_up_possible
error : Table 'ticket.follow_up_possible' is read only
ticket.generic_agent_jobs Table is already up to date
ticket.gi_debugger_entry
error : Table 'ticket.gi_debugger_entry' is read only
ticket.gi_debugger_entry_content
error : Table 'ticket.gi_debugger_entry_content' is read only
ticket.gi_object_lock_state
error : Table 'ticket.gi_object_lock_state' is read only
ticket.gi_webservice_config
error : Table 'ticket.gi_webservice_config' is read only
ticket.gi_webservice_config_history
error : Table 'ticket.gi_webservice_config_history' is read only
ticket.group_customer_user
error : Table 'ticket.group_customer_user' is read only
ticket.group_role
error : Table 'ticket.group_role' is read only
ticket.group_user Table is already up to date
ticket.groups Table is already up to date
ticket.link_object Table is already up to date
ticket.link_relation
error : Table 'ticket.link_relation' is read only
ticket.link_state
error : Table 'ticket.link_state' is read only
ticket.link_type
error : Table 'ticket.link_type' is read only
ticket.mail_account
error : Table 'ticket.mail_account' is read only
ticket.notification_event
error : Table 'ticket.notification_event' is read only
ticket.notification_event_item
error : Table 'ticket.notification_event_item' is read only
ticket.notifications
error : Table 'ticket.notifications' is read only
ticket.package_repository
error : Table 'ticket.package_repository' is read only
ticket.personal_queues Table is already up to date
ticket.postmaster_filter
error : Table 'ticket.postmaster_filter' is read only
ticket.process_id Table is already up to date
ticket.queue Table is already up to date
ticket.queue_auto_response
error : Table 'ticket.queue_auto_response' is read only
ticket.queue_preferences
error : Table 'ticket.queue_preferences' is read only
ticket.queue_standard_response Table is already up to date
ticket.role_user
error : Table 'ticket.role_user' is read only
ticket.roles
error : Table 'ticket.roles' is read only
ticket.salutation Table is already up to date
ticket.scheduler_task_list Table is already up to date
ticket.search_profile Table is already up to date
ticket.service Table is already up to date
ticket.service_customer_user Table is already up to date
ticket.service_preferences
error : Table 'ticket.service_preferences' is read only
ticket.service_sla Table is already up to date
ticket.sessions Table is already up to date
ticket.signature
error : Table 'ticket.signature' is read only
ticket.sla Table is already up to date
ticket.sla_preferences
error : Table 'ticket.sla_preferences' is read only
ticket.smime_signer_cert_relations
error : Table 'ticket.smime_signer_cert_relations' is read only
ticket.standard_attachment
error : Table 'ticket.standard_attachment' is read only
ticket.standard_response
error : Table 'ticket.standard_response' is read only
ticket.standard_response_attachment
error : Table 'ticket.standard_response_attachment' is read only
ticket.support_bench_test
error : Table 'ticket.support_bench_test' is read only
ticket.system_address
error : Table 'ticket.system_address' is read only
ticket.ticket Table is already up to date
ticket.ticket_flag Table is already up to date
ticket.ticket_history Table is already up to date
ticket.ticket_history_type
error : Table 'ticket.ticket_history_type' is read only
ticket.ticket_index
error : Table 'ticket.ticket_index' is read only
ticket.ticket_lock_index
error : Table 'ticket.ticket_lock_index' is read only
ticket.ticket_lock_type
error : Table 'ticket.ticket_lock_type' is read only
ticket.ticket_loop_protection
error : Table 'ticket.ticket_loop_protection' is read only
ticket.ticket_priority
error : Table 'ticket.ticket_priority' is read only
ticket.ticket_state Table is already up to date
ticket.ticket_state_type
error : Table 'ticket.ticket_state_type' is read only
ticket.ticket_type
error : Table 'ticket.ticket_type' is read only
ticket.ticket_watcher Table is already up to date
ticket.time_accounting
error : Table 'ticket.time_accounting' is read only
ticket.user_preferences Table is already up to date
ticket.users Table is already up to date
ticket.valid
error : Table 'ticket.valid' is read only
ticket.virtual_fs
error : Table 'ticket.virtual_fs' is read only
ticket.virtual_fs_db
error : Table 'ticket.virtual_fs_db' is read only
ticket.virtual_fs_preferences
error : Table 'ticket.virtual_fs_preferences' is read only
ticket.web_upload_cache Table is already up to date
ticket.xml_storage Table is already up to date


what is issue pleas help me

[crythias]

http://stackoverflow.com/questions/9575 ... -read-only