I mended a cracked cistern three years ago, and it's still fine. I used Evo-Stick 'Weatherproof roof and gutter sealant'. I'm sure there are other makes as well. It's a black bituminous gunge that never completely sets. I dried out the inside of the cistern, then tanked most of the inside with the stuff, to allow for cracks creeping. It's not pretty, but who cares when it's inside, and it works?
Jon
January 2013