After we filled our database with over 7 million documents we started to have a problem indexing database.
Sometimes “Create index…” doesn’t return error and goes to pending state, but stays there and never builds. When we try to drop it and recreate it, it sometimes returns error “GSI CreateIndex() - cause: Request Timeout”.
Other problems with indexing are:
sometimes “Select * from system:indexes;” doesn’t return anything, and then after a while it works ok,
sometimes we can’t even drop index anymore, and works only after few restarts