I'm sure plenty of books get cancelled all the time. I have one novel published and a second written. However, I had trouble getting beta readers for the second book. So it remains finished, but unpublished. Maybe one day I'll return to the series, finish it off, and publish all the books, but until then they're cancelled.