replication problem

benymarel

We are using litereplica in django app and we're facing a problem with replication

First case : We shut off the slave server which is actually a server where we store the replicated database. So after shutting off the slave, we add entries in the master database and then turn on the slave server. And there the replication just doesn't work anymore
Second case : While the slave server is up, we update the structure of the master database add new fields ... after this operation, the replication stop working.

Does anyone already got those cases? any idea to fix it or am i missing something?

Thanks in advance for your input

Bernardo

Hi!

Could you inform which version of LiteReplica are you using?

Is it the last one from the private GitLab repo?

If not, consider updating it.

Did you run the automated tests?

benymarel

Hi Bernado,
It's the version 2.3 and not the one from the private repo.
Actually we use the public version.
Yes i run automated tests.

Bernardo

As well known, the public version has many many bugs.

If you need a stable implementation you need to acquire a license.

With that you will be able to access the private repo, currently supporting SQLite 3.29

Best regards,

benymarel

Hi berndao,
We acquired the license, but we still having the same problem explained in this post.
I keep testing, trying to figure out if we miss something but we need help about this to move fast forward, so if you have any suggestion about that it would be great.

Best Regards,

Bernardo

Hi,

I need more details about the problem. I have not worked with Django before. Note that there is no guarantee that it will work with Django out of the box, maybe you will need to patch Django or the wrapper.

Could it be opening many connections to the same database file? This could be a problem.
Does it keep the connection to the local db open or does it open it only when required and then close it?
Have you discovered which wrapper it uses to interface with SQLite?
Which OS is being used on the nodes?

You can also send me an e-mail with the details you have.