CloudForms Replication failing due to ERROR: no data left in message

Solution Verified - Updated -

Issue

We found out we are missing VMs from regions on master. We saw large backlog in sync and Status down. Update and save didn't help, only decreased backlog size to zero and number was slowly growing again. Validation (credentials) was OK. Remove and add subscription again didn't help.

In postgresql.log logs you can see:

2018-08-27 10:41:10 EDT::5b840d86.108c:@:[4236]:LOG:  starting apply for subscription region_0_subscription
2018-08-27 10:41:10 EDT::5b840d86.108c:@:[4236]:LOG:  CONFLICT: remote UPDATE on relation public.event_streams. Resolution: apply_remote.
2018-08-27 10:41:10 EDT::5b840d86.108c:@:[4236]:ERROR:  no data left in message
2018-08-27 10:41:10 EDT::5b840d86.108c:@:[4236]:LOG:  apply worker [4236] at slot 1 generation 20 exiting with error
2018-08-27 10:41:10 EDT::5b840982.924:@:[2340]:LOG:  worker process: pglogical apply 16386:1658409966 (PID 4236) exited with exit code 1

Environment

  • CloudForms 4.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content