D1 alpha migration guide mentions "_cf_KV" table which was not present in my dump

For Workes & Pages, what is the name of the domain?

nerdo.ai

What is the issue or error you’re encountering

Migration fails, resulting db has no data in it

What steps have you taken to resolve the issue?

Following this guide: Alpha database migration guide · Cloudflare D1 docs

What are the steps to reproduce the issue?

First three lines of my db dump look like this:

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE d1_kv (key TEXT PRIMARY KEY, value TEXT NOT NULL);

I’m new to CF and D1 but from what I have learned, _cf_KV is an internal table used by CF to manage the serverless D1. It seems you ignore it and don’t delete it. This is why you don’t create it (it is already created when the d1 instance is initiated) and dump doesn’t dump it. Somebody might be able to answer that better.

As a side question: how are you able to use D1 with an .ai TLD when CF does not support .ai domains?
https://www.cloudflare.com/tld-policies/
https://community.cloudflare.com/t/request-cloudflare-registrar-to-support-ai-domain/611048
CF needs to have a chat with ChatGPT about working with .ai TLDs.

Cloudflare supports domains of any tld through the standard services, it is only Cloudflare Registrar where the tld matters. You can use every other feature of Cloudflare without using Registrar.

4 Likes

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.