Unable to perform INSERT or UPDATE operations into my PostgreSQL via PostgREST

[Mark_Howell]

Unable to perform INSERT or UPDATE operations into my PostgreSQL via PostgREST.

I’m using an HTTP URL call to the web service via a web browser.

SELECTs work but INSERTs do not, even when using the adm user as credentials on the service API.

Response: cannot execute INSERT in a read-only transaction

[Lukasz_Oles]

Hey @Mark_Howell is it still happening? Some fixes were pushed, but I’m not sure if they’re related to your issue.

[Mark_Howell]

Hi Lukasz. Yes it’s still happening. I can share the URL with you but I would rather not post it here.

Thanks,

Mark

[Mark_Howell]

Hi Lukasz. For info, this morning I find that my database is marked as degraded and there is a blank page displayed when i try to open the database page online. This wasn’t the case when I left it on friday night. This sounds similar to the following previous community post:

Database "Degraded" and no settings available

Hello @mjakl I’ve actually was debugging issue with your DB. It appears that you changed some settings. Maybe added a new role? The change worked, but wasn’t properly saved in our log. I was trying to find out why, but couldn’t. I was planning to continue work on it on Monday, but it seems that you’ve deleted the DB. We will try to improve our UI to better show why the service has “Degraded” status.

[Mark_Howell]

For information, there was a redeployment of my database on Saturday 7th february at 16h55 (CET). I assume this was as a result of the weekend maintenance. It failed.

There was another redeployment of my database on Sunday 8th february at 20h35 (CET). This also failed.

[Alexis_Guerville]

Hi Mark,

The database should be back up now. There was an issue with your DB service which caused the deployment to timeout. We’re still investigating exactly how it happened.

Sorry for the inconvenience.

[Mark_Howell]

Hi Alexis,

I finally managed to get an option to delete the database via the control panel a few hours ago, so I did. I then rebuilt it again. Thankfully it is not live yet. I would appreciate any advice you have on backups, as once it is live I won’t be able to wait 4 days like I did this time. I know I’m only on the cheapest plan right now, but I will scale up if/when there is take up on my new app.

For info, I also had some difficulties with Koyeb CLI which I downloaded this morning with the latest version, and a lot of the functionality Fin was suggesting to me wasn’t there.

[Mark_Howell]

In fact, I still have the problem where I cannot perform INSERT transactions via an API function using a URL. Fin has suggested various solutions but none of them have worked. If you could help point me in the right direction that would be great, as a database is a bit redundant if you cannot INSERT data. I would prefer to conduct this discussion via email though, given the details you will require in order to better understand the issue. Here is the response I get:

{"code":"25006","details":null,"hint":null,"message":"cannot execute INSERT in a read-only transaction"}

I don’t want to use my adm account to make this API call as the last time I did that, the adm account lost all privileges except READ.

[Mark_Howell]

Never mind. I fixed it. I now realise using a URL in a web browser is not a good test for an update/insert function. I’ve adapted the app to use POST and we are all good to go. Thank you for your feedback earlier.