Uploaded image for project: 'Guacamole'
  1. Guacamole
  2. GUACAMOLE-777

Automate aspects of schema update with Docker images

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: guacamole-docker
    • Labels:
      None

      Description

      When pulling a newer guacamole  images from guacamole/guacamole:latest upon restart there is a critical DB error.

       

      18-Apr-2019 09:08:16.895 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 4397 ms
      {{09:09:04.896 [http-nio-8080-exec-4] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error: }}
      ### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: relation "guacamole_entity" does not exist
        Position: 571
      ### The error may exist in org/apache/guacamole/auth/jdbc/user/UserMapper.xml
      ### The error may involve defaultParameterMap
      ### The error occurred while setting parameters
      ### SQL: SELECT             guacamole_user.user_id,             guacamole_entity.entity_id,             guacamole_entity.name,             password_hash,             password_salt,             password_date,             disabled,             expired,             access_window_start,             access_window_end,             valid_from,             valid_until,             timezone,             full_name,             email_address,             organization,             organizational_role,             MAX(start_date) AS last_active         FROM guacamole_user         JOIN guacamole_entity ON guacamole_user.entity_id = guacamole_entity.entity_id         LEFT JOIN guacamole_user_history ON guacamole_user_history.user_id = guacamole_user.user_id         WHERE             guacamole_entity.name = ?             AND guacamole_entity.type = 'USER'::guacamole_entity_type         GROUP BY guacamole_user.user_id, guacamole_entity.entity_id;          SELECT             guacamole_user_attribute.user_id,             guacamole_user_attribute.attribute_name,             guacamole_user_attribute.attribute_value         FROM guacamole_user_attribute         JOIN guacamole_user ON guacamole_user.user_id = guacamole_user_attribute.user_id         JOIN guacamole_entity ON guacamole_user.entity_id = guacamole_entity.entity_id         WHERE             guacamole_entity.name = ?             AND guacamole_entity.type = 'USER'::guacamole_entity_type
      ### Cause: org.postgresql.util.PSQLException: ERROR: relation "guacamole_entity" does not exist
        Position: 571

       

       

       

      There ought to be some sort of sanity check when upgrading the DB schema.

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              develroo Don
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: