satellite-sync throws the error ORA-03114: not connected to ORACLE
Issue
- When running
satellite-syncit 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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
