[postgis-users] error with global/pg_filenode.map

Mon Aug 19 06:32:10 PDT 2013

Dear List

Thank you very much for help and very useful comments, I have some problem with the Ubuntu system I am working, because it is a "live server". It is very difficult to reboot. Do you have the others ways to solve this problem.

Thank you very much 

Tung

________________________________
 From: Paragon Corporation <lr at pcorp.us>
To: 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org> 
Sent: Thursday, August 15, 2013 5:28 AM
Subject: Re: [postgis-users] error with global/pg_filenode.map

That usually denotes a locked file not closed.  Usually 
resolves if you reboot your whole server or the postgresql 
service.

We describe the issue here:
http://www.postgresonline.com/journal/archives/203-postgresql90-yum.html  
(though this article is a bit dated)

except
If you get a: 
FATAL: could not open relation mapping file 
"global/pg_filenode.map": Permission denied When you attempt to connect 
to psql. Most likely the problem is caused by a locked file from left over. You 
could go thru the effort of shutting down things looking, for what went wrong, 
but you are an Almost idiot with little patience for these things. 
just do a: 
reboot 
and all should be fine.

Leo and Regina
http://www.postgis.us
http://www.paragoncorporation.com
http://www.postgresonline.com
http://www.bostongis.com

________________________________
 From: postgis-users-bounces at lists.osgeo.org 
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Tung 
Thanh
Sent: Wednesday, August 14, 2013 3:37 PM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] error with 
global/pg_filenode.map

Dear 
List

I 
am installing software name geo-node, on the way of installation I have some 
errors with postgresql/postgis and psycopg2
I 
have also removed and re-install postgresql and python-psycopg2 many time but It 
doesn't work

the 
problem when  I installed by using command as bellow

$sydi 
add-apt-repository xxxx
$sudo 
apt-get update 
$sudo 
apt-get install geonode
and 
the errors occurred:

Traceback 
(most recent call last):

File "/var/lib/geonode/bin/django- admin.py", line 5, in <module>

  management.execute_from_ command_line()

File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ 
management/__init__.py", line 443, in execute_from_command_line

  utility.execute()

File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ 
management/__init__.py", line 382, in execute

  self.fetch_command(subcommand) .run_from_argv(self.argv)

File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ 
management/base.py", line 196, in run_from_argv

  self.execute(*args, **options.__dict__)

File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ 
management/base.py", line 232, in execute

  output = self.handle(*args, **options)

File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ 
management/base.py", line 371, in handle

  return self.handle_noargs(**options)

File "/var/lib/geonode/lib/python2. 6/site-packages/south/ 
management/commands/syncdb.py" , line 90, in handle_noargs

  syncdb.Command().execute(** options)

File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ 
management/base.py", line 232, in execute

  output = self.handle(*args, **options)

File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ 
management/base.py", line 371, in handle

  return self.handle_noargs(**options)

File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ 
management/commands/syncdb.py" , line 57, in handle_noargs

  cursor = connection.cursor()

File "/var/lib/geonode/lib/python2. 6/site-packages/django/db/ 
backends/__init__.py", line 308, in cursor

  cursor = util.CursorWrapper(self._ cursor(), self)

File "/var/lib/geonode/lib/python2. 6/site-packages/django/db/ 
backends/postgresql_psycopg2/ base.py", line 177, in _cursor

  self.connection = Database.connect(**conn_ params)

File "/usr/local/lib/python2.6/ dist-packages/psycopg2/__init_ _.py", line 179, 
in connect

  connection_factory=connection_ factory, async=async)
psycopg2.OperationalError: 
FATAL:  could not open relation mapping file "global/pg_filenode.map": No 
such file or directory
FATAL: 
 could not open relation mapping file "global/pg_filenode.map": No such 
file or directory

Traceback 
(most recent call last):

File "/var/lib/geonode/bin/django- admin.py", line 5, in <module>

  management.execute_from_ command_line()

File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ 
management/__init__.py", line 443, in execute_from_command_line

  utility.execute()

File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ 
management/__init__.py", line 382, in execute

  self.fetch_command(subcommand) .run_from_argv(self.argv)

File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ 
management/base.py", line 196, in run_from_argv

  self.execute(*args, **options.__dict__)

File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ 
management/base.py", line 232, in execute

  output = self.handle(*args, **options)

File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ 
management/commands/loaddata. py", line 71, in handle

  cursor = connection.cursor()

File "/var/lib/geonode/lib/python2. 6/site-packages/django/db/ 
backends/__init__.py", line 308, in cursor

  cursor = util.CursorWrapper(self._ cursor(), self)

File "/var/lib/geonode/lib/python2. 6/site-packages/django/db/ 
backends/postgresql_psycopg2/ base.py", line 177, in _cursor

  self.connection = Database.connect(**conn_ params)

File "/usr/local/lib/python2.6/ dist-packages/psycopg2/__init_ _.py", line 179, 
in connect

  connection_factory=connection_ factory, async=async)
psycopg2.OperationalError: 
FATAL:  could not open relation mapping file "global/pg_filenode.map": No 
such file or directory
FATAL: 
 could not open relation mapping file "global/pg_filenode.map": No such 
file or directory

/

Site 
default disabled.
To 
activate the new configuration, you need to run:

service apache2 reload
Considering 
dependency proxy for proxy_http:
Module 
proxy already enabled
Module 
proxy_http already enabled
Enabling 
site geonode.
To 
activate the new configuration, you need to run:

service apache2 reload
 * 
Restarting web server apache2               

           ... waiting         

       [ OK ]
 * 
Stopping Tomcat servlet engine tomcat6             

                  [ OK ]
 * 
Starting Tomcat servlet engine tomcat6             

                  [ OK ]
 * 
Restarting web server apache2               

           ... waiting .  

Any 
ideas to fix 

Many 
thanks

@QT

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130819/eaeb6ec4/attachment.html>