Undeleteable triggers

[rjosephwright]

I selected 6 triggers to delete from a template, which was linked to 50 hosts or so. After attempting the delete, I got an error message.

ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-01000: maximum open cursors exceeded[/var/www/html/zabbix/include/db.inc.php:424]
SQL error [ORA-01000: maximum open cursors exceeded] in [SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (85771)) ]

This message repeats itself a few hundred times, then more errors such as the one below.

SQL error [ORA-01000: maximum open cursors exceeded] in [SELECT triggerid_up, triggerid_down FROM trigger_depends WHERE (triggerid_down IN (68918,68919,68932,69550,69551,.......(a whole bunch of items)......,84797,84798,84822,84823,84836,84881,84882,69234,69235,69248,69406,69449,69450,69451,69528,69529,69530,69291,69292,69293,69313,69314,69327,88987,88988,89001,89046,89047,89048,88817,88818,88831,88876,88877,88878,88902,88903,88916,88961,88962,88963)) ]
ocifetchinto() [<a href='function.ocifetchinto'>function.ocifetchinto</a>]: ORA-24374: define not done before fetch or execute and fetch[/var/www/html/zabbix/include/db.inc.php:556]
ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-01000: maximum open cursors exceeded[/var/www/html/zabbix/include/db.inc.php:502]

Well, after it failed to delete these triggers from the hosts, it went ahead and deleted them from the template. Now they exist as "phantom" triggers attached to each of the hosts. They cannot be deleted because Zabbix seems to believe that they belong to a template.

My question is, is the only way I can get rid of them to go into the database and attempt to do it manually? And, why is it opening so many cursors? Our DBA set the max cursors to 600, which is a lot.

This is using Zabbix version 1.8.3 with Oracle 10.2.0.4 database.