This is not normally used in the figurative sense. Most likely whoever used this was just being creative.. which is what language is for =) Domasla and Peachey's posts are probably close to what the original speaker meant; just wanted to add that this isn't a common expression you need to memorize.

I've never heard someone describe themselves using this expression, but I guess they would mean they're a pain only to themselves, as Domasla suggests.

A pain to yourself? An annoyance. But nothing spectacular.