MySQL isolation level could not be read

[victor9669]

Every time I start my confluence server I get the following error message.

MySQL isolation level could not be read. Isolation level must be 'READ-COMMITTED'. See http://confluence.atlassian.com/x/GAtmDg

I have followed the instructions provided on the link and set the mysql isolation level. (Also tried the other two options with no luck)

Does anyone else have any ideas of what I can try?

Thanks

[Kurt Klinner]

@victor9669

Can you share the complete line?

jdbc:mysql://localhost/...?sessionVariables=tx_isolation='READ-COMMITTED'

[victor9669]

Sorry that's just the database name, there are no extra parameters there.

[Kurt Klinner]

@victor9669

Hi Victor,

so db-wise we should be fine, can you double check what you configured in the confluence config file

BR

Kurt

[victor9669]

Hi Kurt, here is my config file.

<?xml version="1.0" encoding="UTF-8"?> 

<confluence-configuration>

  <setupStep>complete</setupStep>

  <setupType>custom</setupType>

  <buildNumber>7701</buildNumber>

  <properties>

    <property name="admin.ui.allow.daily.backup.custom.location">false</property>

    <property name="admin.ui.allow.manual.backup.download">false</property>

    <property name="admin.ui.allow.site.support.email">false</property>

    <property name="atlassian.license.message">..</property>

    <property name="attachments.dir">${confluenceHome}/attachments</property>

    <property name="confluence.setup.server.id">BEKS-CPXY-FA3C-QGIU</property>

    <property name="confluence.webapp.context.path"></property>

    <property name="hibernate.c3p0.acquire_increment">1</property>

    <property name="hibernate.c3p0.idle_test_period">100</property>

    <property name="hibernate.c3p0.max_size">30</property>

    <property name="hibernate.c3p0.max_statements">0</property>

    <property name="hibernate.c3p0.min_size">0</property>

    <property name="hibernate.c3p0.timeout">30</property>

    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>

    <property name="hibernate.connection.password">...</property>

    <property name="hibernate.connection.url">jdbc:mysql://localhost/...?sessionVariables=tx_isolation='READ-COMMITTED'</property>

    <property name="hibernate.connection.username">...</property>

    <property name="hibernate.database.lower_non_ascii_supported">true</property>

    <property name="hibernate.dialect">com.atlassian.confluence.impl.hibernate.dialect.MySQLDialect</property>

    <property name="hibernate.setup">true</property>

    <property name="jwt.private.key">...</property>

    <property name="jwt.public.key">...</property>

    <property name="lucene.index.dir">${localHome}/index</property>

    <property name="synchrony.btf">true</property>

    <property name="synchrony.encryption.disabled">true</property>

    <property name="synchrony.proxy.enabled">false</property>

    <property name="webwork.multipart.saveDir">${localHome}/temp</property>

  </properties>

</confluence-configuration>

[Kurt Klinner]

@victor9669

Hi Victor,

can you check what the mysql server reports regarding the transation isolation level,

to check if the config change is reflected in the running db instance

SELECT @@GLOBAL.transaction_isolation, @@transaction_isolation;

BR

Kurt

[victor9669]

Hi Kurt,

They both return as READ-COMMITTED