pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #16692: Postgres process using 100 percent CPU
4+ messages / 4 participants
[nested] [flat]
* BUG #16692: Postgres process using 100 percent CPU
@ 2020-10-30 14:28 PG Bug reporting form <noreply@postgresql.org>
2020-10-30 14:32 ` Re: BUG #16692: Postgres process using 100 percent CPU Magnus Hagander <magnus@hagander.net>
0 siblings, 1 reply; 4+ messages in thread
From: PG Bug reporting form @ 2020-10-30 14:28 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: email2anup14@gmail.com
The following bug has been logged on the website:
Bug reference: 16692
Logged by: Anup Maity
Email address: email2anup14@gmail.com
PostgreSQL version: 11.0
Operating system: UBUNTU 20.4
Description:
From last 1 week, this process with user postgres is utilizing entire cpu
and approx 2.5gb ram. I have tried reinstalling postgres but then too the
issues persists. please help. No query is being running. this is in idle
usage
37811 postgres 20 0 2442744 2.3g 4 S 399.7 14.8 148:23.87
n2cP0Mv4
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #16692: Postgres process using 100 percent CPU
2020-10-30 14:28 BUG #16692: Postgres process using 100 percent CPU PG Bug reporting form <noreply@postgresql.org>
@ 2020-10-30 14:32 ` Magnus Hagander <magnus@hagander.net>
2020-10-30 15:39 ` Re: BUG #16692: Postgres process using 100 percent CPU hubert depesz lubaczewski <depesz@depesz.com>
2020-10-31 17:01 ` Re: BUG #16692: Postgres process using 100 percent CPU Jeff Janes <jeff.janes@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Magnus Hagander @ 2020-10-30 14:32 UTC (permalink / raw)
To: email2anup14@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
On Fri, Oct 30, 2020 at 3:29 PM PG Bug reporting form
<noreply@postgresql.org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference: 16692
> Logged by: Anup Maity
> Email address: email2anup14@gmail.com
> PostgreSQL version: 11.0
> Operating system: UBUNTU 20.4
> Description:
>
> From last 1 week, this process with user postgres is utilizing entire cpu
> and approx 2.5gb ram. I have tried reinstalling postgres but then too the
> issues persists. please help. No query is being running. this is in idle
> usage
> 37811 postgres 20 0 2442744 2.3g 4 S 399.7 14.8 148:23.87
> n2cP0Mv4
>
That is not a PostgreSQL process.
It looks very much like malware running on your system, that happens
to be running under the "postgres" user account.
I'd shut the machine down immediately. And then mount the file system
through some other means (meaning mount the disk from a different
system and absolutely do *NOT* boot off this disk), figuring out where
those binaries are and try to salvage the database from there.
--
Magnus Hagander
Me: https://www.hagander.net/
Work: https://www.redpill-linpro.com/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #16692: Postgres process using 100 percent CPU
2020-10-30 14:28 BUG #16692: Postgres process using 100 percent CPU PG Bug reporting form <noreply@postgresql.org>
2020-10-30 14:32 ` Re: BUG #16692: Postgres process using 100 percent CPU Magnus Hagander <magnus@hagander.net>
@ 2020-10-30 15:39 ` hubert depesz lubaczewski <depesz@depesz.com>
1 sibling, 0 replies; 4+ messages in thread
From: hubert depesz lubaczewski @ 2020-10-30 15:39 UTC (permalink / raw)
To: Magnus Hagander <magnus@hagander.net>; +Cc: email2anup14@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
On Fri, Oct 30, 2020 at 03:32:13PM +0100, Magnus Hagander wrote:
> On Fri, Oct 30, 2020 at 3:29 PM PG Bug reporting form
> <noreply@postgresql.org> wrote:
> >
> > The following bug has been logged on the website:
> >
> > Bug reference: 16692
> > Logged by: Anup Maity
> > Email address: email2anup14@gmail.com
> > PostgreSQL version: 11.0
> > Operating system: UBUNTU 20.4
> > Description:
> >
> > From last 1 week, this process with user postgres is utilizing entire cpu
> > and approx 2.5gb ram. I have tried reinstalling postgres but then too the
> > issues persists. please help. No query is being running. this is in idle
> > usage
> > 37811 postgres 20 0 2442744 2.3g 4 S 399.7 14.8 148:23.87
> > n2cP0Mv4
> >
>
> That is not a PostgreSQL process.
>
> It looks very much like malware running on your system, that happens
> to be running under the "postgres" user account.
>
> I'd shut the machine down immediately. And then mount the file system
> through some other means (meaning mount the disk from a different
> system and absolutely do *NOT* boot off this disk), figuring out where
> those binaries are and try to salvage the database from there.
Before shutting down it might be good to look at "ls -l /proc/37811",
especially "cwd" and "exe" links.
depesz
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #16692: Postgres process using 100 percent CPU
2020-10-30 14:28 BUG #16692: Postgres process using 100 percent CPU PG Bug reporting form <noreply@postgresql.org>
2020-10-30 14:32 ` Re: BUG #16692: Postgres process using 100 percent CPU Magnus Hagander <magnus@hagander.net>
@ 2020-10-31 17:01 ` Jeff Janes <jeff.janes@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Jeff Janes @ 2020-10-31 17:01 UTC (permalink / raw)
To: Magnus Hagander <magnus@hagander.net>; +Cc: email2anup14@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
On Fri, Oct 30, 2020 at 10:32 AM Magnus Hagander <magnus@hagander.net>
wrote:
> On Fri, Oct 30, 2020 at 3:29 PM PG Bug reporting form
> <noreply@postgresql.org> wrote:
> >
> > 37811 postgres 20 0 2442744 2.3g 4 S 399.7 14.8 148:23.87
> > n2cP0Mv4
> >
>
> That is not a PostgreSQL process.
>
> It looks very much like malware running on your system, that happens
> to be running under the "postgres" user account.
>
To expand on that, the malware was likely to have been installed and
started through a compromised superuser account for his database. It is a
common attack to look for postgreSQL superuser accounts with weak
passwords, then use lo_export or COPY ... TO PROGRAM to drop cryptocurrency
mining programs. They often have names that look like that, too.
Reinstalling but without fixing the security practices just means the bad
guys come back again.
Cheers,
Jeff
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2020-10-31 17:01 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-10-30 14:28 BUG #16692: Postgres process using 100 percent CPU PG Bug reporting form <noreply@postgresql.org>
2020-10-30 14:32 ` Magnus Hagander <magnus@hagander.net>
2020-10-30 15:39 ` hubert depesz lubaczewski <depesz@depesz.com>
2020-10-31 17:01 ` Jeff Janes <jeff.janes@gmail.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