Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-13710

Drive: SQLite thread-safety issue when running the tests

    XMLWordPrintable

    Details

    • Backlog priority:
      450

      Description

      For example when running

      nosetests -v nxdrive/tests/test_integration_concurrent_synchronization.py:TestIntegrationConcurrentSynchronization.test_delete_local_folder_2_clients
      

      we get:

      2014-02-06 14:02:50,707 20930 140419056961280 ERROR    sqlalchemy.pool.SingletonThreadPool Exception closing connection <sqlite3.Connection object at 0x38a9858>
      Traceback (most recent call last):
        File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 191, in _close_connection
          self._dialect.do_close(connection)
        File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 364, in do_close
          dbapi_connection.close()
      ProgrammingError: SQLite objects created in a thread can only be used in that same thread.The object was created in thread id 140418965513984 and this is thread id 140419056961280
      2014-02-06 14:02:50,709 20930 140419056961280 ERROR    sqlalchemy.pool.SingletonThreadPool Exception closing connection <sqlite3.Connection object at 0x38a9940>
      Traceback (most recent call last):
        File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 191, in _close_connection
          self._dialect.do_close(connection)
        File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 364, in do_close
          dbapi_connection.close()
      ProgrammingError: SQLite objects created in a thread can only be used in that same thread.The object was created in thread id 140418957121280 and this is thread id 140419056961280
      

      Don't know yet if it is only a test issue or a real thread-safety one that could be in the synchronizer, the controller, ....

      This is not blocking as tests are OK.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1 day
                  1d
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 6 hours Time Not Required
                  6h