Found the problem - mismatch with db versions <span></span><br><br>On Monday, September 5, 2016, <<a href="mailto:Paschedag.Netlution@swr.de">Paschedag.Netlution@swr.de</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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
<<a href="javascript:_e(%7B%7D,'cvml','konrasko@gmail.com');" target="_blank">konrasko@gmail.com</a>></font>
<br><font size="1" color="#5f5f5f" face="sans-serif">An:
</font><font size="1" face="sans-serif"><a href="javascript:_e(%7B%7D,'cvml','spacewalk-list@redhat.com');" target="_blank">spacewalk-list@redhat.com</a></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"><a href="javascript:_e(%7B%7D,'cvml','spacewalk-list-bounces@redhat.com');" target="_blank">spacewalk-list-bounces@<wbr>redhat.com</a></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.<wbr>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.<wbr>QueryExecutorImpl.<wbr>receiveErrorResponse(<wbr>QueryExecutorImpl.java:2094)</font>
<br><font size="3">at org.postgresql.core.v3.<wbr>QueryExecutorImpl.<wbr>processResults(<wbr>QueryExecutorImpl.java:1827)</font>
<br><font size="3">at org.postgresql.core.v3.<wbr>QueryExecutorImpl.execute(<wbr>QueryExecutorImpl.java:255)</font>
<br><font size="3">at org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>execute(<wbr>AbstractJdbc2Statement.java:<wbr>508)</font>
<br><font size="3">at org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>executeWithFlags(<wbr>AbstractJdbc2Statement.java:<wbr>384)</font>
<br><font size="3">at org.postgresql.jdbc2.<wbr>AbstractJdbc2Statement.<wbr>execute(<wbr>AbstractJdbc2Statement.java:<wbr>377)</font>
<br><font size="3">at com.mchange.v2.c3p0.impl.<wbr>NewProxyCallableStatement.<wbr>execute(<wbr>NewProxyCallableStatement.<wbr>java:2417)</font>
<br><font size="3">at com.redhat.rhn.common.db.<wbr>NamedPreparedStatement.<wbr>execute(<wbr>NamedPreparedStatement.java:<wbr>117)</font>
<br><font size="3">at com.redhat.rhn.common.db.<wbr>datasource.CachedStatement.<wbr>executeCallable(<wbr>CachedStatement.java:528)</font>
<br><font size="3">... 22 more</font>
<br><tt><font size="2">______________________________<wbr>_________________<br>
Spacewalk-list mailing list<br>
<a href="javascript:_e(%7B%7D,'cvml','Spacewalk-list@redhat.com');" target="_blank">Spacewalk-list@redhat.com</a><br>
</font></tt><a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank"><tt><font size="2">https://www.redhat.com/<wbr>mailman/listinfo/spacewalk-<wbr>list</font></tt></a>
<br>
<br></blockquote>