Index Backfilling error | Convex Community | Page 1

worldly schooner Jun 4, 2023, 10:22 PM

#

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

#

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)

white prairie Jun 4, 2023, 11:07 PM

#

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? 🙏

worldly schooner Jun 5, 2023, 3:46 AM

#

Its fixed now after a few attempts at clearing all tables and restarting the dev server. And I'm using 0.14.1

#Index Backfilling error