I've hit that problem before, too, the first time I set up a local development Sybase server. It pauses the transaction, but as soon as the log is dumped, the transaction continues. That isn't the issue Jerome (or myself) have seen. Cayenne logs the appropriate SQL (insert/update/delete) without pausing, but the changes aren't made in the database. I really wish I had a test case to reproduce it. It has always been very sporadic for me, but it seems like Jerome might have something closer to being able to reliably reproduce it. I'm hoping he can do that. :-)
Thanks, /dev/mrg On 4/8/07, Andrus Adamchik <[EMAIL PROTECTED]> wrote:
I just ran Cayenne unit test suite against Sybase ASE 12.5.3 (Mac OS X edition). The tests pass, although Sybase quickly runs out of transaction log space, printing the following message in the log: 00:00000:00004:2007/04/08 08:19:21.13 server 1 task(s) are sleeping waiting for space to become available in the log segment for database cayenne. This hangs the application. To unstuck it I had to log in to jISQL and execute the following SQL command, the application resumes and completes successfully: dump transaction cayenne with no_log I don't know if this information is of any relevance to what Jerome is doing, but can you possibly look in the Sybase logs to see what's going on on the Sybase server? Andrus
