Houdini local render and publish existing frames error

Just for reference, the local publishing logic generates a render instance for each render product even if you have one render product resulting in the original instance + run time instances for each render product.
This expecting an aov_identifier to differentiate the run time instances.

s@ayon:aov_identifier = "Beauty";

The error you were seeing above happens because the aov_identifier was defaulting to "" empty string which resulted in the same instance name {product[type]}{Task[name]}{Variant}. therefore, adding an aov_identifier fixes the issue.

However, this logic is buggy bacuse the original instance should be completely ignored.

I did a quick test with one of @BigRoy suggestions where I added

        instance.data["publish"] = False

after this line. which worked.