From: | basti <basti(at)unix-solution(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: could not rename temporary statistics file "/run/shm/pgstat.tmp" to "/run/shm/pgstat.stat": No such file or directory |
Date: | 2014-04-22 15:11:26 |
Message-ID: | 5356869E.3060000@unix-solution.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I use Debian 7, Postgres 9.1, Kernel 3.2.0-3-amd64
Syslog says nothing about postgres during this time.
SELinux is not installed/active.
I also found this (2 hours later) in the postgres log:
2014-04-22 11:01:42 CEST LOG: could not open temporary statistics file
"/run/shm/pgstat.tmp": Permission denied
I don't understand what's going on there:
postgres(at)srv1:/home/postgresql_data/postgresql/9.1/main/pg_log$ date &&
ls -la /run/shm/
Tue Apr 22 17:08:41 CEST 2014
total 308
drwxrwxrwt 2 root root 80 Apr 22 17:08 .
drwxr-xr-x 20 root root 660 Apr 8 11:15 ..
-rw------- 1 postgres postgres 314577 Apr 22 17:08 pgstat.stat
-rw-r--r-- 1 root root 0 Oct 19 2012 .tmpfs
postgres(at)srv1:/home/postgresql_data/postgresql/9.1/main/pg_log$ touch
/run/shm/pgstat.tmp
postgres(at)srv1:/home/postgresql_data/postgresql/9.1/main/pg_log$ date &&
ls -la /run/shm/
Tue Apr 22 17:08:55 CEST 2014
total 308
drwxrwxrwt 2 root root 100 Apr 22 17:08 .
drwxr-xr-x 20 root root 660 Apr 8 11:15 ..
-rw------- 1 postgres postgres 314577 Apr 22 17:08 pgstat.stat
-rw-r--r-- 1 postgres postgres 0 Apr 22 17:08 pgstat.tmp
-rw-r--r-- 1 root root 0 Oct 19 2012 .tmpfs
postgres(at)srv1:/home/postgresql_data/postgresql/9.1/main/pg_log$ date &&
ls -la /run/shm/
Tue Apr 22 17:09:07 CEST 2014
total 52
drwxrwxrwt 2 root root 80 Apr 22 17:09 .
drwxr-xr-x 20 root root 660 Apr 8 11:15 ..
-rw------- 1 postgres postgres 52658 Apr 22 17:09 pgstat.stat
-rw-r--r-- 1 root root 0 Oct 19 2012 .tmpfs
postgres(at)srv1:/home/postgresql_data/postgresql/9.1/main/pg_log$
Basti
On 22.04.2014 16:32, Adrian Klaver wrote:
> On 04/22/2014 07:11 AM, basti wrote:
>> When Postgres has no permission why "pgstat.stat" is created by postgres?
>> I have also try to create a file via su postgres -c "cd /run/shm/ &&
>> touch ...."
>>
>> /run# ls -la shm
>> total 52
>> drwxrwxrwt 2 root root 100 Apr 22 16:09 .
>> drwxr-xr-x 20 root root 660 Apr 8 11:15 ..
>> -rw-r--r-- 1 postgres postgres 0 Apr 22 16:09
>> file_create_as_postgres_user
>> -rw------- 1 postgres postgres 52658 Apr 22 16:09 pgstat.stat
>> -rw-r--r-- 1 root root 0 Oct 19 2012 .tmpfs
>>
>> /run# ls -rtl | grep shm
>> drwxrwxrwt 2 root root 80 Apr 22 16:02 shm
>>
>> I think these permissions are enough.
>
> What distribution are you running?
>
> Is it possible you have something like SELinux enabled that is intervening?
>
> What does the system log show when the Postgres server throws the error?
>
>
>>
>> Basti
>>
>>
>> On 22.04.2014 15:36, Adrian Klaver wrote:
>>> On 04/22/2014 02:39 AM, basti wrote:
>>>> Hello,
>>>>
>>>> since I have enabled "stats_temp_directory = '/run/shm'" in
>>>> /etc/postgresql/9.1/main/postgresql.conf I get the following error:
>>>>
>>>> 2014-04-21 02:37:29 CEST LOG: could not rename temporary statistics
>>>> file "/run/shm/pgstat.tmp" to "/run/shm/pgstat.stat": No such file or
>>>> directory
>>>>
>>>> /var/run/shm# ls -rtl
>>>> -rw------- 1 postgres postgres 312211 Apr 22 11:31 pgstat.stat
>>>>
>>>> There is no "/run/shm/pgstat.tmp" file but if I create it and change
>>>> the
>>>> owner to postgres the file will be removed few minutes later.
>>>>
>>>> How can explain and how can I solve this "error"?
>>>
>>> Postgres does not have permissions on the directory. Give Postgres
>>> permissions on the directory.
>>>
>>>>
>>>> Regards,
>>>> Basti
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | basti | 2014-04-22 15:13:12 | Re: could not rename temporary statistics file "/run/shm/pgstat.tmp" to "/run/shm/pgstat.stat": No such file or directory |
Previous Message | Torsten Förtsch | 2014-04-22 15:03:46 | Re: Is this a planner bug? |