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

All Activity

This stream auto-updates     

  1. Yesterday
  2. Last week
  3. I regularly work with MySQL databases. Mainly I operate with self-written Perl scripts on them. If I could help in any way, I would be happy to do so.
  4. Earlier
  5. 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.
  6. There is a program for this Click here
  7. A list of mods that aren't hosted on CF that are allowed to be used in CF packs.
  8. 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
  9. 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?
  10. My microcontroller keeps giving me the error bad argument #1 (string expected got nil) What did I do wrong? Everything seems ok https://pastebin.com/x29Bgig
  11. Are you going to put this on CurseForge? If not, could you get it added to the accepted 3rd party mods list?
  12. Updated 1/1/2020: Version 2 (checks for drives with /init.lua)
  13. I'm still a bit new to the open computers stuff. I'm not quite sure how to do that?
  14. I asked them if they could do anything and it doesn't seem possible. They gave me the same answer as you did earlier about increasing the total memory, but that wouldn't work.
  15. i don't see how the DNS would help but have fun making it, shouldn't be too hard.
  16. I think you should take this to the developers of nuclearcraft as there's nothing we can really do (apart from editing the config file to increase memory size.)
  17. The thing is, that's exactly what I'm doing. This table is just this large. Around 10 variables are contained in each block, and if there are around 13k blocks (24x24x24), the table becomes incredibly large.
  18. Do you know the address of your I/O blocks? They are unique and random Expamle 2 should work IF you enter the correct addresses. right click/shift+right click with an analyzer will show you the address. take the first 5 characters of the address and put them inside the component.get() calls.
  19. I don't see anything setting the color to white, it could be on your end. Post a screenshot of the screen, that might help figuring out the problem. It could also be that the program doesn't work correctly anymore.
  20. How much memory you have in the computer? You should use T3.5 Memory if you arn't already. You could also try with a server as they can accept twice the amount of memory.
  21. @Canyon Canyon Canyon Canyon You could take a look at my DNS server/client system. https://github.com/SpaceBeeGaming/OC-DNS. I haven't used it in a while, so I don't know if it still works (should work but no guarantees). Just ask if you have more questions or come across problems, always happy to help.
  22. In NuclearCraft, the Fission Reactor component has a .getReactorLayout() function, which produces a table with statistics of every single block inside the reactor. The fission reactor I'm testing out is 24x24x24 (max size) and the function produces an entirely too massive table for the computer to handle. "Unrecoverable Error, Out of Memory." How do I shrink this table before it's contents are displayed and not crash the computer?
  23. I made this program in my single player SkyFactory 4 world and I thought I could share it here. I think it's a bit too big but I think it works. This is a program that allows you to check your NuclearCraft Fission Reactor stats and also has the ability to supply fuel to the reactor with the help of an ME System as well as having grid control for Mekanism's Induction Matrix. I'm not sure where to go with this program so if you have any suggestions, a comment would be greatly appreciated! https://pastebin.com/SDpjY7J2
  24. the sleep was a try to prevent multiple network reading, didnt worked. The computers were connected only by cables, now everything is fine and working, i also built everything new. I believe i had the switch function in one of the racks activated so that may have caused the repetitions
  25. Maybe make an event listener and redraw the rest of the screen if someone pressed return? Btw the ingame computer support unicode https://en.wikipedia.org/wiki/Box-drawing_character
  1. Load more activity
  • Newsletter

    Want to keep up to date with all our latest news and information?
    Sign Up
×
×
  • Create New...

Important Information

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