Bug: Data imported via npx convex import is invisible to HTTP query API but visible via CLI/admin AP
🪲Bug Report
thank you for anything you have on this. it's really hanging us up!!
Environment: Convex deployment precise-ox-546 (production)
Steps to reproduce:
Export data from a dev deployment: npx convex export --path convex-dev-export.zip
Import into a prod deployment: npx convex import --replace-all convex-dev-export.zip --admin-key <key> --url <prod-url>
Deploy functions to prod: npx convex deploy
Query tables via ConvexHttpClient (the HTTP query API)
Expected: All imported tables are queryable via the HTTP query API, same as via CLI.
Actual: Some tables return data, others return empty arrays — even though the data is confirmed present via npx convex run.
Specifics:
Tables that work via HTTP query API after import: pages, chatSessions, chatProjects, shares, sharedChats
Tables that return empty via HTTP query API after import: chatMessages, sharedProjectAccess
The same query function (chatMessages:getSessionMessages) returns data when called via npx convex run (admin/CLI API) but returns [] when called via ConvexHttpClient
Schema is deployed and matches the imported data
Tried npx convex deploy multiple times — no change
The data is visible in the Convex dashboard
Workaround attempted: Tried delete-and-reinsert ("rematerialization") to force Convex to re-index the documents, but this wasn't practical at scale.
Impact: We were unable to migrate from dev to prod deployment. Had to revert to sharing a single database between environments.
Environment: Convex deployment precise-ox-546 (production)
Steps to reproduce:
Export data from a dev deployment: npx convex export --path convex-dev-export.zip
Import into a prod deployment: npx convex import --replace-all convex-dev-export.zip --admin-key <key> --url <prod-url>
Deploy functions to prod: npx convex deploy
Query tables via ConvexHttpClient (the HTTP query API)
Expected: All imported tables are queryable via the HTTP query API, same as via CLI.
Actual: Some tables return data, others return empty arrays — even though the data is confirmed present via npx convex run.
Specifics:
Tables that work via HTTP query API after import: pages, chatSessions, chatProjects, shares, sharedChats
Tables that return empty via HTTP query API after import: chatMessages, sharedProjectAccess
The same query function (chatMessages:getSessionMessages) returns data when called via npx convex run (admin/CLI API) but returns [] when called via ConvexHttpClient
Schema is deployed and matches the imported data
Tried npx convex deploy multiple times — no change
The data is visible in the Convex dashboard
Workaround attempted: Tried delete-and-reinsert ("rematerialization") to force Convex to re-index the documents, but this wasn't practical at scale.
Impact: We were unable to migrate from dev to prod deployment. Had to revert to sharing a single database between environments.
