PLAY [all] ********************************************************************* TASK [Gathering Facts] ********************************************************* ok: [localhost] TASK [debug] ******************************************************************* ok: [localhost] => { "msg": "Using 'test' 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 '49240' as staff port" } TASK [Get host port for sandbox opac port] ************************************* changed: [localhost] TASK [debug] ******************************************************************* ok: [localhost] => { "msg": "Using '49241' as opac port" } TASK [Get host port for sandbox ssh port] ************************************** changed: [localhost] TASK [debug] ******************************************************************* ok: [localhost] => { "msg": "Using '49241' 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-test to ansible hosts] ************************* ok: [localhost] TASK [Test connection to docker container] ************************************* changed: [localhost -> koha-test] 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 test in docker container] ***************************** skipping: [localhost] TASK [git checkout commit_id or tag in docker container] ********************** skipping: [localhost] TASK [git checkout test/ in docker container] ********************************** skipping: [localhost] TASK [Marking repo as a safe git directory] ************************************ changed: [localhost -> koha-test] TASK [Checkout origin/main in docker container] ******************************** changed: [localhost -> koha-test] TASK [Apply bug via git-bz in docker container] ******************************* skipping: [localhost] TASK [Generating CSS and JS using yarn build] ********************************** skipping: [localhost] TASK [Install OpenSSH Server] ************************************************** changed: [localhost -> koha-test] TASK [Enable PermitRootLogin for sshd] ***************************************** changed: [localhost -> koha-test] TASK [Start sshd] ************************************************************** changed: [localhost -> koha-test] TASK [Set root password to 'koha'] ********************************************* changed: [localhost -> koha-test] TASK [Install Postfix MTA] ***************************************************** changed: [localhost -> koha-test] TASK [Enable smtp-sink for mail] *********************************************** changed: [localhost -> koha-test] TASK [Enable email processing] ************************************************* changed: [localhost -> koha-test] TASK [Index the records for the first time] ************************************ changed: [localhost -> koha-test] TASK [Restart Zebra after indexing records] ************************************ changed: [localhost -> koha-test] TASK [Restart Plack after indexing records] ************************************ changed: [localhost -> koha-test] 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-test] RUNNING HANDLER [Run updatedatabase.pl in docker container] ******************** fatal: [localhost -> koha-test]: FAILED! => {"changed": true, "cmd": "koha-shell -c 'perl -I /kohadevbox/koha /kohadevbox/koha/installer/data/mysql/updatedatabase.pl' test", "delta": "0:00:07.111914", "end": "2024-05-15 09:45:50.199000", "msg": "non-zero return code", "rc": 11, "start": "2024-05-15 09:45:43.087086", "stderr": "DBD::mysql::st execute failed: Table 'koha_test.systempreferences' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.\nDBD::mysql::st execute failed: Table 'koha_test.systempreferences' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.\nUse of uninitialized value in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 82.\nDBD::mysql::db do failed: Table 'koha_test.bookshelf' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.\nDBD::mysql::db do failed: Table 'koha_test.shelfcontents' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.\nDBD::mysql::db do failed: Table 'koha_test.virtualshelfcontents' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.\nDBD::mysql::db do failed: Table 'koha_test.virtualshelfcontents' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.\nUndefined subroutine &main::DropAllForeignKeys called at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 90.", "stderr_lines": ["DBD::mysql::st execute failed: Table 'koha_test.systempreferences' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.", "DBD::mysql::st execute failed: Table 'koha_test.systempreferences' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.", "Use of uninitialized value in numeric lt (<) at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 82.", "DBD::mysql::db do failed: Table 'koha_test.bookshelf' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.", "DBD::mysql::db do failed: Table 'koha_test.shelfcontents' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.", "DBD::mysql::db do failed: Table 'koha_test.virtualshelfcontents' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.", "DBD::mysql::db do failed: Table 'koha_test.virtualshelfcontents' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.", "Undefined subroutine &main::DropAllForeignKeys called at /kohadevbox/koha/installer/data/mysql/updatedatabase.pl line 90."], "stdout": "", "stdout_lines": []} NO MORE HOSTS LEFT ************************************************************* PLAY RECAP ********************************************************************* localhost : ok=40 changed=31 unreachable=0 failed=1 skipped=7 rescued=0 ignored=0