could not load library "/usr/pgsql-11/lib/timescaledb.so": /usr/pgsql-11/lib/timescaledb.so: undefined symbol: getmissingattr

[tjyang]

Relevant system information:

• OS: Latest CentOS 7

  [root@zabbixts02 ~]# cat /etc/redhat-release
  CentOS Linux release 7.6.1810 (Core)
  [root@zabbixts02 ~]#

• PostgreSQL version (output of postgres --version): [e.g. 10.5, 9.6.10]

[root@zabbixts02 ]# postgres --version
postgres (PostgreSQL) 11.1
[root@zabbixts02 ]#

• TimescaleDB version (output of \dx in psql): [e.g. 1.0.0]

[root@zabbixts02 ~]# rpm -qa |egrep 'timescaledb-post|postgresq';date
postgresql11-11.1-1PGDG.rhel7.x86_64
postgresql11-libs-11.1-1PGDG.rhel7.x86_64
timescaledb-postgresql-11-1.2.1-0.el7.x86_64
postgresql11-server-11.1-1PGDG.rhel7.x86_64
postgresql11-devel-11.1-1PGDG.rhel7.x86_64
Sat Apr 13 19:02:04 EDT 2019
[root@zabbixts02 ~]#

• Installation method: [e.g., "using Docker", "apt install", "source"] yum update

  
  [root@zabbixts02 ~]# cat /etc/yum.repos.d/timescale_timescaledb.repo
  [timescale_timescaledb]
  name=timescale_timescaledb
  baseurl=https://packagecloud.io/timescale/timescaledb/el/7/$basearch
  repo_gpgcheck=1
  gpgcheck=0
  enabled=1
  gpgkey=https://packagecloud.io/timescale/timescaledb/gpgkey
  sslverify=1
  sslcacert=/etc/pki/tls/certs/ca-bundle.crt
  metadata_expire=300
  [root@zabbixts02 ~]#

**Describe the bug**
timescaledb-postgresql-11-1.2.1-2 rpm package  has issue.

**To Reproduce**
Steps to reproduce the behavior:
1. Go to '...'
yum update -y timescaledb-postgresql # from timescaledb-postgresql-11-1.2.1 version
2. systemctl restart postgresql-11
3. See error

[root@zabbixts02 ~]# systemctl status -l postgresql-11 ● postgresql-11.service - PostgreSQL 11 database server Loaded: loaded (/usr/lib/systemd/system/postgresql-11.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Sat 2019-04-13 15:54:25 EDT; 8min ago Docs: https://www.postgresql.org/docs/11/static/ Process: 10257 ExecStart=/usr/pgsql-11/bin/postmaster -D ${PGDATA} (code=exited, status=1/FAILURE) Process: 10251 ExecStartPre=/usr/pgsql-11/bin/postgresql-11-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS) Main PID: 10257 (code=exited, status=1/FAILURE)

Apr 13 15:54:25 zabbixts02 systemd[1]: Starting PostgreSQL 11 database server... Apr 13 15:54:25 zabbixts02 postmaster[10257]: 2019-04-13 14:54:25.527 CDT [10257] FATAL: could not load library "/usr/pgsql-11/lib/timescaledb.so": /usr/pgsql-11/lib/timescaledb.so: undefined symbol: getmissingattr Apr 13 15:54:25 zabbixts02 postmaster[10257]: 2019-04-13 14:54:25.527 CDT [10257] LOG: database system is shut down Apr 13 15:54:25 zabbixts02 systemd[1]: postgresql-11.service: main process exited, code=exited, status=1/FAILURE Apr 13 15:54:25 zabbixts02 systemd[1]: Failed to start PostgreSQL 11 database server. Apr 13 15:54:25 zabbixts02 systemd[1]: Unit postgresql-11.service entered failed state. Apr 13 15:54:25 zabbixts02 systemd[1]: postgresql-11.service failed. [root@zabbixts02 ~]#

**Expected behavior**

Be able start up postgresql-11 after timescaledb upgrade.

**Actual behavior**
A clear and concise description of what _actually_ happened.

**Screenshots**
If applicable, add screenshots to help explain your problem.

**Additional context**
zabbixt02 is a VMWare VM with snapshot enabled. I fallback to snapshot with timescaledb-postgresql-11-1.2.1 installed without startup issue.

[mfreed]

@tjyang Do you continue to have this issue? Have you tried upgrading to 1.3.0 with any problems?

[tjyang]

@mfreed , I will test it out once I got to my test lab in next few days.

[tjyang]

@mfreed

• Following command was able to update to 1.3.0 and no more "undefined" error.

  sudo yum update -y  timescaledb-\* postgresql11\*