Getting ZipException Error when Installing a New Plugin Due to Postgres 9 Configuration


アトラシアン コミュニティをご利用ください。



Using Postgres 9.0+, the following exception is shown in the logs when installing a new plugin:

2010-10-05 07:14:37,325 ERROR [http-8080-14] [atlassian.plugin.loaders.ScanningPluginLoader] deployPluginFromUnit Unable to deploy plugin 'null', file Unit: C:\confluence\data\plugin-cache\xxxxxxxx.jar (1286277277321)
 -- url: /admin/uploadplugin.action | userName: someuser | referer: http://<confluence server base url>:8080/admin/viewplugins.action | action: uploadplugin
com.atlassian.plugin.PluginParseException: Cannot open JAR file for reading: C:\confluence\data\plugin-cache\1286277277033taskdock-1.2.jar
    at com.atlassian.plugin.JarPluginArtifact.getResourceAsStream(
    at com.atlassian.plugin.factories.LegacyDynamicPluginFactory.canCreate(
    at com.atlassian.plugin.loaders.ScanningPluginLoader.deployPluginFromUnit(
    at com.atlassian.plugin.loaders.ScanningPluginLoader.addFoundPlugins(
    at com.atlassian.confluence.plugin.DatabaseClassLoadingPluginLoader.addFoundPlugins(
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(
    at java.lang.reflect.Method.invoke(
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
Caused by: error in opening zip file
    at Method)
    at java.util.jar.JarFile.<init>(
    at java.util.jar.JarFile.<init>(
    at com.atlassian.plugin.JarPluginArtifact.getResourceAsStream(
    ... 220 more


The PostgreSQL 8.x JDBC drivers that ship with Confluence are not compatible with PostgreSQL 9.x. The underlying cause is a change to PostgreSQL which has modified the bytea_output data type.

This change affects Confluence's ability to store plugin binaries in the plugindata table in the database when installing a new plugin.


Confluence 4.0 and later contains the updated PostgreSQL 9.x JDBC drivers which fixes this problem.

If you are running an earlier version of Confluence, you can upgrade to the latest PostgreSQL JDBC drivers by replacing the existing driver JAR file in Confluence's WEB-INF/lib/ directory. The driver version 9.0-801.jdbc3 does not suffer from this problem.



Last modified on Mar 30, 2016


Powered by Confluence and Scroll Viewport.