satellite-sync throws the error ORA-03114: not connected to ORACLE
Issue
- When running
satellite-sync
it throws the errorORA-03114: not connected to ORACLE
Exception Handler Information
Traceback (most recent call last):
File "/usr/bin/satellite-sync", line 139, in main
return satsync.Runner().main()
File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 229, in main
ret = method()
File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 343, in _step_packages
self._affected_channels = self.syncer.import_packages()
File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 1602, in import_packages
[sources])
File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 1576, in _proces_batch
prompt, nevermorethan, process_function_args)
File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 1556, in _processWithProgressBar
process_function(chunk, *process_function_args)
File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 1583, in _import_packages_process
sync_handlers.import_packages(batch, sources)
File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/sync_handlers.py", line 385, in import_packages
importer.run()
File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/importLib.py", line 646, in run
self.fix()
File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/packageImport.py", line 292, in fix
self.backend.rollback()
File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backend.py", line 1473, in rollback
self.dbmodule.rollback()
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 186, in rollback
return db.rollback(name)
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 507, in rollback
return self.dbh.rollback()
OperationalError: ORA-03114: not connected to ORACLE
- Client systems registered to satellite are not getting latest updates.
From taskomatic logs we can see below error :
INFO | jvm 1 | 2017/04/23 22:21:32 | Caused by:
INFO | jvm 1 | 2017/04/23 22:21:32 | java.lang.reflect.InvocationTargetException
INFO | jvm 1 | 2017/04/23 22:21:32 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO | jvm 1 | 2017/04/23 22:21:32 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
INFO | jvm 1 | 2017/04/23 22:21:32 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
INFO | jvm 1 | 2017/04/23 22:21:32 | at java.lang.reflect.Method.invoke(Method.java:620)
INFO | jvm 1 | 2017/04/23 22:21:32 | at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.invoke(AttributeRestoringConnectionInvocationHandler.java:71)
INFO | jvm 1 | 2017/04/23 22:21:32 | ... 7 more
INFO | jvm 1 | 2017/04/23 22:21:32 | Caused by:
INFO | jvm 1 | 2017/04/23 22:21:32 | java.sql.SQLException: ORA-03114: not connected to ORACLE
INFO | jvm 1 | 2017/04/23 22:21:32 |
INFO | jvm 1 | 2017/04/23 22:21:32 | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
INFO | jvm 1 | 2017/04/23 22:21:32 | at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676)
INFO | jvm 1 | 2017/04/23 22:21:32 | at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602)
INFO | jvm 1 | 2017/04/23 22:21:32 | at oracle.jdbc.driver.T2CConnection.doRollback(T2CConnection.java:489)
INFO | jvm 1 | 2017/04/23 22:21:32 | at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1189)
INFO | jvm 1 | 2017/04/23 22:21:32 | at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:273)
INFO | jvm 1 | 2017/04/23 22:21:32 | at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288)
Environment
- Red Hat Satellite 5.6
- Red Hat Satellite 5.7
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.