[Spacewalk-list] Moving spacewalk to new physical server

[Konstantin Raskoshnyi]

Found the problem - mismatch with db versions

On Monday, September 5, 2016, <Paschedag.Netlution at swr.de> wrote:

> Hmm...looks like the DB backup is corrupt or something's wrong with the
> schema (my opinion)
>
> Maybe you can try a spacewalk-schema-upgrade? This possibly fixes your
> problem.
>
> Regards,
> Robert
>
>
>
>
>
> Von:        Konstantin Raskoshnyi <konrasko at gmail.com
> <javascript:_e(%7B%7D,'cvml','konrasko at gmail.com');>>
> An:        spacewalk-list at redhat.com
> <javascript:_e(%7B%7D,'cvml','spacewalk-list at redhat.com');>
> Datum:        03.09.2016 00:56
> Betreff:        [Spacewalk-list] Moving spacewalk to new physical server
> Gesendet von:        spacewalk-list-bounces at redhat.com
> <javascript:_e(%7B%7D,'cvml','spacewalk-list-bounces at redhat.com');>
> ------------------------------
>
>
>
> Hi fellows,
>
> 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:
>
> Caused by: org.postgresql.util.PSQLException: ERROR: function
> logging.clear_log_id() does not exist
>   Hint: No function matches the given name and argument types. You might
> need to add explicit type casts.
>   Position: 15
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
> QueryExecutorImpl.java:2094)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(
> QueryExecutorImpl.java:1827)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(
> QueryExecutorImpl.java:255)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(
> AbstractJdbc2Statement.java:508)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
> AbstractJdbc2Statement.java:384)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(
> AbstractJdbc2Statement.java:377)
> at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(
> NewProxyCallableStatement.java:2417)
> at com.redhat.rhn.common.db.NamedPreparedStatement.execute(
> NamedPreparedStatement.java:117)
> at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(
> CachedStatement.java:528)
> ... 22 more
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> <javascript:_e(%7B%7D,'cvml','Spacewalk-list at redhat.com');>
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20160905/940166a9/attachment.htm>