timescale/timescaledb issues and pull requests

#7023 - Block ALTER TABLE...{RENAME | SET SCHEMA} on CAggs

Pull Request - State: open - Opened by fabriziomello 21 days ago - 3 comments
Labels: bug, continuous_aggregate, ddl

#7022 - Reduce drop_extension test flakiness

Pull Request - State: open - Opened by fabriziomello 22 days ago - 1 comment
Labels: flaky-test

#7021 - [Enhancement]: Remove requirement that `compress_after` be larger than refresh policy's `start_offset`

Issue - State: open - Opened by RobAtticus 22 days ago - 1 comment
Labels: enhancement

#7020 - Add support for column dimension range tracking

Pull Request - State: open - Opened by nikkhils 22 days ago - 6 comments

#7019 - Continuous aggregation calculation error

Issue - State: open - Opened by nieyuan1980 23 days ago
Labels: bug

#7018 - Fix search_path quoting in compression defaults function

Pull Request - State: open - Opened by svenklemm 25 days ago

#7017 - [Bug]: Upgradee PostgreSQL 15.3 with TS 2.15 to PostgreSQL 16.3 failed

Issue - State: closed - Opened by pgloader 25 days ago - 1 comment
Labels: bug

#7016 - Post release 2.15.2

Pull Request - State: closed - Opened by fabriziomello 25 days ago - 1 comment
Labels: release

#7015 - [Bug]: realtime aggregation select planning and execution time is poor

Issue - State: open - Opened by pohmelie 25 days ago
Labels: bug

#7014 - Release 2.15.2

Pull Request - State: closed - Opened by pallavisontakke 25 days ago - 1 comment

#7013 - Release 2.15.2

Pull Request - State: closed - Opened by fabriziomello 26 days ago - 1 comment
Labels: release

#7012 - Add known flaky tests to linux32bit CI

Pull Request - State: closed - Opened by fabriziomello 26 days ago
Labels: ci

#7011 - Backport to 2.15.x: #7005: Allow CAggs with variable sized bucked with origin/offset

Pull Request - State: closed - Opened by fabriziomello 26 days ago - 1 comment
Labels: manual-backport

#7010 - [Bug]: UPDATE is hundreds of times less effective as UPSERT statement

Issue - State: open - Opened by igor2x 26 days ago - 7 comments
Labels: bug

#7009 - Backport to 2.15.x: #6984: Fix show_chunks on hypertable by hash

Pull Request - State: closed - Opened by timescale-automation 26 days ago
Labels: is-auto-backport

#7008 - Reorder some tests in bgw_custom

Pull Request - State: closed - Opened by fabriziomello 27 days ago - 1 comment
Labels: testing, bgw, tech-debt

#7007 - Backport to 2.15.x: #7004: Fix segfault with closed primary dimension

Pull Request - State: closed - Opened by timescale-automation 27 days ago
Labels: is-auto-backport

#7006 - Calendar-based chunking PoC

Pull Request - State: open - Opened by erimatnor 27 days ago

#7005 - Allow CAggs with variable sized bucked with origin/offset

Pull Request - State: closed - Opened by fabriziomello 27 days ago - 2 comments
Labels: continuous_aggregate, time_bucket, auto-backport-not-done, force-auto-backport, backported-2.15.x

#7004 - Fix segfault with closed primary dimension

Pull Request - State: closed - Opened by svenklemm 27 days ago - 1 comment
Labels: backported-2.15.x

#7003 - Backport to 2.15.x: #6981: Fix segfault creating CAgg on hypertable by hash

Pull Request - State: closed - Opened by timescale-automation 27 days ago
Labels: is-auto-backport

#7002 - Backport to 2.15.x: #6996: Fix removal of metadata function and update script

Pull Request - State: closed - Opened by timescale-automation 27 days ago
Labels: is-auto-backport

#7001 - Backport to 2.15.x: #6992: Fix sort pushdown for partially compressed chunks

Pull Request - State: closed - Opened by antekresic 27 days ago

#7000 - Backport to 2.15.x: #6993: Disallow hash partitioning on primary column

Pull Request - State: closed - Opened by timescale-automation 27 days ago
Labels: is-auto-backport

#6999 - [Bug]: average(time_weight('linear')) yields incorrect result

Issue - State: open - Opened by relativityboy 27 days ago
Labels: bug, toolkit

#6998 - Consider origin time on monthly buckets

Pull Request - State: closed - Opened by fabriziomello 28 days ago - 2 comments
Labels: time_bucket

#6997 - Fix stale code in Ensure

Pull Request - State: closed - Opened by akuzm 28 days ago - 1 comment

#6996 - Fix removal of metadata function and update script

Pull Request - State: closed - Opened by antekresic 28 days ago - 1 comment
Labels: bug, backported-2.15.x

#6995 - Backport to 2.15.x: #6891: Fix the flaky merge_append_partially_compressed test

Pull Request - State: closed - Opened by timescale-automation 28 days ago
Labels: is-auto-backport

#6994 - Backport to 2.15.x: #6892: Fix some flakiness in transparent_decompression test

Pull Request - State: closed - Opened by timescale-automation 28 days ago
Labels: is-auto-backport

#6993 - Disallow hash partitioning on primary column

Pull Request - State: closed - Opened by nikkhils 28 days ago - 2 comments
Labels: bug, backported-2.15.x

#6992 - Fix sort pushdown for partially compressed chunks

Pull Request - State: closed - Opened by antekresic 28 days ago - 3 comments
Labels: bug, planner, compression, auto-backport-not-done, backported-2.15.x

#6991 - [Enhancement]: Allow specifying application_name for custom jobs

Issue - State: open - Opened by RobAtticus 29 days ago
Labels: enhancement

#6990 - Add table mappings to compression settings

Pull Request - State: open - Opened by erimatnor 29 days ago - 2 comments
Labels: compression, tech-debt

#6989 - Add support for foreign keys to hypertables

Pull Request - State: open - Opened by svenklemm 29 days ago - 1 comment

#6988 - Fix code comment ending mid-sentence

Pull Request - State: closed - Opened by svenklemm about 1 month ago

#6987 - Fix REASSIGN OWNED BY for background jobs

Pull Request - State: open - Opened by mkindahl about 1 month ago - 1 comment

#6986 - Update copyright notice to 2024

Pull Request - State: closed - Opened by mfreed about 1 month ago

#6985 - [Bug]: days_in_month() calculates incorrectly

Issue - State: open - Opened by JimRowan about 1 month ago
Labels: bug, toolkit

#6984 - Fix show_chunks on hypertable by hash

Pull Request - State: closed - Opened by fabriziomello about 1 month ago - 1 comment
Labels: bug, segfault, hypertable, backported-2.15.x

#6983 - [Bug]: segfault when configuring orderby on hypertable with closed primary dimension

Issue - State: closed - Opened by JamesGuthrie about 1 month ago
Labels: bug, segfault

#6982 - Fix broken CI build matrix

Pull Request - State: closed - Opened by fabriziomello about 1 month ago - 2 comments
Labels: bug, ci, auto-backport-not-done

#6981 - Fix segfault creating CAgg on hypertable by hash

Pull Request - State: closed - Opened by fabriziomello about 1 month ago - 1 comment
Labels: bug, continuous_aggregate, segfault, hypertable, backported-2.15.x

#6980 - Backport to 2.15.x: #6978: Fix segfault on non-open primary dimension when compressing

Pull Request - State: closed - Opened by timescale-automation about 1 month ago
Labels: is-auto-backport

#6979 - show_chunks() segfaults on hypertables with closed primary dimension

Issue - State: open - Opened by svenklemm about 1 month ago
Labels: segfault

#6978 - Fix segfault on non-open primary dimension when compressing

Pull Request - State: closed - Opened by svenklemm about 1 month ago - 1 comment
Labels: backported-2.15.x

#6977 - [Bug]: Segfault when compressing a chunk belonging to a hypertable with closed dimensions

Issue - State: closed - Opened by JamesGuthrie about 1 month ago - 1 comment
Labels: bug, segfault

#6976 - [Bug]: Upgrade to tsdb 2.15.1 caused selects by partitioned column to return only data after upgrade

Issue - State: closed - Opened by gugu about 1 month ago - 19 comments
Labels: bug

#6975 - [Bug]: Could not find pathkey item to sort on partially compressed chunks of a hypertable

Issue - State: closed - Opened by srieding about 1 month ago - 4 comments
Labels: bug

#6974 - Fix some CI failures

Pull Request - State: closed - Opened by fabriziomello about 1 month ago - 1 comment
Labels: ci

#6973 - Post release 2.15.1

Pull Request - State: closed - Opened by fabriziomello about 1 month ago - 3 comments
Labels: release

#6972 - Live migration: Failed to find hypertable from map

Issue - State: closed - Opened by john9x about 1 month ago - 5 comments
Labels: bug

#6971 - [StepSecurity] Apply security best practices

Pull Request - State: open - Opened by step-security-bot about 1 month ago - 1 comment
Labels: security

#6970 - Release 2.15.1

Pull Request - State: closed - Opened by pallavisontakke about 1 month ago - 7 comments

#6969 - [Bug]: Lateral Joins are unable to perform with even 1 record being queried

Issue - State: closed - Opened by KamalAman about 1 month ago - 1 comment
Labels: bug, continuous_aggregate

#6968 - Remove time_bucket_ng

Pull Request - State: open - Opened by fabriziomello about 1 month ago - 1 comment

#6967 - [Help needed]: Downsampling of all tables in a database?

Issue - State: open - Opened by DrTron about 1 month ago - 1 comment
Labels: bug

#6966 - Release 2.15.1

Pull Request - State: closed - Opened by fabriziomello about 1 month ago - 4 comments
Labels: release

#6965 - [Enhancement]: Delete rows from CAggs using DELETE FROM

Issue - State: open - Opened by TomoBossi about 1 month ago - 1 comment
Labels: enhancement

#6964 - Backport to 2.15.x: #6903: Fix update triggers issue caused by decompression

Pull Request - State: closed - Opened by antekresic about 1 month ago
Labels: bug

#6963 - Backport to 2.15.x: #6932: Make constification functions visible outside timescale library

Pull Request - State: closed - Opened by timescale-automation about 1 month ago
Labels: is-auto-backport

#6962 - Backport to 2.15.x: #6958: Fix coverity warning about null pointer dereference

Pull Request - State: closed - Opened by timescale-automation about 1 month ago
Labels: is-auto-backport

#6961 - Backport to 2.15.x: #6957: Fix segfault in UNION queries with top-level ordering

Pull Request - State: closed - Opened by timescale-automation about 1 month ago
Labels: is-auto-backport

#6958 - Fix coverity warning about null pointer dereference

Pull Request - State: closed - Opened by svenklemm about 1 month ago - 4 comments
Labels: force-auto-backport, backported-2.15.x, coverity

#6957 - Fix segfault in UNION queries with top-level ordering

Pull Request - State: closed - Opened by svenklemm about 1 month ago - 3 comments
Labels: bug, backported-2.15.x

#6956 - Add check for column types we use in our catalog.

Pull Request - State: closed - Opened by svenklemm about 1 month ago
Labels: ci

#6946 - Backport to 2.15.x: #6931: Do not decompress batches for COPY with potentially invalid slot

Pull Request - State: closed - Opened by timescale-automation about 1 month ago
Labels: is-auto-backport

#6944 - Backport to 2.15.x: #6940: Remove regprocedure oid type from catalog

Pull Request - State: closed - Opened by timescale-automation about 1 month ago
Labels: is-auto-backport

#6942 - Backport to 2.15.x: #6911: Fix _timescaledb_functions.remove_dropped_chunk_metadata

Pull Request - State: closed - Opened by timescale-automation about 1 month ago
Labels: is-auto-backport

#6941 - [Bug]: Unable to change job owner

Issue - State: open - Opened by jflambert about 1 month ago - 3 comments
Labels: bug, bgw

#6939 - Refactor CAggTimeBucketInfo to remove redundancy

Pull Request - State: closed - Opened by fabriziomello about 1 month ago - 1 comment
Labels: continuous_aggregate, time_bucket, tech-debt, backported-2.15.x

#6932 - Make constification functions visible outside timescale library

Pull Request - State: closed - Opened by zilder about 2 months ago - 1 comment
Labels: force-auto-backport, backported-2.15.x

#6925 - [Bug]: Segfault while running a query that reads from compressed chunks

Issue - State: closed - Opened by feikesteenbergen about 2 months ago - 2 comments
Labels: bug, compression, segfault

#6923 - [Enhancement]: Add WITH option to set chunk size in continuous aggregate

Issue - State: open - Opened by RobAtticus about 2 months ago - 6 comments
Labels: continuous_aggregate, enhancement

#6920 - Rework compression activity wal markers

Pull Request - State: closed - Opened by JamesGuthrie about 2 months ago - 3 comments

#6904 - [Bug]: 'ERROR: tuple already updated by self' after inserting data when chunk was dropped

Issue - State: open - Opened by banitt about 2 months ago - 3 comments
Labels: bug

#6903 - Fix update triggers issue caused by decompression

Pull Request - State: closed - Opened by antekresic about 2 months ago - 3 comments
Labels: bug, auto-backport-not-done, backported-2.15.x

#6902 - [Bug]: Continuous aggregates with time_bucket hourly and timezone fail to update

Issue - State: open - Opened by nofalx about 2 months ago - 2 comments
Labels: bug, continuous_aggregate

#6901 - Add support for transition tables

Pull Request - State: open - Opened by jamessewell about 2 months ago - 1 comment

#6900 - [Bug]: inconsistent bad query plan

Issue - State: open - Opened by phemmer about 2 months ago - 7 comments
Labels: bug, planner

#6893 - Remove unneeded Sort over Sort

Pull Request - State: open - Opened by akuzm about 2 months ago - 1 comment

#6892 - Fix some flakiness in transparent_decompression test

Pull Request - State: closed - Opened by akuzm about 2 months ago - 3 comments
Labels: force-auto-backport, backported-2.15.x

#6891 - Fix the flaky merge_append_partially_compressed test

Pull Request - State: closed - Opened by akuzm about 2 months ago - 1 comment
Labels: force-auto-backport, backported-2.15.x

#6879 - Add unsorted decompressed chunk path even if we have sorted ones

Pull Request - State: open - Opened by akuzm about 2 months ago

#6859 - Avoid projection more often in DecompressChunk node

Pull Request - State: closed - Opened by akuzm 2 months ago - 1 comment

#6858 - [Bug]: Before Update trigger on hypertable make updates fail

Issue - State: closed - Opened by edgarzamora 2 months ago - 4 comments
Labels: bug

#6838 - Modify dimension slice catalog update API

Pull Request - State: closed - Opened by antekresic 3 months ago - 1 comment
Labels: refactor

#6797 - Fix FK constraints for compressed chunks

Pull Request - State: closed - Opened by svenklemm 3 months ago - 6 comments
Labels: compression, migration, auto-backport-not-done

#6792 - Backport to 2.14.x: #6789: Fix deletes with subqueries and compression

Pull Request - State: closed - Opened by timescale-automation 3 months ago - 4 comments
Labels: is-auto-backport

#6753 - [Bug]: Crash on insert or deletion into compressed chunk

Issue - State: closed - Opened by hostops 4 months ago - 21 comments
Labels: bug, waiting-for-author, segfault

#6538 - [StepSecurity] Apply security best practices

Pull Request - State: closed - Opened by step-security-bot 6 months ago - 4 comments

#6420 - Ability to track status of CAgg refresh

Issue - State: open - Opened by ggodeke 7 months ago - 1 comment
Labels: continuous_aggregate, enhancement

#6382 - Support for CAgg with time_bucket origin/offset parameter

Pull Request - State: closed - Opened by jnidzwetzki 7 months ago - 8 comments
Labels: continuous_aggregate, time_bucket

#5978 - [Bug]: Compression job not restarting when paused or stopped forcefully

Issue - State: open - Opened by RobAtticus 11 months ago - 5 comments
Labels: bug, bgw

#5942 - Fix quoting owners in sql scripts.

Pull Request - State: closed - Opened by konskov 11 months ago - 2 comments

GitHub / timescale/timescaledb issues and pull requests