punn
punn•2y ago

Index Backfilling error

I'm getting an index backfilling error for one of our tables. It was working fine before and I deleted the table and recreated it using npx convex dev
4 Replies
punn
punnOP•2y ago
Uncaught Error: Uncaught Error: Index messages.by_conversationId is currently backfilling and not available to query yet.
  at performAsyncSyscall (../../node_modules/convex/src/server/impl/syscall.ts:41:2)
  at async next [as next] (../../node_modules/convex/src/server/impl/query_impl.ts:248:6)
  at async collect [as collect] (../../node_modules/convex/src/server/impl/query_impl.ts:297:19)
  at async unique [as unique] (../../node_modules/convex/src/server/impl/query_impl.ts:314:24)
  at async <anonymous> (../../convex/integrationsStore/hostaway.ts:714:23)
  at async invokeMutation (../../node_modules/convex/src/server/impl/registration_impl.ts:52:2)

  at async <anonymous> (../../convex/actions/pmsData.ts:525:20)

  at performAsyncSyscall (../../node_modules/convex/src/server/impl/syscall.ts:41:2)
  at async runAction (../../node_modules/convex/src/server/impl/actions_impl.ts:47:13)
  at async <anonymous> (../convex/http.ts:41:75)
  at async invokeHttpAction (../../node_modules/convex/src/server/impl/registration_impl.ts:333:0)
  at async HttpRouter.runRequest (../../node_modules/convex/src/server/router.ts:270:16)
Uncaught Error: Uncaught Error: Index messages.by_conversationId is currently backfilling and not available to query yet.
  at performAsyncSyscall (../../node_modules/convex/src/server/impl/syscall.ts:41:2)
  at async next [as next] (../../node_modules/convex/src/server/impl/query_impl.ts:248:6)
  at async collect [as collect] (../../node_modules/convex/src/server/impl/query_impl.ts:297:19)
  at async unique [as unique] (../../node_modules/convex/src/server/impl/query_impl.ts:314:24)
  at async <anonymous> (../../convex/integrationsStore/hostaway.ts:714:23)
  at async invokeMutation (../../node_modules/convex/src/server/impl/registration_impl.ts:52:2)

  at async <anonymous> (../../convex/actions/pmsData.ts:525:20)

  at performAsyncSyscall (../../node_modules/convex/src/server/impl/syscall.ts:41:2)
  at async runAction (../../node_modules/convex/src/server/impl/actions_impl.ts:47:13)
  at async <anonymous> (../convex/http.ts:41:75)
  at async invokeHttpAction (../../node_modules/convex/src/server/impl/registration_impl.ts:333:0)
  at async HttpRouter.runRequest (../../node_modules/convex/src/server/router.ts:270:16)
lee
lee•2y ago
Hi! Index backfilling should be a transient state when the index is first created. It should be fast, but may be longer for large tables. Does the error keep happening? To help me look into it, could you share your deployment url? Prod and Dev deployments have independent tables and indexes, so maybe that's the issue. Also in case it's relevant, what version npx convex -V are you running? 🙏
punn
punnOP•2y ago
Its fixed now after a few attempts at clearing all tables and restarting the dev server. And I'm using 0.14.1
lee
lee•2y ago
interesting. that shouldn't happen. i'll try to repro, thanks for reporting!

Did you find this page helpful?