[FIX] http: ensure to clean the request cursor before calling the route function.

The route function can be call more than once in case of database error,
breaking the request cursor. By rollbacking it, we force the creation of a new transaction.