Oninit cdi / Archive
Talk to an expert →

CDR_QDATA_SBSPACE

Posted in 2016

Summary

Jorge Valenzuela saw free space in the CDR_QDATA_SBSPACE sbspace dropping quickly and asked what happens when it runs out. Madison Pruet said a node was not receiving replicated transactions. Frank asked for cdr list server and onstat -g rqm output. A queue of about 398 million items was found; restarting the secondary server (onmode -ky, oninit) drained the queue and freed the space. Solved.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Storage & Space Management

jorge valenzuela — — source: IIUG Forums & Mailing Lists

Hi, I have a dbspace specified in the CDR_QDATA_SBSPACE. Acoording with the onstat -d command, It has 262144 of space and 113534 of free space. It has ben working about one year with any problem, but in the last 2 weeks, I see the free space has ben reducing drastically My Question is, what will happend if the free space is consumed ? I what do I have to do to avoid ? Thanks in advance. --001a11430c7a736cc9052e09bf1a

↪ replying to jorge valenzuela
Madison Pruet — — source: IIUG Forums & Mailing Lists

blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px #715FFA solid !important; padding-left:1ex !important; background-color:white !important; } That means that one of your nodes is not receiving replicated transactions. Sent from Yahoo Mail for iPad On Monday, March 14, 2016, 7:15 PM, jorge valenzuela <jorgervt@gmail.com> wrote: Hi, I have a dbspace specified in the CDR_QDATA_SBSPACE. Acoording with the onstat -d command, It has 262144 of space and 113534 of free space. It has ben working about one year with any problem, but in the last 2 weeks, I see the free space has ben reducing drastically My Question is, what will happend if the free space is consumed ? I what do I have to do to avoid ? Thanks in advance. --001a11430c7a736cc9052e09bf1a ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to jorge valenzuela
FRANK — — source: IIUG Forums & Mailing Lists

Do you have ER queued data in send queue ? what are outputs of , cdr list server onstat -g rqm brief ? Thanks Frank On Mon, Mar 14, 2016 at 7:01 PM, jorge valenzuela <jorgervt@gmail.com> wrote: > Hi, > > I have a dbspace specified in the CDR_QDATA_SBSPACE. > Acoording with the onstat -d command, It has 262144 of space and 113534 of > free space. > > It has ben working about one year with any problem, but in the last 2 > weeks, I see > the free space has ben reducing drastically > > My Question is, what will happend if the free space is consumed ? I what > do I have to > do to avoid ? > > Thanks in advance. > > --001a11430c7a736cc9052e09bf1a > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a114710925e5284052e199e87

↪ replying to jorge valenzuela
jorge valenzuela — — source: IIUG Forums & Mailing Lists

Thanks for your help. You were right. I had to do an onmode -ky to one node, then on oninit. after that I see the QUEUE was reducing from 398110303 until 0. Then I run onstat -d again and the space was freeded again. On 14 March 2016 at 16:01, jorge valenzuela <jorgervt@gmail.com> wrote: > Hi, > > I have a dbspace specified in the CDR_QDATA_SBSPACE. > Acoording with the onstat -d command, It has 262144 of space and 113534 of > free space. > > It has ben working about one year with any problem, but in the last 2 > weeks, I see > the free space has ben reducing drastically > > My Question is, what will happend if the free space is consumed ? I what > do I have to > do to avoid ? > > Thanks in advance. > > --001a11430c7a736cc9052e09bf1a > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1143e3dc832c19052e1bf0b9

↪ replying to FRANK
jorge valenzuela — — source: IIUG Forums & Mailing Lists

The problema was resolved. The cdr list server command had a big queue aprox. 398110303. It was the problema. I did an onmode -ky, oninit on the secondary server. After that the QUEUE, was empty. Thanks. On 15 March 2016 at 11:08, FRANK <yunyaoqu@gmail.com> wrote: > Do you have ER queued data in send queue ? > > what are outputs of , > > cdr list server > onstat -g rqm brief> > ? > > Thanks > Frank > > On Mon, Mar 14, 2016 at 7:01 PM, jorge valenzuela <jorgervt@gmail.com> > wrote: > > > Hi, > > > > I have a dbspace specified in the CDR_QDATA_SBSPACE. > > Acoording with the onstat -d command, It has 262144 of space and 113534 > of > > free space. > > > > It has ben working about one year with any problem, but in the last 2 > > weeks, I see > > the free space has ben reducing drastically > > > > My Question is, what will happend if the free space is consumed ? I what > > do I have to > > do to avoid ? > > > > Thanks in advance. > > > > --001a11430c7a736cc9052e09bf1a > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a114710925e5284052e199e87 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11441386d83d9d052e1c8c81

Related threads

Glossary