pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16227: Loss database tables automatically in a couple of days
5+ messages / 4 participants
[nested] [flat]

* BUG #16227: Loss database tables automatically in a couple of days
@ 2020-01-23 10:03 PG Bug reporting form <noreply@postgresql.org>
  2020-01-23 11:48 ` Re: BUG #16227: Loss database tables automatically in a couple of days Michael Paquier <michael@paquier.xyz>
  0 siblings, 1 reply; 5+ messages in thread

From: PG Bug reporting form @ 2020-01-23 10:03 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: srinivasulu@accuracy.com.sg

The following bug has been logged on the website:

Bug reference:      16227
Logged by:          Srinu Vasu
Email address:      srinivasulu@accuracy.com.sg
PostgreSQL version: 11.0
Operating system:   Windows
Description:        

Hi team,

Every couple of days we are loosing our postgres server database tables
automcaticaly.
Please check this issue and give us a solution to avoid that..



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

* Re: BUG #16227: Loss database tables automatically in a couple of days
  2020-01-23 10:03 BUG #16227: Loss database tables automatically in a couple of days PG Bug reporting form <noreply@postgresql.org>
@ 2020-01-23 11:48 ` Michael Paquier <michael@paquier.xyz>
  2020-01-23 12:10   ` RE: BUG #16227: Loss database tables automatically in a couple of days srinivasulu <srinivasulu@accuracy.com.sg>
  0 siblings, 1 reply; 5+ messages in thread

From: Michael Paquier @ 2020-01-23 11:48 UTC (permalink / raw)
  To: srinivasulu@accuracy.com.sg; pgsql-bugs@lists.postgresql.org

On Thu, Jan 23, 2020 at 10:03:37AM +0000, PG Bug reporting form wrote:
> Every couple of days we are loosing our postgres server database tables
> automcaticaly.
> Please check this issue and give us a solution to avoid that..

It is impossible to know what is happening to you if you provide zero
details.  Tables going away would mean that DROP TABLE commands are
issues, so you may want to monitor and audit that.
--
Michael

Attachments:

  signature.asc (application/pgp-signature, 832B) download

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

* RE: BUG #16227: Loss database tables automatically in a couple of days
  2020-01-23 10:03 BUG #16227: Loss database tables automatically in a couple of days PG Bug reporting form <noreply@postgresql.org>
  2020-01-23 11:48 ` Re: BUG #16227: Loss database tables automatically in a couple of days Michael Paquier <michael@paquier.xyz>
@ 2020-01-23 12:10   ` srinivasulu <srinivasulu@accuracy.com.sg>
  2020-01-24 13:04     ` Re: BUG #16227: Loss database tables automatically in a couple of days Daniel Gustafsson <daniel@yesql.se>
  0 siblings, 1 reply; 5+ messages in thread

From: srinivasulu @ 2020-01-23 12:10 UTC (permalink / raw)
  To: 'Michael Paquier' <michael@paquier.xyz>; pgsql-bugs@lists.postgresql.org

Please find the attached log file and check it once.

I will send you if you need any details

-----Original Message-----
From: Michael Paquier [mailto:michael@paquier.xyz] 
Sent: Thursday, January 23, 2020 5:18 PM
To: srinivasulu@accuracy.com.sg; pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16227: Loss database tables automatically in a couple of
days

On Thu, Jan 23, 2020 at 10:03:37AM +0000, PG Bug reporting form wrote:
> Every couple of days we are loosing our postgres server database 
> tables automcaticaly.
> Please check this issue and give us a solution to avoid that..

It is impossible to know what is happening to you if you provide zero
details.  Tables going away would mean that DROP TABLE commands are issues,
so you may want to monitor and audit that.
--
Michael

Attachments:

  postgresql-2020-01-19_000000.log (application/octet-stream, 192.9K) download

  postgresql-2020-01-20_000000.log (application/octet-stream, 200.8K) download

  postgresql-2020-01-21_000000.log (application/octet-stream, 68.8K) download

  postgresql-2020-01-21_204408.log (application/octet-stream, 29.4K) download

  postgresql-2020-01-22_000000.log (application/octet-stream, 196.1K) download

  postgresql-2020-01-23_000000.log (application/octet-stream, 33.7K) download

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

* Re: BUG #16227: Loss database tables automatically in a couple of days
  2020-01-23 10:03 BUG #16227: Loss database tables automatically in a couple of days PG Bug reporting form <noreply@postgresql.org>
  2020-01-23 11:48 ` Re: BUG #16227: Loss database tables automatically in a couple of days Michael Paquier <michael@paquier.xyz>
  2020-01-23 12:10   ` RE: BUG #16227: Loss database tables automatically in a couple of days srinivasulu <srinivasulu@accuracy.com.sg>
@ 2020-01-24 13:04     ` Daniel Gustafsson <daniel@yesql.se>
  2020-01-27 03:16       ` Re: BUG #16227: Loss database tables automatically in a couple of days Michael Paquier <michael@paquier.xyz>
  0 siblings, 1 reply; 5+ messages in thread

From: Daniel Gustafsson @ 2020-01-24 13:04 UTC (permalink / raw)
  To: srinivasulu <srinivasulu@accuracy.com.sg>; +Cc: Michael Paquier <michael@paquier.xyz>; pgsql-bugs@lists.postgresql.org

Please avoid top-posting on the mailinglist.

> On 23 Jan 2020, at 13:10, srinivasulu <srinivasulu@accuracy.com.sg> wrote:
> 
> Please find the attached log file and check it once.
> 
> I will send you if you need any details

I don't think this log dump qualifies as providing details, this is a volunteer
driven effort where people spend their own time.  Have you gone over them to
see if there is anything you suspect?  Looking at a single one of these, there
are numerous DROP TABLE statements in it, and we have no way of knowing if
thats expected or not.

If you need help you will have to be more specific, and provide more details.

cheers ./daniel




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

* Re: BUG #16227: Loss database tables automatically in a couple of days
  2020-01-23 10:03 BUG #16227: Loss database tables automatically in a couple of days PG Bug reporting form <noreply@postgresql.org>
  2020-01-23 11:48 ` Re: BUG #16227: Loss database tables automatically in a couple of days Michael Paquier <michael@paquier.xyz>
  2020-01-23 12:10   ` RE: BUG #16227: Loss database tables automatically in a couple of days srinivasulu <srinivasulu@accuracy.com.sg>
  2020-01-24 13:04     ` Re: BUG #16227: Loss database tables automatically in a couple of days Daniel Gustafsson <daniel@yesql.se>
@ 2020-01-27 03:16       ` Michael Paquier <michael@paquier.xyz>
  0 siblings, 0 replies; 5+ messages in thread

From: Michael Paquier @ 2020-01-27 03:16 UTC (permalink / raw)
  To: Daniel Gustafsson <daniel@yesql.se>; +Cc: srinivasulu <srinivasulu@accuracy.com.sg>; pgsql-bugs@lists.postgresql.org

On Fri, Jan 24, 2020 at 02:04:57PM +0100, Daniel Gustafsson wrote:
> I don't think this log dump qualifies as providing details, this is a volunteer
> driven effort where people spend their own time.  Have you gone over them to
> see if there is anything you suspect?  Looking at a single one of these, there
> are numerous DROP TABLE statements in it, and we have no way of knowing if
> thats expected or not.

Yeah.  What I can see from those logs is a bunch of logs mentioning
DDL queries doing what you are complaining about.  What you should try
to understand is from where those come from.  This comes with an effort
from your side, where you need to audit your queries, and put in place
drastic connection policies to your database.  One thing that you
should try to do first is enable log_connections and
log_disconnections.  A second is to track down the process which may
be doing that.  And that's not an issue with Postgres, that's an issue
with your server.  Postgres here simply does what it is told to.
--
Michael

Attachments:

  signature.asc (application/pgp-signature, 832B) download

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


end of thread, other threads:[~2020-01-27 03:16 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-01-23 10:03 BUG #16227: Loss database tables automatically in a couple of days PG Bug reporting form <noreply@postgresql.org>
2020-01-23 11:48 ` Michael Paquier <michael@paquier.xyz>
2020-01-23 12:10   ` srinivasulu <srinivasulu@accuracy.com.sg>
2020-01-24 13:04     ` Daniel Gustafsson <daniel@yesql.se>
2020-01-27 03:16       ` Michael Paquier <michael@paquier.xyz>

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