librelist archives

Re: [geonode] Server Internal error

From:

Noha Khalifa

Date:

2012-03-13 @ 22:30

*Dear David & Ariel,*
*
*
*Thanks for your reply. David the server is still for our internal use and
we are a team of three, but I will try to alter the limit of the Postgres
and thanks for letting me know that the Geonode test commend is not safe to
use. *
*
*
*Ariel, we are using Ubuntu 11.04 and we did an update for Ubuntu as it was
mentioned in the Documentation, an Ubuntu update would update to 1.1.
 However, is there a commend where we can use to check the version of the
Geonode, to check whether it was updated successfully to 1.1?
*
*
*
*Thanks for your help!*
*Noha*


On 13 March 2012 16:51, Ariel Nunez <ingenieroariel@gmail.com> wrote:

> Adding to David's response, this sounds similar to the bug related to
> upload that affected earlier versions of GeoNode.
>
> Noha, are you running 1.1?
>
> Sent from my iPhone
>
> On Mar 13, 2012, at 10:09 AM, David Winslow <dwinslow@opengeo.org> wrote:
>
> The "geonode test" command is really intended for verifying the software
> itself rather than individual deployments.  I'm not sure it's even safe to
> run against a "real" database without looking into it more deeply (it may
> leave changes after the tests finish running).
>
> Anyway, the error you're getting:
>
> psycopg2.OperationalError: FATAL:  sorry, too many clients already
>
>
> Indicates that your Postgres database server is refusing connections
> because it has a limit set on how many clients may connect at a time.  You
> can try to look at postgres logs to track down what clients are active and
> try to shut some down, or you can go into the postgresql config file
> (postgresql.conf, its location varies for different systems) and change the
> connection_limit setting to a higher value.  You'll have to restart
> postgresql for this change to take effect.
>
> --
> David Winslow
> OpenGeo - http://opengeo.org/
>
> On Tue, Mar 13, 2012 at 4:48 AM, Noha Khalifa <nohakhalifa7@gmail.com>wrote:
>
>> Hi All,
>>
>> we are facing a problem with the Geonode Server, while we were uploading
>> the data, so we had to restart the server several times but we still have
>> the error "Internal Server Error", We tried the test commend and here is
>> the result:
>>
>> rcdrr@rcdrr-Geo:~$ sudo geonode test
>> [sudo] password for rcdrr:
>> nosetests --verbosity 1 --verbosity=2 --cover-erase --nocapture
>> --with-coverage --cover-package=geonode --cover-inclusive --cover-tests
>> --detailed-errors --with-xunit
>> Creating test database 'default'...
>> 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/local/lib/python2.7/site-packages/
>> django/core/management/__init__.py", line 429, in
>> execute_from_command_line
>>     utility.execute()
>>   File "/var/lib/geonode/local/lib/python2.7/site-packages/
>> django/core/management/__init__.py", line 379, in execute
>>     self.fetch_command(subcommand).run_from_argv(self.argv)
>>   File "/var/lib/geonode/local/lib/python2.7/site-packages/
>> django/core/management/base.py", line 191, in run_from_argv
>>     self.execute(*args, **options.__dict__)
>>   File "/var/lib/geonode/local/lib/python2.7/site-packages/
>> django/core/management/base.py", line 218, in execute
>>     output = self.handle(*args, **options)
>>   File "/var/lib/geonode/local/lib/python2.7/site-packages/
>> django/core/management/commands/test.py", line 37, in handle
>>     failures = test_runner.run_tests(test_labels)
>>   File 
"/var/lib/geonode/local/lib/python2.7/site-packages/django_nose/runner.py",
>> line 85, in run_tests
>>     result = self.run_suite(nose_argv)
>>   File 
"/var/lib/geonode/local/lib/python2.7/site-packages/django_nose/runner.py",
>> line 49, in run_suite
>>     addplugins=plugins_to_add)
>>   File "/var/lib/geonode/local/lib/python2.7/site-packages/nose/core.py",
>> line 118, in __init__
>>     **extra_args)
>>   File "/usr/lib/python2.7/unittest/main.py", line 94, in __init__
>>     self.parseArgs(argv)
>>   File "/var/lib/geonode/local/lib/python2.7/site-packages/nose/core.py",
>> line 135, in parseArgs
>>     self.config.configure(argv, doc=self.usage())
>>   File "/var/lib/geonode/local/lib/python2.7/site-packages/nose/config.py",
>> line 339, in configure
>>     self.plugins.begin()
>>   File 
"/var/lib/geonode/local/lib/python2.7/site-packages/nose/plugins/manager.py",
>> line 94, in __call__
>>     return self.call(*arg, **kw)
>>   File 
"/var/lib/geonode/local/lib/python2.7/site-packages/nose/plugins/manager.py",
>> line 162, in simple
>>     result = meth(*arg, **kw)
>>   File 
"/var/lib/geonode/local/lib/python2.7/site-packages/django_nose/plugin.py",
>> line 39, in begin
>>     self.old_names = self.runner.setup_databases()
>>   File 
"/var/lib/geonode/local/lib/python2.7/site-packages/django/test/simple.py",
>> line 270, in setup_databases
>>     connection.creation.create_test_db(self.verbosity, autoclobber=not
>> self.interactive)
>>   File "/var/lib/geonode/local/lib/python2.7/site-packages/
>> django/db/backends/creation.py", line 346, in create_test_db
>>     test_database_name = self._create_test_db(verbosity, autoclobber)
>>   File "/var/lib/geonode/local/lib/python2.7/site-packages/
>> django/db/backends/creation.py", line 380, in _create_test_db
>>     cursor = self.connection.cursor()
>>   File "/var/lib/geonode/local/lib/python2.7/site-packages/
>> django/db/backends/__init__.py", line 75, in cursor
>>     cursor = self._cursor()
>>   File "/var/lib/geonode/local/lib/python2.7/site-packages/
>> django/db/backends/postgresql_psycopg2/base.py", line 136, in _cursor
>>     self.connection = Database.connect(**conn_params)
>> psycopg2.OperationalError: FATAL:  sorry, too many clients already
>>
>> Can someone please help!
>> --
>>
>>
>> 
-----------------------------------------------------------------------------------------------------------------------------------------
>> *Eng.Noha Khalifa, MSc*
>>
>> GIS Programme Officer - Education & Training Programme Officer
>>
>> Regional Centre for Disaster Risk Reduction (RCDRR)
>> Cell : +2 0110022265                                     Telefax : +2 02
>> 22675006
>>
>> E-Mail : Nohakhalifa7@gmail.com  / N.Khalifa@rcdrr.org
>>
>> Address: The Arab Academy for Science, Technology & Maritime Transport,
>> Postgraduate Studies Complex, (Fourth Floor),
>> Block 1167, off El-Moshir Ahmed Ismail St., Masaken Sheraton, Cairo,
>> Egypt, P.O. Box 2033 – El-Horria.
>>
>> 
---------------------------------------------------------------------------------------------------------------------------------------
>>
>>
>>
>>
>>
>>
>


-- 


-----------------------------------------------------------------------------------------------------------------------------------------
*Eng.Noha Khalifa, MSc*

GIS Programme Officer - Education & Training Programme Officer

Regional Centre for Disaster Risk Reduction (RCDRR)
Cell : +2 0110022265                                     Telefax : +2 02
22675006

E-Mail : Nohakhalifa7@gmail.com  / N.Khalifa@rcdrr.org

Address: The Arab Academy for Science, Technology & Maritime Transport,
Postgraduate Studies Complex, (Fourth Floor),
Block 1167, off El-Moshir Ahmed Ismail St., Masaken Sheraton, Cairo, Egypt,
P.O. Box 2033 – El-Horria.

---------------------------------------------------------------------------------------------------------------------------------------