Posit Connect Cloud Shiny App Deploying

Posit Professional & Hosted Products Connect Cloud (Beta)
1

Hi :slight_smile:

Here my GitHub with the code. I am trying to develop a shiny dashboard which uses an LLM to query a sql database: look the last page. The others are part of another task.

I don't get how to solve te error in the log. Looking at the documentation I noticed I was using renv and removed it. I also looked at this page about the known issues.

What am I missing?

Thanks for the support,

Simone

Log
2025-03-04T11:55:49+01:00 Your publish request with ID 9ecc7d76-820b-47ae-8a79-b9364c3e89ea is now being processed.
2025-03-04T11:55:49+01:00 Quarto version was not provided. Using 1.6.42
2025-03-04T11:55:49+01:00 Loading your source code...
2025-03-04T11:55:49+01:00 Initialized empty Git repository in /cloud/project/.git/
2025-03-04T11:55:50+01:00 From GitHub - SimoneBrazzi/sql_query
2025-03-04T11:55:50+01:00 * branch 74827d89369bab8e0ff96552d7626650a5086fc7 -> FETCH_HEAD
2025-03-04T11:55:50+01:00 HEAD is now at 74827d8 make the app a single file for deployment
2025-03-04T11:55:50+01:00 Quarto version was not provided. Using 1.6.42
2025-03-04T11:55:50+01:00 Collecting your code's R dependencies...
2025-03-04T11:55:50+01:00 40 new R package(s) to install.
2025-03-04T11:55:50+01:00 Connect Cloud is providing all 40 required R packages:
2025-03-04T11:55:50+01:00 askpass@1.2.1, base64enc@0.1-3, bslib@0.9.0, cachem@1.1.0, cli@3.6.4
2025-03-04T11:55:50+01:00 commonmark@1.9.2, coro@1.1.0, crayon@1.5.3, curl@6.2.1, digest@0.6.37
2025-03-04T11:55:50+01:00 ellmer@0.1.1, fastmap@1.2.0, fontawesome@0.5.3, fs@1.6.5, glue@1.8.0
2025-03-04T11:55:50+01:00 htmltools@0.5.8.1, httpuv@1.6.15, httr2@1.1.0, jquerylib@0.1.4, jsonlite@1.9.1
2025-03-04T11:55:50+01:00 later@1.4.1, lifecycle@1.0.4, magrittr@2.0.3, memoise@2.0.1, mime@0.12
2025-03-04T11:55:50+01:00 openssl@2.3.2, promises@1.3.2, R6@2.6.1, rappdirs@0.3.3, Rcpp@1.0.14
2025-03-04T11:55:50+01:00 rlang@1.1.5, S7@0.2.0, sass@0.4.9, shiny@1.10.0, shinychat@0.1.1
2025-03-04T11:55:50+01:00 sourcetools@0.1.7-1, sys@3.4.3, vctrs@0.6.5, withr@3.0.2, xtable@1.8-4
2025-03-04T11:55:52+01:00 Connect Cloud is providing all 146 required Python packages:
2025-03-04T11:55:52+01:00 absl-py==2.1.0, anyio==4.6.2.post1, appnope==0.1.4, argon2-cffi==23.1.0, argon2-cffi-bindings==21.2.0
2025-03-04T11:55:52+01:00 arrow==1.3.0, asttokens==2.4.1, astunparse==1.6.3, async-lru==2.0.4, attrs==24.2.0
2025-03-04T11:55:52+01:00 babel==2.16.0, beautifulsoup4==4.12.3, bleach==6.2.0, certifi==2024.8.30, cffi==1.17.1
2025-03-04T11:55:52+01:00 charset-normalizer==3.4.0, cloudpickle==3.1.0, comm==0.2.2, contourpy==1.3.1, cycler==0.12.1
2025-03-04T11:55:52+01:00 debugpy==1.8.8, decorator==5.1.1, defusedxml==0.7.1, executing==2.1.0, fastjsonschema==2.20.0
2025-03-04T11:55:52+01:00 flatbuffers==24.3.25, fonttools==4.54.1, fqdn==1.5.1, gast==0.6.0, google-pasta==0.2.0
2025-03-04T11:55:52+01:00 grpcio==1.67.1, h11==0.14.0, h5py==3.12.1, httpcore==1.0.6, httpx==0.27.2
2025-03-04T11:55:52+01:00 idna==3.10, ipykernel==6.29.5, ipython==8.29.0, ipywidgets==8.1.5, isoduration==20.11.0
2025-03-04T11:55:52+01:00 jedi==0.19.2, jinja2==3.1.4, joblib==1.4.2, json5==0.9.28, jsonpointer==3.0.0
2025-03-04T11:55:52+01:00 jsonschema==4.23.0, jsonschema-specifications==2024.10.1, jupyter==1.1.1, jupyter-client==8.6.3, jupyter-console==6.6.3
2025-03-04T11:55:52+01:00 jupyter-core==5.7.2, jupyter-events==0.10.0, jupyter-lsp==2.2.5, jupyter-server==2.14.2, jupyter-server-terminals==0.5.3
2025-03-04T11:55:52+01:00 jupyterlab==4.2.5, jupyterlab-pygments==0.3.0, jupyterlab-server==2.27.3, jupyterlab-widgets==3.0.13, keras==3.6.0
2025-03-04T11:55:52+01:00 kiwisolver==1.4.7, libclang==18.1.1, llvmlite==0.43.0, markdown==3.7, markdown-it-py==3.0.0
2025-03-04T11:55:52+01:00 markupsafe==3.0.2, matplotlib==3.9.2, matplotlib-inline==0.1.7, mdurl==0.1.2, mistune==3.0.2
2025-03-04T11:55:52+01:00 ml-dtypes==0.4.1, namex==0.0.8, nbclient==0.10.0, nbconvert==7.16.4, nbformat==5.10.4
2025-03-04T11:55:52+01:00 nest-asyncio==1.6.0, notebook==7.2.2, notebook-shim==0.2.4, numba==0.60.0, numpy==2.0.2
2025-03-04T11:55:52+01:00 nvidia-nccl-cu12==2.25.1, opt-einsum==3.4.0, optree==0.13.1, overrides==7.7.0, packaging==24.2
2025-03-04T11:55:52+01:00 pandas==2.2.3, pandocfilters==1.5.1, parso==0.8.4, pexpect==4.9.0, pillow==11.0.0
2025-03-04T11:55:52+01:00 platformdirs==4.3.6, prometheus-client==0.21.0, prompt-toolkit==3.0.48, protobuf==5.28.3, psutil==6.1.0
2025-03-04T11:55:52+01:00 ptyprocess==0.7.0, pure-eval==0.2.3, pycparser==2.22, pygments==2.18.0, pyparsing==3.2.0
2025-03-04T11:55:52+01:00 python-dateutil==2.9.0.post0, python-json-logger==2.0.7, pytz==2024.2, pyyaml==6.0.2, pyzmq==26.2.0
2025-03-04T11:55:52+01:00 referencing==0.35.1, requests==2.32.3, rfc3339-validator==0.1.4, rfc3986-validator==0.1.1, rich==13.9.4
2025-03-04T11:55:52+01:00 rpds-py==0.21.0, scikit-learn==1.5.2, scipy==1.14.1, send2trash==1.8.3, setuptools==75.8.2
2025-03-04T11:55:52+01:00 shap==0.46.0, six==1.16.0, slicer==0.0.8, sniffio==1.3.1, soupsieve==2.6
2025-03-04T11:55:52+01:00 stack-data==0.6.3, tensorboard==2.18.0, tensorboard-data-server==0.7.2, tensorflow==2.18.0, tensorflow-io-gcs-filesystem==0.37.1
2025-03-04T11:55:52+01:00 termcolor==2.5.0, terminado==0.18.1, threadpoolctl==3.5.0, tinycss2==1.4.0, tornado==6.4.1
2025-03-04T11:55:52+01:00 tqdm==4.67.0, traitlets==5.14.3, types-python-dateutil==2.9.0.20241003, typing-extensions==4.12.2, tzdata==2024.2
2025-03-04T11:55:52+01:00 uri-template==1.3.0, urllib3==2.2.3, wcwidth==0.2.13, webcolors==24.11.1, webencodings==0.5.1
2025-03-04T11:55:52+01:00 websocket-client==1.8.0, werkzeug==3.1.3, wheel==0.45.1, widgetsnbextension==4.0.13, wrapt==1.16.0
2025-03-04T11:55:52+01:00 xgboost==2.1.2
2025-03-04T11:55:52+01:00 Quarto version was not provided. Using 1.6.42
2025-03-04T11:55:52+01:00 Using Quarto version: 1.6.42
2025-03-04T11:55:53+01:00 Running on host: deployment-019560b7-7644d922669603b25b81b4e9cf5b7722-deplovqchm
2025-03-04T11:55:53+01:00 Process ID: 212
2025-03-04T11:55:53+01:00 Running as user: uid=10002(connect) gid=10002(connect) groups=10002(connect)
2025-03-04T11:55:53+01:00 Connect version: 2025.02.0
2025-03-04T11:55:53+01:00 LANG: C.UTF-8
2025-03-04T11:55:53+01:00 Working directory: /cloud/project
2025-03-04T11:55:53+01:00 Using R 4.4.2
2025-03-04T11:55:53+01:00 R.home(): /opt/R/4.4.2/lib/R
2025-03-04T11:55:53+01:00 Content will use current R environment
2025-03-04T11:55:53+01:00 R_LIBS: /cloud/lib/x86_64-pc-linux-gnu-library/4.4
2025-03-04T11:55:53+01:00 .libPaths(): /cloud/lib/x86_64-pc-linux-gnu-library/4.4, /opt/R/4.4.2/lib/R/library
2025-03-04T11:55:53+01:00 shiny version: 1.10.0
2025-03-04T11:55:53+01:00 httpuv version: 1.6.15
2025-03-04T11:55:53+01:00 rmarkdown version: (none)
2025-03-04T11:55:53+01:00 knitr version: (none)
2025-03-04T11:55:53+01:00 jsonlite version: 1.9.1
2025-03-04T11:55:53+01:00 RJSONIO version: (none)
2025-03-04T11:55:53+01:00 htmltools version: 0.5.8.1
2025-03-04T11:55:53+01:00 reticulate version: (none)
2025-03-04T11:55:53+01:00 Using pandoc: /opt/connect/connect-cloud-2025.02.0/ext/pandoc/2.16
2025-03-04T11:55:53+01:00 Shiny application starting ...
2025-03-04T11:55:53+01:00 Installing package into ‘/cloud/lib/x86_64-pc-linux-gnu-library/4.4’
2025-03-04T11:55:53+01:00 (as ‘lib’ is unspecified)
2025-03-04T11:55:53+01:00 Error in contrib.url(repos, type) :
2025-03-04T11:55:53+01:00 trying to use CRAN without setting a mirror
2025-03-04T11:55:53+01:00 Calls: local ... tryCatch -> tryCatchList -> tryCatchOne ->
2025-03-04T11:55:53+01:00 Execution halted
2025-03-04T11:55:53+01:00 Shiny application exiting ...
2025-03-04T11:55:53+01:00 Failed to publish content: Your application failed to start. error_id=a7b0fb53-483a-4c8d-8599-969cb992acc4

2

Hi Simone,
It looks like the issue is that your application is itself trying to install some R packages. In your helper.R which is sourced by app.R I see install.packages calls.

Usually you don't want to install packages that way one at a time every time your application's code runs because people using your application have to wait for the installations to complete. As long as all the packages you are using are listed in your manifest.json then you can skip installing them explicitly (maybe just don't source helper.R?) and Connect Cloud will provide them for you.

Regards,
Mike

1 Like
3

Thank you very much! I also had to import the libraries using the classic library(). I don't care, I just wanted it to work :slight_smile:

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.