libmysqlclient-dev has problem

[agronomofiorentini]

Dear contributors, i have a new issue to report about the way that golem create dockerfile.

This is my dockerfile

FROM rocker/r-ver:4.1.2
RUN apt-get update && apt-get install -y  gdal-bin git-core imagemagick libcurl4-openssl-dev libfontconfig1-dev libgdal-dev libgeos-dev libgeos++-dev libgit2-dev libicu-dev libmariadb-dev libpng-dev libpq-dev libproj-dev libssl-dev libudunits2-dev libxml2-dev make pandoc pandoc-citeproc zlib1g-dev && rm -rf /var/lib/apt/lists/*
RUN echo "options(repos = c(CRAN = 'https://cran.rstudio.com/'), download.file.method = 'libcurl', Ncpus = 4)" >> /usr/local/lib/R/etc/Rprofile.site
RUN R -e 'install.packages("remotes")'
RUN Rscript -e 'remotes::install_version("DBI",upgrade="never", version = "1.1.2")'
RUN Rscript -e 'remotes::install_version("lubridate",upgrade="never", version = "1.8.0")'
RUN Rscript -e 'remotes::install_version("shiny",upgrade="never", version = "1.7.1")'
RUN Rscript -e 'remotes::install_version("plotly",upgrade="never", version = "4.10.0")'
RUN Rscript -e 'remotes::install_version("raster",upgrade="never", version = "3.5-15")'
RUN Rscript -e 'remotes::install_version("leaflet",upgrade="never", version = "2.1.1")'
RUN Rscript -e 'remotes::install_version("pkgload",upgrade="never", version = "1.2.4")'
RUN Rscript -e 'remotes::install_version("googlesheets4",upgrade="never", version = "1.0.0")'
RUN Rscript -e 'remotes::install_version("RPostgreSQL",upgrade="never", version = "0.7-3")'
RUN Rscript -e 'remotes::install_version("timetk",upgrade="never", version = "2.7.0")'
RUN Rscript -e 'remotes::install_version("config",upgrade="never", version = "0.3.1")'
RUN Rscript -e 'remotes::install_version("tidyverse",upgrade="never", version = "1.3.1")'
RUN Rscript -e 'remotes::install_version("tidymodels",upgrade="never", version = "0.1.4")'
RUN Rscript -e 'remotes::install_version("shinymanager",upgrade="never", version = "1.0.400")'
RUN Rscript -e 'remotes::install_version("testthat",upgrade="never", version = "3.1.1")'
RUN Rscript -e 'remotes::install_version("spelling",upgrade="never", version = "2.2")'
RUN Rscript -e 'remotes::install_version("weathermetrics",upgrade="never", version = "1.2.2")'
RUN Rscript -e 'remotes::install_version("waiter",upgrade="never", version = "0.2.5")'
RUN Rscript -e 'remotes::install_version("shinyWidgets",upgrade="never", version = "0.6.4")'
RUN Rscript -e 'remotes::install_version("shinythemes",upgrade="never", version = "1.2.0")'
RUN Rscript -e 'remotes::install_version("shinydashboard",upgrade="never", version = "0.7.2")'
RUN Rscript -e 'remotes::install_version("shinycssloaders",upgrade="never", version = "1.0.0")'
RUN Rscript -e 'remotes::install_version("sever",upgrade="never", version = "0.0.7")'
RUN Rscript -e 'remotes::install_version("RPostgres",upgrade="never", version = "1.4.3")'
RUN Rscript -e 'remotes::install_version("rpostgis",upgrade="never", version = "1.4.3")'
RUN Rscript -e 'remotes::install_version("RMySQL",upgrade="never", version = "0.10.23")'
RUN Rscript -e 'remotes::install_version("rgdal",upgrade="never", version = "1.5-30")'
RUN Rscript -e 'remotes::install_version("modeltime",upgrade="never", version = "1.1.1")'
RUN Rscript -e 'remotes::install_version("mapview",upgrade="never", version = "2.10.0")'
RUN Rscript -e 'remotes::install_version("leaflet.extras",upgrade="never", version = "1.0.0")'
RUN Rscript -e 'remotes::install_version("golem",upgrade="never", version = "0.3.2")'
RUN mkdir /build_zone
ADD . /build_zone
WORKDIR /build_zone
RUN R -e 'options(warn = 2);remotes::install_local(upgrade="never")'
EXPOSE 80
CMD R -e "options('shiny.port'=80,shiny.host='0.0.0.0');AIBIOSAT::run_app()"

and when i build the image i have the follow output

5 34.58 Get:18 http://archive.ubuntu.com/ubuntu focal-backports/universe amd64 Packages [26.0 kB]

5 34.59 Fetched 21.9 MB in 34s (640 kB/s)

5 34.59 Reading package lists...

5 35.29 Reading package lists...

5 35.95 Building dependency tree...

5 36.09 Reading state information...

5 36.16 make is already the newest version (4.2.1-1.2).

5 36.16 Some packages could not be installed. This may mean that you have

5 36.16 requested an impossible situation or if you are using the unstable

5 36.16 distribution that some required packages have not yet been created

5 36.16 or been moved out of Incoming.

5 36.16 The following information may help to resolve the situation:

5 36.16

5 36.16 The following packages have unmet dependencies:

5 36.23 libmariadb-dev : Conflicts: libmysqlclient-dev but 8.0.28-0ubuntu0.20.04.3 is to be installed

5 36.23 Breaks: libmysqlclient-dev but 8.0.28-0ubuntu0.20.04.3 is to be installed

5 36.24 E: Unable to correct problems, you have held broken packages.

Could you please help me to understand the output and how to solve it?

[agronomofiorentini]

I have solved this.

I have tried again to run the dockerfile and now it is working.