Jump to content
  • Sky
  • Blueberry
  • Slate
  • Blackcurrant
  • Watermelon
  • Strawberry
  • Orange
  • Banana
  • Apple
  • Emerald
  • Chocolate
  • Charcoal
  1. OpenComputers

    1. Announcements

      OpenComputers official announcements.

      125
      posts
    2. Feedback

      Tell us what you think.

      406
      posts
    3. IRC

      #OC channel discussion
      irc.esper.net #oc

      25
      posts
  2. Code Central

    1. Support

      Ask for support from the OpenComputers community

      4036
      posts
    2. Showcase

      Showcase what you have created for OC. No 'malware' or other junk!

      2813
      posts
    3. Tutorials

      Help other users out. Please no 'false tutorials'

      128
      posts
  3. Addons & More

    1. Addons Mods

      Show off your OC addons mods

      235
      posts
    2. Architectures

      Discussions for Architectures

      178
      posts
    3. OpenEngineering Task Force

      Discussion board for the OETF documents

      93
      posts
  4. General

    1. Lounge

      Just lounge around or have an open discussion.

      329
      posts
    2. Forum Games

      Fight boredom!

      68
      posts
    3. Showcase

      Show off your creations! (not for your programs)

      136
      posts
    4. Servers

      A place to advertise your servers

      147
      posts
  5. Archives

    1. Public Archives

      OpenComputers public archive forum

      8
      posts
  • Forum Upkeep

    In order to keep the forums updated with improvements and security fixes, we need to pay for a subscription.

    Currently, this is: $25/6-months for the forums itself and $10/6-months for the Theme (totalling $35 USD/6-months).

    You're not obligated to donate anything, but anything you do donate will be much appreciated. :)



    28% of donation goal reached.
    Donate Sidebar by DevFuse
  • Topics

  • Posts

    • Just a heads up, this is going to be a bit of a long post with a bit of technical information mixed in. Forum access over the past few days You may have tried to access the forums over the last few days (13th - 15th of January, 2020) and been met with a message that read something like "Forums are currently offline due to database corruption". Whilst the forums are now back up again, the database corruption is still here. I'll get into the specifics in a bit but first a bit of context: Context: Over the period of the last month, I have been migrating to a new (and cheaper) dedicated server. The forums' files were moved over last weekend but they've been pointing at my database cluster for the past few weeks. Unfortunately, what wasn't apparent to me at the time (and I only realised it yesterday), is that the OC Forums' Database has a mix of InnoDB tables (good, they can replicate) and MyISAM tables (bad, they don't replicate). This has resulted in the database servers printing to their respective consoles, that various tables within the Forum's database are marked as crashed and should be repaired. After a while (or a few requests to the same table, I'm not entirely sure what causes it), it also causes the node that was being accessed to completely crash out, resulting in cutting off anything else that also happened to be using that node at the time. I've limited the forums to one node so the impact is lessened, but it still takes some time when Systemd restarts the downed node and gets it re-synced with the surviving node. I've also tried repairing the tables using various mysqlcheck commands, which didn't succeed. I found an option in the config to use "InnoDB" as the table storage method, but any combination of activating that and converting the MyISAM tables to InnoDB ones just ends up in either more crashes or stuff not even loading at all. Nothing I have tried is getting it back to how it was before all my migrations started a month ago. I do have some backups, but they're either from over a month ago, or already contain the corruption. Going forward, there'll be daily snapshots of the database nodes, but that doesn't help fix things retroactively sadly. What's the TL;DR? As it stands right now, the databases are corrupted and the frequency of the crashes is only going to get worse. One of the tasks that is currently "stuck" (and trying to manually run kills the database) is the cache clearing process. The table it accesses is a MyISAM-backed one. With no way to convert the tables or fix the corruption and the only way to "back up" the data of the forum is to take a snapshot of the (corrupted) database, there isn't a lot of options to be able to do a backup-wipe-and-reload whilst keeping all the data. Future plans and fixes To those of you who have been giving some domains towards the license costs, Thank you! They are a good help. The amount on the sidebar is currently a little off because trying to update the value end up killing the Database node, which is what alerted me to this issue in the first place (it doesn't auto-update annoyingly). So what's the plan? Right now? I honestly don't know. I'm contemplating switching to a different forum software, preferably something free/open source. But moving all the topics, discussions and userdata over is going to be a pain, even more so when the database is in a fragile state. I was looking into seeing if I could get the Wayback Machine to snapshot the entirety of the forums, but their site for snap-shotting everything confused me. (If you know more about this, please @Lizzian me on either the Discord guild or IRC). AFAIK the Wayback Machine allows you to snapshot single pages, so if you want to snapshot random pages/threads, please do.   I'll be leaving this topic open for replies (if permissions allow you to reply, I don't know if you can and the database might die again if I try to look), so if you have any questions either reply to this thread or poke me on IRC/Discord. In writing all of the above, the database node that the forums is pointing to has died a total of 5 times so far and even made the container that the node was running in crash.
    • A list of mods that aren't hosted on CF that are allowed to be used in CF packs.
    • Make sure to change password and test side it goes 1-6. All you should need is a redstone card  local component=require("component") --references all connected components local r=component.redstone --Choose redstone from components list local gpu=component.gpu --Choose gpu from components local term=require("term") --References terminal commands   ---- config section local password="1234" local delay=5 --time the door stays open local side=5 --side of the door, test this -----   local wrong=false   while true do   term.clear() --Clear screen   gpu.set(1,1,"Please enter the password")   if wrong then     gpu.set(1,1,"Password was wrong, try again")     wrong=false   end   term.setCursor(1,2)   local input=io.read() --wait for user input   if input==password then      r.setOutput(side,15) -- check if this is the correct function      os.sleep(delay)       r.setOutput(side,0) -- same here   else      wrong=true   end end
    • I wanted to make a window and I've been scrolling around. I found some stuff related to the term API, but I can't wrap my head around it. How would you use it?
  • Popular Contributors

    Nobody has received reputation this week.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.