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

Pilvinen

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?

Bri

@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.

Robert

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

Henry Wright

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.

Pilvinen

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.

Bri

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.

Pilvinen

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.

Robert

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

Bri

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?

Pilvinen

@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.

Pilvinen

@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.

? Offline

@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

Pilvinen

@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 ... ?

? Offline

@Pilvinen said:

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

Yes.

PitaJ

We want to see all the configs!

Pilvinen

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.

<baris>

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

Pilvinen

free -m:

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

? Offline

@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.

Pilvinen

@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.