Re: frontbase dying
On Mar 28, 2010, at 8:52 PM, Chuck Hill wrote: On Mar 28, 2010, at 6:48 AM, Mike Schrag wrote: presumably it crashed ... there should be a crash log produced by it that you can send to FB. Hint: look in /Library/Logs/CrashReporter That directory is empty. 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. If the _exact_ _same_ (different data values perhaps, but same SQL) query runs OK one time and fails later, that would suggest a corrupted table or index. Doing a write all and importing it to re- create the database will fix this. If that is the case, I'd run the hardware tests on that machine and check the disk. The above is the case. If the SQL form is unique, you have have hit a parsing bug in FrontBase. I've seen that happen now and then. Chuck 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/chill%40global-village.net This email sent to ch...@global-village.net -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects ___ 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
Re: frontbase dying
On Mar 28, 2010, at 6:48 AM, Mike Schrag wrote: presumably it crashed ... there should be a crash log produced by it that you can send to FB. Hint: look in /Library/Logs/CrashReporter 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. If the _exact_ _same_ (different data values perhaps, but same SQL) query runs OK one time and fails later, that would suggest a corrupted table or index. Doing a write all and importing it to re-create the database will fix this. If that is the case, I'd run the hardware tests on that machine and check the disk. If the SQL form is unique, you have have hit a parsing bug in FrontBase. I've seen that happen now and then. Chuck 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/chill%40global-village.net This email sent to ch...@global-village.net -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects ___ 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
Re: frontbase dying
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
Re: frontbase dying
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