pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedError in log
4+ messages / 3 participants
[nested] [flat]
* Error in log
@ 2012-02-15 08:54 Frank Lanitz <frank@frank.uvena.de>
0 siblings, 0 replies; 4+ messages in thread
From: Frank Lanitz @ 2012-02-15 08:54 UTC (permalink / raw)
To: pgsql-admin
Hi folks,
Currently I'm not sure about the reason for a error entry inside syslog.
Maybe you can point me to right direction.
During last night I received this log entries:
> Feb 15 02:08:18 dbsrv kernel: [1158600.676036] INFO: task postgres:2358 blocked for
> more than 120 seconds.
> Feb 15 02:08:18 dbsrv kernel: [1158600.676102] "echo 0 >
> /proc/sys/kernel/hung_task_timeout_secs" disables this message.
> Feb 15 02:08:18 dbsrv kernel: [1158600.676201] postgres D ffff88000180fc40 0
> 2358 2279 0x00000000
> Feb 15 02:08:18 dbsrv kernel: [1158600.676206] ffffffff814891f0 0000000000000086
> 0000000000000000 000000010000000e
> Feb 15 02:08:18 dbsrv kernel: [1158600.676210] ffff8800f2ba4520 ffff8800f39e1e18
> 000000000000f9e0 ffff8800f39e1fd8
> Feb 15 02:08:18 dbsrv kernel: [1158600.676213] 0000000000015780 0000000000015780
> ffff8800f3f446a0 ffff8800f3f44998
> Feb 15 02:08:18 dbsrv kernel: [1158600.676217] Call Trace:
> Feb 15 02:08:18 dbsrv kernel: [1158600.676225] [<ffffffff810b4e8f>] ?
> wait_on_page_writeback_range+0xce/0x11b
> Feb 15 02:08:18 dbsrv kernel: [1158600.676238] [<ffffffffa0226e20>] ?
> log_wait_commit+0xbf/0x112 [jbd]
> Feb 15 02:08:18 dbsrv kernel: [1158600.676242] [<ffffffff8106502a>] ?
> autoremove_wake_function+0x0/0x2e
> Feb 15 02:08:18 dbsrv kernel: [1158600.676249] [<ffffffffa02373f8>] ?
> ext3_sync_file+0x94/0xc8 [ext3]
> Feb 15 02:08:18 dbsrv kernel: [1158600.676254] [<ffffffff8110c02c>] ?
> vfs_fsync_range+0x73/0x9e
> Feb 15 02:08:18 dbsrv kernel: [1158600.676257] [<ffffffff8110c0d6>] ?
During this time it could be that autovacuum was running (its manually
set to run after a data update has been successfuly done before.)
Its a 8.4.10 running on Debian Stable. Now I'm wondering whether an
issue with postgres itself or hardware or any other part of debian....
cheers,
Frank
^ permalink raw reply [nested|flat] 4+ messages in thread
* Error in log
@ 2023-11-02 07:59 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-11-02 08:06 ` Re: Error in log Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 4+ messages in thread
From: Rajesh Kumar @ 2023-11-02 07:59 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi team,
I see this in log ..what does it mean? Is this a problem? This seems to be
happening recently only. Why is this being logged?
Attachments:
[image/jpeg] tmp_1698911885347.jpg (69.8K, ../../CAJk5AtaUPPjjfk40uK_=sGmgkq-qRq6O6QSuSBP+BLbJjaXXuA@mail.gmail.com/3-tmp_1698911885347.jpg)
download | view image
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Error in log
2023-11-02 07:59 Error in log Rajesh Kumar <rajeshkumar.dba09@gmail.com>
@ 2023-11-02 08:06 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-11-02 08:21 ` Re: Error in log Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Laurenz Albe @ 2023-11-02 08:06 UTC (permalink / raw)
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Thu, 2023-11-02 at 13:29 +0530, Rajesh Kumar wrote:
> I see this in log ..what does it mean? Is this a problem?
> This seems to be happening recently only. Why is this being logged?
I got annoyed by the image of perfectly copy-and-pastable text,
which became blurry when I enlarged it. But I believe that it contained
only disconnection log messages, so you'd have to set
"log_disconnections = off".
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Error in log
2023-11-02 07:59 Error in log Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-11-02 08:06 ` Re: Error in log Laurenz Albe <laurenz.albe@cybertec.at>
@ 2023-11-02 08:21 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Rajesh Kumar @ 2023-11-02 08:21 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Sorry and thanks.
On Thu, 2 Nov 2023, 13:36 Laurenz Albe, <laurenz.albe@cybertec.at> wrote:
> On Thu, 2023-11-02 at 13:29 +0530, Rajesh Kumar wrote:
> > I see this in log ..what does it mean? Is this a problem?
> > This seems to be happening recently only. Why is this being logged?
>
> I got annoyed by the image of perfectly copy-and-pastable text,
> which became blurry when I enlarged it. But I believe that it contained
> only disconnection log messages, so you'd have to set
> "log_disconnections = off".
>
> Yours,
> Laurenz Albe
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2023-11-02 08:21 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-02-15 08:54 Error in log Frank Lanitz <frank@frank.uvena.de>
2023-11-02 07:59 Error in log Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-11-02 08:06 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-11-02 08:21 ` Rajesh Kumar <rajeshkumar.dba09@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