A major flood alert was issued in Co Cork last night following a combination of torrential rain, high tides, and strong winds.