onbar PSM: -284 error when running onsmsync -g (recycle backup
Eric Vercelletto got SQL error -284 (subquery returned more than one row) from onsmsync -g in the PSM during expiration, so media recycling failed. Paul Watson joked about onmode -I 284; Andreas Legner suggested PSM_DEBUG and PSM_DEBUG_LOG. Eric said the PSM log showed no error, backup objects were piling up, and asked whether to open a ticket. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi Folks,
having a stupid error -284 when running onsmsync -g , which ends in not complete the media recycling operation.
here is what the onbar log says
2020-04-19 07:50:28 27813 27812 Applying expiration policies...
2020-04-19 07:50:28 27813 27812 bar_exp_spaces_by_policy: s_bkp_obj_from_tltab_stmt: SQLCODE=-284 using aid=38 oid=7
2020-04-19 07:50:28 27813 27812 SQL -284 A subquery has returned not exactly one row.
2020-04-19 07:50:28 27813 27812 Informix Primary Storage Manager session 700 closed
2020-04-19 07:50:28 27813 27812 /opt/informix/engines/ifmx.14.10.FC3/bin/onsmsync complete, returning 148 (0x94)
Not sure in which table this error occurs. I am trying to access with Informix SE to the PSM_CATALOG_PATH tables but no database name to use ...
Any idea on how to fix this ?
Thanks, as always
Eric
------------------------------
[eric] [Vercelletto] []
[Founder]
[kandooerp.org]
[Pont l'Abbé] [France]
[+33 626 52 50 68]
Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
------------------------------
#Informix
onmode –I 284 ?
Brilliant idea Paul Should I create a RFE for this new option
Hi Eric, there's PSM_DEBUG and PSM_DEBUG_LOG, very similar to BAR_DEBUG[_LOG]. Maybe this can shed more light on your problem? BR, Andreas ------------------------------ Andreas Legner ------------------------------
Hi Andreas Nice try, and cool functionality, now I know with lot of details what onsmsync does, but the bar_log file gives an error probably with a function name and a prepared statement name, and the psm log (in 2100+ lines) does not mention any error nor function name or anything similar. This is starting to be annoying because backup objects volume is growing and I cannot clear them ... Should I log a ticket ?