PLAY [all] *********************************************************************

TASK [Gathering Facts] *********************************************************
ok: [localhost]

TASK [debug] *******************************************************************
ok: [localhost] => {
    "msg": "Using 'bug40504' as instance name"
}

TASK [Check if git dir already exists] *****************************************
ok: [localhost]

TASK [Force get new tags and branches] *****************************************
changed: [localhost]

TASK [Clone koha source to /usr/local/src/koha] ********************************
skipping: [localhost]

TASK [Copy source koha clone for sandbox] **************************************
changed: [localhost]

TASK [Change owner for koha clone for sandbox] *********************************
changed: [localhost]

TASK [Create a new database for Koha instance] *********************************
changed: [localhost]

TASK [Ensure user doesn't exist or the create below will fail] *****************
changed: [localhost]

TASK [mysql_user] **************************************************************
changed: [localhost]

TASK [Install koha git config for sandbox] *************************************
changed: [localhost]

TASK [Start new koha-testing-docker container] *********************************
changed: [localhost]

TASK [Get host port for sandbox staff port] ************************************
changed: [localhost]

TASK [debug] *******************************************************************
ok: [localhost] => {
    "msg": "Using '32812' as staff port"
}

TASK [Get host port for sandbox opac port] *************************************
changed: [localhost]

TASK [debug] *******************************************************************
ok: [localhost] => {
    "msg": "Using '32811' as opac port"
}

TASK [Get host port for sandbox ssh port] **************************************
changed: [localhost]

TASK [debug] *******************************************************************
ok: [localhost] => {
    "msg": "Using '32811' as ssh port"
}

TASK [Install apache config for sandbox instance] ******************************
changed: [localhost]

TASK [Symlink the new apache config from sites-available to sites-enabled] *****
changed: [localhost]

TASK [Add docker container koha-bug40504 to ansible hosts] *********************
ok: [localhost]

TASK [Test connection to docker container] *************************************
changed: [localhost -> koha-bug40504]

TASK [debug] *******************************************************************
skipping: [localhost]

TASK [Pausing for 5 minutes whilst container sets itself up] *******************
Pausing for 300 seconds
(ctrl+C then 'C' = continue early, ctrl+C then 'A' = abort)
ok: [localhost]

TASK [debug] *******************************************************************
ok: [localhost] => {
    "msg": "GIT_REMOTE is set to "
}

TASK [Add git remote  as bug40504 in docker container] *************************
skipping: [localhost]

TASK [git checkout commit_id or tag  in docker container] **********************
skipping: [localhost]

TASK [git checkout bug40504/ in docker container] ******************************
skipping: [localhost]

TASK [Marking repo as a safe git directory] ************************************
changed: [localhost -> koha-bug40504]

TASK [Checkout origin/main in docker container] ********************************
changed: [localhost -> koha-bug40504]

TASK [Apply bug 40504 via git-bz in docker container] **************************
changed: [localhost -> koha-bug40504]

TASK [Generating CSS and JS using yarn build] **********************************
changed: [localhost -> koha-bug40504]

TASK [Apt Update & Upgrade] ****************************************************
ok: [localhost -> koha-bug40504]

TASK [Install OpenSSH Server] **************************************************
changed: [localhost -> koha-bug40504]

TASK [Enable PermitRootLogin for sshd] *****************************************
changed: [localhost -> koha-bug40504]

TASK [Start sshd] **************************************************************
changed: [localhost -> koha-bug40504]

TASK [Set root password to 'koha'] *********************************************
changed: [localhost -> koha-bug40504]

TASK [Install Postfix MTA] *****************************************************
changed: [localhost -> koha-bug40504]

TASK [Enable smtp-sink for mail] ***********************************************
changed: [localhost -> koha-bug40504]

TASK [Enable email processing] *************************************************
changed: [localhost -> koha-bug40504]

TASK [Index the records for the first time] ************************************
changed: [localhost -> koha-bug40504]

TASK [Restart Zebra after indexing records] ************************************
changed: [localhost -> koha-bug40504]

TASK [Restart Plack after indexing records] ************************************
changed: [localhost -> koha-bug40504]

TASK [Restart apache, one last time] *******************************************
changed: [localhost]

TASK [Clean up docker files] ***************************************************
changed: [localhost]

RUNNING HANDLER [Restart apache] ***********************************************
changed: [localhost]

RUNNING HANDLER [Update koha git repo for sandbox] *****************************
changed: [localhost]

RUNNING HANDLER [Restart plack in docker container] ****************************
changed: [localhost -> koha-bug40504]

RUNNING HANDLER [Run updatedatabase.pl in docker container] ********************
fatal: [localhost -> koha-bug40504]: FAILED! => {"changed": true, "cmd": "koha-shell -c 'perl -I /kohadevbox/koha /kohadevbox/koha/installer/data/mysql/updatedatabase.pl' bug40504", "delta": "0:00:01.317870", "end": "2025-10-23 14:03:26.325361", "msg": "non-zero return code", "rc": 1, "start": "2025-10-23 14:03:25.007491", "stderr": "", "stderr_lines": [], "stdout": "DEV atomic update /kohadevbox/koha/installer/data/mysql/atomicupdate/bug_40504.pl  [14:03:26]: Bug 40504 - Add managedby column to illrequests table\n\t\u001b[31mERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'member manager of request'' AFTER borrowernumber' at line 1 at /kohadevbox/koha/C4/Installer.pm line 825\n\t\u001b[0m", "stdout_lines": ["DEV atomic update /kohadevbox/koha/installer/data/mysql/atomicupdate/bug_40504.pl  [14:03:26]: Bug 40504 - Add managedby column to illrequests table", "\t\u001b[31mERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'member manager of request'' AFTER borrowernumber' at line 1 at /kohadevbox/koha/C4/Installer.pm line 825", "\t\u001b[0m"]}

PLAY RECAP *********************************************************************
localhost                  : ok=43   changed=33   unreachable=0    failed=1    skipped=5    rescued=0    ignored=0