An error has occurred unable to open database file

You may see this error on RStudio Connect, or when attempting to publish to RStudio Connect.

Resolution

We typically see these types of database errors when the RStudio Connect server does not have sufficient disk space. The best way to resolve this is to remove disk space on the server or expand the disk that's currently available.

If you're deploying an updated version of an application, a good way to clear up disk space is to delete previous iterations of the same application. You can automate this by using the Applications.RenderingSweepLimit option as defined here:
https://docs.rstudio.com/connect/admin/appendix/configuration/#Applications.RenderingSweepLimit
 
It defaults to 30, so you may want to set this to a lower value in your /etc/rstudio-connect/rstudio-connect.gcfg configuration file. It should look something like this:

[Applications]
RenderingSweepLimit = 5

You can also use the Applications.RenderingSweepAge which defines the  maximum age of a rendering retained for any one application. Renderings older than this setting will be removed. An example of this set to 3 days is below:

[Applications] 
RenderingSweepAge = 3

https://docs.rstudio.com/connect/admin/appendix/configuration/#Applications.RenderingSweepAge

You can also use these 2 settings in conjunction like this:

[Applications] 
RenderingSweepLimit = 5
RenderingSweepAge = 3

From there, restart RStudio Connect for these changes to take effect:

sudo systemctl restart rstudio-connect

You can also see the disk space available on all of your mount points by running the command below:

df -h

Support Ticket

If you still have issues after completing the above, you can always lodge a support ticket, where our group of friendly, and incredibly knowledgeable staff can assist with any issues that you may be having. You can submit a ticket here:

https://support.rstudio.com/hc/en-us/requests/new