[Spacewalk-list] ISE when scheduling errata

Pierre Casenove pcasenove at gmail.com
Thu Jul 12 06:56:25 UTC 2012


hello,
I have a rhel 6 client with 48 needed security erratas.
I'm trying to schedule all erratas... but I'm getting an ISE:
The following exception occurred while executing this request:
POST /rhn/systems/details/ErrataConfirm.do
Caused by: org.postgresql.util.PSQLException: ERROR: value too long
for type character varying(128)

I attach the complete traceback.

Thnaks in advance,

pierre
-------------- next part --------------
The following exception occurred while executing this request:
POST /rhn/systems/details/ErrataConfirm.do

Date:7/12/12 6:45:27 AM UTC
Headers:
  host: spacewalk
  user-agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.4) Gecko/20100101 
Firefox/10.0.4
  accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
  accept-language: fr,en-us;q=0.7,en;q=0.3
  accept-encoding: gzip, deflate
  connection: keep-alive
  referer: 
https://spacewalkr/rhn/systems/details/ErrataConfirm.do?sid=1000010
058
  cookie: JSESSIONID=D4A4A46150867B4DE45A3A490BB5C188; pxt-session-
cookie=37371x93d272ebefa944252af013e553d6d8b4
  content-type: application/x-www-form-urlencoded
  content-length: 463

Request:
Local Name = spacewalk
Server Name = spacewalk
Requested Session Id came from Cookie
Requested Session Valid = true
Session = 
org.apache.catalina.session.StandardSessionFacade at 3b35bed2[session=StandardSes
sion[D4A4A46150867B4DE45A3A490BB5C188]]
Protocol = https
Request Locale = en_US
Request Character Encoding = UTF-8
Attribute Names = rhnActiveLang, javax.servlet.jsp.jstl.fmt.timeZone.request, 
javax.servlet.request.key_size, requestedUri, list_1154021400_selected_amt, 
org.apache.struts.action.ACTION_MESSAGE, javax.servlet.request.ssl_session, 
org.apache.struts.action.MESSAGE, session, __sitemesh__filterapplied, 
applyErrataConfirmForm, javax.servlet.request.cipher_suite, 
org.apache.struts.action.mapping.instance, org.apache.struts.action.MODULE, 

Form Variables:
  date_year: 2012
  sid: 1000010058
  1154021400_PAGE_SIZE_LABEL_SELECTED: null
  list_1154021400_page_last: last
  use_date: false
  date_day: 12
  list_1154021400_parent_is_an_element: true
  date_minute: 45
  list_1154021400_search_parent: true
  dispatch: Confirmer
  list_1154021400_search_child: false
  date_hour: 8
  date_month: 6
  submitted: true
  list_1154021400_page_next: 1
  csrf_token: -2344184125659933343
  1154021400_PAGE_SIZE_LABEL: 25


User Information:
User irt43 (id 25, org_id 1)

Exception:
javax.servlet.ServletException: HibernateException executing CachedStatement
	at 
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.ja
va:535)
	at 
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcesso
r.java:433)
	at 
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237)
	at 
com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor
.java:99)
	at 
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFi
lterChain.java:269)
	at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChai
n.java:188)
	at 
com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:91)
	at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFi
lterChain.java:215)
	at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChai
n.java:188)
	at 
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:1
42)
	at 
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58
)
	at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFi
lterChain.java:215)
	at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChai
n.java:188)
	at 
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(Localized
EnvironmentFilter.java:67)
	at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFi
lterChain.java:215)
	at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChai
n.java:188)
	at 
com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.
java:108)
	at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFi
lterChain.java:215)
	at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChai
n.java:188)
	at 
com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)
	at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFi
lterChain.java:215)
	at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChai
n.java:188)
	at 
com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharac
terEncodingFilter.java:97)
	at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFi
lterChain.java:215)
	at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChai
n.java:188)
	at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java
:210)
	at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java
:172)
	at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
	at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:1
08)
	at 
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:542)
	at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
	at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
	at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
	at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
	at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:8
97)
	at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:
685)
	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.ja
va:468)
	at 
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.ja
va:430)
	at 
com.redhat.rhn.common.db.datasource.CachedStatement.executeUpdate(CachedStatem
ent.java:270)
	at 
com.redhat.rhn.common.db.datasource.WriteMode.executeUpdate(WriteMode.java:33)
	at 
com.redhat.rhn.domain.rhnset.RhnSetFactory.removeByLabel(RhnSetFactory.java:19
1)
	at 
com.redhat.rhn.manager.rhnset.RhnSetManager.deleteByLabel(RhnSetManager.java:6
5)
	at com.redhat.rhn.manager.rhnset.RhnSetDecl.clear(RhnSetDecl.java:388)
	at 
com.redhat.rhn.frontend.action.systems.ErrataConfirmSetupAction.confirmErrata(
ErrataConfirmSetupAction.java:143)
	at 
com.redhat.rhn.frontend.action.systems.ErrataConfirmSetupAction.execute(Errata
ConfirmSetupAction.java:75)
	at 
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcesso
r.java:431)
	... 41 more
Caused by: org.hibernate.exception.DataException: could not insert: 
[com.redhat.rhn.domain.action.errata.ErrataAction]
	at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
	at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:4
3)
	at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPe
rsister.java:2267)
	at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPe
rsister.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(Abstra
ctFlushingEventListener.java:298)
	at 
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventLis
tener.java:27)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
	at 
com.redhat.rhn.common.db.datasource.CachedStatement.stealConnection(CachedStat
ement.java:855)
	at 
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.ja
va:440)
	... 50 more
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type 
character varying(128)
	at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImp
l.java:1525)
	at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java
:1309)
	at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
	at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.jav
a:452)
	at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Stat
ement.java:354)
	at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Stateme
nt.java:308)
	at 
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPrepa
redStatement.java:79)
	at 
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
	at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPe
rsister.java:2247)
	... 60 more



More information about the Spacewalk-list mailing list