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 <andru..bjectstyle.org> 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
This archive was generated by hypermail 2.0.0 : Sun Apr 08 2007 - 10:49:16 EDT