[migration] Drop cw_schema relation first without this, we ends up with the traceback shown at https://www.cubicweb.org/ticket/16130960. This is not the proper fix, which I have not been able to find. It seems due to this very rare case of deletion of such relation linked to CWRType vs order of execution of operation (in this case, the operation deleting the entity table is run before some other queries using it). As forcing this relation to be deleted before the entity type fixes the problem while this case seems rare enough, IMO this patch is "good enough". Closes #16130960

     1

# Check the CW versions and add the entity only if needed ?

     2

add_entity_type('CWSession')

     3

rql('DELETE CWProperty X WHERE X pkey "system.version.pyramid"',

     4

    ask_confirm=False)

     5

     6

sql('DROP TABLE moved_entities')

     7

sql('ALTER TABLE entities DROP COLUMN asource')

     8

sql('ALTER TABLE entities DROP COLUMN extid')

     9

sql('DROP INDEX entities_type_idx')

    10

    11

# force cw_schema deletion before CWSourceSchemaConfig to avoid nasty bug

    12

drop_relation_type('cw_schema')

    13

drop_entity_type('CWSourceSchemaConfig')