-
Type:
Bug
-
Status: Verified
-
Resolution: Unresolved
-
Affects Version/s: 7.0.X, 7.1.X, Master
-
Fix Version/s: None
-
Labels:
-
Fix Priority:2
-
Databases:DB2 11.1
-
QA Test Name:
-
QA Test Score:25
Steps to reproduce issue:
- Import the attached 7.0.10.6 database into DB2 11.1
- Upgrade database
- Expected result: Upgrade executes successfully without SQL syntax errors
- Actual results: SQL syntax errors are thrown:
2018-12-12 08:07:24.821 WARN [main][BaseDB:487] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=exists;drop table if ;NPS_DOUBLE_DOT, DRIVER=4.24.92: drop table if exists KaleoTaskForm; WARN - DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=exists;drop table if ;NPS_DOUBLE_DOT, DRIVER=4.24.92: drop table if exists KaleoTaskForm; 2018-12-12 08:07:25.022 WARN [main][BaseDB:487] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=exists;drop table if ;NPS_DOUBLE_DOT, DRIVER=4.24.92: drop table if exists KaleoTaskFormInstance; WARN - DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=exists;drop table if ;NPS_DOUBLE_DOT, DRIVER=4.24.92: drop table if exists KaleoTaskFormInstance; 2018-12-12 08:07:25.220 WARN [main][BaseDB:487] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=exists;drop table if ;NPS_DOUBLE_DOT, DRIVER=4.24.92: drop table if exists KaleoDefinitionVersion; WARN - DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=exists;drop table if ;NPS_DOUBLE_DOT, DRIVER=4.24.92: drop table if exists KaleoDefinitionVersion;
- Start up portal
- Expected result: No SQL syntax errors are thrown
- Actual result: SQL syntax errors are thrown
2018-12-12 08:07:31.810 WARN [main][UpgradeProcess:447] Attempting to upgrade table LayoutSetPrototype by recreating the table due to: DB2 SQL Error: SQLCODE=-190, SQLSTATE=42837, SQLERRMC=ROOT.LAYOUTSETPROTOTYPE;NAME, DRIVER=4.24.92 WARN - Attempting to upgrade table LayoutSetPrototype by recreating the table due to: DB2 SQL Error: SQLCODE=-190, SQLSTATE=42837, SQLERRMC=ROOT.LAYOUTSETPROTOTYPE;NAME, DRIVER=4.24.92 2018-12-12 08:07:31.810 INFO [main][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#LayoutSetPrototype INFO - Starting com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#LayoutSetPrototype 2018-12-12 08:07:31.811 INFO [main][Table:168] Starting backup of LayoutSetPrototype to /tmp/temp-db-LayoutSetPrototype-4096692390939125030.tmp INFO - Starting backup of LayoutSetPrototype to /tmp/temp-db-LayoutSetPrototype-4096692390939125030.tmp 2018-12-12 08:07:31.814 INFO [main][Table:204] Finished backup of LayoutSetPrototype to /tmp/temp-db-LayoutSetPrototype-4096692390939125030.tmp in 3 ms INFO - Finished backup of LayoutSetPrototype to /tmp/temp-db-LayoutSetPrototype-4096692390939125030.tmp in 3 ms 2018-12-12 08:07:32.156 INFO [main][LoggingTimer:43] Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#LayoutSetPrototype in 346 ms INFO - Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#LayoutSetPrototype in 346 ms 2018-12-12 08:07:32.157 WARN [main][UpgradeProcess:466] Successfully recreated and upgraded table LayoutSetPrototype WARN - Successfully recreated and upgraded table LayoutSetPrototype
Reproduced on:
Tomcat 9.0.10 + DB2 11.1
Portal master GIT ID: 17920c8d2d94e155e34b593a5389e49b8ae34e57