Databases problems
PostgreSQL users keep filing bugs
Top post: "Instance owner cannot view execution data in a team project when the execution uses a credential of that", one of 42 posts from 41 people on GitHub issues, Stack Overflow, Reddit.
SQLite users keep filing bugs
Top post: "filelock<4.0 cap keeps downstreams on a version with three open CVEs", one of 39 posts from 35 people on GitHub issues, Reddit.
Supabase users keep filing bugs
Top post: "Organization not showing!", one of 37 posts from 36 people on GitHub issues, Reddit.
Trouble with ClickHouse column
Top post: "MaterializedPostgreSQL: reading a Nullable column's .null subcolumn (x IS NULL, count(x)) fails with", one of 15 posts from 9 people on GitHub issues.
Vector search quality and scaling are hard to get right
12 posts from 12 people on GitHub issues, Reddit, Stack Overflow.
Trouble with Supabase studio
Top post: "Pressing Backspace or typing in Command Menu context search pages (Edge Functions / RLS Policies / Storage /", one of 7 posts from 5 people on GitHub issues.
Trouble with ClickHouse tables
Top post: "Paimon: resolve columns by field id, so tables with renamed or re-added columns are readable", one of 7 posts from 6 people on GitHub issues.
Queries run too slowly and are hard to tune
5 posts from 5 people on GitHub issues, Stack Overflow.
MySQL users keep asking for help
Top post: "Unable to pull image, not found for mysql:8.4", one of 5 posts from 5 people on Reddit, GitHub issues, Community forums.
Firebase users keep asking for help
Top post: "Google Cloud Firestore: small fractional numbers are sent as integerValue in Create and Upsert", one of 5 posts from 5 people on Reddit, GitHub issues, Community forums.
Trouble with PostgreSQL workflow
Top post: "Agent not recognizing the workflow inputs", one of 4 posts from 4 people on GitHub issues, Stack Overflow.
Trouble with PostgreSQL credentials
Top post: "SFTP Credentials: Port field clears value and incorrectly formats large port numbers", one of 4 posts from 4 people on GitHub issues.
ClickHouse queries run too slowly and are hard to tune
3 posts from 2 people on GitHub issues.
Trouble with PostgreSQL http
Top post: "Auth endpoints return HTTP 500 with `converting NULL to string is unsupported` on `confirmation_token`", one of 2 posts from 2 people on GitHub issues. Unverified.
Trouble with ClickHouse merges
Top post: "OPTIMIZE FINAL writes the merged part with stale metadata after waiting for running merges", one of 2 posts from 2 people on GitHub issues. Unverified.
DuckDB users keep filing bugs
Top post: "latest alpha DuckDB 2.0 with Quack server on Windows/Linux got `Authentication failed` since several days ago", one of 23 posts from 15 people on GitHub issues.
Oracle users keep filing bugs
Top post: "Permanent compiler bailout: partialEvaluationConstant violated in WasmFunctionNode.executeBodyFromOffset", one of 21 posts from 10 people on GitHub issues.
ClickHouse users keep filing bugs
Top post: "Tighten seccomp policy for optional kernel interfaces", one of 19 posts from 8 people on GitHub issues.
Databases hit connection, locking and scaling limits
16 posts from 16 people on GitHub issues, Hacker News, Reddit.
Trouble with DuckDB internal
Top post: "duckdb 2.0.0 fails to launch on BE: `INTERNAL Error: The time zone data is corrupt`", one of 14 posts from 7 people on GitHub issues.
Trouble with DuckDB returns
Top post: "Comparison simplification returns an incorrect result when a narrowing `DECIMAL` cast is used", one of 9 posts from 9 people on GitHub issues.
Trouble with DuckDB join
Top post: "Segfault in `dense_rank() OVER ()` over a RIGHT_ANTI hash join that returns its unmatched rows", one of 9 posts from 8 people on GitHub issues.
Trouble with ClickHouse table
Top post: "`SYSTEM RESTORE REPLICA` on a second replica over-bumps the table `metadata` znode version; every later", one of 8 posts from 5 people on GitHub issues.
PostgreSQL queries run too slowly and are hard to tune
8 posts from 8 people on Reddit, Stack Overflow, GitHub issues.
Trouble with DuckDB cast
Top post: "TRY_CAST of an empty BLOB to BIT escapes a non-fallible __cast and invalidates the database", one of 7 posts from 6 people on GitHub issues.
Trouble with DuckDB column
Top post: "2.0 alpha: comparing a CASE/split_part result to a constant fails with BindBuiltinScalarFunction did not", one of 7 posts from 5 people on GitHub issues.
Elasticsearch users keep asking for help
Top post: "Unable to load Integrations > Upload File page in Kibana", one of 6 posts from 6 people on Community forums, GitHub issues, Reddit.
Trouble with DuckDB values
Top post: "ManualVuln37 Unbounded Recursion in EncodeVariantValue Causes Stack Overflow via variant_comparator on Deeply", one of 6 posts from 6 people on GitHub issues.
Trouble with Supabase returns
Top post: "Hosted PostgREST 14.5 returns 401/PGRST303 after successful Supabase Auth sign-in", one of 6 posts from 6 people on GitHub issues.
Trouble with PostgreSQL database
Top post: "Canonicalising unit names from a flat file in a normalised database structure", one of 6 posts from 6 people on GitHub issues, Stack Overflow.
Trouble with DuckDB null
Top post: "DuckDB: `HAVING` of `(φ IS TRUE) OR NOT (φ IS TRUE) AND …` is empty for a NULL `φ`, but the same boolean as", one of 6 posts from 6 people on GitHub issues.
Trouble with ClickHouse join
Top post: "Explicit grace_hash now spills at max_bytes_ratio_before_external_join = 0.5 although the build side fits in", one of 5 posts from 4 people on GitHub issues.
Trouble with DuckDB parquet
Top post: "External file cache range metadata grows for deleted local Parquet files in v1.5.6 despite buffer eviction", one of 5 posts from 5 people on GitHub issues.
Trouble with SQLite node
Top post: "The Remove Duplicates node gets stuck at maximum history size", one of 5 posts from 5 people on GitHub issues.
Trouble with ClickHouse query
Top post: "Memory tracker counts jemalloc's freed pages as used, so a heavy query started right after another spills to", one of 4 posts from 3 people on GitHub issues.
Trouble with Supabase docs
Top post: "e2e/docs: checkLinkFromBrowser falls back to full document DOM when articleSelector is missing on reference", one of 4 posts from 3 people on GitHub issues.
Chroma users keep filing bugs
Top post: "There are multiple vulnerabilities in latest version of chromadb 1.5.9, which are getting added transitively", one of 4 posts from 3 people on GitHub issues.
Trouble with ClickHouse database
Top post: "`DROP NAMED COLLECTION` succeeds while a database uses the collection, and the server then fails to start", one of 4 posts from 2 people on GitHub issues.
Trouble with Supabase table
Top post: "ALTER FOREIGN TABLE public.KSL SET SCHEMA private;", one of 4 posts from 4 people on GitHub issues.
Trouble with ClickHouse read
Top post: "ORC: a corrupt PostScript `metadata_length` makes ORC predicate pushdown read `stripe_stats` out of bounds,", one of 4 posts from 4 people on GitHub issues.
Redis users keep filing bugs
Top post: "7.0.0rc2 Flight SQL/ADBC validation: source-install dependency failures and metadata gaps", one of 3 posts from 1 person on GitHub issues.
Trouble with ClickHouse columns
Top post: "INSERT SELECT from fileCluster/urlCluster fails to fill DEFAULT columns", one of 3 posts from 2 people on GitHub issues.
Trouble with ClickHouse server
Top post: "Server crash building projection with `WHERE` on `Tuple` equality", one of 3 posts from 2 people on GitHub issues.
LlamaIndex vector search quality is hard to get right
3 posts from 3 people on GitHub issues.
Trouble with PostgreSQL function
Top post: "How to bypass PostgreSQL's 100 function parameter limitation for IN and FIELD", one of 3 posts from 3 people on Stack Overflow, GitHub issues.
PostgreSQL hits connection, locking and scaling limits
3 posts from 3 people on Reddit, GitHub issues, Stack Overflow.
Trouble with PostgreSQL server
Top post: "SQL Server to PostgreSQL sync missing some records", one of 3 posts from 3 people on Reddit, GitHub issues, Stack Overflow.