[Spacewalk-list] Antwort: Moving spacewalk to new physical server

[Paschedag.Netlution at swr.de]

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



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
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/b57483bf/attachment.htm>