Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
ddl.lck files created in VARDIR state directory - Do these need to manually removed?
설명
There are hundreds of .ddl*.lck files in the vardir/state directory. Do these need to manually removed? This is what they look like: ---------- 1 root dba 0 Feb 12 14:43 .ddl-277-0-9752-332743100.lck ---------- 1 root dba 0 Feb 12 14:43 .ddl-277-0-9752-321008296.lck
원인
The *ddl*lck* files are created by poster to insure that only a single poster instance applies a DDL that may have been broadcast to multiple poster queues. These "lock" filenames are constructed with the sequence number and offset of the redo record [from the source]; poster is supposed to clean them up periodically. Once again: these files are created quite deliberately, and not as a result of an error. Poster cleans [removes] them periodically.
