How to export from Redis to MongoDB? (My database got wiped)



  • Yeah, thanks. Of course I save to a different file each time. I know how to make bash scripts.

    What I don't know is how to prevent NodeBB + Redis database from crashing and wiping itself without no reason at all, but then again that's probably your job - and so far it's not going very well is it?

    😠


  • Community Rep

    @Pilvinen to date, you're the only one I've seen have this problem. If we're going to be pointing fingers you might want to double check your work and who you're blaming.



  • For all we know it can be your host, your configuration and whatnot destroying databases. As @BDHarrington7 said, you're the only one who got these problems. I've broken instances of NodeBB (for the sake of this testing) many times and I never had it wipe a database. I surguest you take a good look at all your logs. The way you run NodeBB, the way you take backups. Etc etc. Even if the software is at fault here. Something about the way you're running it is causing it



  • Did you build Redis form source? It happened to me once when I did that, which probably indicates the problem came from something I did (or didn't do) during the build process.



  • No. I didn't build it from the source. And I've followed installation instructions to the letter and had nothing but trouble with NodeBB.


  • Community Rep

    You're going to have to help us out here, there is a lot of variability in how to install various parts of nodebb, being hand wavy and saying "it doesn't work" helps no one.

    • what provider are you on?
    • what versions of nodebb and redis?
    • are you using nginx? Do you have ports open to the db from the outside world?
    • can you give logs from the database / nodebb / system?
      Etc. etc.


  • OVH.
    Ubuntu Linux server.
    NodeBB v0.8.2.
    Redis server v3.0.5.
    No nginx.
    No open ports from outside.

    There are no logs from the crash. It. Just. Stopped. Working. 100% dead, no errors.



  • No Nginx or Apache... I find that hard to beleave. Are you running NodeBB on port 80?


  • Community Rep

    If there are really no logs it makes me think you might have forgotten to turn a config off, something that would have the database written to disk every once in a while. Did you import a community by any chance?



  • @Kowlin said:

    No Nginx or Apache... I find that hard to beleave. Are you running NodeBB on port 80?

    I'm running Apache of course.



  • @BDHarrington7 said:

    If there are really no logs it makes me think you might have forgotten to turn a config off, something that would have the database written to disk every once in a while. Did you import a community by any chance?

    There are logs but nothing useful. They just stop before the crash happened.

    Several months ago I imported messages from SMF but that's it.



  • @Pilvinen I encountered a similar issue as yours. The logs showed no problem at all nor NodeBB ones as it is not the softwares fold.
    This issue is 100% related to a config issue as it showed out for me.

    First of all, are you sure that Redis hat R/W access to the directory /var/lib/redis and its files?
    Yes. -> Post config file.
    No. -> chown -R redis:redis /var/lib/redis



  • @AOKP

    Of course it has write access there, I've been running the forums for many months and I have taken backups along the way every now and then and the dump.rdb has been alive and well.

    When the crash happened -> dump.rdb was suddenly 4 bytes in size instead of the usual ~13 mb.

    Which config do you wish to see? /etc/redis/redis.conf?

    It's 100% default except now after the second crash I switched appendonly to yes, ie. I'm now using appendonly.aof + dump.rdb both.

    Do you still want to see it ... ?



  • @Pilvinen said:

    @AOKP
    Which config do you wish to see? /etc/redis/redis.conf?

    Yes.


  • Global Moderator

    We want to see all the configs!



  • Here is /etc/redis/redis.conf:
    http://pastie.org/private/rehppriwl3yfgcmkk4gtq

    And it would be a lot more productive to say exactly which configs instead of "all of them" since I'm not power user - I don't know what you're talking about.

    Like I said I have default settings except those which I've configured through ACP.

    So tell me the config file names and paths and I'll see what I can pull up.


  • Staff Admin

    Also post the output of free -m, make sure you have enough ram and swap enabled.



  • free -m:

                 total       used       free     shared    buffers     cached
    Mem:         32141      29098       3043       3527        621      11891
    -/+ buffers/cache:      16585      15555
    Swap:         1025         37        988
    


  • @Pilvinen I hope you have a password for Redis...
    Otherwise I haven't found any issue.

    What you can also try is the following:
    service redis-server stop
    apt-get remove redis*
    apt-get purge redis*

    apt-get install redis-server

    So you have a fresh reinstall.



  • @AOKP said:

    @Pilvinen I hope you have a password for Redis...
    Otherwise I haven't found any issue.

    Well, since you can only connect to the database from the local machine I don't really see the point. If someone would compromise my system so far that they have access to the server's account then password protecting the database wouldn't really help at that point.



Suggested Topics

| |