Oliver Bleutgen wrote:

...

I fiddled around somewhat and discovered that disabling subtransactions in ZCatalog does help (required for using ZSQL Methods and ZCatalog in the same transaction).

Yeah, that sux. I think this is a known limitation. I'm not sure.

It is, unfortunately this is only mentioned under "status" in the ZCatalog interface. Well, I just got there by chance after several hours of digging around. I first thought perhaps some DTML-Document was "bad-behaving". (not that I had an idea how it might do that.) With a (assumed) growing attractiveness of things like sql-based UserFolders, perhaps a big warning sign either on the main page of these products or ZCatalog (better IMO, since this is a default product) would be in order, I guess. Or perhaps disabling subtransactions by default. All in all this combination seems not uncommon.

...

Now I use SQL-based LoginManager, but why on earth did it only fail on DTML-Documents? Is it because I have much more of them so only then ZCatalog's subtransactions come into play?

Probably because sub transactions are only commited after a certain number of words or values are indexed, and your DTML documents were the only things that held words.

-Michel

cheers, oliver