Uploaded image for project: 'The Virtual Brain'
  1. The Virtual Brain
  2. TVB-2846

SQLAlchemy raises exceptions during framework tests

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 2.3
    • None
    • None
    • macOS, conda/pip env, master at 93e85255b9a3
    • VBC Sprint 12
    • 8.2 Pipeline Integration

    Description

      When running the framework test suite, pytest reports 467 passed, 15 skipped, 3131 warnings in 183.85s, and then there are some lines due to exceptions happening in other threads following a `commit()` call inside the dao, starting with (I will attach the full output)

      ============================================================== 467 passed, 15 skipped, 3131 warnings in 183.85s (0:03:03) ===============================================================
      Exception in thread Thread-73:
      Traceback (most recent call last):
        File "/Users/duke/miniconda3/envs/tvb-full-x86/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
          cursor, statement, parameters, context
        File "/Users/duke/miniconda3/envs/tvb-full-x86/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute
          cursor.execute(statement, parameters)
      sqlite3.OperationalError: database is locked
      
      The above exception was the direct cause of the following exception:
      
      Traceback (most recent call last):
      

      I may not have the right versions of all the dependencies, leading to these exceptions, but it was surprising to me that such uncaught exceptions may not be represented in the test results, as I noticed the test script requests test results in an xml format, so this might be going unnoticed.

      Secondarily I noticed the test suite for the framework can't be run with multiple cores for some DB migration reason, which might be a nice improvement, but is not really a bug, later on.

      Gliffy Diagrams

        Attachments

          1. pip-freeze.txt
            4 kB
            Marmaduke Woodman
          2. sa-exc.txt
            19 kB
            Marmaduke Woodman

          Activity

            People

              paula.popa Paula Prodan
              marmaduke.woodman Marmaduke Woodman
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 2 days
                  2d
                  Remaining:
                  Time Spent - 1 day, 4 hours Remaining Estimate - 4 hours
                  4h
                  Logged:
                  Time Spent - 1 day, 4 hours Remaining Estimate - 4 hours
                  1d 4h