GUI broken after 11.1-u1 update

[pixelbrain]

Hello

The other day I ran the update to FreeNAS 11.1-u1 via the gui. After rebooting the gui goes to the login. When i type the username and password i get the following error pasted below. My addons still work. Im watching plex fine. SSH still works, i can see my data drive mounted. If i access FreeNAS via the network in windows it shows no folders. Can someone help. Relatively new to freenas. Also I downgraded back to 11.1 and its still showing same error prob. Thanks in advance

Code:

Request Method:	  POST	
	
	 Request URL:	  http://192.168.1.118/account/login/	
	
	 Software Version:	  FreeNAS-11.1-U1 (f7e246b8f)	
	
	 Exception Type:	  OperationalError	
	
	 Exception Value:	
no such column: account_bsdusers.bsdusr_attributes
		
	 Exception Location:	  ./freenasUI/freeadmin/sqlite3_ha/base.py in locked_retry, line 389	
	
	 Server time:	  Sun, 21 Jan 2018 15:22:15 +1300

	


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
  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
  187.				 response = self.process_exception_by_middleware(e, request)
File "/usr/local/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
  185.				 response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "./freenasUI/account/views.py" in login_wrapper
  319.		 extra_context=extra_context,
File "/usr/local/lib/python3.6/site-packages/django/contrib/auth/views.py" in inner
  47.		 return func(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/django/views/decorators/debug.py" in sensitive_post_parameters_wrapper
  76.			 return view(request, *args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/django/utils/decorators.py" in _wrapped_view
  149.					 response = view_func(request, *args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/django/views/decorators/cache.py" in _wrapped_view_func
  57.		 response = view_func(request, *args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/django/contrib/auth/views.py" in login
  81.		 if form.is_valid():
File "/usr/local/lib/python3.6/site-packages/django/forms/forms.py" in is_valid
  169.		 return self.is_bound and not self.errors
File "/usr/local/lib/python3.6/site-packages/django/forms/forms.py" in errors
  161.			 self.full_clean()
File "/usr/local/lib/python3.6/site-packages/django/forms/forms.py" in full_clean
  371.		 self._clean_form()
File "/usr/local/lib/python3.6/site-packages/django/forms/forms.py" in _clean_form
  398.			 cleaned_data = self.clean()
File "/usr/local/lib/python3.6/site-packages/django/contrib/auth/forms.py" in clean
  191.			 self.user_cache = authenticate(username=username, password=password)
File "/usr/local/lib/python3.6/site-packages/django/contrib/auth/__init__.py" in authenticate
  74.			 user = backend.authenticate(**credentials)
File "/usr/local/lib/python3.6/site-packages/django/contrib/auth/backends.py" in authenticate
  17.			 user = UserModel._default_manager.get_by_natural_key(username)
File "./freenasUI/account/models.py" in get_by_natural_key
  78.		 return self.get(**{self.model.USERNAME_FIELD: username})
File "/usr/local/lib/python3.6/site-packages/django/db/models/manager.py" in manager_method
  85.				 return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py" in get
  379.		 num = len(clone)
File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py" in __len__
  238.		 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
  389.				 rv = method(self, *args, **kwargs)

Exception Type: OperationalError at /account/login/
Exception Value: no such column: account_bsdusers.bsdusr_attributes

Request information
GET
	
No GET data

POST
				  
		  Variable		  Value		
						  
			csrfmiddlewaretoken			 '1cguzFrq0tr6SGaURh4jOTOeTLCFSb2eKPlYsXkHLqo7zAzy9AMfz4YpG5zHw982'		
				
			username			 'root'		
				
			password			 'mypassword'		
				
			next			 '/'		
				 
FILES
	
No FILES data

COOKIES
				  
		  Variable		  Value		
						  
			csrftoken			 'tkaCvMG0DfaeikwVgY6nmQIk8sfTBBRRcXf6o4zhoc7fZeVzyhOj71SvVMcVfzXF'		
				
			fntreeSaveStateCookie			 'root%2Croot%2F201%2Croot%2F201%2F213%2F215%2Croot%2F201%2F207%2Croot%2F201%2F207%2F209%2Croot%2F201%2F213%2Croot%2F201%2F218%2F220%2Croot%2F201%2F212%2Croot%2F201%2F212%2F214%2Croot%2F201%2F220%2Croot%2F201%2F220%2F222%2Croot%2F196%2F211%2Croot%2F196%2F211%2F213%2Croot%2F75%2F76%2Croot%2F201%2F218%2Croot%2F206%2Croot%2F206%2F229%2Croot%2F206%2F229%2F231%2Croot%2F197%2Croot%2F75%2F76%2F77%2Croot%2F196%2F207%2Croot%2F196%2F207%2F209%2Croot%2F196%2Croot%2F196%2F202%2Croot%2F196%2F202%2F204%2Croot%2F186%2Croot%2F75%2F116%2Croot%2F189%2Croot%2F191%2F197%2Croot%2F191%2F197%2F199%2Croot%2F205%2Croot%2F209%2Croot%2F76%2F77%2Croot%2F221%2Croot%2F221%2F248%2F250%2Croot%2F221%2F238%2Croot%2F221%2F238%2F240%2Croot%2F203%2Croot%2F211%2Croot%2F211%2F222%2Croot%2F207%2Croot%2F211%2F222%2F224%2Croot%2F211%2F228%2Croot%2F211%2F228%2F230%2Croot%2F211%2F217%2Croot%2F211%2F217%2F219%2Croot%2F221%2F233%2Croot%2F221%2F244%2F246%2Croot%2F221%2F233%2F235%2Croot%2F221%2F244%2Croot%2F221%2F250%2Croot%2F221%2F250%2F252%2Croot%2F215%2Croot%2F221%2F227%2Croot%2F221%2F227%2F229%2Croot%2F221%2F240%2Croot%2F221%2F240%2F242%2Croot%2F221%2F234%2Croot%2F221%2F234%2F236%2Croot%2F221%2F249%2Croot%2F221%2F249%2F251%2Croot%2F11'		
				 
META
				 
Variable		 Value

 

[dlavigne]

Was this logging into the new UI or the old UI? How did you downgrade back to 11.1?

 

[pixelbrain]

Was this logging into the new UI or the old UI? How did you downgrade back to 11.1?

The old gui it happened to. I tried the new gui, entered user and pass and it just sat there with that little activity bar moving and nothing happens. I couldnt find how to revert or downgrade via a command line so what I did was #freenas-update FreeNas-11.1-RELEASE-manual-update.tar in ssh. probably not the right way but it was the only way i could find work out how to do it.

 

[dlavigne]

That type of error occurs when you switch a config between nightlies and a stable branch. The correct way to "downgrade" is to reboot and to select an earlier boot environment. Otherwise, weird stuff happens as changed config db settings don't get properly migrated. Best way to fix this is to do a fresh install of U1 on a different stick and importing a saved config from a non-nightly (or before you made changes on a nightly).

 

[pixelbrain]

That type of error occurs when you switch a config between nightlies and a stable branch. The correct way to "downgrade" is to reboot and to select an earlier boot environment. Otherwise, weird stuff happens as changed config db settings don't get properly migrated. Best way to fix this is to do a fresh install of U1 on a different stick and importing a saved config from a non-nightly (or before you made changes on a nightly).

Thanks but is 11.1-u1 not a stable branch as i used the gui originally to update it and then it went all wrong.

 

[dlavigne]

It is. Were you on a nightly at some point? What is the output of beadm list?

 

[pixelbrain]

havnt been on any nightly build. Dont trust them. I found something interesting though. Download and installed 11.1-u1 on a different usb stick. After install I reboot it and it would come up with an error.

fatal trap 12 page fault while in kernel mode freenas , thought is might be the usb stick so changed the stick same error. So downloaded ver 11.1 and installed. Same error. So went down to 11.0-u4 and it is running perfectly.

Luckily when i attached a monitor to my original setup it allowed me to go into a previous install through grub . Ran 11.0-u4 which was working. Downloaded the config - yes I didnt do a backup of the config originally. Lesson Learnt. And uploaded the config on the new install. Everything seems fine.

Is there perhaps a bug in 11.1 upwards.

Thanks for your help it did the trick