Skip to content

Instantly share code, notes, and snippets.

@davidjb
Last active December 6, 2020 23:22
Show Gist options
  • Save davidjb/be2849b5bbb5d4c3e3db1e317d644a17 to your computer and use it in GitHub Desktop.
Save davidjb/be2849b5bbb5d4c3e3db1e317d644a17 to your computer and use it in GitHub Desktop.
Log output of failing tests on SQL Server for https://github.com/wagtail/wagtail/pull/6607
$ DATABASE_ENGINE=sql_server.pyodbc DATABASE_DRIVER=FreeTDS DATABASE_HOST=localhost DATABASE_PORT=1433 DATABASE_USER=sa DATABASE_PASSWORD='yourStrong(!)Password' python runtests.py
Creating test database for alias 'default'...
Got an error creating the test database: ('42000', "[42000] [FreeTDS][SQL Server]Database 'test_wagtail' already exists. Choose a different database name. (1801) (SQLExecDirectW)")
I Type 'yes' if you would like to try deleting the test database 'test_wagtail', or 'no' to cancel: yes
Destroying old test database for alias 'default'...
System check identified no issues (0 silenced).
....................................F..................................................F....................................................................................................................F...............................................................................
......................................................................................................FF......................E.............................................................................................................................................................
............................................................................................................................................................................................................................................................................................
...........s................................................................................................................................................................................................................................................................................
....F......................................................F............................................................................................................F...................................................................................................................
........................................................................................................................................................wagtail/wagtail/contrib/modeladmin/views.py:176: RuntimeWarning: Missing dependency 'author' for prepopulated_f
ield 'title''.
warnings.warn(
....................................sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss......F..............................................................................................................................F.................................................
................................................................................................................................................................................................................................................................xx..........................
............................................................................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................................................................ss......
............sss.....................sssssss.................................................................................................................................................................................................................................................
.....................................ss................................s........................................................................................xxxxxxwagtail/wagtail/search/backends/db.py:67: UserWarning: Database search backend does not support t
erm boosting.
warn('Database search backend does not support term boosting.')
x...................xx...............x....xxx.....x..............sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss................................................sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss.................
...............................sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss................................................................................................................................................................................
............................................................................................................................................................................................................................................................................................
....................................................................................................................
======================================================================
ERROR: test_explore_root (wagtail.admin.tests.pages.test_explorer_view.TestPageExplorer)
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "wagtail/src/django-mssql-backend/sql_server/pyodbc/base.py", line 554, in execute
return self.cursor.execute(sql, params)
pyodbc.ProgrammingError: ('42000', '[42000] [FreeTDS][SQL Server]Statement(s) could not be prepared. (8180) (SQLExecDirectW)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "wagtail/wagtail/admin/tests/pages/test_explorer_view.py", line 61, in test_explore_root
self.assertTrue(response.context['pages'].paginator.object_list.filter(id=self.root_page.id).exists())
File "wagtail/lib/python3.9/site-packages/django/db/models/query.py", line 809, in exists
return self.query.has_results(using=self.db)
File "wagtail/lib/python3.9/site-packages/django/db/models/sql/query.py", line 535, in has_results
return compiler.has_results()
File "wagtail/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1126, in has_results
return bool(self.execute_sql(SINGLE))
File "wagtail/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "wagtail/lib/python3.9/site-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "wagtail/lib/python3.9/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "wagtail/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "wagtail/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "wagtail/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "wagtail/src/django-mssql-backend/sql_server/pyodbc/base.py", line 554, in execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: ('42000', '[42000] [FreeTDS][SQL Server]Statement(s) could not be prepared. (8180) (SQLExecDirectW)')
======================================================================
FAIL: test_ordering_by_random (wagtail.admin.tests.api.test_documents.TestAdminDocumentListing)
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/wagtail/api/v2/tests/test_documents.py", line 216, in test_ordering_by_random
self.assertNotEqual(document_id_list_1, document_id_list_2)
AssertionError: [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12] == [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]
====================================================================== [205/3139]
FAIL: test_ordering_by_random (wagtail.admin.tests.api.test_images.TestAdminImageListing)
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/wagtail/api/v2/tests/test_images.py", line 216, in test_ordering_by_random
self.assertNotEqual(image_id_list_1, image_id_list_2)
AssertionError: [4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] == [4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15]
======================================================================
FAIL: test_ordering_by_random (wagtail.admin.tests.api.test_pages.TestAdminPageListing)
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/wagtail/api/v2/tests/test_pages.py", line 607, in test_ordering_by_random
self.assertNotEqual(page_id_list_1, page_id_list_2)
AssertionError: [2, 4, 5, 6, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23] == [2, 4, 5, 6, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23]
======================================================================
FAIL: test_upload_file_draft (wagtail.admin.tests.pages.test_edit_page.TestPageEdit)
Check that file uploads work when saving a draft
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/wagtail/admin/tests/pages/test_edit_page.py", line 177, in test_upload_file_draft
self.assertEqual(file_page.file_field.name, file_upload.name)
AssertionError: 'draft-file_apMLrji.txt' != 'draft-file.txt'
- draft-file_apMLrji.txt
? --------
+ draft-file.txt
======================================================================
FAIL: test_upload_file_publish (wagtail.admin.tests.pages.test_edit_page.TestPageEdit)
Check that file uploads work when directly publishing
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/wagtail/admin/tests/pages/test_edit_page.py", line 147, in test_upload_file_publish
self.assertEqual(file_page.file_field.name, file_upload.name)
AssertionError: 'published-file_GDtNhfe.txt' != 'published-file.txt'
- published-file_GDtNhfe.txt
? --------
+ published-file.txt
======================================================================
FAIL: test_ordering_by_random (wagtail.api.v2.tests.test_documents.TestDocumentListing)
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/wagtail/api/v2/tests/test_documents.py", line 216, in test_ordering_by_random
self.assertNotEqual(document_id_list_1, document_id_list_2)
AssertionError: [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12] == [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]
======================================================================
FAIL: test_ordering_by_random (wagtail.api.v2.tests.test_images.TestImageListing)
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/wagtail/api/v2/tests/test_images.py", line 216, in test_ordering_by_random
self.assertNotEqual(image_id_list_1, image_id_list_2)
AssertionError: [4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] == [4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15]
======================================================================
FAIL: test_ordering_by_random (wagtail.api.v2.tests.test_pages.TestPageListing)
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/wagtail/api/v2/tests/test_pages.py", line 607, in test_ordering_by_random
self.assertNotEqual(page_id_list_1, page_id_list_2)
$ DATABASE_ENGINE=sql_server.pyodbc DATABASE_DRIVER=FreeTDS DATABASE_HOST=localhost DATABASE_PORT=1433 DATABASE_USER=sa DATABASE_PASSWORD='yourStrong(!)Password' python runtests.py
Creating test database for alias 'default'...
....................................F..................................................F....................................................................................................................F...............................................................................
..............................................................................................................................E.............................................................................................................................................................
............................................................................................................................................................................................................................................................................................
...........s................................................................................................................................................................................................................................................................................
....F......................................................F............................................................................................................F...................................................................................................................
........................................................................................................................................................wagtail/wagtail/contrib/modeladmin/views.py:176: RuntimeWarning: Missing dependency 'author' for prepopulated_f
ield 'title''.
warnings.warn(
....................................sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss......F..............................................................................................................................F.................................................
................................................................................................................................................................................................................................................................xx..........................
............................................................................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................................................................ss......
............sss.....................sssssss.................................................................................................................................................................................................................................................
.....................................ss................................s........................................................................................xxxxxxwagtail/wagtail/search/backends/db.py:67: UserWarning: Database search backend does not support t
erm boosting.
warn('Database search backend does not support term boosting.')
x...................xx...............x....xxx.....x..............sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss................................................sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss.................
...............................sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss................................................................................................................................................................................
............................................................................................................................................................................................................................................................................................
....................................................................................................................
======================================================================
ERROR: test_explore_root (wagtail.admin.tests.pages.test_explorer_view.TestPageExplorer)
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "wagtail/src/django-mssql-backend/sql_server/pyodbc/base.py", line 554, in execute
return self.cursor.execute(sql, params)
pyodbc.ProgrammingError: ('42000', '[42000] [FreeTDS][SQL Server]Statement(s) could not be prepared. (8180) (SQLExecDirectW)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "wagtail/wagtail/admin/tests/pages/test_explorer_view.py", line 61, in test_explore_root
self.assertTrue(response.context['pages'].paginator.object_list.filter(id=self.root_page.id).exists())
File "wagtail/lib/python3.9/site-packages/django/db/models/query.py", line 809, in exists
return self.query.has_results(using=self.db)
File "wagtail/lib/python3.9/site-packages/django/db/models/sql/query.py", line 535, in has_results
return compiler.has_results()
File "wagtail/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1126, in has_results
return bool(self.execute_sql(SINGLE))
File "wagtail/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "wagtail/lib/python3.9/site-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "wagtail/lib/python3.9/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "wagtail/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "wagtail/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "wagtail/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "wagtail/src/django-mssql-backend/sql_server/pyodbc/base.py", line 554, in execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: ('42000', '[42000] [FreeTDS][SQL Server]Statement(s) could not be prepared. (8180) (SQLExecDirectW)')
======================================================================
FAIL: test_ordering_by_random (wagtail.admin.tests.api.test_documents.TestAdminDocumentListing)
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/wagtail/api/v2/tests/test_documents.py", line 216, in test_ordering_by_random
self.assertNotEqual(document_id_list_1, document_id_list_2)
AssertionError: [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12] == [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]
======================================================================
FAIL: test_ordering_by_random (wagtail.admin.tests.api.test_images.TestAdminImageListing)
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/wagtail/api/v2/tests/test_images.py", line 216, in test_ordering_by_random
self.assertNotEqual(image_id_list_1, image_id_list_2)
AssertionError: [4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] == [4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15]
======================================================================
FAIL: test_ordering_by_random (wagtail.admin.tests.api.test_pages.TestAdminPageListing)
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/wagtail/api/v2/tests/test_pages.py", line 607, in test_ordering_by_random
self.assertNotEqual(page_id_list_1, page_id_list_2)
AssertionError: [2, 4, 5, 6, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23] == [2, 4, 5, 6, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23]
======================================================================
FAIL: test_ordering_by_random (wagtail.api.v2.tests.test_documents.TestDocumentListing)
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/wagtail/api/v2/tests/test_documents.py", line 216, in test_ordering_by_random
self.assertNotEqual(document_id_list_1, document_id_list_2)
AssertionError: [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12] == [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]
======================================================================
FAIL: test_ordering_by_random (wagtail.api.v2.tests.test_images.TestImageListing)
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/wagtail/api/v2/tests/test_images.py", line 216, in test_ordering_by_random
self.assertNotEqual(image_id_list_1, image_id_list_2)
AssertionError: [4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] == [4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15]
======================================================================
FAIL: test_ordering_by_random (wagtail.api.v2.tests.test_pages.TestPageListing)
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/wagtail/api/v2/tests/test_pages.py", line 607, in test_ordering_by_random
self.assertNotEqual(page_id_list_1, page_id_list_2)
AssertionError: [2, 4, 5, 6, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23] == [2, 4, 5, 6, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23]
======================================================================
FAIL: test_import_xlsx_with_cache_store_engine (wagtail.contrib.redirects.tests.test_import_admin_views.TestImportAdminViews)
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/lib/python3.9/site-packages/django/test/utils.py", line 381, in inner
return func(*args, **kwargs)
File "wagtail/wagtail/contrib/redirects/tests/test_import_admin_views.py", line 362, in test_import_xlsx_with_cache_store_engine
self.assertEqual(
AssertionError: 'wagtailadmin/shared/messages.html' != 'wagtailredirects/confirm_import.html'
- wagtailadmin/shared/messages.html
+ wagtailredirects/confirm_import.html
======================================================================
FAIL: test_post_reorder (wagtail.contrib.search_promotions.tests.TestSearchPromotionsEditView)
----------------------------------------------------------------------
Traceback (most recent call last):
File "wagtail/wagtail/contrib/search_promotions/tests.py", line 311, in test_post_reorder
self.assertEqual(Query.get("Hello").editors_picks.all()[0], self.search_pick)
AssertionError: SearchPromotion(query="hello", page="Welcome to your new Wagtail site!") != SearchPromotion(query="hello", page="Root")
----------------------------------------------------------------------
Ran 4126 tests in 4052.875s
FAILED (failures=8, errors=1, skipped=312, expected failures=16)
Destroying test database for alias 'default'...
System check identified no issues (0 silenced).
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment