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

IT jobs failing under Windows due to bad cleanup of Drive database

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.6.0-HF25, 5.8
    • Component/s: Nuxeo Drive
    • Backlog priority:
      980

      Description

      Since new columns have been added to the device_config table:

      > lessmsi\lessmsi /x dist\nuxeo-drive-1.2013.0926-win32.msi nxdrive_msi
      19:45:00 Extracting 'C:\Jenkins\workspace\IT-nuxeo-drive-5.6.0-windows\dist\nuxeo-drive-1.2013.0926-win32.msi' to 'C:\Jenkins\workspace\IT-nuxeo-drive-5.6.0-windows\nxdrive_msi'.
      19:45:00 > nxdrive_msi\SourceDir\ndrive.exe test
      19:45:00 Traceback (most recent call last):
      19:45:00   File "C:\Python27\lib\site-packages\cx_Freeze\initscripts\Console.py", line 27, in <module>
      19:45:00     exec code in m.__dict__
      19:45:00   File "nuxeo-drive-client/scripts/ndrive", line 6, in <module>
      19:45:00     sys.exit(main())
      19:45:00   File "nuxeo-drive-client\nxdrive\commandline.py", line 489, in main
      19:45:00     return CliHandler().handle(argv)
      19:45:00   File "nuxeo-drive-client\nxdrive\commandline.py", line 309, in handle
      19:45:00     timeout=options.timeout)
      19:45:00   File "nuxeo-drive-client\nxdrive\controller.py", line 103, in __init__
      19:45:00     device_config = self.get_device_config()
      19:45:00   File "nuxeo-drive-client\nxdrive\controller.py", line 129, in get_device_config
      19:45:00     return session.query(DeviceConfig).one()
      19:45:00   File "C:\Users\nuxeo\AppData\Roaming\Python\Python27\site-packages\sqlalchemy\orm\query.py", line 2184, in one
      19:45:00     ret = list(self)
      19:45:00   File "C:\Users\nuxeo\AppData\Roaming\Python\Python27\site-packages\sqlalchemy\orm\query.py", line 2227, in __iter__
      19:45:00     return self._execute_and_instances(context)
      19:45:00   File "C:\Users\nuxeo\AppData\Roaming\Python\Python27\site-packages\sqlalchemy\orm\query.py", line 2242, in _execute_and_instances
      19:45:00     result = conn.execute(querycontext.statement, self._params)
      19:45:00   File "C:\Users\nuxeo\AppData\Roaming\Python\Python27\site-packages\sqlalchemy\engine\base.py", line 1449, in execute
      19:45:00     params)
      19:45:00   File "C:\Users\nuxeo\AppData\Roaming\Python\Python27\site-packages\sqlalchemy\engine\base.py", line 1584, in _execute_clauseelement
      19:45:00     compiled_sql, distilled_params
      19:45:00   File "C:\Users\nuxeo\AppData\Roaming\Python\Python27\site-packages\sqlalchemy\engine\base.py", line 1698, in _execute_context
      19:45:00     context)
      19:45:00   File "C:\Users\nuxeo\AppData\Roaming\Python\Python27\site-packages\sqlalchemy\engine\base.py", line 1691, in _execute_context
      19:45:00     context)
      19:45:00   File "C:\Users\nuxeo\AppData\Roaming\Python\Python27\site-packages\sqlalchemy\engine\default.py", line 331, in do_execute
      19:45:00     cursor.execute(statement, parameters)
      19:45:00 sqlalchemy.exc.OperationalError: (OperationalError) no such column: device_config.proxy_config u'SELECT device_config.device_id AS device_config_device_id, device_config.proxy_config AS device_config_proxy_config, device_config.proxy_type AS device_config_proxy_type, device_config.proxy_server AS device_config_proxy_server, device_config.proxy_port AS device_config_proxy_port, device_config.proxy_authenticated AS device_config_proxy_authenticated, device_config.proxy_username AS device_config_proxy_username, device_config.proxy_password AS device_config_proxy_password, device_config.proxy_exceptions AS device_config_proxy_exceptions \nFROM device_config' ()
      19:45:00 Command nxdrive_msi\SourceDir\ndrive.exe test returned with code 1
      

        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