[Spacewalk-list] rhn-search cleanindex error on spacewalk 1.1

[Benedetto Vassallo]

Hi again,
When I issue the command /etc/init.d/rhn-search cleanindex I have the
following error:

[root at spacewalk ~]# /etc/init.d/rhn-search cleanindex
Stopping rhn-search...
rhn-search was not running.
2010-09-02 16:35:47,393 [main] ERROR
com.redhat.satellite.search.DeleteIndexes - Caught Exception:
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/redhat/satellite/search/db/errata.xml.
--- The error occurred while executing mapped statement.
--- Check the deleteLastErrata.
--- Check the statement or the result map.
--- Cause: java.sql.SQLException: Eccezione IO: The Network Adapter could
not establish the connection
        at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
        at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:505)
        at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.delete(SqlMapExecutorDelegate.java:528)
        at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.delete(SqlMapSessionImpl.java:98)
        at
com.redhat.satellite.search.db.WriteQuery.delete(WriteQuery.java:72)
        at
com.redhat.satellite.search.DeleteIndexes.deleteQuery(DeleteIndexes.java:87)
        at
com.redhat.satellite.search.DeleteIndexes.main(DeleteIndexes.java:118)
Caused by: java.sql.SQLException: Eccezione IO: The Network Adapter could
not establish the connection
        at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
        at
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
        at
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
        at java.sql.DriverManager.getConnection(DriverManager.java:620)
        at java.sql.DriverManager.getConnection(DriverManager.java:200)
        at
com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:580)
        at
com.ibatis.common.jdbc.SimpleDataSource.getConnection(SimpleDataSource.java:222)
        at
com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48)
        at
com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89)
        at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)
        ... 6 more
2010-09-02 16:35:47,397 [main] ERROR
com.redhat.satellite.search.DeleteIndexes - Unable to establish database
connection.
2010-09-02 16:35:47,397 [main] ERROR
com.redhat.satellite.search.DeleteIndexes - Ensure database is available and
connection details are correct, then retry

The database is available and running in a separate server.

I have made the following modify in
/usr/share/rhn/search/classes/com/redhat/satellite/search/db/config.xml as
suggested in this list:

-- <property name="JDBC.ConnectionURL"
value="${search.connection.driver_proto}:@${db_name}"/>
++ <property name="JDBC.ConnectionURL"
value="${search.connection.driver_proto}:@oracle-server.unipa.it:1521
:SPACEWALK"/>

Any idea?

Thank you.
-- 
--
Benedetto Vassallo
Sistema Informativo di Ateneo
Settore Gestione Reti Hardware e Software
U.O.B. Sviluppo e manutenzione dei sistemi
Università degli Studi di Palermo

Red Hat Certified Engineer
Certificate Number: 804007793324656

Phone.: +3909123860056
Fax: +390916529124
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100902/a312da2f/attachment.htm>