|
|
|
A partition purge was failing with PUSD_ERR (718, partition member in use); however, connections were not expected to have the partition member open. Diagnostic logging was added to better diagnose which partition and which connection were involved.
Now, when a partition member purge fails with PUSD_ERR, the filename and list of open instances of that file are logged. Below is an example. For each connection, the task ID, user name, node name, and user file number are listed.
Mon Dec 12 12:40:33 2011
- User# 00012 PT_ADMIN: purge failed, partition .\ctreesql.dbs\admin_pt.20111129.015307.dat is open (2 open instances):
Mon Dec 12 12:40:39 2011
- User# 00012 PT_ADMIN: Connection 16: ADMIN(SQL:CTREESQL) 64
Mon Dec 12 12:40:44 2011
- User# 00012 PT_ADMIN: Connection 17: ADMIN(SQL:CTREESQL) 45
In addition to these log messages, if the configuration option DIAGNOSTICS PTADMIN is specified in ctsrvr.cfg, then c-treeACE creates a process stack trace when this error occurs. This option can be enabled or disabled using the ctadmn Administrator utility.
