Novell Doc: NW 6.5 SP8: Novell Archive and Version Services 2.1 Administration Guide

C.3 MySQL Issues

This section discusses known issues and workarounds for the MySQL database.

Possible File Lock Conflicts in the Archive Database

Problem: Users experience errors when deleting or restoring file versions.

Possible Cause: The errors might be caused by file lock conflicts in the archive database.

Action: To disable database locks:

Stop ArkManager by entering the following at the server console:
```
arkstop
```
Stop the MySQL server by entering the following at the server console:
```
mysqladmin -p shutdown --port=value
```
Replace value with the port number where the ArkManager instance of MySQL server is running, such as 3308.
Disable database locks by opening the sys:\arkManager\arkSQL.cnf file in a text editor and adding the following line to the end of the file:
```
set-variable = innodb_table_locks=OFF
```
Restart the MySQL server by entering the following at the server console (all on the same line, of course):
```
mysqld_safe --defaults-file= sys:\arkmanager\arksql.cnf
```
Restart ArkManager by entering the following at the server console:
```
arkstart
```