Tinybird flock.js: rows quarantined for missing session_id

TL;DR

For "Strict type checking failed. Object does not have column 'session_id', you should send a value or recreate the table with a Nullable column": the Tinybird team reproduced it and shipped the fix in flock.js v1.4.3 (PR #115): the tracker now falls back to a generated session ID value when none could be stored, so rows ingest instead of quarantining. Fix: make sure youre loading flock.js v1.4.3 or newer.

Strict type checking failed. Object does not have column 'session_id', you should send a value or recreate the table with a Nullable column type. While accessing jsonpath '$.session_id'

Steps

1. Using the Tinybird web analytics tracker (flock.js) in a Next.js app, about a third of tracked rows ended up in quarantine instead of being ingested. The quarantine error was Strict type checking failed. Object does not have column 'session_id', you should send a value or recreate the table with a Nullable column type. While accessing jsonpath '$.session_id'. The reporter had 340 good rows and 150 quarantined.
2. The tracker sometimes failed to store a session ID (depending on the storage mode), and then sent events with no session_id at all, which strict type checking quarantined. The Tinybird team reproduced it and shipped the fix in flock.js v1.4.3 (PR #115): the tracker now falls back to a generated session ID value when none could be stored, so rows ingest instead of quarantining.
3. Fix: make sure youre loading flock.js v1.4.3 or newer. If youre pinning the unpkg URL, update the pinned tag:

4. <script defer src="https://unpkg.com/@tinybirdco/flock.js" data-host="https://api.tinybird.co" data-token [your value]

When to use

You are seeing this: The quarantine error was Strict type checking failed. Use this skill when you run into "Tinybird flock.js: rows quarantined for missing session_id".

When not to use

If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.

Versions

Versions mentioned in the source: flock.js v1.4.3. If you are on something much newer or older, the details may have shifted.

Why this happens

Using the Tinybird web analytics tracker (flock.js) in a Next.js app, about a third of tracked rows ended up in quarantine instead of being ingested.

Sources

• https://unpkg.com/@tinybirdco/flock.js"
• https://api.tinybird.co"

Asked in the thread (https://vectle.com/threads/thr0rpSjl7SdiE0m82ePn1L4A): Using the Tinybird web analytics tracker (flock.js) in a Next.js app, about a third of tracked rows ended up in quarantine instead of being ingested. The quarantine error was `Strict type checking failed. Object does not have column 'sessionid', you should send a value or recreate the table with a Nullable column type. While accessing jsonpath '$.sessionid'`. The reporter had 340 good rows and 150 quarantined. The verified answer: The tracker sometimes failed to store a session ID (depending on the storage mode), and then sent events with no sessionid at all, which strict type checking quarantined. The Tinybird team reproduced it and shipped the fix in flock.js v1.4.3 (PR #115): the tracker now falls back to a generated session ID value when none could be stored, so rows ingest instead of quarantining.

Fix: make sure youre loading flock.js v1.4.3 or newer. If youre pinning the unpkg URL, update the pinned tag:

<script defer src="https://unpkg.com/@tinybirdco/flock.js" data-host="https://api.tinybird.co" data-token [your value]

Source: https://github.com/tinybirdco/web-analytics-starter-kit/issues/103 Thread: https://vectle.com/threads/thr_0rpSjl7SdiE0m82ePn1L4A