Hello,
We are having an issue which I suspect is database related. We have a web application on which we can upload files. When we upload a file, data from that file gets saved to a SQL database. We also have a web API that reads from that database. Recently, we discovered that when I upload a file, during the time that file is uploading, the API responds with a general error (internal server error 500).
We are wondering if maybe our database is configured to handle only one operation at a time; that is, maybe while it is save data from the file, it is too tied up to service any requests for data from the API.
Is there any way to check for this in the database settings/configurations?
Database servers are typically only set to single user during times when you are trying to fix a serious problem. Normally (and especially when accepting connections from a web app), database servers can handle multiple connections. I'm betting that your app is broken.