-
Title
Error "que_DATA: Data is available" when deleting a named post queue -
Description
The deleteq command in qview is supposed to get rid of the queue structure along with the data in the queue. At times it errors out with "que_DATA: Data is available". The following is a sample session:
qview> qsetup
qview> list
The following queues exist:
csgpfia1+P+o.DBOPFIA1-o.DBOPFIA3
subqueues range from 0 to 13
WRITER +PI+csgpfia1+sp_mport+0x91e4cdc9 (145.228.205.201)
READER +PP+csgpfia1+sp_opst_mt+o.DBOPFIA1-o.DBOPFIA3
csgpfia1+P+o.DBOPFIA1-o.DBOPFIA2
subqueues range from 2 to 6
WRITER +PI+csgpfia1+sp_mport+0x91e4cdc9 (145.228.205.201)
READER +PP+csgpfia1+sp_opst_mt+o.DBOPFIA1-o.DBOPFIA2
qview> deleteq p csgpfia1+P+o.DBOPFIA1-o.DBOPFIA2
Queue csgpfia1+P+o.DBOPFIA1-o.DBOPFIA3 (y/n) <n>? n
Queue csgpfia1+P+o.DBOPFIA1-o.DBOPFIA2 (y/n) <n>? y
Error deleting queue csgpfia1+P+o.DBOPFIA1-o.DBOPFIA2
que_DATA: Data is available
qview> exit -
Cause
A bug in qview module causes the deleteq command to fail to get rid of the named Post queue.
-
Resolution
WORKAROUND:
qview -i
qview>qsetup
qview>reset p (it will prompt you with the queue name and you need to specify the appropriate queue)
qview>exit
Then go into qview once again and do deleteq as:
qview -i
qview>qsetup
qview>deleteq p (it will prompt you with the queue name and you need to specify the appropriate queue)
qview>list (issue list to verity that the queue is deleted as per your requests)
qview>exit
Afterwards, please make sure to truncate the shareplex internal table shareplex_trans.