[Zope] XRON and simultaneous triggers

[Capesius, Alan]

How does XRON handle multiple events schedule for firing at the same time?

If they are parallel tasks, does this present any problems with ODBC
database access if say 20 tasks were all queued to fire at the same time?

I added a ODBC SQL call to my Xron Method to tag a particular record in an
MSAccess database with the current date for indicating the last time a
scheduled job fired. This ODBC SQL call would've been executing from
multiple threads simultaneously when the events triggered through the
scheduler.

I'm seeing some "connection already closed" errors from zmxodbc in the xron
log.
This is resulting in an endless loop until the server is restarted and full
system logs.

2001-06-21T18:11:51 PROBLEM(100) Products.Xron.Loggerr Failed to disarm
event
------
2001-06-21T18:11:51 PROBLEM(100) Products.Xron.Loggerr 
Trigger event: http://192.168.200.1:8080/Event_IConnect_Alert
Trigger time: 2001/06/21 12:59:00 US/Central
Failed to trigger event.
Type=bci.ServerError
Val=connection already closed (File:
D:\Zope230\lib\python\Products\ZmxODBCDA\db.py Line: 150)
500 Internal Server Error for
http://192.168.200.1:8080/Event_IConnect_Alert/trigger
------
2001-06-21T18:11:51 PROBLEM(100) Products.Xron.Loggerr Failed to disarm
event
------
2001-06-21T18:11:51 PROBLEM(100) Products.Xron.Loggerr 
Trigger event: http://192.168.200.1:8080/Event_IConnect_Alert
Trigger time: 2001/06/21 12:59:00 US/Central
Failed to trigger event.
Type=bci.ServerError
Val=connection already closed (File:
D:\Zope230\lib\python\Products\ZmxODBCDA\db.py Line: 150)
500 Internal Server Error for
http://192.168.200.1:8080/Event_IConnect_Alert/trigger




Alan Capesius, MCSE/NTCIP+20
Technical Support Engineer
Sysmex Corporation of America
capesiusa@sysmex.com