Difference between revisions of "The Root Causes of Database Table Corruption"
| Line 24: | Line 24: | ||
Table corruption occurs when another application other than the SwSQLServer has already locked either the Data file or the Index file when SwSQL locks the table for update. | Table corruption occurs when another application other than the SwSQLServer has already locked either the Data file or the Index file when SwSQL locks the table for update. | ||
| − | The types of application that will lock the database files are typically either Anti Virus, Backup or the Windows Shadow Copy Service. | + | The types of application that will lock the database files are typically either Anti Virus, Backup or the Windows Shadow Copy Service. Therefore to avoid table corruption we would advise that the Hornbill folder be added to the exception list of any Anti Virus or Backup software that runs automatically on the server. |
| − | |||
| − | Therefore to avoid table corruption we would advise that the Hornbill folder be added to the exception list of any Anti Virus or Backup software that runs automatically on the server. | ||
We would also advise that the Drive that the Supportworks Server is installed on be added to the exception list of the Windows Shadow Copy Service. | We would also advise that the Drive that the Supportworks Server is installed on be added to the exception list of the Windows Shadow Copy Service. | ||
Revision as of 15:41, 19 January 2018
| Status: | Published |
|---|---|
| Version: | 1.0 |
| Authors: | HTL QA |
| Applies to: | Core Services Version 3.x and above |
Virus Scanners - 3rd Party Backup software - Shadow copy service - causes of table corruption
How Virus Scanners, Backup software and the Shadow copy service cause table corruption.
The SwSQL database is based on MySQL and uses the MyISAM engine. MySQL uses three files (*.frm,*.MYI and *.MYD) to represent each table and the engine implements table level locking. This means
that when a table is updated no one else can access the table as all of the table files are locked to avoid corruption of the data.
Table corruption occurs when another application other than the SwSQLServer has already locked either the Data file or the Index file when SwSQL locks the table for update.
The types of application that will lock the database files are typically either Anti Virus, Backup or the Windows Shadow Copy Service. Therefore to avoid table corruption we would advise that the Hornbill folder be added to the exception list of any Anti Virus or Backup software that runs automatically on the server.
We would also advise that the Drive that the Supportworks Server is installed on be added to the exception list of the Windows Shadow Copy Service.