From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Daniel Jakots <postgres(at)chown(dot)me>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: could not send data to client: Permission denied |
Date: | 2020-08-27 16:04:25 |
Message-ID: | 386b6ef2-c68b-c7fc-76b9-667c3a5babe5@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 8/27/20 8:28 AM, Daniel Jakots wrote:
> Hi,
>
> I run a flask rest api which use postgres to store data. I've been
> using it for a few months and it worked flawlessly. I recently got an
> error twice (58h10m apart). I added a lot more data a few days ago which
> could be the reason I get this now, but the table is still quite small
> with 69807 lines. This endpoint is called by a handful of machines
> every 5 minutes and it works all the time except those two times.
>
> The API runs in docker with gunicorn.
> [2020-08-27 02:10:03,624] ERROR in app: Exception on /v1/pf [GET]
> Traceback (most recent call last):
> [...]
> File "/home/snek/app/api/tools.py", line 94, in ip_get
> cursor.execute("SELECT ip FROM pf_ip_ban;")
> psycopg2.OperationalError: server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
> In postgresql log, it says:
> Aug 27 02:10:02 db1 postgres[62464]: [7-1] 10.10.10.43(41816):[unknown](at)[unknown]: LOG: connection received: host=10.10.10.43 port=4181
> Aug 27 02:10:02 db1 postgres[62464]: [8-1] 10.10.10.43(41816):api(at)api: LOG: connection authorized: user=api database=api
> Aug 27 02:10:02 db1 postgres[62464]: [9-1] 10.10.10.43(41816):api(at)api: LOG: could not send data to client: Permission denied
I would think it is the above.
Are you using some sort of authentication for the API?
> Aug 27 02:10:02 db1 postgres[62464]: [9-2] 10.10.10.43(41816):api(at)api: STATEMENT: SELECT ip FROM pf_ip_ban;
> Aug 27 02:10:02 db1 postgres[62464]: [10-1] 10.10.10.43(41816):api(at)api: FATAL: connection to client lost
> Aug 27 02:10:02 db1 postgres[62464]: [10-2] 10.10.10.43(41816):api(at)api: STATEMENT: SELECT ip FROM pf_ip_ban;
>
> Postgresql and the python code runs on two different VM, but
> they're both on the same hypervisor (kvm on ubuntu). Therefore I would
> assume the network between them should be uneventful; but software
> has bugs.
>
> Postgresql is postgresql-server-12.3p0 running OpenBSD -current.
>
> I searched the error on the web but I didn't find anything with this
> exact error. Do you know what could cause it? Or how could I get more
> information?
>
> I tuned OpenBSD according to our README:
> https://github.com/openbsd/ports/blob/master/databases/postgresql/pkg/README-server#L59-L68
> could it be that the values are too low since the table growth?
>
> Cheers,
> Daniel
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Jakots | 2020-08-27 16:14:49 | Re: could not send data to client: Permission denied |
Previous Message | Paul Förster | 2020-08-27 16:03:51 | Re: Postgres and alias |