| # | Time | Nick | Message |
|---|
| # | 00:10:05 | sndwrx has joined #evergreen |
| # | 06:01:03 | lisah___ has joined #evergreen |
| # | 06:07:36 | lisah___ has quit IRC |
| # | 06:15:40 | wlayton has joined #evergreen |
| # | 06:54:21 | wlayton has quit IRC |
| # | 08:01:33 | csharp | okay - quick "how we use git in Evergreen" question... |
| # | 08:02:16 | csharp | I would like to start tracking PINES changes from a downloaded Evergreen repo - should I create a branch? or a new project? or what? |
| # | 08:03:00 | csharp | ideally we would push our changes to our own branch/project/section of git.evergreen-ils.org |
| # | 08:14:34 | csharp | okay - looking at the project list on the git start page, we would probably want something like evergreen/pines.git |
| # | 08:16:14 | tsbere | csharp: To get your changes from the downloaded repo you probably want to patchify them |
| # | 08:16:40 | tsbere | If they aren't patchified already |
| # | 08:17:17 | csharp | they aren't yet |
| # | 08:18:05 | tsbere | If they are literally just edited files in a dumped tarball then I would recommend checking out the same version from git (by tag), overwriting everything in the repo, then git adding any files you *created* followed by a git commit -a to get all the changes. This will create one giant commit of "Pines Changes" as a starting point, at least. |
| # | 08:18:05 | csharp | my short term goal is to take rel_2_1_0 and patch it with our changes and push it somewhere |
| # | 08:18:31 | csharp | tsbere: okay - that's what I'm after |
| # | 08:19:00 | tsbere | If you have discrete changes you know how to apply manually (or are the only changes to a file) you can do it in chunks instead |
| # | 08:19:15 | tsbere | Which I find to be easier. I keep multiple branches for MVLC customizations, in fact. |
| # | 08:19:43 | csharp | well, I have a good amount of organization to do, but I wanted to start with our tweaks to the upgrade scripts |
| # | 08:19:48 | tsbere | At least one of those branches is maintained by Dyrcona, actually, and has to be kept in a "private" repo. It contains all of our SIP config (with passwords) |
| # | 08:19:57 | csharp | I see |
| # | 08:21:17 | tsbere | If you want to keep things you aren't concerned with, like skin tweaks and such, that don't have passwords or other sensitive things included on git.evergreen-ils.org in a public area then you will need to do two things |
| # | 08:21:33 | tsbere | One is get us a pubkey, because I don't see you in the list yet |
| # | 08:21:46 | tsbere | The other is ask for a repo area |
| # | 08:22:02 | csharp | tsbere: that's what I was after ;-) |
| # | 08:22:13 | tsbere | Each person you want to be able to access the repo for writing will need a pubkey on the server, if they don't have one already. |
| # | 08:22:41 | tsbere | And if you use more than one pubkey, say from different machines, you can send them all in |
| # | 08:22:50 | csharp | great |
| # | 08:23:23 | csharp | tsbere: would one big text file with them (one per line) work? |
| # | 08:24:01 | tsbere | If they are in openssh format (for inclusion in authorized_keys) then yes. I suppose you could just hand me an authorized keys file, actually. I will need to split it into chunks, but that isn't hard. |
| # | 08:24:26 | csharp | yeah - that's what they would be |
| # | 08:24:33 | csharp | okay - works for me |
| # | 08:24:38 | tsbere | gmcharlt: If you are around, I will take care of csharp's stuff here ;) |
| # | 08:24:45 | csharp | tsbere: thanks (as always ;-)) |
| # | 08:24:54 | tsbere | csharp: Easiest way to get it in is probably to email it to the gitadmins address |
| # | 08:25:37 | csharp goes off to gather keys |
| # | 08:27:19 | tsbere | Do you want the repo to only mirror master automatically, or would you like it if the repo itself duped rel_2_1 from the official repo as well? |
| # | 08:27:44 | csharp | to be honest - I don't know ;-) |
| # | 08:28:19 | csharp | managing a single release is my short term goal, but I'd like room to expand ;-) |
| # | 08:29:05 | csharp | if the repo mirrors master, does that include all backports, etc. to each of the branches, or just changes to master? |
| # | 08:29:42 | tsbere | Just changes to master |
| # | 08:29:50 | csharp | mkay |
| # | 08:29:57 | tsbere | Take note you can always have other repos as remotes anyway |
| # | 08:30:01 | mrpeters-isl | csharp: http://git.evergreen.lib.in.us/git/?p=Evergreen.INCustom/Evergreen/.git;a=summary |
| # | 08:30:04 | tsbere has a small pile of remotes, in fact |
| # | 08:30:48 | csharp | mrpeters-isl: yes - that's the kind of thing I'm after |
| # | 08:30:53 | mrpeters-isl | tsbere taught me cherry-picking all of our customizations into the heads for rel_2_0 and that made it super easy to apply our changes to rel_2_1, master, and beyond |
| # | 08:31:07 | csharp is using git day to day, but has not gotten in deep |
| # | 08:31:20 | tsbere | mrpeters-isl: Did you want that to get auto-updating master fun? |
| # | 08:31:31 | csharp has a bunch of tutorials open in tabs in his browser right now ;-) |
| # | 08:31:36 | mrpeters-isl | i haven't yet |
| # | 08:31:44 | mrpeters-isl | csharp: how are your customizations tracked now? |
| # | 08:32:01 | csharp | mrpeters-isl: patches are dumped into a github repo |
| # | 08:32:10 | mrpeters-isl | ok, thats good |
| # | 08:32:14 | tsbere | mrpeters-isl: Specifically, do you want that added to the list of places that get a copy of anything that changes in master? We have a list. :P |
| # | 08:32:15 | csharp | patches/files/readmes, etc. |
| # | 08:32:22 | csharp | not very well organized |
| # | 08:32:28 | mrpeters-isl | i think you could add your github as a remote and cherry pick from it |
| # | 08:32:34 | csharp | ah |
| # | 08:32:49 | mrpeters-isl | so, each commit has a hash |
| # | 08:33:09 | mrpeters-isl | git-cherry-pick somehash |
| # | 08:33:25 | mrpeters-isl | sometimes they merge right in, sometimes you have to do some manual editing to resolve differences |
| # | 08:33:38 | mrpeters-isl | tsbere: i'd be down for that |
| # | 08:33:43 | csharp | cool |
| # | 08:34:10 | _bott_ has quit IRC |
| # | 08:34:12 | tsbere | csharp: IF you use git cherry-pick -n it will grab the changes, but not commit them. Useful if you want to combine several changes, or if you are literally grabbing patch files to apply (and then delete) |
| # | 08:34:18 | AaronZ-PLS has joined #evergreen |
| # | 08:34:36 | mrpeters-isl | csharp: http://www.vogella.de/articles/Git/article.html#github |
| # | 08:35:14 | _bott_ has joined #evergreen |
| # | 08:35:20 | mrpeters-isl | so i'd start a repo called Evergreen.GACustom or something |
| # | 08:35:21 | tsbere dislikes github for reasons of "you can't use these tools with github" notes that they have, despite being able to use said tools. Easily. |
| # | 08:35:32 | mrpeters-isl | then git clone git://git.evergreen-ils.org/Evergreen.git into it |
| # | 08:39:57 | mrpeters-isl | from there, you'd then start with a branch based on whatever release you're upgrading to |
| # | 08:40:33 | mrpeters-isl | so, say git checkout --force -b rel_2_0_4 refs/heads/rel_2_0 |
| # | 08:40:56 | mrpeters-isl | and then start applying your patches |
| # | 08:43:02 | plux_ has joined #evergreen |
| # | 08:43:42 | mrpeters-isl | one thing is for sure, csharp -- it's WELL worth the effort to do what you're planning |
| # | 08:52:33 | csharp | mrpeters-isl: yeah - I've been planning to do it for a long time - our current project requires it ;-) |
| # | 08:53:09 | csharp got tired of digging around in his github repo for this or that patch |
| # | 08:55:01 | mrpeters-isl | you could also get all of your patches from git hub and "git-apply foo.patch" to whatever branch |
| # | 08:55:21 | jenny has joined #evergreen |
| # | 08:55:46 | mrpeters-isl | and then when it comes time to apply them all to say, rel_2_1, you can just git-cherry-pick across your local branches |
| # | 08:56:10 | csharp | nice |
| # | 08:59:34 | tsbere | mrpeters-isl loves git since I helped him convert to it ;) |
| # | 08:59:45 | mrpeters-isl | yep...you saved me |
| # | 09:07:07 | gmcharlt | csharp: keys received (it's gitadmin@) |
| # | 09:07:49 | tsbere | Did he send them to the wrong location? |
| # | 09:07:58 | csharp | gmcharlt: got it |
| # | 09:08:00 | tsbere has a starter set of config changes ready to go |
| # | 09:08:12 | gmcharlt | tsbere: check your email |
| # | 09:09:43 | tsbere | Hmmm. Seems to have been greylisted. Did the server handling the git admin account change IPs? |
| # | 09:09:52 | tsbere | Or was it sent more directly and thus bypassed said server? |
| # | 09:10:05 | gmcharlt | csharp had sent it to us directly |
| # | 09:10:25 | tsbere | ahhh. That would explain why it was greylisted, then. |
| # | 09:12:01 | csharp | gmcharlt: tsbere: in case it makes a difference in what you're setting up, we would also probably be committing our packaging materials and other automating scripts to projects within that same space if possible |
| # | 09:12:48 | tsbere | The way I am setting it up the entire repo aside from "master" will be yours to create stuff in anyway. If you want a second repo for some of your other stuff, though, I can add that in. |
| # | 09:13:02 | gmcharlt | csharp: that probably calls for an additional contrib/GPLS.git repo, then |
| # | 09:13:28 | gmcharlt | unless all of that other stuff is expressible as a topic branch against the Evergreen source tree |
| # | 09:14:10 | gmcharlt | or contrib/PINES.git, however you want it named |
| # | 09:14:20 | csharp | gmcharlt: it's not - I think a contrib branch would be more appropriate |
| # | 09:14:32 | csharp | that name works for me |
| # | 09:14:45 | gmcharlt | which one? |
| # | 09:14:49 | csharp | sorry :-0 |
| # | 09:14:59 | csharp | let's use PINES |
| # | 09:15:06 | gmcharlt | :) |
| # | 09:15:27 | tsbere was already using "pines" anyway in the config file |
| # | 09:19:07 | tsbere | gmcharlt: I could throw the config changes in and let you deal with the keys. You might like my keyconvert.sh file, though, to split a file full of one person's keys into individual files. |
| # | 09:19:32 | gmcharlt | tsbere: I'll handle the keys, then |
| # | 09:19:46 | tsbere hates waiting for the greylister |
| # | 09:20:33 | kmlussier has joined #evergreen |
| # | 09:22:48 | gmcharlt | csharp: I see that one of the keys is a personal one - should the rest be named generic pines keys? |
| # | 09:22:59 | tsbere | gmcharlt: I pushed the config. And my keyconvert, if you want it. |
| # | 09:23:09 | csharp | gmcharlt: sure |
| # | 09:26:12 | tsbere | And automatic updating of the "master" branch is active :D |
| # | 09:27:43 | gmcharlt | csharp: ok, you should be all set up |
| # | 09:28:43 | gmcharlt | git urls are git@git.evergreen-ils.org:contrib/pines.git and git@git.evergreen-ils.org:evergreen/pines.git |
| # | 09:28:45 | csharp | gmcharlt++ |
| # | 09:28:52 | csharp | tsbere++ |
| # | 09:28:53 | csharp | thanks! |
| # | 09:33:16 | csharp | so I've cloned the repo... how would I bring in tags/rel_2_1_0 from Evergreen.git? |
| # | 09:33:47 | mrpeters-isl | git checkout --force -b rel_2_1_0 tags/rel_2_1_0 |
| # | 09:34:03 | mrpeters-isl | at least...i think thtas the right path...going from memory |
| # | 09:34:07 | tsbere | git add egils git://git.evergreen-ils.org/Evergreen; git fetch egils; git checkout -b rel_2_1_0 egils/tags/rel_2_1_0 |
| # | 09:34:23 | tsbere | Then git push origin rel_2_1_0 |
| # | 09:34:27 | tsbere | (or make changes then push) |
| # | 09:34:39 | tsbere | Oh, git remote add, not git add |
| # | 09:34:40 | tsbere | < |
| # | 09:34:42 | tsbere | *<_< |
| # | 09:34:48 | tsbere got ahead of himself when typing |
| # | 09:36:40 | csharp is giddy with excitement |
| # | 09:36:51 | csharp | this'll be awesome |
| # | 09:37:16 | csharp | forgot |
| # | 09:37:20 | csharp | mrpeters-isl++ |
| # | 09:38:36 | mrpeters-isl | has anyone considered updating eg.conf (Apache2) to prevent against the BEAST attacks? I patched ours, but thought maybe it'd be worth sharing here. Something for the Security team, perhaps? |
| # | 09:40:25 | gmcharlt | well, it's kinda out now, isn't it |
| # | 09:40:32 | gmcharlt | sec, I'll give you a patch to test and sign off on |
| # | 09:40:45 | mrpeters-isl | i've actually got it in a branch |
| # | 09:40:47 | mrpeters-isl | just need to push it |
| # | 09:40:48 | sfortin has joined #evergreen |
| # | 09:40:55 | eeevil | mrpeters-isl: if you have attack detail, please start by opening a security bug |
| # | 09:41:08 | eeevil | in the future, obv |
| # | 09:41:24 | mrpeters-isl | ok, apologies. didn't realise i could. |
| # | 09:41:29 | csharp | okay - now to the issue that opened the git can of worms for me... |
| # | 09:41:35 | tsbere | I thought this was a generic apache issue, more than an evergreen issue. |
| # | 09:41:49 | gmcharlt | tsbere: indeed |
| # | 09:41:55 | csharp | in the 2.0-2.1 upgrade script, it fails on CREATE OR REPLACE FUNCTION actor.usr_purge_data |
| # | 09:42:23 | tsbere doesn't see why we would need to "hide" security issues that are public on the upstream of the third party stuff we use |
| # | 09:42:40 | csharp digs for the error message |
| # | 09:43:21 | eeevil | tsbere: it's not about hiding them, per se, but allowing a coordinated message to be crafted that's specific to normal EG setups |
| # | 09:43:46 | eeevil | and it confers some priority to the problem |
| # | 09:43:53 | eeevil | IMO, at least |
| # | 09:44:46 | mrpeters-isl | i just happened to catch it yesterday when updating SSL certs |
| # | 09:45:03 | mrpeters-isl | thought i'd share but yeah, my bad should have done it more privately |
| # | 09:48:40 | csharp | psql:2.0-2.1-upgrade-db.sql:636: ERROR: cannot change name of input parameter "dest_usr" |
| # | 09:48:55 | csharp | that's what I've got that I'm hanging on |
| # | 09:49:21 | mrpeters-isl | csharp: https://bugs.launchpad.net/evergreen/+bug/725809 |
| # | 09:49:37 | csharp | heh |
| # | 09:49:53 | csharp really should read the massive amount of bug notification emails he gets |
| # | 09:50:06 | mrpeters-isl | Dr. Google wins again! |
| # | 09:50:13 | csharp | mrpeters-isl: thanks |
| # | 09:50:38 | mrpeters-isl | i always just search open-ils and my error and I can usually find a log from here, or a bug ticket |
| # | 09:50:50 | csharp | hmm - seems that like that would've been fixed in rel_2_1_0, though |
| # | 09:51:04 | mrpeters-isl | yeah, but maybe the same concept applies for fixing it this time too? |
| # | 09:51:15 | csharp | no - I'm sure that's right |
| # | 09:51:22 | csharp | it was what I was going to try anyway ;-) |
| # | 10:04:33 | Dyrcona has joined #evergreen |
| # | 10:04:59 | leed has joined #evergreen |
| # | 10:05:07 | Dyrcona thinks it might be useful if staff could manage their own or shared book bags from the client. |
| # | 10:06:01 | eeevil | Dyrcona: they can't? |
| # | 10:06:17 | Dyrcona | eeevil: If they can, then I don't know how. |
| # | 10:06:29 | eeevil | in the embedded opac? |
| # | 10:06:44 | Dyrcona | eeevil: doh. why didn't I try that? |
| # | 10:07:23 | Dyrcona | eeevil++ |
| # | 10:07:34 | Dyrcona | for pointing out the obvious. :p |
| # | 10:07:38 | eeevil | I do what I can |
| # | 10:07:44 | tsbere | Looks like the uncoded failures fix made SIP happier for us :D |
| # | 10:07:55 | Dyrcona | tsbere++ |
| # | 10:08:07 | Dyrcona | Does it fix the problem that you mentioned to me yesterday? |
| # | 10:08:13 | tsbere | Still some annoying GIGO errors from SIPServer itself. |
| # | 10:08:46 | tsbere | Dyrcona: looks like it. I saw two apparently complete success entries in the logs. |
| # | 10:09:01 | tsbere | Within minutes of restarting SIP with the new code |
| # | 10:10:05 | Dyrcona | Good to know. |
| # | 10:10:29 | Dyrcona | I may actually use my home_ou today. |
| # | 10:10:37 | Dyrcona | They have a book in reshelving that I want. |
| # | 10:13:17 | csharp | sorry for the git newbie questions, but I would like to "branch a branch", meaning that I would like to create multiple branches of rel_2_1_0 (one for general customizations, one for skin development, etc.) |
| # | 10:13:43 | Dyrcona | git checkout -b new_branch old_branch |
| # | 10:13:51 | csharp | Dyrcona: ah - that's it |
| # | 10:13:52 | csharp | thanks |
| # | 10:13:53 | tsbere | csharp: git checkout -b newbranch egils/tags/rel_2_1_0 with whatever newbranch names you want |
| # | 10:14:01 | tsbere | csharp: Then later you can git merge them all together ;) |
| # | 10:14:03 | csharp | excellent |
| # | 10:17:04 | Dyrcona | gah! "Authentication is required to print....." |
| # | 10:17:20 | Dyrcona mumbles something about cupsd and Oneiric.... |
| # | 10:20:55 | Dyrcona goes looking for a #samba channel. |
| # | 10:25:39 | leed has quit IRC |
| # | 10:25:51 | leed has joined #evergreen |
| # | 10:28:39 | sal_ has joined #evergreen |
| # | 10:28:48 | tsbere | Hmmm |
| # | 10:29:31 | tsbere | We have 11703 circs that have 0.00 owed and have a checkin time, but have no xact_finish time. Is this normal? |
| # | 10:29:45 | mrpeters-isl | tsbere: i think we have the same situation a lot |
| # | 10:29:46 | Dyrcona gets nervous whenever tsbere goes "hmm." |
| # | 10:35:14 | tsbere | mrpeters-isl: How do you deal with it, normally? |
| # | 10:35:56 | mcarlson has quit IRC |
| # | 10:35:56 | b_bonner has quit IRC |
| # | 10:35:56 | mrpeters-isl | to be honest, it usually ends up being a deal where someone spots it (say, a Claims Returned still showing up after all billings paid) and reports it to our helpdesk |
| # | 10:36:07 | tsbere | and what do they do to fix it? |
| # | 10:36:29 | mrpeters-isl | we just set xact_finish to a date that makes sense, such as the date of the final payment |
| # | 10:36:45 | tsbere | That was what I was thinking about doing. |
| # | 10:37:37 | b_bonner has joined #evergreen |
| # | 10:37:44 | mrpeters-isl | what query did you use to identify them? |
| # | 10:38:02 | tsbere | select * from money.materialized_billable_xact_summary mmbxs JOIN action.circulation USING (id) WHERE checkin_time IS NOT NULL AND balance_owed = 0.00 AND mmbxs.xact_finish IS NULL |
| # | 10:38:07 | mcarlson has joined #evergreen |
| # | 10:38:44 | mrpeters-isl | k let me see how bad it is for us |
| # | 10:39:21 | mrpeters-isl | i'm thinking https://bugs.launchpad.net/evergreen/+bug/758982 is maybe one of the causes as well |
| # | 10:40:01 | mrpeters-isl | heh 62,070 for us |
| # | 10:40:25 | tsbere | I have a query to "fix" them ready to go. Want that? |
| # | 10:40:44 | mrpeters-isl | yeah i'd be curious...but i need to ponder if i want to run it or not haha |
| # | 10:41:04 | tsbere | Add "UPDATE action.circulation SET xact_finish = COALESCE(x.last_billing_ts, x.checkin_time) FROM (" before that query and ")x" after it |
| # | 10:41:28 | tsbere | No, wait, I need a join on the id |
| # | 10:41:36 | tsbere opens the file again |
| # | 10:41:55 | tsbere | Oh, I have a where clause on the next line. |
| # | 10:42:46 | tsbere | WHERE circ.id = x.id ... I think I need to alias action.circulation as "circ" too or this is gonna error out |
| # | 10:44:16 | lisah___ has joined #evergreen |
| # | 10:46:01 | mrpeters-isl | i guess for me to be comfortable, we need to figure out if there is ever a valid reason to have xact_finish like this |
| # | 10:53:26 | Dyrcona wonders if it would be an Evergreen staff client bug or a XulRunner bug that the client cannot print to servers that require authentication. |
| # | 10:54:14 | Dyrcona doesn't get the driver's authentication dialog on Ubuntu Oneiric from the staff client, but does get it in Chromium, etc. |
| # | 10:55:06 | mrpeters-isl | Dyrcona: wouldn't printing from firefox work similarly? does that let you print on that server? |
| # | 10:57:07 | Dyrcona doesn't use firefox, but its likely installed will check after switching to a postscript driver....PCL 3 gives me some garbage. |
| # | 10:59:19 | mrpeters-isl | i think it is by default in ubuntu |
| # | 11:01:03 | Dyrcona | mrpeters-isl: I switched to Chromium to try it out and I liked it enough to make it my default browser. |
| # | 11:01:21 | Dyrcona | Firefox prompts for the password, but the staff client doesn't. |
| # | 11:01:42 | mrpeters-isl | newer xulrunner in FF probably |
| # | 11:02:00 | Dyrcona | I have also found Oneiric to be rather buggy in many ways that Natty wasn't, just in case anyone is thinking of upgrading. |
| # | 11:03:23 | Dyrcona | Yes, most likely. I am using the 1.9.2.22 XulRunner that gets bundled with the linux client builds. |
| # | 11:04:21 | Dyrcona | Firefox is version 7.0.1, so definitely a newer XUL runtime there. |
| # | 11:05:15 | Dyrcona | Ah well, just means I can't print from the client on my laptop for the time being. Carry on with your more important discussions. :) |
| # | 11:07:02 | csharp | okay when running the PG 9.1 re-req scripts, hstore was not installed for some reason... |
| # | 11:07:58 | csharp | I see three files in /usr/share/postgresql/9.1/extenstion: hstore--1.0.sql, hstore--unpackaged--1.0.sql and hstore.control - does anyone know which one I want? |
| # | 11:08:11 | mrpeters-isl | let me look at my notes csharp |
| # | 11:08:59 | tsbere | csharp: Just use the create extension command? |
| # | 11:09:29 | csharp | tsbere: ah |
| # | 11:09:50 | mrpeters-isl | yeah i think i just did CREATE EXTENSION hstore; |
| # | 11:10:00 | csharp | that would make sense with what I'm seeing - looks like more of a packaging system than before |
| # | 11:10:21 | mrpeters-isl | csharp: http://developer.postgresql.org/pgdocs/postgres/sql-createextension.html |
| # | 11:11:07 | csharp | good |
| # | 11:11:24 | csharp | that's a much better way to do it |
| # | 11:11:27 | granitize has joined #evergreen |
| # | 11:25:39 | tspindler has joined #evergreen |
| # | 11:44:52 | yboston has joined #evergreen |
| # | 11:46:05 | granitize has left #evergreen |
| # | 11:54:06 | granitize has joined #evergreen |
| # | 12:22:24 | plux_ has quit IRC |
| # | 12:29:04 | granitize has left #evergreen |
| # | 12:30:22 | plux_ has joined #evergreen |
| # | 12:31:29 | AaronZ-PLS has quit IRC |
| # | 12:36:52 | AaronZ-PLS has joined #evergreen |
| # | 12:55:52 | sal_ has quit IRC |
| # | 13:13:09 | csharp | okay - another git/installation question... we have several files that we add (/openils/conf/lib_ips.txt, /openils/var/data/zips.txt, for instance)... If I place them in the source tree appropriately, will they be installed correctly, or do I have to tell a makefile or something about them? |
| # | 13:14:11 | tsbere | I think if you place them properly they will get installed. Although I also think we just edit the .example files anyway. |
| # | 13:14:26 | tsbere | But I dunno about data/ there |
| # | 13:14:34 | csharp | ok |
| # | 13:24:52 | sal_ has joined #evergreen |
| # | 13:49:02 | sal_ has quit IRC |
| # | 13:51:22 | sal_ has joined #evergreen |
| # | 13:59:01 | lisah___ has quit IRC |
| # | 14:13:00 | jeffdavis has quit IRC |
| # | 14:31:45 | lisah___ has joined #evergreen |
| # | 14:45:12 | AaronZ-PLS has quit IRC |
| # | 14:52:55 | jeffdavis has joined #evergreen |
| # | 14:53:51 | jenny has left #evergreen |
| # | 15:17:58 | sal_ has quit IRC |
| # | 15:45:30 | granitize has joined #evergreen |
| # | 15:45:54 | granitize has left #evergreen |
| # | 15:49:39 | tspindler has quit IRC |
| # | 15:53:22 | youdonotexist has joined #evergreen |
| # | 16:04:59 | plux_ has quit IRC |
| # | 16:15:17 | sfortin has quit IRC |
| # | 16:46:43 | kmlussier has quit IRC |
| # | 16:58:41 | sal_ has joined #evergreen |
| # | 17:32:31 | leed has quit IRC |
| # | 17:42:36 | yboston has quit IRC |
| # | 18:05:23 | leed has joined #evergreen |
| # | 18:07:43 | Dyrcona has quit IRC |
| # | 18:21:43 | leed has quit IRC |
| # | 18:27:18 | csharp is bitten by the bug agJohn reported the other day: https://bugs.launchpad.net/evergreen/+bug/881774 |
| # | 18:27:35 | csharp | ERROR: function array_remove_item_by_value(text[], unknown) does not exist |
| # | 18:28:07 | csharp | looks like it may need to be evergreen.array_remove_item_by_value(), but I don't know |
| # | 18:30:24 | lisah___ has quit IRC |
| # | 18:39:36 | youdonotexist has quit IRC |
| # | 18:48:29 | tsbere | csharp: Perhaps you should do a ALTER DATABASE <dbname> SET search_path=evergreen, public, pg_catalog; |
| # | 18:55:24 | AaronZ-PLS has joined #evergreen |
| # | 18:57:30 | AaronZ-PLS has quit IRC |
| # | 19:00:10 | jeffdavis has quit IRC |
| # | 19:01:18 | jeffdavis has joined #evergreen |
| # | 19:23:33 | csharp | tsbere: thanks - will try |
| # | 19:25:36 | csharp | hmmm - more may be off than just that: NOTICE: schema "evergreen" does not exist |
| # | 19:25:48 | tsbere | Hmmm. That is a good point on problem front. |
| # | 19:25:49 | tsbere | Gimme a min |
| # | 19:27:15 | tsbere | Hmmm. The upgrade script includes "SELECT evergreen.change_db_setting('search_path', ARRAY['evergreen','public','pg_catalog']);" which should be triggering that anway. |
| # | 19:27:29 | tsbere | *anyway |
| # | 19:27:45 | csharp | huh |
| # | 19:27:50 | tsbere | Unless that isn't working? |
| # | 19:28:07 | tsbere | Are you running the script with superuser rights? |
| # | 19:28:12 | csharp | yes |
| # | 19:28:17 | tsbere | hmm |
| # | 19:29:27 | csharp reviews the postgres log |
| # | 19:32:15 | csharp | nope - no mention of evergreen in the log |
| # | 19:32:25 | tsbere | Which may just mean it worked |
| # | 19:32:34 | csharp | it's the first frickin' line in the script CREATE SCHEMA evergreen; |
| # | 19:34:16 | csharp | psql:2.0-2.1-upgrade-db.sql:5: ERROR: schema "evergreen" already exists |
| # | 19:34:25 | csharp | so maybe I was in the wrong db |
| # | 19:34:29 | tsbere | ok |
| # | 19:34:31 | csharp | postgres maybe? |
| # | 19:34:53 | tsbere | What is your current search path? |
| # | 19:35:42 | tsbere | I think you can get it via "SHOW search_path;" when in your EG database |
| # | 19:36:15 | csharp | yeah - it works now |
| # | 19:36:43 | csharp | I was in postgres's db |
| # | 19:36:49 | csharp | so that was the issue |
| # | 19:37:02 | csharp cranks the script back up |
| # | 19:39:40 | wlayton has joined #evergreen |
| # | 20:23:15 | sndwrx has quit IRC |
| # | 20:27:09 | sndwrx has joined #evergreen |
| # | 21:02:26 | wlayton has quit IRC |