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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.