pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16478: Unable to edit and delete for certain row manually using db beaver
3+ messages / 3 participants
[nested] [flat]

* BUG #16478: Unable to edit and delete for certain row manually using db beaver
@ 2020-06-04 06:39  PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 1 reply; 3+ messages in thread

From: PG Bug reporting form @ 2020-06-04 06:39 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: chris@xcidic.com

The following bug has been logged on the website:

Bug reference:      16478
Logged by:          Nanda Christanto
Email address:      chris@xcidic.com
PostgreSQL version: 10.6
Operating system:   Linux Ubuntu
Description:        

I got the following error in my postgre db and some of the in the data
cannot be edited / deleted at all? Any suggestion

FATAL: remaining connection slots are reserved for non-replication superuser
and rds_superuser connections
FATAL: remaining connection slots are reserved for non-replication superuser
and rds_superuser connections



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BUG #16478: Unable to edit and delete for certain row manually using db beaver
@ 2020-06-04 08:56  Francisco Olarte <folarte@peoplecall.com>
  parent: PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 1 reply; 3+ messages in thread

From: Francisco Olarte @ 2020-06-04 08:56 UTC (permalink / raw)
  To: chris@xcidic.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

Nanda:

On Thu, Jun 4, 2020 at 10:42 AM PG Bug reporting form
<noreply@postgresql.org> wrote:
> I got the following error in my postgre db and some of the in the data
> cannot be edited / deleted at all? Any suggestion
> FATAL: remaining connection slots are reserved for non-replication superuser
> and rds_superuser connections
> FATAL: remaining connection slots are reserved for non-replication superuser
> and rds_superuser connections

That does not seem like a bug. Postgres has a limit to the
connections, max_connections. Some of it are reserved for superusers,
so in case of problems the suepruser can still get in and fix them,
like the reserved root space on unix filesystems.

These seems like you have too many connection and you cannot edit
because you cannot connect. You are probably using a graphical client
which hides this fact.

You should ask your question in the general list, preferrably posting
some more details like "when I connect to postgres using wunderbar-sql
3.14.16 from linux I get this error and pink messages show", otherwise
even the very knodlegeable people on that list will not be able to
help you.

As this does not seem like a bug, but clearly configuration or pilot
error, this list is not the place to post it, and people replying to
bugs will probably just skip your message.

Regards.
   Francisco Olarte.





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BUG #16478: Unable to edit and delete for certain row manually using db beaver
@ 2020-06-04 09:56  Nanda Christanto <chris@xcidic.com>
  parent: Francisco Olarte <folarte@peoplecall.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Nanda Christanto @ 2020-06-04 09:56 UTC (permalink / raw)
  To: Francisco Olarte <folarte@peoplecall.com>; +Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

Hi Fransisco,

Thanks for your response. Actually before the remaining connection error I
was able to connect using db beaver just fine but though at that time I was
not able to edit or delete certain rows. Anytime I tried to update them I
got an error in my db beaver gui saying that error there is when sending
the data to the backend. Before this everything was working fine. That why
I thought its a bug. And in my app anytime we post, edit or delete it
causes time out error because the db cannot even be edited manually using
db beaver.
Would appreciate if you have any advice?

Thanks,
Regards,

On Thu, Jun 4, 2020 at 3:57 PM Francisco Olarte <folarte@peoplecall.com>
wrote:

> Nanda:
>
> On Thu, Jun 4, 2020 at 10:42 AM PG Bug reporting form
> <noreply@postgresql.org> wrote:
> > I got the following error in my postgre db and some of the in the data
> > cannot be edited / deleted at all? Any suggestion
> > FATAL: remaining connection slots are reserved for non-replication
> superuser
> > and rds_superuser connections
> > FATAL: remaining connection slots are reserved for non-replication
> superuser
> > and rds_superuser connections
>
> That does not seem like a bug. Postgres has a limit to the
> connections, max_connections. Some of it are reserved for superusers,
> so in case of problems the suepruser can still get in and fix them,
> like the reserved root space on unix filesystems.
>
> These seems like you have too many connection and you cannot edit
> because you cannot connect. You are probably using a graphical client
> which hides this fact.
>
> You should ask your question in the general list, preferrably posting
> some more details like "when I connect to postgres using wunderbar-sql
> 3.14.16 from linux I get this error and pink messages show", otherwise
> even the very knodlegeable people on that list will not be able to
> help you.
>
> As this does not seem like a bug, but clearly configuration or pilot
> error, this list is not the place to post it, and people replying to
> bugs will probably just skip your message.
>
> Regards.
>    Francisco Olarte.
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2020-06-04 09:56 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-06-04 06:39 BUG #16478: Unable to edit and delete for certain row manually using db beaver PG Bug reporting form <noreply@postgresql.org>
2020-06-04 08:56 ` Francisco Olarte <folarte@peoplecall.com>
2020-06-04 09:56   ` Nanda Christanto <chris@xcidic.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox