Page 1 of 1

failed to commit transaction: disk I/O error

Posted: Wed Apr 16, 2014 2:33 am
by coylh
I started using the userman package this weekend on CCR1036-12G-4S-EM (6.11), and after only a few days it failed.

I get the error "failed to commit transaction: disk I/O error". After this happened I get "failed to add log: unable to open database file". It looks like this has caused the disk to switch to read-only, so other things like making a backup also fail.

Should I expect this service to work reliably? I'm only interesting in using radius authentication for routerboard logins, and thought it would be more convenient that a freeradius installation.

Re: failed to commit transaction: disk I/O error

Posted: Sat Apr 19, 2014 11:45 pm
by russman
Image

I'm getting the same issue with userman on cloudcore. It happened with one we've been running for awhile then it manifested itself again on a the brand new identical unit that I replaced it with 3 days later. It's far from running out of space. Maybe the integrated storage literally can't handle the IOPs needed to run radius and I need x86 router with and SSD and/or this is a 6.11-6.12 userman issue. I don't think we started seeing this issue until after the recent upgrade.

Would love some input here.

Re: failed to commit transaction: disk I/O error

Posted: Tue Apr 22, 2014 5:29 am
by russman
I hear crickets chirping...

I upgraded the new userman box to 6.12 and the same issue returned in less than an hour and happened 5 more times that morning before I decided to try downgrading router OS versions. I looked at the changlog and figured 6.8 would be a good starting point for further troubleshooting this dedicated userman router. I've been running 6.8 for 34hours with no errors. I'll let it go 72hours before I'd conclude that this is a software bug.

Re: failed to commit transaction: disk I/O error

Posted: Thu Apr 24, 2014 5:06 am
by russman
Two cloud core units and 3 Router OS versions (6.11, 6.12, and now 6.8) the issue is resolved. It appears there is a bug in the later versions of Router OS. 115 hours have passed without any errors locking up userman. Please look into this userman DB issue Mikrotik, I'll be watching release notes.

Re: failed to commit transaction: disk I/O error

Posted: Sat Jun 14, 2014 5:50 am
by russman
I see 6.15 has been released but I haven't seen anything in the changelog referencing this or any responses to this thread. Anyone have input to add?

Re: failed to commit transaction: disk I/O error

Posted: Mon Jun 23, 2014 8:01 pm
by Hassan1
I have the same problem :(
did you solve it ?

Re: failed to commit transaction: disk I/O error

Posted: Fri Jun 27, 2014 9:19 am
by jacquesgrun
I have the same problem as well as traffic just stops going to the default route randomly on the ccr1016-12G have you guys had any luck with mikrotik support as I have sent numerous emails and responses like have you updated the firmware to 6.15, and when you answer you have already, you never hear back!

Re: failed to commit transaction: disk I/O error

Posted: Tue Oct 14, 2014 5:28 am
by russman
I simply downgraded to 6.8 as mentioned above and the the issue went away. I haven't tried anything else because I haven't seen anything in the change log addressing this issue yet. Has anyone that had this issue try 6.20 yet?

Re: failed to commit transaction: disk I/O error

Posted: Wed Feb 01, 2017 5:52 pm
by Kinaee
i have the same problem
And I didn't find any solution

Re: failed to commit transaction: disk I/O error

Posted: Fri Sep 29, 2017 8:18 am
by undecided
I too now have the same issue, CCR1036 v6.41rc32, was previously stable release and had the issue hence updated to rc32 in hope it solved it...

Some have said that they reverted to 6.8...that's far too old now, surely this should have been fixed by now?

Re: failed to commit transaction: disk I/O error

Posted: Fri Dec 07, 2018 8:41 am
by ahmadzai
i am also facing disk i/o error issue in my dude database file. while i want to connect to my dude server i am getting error db failure disk i/o error : stopped.

kindly help me how to get out of it and solve it.