No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

FAQ - how to inquire database log of SIG system

Publication Date:  2012-10-15 Views:  42 Downloads:  0
Issue Description
Q:
How to query SIG system of database log?
Alarm Information
none
Handling Process
A:
Mysql database log path: / var/lib/Mysql/ServerName. Err.
Through check log can view mysal common operation conditions, such as:
1, whether mysql process anomaly or have been restarted
Common: due to insufficient memory problems lead to the mysql process exception. Mysql exception will lead to relevant SAS service data can't write into the database, SAS will connect database recurrently, in the related service in SAS log can view the information, which can also first sentence whether mysql is anomaly.
2, if there is damage whether the table is damaged.
through the log checking specific list whether the table is damaged, need repaired, and combined with whether there is abnormal restart, can sentence the cause of the damage of the table. Usually after a table damaged, when the page inquires the relevant table, page layout will always inquiry status (table is very big, inquires the situation very slowly with the some alike, need to differentiate).
Root Cause
none
Suggestions
none

END