Failing: Upgrade from 11.2-BETA3 to 11.2-RC1 - database is locked

[MatthewSteinhoff]

We've tried to upgrade from 11.2-BETA3 to RC1 twice. Both times we've received a 'database is locked' error. Full error below.

We're tight on boot device space but not so tight we should have a problem. After the failed upgrade, we're at 83%...

When an upgrade works, we delete the oldest version and that brings us back down to: 4.7 GiB (63%). (One of these days, we'll swap the 8G USB sticks with something larger. And, by 'one of these days', I mean 'will likely have 8G sticks until the machine is decommissioned in a couple years'.)

Since it is just a release candidate and not the final version, we're not especially concerned. Especially since BETA3 is working like a champ. Just putting this out there in case any of the developers are looking for something to investigate.

Bonus note for the UI team: this message has bothered me for years...

The options should be 'Yes' and 'No' not 'OK' and 'No'.

Cheers,
Matt




Request Method: POST
Request URL: http://freenas-server.fqdn/legacy/system/update/check/?uuid=82{stuff}16
Software Version: FreeNAS-11.2-BETA3 (85d5c7542)
Exception Type: OperationalError
Exception Value:
database is locked
Exception Location: ./freenasUI/freeadmin/sqlite3_ha/base.py in locked_retry, line 389
Server time: Wed, 24 Oct 2018 09:38:44 -0400

Traceback

Environment:

Software Version: FreeNAS-11.2-BETA3 (85d5c7542)
Request Method: POST
Request URL: http://freenas-server.fqdn/legacy/system/update/check/?uuid=82dc31e6d32245bc9ed4442d769baf16


Traceback:
File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
64. return self.cursor.execute(sql, params)
File "./freenasUI/freeadmin/sqlite3_ha/base.py" in execute
412. execute = self.locked_retry(Database.Cursor.execute, query, params)
File "./freenasUI/freeadmin/sqlite3_ha/base.py" in locked_retry
403. raise e
File "./freenasUI/freeadmin/sqlite3_ha/base.py" in locked_retry
389. rv = method(self, *args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/django/core/handlers/exception.py" in inner
42. response = get_response(request)
File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py" in _legacy_get_response
249. response = self._get_response(request)
File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
178. response = middleware_method(request, callback, callback_args, callback_kwargs)
File "./freenasUI/freeadmin/middleware.py" in process_view
163. return login_required(view_func)(request, *view_args, **view_kwargs)
File "/usr/local/lib/python3.6/site-packages/django/contrib/auth/decorators.py" in _wrapped_view
23. return view_func(request, *args, **kwargs)
File "./freenasUI/system/views.py" in update_check
1504. updateobj = models.Update.objects.order_by('-id')[0]
File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py" in __getitem__
295. return list(qs)[0]
File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py" in __iter__
256. self._fetch_all()
File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py" in _fetch_all
1087. self._result_cache = list(self.iterator())
File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py" in __iter__
54. results = compiler.execute_sql()
File "/usr/local/lib/python3.6/site-packages/django/db/models/sql/compiler.py" in execute_sql
835. cursor.execute(sql, params)
File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
64. return self.cursor.execute(sql, params)
File "/usr/local/lib/python3.6/site-packages/django/db/utils.py" in __exit__
94. six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python3.6/site-packages/django/utils/six.py" in reraise
685. raise value.with_traceback(tb)
File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py" in execute
64. return self.cursor.execute(sql, params)
File "./freenasUI/freeadmin/sqlite3_ha/base.py" in execute
412. execute = self.locked_retry(Database.Cursor.execute, query, params)
File "./freenasUI/freeadmin/sqlite3_ha/base.py" in locked_retry
403. raise e
File "./freenasUI/freeadmin/sqlite3_ha/base.py" in locked_retry
389. rv = method(self, *args, **kwargs)

Exception Type: OperationalError at /legacy/system/update/check/
Exception Value: database is locked

 

[dlavigne]

You shouldn't be getting a traceback. Please create a report at bugs.freenas.org and post the issue number here.

 

[MatthewSteinhoff]

As it was written, so it was done:

Bug #53485 = Failing: Upgrade from 11.2-BETA3 to 11.2-RC1 - database is locked

Bug #53494 = Invalid Choice When Deleting Boot Environment

Cheers,
Matt