Alerts; scheduling jobs

Steven North swn at ocsystems.com
Fri Aug 19 17:42:12 UTC 2011


Mazz,

These are the messages I see on the server side related to the invalid 
alert definition:

  2011-08-19 13:08:44,744 ERROR 
[org.rhq.enterprise.server.resource.ResourceManagerBean] Bulk named 
query delete error for 'AlertCondition.deleteByResources' for [10772]: 
org.hibernate.exception.ConstraintViolationException: could not execute 
update query
2011-08-19 13:08:44,758 WARN  [org.hibernate.util.JDBCExceptionReporter] 
SQL Error: 0, SQLState: 23503
2011-08-19 13:08:44,758 ERROR [org.hibernate.util.JDBCExceptionReporter] 
ERROR: update or delete on table "rhq_alert_definition" violates foreign 
key constraint "rhq_alert_condition_alert_definition_id_fkey" on table 
"rhq_alert_condition"
   Detail: Key (id)=(10031) is still referenced from table 
"rhq_alert_condition".
2011-08-19 13:08:44,758 ERROR 
[org.rhq.enterprise.server.resource.ResourceManagerBean] Bulk named 
query delete error for 'AlertDefinition.deleteByResources' for [10772]: 
org.hibernate.exception.ConstraintViolationException: could not execute 
update query
2011-08-19 13:08:44,778 INFO  
[org.rhq.enterprise.server.scheduler.jobs.AsyncResourceDeleteJob] Async 
resource deletion - 2 successful, 0 failed, took [304] ms


These are the types of messages I see for the global exception.  These 
happen whenever the UI tries to display recent alerts, either on the 
Dashboard or the Summary tab for a particular resource.  I also notice 
that Reports -> Alert Definitions lists some alert definitions that are 
no longer valid and if I click on their links I get a blank Inventory 
tab.  I tried squinting at the traceback below to find the associated 
source, but I wasn't sure what to do when I got there.  ;-)

Message :
Globally uncaught exception
Severity :
Error

Time :
Friday, August 19, 2011 1:30:28 PM Etc/GMT+4
Detail :
java.lang.NumberFormatException:For input string: "[From:Aug 18, 2011 
3:09:56 PM, To:Aug 18, 2011 3:11:01 PM, MAX:33929.0], 
extraInfo=[/seam-booking/debug.seam]"
--- STACK TRACE FOLLOWS ---
For input string: "[From:Aug 18, 2011 3:09:56 PM, To:Aug 18, 2011 
3:11:01 PM, MAX:33929.0], extraInfo=[/seam-booking/debug.seam]"
     at 
Unknown.java_lang_NumberFormatException_$NumberFormatException__Ljava_lang_NumberFormatException_2Ljava_lang_String_2Ljava_lang_NumberFormatException_2(Unknown 
source:0)
     at 
Unknown.java_lang_Number__1_1parseAndValidateDouble__Ljava_lang_String_2D(Unknown 
source:0)
     at 
Unknown.org_rhq_enterprise_gui_coregui_client_alert_AlertDataSource_convert__Lorg_rhq_core_domain_alert_Alert_2Lcom_smartgwt_client_widgets_grid_ListGridRecord_2(Unknown 
source:0)
     at 
Unknown.org_rhq_enterprise_gui_coregui_client_alert_AlertDataSource_copyValues__Ljava_lang_Object_2Lcom_smartgwt_client_widgets_grid_ListGridRecord_2(Unknown 
source:0)
     at 
Unknown.org_rhq_enterprise_gui_coregui_client_util_RPCDataSource_copyValues__Ljava_lang_Object_2ZLcom_smartgwt_client_widgets_grid_ListGridRecord_2(Unknown 
source:0)
     at 
Unknown.org_rhq_enterprise_gui_coregui_client_util_RPCDataSource_$buildRecords__Lorg_rhq_enterprise_gui_coregui_client_util_RPCDataSource_2Ljava_util_Collection_2Z_3Lcom_smartgwt_client_widgets_grid_ListGridRecord_2(Unknown 
source:0)
     at 
Unknown.org_rhq_enterprise_gui_coregui_client_alert_AlertDataSource$8_onTypesLoaded__Ljava_util_Map_2V(Unknown 
source:0)
     at 
Unknown.org_rhq_enterprise_gui_coregui_client_inventory_resource_type_ResourceTypeRepository_$getResourceTypes__Lorg_rhq_enterprise_gui_coregui_client_inventory_resource_type_ResourceTypeRepository_2_3Ljava_lang_Integer_2Ljava_util_EnumSet_2Lorg_rhq_enterprise_gui_coregui_client_inventory_resource_type_ResourceTypeRepository$TypesLoadedCallback_2V(Unknown 
source:0)
     at 
Unknown.org_rhq_enterprise_gui_coregui_client_alert_AlertDataSource_$dataRetrieved__Lorg_rhq_enterprise_gui_coregui_client_alert_AlertDataSource_2Lorg_rhq_core_domain_util_PageList_2Lcom_smartgwt_client_data_DSResponse_2Lcom_smartgwt_client_data_DSRequest_2V(Unknown 
source:0)
     at 
Unknown.org_rhq_enterprise_gui_coregui_client_dashboard_portlets_recent_alerts_AbstractRecentAlertsPortlet$AlertsPortletDataSource_dataRetrieved__Lorg_rhq_core_domain_util_PageList_2Lcom_smartgwt_client_data_DSResponse_2Lcom_smartgwt_client_data_DSRequest_2V(Unknown 
source:0)
     at 
Unknown.org_rhq_enterprise_gui_coregui_client_alert_AlertDataSource$7_$onSuccess__Lorg_rhq_enterprise_gui_coregui_client_alert_AlertDataSource$7_2Lorg_rhq_core_domain_util_PageList_2V(Unknown 
source:0)
     at 
Unknown.org_rhq_enterprise_gui_coregui_client_alert_AlertDataSource$7_onSuccess__Ljava_lang_Object_2V(Unknown 
source:0)
     at 
Unknown.com_google_gwt_user_client_rpc_impl_RequestCallbackAdapter_$onResponseReceived__Lcom_google_gwt_user_client_rpc_impl_RequestCallbackAdapter_2Lcom_google_gwt_http_client_Request_2Lcom_google_gwt_http_client_Response_2V(Unknown 
source:0)
     at 
Unknown.org_rhq_enterprise_gui_coregui_client_util_rpc_TrackingRequestCallback_onResponseReceived__Lcom_google_gwt_http_client_Request_2Lcom_google_gwt_http_client_Response_2V(Unknown 
source:0)
     at 
Unknown.com_google_gwt_http_client_Request_$fireOnResponseReceived__Lcom_google_gwt_http_client_Request_2Lcom_google_gwt_http_client_RequestCallback_2V(Unknown 
source:0)
     at 
Unknown.com_google_gwt_http_client_RequestBuilder$1_onReadyStateChange__Lcom_google_gwt_xhr_client_XMLHttpRequest_2V(Unknown 
source:0)
     at Unknown.anonymous(Unknown source:0)
     at 
Unknown.com_google_gwt_core_client_impl_Impl_entry0__Ljava_lang_Object_2Ljava_lang_Object_2Ljava_lang_Object_2Ljava_lang_Object_2(Unknown 
source:0)
     at Unknown.anonymous(Unknown source:0)
     at Unknown.anonymous(Unknown source:0)












On 8/19/2011 6:14 AM, John Mazzitelli wrote:
>> I assume this is my problem.  I know I have some "bad" alert
>> data hanging around int he database--is there a way to purge it?  Do I
>> have to reset the database somehow?
> Probably, unless you can do some sleuthing in your database and execute
> some SQL to cleanse your bad data.
>
> For reference, can you give more info on the global exception? What is
> it? Is this on a page where you are viewing alert details? Or a
> configuration editor? Any errors on the server side? Is this something
> where we can add code to be less destructive (i.e. maybe just show a
> blank value due to the bad data but still let you render the rest?)
> _______________________________________________
> rhq-devel mailing list
> rhq-devel at lists.fedorahosted.org
> https://fedorahosted.org/mailman/listinfo/rhq-devel



More information about the rhq-devel mailing list