issues with renderd for mapnik style with name:ga labels

I'm in the process of rebuilding the maps and overlays for maps.openstreetmap.ie but running into some issues with existing style sheets. I've already done this once in the past year but had to redo it again recently and running into issues. It's worth noting that most of the styles are still based on the old XML format (that's what I inherited) and don't use the newer CartoCSS.

I've followed the guide on switch2osm with a view deviations (we have more than 10 layers to render so have compile some things from source).

The style file I used for the import is here.

The XML renderd config I'm using the for the name:ga map tiles is here

The command line for the initial import I did is as follows:

osm2pgsql   \
  --database gis \
  --create \
  --slim \
  --multi-geometry \
  --hstore \
  --tag-transform-script /data/src/openstreetmap-carto/openstreetmap-carto.lua \
  --cache 2500 \
  --number-processes 1 \
  --style /usr/local/share/osm2pgsql/default.style.IE \
  /home/roles/planet/data/ireland-and-northern-ireland-2019-11-23T21\:19\:02Z.osm.pbf

The errors I'm getting are as follows:

Nov 30 17:32:02 hostname renderd[9961]: An error occurred while loading the map layer 'osm-ga': Postgis Plugin: ERROR:  COALESCE types text and integer cannot be matched#012LINE 18:   ORDER BY COALESCE(layer,0), way_area DESC#012^#012in executeQuery Full sql was: 'SELECT * FROM (SELECT#012    way,#012    "natural",#012    waterway,#012    landuse,#012    COALESCE(tags->'name:ga', '') as name,#012    way_area/NULLIF(0::real*0::real,0) AS way_pixels,#012    CASE WHEN tags->'intermittent' IN ('yes')#012      OR tags->'seasonal' IN ('yes', 'spring', 'summer', 'autumn', 'winter', 'wet_season', 'dry_season')#012      THEN 'yes' ELSE 'no' END AS int_intermittent#012  FROM planet_osm_polygon#012  WHERE#012    (waterway IN ('dock', 'riverbank')#012      OR landuse IN ('reservoir', 'basin')#012      OR "natural" IN ('water', 'glacier'))#012    AND building IS NULL#012    AND way_area > 1*0::real*0::real#012  ORDER BY COALESCE(layer,0), way_area DESC#012) AS water_areas LIMIT 0'#012  encountered during parsing of layer 'water-areas' in Layer at line 8462 of '/data/maps/mapnik/osm-ga.xml'

It specifically seems to be barfing on:

ORDER BY COALESCE(layer,0), way_area) AS water_areas

I'm hoping this is something simple and someone with more experience has encountered this before and can point me in the right direction before I go down the "trial and error" rabbit hole... :)