Skip to content

guestbookresponse table: "ERROR: column "downloadtype" does not exist" after pull request #5863 was merged #5964

@pdurbin

Description

@pdurbin

Ever since pull request #5863 was merged the "deploy" phase of the phoenix tests fail with this error:

Command deploy failed.
remote failure: Error occurred during deployment: Exception while loading the app : javax.ejb.CreateException: Initialization failed for Singleton StartupFlywayMigrator. Please see server.log for more details.

You can see this at https://build.hmdc.harvard.edu:8443/job/phoenix.dataverse.org-deploy-develop/424/console

Here are the errors in server.log:

Caused by: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V4.14.0.2__2043-split-gbr-table.sql failed

SQL State : 42703
Error Code : 0
Message : ERROR: column "downloadtype" does not exist
Hint: There is a column named "downloadtype" in table "filedownload", but it cannot be referenced from this part of the query.
Position: 100
Location : db/migration/V4.14.0.2__2043-split-gbr-table.sql (/usr/local/glassfish4/glassfish/domains/domain1/applications/dataverse/WEB-INF/classes/db/migration/V4.14.0.2__2043-split-gbr-table.sql)
Line : 2
Statement : insert into filedownload(GUESTBOOKRESPONSE_ID,DOWNLOADTYPE,DOWNLOADTIMESTAMP,SESSIONID) select ID, DOWNLOADTYPE,RESPONSETIME,SESSIONID from guestbookresponse

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions