<font size=2 face="sans-serif">Hmm...looks like the DB backup is corrupt
or something's wrong with the schema (my opinion)</font>
<br>
<br><font size=2 face="sans-serif">Maybe you can try a spacewalk-schema-upgrade?
This possibly fixes your problem.</font>
<br>
<br><font size=2 face="sans-serif">Regards,</font>
<br><font size=2 face="sans-serif">Robert</font>
<br>
<br>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">Von:
</font><font size=1 face="sans-serif">Konstantin Raskoshnyi
<konrasko@gmail.com></font>
<br><font size=1 color=#5f5f5f face="sans-serif">An:
</font><font size=1 face="sans-serif">spacewalk-list@redhat.com</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Datum:
</font><font size=1 face="sans-serif">03.09.2016 00:56</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Betreff:
</font><font size=1 face="sans-serif">[Spacewalk-list]
Moving spacewalk to new physical server</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Gesendet von:
</font><font size=1 face="sans-serif">spacewalk-list-bounces@redhat.com</font>
<br>
<hr noshade>
<br>
<br>
<br><font size=3>Hi fellows,</font>
<br>
<br><font size=3>I backed up all the stuff, including db, restored db &
copied all the stuff on a new server, but login shows error 500, tomcat
logs:</font>
<br>
<br><font size=3>Caused by: org.postgresql.util.PSQLException: ERROR: function
logging.clear_log_id() does not exist</font>
<br><font size=3> Hint: No function matches the given name and argument
types. You might need to add explicit type casts.</font>
<br><font size=3> Position: 15</font>
<br><font size=3>at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2094)</font>
<br><font size=3>at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1827)</font>
<br><font size=3>at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)</font>
<br><font size=3>at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)</font>
<br><font size=3>at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)</font>
<br><font size=3>at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:377)</font>
<br><font size=3>at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2417)</font>
<br><font size=3>at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:117)</font>
<br><font size=3>at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:528)</font>
<br><font size=3>... 22 more</font>
<br><tt><font size=2>_______________________________________________<br>
Spacewalk-list mailing list<br>
Spacewalk-list@redhat.com<br>
</font></tt><a href="https://www.redhat.com/mailman/listinfo/spacewalk-list"><tt><font size=2>https://www.redhat.com/mailman/listinfo/spacewalk-list</font></tt></a>
<br>
<br>