You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by Prathap Gupta <ja...@gmail.com> on 2010/02/10 08:49:44 UTC

BundleDbPersistenceManager - default initialization fail on MySQL with duplicate entry error

Hi,

I am new to Jackrabbit and trying to use jackrabbit 2.0 webapp with MySQL
database. Whenever the tomcat server is started, the default initialization
is failed with the following error. Could somebody point me to the error
fix.

MySqlPersistenceManager is being used.

Thanks in advance.

Here is the error:

*09.02.2010 22:31:59 *INFO * RepositoryImpl: initializing workspace
'default'...
*(RepositoryImpl.java, line 1993)
09.02.2010 22:31:59 *INFO * ConnectionRecoveryManager: Database: MySQL /
5.0.18-
nt-log (ConnectionRecoveryManager.java, line 345)
09.02.2010 22:31:59 *INFO * ConnectionRecoveryManager: Driver: MySQL-AB JDBC
Dri
ver / mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19
Oct
 2006) $, $Revision: 5908 $ ) (ConnectionRecoveryManager.java, line 346)
*09.02.2010 22:31:59 *ERROR* ConnectionRecoveryManager: could not execute
stateme
nt, reason: Duplicate entry '▐¡╛∩╩■║╛╩■║╛╩■║╛' for key 1, state/code:
23000/1062
* (ConnectionRecoveryManager.java, line 453)
*09.02.2010 22:31:59 *ERROR* BundleDbPersistenceManager: failed to write
bundle:deadbeef-cafe-babe-cafe-babecafebabe
(BundleDbPersistenceManager.java, line 1210)
*com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:
Duplicate
entry '▐¡╛∩╩■║╛╩■║╛╩■║╛' for key 1
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)

Re: BundleDbPersistenceManager - default initialization fail on MySQL with duplicate entry error

Posted by Thomas Müller <th...@day.com>.
Hi,

I'm not sure, but it sounds like a configuration problem. Could you post:

* The error message and stack trace (including all root causes; see
also the log file if there are more exceptions)

* The configuration (repository.xml and all workspace.xml files).

* The versions of the Jackrabbit jar files you use (the list of all
jar file names).

See also http://wiki.apache.org/jackrabbit/QuestionsAndAnswers#Reporting_Problems

Regards,
Thomas


On Wed, Feb 10, 2010 at 8:49 AM, Prathap Gupta <ja...@gmail.com> wrote:
> Hi,
>
> I am new to Jackrabbit and trying to use jackrabbit 2.0 webapp with MySQL
> database. Whenever the tomcat server is started, the default initialization
> is failed with the following error. Could somebody point me to the error
> fix.
>
> MySqlPersistenceManager is being used.
>
> Thanks in advance.
>
> Here is the error:
>
> *09.02.2010 22:31:59 *INFO * RepositoryImpl: initializing workspace
> 'default'...
> *(RepositoryImpl.java, line 1993)
> 09.02.2010 22:31:59 *INFO * ConnectionRecoveryManager: Database: MySQL /
> 5.0.18-
> nt-log (ConnectionRecoveryManager.java, line 345)
> 09.02.2010 22:31:59 *INFO * ConnectionRecoveryManager: Driver: MySQL-AB JDBC
> Dri
> ver / mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19
> Oct
>  2006) $, $Revision: 5908 $ ) (ConnectionRecoveryManager.java, line 346)
> *09.02.2010 22:31:59 *ERROR* ConnectionRecoveryManager: could not execute
> stateme
> nt, reason: Duplicate entry '▐¡╛∩╩■║╛╩■║╛╩■║╛' for key 1, state/code:
> 23000/1062
> * (ConnectionRecoveryManager.java, line 453)
> *09.02.2010 22:31:59 *ERROR* BundleDbPersistenceManager: failed to write
> bundle:deadbeef-cafe-babe-cafe-babecafebabe
> (BundleDbPersistenceManager.java, line 1210)
> *com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:
> Duplicate
> entry '▐¡╛∩╩■║╛╩■║╛╩■║╛' for key 1
>        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
>        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
>        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
>