confluence.cfg.xml gets filled with <property>select 1</property> entries

[Michael Kluge]

Hello all,

we had a running instance of confluence 7.10.1. This installation was running correctly and has been updated to that point multiple times.

While Updating to 7.12.0 we are facing a problem. First of all the "SUPER privilege" problem described here:

https://confluence.atlassian.com/confkb/install-upgrade-confluence-7-11+-fails-with-error-you-do-not-have-the-super-privilege-and-binary-logging-is-enabled-1044096915.html

but after fixing that, we get a strange problem. While starting and running confluence the config gets changed and the following lines start to appear:

<property>select 1</property>

With these Lines the restart of confluence is not possible (of course). So we did a rollback (Backup) to the 7.10.1 and waited for a later release until yesterday. We changed the target version to 7.13.0, the update was running correctly, but these entries still appear. After removing the first appearance and running the instance the complete night, now we're facing a lot of these lines (10) within the config.

Does anyone know of these problem?

with best regards

Martin

[Michael Kluge · Accepted solution]

We found it, the problem seems to be caused by the puppet modul for confluence.

Within Puppet there is a config that has to make sure, that the folliwing Line within the config exists:

<property name="hibernate.c3p0.preferredTestQuery">select 1</property>

This Line is missing and puppet tries to add this line, but there is the failure, it adds:

<property>select 1</property>

which produces the failure. We currently just don't know the difference between 7.10.1 and 7.13.0 as the puppet code (puppet forge version 4.0.0) works correct with 7.10.1 and does not work with higher Versions.

with best regards.

[Kishan Sharma]

Thank you for posting the answer @Michael Kluge