hanging transactions from web frontend

[xxiii]

This is happening in 2.0.6rc1 (sorry, I haven't upgraded to the non rc1 version yet, so perhaps this is fixed?)

The zabbix web interface seems to like leaving idle transactions lying around (is there a commit missing somewhere?) They disappear (or restart the age counter) as the httpd process gets reused, or if httpd is shutdown:

age | pid | state | usename | query

00:08:28.927143 | 11800 | idle in transaction | zabbix | SELECT t.* FROM triggers t WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='14' WHERE t.tr
00:07:58.713091 | 13373 | idle in transaction | zabbix | SELECT t.* FROM triggers t WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='14' WHERE t.tr
00:06:53.172378 | 16800 | idle in transaction | zabbix | SELECT t.* FROM triggers t WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='14' WHERE t.tr
00:06:40.970496 | 17451 | idle in transaction | zabbix | SELECT t.* FROM triggers t WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='14' WHERE t.tr
00:06:15.864563 | 18799 | idle in transaction | zabbix | SELECT t.* FROM triggers t WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='14' WHERE t.tr
00:05:25.992458 | 21416 | idle in transaction | zabbix | SELECT t.* FROM triggers t WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='14' WHERE t.tr
00:05:01.28525 | 22741 | idle in transaction | zabbix | SELECT t.* FROM triggers t WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='14' WHERE t.tr
00:04:36.610073 | 24063 | idle in transaction | zabbix | SELECT t.* FROM triggers t WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='14' WHERE t.tr
00:03:59.275312 | 26006 | idle in transaction | zabbix | SELECT t.* FROM triggers t WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='14' WHERE t.tr
00:03:29.97829 | 27551 | idle in transaction | zabbix | SELECT t.* FROM triggers t WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='14' WHERE t.tr
00:03:14.021144 | 28378 | idle in transaction | zabbix | SELECT t.* FROM triggers t WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='14' WHERE t.tr
00:02:31.895469 | 30638 | idle in transaction | zabbix | SELECT t.* FROM triggers t WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='14' WHERE t.tr
00:02:16.597334 | 31426 | idle in transaction | zabbix | SELECT t.* FROM triggers t WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='14' WHERE t.tr
00:00:40.064992 | 4085 | idle in transaction | zabbix | SELECT t.* FROM triggers t WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='14' WHERE t.tr
00:00:33.021464 | 10244 | idle in transaction | zabbix | SELECT d.triggerid_down,d.triggerid_up,t.value FROM trigger_depends d,triggers t WHERE (d.triggerid_down BETWEEN '44521' AND '44527' OR d.triggerid_down BETWEEN
00:00:26.5373 | 4844 | idle in transaction | zabbix | SELECT t.* FROM triggers t WHERE EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid='14' WHERE t.tr