Symptoms

Doing a full site import when using a PostgreSQL 8.1 or 8.2 data source configured in WebLogic results in an inconsistent database state which cannot be fixed. The following error is shown, even after restarting WebLogic:

org.postgresql.util.PSQLException: ERROR: relation with OID 4024106 does not exist

Cause

The problem is caused by using a data source rather than Confluence's built-in C3P0 connection pool.

Resolution

The workaround for this issue is to use Confluence's built-in C3P0 connection pool (configured when setting up Confluence initially, or via confluence.cfg.xml), which does not experience this problem.

Upgrading to PostgreSQL 8.3 may potentially fix the problem (as suggested by this PostgreSQL FAQ entry), but this has not been tested by Atlassian. The problem is being tracked at Site Import Fails on Weblogic when Using PostgreSQL, but will not be fixed, as Weblogic is no longer a supported application server..