In the affected Confluence versions, the LDAP sync fails with a very unrelated failure:
2022-05-20 11:27:45,353 ERROR [Caesium-1-2] [engine.jdbc.spi.SqlExceptionHelper] logExceptions ERROR: invalid
byte
sequence
for
encoding
"UTF8"
: 0x00
2022-05-20 11:27:45,353 ERROR [Caesium-1-2] [org.hibernate.internal.ExceptionMapperStandardImpl] mapManagedFlushFailure HHH000346: Error during managed flush [org.hibernate.exception.DataException: could not execute statement]
2022-05-20 11:27:45,354 WARN [Caesium-1-2] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doCommit Commit failed. Rolling back. Error: Hibernate operation: could not execute statement; ERROR: invalid
byte
sequence
for
encoding
"UTF8"
: 0x00; nested exception is org.postgresql.util.PSQLException: ERROR: invalid
byte
sequence
for
encoding
"UTF8"
: 0x00
2022-05-20 11:27:45,354 WARN [Caesium-1-2] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[PluginReadWriteTx]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1508402677)
These additional debug does
not
help to show the LDAP exception due to the above database exception being thrown:
com.atlassian.crowd
com.atlassian.crowd.directory
SQL Logging
Base DN
The root distinguished name (DN) to use when running queries against the directory server. Examples:
when searching and loading users. If no value is supplied, the subtree search will start from the base DN. Example:
when searching and loading groups. If no value is supplied, the subtree search will start from the base DN. Example:
