Skip to content

[11.0->12.0] queue_job module is not upgraded correctly (postgres trigger is missing) #262

@legalsylvain

Description

@legalsylvain

Hi all,

I faced an issue, with a database that comes from 11.0, with queue_job installed, when I migrated the database to 12.0.

After a (loooong !) investigation, the database is not correctly set, because this script is not executed.

  • The script doesn't exist in V11.
  • The script is only executed on the installation of the module (not during the update / upgrade process)

To check if the database is OK, you can run the following script :
select * from information_schema.triggers;

if there are no result, queue_job will not work correctly.

I think that moving the script from a post_init_hook to a migrations folder could fix the bug.

What do you think ?

Thanks.

CC : @guewen

Metadata

Metadata

Assignees

No one assigned

    Labels

    stalePR/Issue without recent activity, it'll be soon closed automatically.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions