Re: could not rename temporary statistics file "/run/shm/pgstat.tmp" to "/run/shm/pgstat.stat": No such file or directory

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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>