Looking at the frontbase transaction log, around the time of the below
exception (7:42) I see a normal update (one of MANY similar ones going
on before it) followed by one that occurred 2 minutes after the
webobjects exception that I don't recognize concerning an updatelock.
Of course this second transaction happened after webobjects was
already reporting the database as not running...
--Tran: 55296 2010-03-28-06:38:35 1344314 505 505 0 1070459
0,netBrackets,NETBRACKETS,America/Chicago
^...@^@^A?UPDATE "t_pool" SET "c_calculating_can_i_wins" = 'true' WHERE
("id"=1000743) AND ("c_admin_email"='sta...@fortosage.net') AND
("c_calculating_can_i_wins"='false') AND ("c_can_i_win_index"=0) AND
("c_can_i_wins_calculated"='false') AND ("c_early_bird_paid"='false')
AND ("c_entry_limit"=0) AND ("c_paid"='tr
ue') AND ("c_pool_type"=0) AND ("c_results_index"=24) AND
("c_seed_type"=0) AND ("c_stand_alone"='false') AND
("c_ud_bonus"='false') AND ("c_updating_results"='false') AND
("c_weighted"='false');~...@^@^...@b--
Tran: 55297 2010-03-28-07:44:48 11 190 190 0 1070751
0,netBrackets,NETBRACKETS,America/Chicago
^...@^@^...@?update "_dbupdater" SET "lockowner" = 'netBrackets-localhost:
2003', "updatelock" = 1 WHERE ("modelname"='netbracketsFW') AND
("updatelock"=0 OR "lockowner"='netBrackets-localhost:2003');~...@^@^...@`
--Tran: 55298 2010-03-28-07:44:48 31 99 99 0 1070950
0,netBrackets,NETBRACKETS,America/Chicago
^...@^@^...@_update "_dbupdater" SET "lockowner" = NULL, "updatelock" = 0
WHERE "modelname"='netbracketsFW';~...@^@^...@b
On Mar 28, 2010, at 8:48 AM, Mike Schrag wrote:
presumably it crashed ... there should be a crash log produced by it
that you can send to FB. you should also look at the query that ran
just before it crashed and see if it's the same both times -- maybe
you can check to see if something is corrupted related to that query.
On Mar 28, 2010, at 9:37 AM, Jeff Schmitz wrote:
Any idea what might cause frontbase to just up and die. Twice now
it will seem to be functioning fine, and then it will just go
away. Below is the only exception I'm getting when it dies:
(ERXDatabaseContextDelegate.java:175) INFO
er.transaction.adaptor.Exceptions - Database Exception occured:
Database - netBrackets - is not runningat
com
.frontbase.jdbc.FBJConnection.createConnection(FBJConnection.java:
275)
at com.frontbase.jdbc.FBJConnection.reconnect(FBJConnection.java:355)
at com.frontbase.jdbc.FBJConnection.fbX(FBJConnection.java:796)
at com.frontbase.jdbc.FBJConnection.execute(FBJConnection.java:839)
at com.frontbase.jdbc.FBJConnection.rollback(FBJConnection.java:629)
Thanks,
Jeff
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40mdimension.com
This email sent to msch...@mdimension.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
