Development #49168
instabilité du build sur test des migrations SQL
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
Mis à jour par Frédéric Péters il y a plus d'un an
- Statut changé de Nouveau à Fermé
Pas vu depuis https://jenkins.entrouvert.org/job/wcs/2285/display/redirect (février 2021).