After reverting to futures/promises for our app/flexdashboard we noticed that our database started having 'SUSPENDED' queries related to the query that we put in the future statement.
After investigation, we found that if we only run one instance in Rconnect the queries and everything executes fine.
If we open two instances, one after another in browser in seperate tabs the 1st instance fails (never returns) and the 1st query is suspended. The second instance completes fine.
We tried adding hints with (nolock) and setting the lock_timeout to 10 seconds to the query to avoid blocking.
Any tips for how to prevent or trouble shoot? For now we've had to revert back since the suspended instances appeared to impacting our inserts.
Package info:
Package: shiny
Type: Package
Title: Web Application Framework for R
Version: 1.0.5.9000
Built: R 3.4.1; ; 2018-03-16 15:25:38 UTC; windows
RemoteType: github
RemoteHost: https://api.github.com
RemoteRepo: shiny
RemoteUsername: rstudio
RemoteRef: master
After reverting to futures/promises for our app/flexdashboard we noticed that our database started having 'SUSPENDED' queries related to the query that we put in the future statement.
After investigation, we found that if we only run one instance in Rconnect the queries and everything executes fine.
If we open two instances, one after another in browser in seperate tabs the 1st instance fails (never returns) and the 1st query is suspended. The second instance completes fine.
We tried adding hints with (nolock) and setting the lock_timeout to 10 seconds to the query to avoid blocking.
Any tips for how to prevent or trouble shoot? For now we've had to revert back since the suspended instances appeared to impacting our inserts.
Package info:
Package: shiny Type: Package Title: Web Application Framework for R Version: 1.0.5.9000 Built: R 3.4.1; ; 2018-03-16 15:25:38 UTC; windows RemoteType: github RemoteHost: https://api.github.com RemoteRepo: shiny RemoteUsername: rstudio RemoteRef: master
Package: htmlwidgets Version: 0.9 Date: 2017-07-10 Built: R 3.4.1; ; 2018-04-16 17:18:09 UTC; windows RemoteType: github RemoteHost: https://api.github.com RemoteRepo: htmlwidgets RemoteUsername: ramnathv RemoteRef: async
Package: plotly Version: 4.7.1.9000 Built: R 3.4.1; ; 2018-04-16 17:15:02 UTC; windows RemoteType: github RemoteHost: https://api.github.com RemoteRepo: plotly RemoteUsername: jcheng5 RemoteRef: joe/feature/async
Package: DT Type: Package Title: A Wrapper of the JavaScript Library 'DataTables' Version: 0.2.12 Built: R 3.4.1; ; 2018-04-16 17:19:38 UTC; windows RemoteType: github RemoteHost: https://api.github.com RemoteRepo: DT RemoteUsername: rstudio RemoteRef: async