-
Title
Export: Error reading fwd data 1:que_ERR: Non specific error -
Description
The following messages keep appearing in event log which are possibly due to a defunct Export queue but the replication through the valid Export queue runs fine:
sp_ctrl (server_name:2200)> show log reverse
Notice 2014-03-12 15:42:26.202082 19267674 1 Export: Error reading fwd data 1:que_ERR: Non specific error (exporting to target_server_namequeue old_server_name) [module que]
Notice 2014-03-12 15:42:26.201885 19267674 1 Export: Error reading queue old_server_name+X, subqueue -2 (exporting to target_server_namequeue old_server_name) [module que]
Notice 2014-03-12 15:42:26.200366 19267674 1 Export: sque read hdr error msglen=0 seq=0 magic=0 (exporting to target_server_namequeue old_server_name) [module que]
-
Cause
The defunct Export queue (named old_server_name) is causing these messages to generate.
-
Resolution
When a qstatus is issued, the defunct queue named old_server_name shows up as below:
sp_ctrl (server_name:2200)> qstatus
Queues Statistics for server_name
Name: old_server_name(Export queue)
Number of messages: 0 (Age 0 min; Size 1 mb)
Backlog (messages): 0 (Age 0 min)
Name: o.SID1 (Capture queue)
Number of messages: 2 (Age 0 min; Size 2 mb)
Backlog (messages): 2 (Age 0 min)
Name: server_name (Export queue)
Number of messages: 0 (Age 0 min; Size 3 mb)
Backlog (messages): 0 (Age 0 min)
The defunct Export queue should be deleted using the deleteq command in qview as below:
1. Shutdown Shareplex
2. From /proddir/bin invoke qview utility and run the following commands (where proddir refers to Product Directory of Shareplex):
sp_ctrl (server_name:2200)> shutdown
/proddir/bin ./qview -i
qview> qsetup
qview> list
The following queues exist:
o.SID1+C
WRITER +PA+o.SID1+sp_ocap+o.SID1
READER +PR+o.SID1+sp_ordr+o.SID1
old_server_name+X
WRITER +PR+o.SID1+sp_ordr+o.SID1
READER +PX+old_server_name+sp_xport+0xcececece (nnn.nnn.nnn.nnn)
server_name+X
WRITER +PR+o.SID1+sp_ordr+o.SID1
READER +PX+server_name+sp_xport+0xcececece (nnn.nnn.nnn.nnn)
qview> deleteq old_server_name+X
3. Then verify that the defunct queue does not exist:
qview> list
The following queues exist:
o.SID1+C
WRITER +PA+o.SID1+sp_ocap+o.SID1
READER +PR+o.SID1+sp_ordr+o.SID1
server_name+X
WRITER +PR+o.SID1+sp_ordr+o.SID1
READER +PX+server_name+sp_xport+0xcececece (nnn.nnn.nnn.nnn)
4. Upon restart of Shareplex the problem messages will not appear anymore since the defunct queue has been removed.