A stretch of road leading to the Greystones roundabout in Grangetown was closed for roughly seven hours after a lorry overturned.