SOLVED Services Tab has gone Kaput after a reset

[Starius]

Okay, the short version is this:

Server was running happily with a week's worth of usage.
After having an issue where the server wasn't obtaining an IP address upon rebooting, I was able to get it to pull an IP address..... but not after having hit the "factory reset" option at the console. (Wish I hadn't done that.)

The good news (for me) was that the system imported in the ZFS volume from my raid array just fine.
However, the Services tab is not happy and I cant get anything running again.

Here is what is displaying on the Services tab:

Request Method: GET
Request URL: http://192.168.13.61/services/core/?dojo.preventCache=1396568004594
Software Version: FreeNAS-9.2.1.3-RELEASE-x64 (dc0c46b)
Exception Type: OperationalError
Exception Value:

no such column: services_afp.afp_srv_homedir_enable

Exception Location: /usr/local/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py in execute, line 450
Server time: Thu, 3 Apr 2014 18:33:25 -0500

Environment:

Software Version: FreeNAS-9.2.1.3-RELEASE-x64 (dc0c46b)
Request Method: GET
Request URL: http://192.168.13.61/services/core/?dojo.preventCache=1396568004594


Traceback:
File "/usr/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response
107. response = middleware_method(request, callback, callback_args, callback_kwargs)
File "/usr/local/www/freenasUI/../freenasUI/freeadmin/middleware.py" in process_view
158. return login_required(view_func)(request, *view_args, **view_kwargs)
File "/usr/local/lib/python2.7/site-packages/django/contrib/auth/decorators.py" in _wrapped_view
22. return view_func(request, *args, **kwargs)
File "/usr/local/www/freenasUI/../freenasUI/services/views.py" in core
65. afp = models.AFP.objects.order_by("-id")[0]
File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py" in __getitem__
132. return list(qs)[0]
File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py" in __iter__
96. self._fetch_all()
File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py" in _fetch_all
854. self._result_cache = list(self.iterator())
File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py" in iterator
220. for row in compiler.results_iter():
File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in results_iter
710. for rows in self.execute_sql(MULTI):
File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
781. cursor.execute(sql, params)
File "/usr/local/lib/python2.7/site-packages/django/db/backends/util.py" in execute
53. return self.cursor.execute(sql, params)
File "/usr/local/lib/python2.7/site-packages/django/db/utils.py" in __exit__
99. six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python2.7/site-packages/django/db/backends/util.py" in execute
53. return self.cursor.execute(sql, params)
File "/usr/local/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py" in execute
450. return Database.Cursor.execute(self, query, params)

Exception Type: OperationalError at /services/core/
Exception Value: no such column: services_afp.afp_srv_homedir_enable

Request information
GET
Variable Value
dojo.preventCache u'1396568004594'
POST

No POST data
FILES

No FILES data
COOKIES
Variable Value
csrftoken 'K26gBopA3vPdT3oUxX0QiDFysxzg2g1W'
sessionid '4s4oiqmn7eycfrs3w47pgd4qw99tvd2j'
fntreeSaveStateCookie 'root%2Croot%2F51%2Croot%2F51%2F58%2Croot%2F148%2Croot%2F8%2Croot%2F8%2F28%2Croot%2F8%2F32%2Croot%2F1%2Croot%2F1%2F5%2Croot%2F1%2F6%2Croot%2F1%2F2%2Croot%2F54%2Croot%2F54%2F61%2Croot%2F54%2F61%2F62%2Croot%2F54%2F61%2F62%2F119%2Croot%2F54%2F61%2F62%2F119%2F120%2Croot%2F155%2Croot%2F157%2Croot%2F157%2F163%2Croot%2F157%2F163%2F165%2Croot%2F157%2F175%2Croot%2F157%2F175%2F177'
META
Variable Value
wsgi.multiprocess False
HTTP_REFERER 'http://192.168.13.61/'
REDIRECT_STATUS '200'
SERVER_SOFTWARE 'nginx/1.4.4'
SCRIPT_NAME u''
REQUEST_METHOD 'GET'
PATH_INFO u'/services/core/'
SERVER_PROTOCOL 'HTTP/1.1'
QUERY_STRING 'dojo.preventCache=1396568004594'
CONTENT_LENGTH ''
HTTP_USER_AGENT 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:27.0) Gecko/20100101 Firefox/27.0'
HTTP_CONNECTION 'keep-alive'
HTTP_COOKIE 'csrftoken=K26gBopA3vPdT3oUxX0QiDFysxzg2g1W; sessionid=4s4oiqmn7eycfrs3w47pgd4qw99tvd2j; fntreeSaveStateCookie=root%2Croot%2F51%2Croot%2F51%2F58%2Croot%2F148%2Croot%2F8%2Croot%2F8%2F28%2Croot%2F8%2F32%2Croot%2F1%2Croot%2F1%2F5%2Croot%2F1%2F6%2Croot%2F1%2F2%2Croot%2F54%2Croot%2F54%2F61%2Croot%2F54%2F61%2F62%2Croot%2F54%2F61%2F62%2F119%2Croot%2F54%2F61%2F62%2F119%2F120%2Croot%2F155%2Croot%2F157%2Croot%2F157%2F163%2Croot%2F157%2F163%2F165%2Croot%2F157%2F175%2Croot%2F157%2F175%2F177'
SERVER_NAME 'localhost'
REMOTE_PORT '57048'
wsgi.url_scheme 'http'
SERVER_PORT '80'
SERVER_ADDR '192.168.13.61'
DOCUMENT_ROOT '/usr/local/etc/nginx/html'
HTTP_X_REQUESTED_WITH 'XMLHttpRequest'
DOCUMENT_URI '/services/core/'
wsgi.input <flup.server.fcgi_base.InputStream object at 0x811b7eb90>
HTTP_HOST '192.168.13.61'
wsgi.multithread True
HTTP_CONTENT_TYPE 'application/x-www-form-urlencoded'
REQUEST_URI '/services/core/?dojo.preventCache=1396568004594'
HTTP_ACCEPT 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
wsgi.version (1, 0)
GATEWAY_INTERFACE 'CGI/1.1'
wsgi.run_once False
wsgi.errors <flup.server.fcgi_base.TeeOutputStream object at 0x811b82190>
REMOTE_ADDR '192.168.13.85'
HTTP_ACCEPT_LANGUAGE 'en-US,en;q=0.5'
CONTENT_TYPE 'application/x-www-form-urlencoded'
CSRF_COOKIE u'K26gBopA3vPdT3oUxX0QiDFysxzg2g1W'
HTTP_ACCEPT_ENCODING 'gzip, deflate'







Any help with this would be GREATLY appreciated. I've already accumulated a fair bit of data on this server that I would like to recover.

 

[Yatti420]

Reset browser cache and try again or maybe try a different browser.. Worse comes to worse reset everything and see what happens..

 

[Starius]

Thanks for the tip, I hadn't considered it being an issue on the browser side.
I shall try accessing the server from a different computer on the network when I get home from work this evening.

 

[Starius]

Nope, that was a no-go. Same page loads on a different computer. :/
If I were to do a new USB flash of Freenas, run it as if it was the first time, would I still be able to import the data off of my raid array to recover the files?

 

[dlavigne]

If I were to do a new USB flash of Freenas, run it as if it was the first time, would I still be able to import the data off of my raid array to recover the files?

Yes.

 

[Starius]

Just for an update, I just put in a Intel Gigabit nic and disabled the onboard lan of my motherboard. The services tab now displays normally in the WebUI, no data lost, seems to be up and running again.
I guess FreeNAS was kind of being flakey with the Nvidia LAN chipset which ultimately was causing the issues I was having. It was strange though, as it worked perfectly for a week.

 

[venkavis]

I was stunned when I saw the exact same problem. :)

I did the same thing and put back the NIC on and the NIC is working but the services hasnt got fixed.

What options do I have. Create a new USB Stick? Can I go with the latest version 9.2.1.5? My current version is 9.2.1.3.

Thanks fo help in advance.