Known Replikwando Errors
Errors in Replikwando
Replikwando is made to handle inconsistent internet connections, MySQL databases that get shut off randomly, and things like that. However, sometimes things happen that Replikwando isn't able to handle automatically in a smart fashion. It uses error logs to tell the administrator when something odd has come up and should probably be looked into.
This wiki page is meant to help explain what the different errors are, as well as what needs to be done to handle them (or if they can be safely ignored).
Error Logs
FromConnectionError Log
This error log contains errors and warnings coming from the company's local database.
Lost Connection To The Database
- Cause
Replikwando wasn't able to see the local database. This can happen if the MySQL service is stopped or restarted, or if the process was too busy to respond for a moment, or if the network connection to the server host quit working for a moment (if the MySQL server isn't hosted locally).
- Resolution
Replikwando is built so that things like this can happen. Therefore, it's safe to ignore this error. Replikwando will just reconnect to the database when it comes back.
- Similar Errors
MySQL Server Has Gone Away
The Following Query Was Reported And Skipped
- Cause
Someone enabled the skip-query interface for replikwando and then told it to skip a query. The query is then logged in the error log to record what was skipped in case the administrator needs to go back and evaluate it.
- Resolution
This error can be ignored, as it is purely for informational purposes.
ToConnectionError Log
This error log contains errors generated from interacting with the remote MySQL database.
Lost Connection To The Database
- Cause
Replikwando wasn't able to see the remote database. This can happen if the MySQL service is stopped or restarted, or if the process was too busy to respond for a moment, or if the internet connection for the site drops.
- Resolution
Replikwando is built so that things like this can happen. Therefore, it's safe to ignore this error. Replikwando will just reconnect to the database when it comes back.
- Similar Errors
MySQL Server Has Gone Away
Duplicate Key
- Cause
This error means that it tried to push a key to the remote database, but it already had the values being specified. This is normally caused by a query that gets sent, is received by the server, but the server reply just doesn't get back to Replikwando before it tries again. That means that if the remote server goes down or the internet connection is interrupted for even a moment, this can occur.
- Resolution
It is safe to ignore this error. Newer versions no longer halt on this error, as it is indicative of the data already being on the remote server.
There is no '*'%' registered
- Cause
This error occurs when the remote server is asked to run a stored procedure (like a function or trigger), but the user who created it or is defined as the executor no longer exists.
- Resolution
You do not need to stop Replikwando to fix this issue. Dump the functions from the remote database into a text file, find-and-replace all instances of the obsoleted name with the name of a valid user, and re-insert them.
QueueConnectionError Log
Database Is Locked
- Cause
This error occurs when one thread/process/person is writing into the SQLite database file while another is trying to use it. It means that whatever got the error wasn't able to query the table or write data into it. It's most common to see this error when an administrator is running queries against the SQLite database file while Replikwando is running (which is safe to do, but it can get annoying having to run your query more than once).
- Resolution
It is safe to ignore this error. Replikwando does not halt on this error; it just tries to do what it was doing again, until it succeeds.