2008-03-10T00:28:23 *** bmazur has quit IRC
2008-03-10T00:40:39 *** parolkar has joined #mifos
2008-03-10T02:40:16 *** ccharlesworth has joined #mifos
2008-03-10T03:02:55 *** bmazur_ has joined #mifos
2008-03-10T03:02:56 *** bmazur_ is now known as bmazur
2008-03-10T03:24:11 *** bmazur has quit IRC
2008-03-10T05:40:27 *** parolkar has quit IRC
2008-03-10T06:40:47 <mifosbot> New news from builds: MIFOS-WT-587 has FAILED : Updated by LAJDEL Nazir
2008-03-10T07:10:52 <mifosbot> New news from builds: MIFOS-WT-588 has FAILED : Updated by LAJDEL Nazir
2008-03-10T07:44:33 *** meonkeys has joined #mifos
2008-03-10T07:44:33 *** ChanServ sets mode: +o meonkeys
2008-03-10T08:01:25 *** bmazur_ has joined #mifos
2008-03-10T08:01:26 *** bmazur_ is now known as bmazur
2008-03-10T08:19:57 <stephenhorgan> meonkeys: hi Adam, can i ask a question about database upgrades
2008-03-10T08:20:26 <meonkeys> stephenhorgan: of course. Shoot.
2008-03-10T08:21:22 <stephenhorgan> if my code performs an upgrade, then when i start up the app the upgrade will happen automatically (in DatabaseVersionPersistence.masterRegister()
2008-03-10T08:21:46 <stephenhorgan> but what about my test database, how can i upgrade that?
2008-03-10T08:22:01 <meonkeys> good question.
2008-03-10T08:22:11 <meonkeys> two things:
2008-03-10T08:22:28 <meonkeys> 1. the upgrade is tested in LatestTestAfterCheckpoint
2008-03-10T08:22:43 <meonkeys> DDL is executed to bring the database to a known state,
2008-03-10T08:22:56 <meonkeys> then upgrade scripts (and Java-based upgrades) are tested
2008-03-10T08:23:06 <meonkeys> as well as downgrade scripts and Java-based downgrades
2008-03-10T08:23:33 <meonkeys> 2. the database is routinely blown away, whenever the "build_test_db" target is executed
2008-03-10T08:23:51 <meonkeys> this happens, for instance, when you perform "ant run_test"
2008-03-10T08:23:52 *** emily has joined #mifos
2008-03-10T08:24:05 <stephenhorgan> yep, still with you
2008-03-10T08:24:26 <meonkeys> so, no need to upgrade your test database outside this process.
2008-03-10T08:24:37 <meonkeys> does that answer your question?
2008-03-10T08:25:00 <stephenhorgan> so i need to run LatestTestAfterCheckpoint
2008-03-10T08:25:29 <meonkeys> yes, if you just want to test your upgrade/downgrade scripts.
2008-03-10T08:26:47 <meonkeys> to get a good test of what will happen during deployment, Van suggests grabbing the latest database snapshot from http://test.mifos.org
2008-03-10T08:26:52 <meonkeys> loading it locally,
2008-03-10T08:27:02 <meonkeys> and deploying a WAR.
2008-03-10T08:27:44 <meonkeys> this will prove that your upgrade scripts work when actual test data is present.
2008-03-10T08:27:58 <meonkeys> mentioned here: http://mifos.org/developers/technical-orientation/mifos-database-development#how-to-properly-script (last bullet point)
2008-03-10T08:28:01 <mifosbot> <http://tinyurl.com/2evefr> (at mifos.org)
2008-03-10T08:28:41 <stephenhorgan> still not exactly sure. I ran LatestTestAfterCheckpoint; it failed because DatabaseVersionPersistence.APPLICATION_VERSION does not match the version in the database
2008-03-10T08:29:11 <stephenhorgan> ie. my test db is still at 176, but my register177() should have upgraded it
2008-03-10T08:29:16 <stephenhorgan> to 177
2008-03-10T08:29:28 <stephenhorgan> but what calls register177() in tests?
2008-03-10T08:41:17 <meonkeys> DatabaseVersionPersistence is used by the application initializer and unit tests to decide which upgrade scripts to execute.
2008-03-10T08:41:37 <meonkeys> are you doing an SQL-only upgrade or a Java upgrade?
2008-03-10T08:42:25 <stephenhorgan> java
2008-03-10T08:42:45 <stephenhorgan> so I just added a register177() method in DVP
2008-03-10T08:42:57 <meonkeys> ok, great.
2008-03-10T08:43:05 <meonkeys> Java only, no "conditional" stuff?
2008-03-10T08:43:13 <stephenhorgan> nope
2008-03-10T08:43:41 <meonkeys> ok.
2008-03-10T08:44:52 <meonkeys> cool, so, sounds like the entry in DatabaseVersionPersistence#masterRegister is what was missing.
2008-03-10T08:45:27 <stephenhorgan> no, its there
2008-03-10T08:47:19 <meonkeys> mmm. So, is LatestTestAfterCheckpoint working now?
2008-03-10T08:49:03 <stephenhorgan> no, the realSchemaFromCheckpoint() test fails: expected:<177> but was:<176>
2008-03-10T08:50:24 <meonkeys> ok. Does your Upgrade177#upgrade() method call upgradeVersion(Connection)?
2008-03-10T08:51:35 <stephenhorgan> I dont have an Upgrade177, because it's just an AddActivity upgrade, which does call upgradeVersion
2008-03-10T08:51:44 <meonkeys> ah, got it.
2008-03-10T08:51:49 <meonkeys> hmm,
2008-03-10T08:51:55 <meonkeys> I haven't done one of those, actually.
2008-03-10T08:53:31 <meonkeys> Just double-checking, but you incremented APPLICATION_VERSION (to 177) and left FIRST_NUMBERED_VERSION at 100 and LATEST_CHECKPOINT_VERSION at 174, correct?
2008-03-10T08:54:10 <stephenhorgan> yes
2008-03-10T08:54:49 <meonkeys> ok then.
2008-03-10T08:55:10 <meonkeys> At this point I humbly suggest 1. running "ant build_test_db"
2008-03-10T08:55:17 <meonkeys> 2. running LatestTestAfterCheckpoint
2008-03-10T08:55:47 <meonkeys> 3. if it still breaks, post the full stack trace and your register177 method to the mailing list.
2008-03-10T08:56:25 <meonkeys> and it wouldn't hurt to make sure you're hitting the database you think you are.
2008-03-10T08:56:58 <meonkeys> also feel free to paste your full stacktrace here: http://pastebin.com/ and share the link
2008-03-10T08:57:36 <meonkeys> I'm hoping for a clue beyond simply the version number not being incremented.
2008-03-10T09:01:14 <stephenhorgan> thks, i'll do some more digging & let you know
2008-03-10T09:05:31 <meonkeys> ok, good luck.
2008-03-10T09:10:38 *** rmusso has joined #mifos
2008-03-10T09:13:29 <stephenhorgan> could you pls try the changes here: http://mifos.pastebin.com/m24d20b4c and see if LatestTestAfterCheckpoint passes for you
2008-03-10T09:16:28 <meonkeys> sure! one minute.
2008-03-10T09:16:43 <meonkeys> you can also create a single-file patch in eclipse...
2008-03-10T09:17:09 <meonkeys> that way I'll be sure to not make a cut & paste or typing mistake
2008-03-10T09:17:14 <stephenhorgan> ok, 2 mins
2008-03-10T09:19:11 <stephenhorgan> http://mifos.pastebin.com/m798eb512
2008-03-10T09:21:33 <meonkeys> ugh; extra linebreaks in the patch. I'll just try applying the changes manually since they're minor.
2008-03-10T09:25:19 <meonkeys> stephenhorgan: SecurityConstants.CAN_VIEW_SYSTEM_INFO is undefined
2008-03-10T09:26:08 <stephenhorgan> oops, sorry that's a new short constant, 227
2008-03-10T09:26:13 <meonkeys> k
2008-03-10T09:33:54 <meonkeys> stephenhorgan: repros for me, exactly as you described.
2008-03-10T09:34:08 <stephenhorgan> yay, i'm not going mad
2008-03-10T09:34:22 <meonkeys> I wonder if the latest i18n work changed how these upgrades are supposed to work...
2008-03-10T09:35:40 <meonkeys> would you mind posting your findings (esp. the patch) to the dev mailing list?
2008-03-10T09:35:58 <stephenhorgan> sure
2008-03-10T09:35:59 <meonkeys> I'm sure someone here can take a look while you're digging in.
2008-03-10T09:44:12 *** vanmh has joined #mifos
2008-03-10T09:46:29 <vanmh> looks like we have a broken build due to build server issues
2008-03-10T09:46:53 <vanmh> I'm starting a manual build now
2008-03-10T09:53:52 *** meonkeys has left #mifos
2008-03-10T09:57:56 *** bmazur has quit IRC
2008-03-10T09:58:06 *** bmazur_ has joined #mifos
2008-03-10T09:58:08 *** bmazur_ is now known as bmazur
2008-03-10T10:11:28 <mifosbot> New news from builds: MIFOS-WT-589 was SUCCESSFUL (with 2608 tests): Manual build
2008-03-10T10:15:34 *** meonkeys has joined #mifos
2008-03-10T10:15:34 *** ChanServ sets mode: +o meonkeys
2008-03-10T10:32:30 *** ccharlesworth has quit IRC
2008-03-10T11:44:54 *** rmusso has quit IRC
2008-03-10T11:59:15 *** meonkeys has left #mifos
2008-03-10T13:03:08 *** meonkeys has joined #mifos
2008-03-10T13:03:09 *** ChanServ sets mode: +o meonkeys
2008-03-10T14:14:52 *** Kim_ has joined #mifos
2008-03-10T14:15:58 <Kim_> Hi all, I'm about to commit my code. Any objection? I will count to 3...
2008-03-10T14:16:38 <meonkeys> go for it!
2008-03-10T14:18:50 <meonkeys> After you do I'll re-run my unit tests and do my commit.
2008-03-10T14:26:48 <Kim_> I just commited my code.
2008-03-10T14:32:18 <meonkeys> I updated. No conflicts, but I'll do the tests and redeploy anyway just to be sure my chart of accounts wrap-up stuff works with your stuff.
2008-03-10T14:45:16 <meonkeys> stephenhorgan: just wanted to say thanks to you and Chico for updating your branch often. That will totally make our lives easier when we merge back to the trunk.
2008-03-10T14:57:43 <meonkeys> Kim_: how much RAM to do you have in your development workstation?
2008-03-10T15:00:04 <Kim_> 2 GB
2008-03-10T15:01:30 <meonkeys> interesting. And you said the unit tests take about 45min? I would've thought that 2GB would be enough to help. Perhaps a faster processor or disk would help.
2008-03-10T15:04:13 <Kim_> processor Intel Core 2, T6500, 1.83GHz
2008-03-10T15:08:00 <meonkeys> disk?
2008-03-10T15:12:15 <mifosbot> New news from builds: MIFOS-WT-591 was SUCCESSFUL (with 2608 tests): Updated by Adam Monsen || MIFOS-WT-590 was SUCCESSFUL (with 2608 tests): Updated by Kimloan Ho
2008-03-10T15:13:41 *** bmazur has quit IRC
2008-03-10T15:13:41 *** vanmh has quit IRC
2008-03-10T15:13:41 *** epavlenko has quit IRC
2008-03-10T15:13:41 *** Kim_ has quit IRC
2008-03-10T15:13:41 *** stephenhorgan has quit IRC
2008-03-10T15:13:41 *** ChanServ has quit IRC
2008-03-10T15:13:41 *** emily has quit IRC
2008-03-10T15:13:41 *** meonkeys has quit IRC
2008-03-10T15:15:20 *** meonkeys has joined #mifos
2008-03-10T15:15:20 *** Kim_ has joined #mifos
2008-03-10T15:15:20 *** bmazur has joined #mifos
2008-03-10T15:15:20 *** vanmh has joined #mifos
2008-03-10T15:15:20 *** emily has joined #mifos
2008-03-10T15:15:20 *** ChanServ has joined #mifos
2008-03-10T15:15:20 *** stephenhorgan has joined #mifos
2008-03-10T15:15:20 *** epavlenko has joined #mifos
2008-03-10T15:15:20 *** irc.freenode.net sets mode: +oo meonkeys ChanServ
2008-03-10T15:15:51 <Kim_> where do I find that?
2008-03-10T15:17:59 <meonkeys> I don't know. With mine, I just put my Dell service tag in here: http://support.dell.com/support/topics/global.aspx/support/product_support/product_support_central
2008-03-10T15:18:02 <mifosbot> <http://tinyurl.com/2kpm6c> (at support.dell.com)
2008-03-10T15:18:31 <meonkeys> and it provides hardware details (probably just what the box was sold with)
2008-03-10T15:26:05 <Kim_> WH808 HARD DRIVE..., 120G, Serial ATA..., 9.5, 5.4, T060
2008-03-10T15:28:06 <meonkeys> from what little I know of hard drives, I'd say SATA is good. Speed is hopefully 7200 RPM or faster. I don't know what "9.5, 5.4, T060" means.
2008-03-10T15:29:45 <meonkeys> next thing you might try to do is look at what programs are currently running, especially anti-virus software.
2008-03-10T15:34:51 <Kim_> I have McAfee
2008-03-10T15:40:58 <meonkeys> ok; I imagine that slows down file and memory reads and writes and uses up RAM.
2008-03-10T15:40:59 <meonkeys> You're on Windows, right? I think the Task Manager can report what is using up the most memory. I've also heard of something called "Process Explorer" that might help you do some poor-man's profiling.
2008-03-10T15:41:14 <meonkeys> good luck!
2008-03-10T15:41:38 <meonkeys> vanmh or Kim_: logging question.
2008-03-10T15:42:20 <meonkeys> If I call MifosLogger.info(), where should this show up?
2008-03-10T15:42:20 <mifosbot> New news from builds: MIFOS-WT-592 was SUCCESSFUL (with 2608 tests): Updated by Adam Monsen
2008-03-10T15:43:19 <meonkeys> in Mifos.log, standard out, Tomcat logs, or somewhere else?
2008-03-10T15:43:48 <Kim_> Sorry I don't know.
2008-03-10T15:44:50 <meonkeys> cool, no problem.
2008-03-10T15:59:25 <vanmh> meonkeys: I think this will show up in Mifos.log
2008-03-10T15:59:37 <meonkeys> ah, looks like I need to adjust loggerconfiguration.xml
2008-03-10T16:00:02 <vanmh> meonkeys: I could be wrong on that, but that's my first thought
2008-03-10T16:00:21 <meonkeys> thanks, Van. I think you're right.
2008-03-10T16:01:23 <meonkeys> the log4j configuration would also be a nice thing to override somewhere external to the WAR.
2008-03-10T16:01:30 <vanmh> yep
2008-03-10T16:01:45 <meonkeys> ah, in fact, I see a comment to that effect. I'll file a feature request.
2008-03-10T16:01:57 <vanmh> sounds good
2008-03-10T16:36:28 <mifosbot> New news from wikinewpages: Improve Application Logging
2008-03-10T16:42:56 <meonkeys> Kim_ or whomever, let me know if my incremental commits are disruptive. I can switch to a branch if need be.
2008-03-10T16:44:11 <Kim_> No, I am done for the day.
2008-03-10T17:49:07 *** bmazur has quit IRC
2008-03-10T17:49:32 *** bmazur_ has joined #mifos
2008-03-10T17:49:34 *** bmazur_ is now known as bmazur
2008-03-10T18:10:35 *** Kim_ has quit IRC
2008-03-10T18:12:45 <mifosbot> New news from builds: MIFOS-WT-593 was SUCCESSFUL (with 2608 tests): Updated by Adam Monsen
2008-03-10T19:08:07 *** emily has quit IRC
2008-03-10T20:02:52 *** vanmh has quit IRC
2008-03-10T20:02:52 *** epavlenko has quit IRC
2008-03-10T20:02:52 *** stephenhorgan has quit IRC
2008-03-10T20:02:52 *** ChanServ has quit IRC
2008-03-10T20:02:52 *** bmazur has quit IRC
2008-03-10T20:02:52 *** meonkeys has quit IRC
2008-03-10T20:03:12 *** meonkeys has joined #mifos
2008-03-10T20:03:12 *** bmazur has joined #mifos
2008-03-10T20:03:12 *** vanmh has joined #mifos
2008-03-10T20:03:12 *** epavlenko has joined #mifos
2008-03-10T20:03:12 *** stephenhorgan has joined #mifos
2008-03-10T20:03:12 *** ChanServ has joined #mifos
2008-03-10T20:03:12 *** irc.freenode.net sets mode: +oo meonkeys ChanServ