<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-signature">
<div class="moz-text-flowed" style="font-family: -moz-fixed;
font-size: 14px;" lang="x-unicode">I have two databases
registered in While running a 9.5.2 -> 9.5.3 update I'm
getting an error.
<br>
Could it be that the update process cannot cope with db.pools?
<br>
My opencms.properties is:
<br>
db.pools=\
<br>
default,\
<br>
application
<br>
<br>
<br>
<br>
61: ... DB Update finished.
<br>
60: ... DB Update finished for default.
<br>
59: executing query: ALTER TABLE CMS_USERS MODIFY
USER_PASSWORD VARCHAR(255) BINARY
<br>
58: table CMS_USER_PUBLISH_LIST already exists
<br>
57: table CMS_REWRITES already exists
<br>
56: table CMS_ALIASES already exists
<br>
55: table CMS_SUBSCRIPTION_VISIT already exists
<br>
54: table CMS_SUBSCRIPTION already exists
<br>
53: table CMS_ONLINE_URLNAME_MAPPINGS already exists
<br>
52: table CMS_OFFLINE_URLNAME_MAPPINGS already exists
<br>
51: table CMS_COUNTERS already exists
<br>
50: table CMS_LOG already exists
<br>
49:
org.opencms.setup.db.update7to8.mysql.CmsUpdateDBNewTables.internalExecute(CmsUpdateDBNewTables.java:72)<br>
48: Table engine: MYISAM
<br>
47: Database User: root
<br>
46: JDBC Connection Url Params: ?characterEncoding=UTF-8
<br>
45: JDBC Connection Url: jdbc:mysql://localhost:3306/opencms
<br>
44: JDBC Driver: org.gjt.mm.mysql.Driver
<br>
43: Starting DB Update for pool default...
<br>
42: ... DB Update finished for application.
<br>
41: at
org.opencms.setup.db.CmsUpdateDBThread.run(CmsUpdateDBThread.java:132)
<br>
40: at
org.opencms.setup.db.CmsUpdateDBManager.run(CmsUpdateDBManager.java:286)
<br>
39: at
org.opencms.setup.db.CmsUpdateDBManager.updateDatabase(CmsUpdateDBManager.java:333)<br>
38: at
org.opencms.setup.db.A_CmsUpdateDBPart.execute(A_CmsUpdateDBPart.java:77)<br>
37: at
org.opencms.setup.db.update7to8.CmsUpdatePasswordColumn.internalExecute(CmsUpdatePasswordColumn.java:68)<br>
36: at
org.opencms.setup.CmsSetupDb.updateSqlStatement(CmsSetupDb.java:615)
<br>
35: at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2361)<br>
34: at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2377)<br>
33: at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460)<br>
32: at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)<br>
31: at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
<br>
30: at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
<br>
29: at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
<br>
28: at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
<br>
27: at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
<br>
26: at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
<br>
25: at com.mysql.jdbc.Util.getInstance(Util.java:386)
<br>
24: at
com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
<br>
23: at java.lang.reflect.Constructor.newInstance(Unknown
Source)
<br>
22: at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
<br>
21: at
sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)
<br>
20: at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
<br>
19:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'myapp.cms_users' doesn't exist
<br>
18: executing query: ALTER TABLE CMS_USERS MODIFY
USER_PASSWORD VARCHAR(255) BINARY
<br>
17: executing query: CREATE TABLE CMS_USER_PUBLISH_LIST
(USER_ID VARCHAR(36) BINARY NOT NULL,STRUCTURE_ID VARCHAR(36)
BINARY NOT NULL,DATE_CHANGED BIGINT NOT NULL,PRIMARY
KEY(USER_ID, STRUCTURE_ID),INDEX CMS_USERPUB_01_IDX
(USER_ID),INDEX CMS_USERPUB_02_IDX (STRUCTURE_ID)) ENGINE =
MYISAM CHARACTER SET UTF8;
<br>
16: executing query: CREATE TABLE CMS_REWRITES ( ID
VARCHAR(36) NOT NULL, ALIAS_MODE INTEGER NOT NULL, PATTERN
VARCHAR(255) NOT NULL, REPLACEMENT VARCHAR(255) NOT NULL,
SITE_ROOT VARCHAR(64) NOT NULL, INDEX CMS_REWRITES_IDX_01
(SITE_ROOT), PRIMARY KEY (ID) )
<br>
15: executing query: CREATE TABLE CMS_ALIASES (path
VARCHAR(256) NOT NULL, site_root VARCHAR(64) NOT NULL,
alias_mode INTEGER NOT NULL, structure_id VARCHAR(36) NOT NULL,
PRIMARY KEY (path, site_root), INDEX CMS_ALIASES_IDX_1
(structure_id) ) ENGINE = MYISAM CHARACTER SET UTF8;
<br>
14: executing query: CREATE TABLE CMS_SUBSCRIPTION_VISIT
(USER_ID VARCHAR(36) BINARY NOT NULL,VISIT_DATE BIGINT NOT
NULL,STRUCTURE_ID VARCHAR(36) BINARY,PRIMARY KEY(USER_ID,
VISIT_DATE),UNIQUE INDEX CMS_SUBSCRIPTION_VISIT_UNIQUE_IDX
(USER_ID, VISIT_DATE, STRUCTURE_ID),INDEX
CMS_SUBSCRIPTION_VISIT_01_IDX (USER_ID),INDEX
CMS_SUBSCRIPTION_VISIT_02_IDX (STRUCTURE_ID),INDEX
CMS_SUBSCRIPTION_VISIT_03_IDX (VISIT_DATE),INDEX
CMS_SUBSCRIPTION_VISIT_04_IDX (USER_ID, STRUCTURE_ID),INDEX
CMS_SUBSCRIPTION_VISIT_05_IDX (USER_ID, VISIT_DATE),INDEX
CMS_SUBSCRIPTION_VISIT_06_IDX (USER_ID, STRUCTURE_ID,
VISIT_DATE)) ENGINE = MYISAM CHARACTER SET UTF8;
<br>
13: executing query: CREATE TABLE CMS_SUBSCRIPTION
(PRINCIPAL_ID VARCHAR(36) BINARY NOT NULL,STRUCTURE_ID
VARCHAR(36) BINARY NOT NULL,DATE_DELETED BIGINT NOT NULL,PRIMARY
KEY(PRINCIPAL_ID, STRUCTURE_ID),INDEX PRINCIPAL_ID_IDX
(PRINCIPAL_ID),INDEX STRUCTURE_ID_IDX (STRUCTURE_ID),INDEX
DATE_DELETED_IDX (DATE_DELETED),INDEX SUBSCRIPTION_ALL_IDX
(PRINCIPAL_ID, STRUCTURE_ID, DATE_DELETED)) ENGINE = MYISAM
CHARACTER SET UTF8;
<br>
12: executing query: CREATE TABLE CMS_ONLINE_URLNAME_MAPPINGS
(NAME VARCHAR(255) NOT NULL,STRUCTURE_ID VARCHAR(36) NOT
NULL,STATE INT NOT NULL,DATE_CHANGED BIGINT NOT NULL,LOCALE
VARCHAR(10),INDEX CMS_ONLINE_URLNAME_MAPPINGS_01_IDX
(NAME),INDEX CMS_ONLINE_URLNAME_MAPPINGS_02_IDX (STRUCTURE_ID))
ENGINE = MYISAM CHARACTER SET UTF8;
<br>
11: executing query: CREATE TABLE
CMS_OFFLINE_URLNAME_MAPPINGS (NAME VARCHAR(255) NOT
NULL,STRUCTURE_ID VARCHAR(36) NOT NULL,STATE INT NOT
NULL,DATE_CHANGED BIGINT NOT NULL,LOCALE VARCHAR(10),INDEX
CMS_OFFLINE_URLNAME_MAPPINGS_01_IDX (NAME),INDEX
CMS_OFFLINE_URLNAME_MAPPINGS_02_IDX (STRUCTURE_ID)) ENGINE =
MYISAM CHARACTER SET UTF8;
<br>
10: executing query: CREATE TABLE CMS_COUNTERS (NAME
VARCHAR(255) NOT NULL,COUNTER INT NOT NULL,PRIMARY KEY(NAME))
ENGINE = MYISAM CHARACTER SET UTF8;
<br>
9: executing query: CREATE TABLE CMS_LOG (USER_ID VARCHAR(36)
BINARY NOT NULL,LOG_DATE BIGINT NOT NULL,STRUCTURE_ID
VARCHAR(36) BINARY,LOG_TYPE INT NOT NULL,LOG_DATA
VARCHAR(1024),PRIMARY KEY(USER_ID, LOG_DATE, LOG_TYPE,
STRUCTURE_ID),UNIQUE INDEX CMS_LOG_UNIQUE_IDX (USER_ID,
LOG_DATE, STRUCTURE_ID),INDEX CMS_LOG_01_IDX (USER_ID),INDEX
CMS_LOG_02_IDX (STRUCTURE_ID),INDEX CMS_LOG_03_IDX
(LOG_DATE),INDEX CMS_LOG_04_IDX (LOG_TYPE),INDEX CMS_LOG_05_IDX
(USER_ID, STRUCTURE_ID),INDEX CMS_LOG_06_IDX (USER_ID,
LOG_DATE),INDEX CMS_LOG_07_IDX (USER_ID, STRUCTURE_ID,
LOG_DATE),INDEX CMS_LOG_08_IDX (USER_ID, LOG_DATE, LOG_TYPE))
ENGINE = MYISAM CHARACTER SET UTF8
<br>
8:
org.opencms.setup.db.update7to8.mysql.CmsUpdateDBNewTables.internalExecute(CmsUpdateDBNewTables.java:72)<br>
7: Table engine: MYISAM
<br>
6: Database User: root
<br>
5: JDBC Connection Url Params: null
<br>
4: JDBC Connection Url: jdbc:mysql://localhost:3306/myapp
<br>
3: JDBC Driver: org.gjt.mm.mysql.Driver
<br>
2: Starting DB Update for pool application...
<br>
1: Starting DB Update...
<br>
<br>
<br>
<div class="moz-txt-sig"><span class="moz-txt-tag">-- <br>
</span>Chris Christoph P. U. Kukulies kukulies (at)
rwth-aachen.de
<br>
</div>
</div>
</div>
</body>
</html>