The “show compare” gives error “ ERROR: Illegal state: File” (75677)

The following errors are observed when issuing “show compare id compare_PID”

sp_ctrl (vbbhipv1:2200)> show compare id nnn

Host: hostname

ERROR: Illegal state: File

"/apps/opt/splexq/var_2200/log/vtbdb_desvr-21333-01.log" is not

available

It may be due to a file handle leak in the program.

It has to do with file handle leak that occurred when all the file handles were exhausted. Try the following measures to see if this resolves the issue:

Exit and then relaunch sp_ctrl and issue the command “show compare”

Shutdown and then restart Shareplex and issue the command “show compare”

If there are a large number of compare logs, and if it is ok to remove them, do so by “remove log compare all” command and then run another compare and issue “show compare”.