pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcould not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
12+ messages / 7 participants
[nested] [flat]
* could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
@ 2011-06-16 05:28 bakkiya <bakkiya@gmail.com>
0 siblings, 2 replies; 12+ messages in thread
From: bakkiya @ 2011-06-16 05:28 UTC (permalink / raw)
To: pgsql-admin
Hi,
We have postgresql9.0 in our Linux server. We are continously getting "could
not open temporary statistics file "pg_stat_tmp/pgstat.tmp": No such file or
directory" message in the db log file.We have data/pg_stat_tmp directory in,
but pgstat.tmp file is not ppresent in this directory.Can someone tell us
why this error messgae is logged?
Thanks.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/could-not-open-temporary-statistics-file-pg-stat-tmp-pgstat-...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
@ 2011-06-16 06:23 Tim <elatllat@gmail.com>
parent: bakkiya <bakkiya@gmail.com>
1 sibling, 1 reply; 12+ messages in thread
From: Tim @ 2011-06-16 06:23 UTC (permalink / raw)
To: bakkiya <bakkiya@gmail.com>; +Cc: pgsql-admin
I don't know but I would try this first:
touch pg_stat_tmp/pgstat.tmp
chmod 0777 pg_stat_tmp/pgstat.tmp
ls -halZ pg_stat_tmp
On Thu, Jun 16, 2011 at 1:28 AM, bakkiya <bakkiya@gmail.com> wrote:
> Hi,
> We have postgresql9.0 in our Linux server. We are continously getting
> "could
> not open temporary statistics file "pg_stat_tmp/pgstat.tmp": No such file
> or
> directory" message in the db log file.We have data/pg_stat_tmp directory
> in,
> but pgstat.tmp file is not ppresent in this directory.Can someone tell us
> why this error messgae is logged?
>
> Thanks.
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/could-not-open-temporary-statistics-file-pg-stat-tmp-pgstat-...
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
@ 2011-06-16 06:34 Simon Riggs <simon@2ndQuadrant.com>
parent: bakkiya <bakkiya@gmail.com>
1 sibling, 0 replies; 12+ messages in thread
From: Simon Riggs @ 2011-06-16 06:34 UTC (permalink / raw)
To: bakkiya <bakkiya@gmail.com>; +Cc: pgsql-admin
On Thu, Jun 16, 2011 at 6:28 AM, bakkiya <bakkiya@gmail.com> wrote:
> We have postgresql9.0 in our Linux server. We are continously getting "could
> not open temporary statistics file "pg_stat_tmp/pgstat.tmp": No such file or
> directory" message in the db log file.We have data/pg_stat_tmp directory in,
> but pgstat.tmp file is not ppresent in this directory.Can someone tell us
> why this error messgae is logged?
The file is being opened for write.
Permissions? Space? Kernel settings?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
@ 2011-06-16 06:44 bakkiya <bakkiya@gmail.com>
parent: Tim <elatllat@gmail.com>
0 siblings, 2 replies; 12+ messages in thread
From: bakkiya @ 2011-06-16 06:44 UTC (permalink / raw)
To: pgsql-admin
postgresql/data/pg_stat_tmp> df -h .
Filesystem Size Used Avail Use% Mounted on
/dev/xvdb1 197G 16G 171G 9% /pub
postgresql/data/pg_stat_tmp> touch a
novell@s210:/pub/var/opt/novell/sentinel/3rdparty/postgresql/data/pg_stat_tmp>
ls -rtl
total 96
-rw------- 1 novell novell 91898 2011-06-15 23:36 pgstat.stat
-rw-r--r-- 1 novell novell 0 2011-06-15 23:36 a
/postgresql/data/pg_stat_tmp> uname -a
Linux s210 2.6.32.12-0.7-xen #1 SMP 2010-05-20 11:14:20 +0200 x86_64 x86_64
x86_64 GNU/Linux
Space,permission are not an issue.
Thanks.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/could-not-open-temporary-statistics-file-pg-stat-tmp-pgstat-...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
@ 2011-06-16 06:50 Simon Riggs <simon@2ndQuadrant.com>
parent: bakkiya <bakkiya@gmail.com>
1 sibling, 1 reply; 12+ messages in thread
From: Simon Riggs @ 2011-06-16 06:50 UTC (permalink / raw)
To: bakkiya <bakkiya@gmail.com>; +Cc: pgsql-admin
On Thu, Jun 16, 2011 at 7:44 AM, bakkiya <bakkiya@gmail.com> wrote:
> Space,permission are not an issue.
Then presumably you have your stats_temp_directory parameter set to a
path where that is not true.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
@ 2011-06-16 06:53 Rafael Martinez <r.m.guerrero@usit.uio.no>
parent: bakkiya <bakkiya@gmail.com>
1 sibling, 1 reply; 12+ messages in thread
From: Rafael Martinez @ 2011-06-16 06:53 UTC (permalink / raw)
To: bakkiya <bakkiya@gmail.com>; +Cc: pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 06/16/2011 08:44 AM, bakkiya wrote:
>
> postgresql/data/pg_stat_tmp> touch a
> novell@s210:/pub/var/opt/novell/sentinel/3rdparty/postgresql/data/pg_stat_tmp>
> ls -rtl
> total 96
> -rw------- 1 novell novell 91898 2011-06-15 23:36 pgstat.stat
> -rw-r--r-- 1 novell novell 0 2011-06-15 23:36 a
>
Hei
Are you running postgres with the user 'novell' or 'postgres'?
The user running postgres must own the directories with the data.
regards,
- --
Rafael Martinez Guerrero
Center for Information Technology
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (GNU/Linux)
iEYEARECAAYFAk35qG0ACgkQBhuKQurGihRuQQCgmxS8JsGnYm4SdGZZt85RLjq6
MroAn0jy5NKxZrTinHqQfCnUPMUS70SS
=l2ef
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
@ 2011-06-16 06:56 bakkiya <bakkiya@gmail.com>
parent: Rafael Martinez <r.m.guerrero@usit.uio.no>
0 siblings, 0 replies; 12+ messages in thread
From: bakkiya @ 2011-06-16 06:56 UTC (permalink / raw)
To: pgsql-admin
No, we run postgres with the novell user only.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/could-not-open-temporary-statistics-file-pg-stat-tmp-pgstat-...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
@ 2011-06-16 06:59 Tom Lane <tgl@sss.pgh.pa.us>
parent: Simon Riggs <simon@2ndQuadrant.com>
0 siblings, 1 reply; 12+ messages in thread
From: Tom Lane @ 2011-06-16 06:59 UTC (permalink / raw)
To: Simon Riggs <simon@2ndQuadrant.com>; +Cc: bakkiya <bakkiya@gmail.com>; pgsql-admin
Simon Riggs <simon@2ndQuadrant.com> writes:
> On Thu, Jun 16, 2011 at 7:44 AM, bakkiya <bakkiya@gmail.com> wrote:
>> Space,permission are not an issue.
> Then presumably you have your stats_temp_directory parameter set to a
> path where that is not true.
But the error message is showing the specific file path that the stats
collector tried to open.
I'm wondering whether the OP is confused about which data directory
is in use. It's pretty hard to explain "No such file or directory"
by any theory other than that pg_stat_tmp isn't really there in the
server's CWD.
regards, tom lane
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
@ 2011-06-17 04:29 bakkiya <bakkiya@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 12+ messages in thread
From: bakkiya @ 2011-06-17 04:29 UTC (permalink / raw)
To: pgsql-admin
I have set stats_temp_directory to postgresql/data/pg_stat_tmp, but still
this message is coming and also created pgstat.tmp file in that location
manually, but this file is getting removed automatically in few minutes.
postgresql/data/pg_stat_tmp> touch pgstat.tmp
postgresql/data/pg_stat_tmp> ls -rtl
total 96
-rw-r--r-- 1 novell novell 0 2011-06-15 23:36 a
-rw------- 1 novell novell 92446 2011-06-16 21:23 pgstat.stat
-rw------- 1 novell novell 0 2011-06-16 21:23 pgstat.tmp
postgresql/data/pg_stat_tmp> ls -rtl
total 96
-rw-r--r-- 1 novell novell 0 2011-06-15 23:36 a
-rw------- 1 novell novell 92446 2011-06-16 21:23 pgstat.stat
-rw------- 1 novell novell 0 2011-06-16 21:23 pgstat.tmp
postgresql/data/pg_stat_tmp> ls -rtl
total 96
-rw-r--r-- 1 novell novell 0 2011-06-15 23:36 a
-rw------- 1 novell novell 92446 2011-06-16 21:23 pgstat.stat
Any idea?
Thanks.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/could-not-open-temporary-statistics-file-pg-stat-tmp-pgstat-...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 12+ messages in thread
* could not open temporary statistics file
@ 2022-05-09 22:19 Thiemo Kellner <thiemo@gelassene-pferde.biz>
0 siblings, 1 reply; 12+ messages in thread
From: Thiemo Kellner @ 2022-05-09 22:19 UTC (permalink / raw)
To: PostgreSQL Admin <pgsql-admin@lists.postgresql.org>
Hi
I am not quite sure whether I am at the right place here.
I installed PostgreSQL on a DebianEdu 11 system. First, I had only
version 14 by the "versionless" package. It ran as far as I can
remember (at least I remember creating roles and databases). Then I
decided to install 11 to 13 too to test "simultaneously" on several
versions. I did so on two systems and moved /etc/postgresql to a place
where I could put it into subversion and symlinked.
thiemo @ thiemos-toshi ~ % ll -d /etc/postg*
lrwxrwxrwx 1 root root 62 Mai 4 01:32 /etc/postgresql ->
/home/thiemo/private_documents/linux/skolelinux/etc/postgresql
thiemo @ thiemos-toshi ~ % tree
/home/thiemo/private_documents/linux/skolelinux/etc/postgresql
/home/thiemo/private_documents/linux/skolelinux/etc/postgresql
├── 11
│ ├── main
│ │ ├── conf.d
│ │ ├── environment
│ │ ├── pg_ctl.conf
│ │ ├── pg_hba.conf
│ │ ├── pg_ident.conf
│ │ ├── postgresql.conf
│ │ └── start.conf
│ └── postgresql.conf -> main/postgresql.conf
├── 12
│ ├── main
│ │ ├── conf.d
│ │ ├── environment
│ │ ├── pg_ctl.conf
│ │ ├── pg_hba.conf
│ │ ├── pg_ident.conf
│ │ ├── postgresql.conf
│ │ └── start.conf
│ └── postgresql.conf -> main/postgresql.conf
I cannot remember having changed the structure of the structure of the
config directory, so I am puzzled to find the directory "main" within.
I think it is causing troubles because before I symlinked
postgresql.conf, trying to start ended in complaints of not finding
said config file. This, I will ask Debian people.
Now, it sort of starts, but it keeps logging missing statistics file
and using stale statistics.
postgres@thiemos-toshi:~$ /usr/lib/postgresql/11/bin/postgres -p 5431
-D /etc/postgresql/11/main/
2022-05-09 23:49:38.378 CEST [45056] LOG: listening on IPv6 address
"::1", port 5431
2022-05-09 23:49:38.378 CEST [45056] LOG: listening on IPv4 address
"127.0.0.1", port 5431
2022-05-09 23:49:38.379 CEST [45056] LOG: listening on Unix socket
"/var/run/postgresql/.s.PGSQL.5431"
2022-05-09 23:49:38.398 CEST [45057] LOG: database system was shut
down at 2022-05-09 18:50:09 CEST
2022-05-09 23:49:38.409 CEST [45056] LOG: database system is ready to
accept connections
2022-05-09 23:49:38.413 CEST [45062] LOG: could not open temporary
statistics file "/var/run/postgresql/11-main.pg_stat_tmp/global.tmp":
No such file or directory
...
2022-05-09 23:51:08.782 CEST [45061] LOG: using stale statistics
instead of current ones because stats collector is not responding
I am concerned about three things.
- Performance problems because of the stale statistics being used
- Filling up log unnecessarily
- The linking of postgresql.conf will have side effects.
Actually, the first one is not that much of concern as I do not burden
load on the server, but I wonder what this is about. What do you think?
Kind regards
Thiemo
--
S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH
Signal (Safer than WhatsApp): +49 1578 7723737
Threema (Safer than WhatsApp): A76MKH3J
Handy: +49 1578 772 37 37
Attachments:
smime.p7s (application/pkcs7-signature, 3.9K) download
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: could not open temporary statistics file
@ 2022-05-10 08:30 Holger Jakobs <holger@jakobs.com>
parent: Thiemo Kellner <thiemo@gelassene-pferde.biz>
0 siblings, 1 reply; 12+ messages in thread
From: Holger Jakobs @ 2022-05-10 08:30 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Am 10.05.22 um 00:19 schrieb Thiemo Kellner:
> Hi
>
> I am not quite sure whether I am at the right place here.
>
> I installed PostgreSQL on a DebianEdu 11 system. First, I had only
> version 14 by the "versionless" package. It ran as far as I can
> remember (at least I remember creating roles and databases). Then I
> decided to install 11 to 13 too to test "simultaneously" on several
> versions. I did so on two systems and moved /etc/postgresql to a place
> where I could put it into subversion and symlinked.
>
> thiemo @ thiemos-toshi ~ % ll -d /etc/postg*
> lrwxrwxrwx 1 root root 62 Mai 4 01:32 /etc/postgresql ->
> /home/thiemo/private_documents/linux/skolelinux/etc/postgresql
>
> thiemo @ thiemos-toshi ~ % tree
> /home/thiemo/private_documents/linux/skolelinux/etc/postgresql
> /home/thiemo/private_documents/linux/skolelinux/etc/postgresql
> ├── 11
> │ ├── main
> │ │ ├── conf.d
> │ │ ├── environment
> │ │ ├── pg_ctl.conf
> │ │ ├── pg_hba.conf
> │ │ ├── pg_ident.conf
> │ │ ├── postgresql.conf
> │ │ └── start.conf
> │ └── postgresql.conf -> main/postgresql.conf
> ├── 12
> │ ├── main
> │ │ ├── conf.d
> │ │ ├── environment
> │ │ ├── pg_ctl.conf
> │ │ ├── pg_hba.conf
> │ │ ├── pg_ident.conf
> │ │ ├── postgresql.conf
> │ │ └── start.conf
> │ └── postgresql.conf -> main/postgresql.conf
>
> I cannot remember having changed the structure of the structure of the
> config directory, so I am puzzled to find the directory "main" within.
> I think it is causing troubles because before I symlinked
> postgresql.conf, trying to start ended in complaints of not finding
> said config file. This, I will ask Debian people.
>
> Now, it sort of starts, but it keeps logging missing statistics file
> and using stale statistics.
> postgres@thiemos-toshi:~$ /usr/lib/postgresql/11/bin/postgres -p 5431
> -D /etc/postgresql/11/main/
> 2022-05-09 23:49:38.378 CEST [45056] LOG: listening on IPv6 address
> "::1", port 5431
> 2022-05-09 23:49:38.378 CEST [45056] LOG: listening on IPv4 address
> "127.0.0.1", port 5431
> 2022-05-09 23:49:38.379 CEST [45056] LOG: listening on Unix socket
> "/var/run/postgresql/.s.PGSQL.5431"
> 2022-05-09 23:49:38.398 CEST [45057] LOG: database system was shut
> down at 2022-05-09 18:50:09 CEST
> 2022-05-09 23:49:38.409 CEST [45056] LOG: database system is ready to
> accept connections
> 2022-05-09 23:49:38.413 CEST [45062] LOG: could not open temporary
> statistics file "/var/run/postgresql/11-main.pg_stat_tmp/global.tmp":
> No such file or directory
> ...
> 2022-05-09 23:51:08.782 CEST [45061] LOG: using stale statistics
> instead of current ones because stats collector is not responding
>
> I am concerned about three things.
> - Performance problems because of the stale statistics being used
> - Filling up log unnecessarily
> - The linking of postgresql.conf will have side effects.
>
> Actually, the first one is not that much of concern as I do not burden
> load on the server, but I wonder what this is about. What do you think?
>
> Kind regards
>
> Thiemo
>
You could try to create the directory
/var/run/postgresql/11-main.pg_stat_tmp and change ownership to
postgres:postgres
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachments:
OpenPGP_signature (application/pgp-signature, 202B) download
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: could not open temporary statistics file
@ 2022-05-10 10:19 Thiemo Kellner <thiemo@gelassene-pferde.biz>
parent: Holger Jakobs <holger@jakobs.com>
0 siblings, 0 replies; 12+ messages in thread
From: Thiemo Kellner @ 2022-05-10 10:19 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
I did, rebooting removes it however, so it isn't even a permanent work around.
^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~2022-05-10 10:19 UTC | newest]
Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-06-16 05:28 could not open temporary statistics file "pg_stat_tmp/pgstat.tmp" bakkiya <bakkiya@gmail.com>
2011-06-16 06:23 ` Tim <elatllat@gmail.com>
2011-06-16 06:44 ` bakkiya <bakkiya@gmail.com>
2011-06-16 06:50 ` Simon Riggs <simon@2ndQuadrant.com>
2011-06-16 06:59 ` Tom Lane <tgl@sss.pgh.pa.us>
2011-06-17 04:29 ` bakkiya <bakkiya@gmail.com>
2011-06-16 06:53 ` Rafael Martinez <r.m.guerrero@usit.uio.no>
2011-06-16 06:56 ` bakkiya <bakkiya@gmail.com>
2011-06-16 06:34 ` Simon Riggs <simon@2ndQuadrant.com>
2022-05-09 22:19 could not open temporary statistics file Thiemo Kellner <thiemo@gelassene-pferde.biz>
2022-05-10 08:30 ` Re: could not open temporary statistics file Holger Jakobs <holger@jakobs.com>
2022-05-10 10:19 ` Re: could not open temporary statistics file Thiemo Kellner <thiemo@gelassene-pferde.biz>
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