Data with severe collinearity

In the following data X1 is approximately equal to X2, either of which is a good explanatory variable for the response Y. However, if you use both X1 and X2 as covariates then the multiple regression will fail miserably.