Forums

Issue when writing in postgress

I have an app that worked well for years. Today we have an issue on every operation that need to write in the DB (postgress). The reading is slow but works. I read some other topic today on the forum about DB problem, maybe you have a global issue.

I've got errors on the server that are not related to the DB. Did pythonanywhere change something in threading config ?

2023-04-06 13:25:37 announcing my loyalty to the Emperor...
2023-04-06 13:36:33 Thu Apr  6 13:36:32 2023 - *** HARAKIRI ON WORKER 1 (pid: 11, try: 1) ***
2023-04-06 13:36:33 Thu Apr  6 13:36:32 2023 - HARAKIRI !!! worker 1 status !!!
2023-04-06 13:36:33 Thu Apr  6 13:36:32 2023 - HARAKIRI [core 0] 10.0.0.83 - POST /invoice/invoices/ since 1680787591
2023-04-06 13:36:33 Thu Apr  6 13:36:32 2023 - HARAKIRI !!! end of worker 1 status !!!
2023-04-06 13:36:33 DAMN ! worker 1 (pid: 11) died, killed by signal 9 :( trying respawn ...
2023-04-06 13:36:33 Respawned uWSGI worker 1 (new pid: 14)
2023-04-06 13:36:33 spawned 2 offload threads for uWSGI worker

Can you restart our postgress server or tell me how i could restart it myself ? It is urgent, thank you

I think that the problem you're having is separate to the other one that's been reported; Postgres servers on PythonAnywhere run on separate physical servers, and while several customers can be on the same physical server, you and the other customers are on different ones. The one that you're on is mostly idle in terms of CPU (the other customer's was running at a normal but higher level of utilisation).

However, there clearly must be something going on with yours! I've restarted it just now; could you check the site and see if it's working any better?

With regard to your question about threading -- we haven't changed anything at all on our US system recently.