Обсуждение: could not create file "base/16384/11500": File exists

Поиск
Список
Период
Сортировка

could not create file "base/16384/11500": File exists

От
Harshitha S
Дата:
Hi,
 
We are the following msg in the postgres logs.
"could not create file "base/16384/11500": File exists"
 
Some links indicate that the issue is related to OIDs.
Please help me in understanding why the message is appearing and how the issue can be resolved.
 
Regards,
Harshitha

Re: could not create file "base/16384/11500": File exists

От
Filip Rembiałkowski
Дата:
Hello,

You gave much too little information. Please see http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

Especially:
- server version, platform
- vacuum-related settings

It *might* be OID wraparaound.



2011/10/10 Harshitha S <hershetha@gmail.com>
Hi,
 
We are the following msg in the postgres logs.
"could not create file "base/16384/11500": File exists"
 
Some links indicate that the issue is related to OIDs.
Please help me in understanding why the message is appearing and how the issue can be resolved.
 
Regards,
Harshitha

Re: could not create file "base/16384/11500": File exists

От
Harshitha S
Дата:
Hi,
 
The postgres server version is 9.0.4 on the Linux platform.
The vaccum - related settings have default values.
 
If it is OID wrap around, how to resolve it?
 
Regards,
Harshitha


 
2011/10/10 Filip Rembiałkowski <plk.zuber@gmail.com>
Hello,

You gave much too little information. Please see http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

Especially:
- server version, platform
- vacuum-related settings

It *might* be OID wraparaound.




2011/10/10 Harshitha S <hershetha@gmail.com>
Hi,
 
We are the following msg in the postgres logs.
"could not create file "base/16384/11500": File exists"
 
Some links indicate that the issue is related to OIDs.
Please help me in understanding why the message is appearing and how the issue can be resolved.
 
Regards,
Harshitha


Re: could not create file "base/16384/11500": File exists

От
Harshitha S
Дата:

Also, this is the case of first startup of the postgres server.
This msg is shown in the startup logs.
2011/10/10 Harshitha S <hershetha@gmail.com>
Hi,
 
The postgres server version is 9.0.4 on the Linux platform.
The vaccum - related settings have default values.
 
If it is OID wrap around, how to resolve it?
 
Regards,
Harshitha


 
2011/10/10 Filip Rembiałkowski <plk.zuber@gmail.com>
Hello,

You gave much too little information. Please see http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

Especially:
- server version, platform
- vacuum-related settings

It *might* be OID wraparaound.




2011/10/10 Harshitha S <hershetha@gmail.com>
Hi,
 
We are the following msg in the postgres logs.
"could not create file "base/16384/11500": File exists"
 
Some links indicate that the issue is related to OIDs.
Please help me in understanding why the message is appearing and how the issue can be resolved.
 
Regards,
Harshitha



Re: could not create file "base/16384/11500": File exists

От
Filip Rembiałkowski
Дата:

Is it fresh install of PostgreSQL server? What OS, what installer? Did you run initdb (or pg_ctl initdb), or the installer did it for you?


If you want valuable replies you will really need to describe your full story. see http://wiki.postgresql.org/wiki/Guide_to_reporting_problems



W dniu 10 października 2011 12:41 użytkownik Harshitha S <hershetha@gmail.com> napisał:

Also, this is the case of first startup of the postgres server.
This msg is shown in the startup logs.
2011/10/10 Harshitha S <hershetha@gmail.com>
Hi,
 
The postgres server version is 9.0.4 on the Linux platform.
The vaccum - related settings have default values.
 
If it is OID wrap around, how to resolve it?
 
Regards,
Harshitha


 
2011/10/10 Filip Rembiałkowski <plk.zuber@gmail.com>
Hello,

You gave much too little information. Please see http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

Especially:
- server version, platform
- vacuum-related settings

It *might* be OID wraparaound.




2011/10/10 Harshitha S <hershetha@gmail.com>
Hi,
 
We are the following msg in the postgres logs.
"could not create file "base/16384/11500": File exists"
 
Some links indicate that the issue is related to OIDs.
Please help me in understanding why the message is appearing and how the issue can be resolved.
 
Regards,
Harshitha