"It's been years since I had ridden a bike" is mixed tense. The "it's been" implies an ongoing condition, but "had ridden" implies a past condition. In the same way "It'd been a whole two hours since he texted me," is OK, but again we're talking about a past condition that at that moment should be resolved. "It had been a whole two hours since ... More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.