I put a (slightly bigger than a) pin hole in my thermarest with a cinder about 11 years ago. I just put a blob of thermarest's own glue on there and its still going strong, that werent on a seam though
I wouldn't use super glue as theres no flex in it. I tried it on a cheapo air once and it didn't last very long, made it worse in fact
I don't know what was in the little tube that came with my TaR but it may be something like stormsure, i'v never used that for anything under pressure before though so i cant say if it will work or not