ProjectName: pmm-update Version: 2.29.0-PMM-5885-upgrade-postgres-to-14-ec741f69 PMMVersion: 2.29.0-PMM-5885-upgrade-postgres-to-14-ec741f69 Timestamp: 2022-06-21 12:45:09 (UTC) FullCommit: 3e1bab3855caf0c6e3a92594d79ad85dde1d809c Starting "yum --verbose info installed pmm-update" ... Loading "changelog" plugin Loading "fastestmirror" plugin Loading "ovl" plugin Config time: 0.012 rpmdb time: 0.000 ovl: Copying up (0) files from OverlayFS lower layer Yum version: 3.4.3 Installed Packages Name : pmm-update Arch : noarch Version : 2.29.0 Release : 65.2206211245.3e1bab3.el7 Size : 2.2 M Repo : installed From repo : pmm2-server Committer : Nikita Beletskii Committime : Mon May 16 12:00:00 2022 Buildtime : Tue Jun 21 12:45:12 2022 Install time: Thu Jun 23 09:43:12 2022 Installed by: System Changed by : System Summary : Tool for updating packages and OS configuration for PMM Server URL : https://github.com/percona/pmm-update License : AGPLv3 Description : Tool for updating packages and OS configuration for PMM Server Starting "yum update --assumeyes pmm-update" ... Loaded plugins: changelog, fastestmirror, ovl Loading mirror speeds from cached hostfile * base: download.cf.centos.org * epel: dl.fedoraproject.org * extras: download.cf.centos.org * updates: download.cf.centos.org No packages marked for update Starting "yum --verbose info installed pmm-update" ... Loading "changelog" plugin Loading "fastestmirror" plugin Loading "ovl" plugin Config time: 0.011 rpmdb time: 0.000 ovl: Copying up (0) files from OverlayFS lower layer Yum version: 3.4.3 Installed Packages Name : pmm-update Arch : noarch Version : 2.29.0 Release : 65.2206211245.3e1bab3.el7 Size : 2.2 M Repo : installed From repo : pmm2-server Committer : Nikita Beletskii Committime : Mon May 16 12:00:00 2022 Buildtime : Tue Jun 21 12:45:12 2022 Install time: Thu Jun 23 09:43:12 2022 Installed by: System Changed by : System Summary : Tool for updating packages and OS configuration for PMM Server URL : https://github.com/percona/pmm-update License : AGPLv3 Description : Tool for updating packages and OS configuration for PMM Server time="2022-06-23T11:42:12Z" level=info msg="pmm-update:\nbefore update = {Version:2.29.0 FullVersion:2.29.0-65.2206211245.3e1bab3.el7 BuildTime:2022-06-21 12:45:12 +0000 UTC Repo:pmm2-server}\n after update = {Version:2.29.0 FullVersion:2.29.0-65.2206211245.3e1bab3.el7 BuildTime:2022-06-21 12:45:12 +0000 UTC Repo:pmm2-server}" time="2022-06-23T11:42:12Z" level=info msg="Version did not change." Starting "ansible-playbook --flush-cache /usr/share/pmm-update/ansible/playbook/tasks/update.yml" ... [WARNING]: provided hosts list is empty, only localhost is available. Note that the implicit localhost does not match 'all' PLAY [localhost] *************************************************************** TASK [Gathering Facts] ********************************************************* ok: [localhost] TASK [detect /srv/pmm-distribution] ******************************************** ok: [localhost] TASK [detect containers] ******************************************************* ok: [localhost] TASK [force container] ********************************************************* skipping: [localhost] TASK [Remove percona-dashboard without architecture] *************************** ok: [localhost] TASK [Update percona-dashboards package] *************************************** ok: [localhost] TASK [Create supervisor dir] *************************************************** ok: [localhost] TASK [Upgrade supervisor config] *********************************************** ok: [localhost] TASK [Remove supervisord block from pmm.ini] *********************************** skipping: [localhost] TASK [Create grafana config] *************************************************** TASK [Create grafana directory] ************************************************ ok: [localhost] => (item=/srv/grafana) changed: [localhost] => (item=/srv/grafana/plugins) TASK [grafana : Set Grafana folder for plugins on /srv partition for all users] *** ok: [localhost] TASK [Copy new version of grafana.ini] ***************************************** ok: [localhost] TASK [grafana : Create provisioning directory] ********************************* ok: [localhost] => (item=datasources) ok: [localhost] => (item=plugins) ok: [localhost] => (item=dashboards) TASK [Copy grafana provisioning files] ***************************************** ok: [localhost] => (item=datasources) ok: [localhost] => (item=plugins) ok: [localhost] => (item=dashboards) TASK [Upgrade grafana database (Get the latest schema)] ************************ changed: [localhost] TASK [Install postgres] ******************************************************** TASK [postgres : Add PostgreSQL 14 YUM repository] ***************************** ok: [localhost] TASK [postgres : Add PostgreSQL 11 YUM repository] ***************************** ok: [localhost] TASK [postgres : Install Postgres] ********************************************* ok: [localhost] TASK [postgres : Create Postgres log file] ************************************* changed: [localhost] TASK [Add the user 'postgres' to group 'pmm'] ********************************** ok: [localhost] TASK [postgres : Check if Postgres 14 directory exists] ************************ ok: [localhost] TASK [postgres : Create Postgres data dir] ************************************* skipping: [localhost] TASK [postgres : Initialize Postgres database] ********************************* skipping: [localhost] TASK [postgres : Check that supervisor socket exists (Upgrade or init)] ******** skipping: [localhost] TASK [Stop pmm-managed and postgres before backup database] ******************** skipping: [localhost] => (item=pmm-managed) skipping: [localhost] => (item=postgresql) TASK [postgres : Run Postgres database without supervisor] ********************* skipping: [localhost] TASK [postgres : Dump pmm-managed database] ************************************ skipping: [localhost] TASK [postgres : Stop Postgres database without supervisor] ******************** skipping: [localhost] TASK [postgres : Start Postgres 14 database without supervisor] **************** skipping: [localhost] TASK [postgres : Create pmm-managed database] ********************************** skipping: [localhost] TASK [postgres : PostgresDB | Create pmm-managed user] ********** skipping: [localhost] TASK [postgres : Restore pmm-managed database] ********************************* skipping: [localhost] TASK [postgres : Check pg_stat_statements extension] *************************** skipping: [localhost] TASK [postgres : Stop Postgres 14 database without supervisor] ***************** skipping: [localhost] TASK [postgres : Rename old Postgres directory] ******************************** skipping: [localhost] TASK [postgres : Remove old Postgres direcroty] ******************************** skipping: [localhost] TASK [postgres : Restart Postgres] ********************************************* skipping: [localhost] => (item=stop) skipping: [localhost] => (item=remove) skipping: [localhost] => (item=add) TASK [postgres : Run pmm-managed again] **************************************** skipping: [localhost] TASK [Supervisord start | Start supervisord service for AMI/OVF] ******** skipping: [localhost] TASK [Check that supervisor socket exists] ************************************* ok: [localhost] TASK [Supervisord start | Start supervisord for docker] **************** skipping: [localhost] TASK [Run initialization playbook] ********************************************* TASK [initialization : Get current version] ************************************ ok: [localhost] TASK [initialization : Get image version] ************************************** ok: [localhost] TASK [initialization : Set current version if VERSION fail doen't exist] ******* skipping: [localhost] TASK [initialization : Setting current and image version] ********************** ok: [localhost] TASK [initialization : Setting current and image version] ********************** ok: [localhost] TASK [initialization : Print current version] ********************************** ok: [localhost] => { "msg": "Current version: 2.23.0 Image Version: 2.29.0" } TASK [Checking if we need an update or not] ************************************ TASK [dashboards_upgrade : Check that old plugin dir exists] ******************* ok: [localhost] TASK [dashboards_upgrade : Find custom plugin in old plugin dir] *************** skipping: [localhost] TASK [dashboards_upgrade : Synchronization plugins (old version before 2.22.0)] *** skipping: [localhost] TASK [dashboards_upgrade : Find custom plugin in old plugin dir] *************** skipping: [localhost] TASK [dashboards_upgrade : Get plugin list] ************************************ ok: [localhost] TASK [dashboards_upgrade : Delete existing dist folder] ************************ changed: [localhost] => (item={u'rusr': True, u'uid': 0, u'rgrp': True, u'xoth': True, u'islnk': False, u'woth': False, u'nlink': 3, u'issock': False, u'mtime': 1655977421.5035374, u'gr_name': u'root', u'path': u'/usr/share/percona-dashboards/panels/camptocamp-prometheus-alertmanager-datasource', u'xusr': True, u'atime': 1655977476.295792, u'inode': 26535975, u'isgid': False, u'size': 146, u'isdir': True, u'ctime': 1655977421.5035374, u'isblk': False, u'wgrp': False, u'xgrp': True, u'isuid': False, u'dev': 39, u'roth': True, u'isreg': False, u'isfifo': False, u'mode': u'0755', u'pw_name': u'root', u'gid': 0, u'ischr': False, u'wusr': True}) changed: [localhost] => (item={u'rusr': True, u'uid': 0, u'rgrp': True, u'xoth': True, u'islnk': False, u'woth': False, u'nlink': 3, u'issock': False, u'mtime': 1655977421.5075376, u'gr_name': u'root', u'path': u'/usr/share/percona-dashboards/panels/digiapulssi-breadcrumb-panel', u'xusr': True, u'atime': 1655977476.295792, u'inode': 34769721, u'isgid': False, u'size': 270, u'isdir': True, u'ctime': 1655977421.5075376, u'isblk': False, u'wgrp': False, u'xgrp': True, u'isuid': False, u'dev': 39, u'roth': True, u'isreg': False, u'isfifo': False, u'mode': u'0755', u'pw_name': u'root', u'gid': 0, u'ischr': False, u'wusr': True}) changed: [localhost] => (item={u'rusr': True, u'uid': 0, u'rgrp': True, u'xoth': True, u'islnk': False, u'woth': False, u'nlink': 4, u'issock': False, u'mtime': 1655977421.5395377, u'gr_name': u'root', u'path': u'/usr/share/percona-dashboards/panels/grafana-piechart-panel', u'xusr': True, u'atime': 1655977476.295792, u'inode': 46826745, u'isgid': False, u'size': 277, u'isdir': True, u'ctime': 1655977421.5395377, u'isblk': False, u'wgrp': False, u'xgrp': True, u'isuid': False, u'dev': 39, u'roth': True, u'isreg': False, u'isfifo': False, u'mode': u'0755', u'pw_name': u'root', u'gid': 0, u'ischr': False, u'wusr': True}) changed: [localhost] => (item={u'rusr': True, u'uid': 0, u'rgrp': True, u'xoth': True, u'islnk': False, u'woth': False, u'nlink': 5, u'issock': False, u'mtime': 1655977421.6515381, u'gr_name': u'root', u'path': u'/usr/share/percona-dashboards/panels/grafana-polystat-panel', u'xusr': True, u'atime': 1655977476.295792, u'inode': 6920878, u'isgid': False, u'size': 275, u'isdir': True, u'ctime': 1655977421.6515381, u'isblk': False, u'wgrp': False, u'xgrp': True, u'isuid': False, u'dev': 39, u'roth': True, u'isreg': False, u'isfifo': False, u'mode': u'0755', u'pw_name': u'root', u'gid': 0, u'ischr': False, u'wusr': True}) changed: [localhost] => (item={u'rusr': True, u'uid': 0, u'rgrp': True, u'xoth': True, u'islnk': False, u'woth': False, u'nlink': 6, u'issock': False, u'mtime': 1655977421.839539, u'gr_name': u'root', u'path': u'/usr/share/percona-dashboards/panels/grafana-worldmap-panel', u'xusr': True, u'atime': 1655977476.295792, u'inode': 26535983, u'isgid': False, u'size': 188, u'isdir': True, u'ctime': 1655977421.839539, u'isblk': False, u'wgrp': False, u'xgrp': True, u'isuid': False, u'dev': 39, u'roth': True, u'isreg': False, u'isfifo': False, u'mode': u'0755', u'pw_name': u'root', u'gid': 0, u'ischr': False, u'wusr': True}) changed: [localhost] => (item={u'rusr': True, u'uid': 0, u'rgrp': True, u'xoth': True, u'islnk': False, u'woth': False, u'nlink': 3, u'issock': False, u'mtime': 1655977422.279541, u'gr_name': u'root', u'path': u'/usr/share/percona-dashboards/panels/jdbranham-diagram-panel', u'xusr': True, u'atime': 1655977476.295792, u'inode': 46826759, u'isgid': False, u'size': 175, u'isdir': True, u'ctime': 1655977422.279541, u'isblk': False, u'wgrp': False, u'xgrp': True, u'isuid': False, u'dev': 39, u'roth': True, u'isreg': False, u'isfifo': False, u'mode': u'0755', u'pw_name': u'root', u'gid': 0, u'ischr': False, u'wusr': True}) changed: [localhost] => (item={u'rusr': True, u'uid': 0, u'rgrp': True, u'xoth': True, u'islnk': False, u'woth': False, u'nlink': 4, u'issock': False, u'mtime': 1655977422.3475413, u'gr_name': u'root', u'path': u'/usr/share/percona-dashboards/panels/natel-discrete-panel', u'xusr': True, u'atime': 1655977476.295792, u'inode': 1115936, u'isgid': False, u'size': 191, u'isdir': True, u'ctime': 1655977422.3475413, u'isblk': False, u'wgrp': False, u'xgrp': True, u'isuid': False, u'dev': 39, u'roth': True, u'isreg': False, u'isfifo': False, u'mode': u'0755', u'pw_name': u'root', u'gid': 0, u'ischr': False, u'wusr': True}) changed: [localhost] => (item={u'rusr': True, u'uid': 0, u'rgrp': True, u'xoth': True, u'islnk': False, u'woth': False, u'nlink': 7, u'issock': False, u'mtime': 1655977422.4315417, u'gr_name': u'root', u'path': u'/usr/share/percona-dashboards/panels/petrslavotinek-carpetplot-panel', u'xusr': True, u'atime': 1655977476.295792, u'inode': 14491040, u'isgid': False, u'size': 4096, u'isdir': True, u'ctime': 1655977422.4315417, u'isblk': False, u'wgrp': False, u'xgrp': True, u'isuid': False, u'dev': 39, u'roth': True, u'isreg': False, u'isfifo': False, u'mode': u'0755', u'pw_name': u'root', u'gid': 0, u'ischr': False, u'wusr': True}) changed: [localhost] => (item={u'rusr': True, u'uid': 0, u'rgrp': True, u'xoth': True, u'islnk': False, u'woth': False, u'nlink': 3, u'issock': False, u'mtime': 1655977422.4315417, u'gr_name': u'root', u'path': u'/usr/share/percona-dashboards/panels/pmm-app', u'xusr': True, u'atime': 1655977476.295792, u'inode': 9751637, u'isgid': False, u'size': 18, u'isdir': True, u'ctime': 1655977422.4315417, u'isblk': False, u'wgrp': False, u'xgrp': True, u'isuid': False, u'dev': 39, u'roth': True, u'isreg': False, u'isfifo': False, u'mode': u'0755', u'pw_name': u'root', u'gid': 0, u'ischr': False, u'wusr': True}) changed: [localhost] => (item={u'rusr': True, u'uid': 0, u'rgrp': True, u'xoth': True, u'islnk': False, u'woth': False, u'nlink': 4, u'issock': False, u'mtime': 1655977425.019554, u'gr_name': u'root', u'path': u'/usr/share/percona-dashboards/panels/vertamedia-clickhouse-datasource', u'xusr': True, u'atime': 1655977476.295792, u'inode': 39397656, u'isgid': False, u'size': 213, u'isdir': True, u'ctime': 1655977425.019554, u'isblk': False, u'wgrp': False, u'xgrp': True, u'isuid': False, u'dev': 39, u'roth': True, u'isreg': False, u'isfifo': False, u'mode': u'0755', u'pw_name': u'root', u'gid': 0, u'ischr': False, u'wusr': True}) changed: [localhost] => (item={u'rusr': True, u'uid': 0, u'rgrp': True, u'xoth': True, u'islnk': False, u'woth': False, u'nlink': 7, u'issock': False, u'mtime': 1655977425.1275544, u'gr_name': u'root', u'path': u'/usr/share/percona-dashboards/panels/yesoreyeram-boomtable-panel', u'xusr': True, u'atime': 1655977476.295792, u'inode': 51562492, u'isgid': False, u'size': 181, u'isdir': True, u'ctime': 1655977425.1275544, u'isblk': False, u'wgrp': False, u'xgrp': True, u'isuid': False, u'dev': 39, u'roth': True, u'isreg': False, u'isfifo': False, u'mode': u'0755', u'pw_name': u'root', u'gid': 0, u'ischr': False, u'wusr': True}) TASK [dashboards_upgrade : Synchronization plugin] ***************************** changed: [localhost] TASK [dashboards_upgrade : Check that the SQLite grafana database exists] ****** ok: [localhost] TASK [dashboards_upgrade : Restart grafana before delete data] ***************** fatal: [localhost]: FAILED! => {"changed": false, "msg": "ERROR (no such process)", "name": "grafana"} PLAY RECAP ********************************************************************* localhost : ok=30 changed=5 unreachable=0 failed=1 skipped=25 rescued=0 ignored=0 time="2022-06-23T11:42:33Z" level=fatal msg="RunPlaybook failed: exit status 2"