Data and AI struggles

2,114 problems · 377 companies

Databases

Trouble with PostgreSQL filter

3 posts from 3 people3d activeFading, +0 this week

Posts per day

Posts per day3 posts, Sep 15 to Nov 21

The posts behind it

GitHub issuesn8n-io/n8n · AlexFetNov 14

Executions filter startedAfter/startedBefore shifted by the Postgres session time zone offset (zone-less UTC string vs timestamptz)

...the Postgres session time zone). External PostgreSQL 17 with server `timezone` UTC+2. Workaround applied: role-level `timezone = 'UTC'`. ### Operating System Debian 13 (Docker) ### n8n Version 2.47.7 ### Node.js Version bundled with the official Docker image 2.47.7 ### Database...

1 replies
GitHub issuesPrefectHQ/prefect · chuqCTCOct 27

Flow run stored with a deeply nested, lone-surrogate or NaN-label value makes `/flow_runs/filter` return 500 for every client

### Bug summary The server stores some values that it can't serialize when reading them back. After that, every list request whose page includes the row returns 500 until the row is deleted. This is the same failure as #15031, but caused by different inputs, and the #15031 fix...

GitHub issuesPrefectHQ/prefect · SuperLamicSep 15

PostgreSQL /flow_runs/filter times out for state-filtered START_TIME_ASC queries on large flow_run tables

### Bug summary We observed `POST /flow_runs/filter` returning HTTP 500 for the following query against a self-hosted Prefect server using PostgreSQL: Our `flow_run` table contained approximately 6.35 million rows (26 GB), including approximately 27,000 `RUNNING` rows. Prefect...

Companies and products named

About this problem

Evidence

3 posts from 3 people in 2 places, about 1 a week over 61 days. Mostly on PrefectHQ/prefect, n8n-io/n8n. Tools named alongside: Prefect, SQLite, Infinity, Model Context Protocol.

Frustration Frustration 0 of 3· Seen on GitHub issues

How it was grouped

Posts about PostgreSQL with no known issue, sharing the word "filter". First post Sep 15, 2026, latest Nov 14, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method

Other PostgreSQL problems

PostgreSQL users keep asking for help

Top post: "How can I exclude sampling gaps when calculating accompanying time between two Ganos trajectories?", one of 44 posts from 43 people on GitHub issues, Stack Overflow, Reddit.

PostgreSQL upgrades break working setups

17 posts from 15 people on GitHub issues, Stack Overflow, Reddit.

PostgreSQL queries run too slowly and are hard to tune

10 posts from 10 people on Reddit, Stack Overflow, GitHub issues.

Trouble with PostgreSQL database

Top post: "Urgent: SIHSS Free Project Unhealthy, Database Recovery Required", one of 8 posts from 8 people on GitHub issues, Stack Overflow.

PostgreSQL error messages are cryptic

7 posts from 7 people on GitHub issues, Stack Overflow.

PostgreSQL permissions are confusing and error-prone

7 posts from 7 people on GitHub issues, Hacker News.

PostgreSQL jobs fail silently or break often

6 posts from 5 people on GitHub issues.

PostgreSQL feels slow and laggy

5 posts from 5 people on Mastodon, Reddit, GitHub issues.

Trouble with PostgreSQL workflow

Top post: "Agent not recognizing the workflow inputs", one of 5 posts from 5 people on GitHub issues, Stack Overflow.

PostgreSQL outages and slowdowns disrupt work

5 posts from 5 people on GitHub issues, Reddit.

PostgreSQL rate limits and usage caps block work

4 posts from 4 people on GitHub issues.

History

Momentum went from steady to fading.

Nov 21, 2026

First seen with 3 posts; the top post now: "Executions filter startedAfter/startedBefore shifted by the Postgres session time zone offset (zone-less UTC".

Nov 15, 2026