TimescaleDB Segmentation Fault

[perry811]

As i m trying to run timescaledb.sql, i immediately got "Segmentation Fault". In my environment, i am running Postgresql-11.6 and TimescaleDB extension 1.6, Zabbix 4.4.5. I m wondering if any of you has also experienced it.

2020-02-06 16:47:15.017 PST [4003] STATEMENT: SELECT create_hypertable('history', 'clock', chunk_time_interval => 86400, migrate_data => true);
2020-02-06 16:47:15.025 PST [4003] NOTICE: migrating data to chunks
2020-02-06 16:47:15.025 PST [4003] DETAIL: Migration might take a while depending on the amount of data.
2020-02-06 16:47:15.025 PST [4003] STATEMENT: SELECT create_hypertable('history', 'clock', chunk_time_interval => 86400, migrate_data => true);
2020-02-06 16:47:15.036 PST [3943] DEBUG: reaping dead processes
2020-02-06 16:47:15.036 PST [3943] DEBUG: server process (PID 4003) was terminated by signal 11: Segmentation fault
2020-02-06 16:47:15.036 PST [3943] DETAIL: Failed process was running: SELECT create_hypertable('history', 'clock', chunk_time_interval => 86400, migrate_data => true);
2020-02-06 16:47:15.036 PST [3943] LOG: server process (PID 4003) was terminated by signal 11: Segmentation fault
2020-02-06 16:47:15.036 PST [3943] DETAIL: Failed process was running: SELECT create_hypertable('history', 'clock', chunk_time_interval => 86400, migrate_data => true);
2020-02-06 16:47:15.036 PST [3943] LOG: terminating any other active server processes

[Glencoe]

Did you shut down Zabbix before running timescaledb.sql? It might be this bug: https://github.com/timescale/timescaledb/issues/1652

[perry811]

Thanks! Glencoe! I was wondering if i was hitting the Bug#1651 and Bug#1652, and I was hoping if anyone in the forum has a workaround of using create_hypertable using a different version of timescaleDB.