twindb Backup not working

[Nishant Singh]

Hey Alexandar,

I have been using your twindb backup tool since feb, and it was working fine until april and since last month the backup is not happening, I am getting this below error:

[root@test ~]# twindb-backup backup daily
Traceback (most recent call last):
  File "/bin/twindb-backup", line 9, in <module>
    load_entry_point('twindb-backup==2.15.7', 'console_scripts', 'twindb-backup')()
  File "/opt/twindb-backup/embedded/lib/python2.7/site-packages/click-6.7-py2.7.egg/click/core.py", line 722, in __call__
    return self.main(*args, **kwargs)
  File "/opt/twindb-backup/embedded/lib/python2.7/site-packages/click-6.7-py2.7.egg/click/core.py", line 697, in main
    rv = self.invoke(ctx)
  File "/opt/twindb-backup/embedded/lib/python2.7/site-packages/click-6.7-py2.7.egg/click/core.py", line 1066, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/opt/twindb-backup/embedded/lib/python2.7/site-packages/click-6.7-py2.7.egg/click/core.py", line 895, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/opt/twindb-backup/embedded/lib/python2.7/site-packages/click-6.7-py2.7.egg/click/core.py", line 535, in invoke
    return callback(*args, **kwargs)
  File "/opt/twindb-backup/embedded/lib/python2.7/site-packages/click-6.7-py2.7.egg/click/decorators.py", line 64, in new_func
    return ctx.invoke(f, obj, *args[1:], **kwargs)
  File "/opt/twindb-backup/embedded/lib/python2.7/site-packages/click-6.7-py2.7.egg/click/core.py", line 535, in invoke
    return callback(*args, **kwargs)
  File "/opt/twindb-backup/embedded/lib/python2.7/site-packages/twindb_backup-2.15.7-py2.7.egg/twindb_backup/cli.py", line 102, in backup
    run_backup_job(cfg, run_type, lock_file=lock_file)
  File "/opt/twindb-backup/embedded/lib/python2.7/site-packages/twindb_backup-2.15.7-py2.7.egg/twindb_backup/backup.py", line 256, in run_backup_job
    backup_everything(run_type, cfg)
  File "/opt/twindb-backup/embedded/lib/python2.7/site-packages/twindb_backup-2.15.7-py2.7.egg/twindb_backup/backup.py", line 207, in backup_everything
    backup_mysql(run_type, config)
  File "/opt/twindb-backup/embedded/lib/python2.7/site-packages/twindb_backup-2.15.7-py2.7.egg/twindb_backup/backup.py", line 121, in backup_mysql
    status = dst.status()
  File "/opt/twindb-backup/embedded/lib/python2.7/site-packages/twindb_backup-2.15.7-py2.7.egg/twindb_backup/destination/base_destination.py", line 118, in status
    return self._read_status()
  File "/opt/twindb-backup/embedded/lib/python2.7/site-packages/twindb_backup-2.15.7-py2.7.egg/twindb_backup/destination/ssh.py", line 200, in _read_status
    return MySQLStatus(content=stdout.read())
  File "/opt/twindb-backup/embedded/lib/python2.7/site-packages/twindb_backup-2.15.7-py2.7.egg/twindb_backup/status/mysql_status.py", line 94, in __init__
    raise CorruptedStatus('Corrupted status: %s', err.message)
twindb_backup.status.exceptions.CorruptedStatus: ('Corrupted status: %s', 'Unterminated string starting at: line 1 column 48876 (char 48875)')

I have tried uninstalling & installing the tool multiple times but its not working. its for a production server, request your help soon.

[Aleksandr Kuzminsky]

Hi Nishant,

In the version 2.15.7 (the latest as of now) we added status verification because sometimes the status got corrupted during network transfers.

I would suggest to delete the status file (it's a file named status in the remote destination directory).

Then start backups again.

Best,

Aleks