SECOND AMENDED AND RESTATED AGREEMENT OF LIMITED PARTNERSHIP OF MEMORIAL PRODUCTION PARTNERS LP