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