<div dir="ltr">Christian, did you get any errors while loading the database?.<div><br></div><div>A dump and reload of it should be a smooth operation.</div><div><br></div><div>The stacktrace doesn't tell that much...</div></div><div class="gmail_extra"><br><div class="gmail_quote">2015-07-14 10:54 GMT+02:00 Christian Willmes <span dir="ltr"><<a href="mailto:christian.willmes@googlemail.com" target="_blank">christian.willmes@googlemail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Hi,<br>
<br>
I have the following issues with geonode since the update and fixing
the DB, as discussed in this thread.<br>
<br>
1. The keyword handling is somehow messed up. GeoNode only shows one
Keyword, there are at least10 different assigned to the various
layers.<br>
<br>
2. After a "geonode updatelayers", layers that were deleted through
the frontend reappear in the GeoNode catalog.<br>
<br>
3. On each request I get the following error in apache error.log:<br>
<br>
[Tue Jul 14 03:03:06.744495 2015] [:error] [pid 23485:tid
140415573407488] Internal Server Error: /api/keywords/17/<br>
[Tue Jul 14 03:03:06.744523 2015] [:error] [pid 23485:tid
140415573407488] Traceback (most recent call last):<br>
[Tue Jul 14 03:03:06.744530 2015] [:error] [pid 23485:tid
140415573407488] File
"/usr/lib/python2.7/dist-packages/tastypie/resources.py", line 217,
in wrapper<br>
[Tue Jul 14 03:03:06.744536 2015] [:error] [pid 23485:tid
140415573407488] response = callback(request, *args, **kwargs)<br>
[...]<br>
[Tue Jul 14 03:03:06.755778 2015] [:error] [pid 23485:tid
140415573407488] KeyError: 'objects'<br>
[Tue Jul 14 03:03:06.772377 2015] [:error] [pid 23485:tid
140415573407488] [remote <a href="http://134.95.19.174:59667" target="_blank">134.95.19.174:59667</a>] mod_wsgi (pid=23485):
Exception occurred processing WSGI script
'/var/www/geonode/wsgi/geonode.wsgi'.<br>
[Tue Jul 14 03:03:06.772430 2015] [:error] [pid 23485:tid
140415573407488] [remote <a href="http://134.95.19.174:59667" target="_blank">134.95.19.174:59667</a>] Traceback (most recent
call last):<br>
[...]<br>
[Tue Jul 14 03:03:06.773172 2015] [:error] [pid 23485:tid
140415573407488] [remote <a href="http://134.95.19.174:59667" target="_blank">134.95.19.174:59667</a>] File
"/usr/lib/python2.7/dist-packages/django/template/context.py", line
56, in __getitem__<br>
[Tue Jul 14 03:03:06.773196 2015] [:error] [pid 23485:tid
140415573407488] [remote <a href="http://134.95.19.174:59667" target="_blank">134.95.19.174:59667</a>] raise
KeyError(key)<br>
[Tue Jul 14 03:03:06.773219 2015] [:error] [pid 23485:tid
140415573407488] [remote <a href="http://134.95.19.174:59667" target="_blank">134.95.19.174:59667</a>] KeyError: 'request'<br>
<br>
Is there anything I can do to rescue the instance, I really don't
want to wipe and reinstall including styling the layers etc... :/<br>
<br>
Thanks and regards,<br>
Christian<br>
<br>
<br>
<br>
<div>Am 10.07.2015 um 11:17 schrieb Simone
Dalmasso:<br>
</div>
<blockquote type="cite">
<div dir="ltr">hm clearly something went wrong with the restore
then. I would suggest you to try to reload back the db.
Everything should be preserver and especially geoserver should
not have changed at all since you never touched it's data
folder.</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2015-07-10 11:05 GMT+02:00 Christian
Willmes <span dir="ltr"><<a href="mailto:christian.willmes@googlemail.com" target="_blank">christian.willmes@googlemail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Hi,<br>
wow cool, thats an easy fix. I can edit the metadata
again. I was worried, the whole DB (user rights etc.)
would be messed up. <br>
<br>
The metadata not stored also in Geoserver, such as the
keywords and categories are missing. Also the spatial
region is not there. But the descriptions/abstracts and
titles are still there.<br>
<br>
regards,<br>
Christian <br>
<div>
<div> <br>
<div>Am 09.07.2015 um 18:11 schrieb Simone Dalmasso:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hi your error is:
<div><span style="font-size:12.8000001907349px">Permission
denied: u'/var/www/geonode/uploaded/</span></div>
<div><span style="font-size:12.8000001907349px">so
a:</span></div>
<div><span style="font-size:12.8000001907349px">$
sudo chmod -R a+w /var/www/geonode/uploaded</span></div>
<div><span style="font-size:12.8000001907349px">should
fix.</span></div>
<div><span style="font-size:12.8000001907349px"><br>
</span></div>
<div><span style="font-size:12.8000001907349px">For
the metadata and categories, they shouldn't be
gone at all.</span></div>
<div><span style="font-size:12.8000001907349px">Not
sure what went wrong there.</span></div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2015-07-09 16:56
GMT+02:00 Christian Willmes <span dir="ltr"><<a href="mailto:christian.willmes@googlemail.com" target="_blank">christian.willmes@googlemail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Hi,<br>
<br>
first it seemed to work fine, all layers are
back and accessible, but I cant edit the
metadata of existing layers vie the geonode
webapp anymore.<br>
The frontend dies and gives an "Internal
Server Error".<br>
<br>
The apache error messages look like:<br>
[Thu Jul 09 09:50:53.648422 2015] [:error]
[pid 2080:tid 140415632357120] Internal
Server Error:
/layers/geonode:sealevels_10_150m/metadata<br>
[Thu Jul 09 09:50:53.648484 2015] [:error]
[pid 2080:tid 140415632357120] Traceback
(most recent call last):<br>
[...]<br>
[Thu Jul 09 09:50:53.648652 2015] [:error]
[pid 2080:tid 140415632357120] IOError:
[Errno 13] Permission denied:
u'/var/www/geonode/uploaded/thumbs/layer-d680d189-b46f-468e-8267-e8e5b497988c-thumb.png'<br>
[Thu Jul 09 09:50:53.664269 2015] [:error]
[pid 2080:tid 140415632357120] [remote <a href="http://134.95.150.136:14361" target="_blank">134.95.150.136:14361</a>]
mod_wsgi (pid=2080): Exception occurred
processing WSGI script
'/var/www/geonode/wsgi/geonode.wsgi'.<br>
[...]<br>
[Thu Jul 09 09:50:53.665753 2015] [:error]
[pid 2080:tid 140415632357120] [remote <a href="http://134.95.150.136:14361" target="_blank">134.95.150.136:14361</a>]
File
"/usr/lib/python2.7/dist-packages/django/template/context.py",
line 56, in __getitem__<br>
[Thu Jul 09 09:50:53.665849 2015] [:error]
[pid 2080:tid 140415632357120] [remote <a href="http://134.95.150.136:14361" target="_blank">134.95.150.136:14361</a>]
raise KeyError(key)<br>
[Thu Jul 09 09:50:53.665872 2015] [:error]
[pid 2080:tid 140415632357120] [remote <a href="http://134.95.150.136:14361" target="_blank">134.95.150.136:14361</a>]
KeyError: 'request'<br>
<br>
<br>
It is the same account name for the
superuser.<br>
<br>
Additionally all the Categories and Keywords
are gone... (that's why I wanted to edit the
metadata in the first place...)<br>
<br>
Any hint on how I can fix this?<br>
<br>
Thanks and regards,<br>
Christian<br>
<br>
<br>
<div>Am 07.07.2015 um 15:49 schrieb Simone
Dalmasso:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Christian, in your case the
backup preserver the old schema.
Although since the difference in the new
schema is a single column being added,
you can use the "geonode
syncdb --no-initial-data" before
loading back the backup. The syncdb will
create the new schema and the backup
should load leaving the new column
blank. The --no-initial-data will make
sure that syncdb only creates the schema
without loading any fixture.
<div><br>
</div>
<div>Hope this helps.</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2015-07-07
14:48 GMT+02:00 Christian Willmes <span dir="ltr"><<a href="mailto:christian.willmes@googlemail.com" target="_blank">christian.willmes@googlemail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
following up on this thread: <a href="https://github.com/GeoNode/geonode/issues/2046" rel="noreferrer" target="_blank">https://github.com/GeoNode/geonode/issues/2046</a><br>
<br>
I did the sugested steps, but the
upload problem persits. No wonder,
because in which step should the
'layers_uploadsession' session be
created?<br>
<br>
The erreor inthe apache log looks
like:<br>
[Tue Jul 07 07:39:11.377817 2015]
[:error] [pid 22673:tid
139958275774208] column "context" of
relation "layers_uploadsession" does
not exist<br>
[Tue Jul 07 07:39:11.377877 2015]
[:error] [pid 22673:tid
139958275774208] LINE 1: ...e",
"user_id", "processed", "error",
"traceback", "context")...<br>
[Tue Jul 07 07:39:11.377884 2015]
[:error] [pid 22673:tid
139958275774208] ^<br>
[Tue Jul 07 07:39:11.377898 2015]
[:error] [pid 22673:tid
139958275774208] Traceback (most
recent call last):<br>
[Tue Jul 07 07:39:11.377904 2015]
[:error] [pid 22673:tid
139958275774208] File
"/usr/local/lib/python2.7/dist-packages/geonode/layers/views.py"<br>
[....]<br>
<br>
<br>
I did exactly the following (from <a href="http://docs.geonode.org/en/master/tutorials/admin/backup/index.html" rel="noreferrer" target="_blank">http://docs.geonode.org/en/master/tutorials/admin/backup/index.html</a>):<br>
<br>
sudo -u postgres -i pg_dump -c -Fc
geonode > geonodedb.backup<br>
<br>
<br>
sudo service apache2 stop<br>
sudo /etc/init.d/tomcat7 stop<br>
<br>
sudo service postgresql start<br>
sudo -u postgres -i "psql -c 'drop
database geonode;'"<br>
sudo -u postgres -i "psql -c 'create
database geonode;'"<br>
sudo -u postgres -s "pg_restore -Fc
-d geonode
/path/to/geonodedb.backup"<br>
<br>
sudo service apache2 start<br>
sudo /etc/init.d/tomcat7 start<br>
<br>
----<br>
<br>
How can I solve this problem?<br>
<br>
Best regards,<br>
Christian<br>
<br>
_______________________________________________<br>
geonode-users mailing list<br>
<a href="mailto:geonode-users@lists.osgeo.org" target="_blank">geonode-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/geonode-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/geonode-users</a><br>
</blockquote>
</div>
<br>
<br clear="all">
<span><font color="#888888">
<div><br>
</div>
-- <br>
<div>Simone </div>
</font></span></div>
</blockquote>
<br>
</div>
</blockquote>
</div>
<br>
<br clear="all"><span class="HOEnZb"><font color="#888888">
<div><br>
</div>
-- <br>
<div>Simone </div>
</font></span></div><span class="HOEnZb"><font color="#888888">
</font></span></blockquote><span class="HOEnZb"><font color="#888888">
<br>
</font></span></div><span class="HOEnZb"><font color="#888888">
</font></span></div><span class="HOEnZb"><font color="#888888">
</font></span></div><span class="HOEnZb"><font color="#888888">
</font></span></blockquote><span class="HOEnZb"><font color="#888888">
</font></span></div><span class="HOEnZb"><font color="#888888">
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div>Simone </div>
</font></span></div>
</blockquote>
<br>
</div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">Simone </div>
</div>