Projet

Général

Profil

Development #49168

instabilité du build sur test des migrations SQL

Ajouté par Benjamin Dauvergne il y a plus de 3 ans. Mis à jour il y a plus d'un an.

Statut:
Fermé
Priorité:
Bas
Assigné à:
-
Version cible:
-
Début:
07 décembre 2020
Echéance:
% réalisé:

0%

Temps estimé:
Patch proposed:
Non
Planning:
Non

Description

Vu sur le build d'un commit qui ne touchait pas au migration, c'est revenu à la normale en relançant :

py3-django111-pylint-coverage.tests.test_sql.test_migration_12_users_fts (from (junit.xml))  :

Message d'erreur

AssertionError: assert True is False
 +  where True = <function guard_postgres.<locals>.f at 0x7f13fe14a488>('user', conn=<connection object at 0x7f13f9342ae8; dsn: 'dbname=wcstests11176 user=jenkins', closed: 0>, cur=<cursor object at 0x7f13f94f17c8; closed: 0>)
 +    where <function guard_postgres.<locals>.f at 0x7f13fe14a488> = sql.is_reindex_needed

Pile d'exécution

@postgresql
    def test_migration_12_users_fts():
        conn, cur = sql.get_connection_and_cursor()
        cur.execute('UPDATE wcs_meta SET value = 11 WHERE key = %s', ('sql_level',))

        sql.SqlUser.wipe()

        user = sql.SqlUser()
        user.name = 'Pierre'
        user.store()

        # remove the fts column
        cur.execute('ALTER TABLE users DROP COLUMN fts')
        assert not column_exists_in_table(cur, 'users', 'fts')
        sql.migrate()

        assert column_exists_in_table(cur, 'users', 'fts')
        assert migration_level(cur) >= 12

        # no fts, migration only prepare re-index
        assert len(sql.SqlUser.get_ids_from_query('pierre')) == 0

        assert sql.is_reindex_needed('user', conn=conn, cur=cur) is True
        assert sql.is_reindex_needed('formdata', conn=conn, cur=cur) is True
        call_command('cron')  # first cron = reindex
>       assert sql.is_reindex_needed('user', conn=conn, cur=cur) is False
E       AssertionError: assert True is False
E        +  where True = <function guard_postgres.<locals>.f at 0x7f13fe14a488>('user', conn=<connection object at 0x7f13f9342ae8; dsn: 'dbname=wcstests11176 user=jenkins', closed: 0>, cur=<cursor object at 0x7f13f94f17c8; closed: 0>)
E        +    where <function guard_postgres.<locals>.f at 0x7f13fe14a488> = sql.is_reindex_needed

tests/test_sql.py:1203: AssertionError

py3-django111-pylint-coverage.tests.test_sql.test_migration_21_users_ascii_name (from (junit.xml)) 

Message d'erreur

AssertionError: assert True is False
 +  where True = <function guard_postgres.<locals>.f at 0x7f13fe14a488>('user', conn=<connection object at 0x7f13f9342ae8; dsn: 'dbname=wcstests11176 user=jenkins', closed: 0>, cur=<cursor object at 0x7f13f94f1318; closed: 0>)
 +    where <function guard_postgres.<locals>.f at 0x7f13fe14a488> = sql.is_reindex_needed

Pile d'exécution

@postgresql
    def test_migration_21_users_ascii_name():
        conn, cur = sql.get_connection_and_cursor()
        cur.execute('UPDATE wcs_meta SET value = 11 WHERE key = %s', ('sql_level',))

        sql.SqlUser.wipe()

        user = sql.SqlUser()
        user.name = 'Jean Sénisme'
        user.store()

        # remove the ascii_name column
        cur.execute('ALTER TABLE users DROP COLUMN ascii_name')
        assert not column_exists_in_table(cur, 'users', 'ascii_name')
        sql.migrate()

        assert column_exists_in_table(cur, 'users', 'ascii_name')
        assert migration_level(cur) >= 21

        # no fts, migration only prepare re-index
        assert sql.SqlUser.count([st.Equal('ascii_name', 'jean senisme')]) == 0

        assert sql.is_reindex_needed('user', conn=conn, cur=cur) is True
        assert sql.is_reindex_needed('formdata', conn=conn, cur=cur) is True
        call_command('cron')  # first cron = reindex
>       assert sql.is_reindex_needed('user', conn=conn, cur=cur) is False
E       AssertionError: assert True is False
E        +  where True = <function guard_postgres.<locals>.f at 0x7f13fe14a488>('user', conn=<connection object at 0x7f13f9342ae8; dsn: 'dbname=wcstests11176 user=jenkins', closed: 0>, cur=<cursor object at 0x7f13f94f1318; closed: 0>)
E        +    where <function guard_postgres.<locals>.f at 0x7f13fe14a488> = sql.is_reindex_needed

tests/test_sql.py:1238: AssertionError

Historique

#1

Mis à jour par Frédéric Péters il y a plus d'un an

  • Statut changé de Nouveau à Fermé

Formats disponibles : Atom PDF