Mariadb keeps getting shut down with INNODB errors

Post

Posted
Rating:
#9987 (In Topic #3484)
Avatar
Standard member
mythus is in the usergroup ‘Community saint’

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."
Online now: No Back to the top

Post

Posted
Rating:
#9990
Avatar
Site director
Patrick Schmalstig is in the usergroup ‘Administrators’
Can you give me more context as to what you tried to do and how your database / site is set up? And what version of Composr CMS are you using?

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.
Online now: No Back to the top

Post

Posted
Rating:
Item has a rating of 5 (Liked by Patrick Schmalstig)
#10036
Avatar
Standard member
mythus is in the usergroup ‘Community saint’
I have been able to determine this was something weird with the webhost. I've tried to get them involved and since have had to migrate from that host. Since migrating away I haven't had those issues, but there was some corruption in my database. It is a good thing I keep daily backups.


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."
Online now: No Back to the top

Post

Posted
Rating:
Item has a rating of 5 (Liked by mythus)
#10042
Avatar
Site director
Patrick Schmalstig is in the usergroup ‘Administrators’
Daily backups are a must in this day and age, haha.

  • 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.
Online now: No Back to the top
1 guest and 0 members have just viewed this.

Statistics

Forum statistics:
  • 2,051 topics, 7,194 posts, 10,824 members
  • Our newest member is gracenayjanjoh
Birthdays:
Back to Top