[Spacewalk-list] Errata sync fails as fields are to small

Tue Jun 19 17:00:30 UTC 2012

Hi all,

when trying to add the errata RHSA-2012-0743 
(https://rhn.redhat.com/errata/RHSA-2012-0743.html) to my SW 1.7 
installation using centos-errata.py it fails with an internal error.

To cut a long story short, it fails as the description of this errata is 
larger than 4000 chars and the db field is limited to 4000. Is there any 
special need or technical background why this field is limited to 
4000chars? Wouldn't it make sense to use an dynamic sized text column 
instead?

Stacktrace from tomcat:

2012-06-19 18:27:53,834 [ajp-0%3A0%3A0%3A0%3A0%3A0%3A0%3A1-8009-5] ERROR 
com.redhat.rhn.frontend.xmlrpc.BaseHandler - Error calling method:
java.lang.reflect.InvocationTargetException
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
         at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         at java.lang.reflect.Method.invoke(Method.java:616)
         at 
com.redhat.rhn.frontend.xmlrpc.BaseHandler.invoke(BaseHandler.java:108)
         at 
redstone.xmlrpc.XmlRpcDispatcher.dispatch(XmlRpcDispatcher.java:123)
         at 
com.redhat.rhn.frontend.xmlrpc.RhnXmlRpcServer.execute(RhnXmlRpcServer.java:54)
         at 
com.redhat.rhn.frontend.xmlrpc.XmlRpcServlet.doPost(XmlRpcServlet.java:162)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)
         at 
com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
         at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
         at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
         at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
         at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
         at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
         at 
org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:429)
         at 
org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384)
         at 
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1556)
         at java.lang.Thread.run(Thread.java:679)
Caused by: com.redhat.rhn.FaultException: The errata CESA-2012:0743 
cannot be found.
         at 
com.redhat.rhn.frontend.xmlrpc.errata.ErrataHandler.lookupErrata(ErrataHandler.java:840)
         at 
com.redhat.rhn.frontend.xmlrpc.errata.ErrataHandler.getDetails(ErrataHandler.java:221)
         ... 38 more
2012-06-19 18:27:53,835 [ajp-0%3A0%3A0%3A0%3A0%3A0%3A0%3A1-8009-5] ERROR 
com.redhat.rhn.frontend.xmlrpc.BaseHandler - Caused by:
com.redhat.rhn.FaultException: The errata CESA-2012:0743 cannot be found.
         at 
com.redhat.rhn.frontend.xmlrpc.errata.ErrataHandler.lookupErrata(ErrataHandler.java:840)
         at 
com.redhat.rhn.frontend.xmlrpc.errata.ErrataHandler.getDetails(ErrataHandler.java:221)
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
         at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         at java.lang.reflect.Method.invoke(Method.java:616)
         at 
com.redhat.rhn.frontend.xmlrpc.BaseHandler.invoke(BaseHandler.java:108)
         at 
redstone.xmlrpc.XmlRpcDispatcher.dispatch(XmlRpcDispatcher.java:123)
         at 
com.redhat.rhn.frontend.xmlrpc.RhnXmlRpcServer.execute(RhnXmlRpcServer.java:54)
         at 
com.redhat.rhn.frontend.xmlrpc.XmlRpcServlet.doPost(XmlRpcServlet.java:162)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)
         at 
com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
         at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
         at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
         at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
         at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
         at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
         at 
org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:429)
         at 
org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384)
         at 
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1556)
         at java.lang.Thread.run(Thread.java:679)
Jun 19, 2012 6:27:53 PM redstone.xmlrpc.XmlRpcDispatcher writeError
WARNING: redstone.xmlrpc.XmlRpcFault: The errata CESA-2012:0743 cannot 
be found.
2012-06-19 18:27:54,702 [ajp-0%3A0%3A0%3A0%3A0%3A0%3A0%3A1-8009-5] WARN 
  com.redhat.rhn.common.hibernate.EmptyVarcharInterceptor - Object 
com.redhat.rhn.domain.errata.impl.UnpublishedErrata is setting empty 
string refersTo
2012-06-19 18:27:54,732 [ajp-0%3A0%3A0%3A0%3A0%3A0%3A0%3A1-8009-5] WARN 
  org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 22001
2012-06-19 18:27:54,732 [ajp-0%3A0%3A0%3A0%3A0%3A0%3A0%3A1-8009-5] ERROR 
org.hibernate.util.JDBCExceptionReporter - ERROR: value too long for 
type character varying(4000)
2012-06-19 18:27:54,733 [ajp-0%3A0%3A0%3A0%3A0%3A0%3A0%3A1-8009-5] ERROR 
org.hibernate.event.def.AbstractFlushingEventListener - Could not 
synchronize database state with session
org.hibernate.exception.DataException: could not insert: 
[com.redhat.rhn.domain.errata.impl.UnpublishedErrata]
         at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
         at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
         at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
         at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
         at 
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
         at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
         at 
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
         at 
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
         at 
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
         at 
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
         at 
com.redhat.rhn.common.db.datasource.CachedStatement.stealConnection(CachedStatement.java:855)
         at 
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:440)
         at 
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:430)
         at 
com.redhat.rhn.common.db.datasource.CachedStatement.executeUpdate(CachedStatement.java:270)
         at 
com.redhat.rhn.common.db.datasource.WriteMode.executeUpdate(WriteMode.java:33)
         at 
com.redhat.rhn.manager.errata.ErrataManager.clearErrataChannelNotifications(ErrataManager.java:1266)
         at 
com.redhat.rhn.domain.errata.AbstractErrata.addChannelNotification(AbstractErrata.java:614)
         at 
com.redhat.rhn.domain.errata.ErrataFactory.publishToChannel(ErrataFactory.java:255)
         at 
com.redhat.rhn.frontend.xmlrpc.errata.ErrataHandler.publish(ErrataHandler.java:1328)
         at 
com.redhat.rhn.frontend.xmlrpc.errata.ErrataHandler.create(ErrataHandler.java:1177)
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
         at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         at java.lang.reflect.Method.invoke(Method.java:616)
         at 
com.redhat.rhn.frontend.xmlrpc.BaseHandler.invoke(BaseHandler.java:108)
         at 
redstone.xmlrpc.XmlRpcDispatcher.dispatch(XmlRpcDispatcher.java:123)
         at 
com.redhat.rhn.frontend.xmlrpc.RhnXmlRpcServer.execute(RhnXmlRpcServer.java:54)
         at 
com.redhat.rhn.frontend.xmlrpc.XmlRpcServlet.doPost(XmlRpcServlet.java:162)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)
         at 
com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
         at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
         at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
         at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
         at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
         at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
         at 
org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:429)
         at 
org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384)
         at 
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1556)
         at java.lang.Thread.run(Thread.java:679)
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for 
type character varying(4000)
         at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
         at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
         at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
         at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
         at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
         at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
         at 
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:469)
         at 
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
         at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
         ... 56 more
2012-06-19 18:27:54,739 [ajp-0%3A0%3A0%3A0%3A0%3A0%3A0%3A1-8009-5] ERROR 
com.redhat.rhn.frontend.xmlrpc.BaseHandler - Error calling method:
java.lang.reflect.InvocationTargetException
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
         at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         at java.lang.reflect.Method.invoke(Method.java:616)
         at 
com.redhat.rhn.frontend.xmlrpc.BaseHandler.invoke(BaseHandler.java:108)
         at 
redstone.xmlrpc.XmlRpcDispatcher.dispatch(XmlRpcDispatcher.java:123)
         at 
com.redhat.rhn.frontend.xmlrpc.RhnXmlRpcServer.execute(RhnXmlRpcServer.java:54)
         at 
com.redhat.rhn.frontend.xmlrpc.XmlRpcServlet.doPost(XmlRpcServlet.java:162)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)
         at 
com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
         at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
         at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
         at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
         at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
         at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
         at 
org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:429)
         at 
org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384)
         at 
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1556)
         at java.lang.Thread.run(Thread.java:679)
Caused by: com.redhat.rhn.common.hibernate.HibernateRuntimeException: 
HibernateException executing CachedStatement
         at 
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:468)
         at 
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:430)
         at 
com.redhat.rhn.common.db.datasource.CachedStatement.executeUpdate(CachedStatement.java:270)
         at 
com.redhat.rhn.common.db.datasource.WriteMode.executeUpdate(WriteMode.java:33)
         at 
com.redhat.rhn.manager.errata.ErrataManager.clearErrataChannelNotifications(ErrataManager.java:1266)
         at 
com.redhat.rhn.domain.errata.AbstractErrata.addChannelNotification(AbstractErrata.java:614)
         at 
com.redhat.rhn.domain.errata.ErrataFactory.publishToChannel(ErrataFactory.java:255)
         at 
com.redhat.rhn.frontend.xmlrpc.errata.ErrataHandler.publish(ErrataHandler.java:1328)
         at 
com.redhat.rhn.frontend.xmlrpc.errata.ErrataHandler.create(ErrataHandler.java:1177)
         ... 38 more
Caused by: org.hibernate.exception.DataException: could not insert: 
[com.redhat.rhn.domain.errata.impl.UnpublishedErrata]
         at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
         at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
         at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
         at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
         at 
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
         at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
         at 
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
         at 
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
         at 
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
         at 
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
         at 
com.redhat.rhn.common.db.datasource.CachedStatement.stealConnection(CachedStatement.java:855)
         at 
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:440)
         ... 46 more
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for 
type character varying(4000)
         at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
         at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
         at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
         at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
         at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
         at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
         at 
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:469)
         at 
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
         at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
         ... 56 more

PostgreSQL log states the following:

ERROR:  value too long for type character varying(4000)
STATEMENT:  insert into rhnErrataTmp (advisory, advisory_type, product, 
description, synopsis, topic, solution, errata_from, issue_date, 
update_date, notes, refers_to, advisory_name, advisory_rel, 
locally_modified, org_id, id) values ($1, $2, $3, $4, $5, $6, $7, $8, 
$9, $10, $11, $12, $13, $14, $15, $16, $17)

Regards,
Patrick

-- 
Lobster LOGsuite GmbH, Hauptstraße 67, D-82327 Tutzing

HRB 178831, Amtsgericht München
Geschäftsführer: Dr. Martin Fischer, Rolf Henrich