Problem when change datatype and index of predicate in Dgraph


(Nguyễn Thanh Phi (Backend MWG)) #1

Hi everyone,
I have Dgraph Database with huge data (over 10 million nodes). After i change price predicate from string to float (current with over 5 million nodes has price data) and index it, Dgraph server has been freeze and i can’t query or mutate. This is the error:


It seem to be hang forever and can’t excute any query.
I have restart Dgraph service, but still got the problem.
What happen, is it the bug on Dgraph when run with huge data?
Please help me resolve the problem
Thank


(Daniel Mai) #2

When you index a predicate Dgraph must finish the generating the index to completion before being able to complete any queries or mutations.

For large data sets you can use bulk loader to create a Dgraph cluster with the updated schema and index.


(Nguyễn Thanh Phi (Backend MWG)) #3

i think current Dgraph does not resolve problem with huge data. many problem about speed, delay, freeze… i hope it can be more better