Skip to content

POST 400 Error getting k8s data #2025

Open
Open
POST 400 Error getting k8s data#2025
Assignees
strawgate

Description

@3266miles
3266miles
opened on Jun 14, 2026

Description

Exported Chat from Chrome DevTools AI Assistance

Export Timestamp (UTC): 2026-06-14T19:25:32.533Z

User

pull all the relevant debugging data for that 400 POST error, but ensure its fully anonymised so its safe to publicy file

AI

Listing network requests

Code executed:

listNetworkRequest()

Data returned:

[{"id":"96121.2197","url":"https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/projects/sumvin-api/query/?limit=5000&min_timestamp=2026-06-14T18:22:30.420Z&max_timestamp=2026-06-14T19:22:30.420Z","statusCode":400,"duration":"186 ms","transferSize":"0.8 kB"},{"id":"96121.2198","url":"https://pa.pydantic.dev/i/v0/e/?ip=0&_=1781464963779&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"210 ms","transferSize":"0.3 kB"},{"id":"96121.2199","url":"https://pa.pydantic.dev/s/?ip=0&_=1781464963775&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"814 ms","transferSize":"0.3 kB"},{"id":"96121.2200","url":"https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/","statusCode":200,"duration":"148 ms","transferSize":"25.5 kB"},{"id":"96121.2201","url":"https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/projects/","statusCode":200,"duration":"152 ms","transferSize":"0.5 kB"},{"id":"96121.2202","url":"https://logfirestatus.pydantic.dev/api/getMonitorList/6ypO6qPhjn","statusCode":200,"duration":"282 ms","transferSize":"2.1 kB"},{"id":"96121.2203","url":"https://logfire-us.pydantic.dev/ui-api/account/me/","statusCode":200,"duration":"120 ms","transferSize":"0.7 kB"},{"id":"96121.2204","url":"https://logfire-us.pydantic.dev/ui-api/organizations/3266miles/","statusCode":200,"duration":"110 ms","transferSize":"0.9 kB"},{"id":"96121.2205","url":"https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/projects/sumvin-api/query/?limit=5000&min_timestamp=2026-06-14T18:22:30.420Z&max_timestamp=2026-06-14T19:22:30.420Z","statusCode":400,"duration":"423 ms","transferSize":"0.5 kB"},{"id":"96121.2206","url":"https://pa.pydantic.dev/s/?ip=0&_=1781464968524&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"577 ms","transferSize":"0.4 kB"},{"id":"96121.2207","url":"https://pa.pydantic.dev/i/v0/e/?ip=0&_=1781464971752&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"193 ms","transferSize":"0.3 kB"},{"id":"96121.2208","url":"https://pa.pydantic.dev/s/?ip=0&_=1781464971753&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"624 ms","transferSize":"0.4 kB"},{"id":"96121.2209","url":"https://pa.pydantic.dev/s/?ip=0&_=1781464974860&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"653 ms","transferSize":"0.3 kB"},{"id":"96121.2210","url":"https://pa.pydantic.dev/s/?ip=0&_=1781464978867&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"725 ms","transferSize":"0.3 kB"},{"id":"96121.2211","url":"https://logfire-us.pydantic.dev/v1/ofrep/v1/evaluate/flags","statusCode":200,"duration":"143 ms","transferSize":"0.7 kB"},{"id":"96121.2212","url":"https://pa.pydantic.dev/s/?ip=0&_=1781464982873&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"444 ms","transferSize":"0.3 kB"},{"id":"96121.2213","url":"https://pa.pydantic.dev/s/?ip=0&_=1781464986883&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"457 ms","transferSize":"0.3 kB"},{"id":"96121.2214","url":"https://pa.pydantic.dev/s/?ip=0&_=1781464990901&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"742 ms","transferSize":"0.3 kB"},{"id":"96121.2215","url":"https://pa.pydantic.dev/i/v0/e/?ip=0&_=1781464990902&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"202 ms","transferSize":"0.4 kB"},{"id":"96121.2216","url":"https://pa.pydantic.dev/s/?ip=0&_=1781464994907&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"732 ms","transferSize":"0.4 kB"},{"id":"96121.2217","url":"https://pa.pydantic.dev/s/?ip=0&_=1781464998915&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"601 ms","transferSize":"0.3 kB"},{"id":"96121.2218","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465002923&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"680 ms","transferSize":"0.3 kB"},{"id":"96121.2219","url":"https://logfire-us.pydantic.dev/ui-api/platform-config/","statusCode":200,"duration":"133 ms","transferSize":"0.4 kB"},{"id":"96121.2220","url":"https://logfire-us.pydantic.dev/ui-api/account/me/","statusCode":200,"duration":"233 ms","transferSize":"0.7 kB"},{"id":"96121.2221","url":"https://logfire-us.pydantic.dev/ui-api/organizations/","statusCode":200,"duration":"202 ms","transferSize":"25.7 kB"},{"id":"96121.2222","url":"https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/projects/","statusCode":200,"duration":"214 ms","transferSize":"0.5 kB"},{"id":"96121.2223","url":"https://logfire-us.pydantic.dev/ui-api/organizations/3266miles/","statusCode":200,"duration":"167 ms","transferSize":"0.9 kB"},{"id":"96121.2224","url":"https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/","statusCode":200,"duration":"229 ms","transferSize":"25.3 kB"},{"id":"96121.2225","url":"https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/members/","statusCode":200,"duration":"280 ms","transferSize":"0.7 kB"},{"id":"96121.2226","url":"https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/projects/sumvin-api/","statusCode":200,"duration":"303 ms","transferSize":"0.5 kB"},{"id":"96121.2227","url":"https://logfire-us.pydantic.dev/ui-api/announcements/","statusCode":200,"duration":"240 ms","transferSize":"0.4 kB"},{"id":"96121.2228","url":"https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/usage/","statusCode":200,"duration":"240 ms","transferSize":"0.5 kB"},{"id":"96121.2229","url":"https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/upcoming-subscription/","statusCode":200,"duration":"269 ms","transferSize":"0.4 kB"},{"id":"96121.2230","url":"https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/projects/sumvin-api/query/?limit=1&min_timestamp=2026-06-14T18:22:30.420Z&max_timestamp=2026-06-14T19:22:30.420Z","statusCode":200,"duration":"1.36 s","transferSize":"0.7 kB"},{"id":"96121.2231","url":"https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/projects/sumvin-api/query/?limit=200&min_timestamp=2026-06-14T18:22:30.420Z&max_timestamp=2026-06-14T19:22:30.420Z","statusCode":200,"duration":"848 ms","transferSize":"0.5 kB"},{"id":"96121.2232","url":"https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/projects/sumvin-api/query/?limit=5000&min_timestamp=2026-06-14T18:22:30.420Z&max_timestamp=2026-06-14T19:22:30.420Z","statusCode":400,"duration":"385 ms","transferSize":"0.7 kB"},{"id":"96121.2233","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465007058&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"660 ms","transferSize":"0.3 kB"},{"id":"96121.2234","url":"https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/projects/sumvin-api/query/?limit=5000&min_timestamp=2026-06-14T18:22:30.420Z&max_timestamp=2026-06-14T19:22:30.420Z","statusCode":400,"duration":"294 ms","transferSize":"0.6 kB"},{"id":"96121.2235","url":"https://logfire-us.pydantic.dev/v1/ofrep/v1/evaluate/flags","statusCode":200,"duration":"245 ms","transferSize":"0.5 kB"},{"id":"96121.2236","url":"https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/projects/sumvin-api/query/?limit=5000&min_timestamp=2026-06-14T18:22:30.420Z&max_timestamp=2026-06-14T19:22:30.420Z","statusCode":400,"duration":"201 ms","transferSize":"0.5 kB"},{"id":"96121.2237","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465011074&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"534 ms","transferSize":"0.3 kB"},{"id":"96121.2238","url":"https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/projects/sumvin-api/query/?limit=5000&min_timestamp=2026-06-14T18:22:30.420Z&max_timestamp=2026-06-14T19:22:30.420Z","statusCode":400,"duration":"217 ms","transferSize":"0.6 kB"},{"id":"96121.2239","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465015387&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"719 ms","transferSize":"0.4 kB"},{"id":"96121.2240","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465019981&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"542 ms","transferSize":"0.4 kB"},{"id":"96121.2241","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465023995&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"953 ms","transferSize":"0.3 kB"},{"id":"96121.2242","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465028004&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"693 ms","transferSize":"0.3 kB"},{"id":"96121.2243","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465032012&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"782 ms","transferSize":"0.3 kB"},{"id":"96121.2244","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465036026&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"773 ms","transferSize":"0.3 kB"},{"id":"96121.2245","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465040035&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"467 ms","transferSize":"0.3 kB"},{"id":"96121.2246","url":"https://logfire-us.pydantic.dev/v1/ofrep/v1/evaluate/flags","statusCode":200,"duration":"170 ms","transferSize":"0.6 kB"},{"id":"96121.2247","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465044044&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"466 ms","transferSize":"0.4 kB"},{"id":"96121.2248","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465048054&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"746 ms","transferSize":"0.4 kB"},{"id":"96121.2249","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465052196&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"603 ms","transferSize":"0.3 kB"},{"id":"96121.2250","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465056204&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"662 ms","transferSize":"0.4 kB"},{"id":"96121.2251","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465060213&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"581 ms","transferSize":"0.3 kB"},{"id":"96121.2252","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465064227&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"587 ms","transferSize":"0.3 kB"},{"id":"96121.2253","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465068237&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"703 ms","transferSize":"0.3 kB"},{"id":"96121.2254","url":"https://logfire-us.pydantic.dev/v1/ofrep/v1/evaluate/flags","statusCode":200,"duration":"151 ms","transferSize":"0.5 kB"},{"id":"96121.2255","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465072249&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"688 ms","transferSize":"0.3 kB"},{"id":"96121.2256","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465076261&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"669 ms","transferSize":"0.4 kB"},{"id":"96121.2257","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465080612&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"833 ms","transferSize":"0.4 kB"},{"id":"96121.2258","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465084620&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"680 ms","transferSize":"0.3 kB"},{"id":"96121.2259","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465088636&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"676 ms","transferSize":"0.4 kB"},{"id":"96121.2260","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465092644&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"662 ms","transferSize":"0.3 kB"},{"id":"96121.2261","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465096655&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"659 ms","transferSize":"0.3 kB"},{"id":"96121.2262","url":"https://logfire-us.pydantic.dev/v1/ofrep/v1/evaluate/flags","statusCode":200,"duration":"160 ms","transferSize":"0.5 kB"},{"id":"96121.2263","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465100662&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"643 ms","transferSize":"0.3 kB"},{"id":"96121.2264","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465104996&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"612 ms","transferSize":"0.4 kB"},{"id":"96121.2265","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465109001&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"594 ms","transferSize":"0.4 kB"},{"id":"96121.2266","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465113011&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"681 ms","transferSize":"0.4 kB"},{"id":"96121.2267","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465117027&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"689 ms","transferSize":"0.3 kB"},{"id":"96121.2268","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465121037&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"644 ms","transferSize":"0.3 kB"},{"id":"96121.2269","url":"https://pa.pydantic.dev/s/?ip=0&_=1781465125050&ver=1.376.0&compression=gzip-js","statusCode":200,"duration":"753 ms","transferSize":"0.3 kB"}]

Getting network request

Analyzing data

Request:

Request URL: https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/projects/sumvin-api/query/?limit=5000&min_timestamp=2026-06-14T18:22:30.420Z&max_timestamp=2026-06-14T19:22:30.420Z

Request headers:
:authority: logfire-us.pydantic.dev
:method: POST
:path: /ui-api/organizations/sumvin/projects/sumvin-api/query/?limit=5000&min_timestamp=2026-06-14T18:22:30.420Z&max_timestamp=2026-06-14T19:22:30.420Z
:scheme: https
accept: application/json, text/plain, */*
accept-encoding: gzip, deflate, br, zstd
accept-language: en-GB,en-US;q=0.9,en;q=0.8
authorization: <redacted>
content-length: <redacted>
content-type: application/json
cookie: <redacted>
origin: https://logfire-us.pydantic.dev
priority: <redacted>
referer: https://logfire-us.pydantic.dev/sumvin/sumvin-api/kubernetes/workloads/deployment/sumvin-services/sumvin-api?last=%221h%22
sec-ch-ua: <redacted>
sec-ch-ua-mobile: <redacted>
sec-ch-ua-platform: <redacted>
sec-fetch-dest: <redacted>
sec-fetch-mode: <redacted>
sec-fetch-site: <redacted>
user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36

Response:

Response headers:
access-control-allow-credentials: true
access-control-allow-origin: https://logfire-us.pydantic.dev
access-control-expose-headers: x-api-version, retry-after, content-disposition, x-conversation-id
cf-cache-status: <redacted>
cf-ray: <redacted>
content-length: <redacted>
content-type: application/json
date: Sun, 14 Jun 2026 19:23:35 GMT
nel: {"report_to":"cf-nel","success_fraction":0.0,"max_age":604800}
report-to: {"group":"cf-nel","max_age":604800,"endpoints":[{"url":"https://a.nel.cloudflare.com/report/v4?s=ImXWfrufBB8JRUSNqu%2BZjLfbeDjIjEljeV641bOIkrbDHmt1SoGqanFk4%2BV7NPv%2FanAvGz%2FFYr3kflanvSI3NG2uOD7vQ7J18%2FvpYbVZjn9tomQpxNZWK8ZHiRmgX8yziO1V8Wd2IK9qACrsFaY1UVojUAQF"}]}
server: cloudflare
traceresponse: <redacted>
vary: Origin
via: 1.1 google
x-api-version: <redacted>
x-logfire-source: <redacted>

Response body:
{"detail":"{\"error\":\"invalid query\",\"details\":{\"error_type\":\"UserError\",\"details\":{\"kind\":\"Error\",\"message\":\"Optimizer rule 'optimize_projections' failed: Unrecognized column: recorded_timestamp\"}}}"}

Response status: 400 
Network request status: finished

Timing:

Queued at (timestamp): 53.5 s
Started at (timestamp): 53.5 s
Queueing (duration): 1 ms
Connection start (stalled) (duration): 0.7 ms
Request sent (duration): 0.4 ms
Waiting for server response (duration): 215 ms
Content download (duration): 0.9 ms
Duration (duration): 218 ms

Request initiator chain:

- URL: https://logfire-us.pydantic.dev/ui-api/organizations/sumvin/projects/sumvin-api/query/?limit=5000&min_timestamp=2026-06-14T18:22:30.420Z&max_timestamp=2026-06-14T19:22:30.420Z

Answer

This request attempts to query logs for the "sumvin-api" project within a specific one-hour time window. The server rejected the request with a 400 Bad Request error.

Root Cause: The query engine failed to execute the request because it does not recognize the column recorded_timestamp. This is a schema mismatch or a syntax error in the underlying query logic generated by the UI or provided in the POST body.

Anonymized Debugging Data

Request Details

  • Endpoint: POST /ui-api/organizations/[ORG]/projects/[PROJECT]/query/
  • Parameters: limit=5000, min_timestamp=[ISO_DATE], max_timestamp=[ISO_DATE]
  • Content-Type: application/json

Error Signature

  • Status: 400 Bad Request
  • Error Type: UserError
  • Optimizer Failure: optimize_projections
  • Error Message: Unrecognized column: recorded_timestamp

Performance Metrics

  • Latency: 218ms (Server processing: 215ms)
  • Status: Finished

Suggestions

  • Verify Schema: Ensure recorded_timestamp is a valid column name for this project. It may have been renamed to timestamp or inserted_at.
  • Check Query Body: Review the POST payload (redacted here) to see if recorded_timestamp is explicitly requested in a SELECT or WHERE clause.
  • UI Sync: If this was an automated UI request, clear your browser cache or refresh the page to ensure the frontend is using the latest API schema definitions.

Python, Logfire & OS Versions, related packages (not required)

Metadata
Metadata
Assignees
Labels
No labels
No labels
Type
No type
Fields
No fields configured for issues without a type.
Projects
No projects
Milestone
No milestone
Relationships
None yet
Development
No branches or pull requests
Issue actions