0 ratings0% found this document useful (0 votes) 141 views3 pagesShare Plex Bug
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content,
claim it here.
Available Formats
Download as PDF or read online on Scribd
‘SharePlex queue files keep growing varir rim directory i fll (107882)
SharePlex queue files keep growing vardir rim directory is full (107882)
Title
SharePlex queue fl
les keep growing vardir rim directory is full
Description
SharePlex rim files keep growing even though number of messages in capture queue go down to zero.
sp_ctl (host 2216)> qstatus
‘Queues Statistics for host
Name: 0.SID (Capture queue)
Number of messages: 1 (Age Omi; Size_-267887 mb)
Backlog (messages): (Age O min)
Name: host (Export queue)
Number of messages: 3822 (Age 4 min; Size. 13298 mb)
Backlog (messages): (Age O min)
Cause
Product Defect, issue occurs when 83 tera byte of data written to a particular subque since replication started or
if you have Horizontal Partitioning set up.
Resolution
STATUS:
Issue is fixed in version 8.0.3.49.
WORKAROUND:
To verify whether you hit the 83 terabyte limit for capture queue, run below command fram prod dir/bin on
source (you can run it even if sp_cop is running).
Jdumpque -ac >dump.out (for capture queue)
Check the section for subqueue 0 in dump.out and see if sque_seq_wrt_file value is greater than 83 terbyte
(8388608000000)
SUBque HDR from currentshared memory
subqueue 0
sque_top_msgid 582905043
sque_seq_wrt file 316524700923 This is lower than 83 terabyte (8388608000000)
sque_seq_wrtemt 316522330439
sque_msgid_wrt_omt 82902424
sque_prev_wrt_emt 316521620368
hnps:/support quest comyshaceplex/kb/107882/shareplex-queve-files-keep-growing.-vardit-tim-directory-s-full[/7/2018 9:35:52 AM} ‘SharePlex queue files keep growing varir rim directory i fll (107882)
sque_lastseqiris 316524685970
sque_diskseq_mis 316524685970
‘sque_prev_msgid_wrt_cmt 582900861
sque_last_msgid_ris 582905007
sque_last_time_ris 4 secs
sque_oldest_time 5 secs 51f03d1a
sque_sqmetr 1582905043
sque_oldest_sqmid §82905008 36 msgs
sque_last_sqmid_ris 82905007
sque_highest_df 37732 sque_lowest_df 163
1/:msgid tris 82905007 seq rrls 316524685970
seq read 316524695175 user ls 316524685626
sreseq 1165139274216 next msgid 582905030
ssqmid rrls 582905007 next sqmid 582905030
A. If sque_seq_wrt_file value is greater than 83 terabyte then follow below procedure to delete queues and
consider upgrade to 8.0.3.x version.
You need to get quiet ime on source to avoid losing data
1. Wait til all messages finish processing or sent to target, then shutdown SharePlex on source and target
sp_otrl>qstatus (make sure all messages are gone)
sp_strl> shutdown
2, Delete the related queues on source and target
49 to prod dinbin
on source
Iqview
qview> qsetup port
qview> deleteq.e (deleting capture queue, any data will be lost)
qview> deleteg x (deleting export queue, any data will be lost)
aview> quit
on target
Jqview
aview>asetup portit
qview> deleteg p (deleting post queue, any data will be lost)
if you have multiple post queues then you need to run deleteg p multiple times
aview> quit
(On target, sqlplus as shareplex user an truncate shareplex_trans table.
B. If sque_seq_wrt_file value is less than 83 terabyte then follow below procedure to safely remove unused data
files.
Below procedure works if you are on version 7.6.3.x and above,
1. shutdown sp_cop on source or target
ssp_ctrl> shutdown
hanps:/support.quest.comyshaceplex/kb/107882/shareplex-queve-files-keep-growing.-vardit-tim-directory-s-full/7/2018 9:35:52 AM} StharePlex queue files keep growing vnc rim directory is ful (107882)
2. go to prod dirin
Jeview 4
qview>qsetup port
qview> old datafles ©
view old datafile x
or
view> old datafes p «ifthe problem is with post queues>
aview> quit
3. Restart sp_cop
Defect ID
s198978
Additional Information
Go to prod dit/bin and run dumpaue for capture queue /dumpque -aC > dumpque.cut Che:
see ifitis greater than 8388608000000 (83 tera by
sque_top_msgid 185962520 sque_seq_wrt file 1570
k sque_seq.wrt fle to
2) SUBque HDR from currentyshared memory subqueue 0
4983719
hanps:/support.quest.comyshaceplex/kb/107882/shareplex-queve-files-keep-growing.-vardit-tim-directory-s-full/7/2018 9:35:52 AM}
