Exception Error during 9.10 Upgrade to 11.1 no such column: system_settings.stg_sysloglevel

OddPrime

Cadet
Joined
Nov 5, 2018
Messages
2
I am upgrading FreeNAS 9.10 to 11.1 via web interface and getting the following Operational Error. My intent is to upgrade this NAS to the latest version. I cannot access the console nor web interface at this time. 9.10 was stable but had what were deemed innocuous errors in the system log according to the posts I observed. I replaced my Cruzer USB with another but it produced the same innocuous errors. Iconfig output shows link is active and dimes shows all peripherals; keyboard, mouse, USB and Drives up and operational. I do know I can reboot back to 9.10 but would prefer to upgrade. I also get this error in the console output loop, "getty repeating too quickly on /dev/ttyv0, sleeping 30 secs". After 30 seconds, it tries again and fails." The exception error was issued during the reboot of 11.1.

Any advice you can impart on how to proceed from this point would be greatly appreciated. There is a very similar post Jan 20, 2018 for this problem but there was no resolution. Member seeking help was Fred Goran Karlsen. Shall I reinstall from a USB stick with 11.1 and re-load my config file?


Request Method:GET
Request URL:<requested URL is web interface IP address that works with 9.10>
Software Version:FreeNAS-11-MASTER-201704201253 (fd84b41)
Exception Type:OperationalError
Exception Value:no such column: system_settings.stg_sysloglevel
Exception Location:./freenasUI/freeadmin/sqlite3_ha/base.py in locked_retry, line 406
Server time:Sun, 20 Feb 2022 23:51:32 -0500

Code:

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
  424.         execute = self.locked_retry(Database.Cursor.execute, query, params)

File "./freenasUI/freeadmin/sqlite3_ha/base.py" in locked_retry
  406.                 rv = method(self, *args, **kwargs)

File "/usr/local/lib/python3.6/site-packages/django/core/handlers/exception.py" in inner
  39.             response = get_response(request)

File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py" in _legacy_get_response
  244.             response = middleware_method(request)

File "./freenasUI/freeadmin/middleware.py" in process_request
  188.                 language = Settings.objects.order_by('-id')[0].stg_language

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
  424.         execute = self.locked_retry(Database.Cursor.execute, query, params)

File "./freenasUI/freeadmin/sqlite3_ha/base.py" in locked_retry
  406.                 rv = method(self, *args, **kwargs)

Exception Type: OperationalError at /
Exception Value: no such column: system_settings.stg_sysloglevel
[ code ]


Hardware:
BIOS P1.90
ASRock ATX DDR3 1333 LGA 1150 Motherboard H97 PRO4
Intel 5 Pentium(R) CPU G3240 RAM @ 3.10 GHz
2 - Kingston RAM @ 4 GB 1600 MHz PC3-12800 DDR3 Non-ECC CL11 DIMM SR x 8
OS drive: SanDisk Cruzer Fit 8 GB USB2.0 Low Profile Flash Drive
6 - Hitachi 2 TB HDS723020BLA642, SATA3 U300 7200 RPM 64MB HD RAIDZ2
FreeNAS 9.10 STABLE
 

OddPrime

Cadet
Joined
Nov 5, 2018
Messages
2
It is possible that my USB stick is too slow. Similar threads below my post contains a hardware recommendation against using USB sticks in favor of 16GB SSD. I am investigating what it will take to make this change both hardware and what I need to do to install the boot software. I am running 11.1 now and need to get it installed on the SSD provided my motherboard can accept this internal SSD. Is there a preferred configuration, internal SSD or external SSD?
 
Top