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

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
------------------------------

cdr cleanstart

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

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
------------------------------

Original Message:
Sent: Mon October 11, 2021 06:15 AM
From: Vicente Salvador Cubedo
Subject: CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables

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
------------------------------

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
------------------------------

Original Message:
Sent: Mon October 11, 2021 06:41 AM
From: Andreas Legner
Subject: CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables

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
------------------------------


Original Message:
Sent: Mon October 11, 2021 06:15 AM
From: Vicente Salvador Cubedo
Subject: CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables

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

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
------------------------------

Original Message:
Sent: Tue October 12, 2021 07:28 AM
From: Saeid Mohseni Rad
Subject: CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables

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
------------------------------


Original Message:
Sent: Mon October 11, 2021 06:41 AM
From: Andreas Legner
Subject: CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables

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


Original Message:
Sent: Mon October 11, 2021 06:15 AM
From: Vicente Salvador Cubedo
Subject: CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables

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