Table 'audit_auditevent' already exists when upgrade from 6.2 to 7.0

• Type: Bug
• Status: Closed
• Resolution: Duplicate
• Affects Version/s: 7.0.X EE
• Fix Version/s: 7.0.X EE, Master
• Component/s: Portal Services, Portal Services > Auditing
• Labels:
  • ee-ts
• Git Pull Request: https://github.com/mhan810/liferay-portal-ee/pull/213

Description

Upgrade fails with an error. The issue doesn't exist in master because the module doesn't exist in master.

Reproduction Steps

1. Start up Liferay 6.2 EE SP15
2. Deploy Audit portlet
3. Shut down the portal
4. In Liferay DXP 7.0 SP2/tools/portal-tools-db-upgrade-client, run the command "java -jar com.liferay.portal.tools.db.upgrade.client.jar" and go through upgrade wizard
5. Wait for the upgrade process to complete.

Actual Result: An error occurs as the following

07:26:31,698 ERROR [main][com_liferay_portal_upgrade:97] Invocation to listener threw exception
java.lang.RuntimeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'audit_auditevent' already exists

Expected Result: No error occurs and upgrade is successful.