Informix

 View Only
  • 1.  CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables

    Posted Sun October 10, 2021 11:01 AM
    Hello everyone!
    I have upgraded informix 14.10FC2 to 14.10FC6 successfully. But when I wanted to start ER with "cdr start" command , I got below error ": 

    CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables! Before starting ER, make sure that ER queus are empty, and log replay position caught up to current log psotion then start ER using `cdr cleanstart` command to force schema changes to on-disk queue tables.

    So I am forced to execute "cdr cleanstart"  . unfortunately as you know with this command all of  ER queue will be purge.

    Do everyone knows about this error and why does it happened and how do I resolve it without  "cdr cleanstart"? 

    Tks.
    Saeid.

    ------------------------------
    Saeid Mohseni Rad
    ------------------------------

    #Informix


  • 2.  RE: CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables

    Posted Mon October 11, 2021 02:10 AM
    Hello Saeid,

    I think the CDR buffer was not empty when stopping the instance for the update. The error looks like this one:
    https://www.ibm.com/support/pages/apar/IT38543

    cdr cleanstart also seems to be the only way to fix the problem.
    Before the update you can check if the syscdr tables trg_send_stxn + trg_receive_stxn are empty to avoid the error (see workaround).

    Regards
    Andreas

    ------------------------------
    Andreas Seifert
    CURSOR Software AG
    http://www.admin-scout.com
    ------------------------------



  • 3.  RE: CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables

    Posted Mon October 11, 2021 06:16 AM
    cdr cleanstart

    That's the way. If you attended tonIIUG virtual conference there were very good presentations about changes in FC6 related to ER and how to upgrade.

    Vicente


    ------------------------------
    Vicente Salvador Cubedo
    ------------------------------



  • 4.  RE: CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables

    IBM Champion
    Posted Mon October 11, 2021 06:41 AM
    Right,

    it actually is not about a problem incurred, but about a schema change to be implemented, for stable queue (spool) syscdr tables control_send_stxn, trg_send_stxn and trg_receive_stxn, in order to enable one of the 14.10.xC6 ER performance and spool enhancement features by which hopefully most if not all of those nasty send queue problems should be put into everyone's past.

    This particular change is about new in-row spooling which would place any transactions smaller than 26kB into an in-row ctbufdata_inline lvarchar field rather than the traditional ctbufdata blob field, thus avoiding a lot of the usual sbspace spool overhead, at least with typical OLTP workloads.

    Per migration guide, an instance should have it's queues empty and ER caught up to current log position, i.e. no more outstanding transactions to be replicated to other serers, before embarking on upgrade, under which circumstances nothing would be lost from a cleanstart anyway.
    The cleanstart is being mandated, with any upgrade from pre-14.10.xC6 to xC6 or newer, as it implicitly would drop and re-create said tables - in the desired new schema.

    So nothing to be scared about, and rather your entry point to an even better ER ;-)

    HTH,
     Andreas

    ------------------------------
    Andreas Legner
    ------------------------------



  • 5.  RE: CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables

    Posted Tue October 12, 2021 07:28 AM
    Thank you Andreas the comment  is made by you help to me , literally my mistake in this matter be solved. Mind you all things about this case is in your sent like .

    https://www.ibm.com/docs/en/informix-servers/14.10?topic=migration-migrating-enterprise-replication

    Saeid.

    ------------------------------
    Saeid Mohseni Rad
    ------------------------------



  • 6.  RE: CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables

    IBM Champion
    Posted Tue October 12, 2021 09:30 AM
    Hi Saeid,

    most welcome - I tried to be as clear as possible on this since you haven't been the first one to scratch their head about this .. and might not be the last ;-)

    BR,
     Andreas

    ------------------------------
    Andreas Legner
    ------------------------------



  • 7.  RE: CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables

    IBM Champion
    Posted Mon October 11, 2021 09:26 AM

    Did you follow the migration guide and run the convcdr script ? AFAIR it is needed if you move to FC6

     

    If you didn't then I suspect you are clean starting

     

    Cheers

    Paul