Scottish actor Peter Capaldi played his first live gig in 40 years in Glasgow this week ahead of the release of his second album next year.