Long-term sustainability of biogas bubbles in sand