Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables
Answered: green (solid confidence) — The error is expected when upgrading from pre-14.10.xC6: ER spool tables get a new in-row schema, which requires empty queues and cdr cleanstart per the migration guide. The asker confirmed Andreas Legner's explanation resolved it.
ifx expert upgraded 14.10.FC2 to FC6 and cdr start failed with a missing ctbufdata_inline column error, requiring cdr cleanstart, which purges ER queues. Andreas Seifert and Andreas Legner explained it is a schema change for new in-row spooling in FC6, and the migration guide describes preparing for it; Paul Watson mentioned the convcdr script. The poster said the explanation resolved the confusion.
💣 This thread may describe something risky to do carelessly
cdr cleanstart purges all Enterprise Replication send/receive queues; if the queues are not empty and replay is not caught up, pending transactions are lost and replicas diverge.
cdr cleanstart
Advisory only — not a substitute for testing in a non-production environment first.
ifx expert — source: IBM Community (ConnectedCommunity.org) Informix forum
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
↪ replying to ifx expert
Andreas Seifert — source: IBM Community (ConnectedCommunity.org) Informix forum
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
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
------------------------------
↪ replying to Vicente Salvador Cubedo
Andreas Legner — source: IBM Community (ConnectedCommunity.org) Informix forum
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
------------------------------
↪ replying to ifx expert
Paul Watson — source: IBM Community (ConnectedCommunity.org) Informix forum
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
↪ replying to Andreas Legner
ifx expert — source: IBM Community (ConnectedCommunity.org) Informix forum
Andreas Legner — source: IBM Community (ConnectedCommunity.org) Informix forum
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
------------------------------
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.