I worked for a company which extended my contract to two years, but I've been in five or six different projects during that time. All but one (Avon AU which is ongoing) have been completed successfully.
I am really biased towards short, "solvable" projects :)
Its not necessarily the length, but the lack of extensions that is a warning sign. Most projects do not last a short time so a lack of extensions indicates a problem.