[opencms-dev] Invalid argument value: Duplicate entry '/' for key 2

[Roland Ribi]

Hi

I have the following error when I try to install OpenCMS 5.0.0 on the
server of my ISP.

They have Tomcat 4.1.24, IBM-JDK 1.4 and MySQL Version: 4.0.13-log


Can anyone help me?

I allready installed the newer JDBC-Driver for MySQL. The following
stacktrace comes from the import of the workspace. 
The setup part before the import works fine.



87:		at
com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
86:		at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
85:		at com.opencms.boot.CmsMain.begin(CmsMain.java:164)
84:		at java.lang.reflect.Method.invoke(Method.java(Compiled
Code))
83:		at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java(Compiled Code))
82:		at sun.reflect.GeneratedMethodAccessor46.invoke(Unknown
Source)
81:		at com.opencms.core.CmsShell.commands(CmsShell.java:177)
80:		at
com.opencms.core.CmsShellCommands.<init>(CmsShellCommands.java:78)
79:	java.lang.NullPointerException
78:	
77:	>>>	at
com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
76:	>>>	at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
75:	>>>	at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
74:	>>>	at java.lang.Class.newInstance(Class.java(Compiled
Code))
73:	>>>	at java.lang.Class.newInstance0(Class.java(Compiled
Code))
72:	>>>	at
java.lang.reflect.Constructor.newInstance(Constructor.java(Compiled
Code))
71:	>>>	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java(Compiled Code))
70:	>>>	at
sun.reflect.GeneratedConstructorAccessor34.newInstance(Unknown Source)
69:	>>>	at com.opencms.core.CmsShell.<init>(CmsShell.java:114)
68:	>>>	at com.opencms.core.OpenCms.<init>(OpenCms.java:255)
67:	>>>	at
com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
66:	>>>	at
com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.jav
a:4182)
65:	>>>	at
com.opencms.file.mySql.CmsResourceBroker.createDbAccess(CmsResourceBroke
r.java:62)
64:	>>>	at
com.opencms.file.mySql.CmsDbAccess.<init>(CmsDbAccess.java:125)
63:	>>>	at
com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:300)
62:	>>>	at
com.opencms.file.mySql.CmsDbAccess.fillDefaults(CmsDbAccess.java:603)
61:	>>>	at
com.opencms.file.genericSql.CmsDbAccess.createFolder(CmsDbAccess.java:11
63)
60:	>>>	at
com.opencms.dbpool.CmsPreparedStatement.executeUpdate(CmsPreparedStateme
nt.java(Compiled Code))
59:	>>>	at
com.mysql.jdbc.PreparedStatement.executeUpdate(Unknown Source)
58:	>>>	at
com.mysql.jdbc.PreparedStatement.executeUpdate(Unknown Source)
57:	>>>	at com.mysql.jdbc.Connection.execSQL(Unknown Source)
56:	>>>	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(Unknown Source)
55:	>>>	at com.mysql.jdbc.MysqlIO.sendCommand(Unknown Source)
54:	>>>java.sql.SQLException: Invalid argument value: Duplicate
entry '/' for key 2
53:	>>>Root cause:
52:	>>>-----------
51:	>>	at
com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
50:	>>	at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
49:	>>	at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
48:	>>	at java.lang.Class.newInstance(Class.java(Compiled
Code))
47:	>>	at java.lang.Class.newInstance0(Class.java(Compiled
Code))
46:	>>	at
java.lang.reflect.Constructor.newInstance(Constructor.java(Compiled
Code))
45:	>>	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java(Compiled Code))
44:	>>	at
sun.reflect.GeneratedConstructorAccessor34.newInstance(Unknown Source)
43:	>>	at com.opencms.core.CmsShell.<init>(CmsShell.java:114)
42:	>>	at com.opencms.core.OpenCms.<init>(OpenCms.java:255)
41:	>>	at
com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
40:	>>	at
com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.jav
a:4182)
39:	>>	at
com.opencms.file.mySql.CmsResourceBroker.createDbAccess(CmsResourceBroke
r.java:62)
38:	>>	at
com.opencms.file.mySql.CmsDbAccess.<init>(CmsDbAccess.java:125)
37:	>>	at
com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:300)
36:	>>	at
com.opencms.file.mySql.CmsDbAccess.fillDefaults(CmsDbAccess.java:603)
35:	>>	at
com.opencms.file.genericSql.CmsDbAccess.createFolder(CmsDbAccess.java:11
65)
34:	>>root cause was java.sql.SQLException: Invalid argument value:
Duplicate entry '/' for key 2
33:	>>com.opencms.core.CmsException: 4 Sql exception. Detailed
error: [com.opencms.file.mySql.CmsDbAccess] Invalid argument value:
Duplicate entry '/' for key 2. 
32:	>>Root cause:
31:	>>-----------
30:	>	at
com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
29:	>	at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
28:	>	at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
27:	>	at java.lang.Class.newInstance(Class.java(Compiled
Code))
26:	>	at java.lang.Class.newInstance0(Class.java(Compiled
Code))
25:	>	at
java.lang.reflect.Constructor.newInstance(Constructor.java(Compiled
Code))
24:	>	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java(Compiled Code))
23:	>	at
sun.reflect.GeneratedConstructorAccessor34.newInstance(Unknown Source)
22:	>	at com.opencms.core.CmsShell.<init>(CmsShell.java:114)
21:	>	at com.opencms.core.OpenCms.<init>(OpenCms.java:255)
20:	>	at
com.opencms.file.CmsRbManager.init(CmsRbManager.java:100)
19:	>root cause was java.sql.SQLException: Invalid argument value:
Duplicate entry '/' for key 2
18:	>root cause was com.opencms.core.CmsException: 4 Sql exception.
Detailed error: [com.opencms.file.mySql.CmsDbAccess] Invalid argument
value: Duplicate entry '/' for key 2. 
17:	>com.opencms.core.CmsException: 33 Resourcebroker-init error.
Detailed error: Critical error while loading resourcebroker. 
16:	>Root cause:
15:	>-----------
14:		at
com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
13:		at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
12:		at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
11:		at java.lang.Class.newInstance(Class.java(Compiled
Code))
10:		at java.lang.Class.newInstance0(Class.java(Compiled
Code))
9:		at
java.lang.reflect.Constructor.newInstance(Constructor.java(Compiled
Code))
8:		at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java(Compiled Code))
7:		at
sun.reflect.GeneratedConstructorAccessor34.newInstance(Unknown Source)
6:		at com.opencms.core.CmsShell.<init>(CmsShell.java:114)
5:		at com.opencms.core.OpenCms.<init>(OpenCms.java:259)
4:	root cause was java.sql.SQLException: Invalid argument value:
Duplicate entry '/' for key 2
3:	root cause was com.opencms.core.CmsException: 4 Sql exception.
Detailed error: [com.opencms.file.mySql.CmsDbAccess] Invalid argument
value: Duplicate entry '/' for key 2. 
2:	root cause was com.opencms.core.CmsException: 33
Resourcebroker-init error. Detailed error: Critical error while loading
resourcebroker. 
1:	com.opencms.core.CmsException: 33 Resourcebroker-init error.
Detailed error: Database init failed. 
0:	%%% props:
/home/fcgrotkreuz.ch/htdocs/opencms/WEB-INF/config/opencms.properties


Gruss

Roland Ribi

mailto:roland.ribi at gmx.ch