Bug 784013 - Deleting a monitoring probe results in exception
Summary: Deleting a monitoring probe results in exception
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Server
Version: 1.6
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Jan Pazdziora
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space17
TreeView+ depends on / blocked
 
Reported: 2012-01-23 15:06 UTC by schuler.philipp
Modified: 2012-03-07 09:54 UTC (History)
1 user (show)

Fixed In Version: spacewalk-java-1.7.11-1
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-03-07 09:54:51 UTC
Embargoed:


Attachments (Terms of Use)

Description schuler.philipp 2012-01-23 15:06:04 UTC
Description of problem:
Deleting a probe results in exception

Version-Release number of selected component (if applicable):
1.6 with postgres backend

How reproducible:
try to delete a probe
  
Actual results:
[TP-Processor2] ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing cached statement sql: DELETE /*+index(time_series time_series_probe_id_idx)*/
  FROM time_series
  WHERE substr(o_id, instr(o_id, '-') + 1,
        (instr(o_id, '-', instr(o_id, '-') + 1) - instr(o_id, '-'))    - 1) = ?
com.redhat.rhn.common.db.WrappedSQLException: ERROR: operator does not exist: text = bigint
  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Expected results:
should delete the probe

Comment 1 Jan Pazdziora 2012-01-27 16:07:43 UTC
Fixed in Spacewalk master, 4dc19730824ded78827a0b9ae39bba25c6bee453.

Comment 2 Jan Pazdziora 2012-03-07 09:54:51 UTC
Spacewalk 1.7 has been released:

https://fedorahosted.org/spacewalk/wiki/ReleaseNotes17


Note You need to log in before you can comment on or make changes to this bug.