| # | Time | Nick | Message |
|---|
| # | 04:57:16 | eeevil_ has joined #evergreen |
| # | 04:59:33 | phasefx2 has quit IRC |
| # | 05:01:26 | phasefx2 has joined #evergreen |
| # | 05:01:53 | eeevil has quit IRC |
| # | 05:01:54 | Dmagick__ has joined #evergreen |
| # | 05:01:55 | Dmagick has quit IRC |
| # | 07:29:18 | youdonotexist has quit IRC |
| # | 10:08:48 | eby_ is now known as eby |
| # | 10:12:46 | dbs has joined #evergreen |
| # | 14:15:38 | dbs has quit IRC |
| # | 15:22:39 | mtate_ has quit IRC |
| # | 15:22:49 | mtate has joined #evergreen |
| # | 15:33:53 | dbs has joined #evergreen |
| # | 15:36:05 | dbs | Making an Evergreen 1.6.1.4 image so that we can actually test the 1.6.1-2.0 upgrade steps in a repeatable fashion |
| # | 16:19:27 | bshum has joined #evergreen |
| # | 16:19:33 | dbs | bshum++ |
| # | 16:19:48 | bshum | dbs: Thanks! Got eager to do a little testing before tomorrow's meeting. |
| # | 16:20:00 | bshum | dbs: Holidays and vacation, bleh :) |
| # | 16:20:33 | bshum | dbs: Happy to report that IE is working quite nicely with my beta3 virtual image |
| # | 16:20:47 | bshum | And firefox and chrome are showing major improvements as well. |
| # | 16:20:54 | bshum | In terms of performance |
| # | 16:21:10 | dbs | yayz |
| # | 16:22:39 | bshum | There were a few "ERROR" messages that popped up during the 1.6.1-2.0 upgrade, but I traced them to mostly the script checking to drop certain things before creating them anew. That's normal I assume. |
| # | 16:23:08 | dbs | yes, indeed |
| # | 16:24:15 | dbs | DROP VIEW auditor.asset_call_number_lifecycle; probably |
| # | 16:24:46 | bshum | I kept a copy of the latest upgrade log (took me a few moments to figure out how to get the outputs into a file) |
| # | 16:24:58 | dbs | should convert those to "DROP VIEW IF EXISTS..." as 8.4 supports that syntax |
| # | 16:26:26 | bshum | Hmm, that one doesn't show up in my upgrade output. |
| # | 16:28:20 | dbs | (actually, that one would be bad as it's inside the transaction) |
| # | 16:28:39 | dbs | Possibly some of the CREATE INDEX statements (trying to create a duplicate) |
| # | 16:28:50 | bshum | Yeah, that comes up a few times. |
| # | 16:29:19 | bshum | psql:1.6.1-2.0-upgrade-db.sql:18953: ERROR: relation "acq_po_org_name_order_date_idx" already exists |
| # | 16:29:22 | bshum | (for example) |
| # | 16:36:57 | dbs | almost through creating a new 1.6.1.4 VM from scratch (including installing the base OS); might be able to get from start to finish in < 2 hours |
| # | 16:37:45 | bshum | Neat |
| # | 16:38:46 | bshum | Question, with a separate DB server, does it make a difference if you run an upgrade script from the box running EG compared to running it on the DB server directly? |
| # | 16:39:20 | bshum | I ask because doing the 1.6.1-2.0 upgrade last night on a standalone DB server resulted in a few extra fails due to missing perl components |
| # | 16:39:50 | bshum | Just trying to make sure I'm not doing it wrong. |
| # | 16:41:46 | bshum | (I've been testing concurrently with a single-server install & also poking at the standalone DB server as well) |
| # | 16:48:20 | dbs | standalone db server has always needed a few extra packages - it's possible with the additional database functions in 2.0 that we've missed adding some of them to the install docs |
| # | 16:49:22 | bshum | Bah, the paste doesn't like me today |
| # | 16:50:10 | bshum | http://paste.lisp.org/display/117112 |
| # | 16:50:16 | dbs | hmm. a quick scan of the upgrade script suggests Unicode::Encode or Unicode::Normalize, but those should be part of a core distro |
| # | 16:50:35 | dbs | lisppaste has been in and out of channel for the last few weeks |
| # | 16:50:41 | bshum | That's the one that it dies horribly on. |
| # | 16:51:09 | dbs | Right. So the install docs say you need MARC::File::XML on the standalone server |
| # | 16:51:31 | dbs | but I guess we need XML::LibXSLT too |
| # | 16:51:31 | bshum | I was pretty sure I had those installed, but maybe I missed one... hmm |
| # | 16:51:48 | bshum | Oh, okay, that one I've never seen before :) |
| # | 16:53:14 | dbs | try "aptitude libxml-libxslt-perl" |
| # | 16:53:41 | bshum | aptitude install? |
| # | 16:53:47 | dbs | err, yeah |
| # | 16:54:00 | eeevil_ | fwiw, I always just do a prereqs install on standalone db boxen |
| # | 16:54:09 | bshum | It's installing the new package now. |
| # | 16:54:31 | dbs | eeevil_: that's probably total overkill, but would certainly cover all the bases :) |
| # | 16:54:32 | eeevil_ | makes (the inevitable) running of client scripts on those boxen simpler |
| # | 16:54:54 | dbs | eeevil_: hey, we haven't run client scripts on our standalone db box yet... |
| # | 16:54:54 | bshum | Heh |
| # | 16:55:22 | eeevil_ | "hey, the db has tons of unused cores and ram, and we need the horsepower for that one-time batch operation..." ;) |
| # | 16:55:48 | dbs | Heresy! |
| # | 17:23:22 | bshum | Okay, re-ran with that libxml-libxslt-perl installed, and came across this one now: http://paste.lisp.org/+2ID4/1 |
| # | 17:25:02 | bshum | What's the downside (if any) for installing all the EG pre-reqs? Just bloat that we don't necessarily need, right? |
| # | 17:27:44 | dbs | bshum: start with the opensrf prereqs |
| # | 17:28:08 | dbs | ah, business::isbn, nice |
| # | 17:28:56 | dbs | you'll need Library::CallNumber::LC too |
| # | 17:29:24 | dbs | both CPAN installs: "cpan Business::ISBN" and "cpan Library::CallNumber::LC" |
| # | 17:29:37 | bshum | Alright. |
| # | 17:29:48 | dbs | also "cpan UUID::Tiny" |
| # | 17:31:15 | dbs is shocked by the default craftsman in 1.6.1.4 :) |
| # | 17:31:58 | bshum | Heh |
| # | 17:32:55 | bshum | Okay, installed those three additional modules using cpan. Waiting for the next DB reload to finish to try yet again. |
| # | 17:32:59 | bshum | Thanks dbs! |
| # | 17:33:48 | dbs | thanks bshum++ |
| # | 17:35:07 | dbs | one could argue that the downside of installing all of the other dependencies is more potential vulnerabilities, but that's a minor delta from having the same dependencies installed on a machine intimately connected to your database server |
| # | 17:43:59 | bshum | I think that did it. |
| # | 17:44:22 | bshum | Upgrade went through without any more pain. |
| # | 17:44:39 | bshum | Guess we just need to add those additional four pre-reqs to the standalone server install instructions. |
| # | 17:44:47 | dbs | added |
| # | 17:44:47 | bshum | For 2.0 at least. |
| # | 17:45:11 | bshum | dbs++ |
| # | 17:45:24 | dbs | bshum++ # not possible without you |
| # | 17:46:02 | dbs | and now I begin a long slow upload of the 1.6.1.4 image, once I write a simple README for it. should be better than the old 1.6.0.2 image that was floating around |
| # | 17:46:23 | bshum | Yay |
| # | 17:58:25 | dbs | http://evergreen-ils.org/~denials/Evergreen_1_6_1_4_Lenny.zip <-- in about 6 hours, knowing my DSL connection |
| # | 18:04:52 | mjg_1 has quit IRC |
| # | 18:23:04 | bshum | Alrighty folks, enjoy the rest of the day. See you later this week. |
| # | 18:23:13 | bshum has quit IRC |
| # | 19:09:30 | brendan2 has joined #evergreen |
| # | 19:32:31 | brendan2 has quit IRC |
| # | 20:00:13 | jeff | dbs++ # virtual images |
| # | 22:09:35 | dbs | Uploaded and downloads page is updated too. |
| # | 22:10:18 | dbs | Now I have no excuse for introducing bizarrely misformed SQL |
| # | 23:25:08 | dbs has quit IRC |
April 10-13