[opencms-dev] installation error on importing workplace

Fri Apr 23 16:21:00 CEST 2004

Hello everyone,

I have just started with opencms and have been trying to install it.
Unfortunately, the installation fails when importing the workplace.  It
seems to be related to a specific SQL error : "Duplicate entry '/' for key
2".  The full error dump is below.

I noticed someone else has reported this error but can not find any
followup.  Can anyone provide any further information?  I must admit that
I'm not familiar with MySQL (being more used to postgresql) - does 'key 2'
mean something specific?

I am using Tomcat 5.0.12 (and have seen some of the comments about using
Tomcat 5 in the mail archive) but can not see anything in the Tomcat log
files.  The opencms.log file is also empty.  I am using MySQL v5 on Redhat
Linux 8 with JDK1.4.1.

Any help much appreciated!

Thanks,

Marion

114:		at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
113:		at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
112:		at com.opencms.boot.CmsMain.begin(CmsMain.java:164)
111:		at java.lang.reflect.Method.invoke(Method.java:324)
110:		at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
109:		at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
108:		at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
107:		at com.opencms.core.CmsShell.commands(CmsShell.java:168)
106:		at com.opencms.core.CmsShellCommands.<init>(CmsShellCommands.java:78)
105:	java.lang.NullPointerException
104:
103:	>>>	at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
102:	>>>	at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
101:	>>>	at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
100:	>>>	at java.lang.Class.newInstance(Class.java:259)
99:	>>>	at java.lang.Class.newInstance0(Class.java:306)
98:	>>>	at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
97:	>>>	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc
torAccessorImpl.java:27)
96:	>>>	at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcces
sorImpl.java:39)
95:	>>>	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
94:	>>>	at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
93:	>>>	at com.opencms.core.OpenCms.<init>(OpenCms.java:255)
92:	>>>	at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
91:	>>>	at
com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:41
82)
90:	>>>	at
com.opencms.file.mySql.CmsResourceBroker.createDbAccess(CmsResourceBroker.ja
va:62)
89:	>>>	at com.opencms.file.mySql.CmsDbAccess.<init>(CmsDbAccess.java:125)
88:	>>>	at
com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:300)
87:	>>>	at
com.opencms.file.mySql.CmsDbAccess.fillDefaults(CmsDbAccess.java:603)
86:	>>>	at
com.opencms.file.genericSql.CmsDbAccess.createFolder(CmsDbAccess.java:1163)
85:	>>>	at
com.opencms.dbpool.CmsPreparedStatement.executeUpdate(CmsPreparedStatement.j
ava:177)
84:	>>>	at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1488)
83:	>>>	at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1602)
82:	>>>	at com.mysql.jdbc.Connection.execSQL(Connection.java:1844)
81:	>>>	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:945)
80:	>>>	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:886)
79:	>>>	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1626)
78:	>>>java.sql.SQLException: Invalid argument value,  message from server:
"Duplicate entry '/' for key 2"
77:	>>>Root cause:
76:	>>>-----------
75:	>>	at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
74:	>>	at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
73:	>>	at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
72:	>>	at java.lang.Class.newInstance(Class.java:259)
71:	>>	at java.lang.Class.newInstance0(Class.java:306)
70:	>>	at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
69:	>>	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc
torAccessorImpl.java:27)
68:	>>	at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcces
sorImpl.java:39)
67:	>>	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
66:	>>	at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
65:	>>	at com.opencms.core.OpenCms.<init>(OpenCms.java:255)
64:	>>	at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
63:	>>	at
com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:41
82)
62:	>>	at
com.opencms.file.mySql.CmsResourceBroker.createDbAccess(CmsResourceBroker.ja
va:62)
61:	>>	at com.opencms.file.mySql.CmsDbAccess.<init>(CmsDbAccess.java:125)
60:	>>	at
com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:300)
59:	>>	at
com.opencms.file.mySql.CmsDbAccess.fillDefaults(CmsDbAccess.java:603)
58:	>>	at
com.opencms.file.genericSql.CmsDbAccess.createFolder(CmsDbAccess.java:1165)
57:	>>root cause was java.sql.SQLException: Invalid argument value,  message
from server: "Duplicate entry '/' for key 2"
56:	>>com.opencms.core.CmsException: 4 Sql exception. Detailed error:
[com.opencms.file.mySql.CmsDbAccess] Invalid argument value,  message from
server: "Duplicate entry '/' for key 2".
55:	>>Root cause:
54:	>>-----------
53:	>	at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
52:	>	at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
51:	>	at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
50:	>	at java.lang.Class.newInstance(Class.java:259)
49:	>	at java.lang.Class.newInstance0(Class.java:306)
48:	>	at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
47:	>	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc
torAccessorImpl.java:27)
46:	>	at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcces
sorImpl.java:39)
45:	>	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
44:	>	at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
43:	>	at com.opencms.core.OpenCms.<init>(OpenCms.java:255)
42:	>	at com.opencms.file.CmsRbManager.init(CmsRbManager.java:100)
41:	>root cause was java.sql.SQLException: Invalid argument value,  message
from server: "Duplicate entry '/' for key 2"
40:	>root cause was com.opencms.core.CmsException: 4 Sql exception. Detailed
error: [com.opencms.file.mySql.CmsDbAccess] Invalid argument value,  message
from server: "Duplicate entry '/' for key 2".
39:	>com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed
error: Critical error while loading resourcebroker.
38:	>Root cause:
37:	>-----------
36:		at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
35:		at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
34:		at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
33:		at java.lang.Class.newInstance(Class.java:259)
32:		at java.lang.Class.newInstance0(Class.java:306)
31:		at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
30:		at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc
torAccessorImpl.java:27)
29:		at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcces
sorImpl.java:39)
28:		at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
27:		at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
26:		at com.opencms.core.OpenCms.<init>(OpenCms.java:259)
25:	root cause was java.sql.SQLException: Invalid argument value,  message
from server: "Duplicate entry '/' for key 2"
24:	root cause was com.opencms.core.CmsException: 4 Sql exception. Detailed
error: [com.opencms.file.mySql.CmsDbAccess] Invalid argument value,  message
from server: "Duplicate entry '/' for key 2".
23:	root cause was com.opencms.core.CmsException: 33 Resourcebroker-init
error. Detailed error: Critical error while loading resourcebroker.
22:	com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed
error: Database init failed.
21:	. Critical init error/3: com.opencms.core.CmsException: Critical error
while loading resourcebroker
20:	[CmsRbManager] Critical error while loading resourcebroker
19:	. Database fill default: yes
18:	. Using digest encoding: MD5 from SUN version 1.2
17:	. Digest file encoding : UTF-8
16:	. Digest configured    : MD5
15:	. Database backup pool : jdbc:opencmspool:mysqlbackup
14:	. Database online pool : jdbc:opencmspool:mysqlonline
13:	. Database offline pool: jdbc:opencmspool:mysql
12:	. Database access init : ok
11:	. Resource broker init : phase 3 ok - creating db access module
10:	. Resource broker init : phase 2 ok - initializing database
9:	. Resource broker init : phase 1 ok - starting