[Please complete the below template with details of the problem reported on your Web-UI. Be as detailed as possible. Community members, including developers, shall try and help. Thanks for your time in reporting this issue! We recommend purchasing commercial support for expedited support directly from the developers.]
Brief description of the problem
Hi guys, went to check my NAS today and it was offline, I had to do a graceful reboot and it never came back up. I got this error open_ctree failed, had to to type âjournalctlâ to view the logs
Detailed step by step instructions to reproduce the problem
[I didnât do anything the problem just occurred ]
Ok, I ended up reinstalling Rockstor on different USB drive, booted up and updated to the latest kernel âLinux: 4.8.7-1.el7.elrepo.x86_64â and Rockstor 3.8.15-14. Activated the testing updates, but didnât get the latest update the 3.8.16!!, any ideas what is going on?
Also after importing the pool I wasnât able add samba shares
Here is some logs
Houston, weâve had a problem.
relation âstorageadmin_pincardâ does not exist LINE 1: SELECT COUNT(*) AS â__countâ FROM âstorageadmin_pincardâ WHE⊠^
Traceback (most recent call last):
File â/opt/rockstor/src/rockstor/rest_framework_custom/generic_view.pyâ, line 40, in _handle_exception
yield
File â/opt/rockstor/src/rockstor/storageadmin/views/user.pyâ, line 105, in get_queryset
return combined_users()
File â/opt/rockstor/src/rockstor/storageadmin/views/ug_helpers.pyâ, line 69, in combined_users
temp_uo.pincard_allowed, temp_uo.has_pincard = pincard_states(temp_uo)
File â/opt/rockstor/src/rockstor/system/pinmanager.pyâ, line 136, in pincard_states
pincard_present = has_pincard(user)
File â/opt/rockstor/src/rockstor/system/pinmanager.pyâ, line 121, in has_pincard
pins = Pincard.objects.filter(user=int(uid_field)).count()
File â/opt/rockstor/eggs/Django-1.8.16-py2.7.egg/django/db/models/query.pyâ, line 318, in count
return self.query.get_count(using=self.db)
File â/opt/rockstor/eggs/Django-1.8.16-py2.7.egg/django/db/models/sql/query.pyâ, line 466, in get_count
number = obj.get_aggregation(using, [â__countâ])[â__countâ]
File â/opt/rockstor/eggs/Django-1.8.16-py2.7.egg/django/db/models/sql/query.pyâ, line 447, in get_aggregation
result = compiler.execute_sql(SINGLE)
File â/opt/rockstor/eggs/Django-1.8.16-py2.7.egg/django/db/models/sql/compiler.pyâ, line 840, in execute_sql
cursor.execute(sql, params)
File â/opt/rockstor/eggs/Django-1.8.16-py2.7.egg/django/db/backends/utils.pyâ, line 64, in execute
return self.cursor.execute(sql, params)
File â/opt/rockstor/eggs/Django-1.8.16-py2.7.egg/django/db/utils.pyâ, line 98, in exit
six.reraise(dj_exc_type, dj_exc_value, traceback)
File â/opt/rockstor/eggs/Django-1.8.16-py2.7.egg/django/db/backends/utils.pyâ, line 64, in execute
return self.cursor.execute(sql, params)
ProgrammingError: relation âstorageadmin_pincardâ does not exist
LINE 1: SELECT COUNT(*) AS â__countâ FROM âstorageadmin_pincardâ WHEâŠ
^
@Mahmoud87 Hello again; well done on getting your Rock-on in to rockon-repo by the way, it normally does take quite that long but it seems like you submitted it right at the beginning of a quite time.
Anyway on to your questions:
Thatâs an easy one as itâs not out yet. The latest Rockstor release in testing channel updates is 3.8.15-14 which is the version you indicate getting so no problem on that one.
The problem you indicate re the database missing an entry looks like the one reported in the following thread: Boot and Upgrade Error. 3.8.12 > 3.8.15.12 - #2 by suman Although in that case it was the missing networkdevice entry.
There as you see @suman states that due to the recent fairly large db related changes there are issues with updating from earlier releases. You didnât state what version of the Rockstor iso you used to re-install with but it seems like the way to go now is to use the latest 3.8.15 iso for any re-installs.
The samba shares issue is also most likely due to the database being out of kilter due to this recent change re upgrades. Bit of a pain but this needed to be done sooner rather than later it seems as I suspect we here heading to greater problems as the db update method was put off. Quite a few regressions (one of which you have reported yourself of course) but we should all be in a better position once we are over the hill as it were.
Hope that helps.
Oh and sometime (often) a reboot is required after a Rockstor update. Just a though but Iâm assuming you tired this.
@Mahmoud87 Please donât get this a wrong way (at I think documentation should be changed to discourage this) but installing any operating system to USB for constant use is VERY UNSAFE.
Letâs concentrate on few characteristics of USB drives:
are meant to be cheap, there fore those are not designed with reliability in mind
are not meant to have any specific âup timeâ so those drives tend to overheat / self rest / plain switch of / have lurking bugs that only running long exposes
are not meant with data integrity in mind ! Those re designed to put pictures of cats on it - take it some where and thatâs it ⊠using those for having a system that relies on integrity of itâs data will result in problems !
have issues with syncing data to âlong term storageâ - letâs say that you system performed some amount of updates (a lot of writes and changes in files) and performed a reboot -> your usb drive may opose a reboot because itâs still trying to write data down ⊠but operating system goes âoh well, you should have a journal like anybody else does, so live long and suck itâ
I know that people will start screaming about the costs, but you can get a sandisk 32GB SSD for 20$ ⊠maybe not a speed demon but very reliable and way better than spinning rust.
Thanks @phillxnet I am so pumped to see it in the official rockon registry, really many thanks to you in the first place you helped alot.
I have looked in this post and totally ignored the fact that my iso was the 3.8.14, but what makes me wonder I got every single update till the last one that upgraded the kernel then Rockstor was down and got the error âBTRFS: open_ctree failedâ. I still has this USB and tried to boot in it again but same problem still there. I donât know if itâs something worth looking into or just enjoy the new setup .
You were right once installed the new iso 3.8.15 and updated to 3.8.15-14 I was able to add samba shares, but I keep getting this error messages .
I just hit ok about 3 times and it disappear but every now and then it pops up, tried to go to the url it displayed but to be honest didnât get much .
I couldnât agree more with ya mate, this is why am gonna get a normal 120gb hdd or an SSD cause I can really tell how slow it is off the USB ,beside all risks you stated above. Do you guys think itâs gonna make a big difference running Rockstor on HDD compared to SSD? I know itâs going to be faster but is it a noticeable speed difference?
Honestly I would say that it will make no difference because once rockstor is running all operating system stuff is already in ram so there is no need to load anything from disk. Also please remember that itâs a good practice to leave system filesystem alone, not to put any shares there (like rockon share) ⊠itâs not smart to do it and a lot of people pay the price for it (or they will but now they donât know about it yet.
Of course when you need to make any operating system related stuff like big update or
Why Iâm suggesting a sandisk ssd is that sandisk is a well established company that produces moderately reliable equipment and their 32GB SSD for around 20$ is cheaper than any brand new HDD you can buy with same reliability level.
Thanks mate for the recommendation, definitely $20 is so cheap for an SSD. [quote=âTomasz_Kusmierz, post:6, topic:2453â]
Also please remember that itâs a good practice to leave system filesystem alone, not to put any shares there (like rockon share) ⊠itâs not smart to do it and a lot of people pay the price for it (or they will but now they donât know about it yet.
[/quote]
Yeah man I have separate drive for the file system since day 1 canât afford losing everything with the system when it goes down.
Iâm honestly starting to get more and more confused ⊠now I canât mount root fs on one server because btrfs decided to corrupt itâs checksum tree (similar to yours) ⊠other (as you seen) spontaneously forgot itâs settings âŠ
I will mark this as solved. I did fresh installation using the 3.8.15 iso, all was fixed. The âData Tablesâ wasnât the original problem, but we can follow the âData Tablesâ issue in this post, please @phillxnet when you get sometime can you have a look at this post .
And this is while Iâm in users and canât create any pincard installing fresh from .14 iso â finish install â upgrade to -14 â import pool â make it compressed â go to samba config (to be able to quickly upload some data) â TADA a nice error âŠ
Maybe Iâm wrong, move to page 2,3,4, etc : on 3.8.14-0 admin user got listed on alphabetical order by all users (ex. your rockstor admin is âTestâ, youâll se it on page with T users), that was fixed later