Mariadb keeps getting shut down with INNODB errors
Posted
#9987
(In Topic #3484)

Standard member

preallocating x bytes for file ./ib_logfile101 failed with error 28
This is like the 2nd time this month that i get the dreaded Could not connect to database-server (when authenticating) (No such file or directory) error screen. All while posting to the forum in my composr-powered site.It seems that the forum is causing this issue. I wasn't having this issue before deploying the forum. Am I screwed with my installation? I am getting really tired of having to deal with this particular error. Last time it took me days to get the datebase working again...
Like ocPortal? Want to thank Chris and gang somehow? Then help out in the chat room! It really needs your help! Just open it in a tab everytime you open your web browser, and when you hear a "ding", check it out!
"Those who want help should first be willing to give help."
Posted

Site director

Composr does not work well with INNODB and was designed for MYISAM. Granted, this is a very old standard, but we don't have enough developer power at the moment to work through re-designing Composr with INNODB in mind. Nonetheless it is on the tracker for v12.
Other things to consider: Do you have enough disk space? Can MariaDB write its INNODB logs and has permission to do so? Is your innodb_log_file_size set too high?
- Need support for version 10? The core development team is no-longer offering it for free (unless it's a critical bug that breaks your entire site or a serious security hole). Please consider hiring me instead if you need v10 support or a non-critical bug fix. Or, ask the community in the forums!
- Do you enjoy Composr? Please consider contributing your talent to the project or recommending Composr to others. Even small contributions make a big impact in the Composr community.
- Do you have feedback for us? You can report bugs, suggest features, or give feedback on the Free support options page.
- Do you need professional service with your Composr website? Please consider contracting me for your needs through my company, PDStig, LLC. Doing so will also help fund Composr development.
- Want to watch live streams of me developing Composr CMS? Please subscribe to me on Twitch to be notified when I stream. Composr development streams are usually spontaneous / not scheduled in advance as work priorities come first.
Posted

Standard member

Like ocPortal? Want to thank Chris and gang somehow? Then help out in the chat room! It really needs your help! Just open it in a tab everytime you open your web browser, and when you hear a "ding", check it out!
"Those who want help should first be willing to give help."
Posted

Site director

- Need support for version 10? The core development team is no-longer offering it for free (unless it's a critical bug that breaks your entire site or a serious security hole). Please consider hiring me instead if you need v10 support or a non-critical bug fix. Or, ask the community in the forums!
- Do you enjoy Composr? Please consider contributing your talent to the project or recommending Composr to others. Even small contributions make a big impact in the Composr community.
- Do you have feedback for us? You can report bugs, suggest features, or give feedback on the Free support options page.
- Do you need professional service with your Composr website? Please consider contracting me for your needs through my company, PDStig, LLC. Doing so will also help fund Composr development.
- Want to watch live streams of me developing Composr CMS? Please subscribe to me on Twitch to be notified when I stream. Composr development streams are usually spontaneous / not scheduled in advance as work priorities come first.
1 guest and 0 members have just viewed this.