Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-15747

RedHat Mysql DB Upgrade - 'Table act_ge_property doesn't exist' error

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 4.2.6
    • Fix Version/s: 4.2.6
    • Component/s: Upgrades
    • Labels:
      None
    • Environment:
      MysqlDB / MariaDB on RedHat
      Alfresco version prior to 4.2.6 on Tomcat
      Alfresco 4.2.6 on Tomcat

      Description

      Preconditions:
      Mysql DB/Maria DB server must be installed on RedHat.

      Steps
      1. Install any Alfresco version prior to 4.2.6 (I reproduced the issue using 4.0.2.1 build3 and 4.2.5.1 versions)
      2. Configure Alfresco with Mysql database (used version:* MySql 5.6.17 and MariaDB 10.0.17*)
      3. Start alfresco and perform some actions (create site, upload documents, create tasks)
      4. Stop Alfresco
      5. Install Alfresco 4.2.6 (I used 4.2.6 build18 and 4.2.6 build27)
      6. Configure Alfresco 4.2.6 with Mysql database
      7. Upgrade the previous installed version to 4.2.6 (4.2.6 points to the CS and DB of the previous installed Alfresco)
      8. Verify the Alfresco.log file of 4.2.6 version

      Expected
      The upgrade is successful.

      Actual
      The upgrade fails with the following error:
      ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'alfresco2.act_ge_property' doesn't exist

      Note: See attached logs with errors.
      With Mysql server installed on Windows the upgrade is successful.
      Upgrade from 4.0.2 to 4.2.5 is successful with Mysql on RedHat

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedbugs Closed Bugs (Inactive)
                  Reporter:
                  mmurarasu Marius Murarasu [X] (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  7 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 1 day, 15 minutes
                    1d 15m

                      Structure Helper Panel