MatthewSteinhoff
Guru
- Joined
- Feb 2, 2016
- Messages
- 574
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
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