Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    Anthony Lapenna
    @deviantony
    if there is a clean way to do it, I'll do it
    but I don't want to add more complexity to the code just to manage OS
    anyway, I'll think about it
    do not forget to open the issue please :)
    Imre Bertalan
    @bertalanimre
    I won't :)
    but 1st I want to see if it is enough if I modify the line according to my system

    I'll just modify the line like this:

    command = ['/etc/init.d/' + service_name, action]
    command=['systemctl' + action, service_name]

    should work :)
    Anthony Lapenna
    @deviantony
    try
    command = [ 'systemctl', action, service_name]
    Imre Bertalan
    @bertalanimre
    ok
    same error? O.o
    do I need to do something after just modify of the file?
    Anthony Lapenna
    @deviantony
    I don't think so
    how did you install the package?
    Imre Bertalan
    @bertalanimre
    cloned the git, then pip
    Anthony Lapenna
    @deviantony
    ok you do not need to clone the git repository
    pip will fetch the tool from pypi
    so I guess you've edited the bad file
    Imre Bertalan
    @bertalanimre
    a-ha. Never used python before, so I didn't know what pip is :P
    Anthony Lapenna
    @deviantony
    ok
    Imre Bertalan
    @bertalanimre
    "bad" file, indeed. :P Yes I've
    Anthony Lapenna
    @deviantony
    it's a package manager for Python
    allows you to install Python packages quite easily
    now, you need to find where pip installs packages on Centos
    normally you'll find a pyxtrabackup folder in here and you'll be able to edit the file
    Imre Bertalan
    @bertalanimre
    my OS found only one file
    /usr/bin/pyxtrabackup
    with that name
    Anthony Lapenna
    @deviantony
    w8
    I'll look on one of my systems
    Imre Bertalan
    @bertalanimre
    k
    Anthony Lapenna
    @deviantony
    I was able to find it in: /usr/local/lib/python2.7/dist-packages/xtrabackup
    Imre Bertalan
    @bertalanimre
    checking...
    Anthony Lapenna
    @deviantony
    should be the sources used by the pyxtrabackup script
    you may need to change the python version though
    Imre Bertalan
    @bertalanimre
    :/ /usr/local/lib/ is empty for me
    pip -V
    pip 7.1.2 from /usr/lib/python2.7/site-packages/pip-7.1.2-py2.7.egg (python 2.7)
    aha
    found it
    /usr/lib/python2.7/site-packages/xtrabackup
    lol, I've executed the right file from the beginning. The command looks just like we have figured: command = ['systemctl', action, service_name]
    Anthony Lapenna
    @deviantony
    so you've updated /usr/lib/python2.7/site-packages/xtrabackup/command_executor.py ?
    Imre Bertalan
    @bertalanimre
    yes
    I'll upload the whole error message in an instant
    Anthony Lapenna
    @deviantony
    I'll need to move out
    leave some messages here
    I'll check tomorrow
    Imre Bertalan
    @bertalanimre
    This was tricky a lot. :)
    So I've modified the line in "/usr/lib/python2.7/site-packages/xtrabackup/command_executor.py" line 67 to command = ['systemctl', action, 'mariadb']
    After this, the restore seemd to run fine, but couldn't check it,because the mariadb server stopped and wasn't able to run any more.
    As it turned out, the key file was the "/var/log/mariadb/mariadb.log" that told me there was a size error with the "innodb_log_file_size". It differed from the one that was set up in the "/etc/my.cnf" file which is used by XtraBackup. Adjusted the number to the same number requested according to the error message, now the MariaDB server started like a charm and (Here come the best part) it restored the dropped table. :) I'mm test it a few more times before I send it to live, but seems like this will be a good way. I aggree with your User stops mysql server, app does the backup, user starts the mysql server method. Could be a working one. But since this works now, I think I'll keep this one. :D
    Thanks a lot! I'll let you informed about the tests :)
    Anthony Lapenna
    @deviantony
    cool :+1: