)]}'
{"/PATCHSET_LEVEL":[{"author":{"_account_id":30491,"name":"Radosław Piliszek","display_name":"Radek","email":"radek@piliszek.it","username":"yoctozepto","status":"self-employed techologist, collaborating mostly with 7bulls.com"},"change_message_id":"57ca4205d347421fff47a304e759ea26df663316","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":2,"id":"c211aef3_5074b206","updated":"2022-01-11 21:23:40.000000000","message":"any bug report?","commit_id":"377b6b4251834519c47aff71afa1ba2b7951c92c"}],"ansible/roles/mariadb/tasks/recover_cluster.yml":[{"author":{"_account_id":27339,"name":"Michal Arbet","email":"michal.arbet@ultimum.io","username":"michalarbet"},"change_message_id":"919c90fd9c83dbd8f0771802cc63347c2919a9d1","unresolved":true,"context_lines":[{"line_number":98,"context_line":"- name: Set grastate.dat file from MariaDB container in bootstrap host"},{"line_number":99,"context_line":"  become: true"},{"line_number":100,"context_line":"  lineinfile:"},{"line_number":101,"context_line":"    create: yes"},{"line_number":102,"context_line":"    dest: \"{{ docker_runtime_directory or \u0027/var/lib/docker\u0027 }}/volumes/mariadb/_data/grastate.dat\""},{"line_number":103,"context_line":"    regexp: \u0027safe_to_bootstrap:(.*)$\u0027"},{"line_number":104,"context_line":"    line: \u0027safe_to_bootstrap: 1\u0027"}],"source_content_type":"text/x-yaml","patch_set":2,"id":"1218ac33_1893a2b0","line":101,"range":{"start_line":101,"start_character":4,"end_line":101,"end_character":15},"updated":"2022-02-28 11:11:15.000000000","message":"why there is create: yes ?, we expect that gastate.dat exist in mariadb volume, otherwise we want ansible to fail.\n\nIf there is create: yes and grastate.dat not exist (for any reason), lineonfile will just create that file, which we don\u0027t want to.\n\nFrom ansible doc for lineinfile\n\nUsed with state\u003dpresent.\nIf specified, the file will be created if it does not already exist.\nBy default it will fail if the file is missing.\n\nMaybe it will help if you can describe the issue, when grastate.dat is missing ?","commit_id":"377b6b4251834519c47aff71afa1ba2b7951c92c"},{"author":{"_account_id":32657,"name":"Piotr Parczewski","email":"piotr@stackhpc.com","username":"piotrp"},"change_message_id":"e9f36db16c5a43cb0d078c2a1805d81dd7861e3f","unresolved":true,"context_lines":[{"line_number":98,"context_line":"- name: Set grastate.dat file from MariaDB container in bootstrap host"},{"line_number":99,"context_line":"  become: true"},{"line_number":100,"context_line":"  lineinfile:"},{"line_number":101,"context_line":"    create: yes"},{"line_number":102,"context_line":"    dest: \"{{ docker_runtime_directory or \u0027/var/lib/docker\u0027 }}/volumes/mariadb/_data/grastate.dat\""},{"line_number":103,"context_line":"    regexp: \u0027safe_to_bootstrap:(.*)$\u0027"},{"line_number":104,"context_line":"    line: \u0027safe_to_bootstrap: 1\u0027"}],"source_content_type":"text/x-yaml","patch_set":2,"id":"89a8cc1b_7e399741","line":101,"range":{"start_line":101,"start_character":4,"end_line":101,"end_character":15},"in_reply_to":"1218ac33_1893a2b0","updated":"2022-05-30 13:21:16.000000000","message":"Restore procedure states the following:\n\u003e Delete the old data files\nthis usually includes grastate.dat.","commit_id":"377b6b4251834519c47aff71afa1ba2b7951c92c"},{"author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"change_message_id":"6fd8b7137e7c3b1f28736205350dff93c3e62f7d","unresolved":true,"context_lines":[{"line_number":98,"context_line":"- name: Set grastate.dat file from MariaDB container in bootstrap host"},{"line_number":99,"context_line":"  become: true"},{"line_number":100,"context_line":"  lineinfile:"},{"line_number":101,"context_line":"    create: yes"},{"line_number":102,"context_line":"    dest: \"{{ docker_runtime_directory or \u0027/var/lib/docker\u0027 }}/volumes/mariadb/_data/grastate.dat\""},{"line_number":103,"context_line":"    regexp: \u0027safe_to_bootstrap:(.*)$\u0027"},{"line_number":104,"context_line":"    line: \u0027safe_to_bootstrap: 1\u0027"}],"source_content_type":"text/x-yaml","patch_set":2,"id":"efcbec85_2a8cb5cc","line":101,"range":{"start_line":101,"start_character":4,"end_line":101,"end_character":15},"in_reply_to":"30330188_8d21aafa","updated":"2022-05-30 13:55:22.000000000","message":"This task only runs on the bootstrap host, where we would expect grastate.dat to exist. If it doesn\u0027t exist, shouldn\u0027t that be an error?","commit_id":"377b6b4251834519c47aff71afa1ba2b7951c92c"},{"author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"change_message_id":"5be8a03c0f8ce296ab96a0341c41e44d2cfa95b6","unresolved":false,"context_lines":[{"line_number":98,"context_line":"- name: Set grastate.dat file from MariaDB container in bootstrap host"},{"line_number":99,"context_line":"  become: true"},{"line_number":100,"context_line":"  lineinfile:"},{"line_number":101,"context_line":"    create: yes"},{"line_number":102,"context_line":"    dest: \"{{ docker_runtime_directory or \u0027/var/lib/docker\u0027 }}/volumes/mariadb/_data/grastate.dat\""},{"line_number":103,"context_line":"    regexp: \u0027safe_to_bootstrap:(.*)$\u0027"},{"line_number":104,"context_line":"    line: \u0027safe_to_bootstrap: 1\u0027"}],"source_content_type":"text/x-yaml","patch_set":2,"id":"b5d26cb5_341488c4","line":101,"range":{"start_line":101,"start_character":4,"end_line":101,"end_character":15},"in_reply_to":"8720ec26_b748fff4","updated":"2022-05-31 08:12:58.000000000","message":"Ack","commit_id":"377b6b4251834519c47aff71afa1ba2b7951c92c"},{"author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"change_message_id":"baa1c67c394eec977189156356cba02d70d3c4b5","unresolved":true,"context_lines":[{"line_number":98,"context_line":"- name: Set grastate.dat file from MariaDB container in bootstrap host"},{"line_number":99,"context_line":"  become: true"},{"line_number":100,"context_line":"  lineinfile:"},{"line_number":101,"context_line":"    create: yes"},{"line_number":102,"context_line":"    dest: \"{{ docker_runtime_directory or \u0027/var/lib/docker\u0027 }}/volumes/mariadb/_data/grastate.dat\""},{"line_number":103,"context_line":"    regexp: \u0027safe_to_bootstrap:(.*)$\u0027"},{"line_number":104,"context_line":"    line: \u0027safe_to_bootstrap: 1\u0027"}],"source_content_type":"text/x-yaml","patch_set":2,"id":"f4fced78_85a68e42","line":101,"range":{"start_line":101,"start_character":4,"end_line":101,"end_character":15},"in_reply_to":"89a8cc1b_7e399741","updated":"2022-05-30 13:24:28.000000000","message":"Not on the bootstrap node though, right?","commit_id":"377b6b4251834519c47aff71afa1ba2b7951c92c"},{"author":{"_account_id":32657,"name":"Piotr Parczewski","email":"piotr@stackhpc.com","username":"piotrp"},"change_message_id":"7603972e3bc6e6866b82c72bdff22514e1104a6c","unresolved":true,"context_lines":[{"line_number":98,"context_line":"- name: Set grastate.dat file from MariaDB container in bootstrap host"},{"line_number":99,"context_line":"  become: true"},{"line_number":100,"context_line":"  lineinfile:"},{"line_number":101,"context_line":"    create: yes"},{"line_number":102,"context_line":"    dest: \"{{ docker_runtime_directory or \u0027/var/lib/docker\u0027 }}/volumes/mariadb/_data/grastate.dat\""},{"line_number":103,"context_line":"    regexp: \u0027safe_to_bootstrap:(.*)$\u0027"},{"line_number":104,"context_line":"    line: \u0027safe_to_bootstrap: 1\u0027"}],"source_content_type":"text/x-yaml","patch_set":2,"id":"8720ec26_b748fff4","line":101,"range":{"start_line":101,"start_character":4,"end_line":101,"end_character":15},"in_reply_to":"efcbec85_2a8cb5cc","updated":"2022-05-31 07:02:07.000000000","message":"In disaster recovery scenario it does not exist - as it\u0027s not part of the backup.","commit_id":"377b6b4251834519c47aff71afa1ba2b7951c92c"},{"author":{"_account_id":32657,"name":"Piotr Parczewski","email":"piotr@stackhpc.com","username":"piotrp"},"change_message_id":"6ed62da1c1e7fed29ba9c87fb3e9c41da58b5932","unresolved":true,"context_lines":[{"line_number":98,"context_line":"- name: Set grastate.dat file from MariaDB container in bootstrap host"},{"line_number":99,"context_line":"  become: true"},{"line_number":100,"context_line":"  lineinfile:"},{"line_number":101,"context_line":"    create: yes"},{"line_number":102,"context_line":"    dest: \"{{ docker_runtime_directory or \u0027/var/lib/docker\u0027 }}/volumes/mariadb/_data/grastate.dat\""},{"line_number":103,"context_line":"    regexp: \u0027safe_to_bootstrap:(.*)$\u0027"},{"line_number":104,"context_line":"    line: \u0027safe_to_bootstrap: 1\u0027"}],"source_content_type":"text/x-yaml","patch_set":2,"id":"30330188_8d21aafa","line":101,"range":{"start_line":101,"start_character":4,"end_line":101,"end_character":15},"in_reply_to":"f4fced78_85a68e42","updated":"2022-05-30 13:40:11.000000000","message":"Right; restore instructions could very well also include ``touch grastate.dat`` in the volumes, but I wanted to avoid that. I don\u0027t immediately see why do we want the following:\n\n\u003e we expect that gastate.dat exist in mariadb volume, otherwise we want ansible to fail.\n\nIf the file exists, Ansible is just continuing silently.","commit_id":"377b6b4251834519c47aff71afa1ba2b7951c92c"}],"doc/source/admin/mariadb-backup-and-restore.rst":[{"author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"change_message_id":"38574bc9c7b72468f73aa5953d18132e81e64b2e","unresolved":true,"context_lines":[{"line_number":111,"context_line":"   (dbrestore) $ rm -rf /var/lib/mysql/\\.[^\\.]*"},{"line_number":112,"context_line":"   (dbrestore) $ mariabackup --copy-back --target-dir /backup/restore/full"},{"line_number":113,"context_line":""},{"line_number":114,"context_line":"Then you can restart MariaDB with the restored data in place, in case of single"},{"line_number":115,"context_line":"node deployments:"},{"line_number":116,"context_line":""},{"line_number":117,"context_line":".. code-block:: console"},{"line_number":118,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"f7395cdb_a61d9e1b","line":115,"range":{"start_line":114,"start_character":0,"end_line":115,"end_character":17},"updated":"2022-01-05 12:16:33.000000000","message":"Let\u0027s make the single/multi node steps a bit more clear.\n\nThen you can restart MariaDB with the restored data in place.\n\nFor single node deployments:","commit_id":"5e514d999cb8d4583734db2b27096327ff8285e0"},{"author":{"_account_id":32657,"name":"Piotr Parczewski","email":"piotr@stackhpc.com","username":"piotrp"},"change_message_id":"d0cd5ca08d2863f1e3ddda9d81098d95d86a036f","unresolved":false,"context_lines":[{"line_number":111,"context_line":"   (dbrestore) $ rm -rf /var/lib/mysql/\\.[^\\.]*"},{"line_number":112,"context_line":"   (dbrestore) $ mariabackup --copy-back --target-dir /backup/restore/full"},{"line_number":113,"context_line":""},{"line_number":114,"context_line":"Then you can restart MariaDB with the restored data in place, in case of single"},{"line_number":115,"context_line":"node deployments:"},{"line_number":116,"context_line":""},{"line_number":117,"context_line":".. code-block:: console"},{"line_number":118,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"62874c71_10f71aeb","line":115,"range":{"start_line":114,"start_character":0,"end_line":115,"end_character":17},"in_reply_to":"f7395cdb_a61d9e1b","updated":"2022-01-11 20:47:06.000000000","message":"Ack","commit_id":"5e514d999cb8d4583734db2b27096327ff8285e0"}]}