| Time |
Nick |
Message |
| 03:15 |
|
beanjammin joined #evergreen |
| 06:00 |
pinesol_green |
News from qatests: Test Success <http://testing.evergreen-ils.org/~live> |
| 07:20 |
|
agoben joined #evergreen |
| 08:13 |
|
tlittle joined #evergreen |
| 08:30 |
remingtron |
phasefx: Here's my branch adding basic docs-building to the tester script: |
| 08:30 |
remingtron |
http://git.evergreen-ils.org/?p=working/random.git;a=shortlog;h=refs/heads/user/rsteed/wheezy_installer |
| 09:14 |
|
Dyrcona joined #evergreen |
| 09:42 |
|
jvwoolf joined #evergreen |
| 09:46 |
|
jvwoolf left #evergreen |
| 09:56 |
dbs |
@later tell hbrennan That is, 'lib.hostname' in the OU settings |
| 09:56 |
pinesol_green |
dbs: The operation succeeded. |
| 09:56 |
|
kmlussier joined #evergreen |
| 09:57 |
|
jvwoolf1 joined #evergreen |
| 10:16 |
Bmagic |
We are getting this: <500> *** Call to [open-ils.storage.action.survey.required.atomic] failed for session [xxx], thread trace [1]:\nDBD::Pg::st execute failed: no connection to the server [for Statement \" |
| 10:16 |
Bmagic |
SELECT s.*\n FROM action.survey s\n JOIN actor.org_unit_full_path(?) p ON (p.id = s.owner)\n WHERE CURRENT_TIMESTAMP BETWEEN s.start_date AND s.end_date\n AND s.required IS TRUE; |
| 10:17 |
Bmagic |
when logging into the xul staff client |
| 10:17 |
Bmagic |
I have restarted all services, including postgres and memcached |
| 10:23 |
Bmagic |
Hmmmm, I think I got it worked out! |
| 10:24 |
jeff |
have you looked for signs of trouble in the postgres logs or signs of nothing being connected in netstat/lsof/the appropriate pg_* tables? |
| 10:24 |
jeff |
ah! good, because i was interrupted halfway through typing that last line. :-) |
| 10:25 |
* JBoyer |
sings -~Max connections?~- |
| 10:33 |
Bmagic |
It wasn't any of those things |
| 10:34 |
Bmagic |
I laughed when I realized what! I altered my hosts file manually on my workstation, so my testing was not to the production machines! Meanwhile, everyone else was happy... LOL |
| 10:34 |
phasefx |
remingtron++ |
| 10:34 |
Bmagic |
There was a problem though, and restarting the services fixed it, but I couldn't tell |
| 10:41 |
phasefx |
remingtron: I went ahead and pushed your commit to the collab branch. I don't mind folks pushing directly there; the test server uses that branch directly, so it's an easy way to test changes you're pretty confident in |
| 11:06 |
gsams |
running into an odd issue today, not able to upload authority records. osrferror log is showing 'unable to read MARC file' without any other input that I can see. |
| 11:06 |
gsams |
nfs shares are currently up and setup properly, there is space for storage |
| 11:07 |
gsams |
I'm importing authority records, and it worked just fine on the 9th. |
| 11:13 |
Dyrcona |
gsams: Have you tried yaz-marcdump on the file to check for errors? |
| 11:13 |
remingtron |
phasefx: okay, thanks, I'll keep that in mind for future changes. |
| 11:14 |
gsams |
Dyrcona: I have not, I will give that a whirl. |
| 11:20 |
dbs |
gsams: are you seeing the files landing on the share when you import them? |
| 11:21 |
gsams |
dbs: I'm not sure, but I don't think they are. I'll see about running a file through specifically to test that. |
| 11:22 |
|
_adb joined #evergreen |
| 11:26 |
gsams |
dbs: well I used marcedit to split the file I was uploading into 3 parts and it has created a new file on the share. |
| 11:27 |
gsams |
It's not processing the records though, it's stuck at 0% |
| 11:29 |
gmcharlt |
tossing out a suggestion for the maintenance releases - let's defer them to 11/29 rather than tomorrow if buildmasters are available then |
| 11:29 |
gmcharlt |
to incorporate some more bugfixes and to coordinate a major Hatch update |
| 11:29 |
gmcharlt |
I'd otherwise suggest 11/22, but that of course runs into U.S. Thanksgiving |
| 11:30 |
gsams |
dbs: looks like it just took a while. Perhaps the file I was attempting to load was too many records at once. |
| 11:32 |
miker |
gmcharlt: +1, for all those reasons you mention |
| 11:32 |
|
kmlussier joined #evergreen |
| 11:46 |
dbwells |
gmcharlt: 11/29 sounds good to me |
| 11:55 |
Bmagic |
I am confused. 3.0.1 - copy alert box is disabled with the cursor icon showing "do not enter" - How do I add a copy alert? |
| 11:55 |
|
Christineb joined #evergreen |
| 11:55 |
kmlussier |
Bmagic: Did you set workstation defaults for which fields should display in the copy editor? |
| 11:55 |
Bmagic |
no |
| 11:56 |
Bmagic |
it shows up but disabled |
| 11:56 |
kmlussier |
I saw the same thing on servers where I had previously set those defaults. See my comment at https://bugs.launchpad.net/evergreen/+bug/1720878/comments/2 |
| 11:56 |
pinesol_green |
Launchpad bug 1720878 in Evergreen "Button to apply copy tags is always disabled on some systems" [Undecided,New] |
| 11:56 |
|
beanjammin joined #evergreen |
| 11:56 |
kmlussier |
In that case, it was for copy tags. But I saw it happens with alerts too. |
| 11:57 |
Bmagic |
kmlussier: where do I set that setting? forgive me |
| 11:57 |
kmlussier |
It's one of the tabs in the copy editor. Maybe it's called 'defaults'? |
| 11:57 |
Bmagic |
hmm |
| 11:57 |
* kmlussier |
isn't looking at the client at the moment. |
| 11:58 |
Bmagic |
ha! That was it, weird |
| 11:58 |
kmlussier |
Yeah, I'm not sure if we should file a new bug on that or if I should update the description of that particular bug. I think those defaults should identify which fields should be disabled, rather than identifying which ones should be enabled. |
| 11:59 |
kmlussier |
Because that issue will arise every time we add a new field to the copy editor. |
| 11:59 |
Bmagic |
oh! That thing. I remember you talking about that in the car |
| 11:59 |
Bmagic |
and now I fully understand what you are talking about |
| 11:59 |
kmlussier |
Yes! On the way to the airport! |
| 12:11 |
|
khuckins joined #evergreen |
| 12:11 |
|
sandbergja joined #evergreen |
| 12:16 |
|
JBoyer joined #evergreen |
| 12:18 |
beanjammin |
I'm hoping someone can point me in the right direction. I'm just getting started on using angular and am not sure what EG data (if any) is available via javascript and how to access it. |
| 12:18 |
beanjammin |
I am trying to conditionally add a class to a row in the staff web client Items Out list at /eg/staff/circ/patron/16/items_out based on whether the item is overdue or not. I can see in t_autogrid.tt2 how the eg-grid-row-selected class is added via ng-class when the checkbox is checked, but I'm not sure how to do the same based on due date. Is items only available in perl/tt2 or is it or similar info available in js? If so, can I use |
| 12:18 |
beanjammin |
$scope.circIsOverdue from items_out.js to test? |
| 12:19 |
beanjammin |
Thanks for any pointers or doc suggestions. |
| 12:35 |
berick |
beanjammin: sounds like we need a new grid feature -- the ability to apply an arbitrary class to a row based on the row contents. |
| 12:36 |
|
krvmga joined #evergreen |
| 12:39 |
khuckins |
That would be a useful feature for other cards with similar purposes(off the top of my head I can think of lp1635386) as well |
| 12:41 |
|
collum joined #evergreen |
| 12:43 |
_adb |
GAH! |
| 12:44 |
_adb |
oops, sorry about that, here's a cat: https://i.imgur.com/ZD9KrFI.gifv |
| 12:44 |
berick |
price is 2 cats now |
| 12:44 |
* _adb |
grumbles about inflation |
| 12:44 |
_adb |
https://i.imgur.com/izL2ici.gif |
| 12:44 |
berick |
_adb++ |
| 12:45 |
beanjammin |
berick and khuckins: Is there documentation on what EG data is available in javascript and how to access it? |
| 12:48 |
khuckins |
For the items out grid, the function fetch_circs should give you more info on what's available, but it can vary beetween grids |
| 12:49 |
beanjammin |
khuckins: Thanks |
| 12:50 |
|
jihpringle joined #evergreen |
| 13:02 |
Dyrcona |
Ugh! Sometimes SQL is limiting..... |
| 13:04 |
Dyrcona |
I want to join two tables to a query and get results from both tables, but not results that are absent from both tables, but I want it to be the union of the two tables not the intersection of the two tables, and I'd really rather not have to use a UNION because that overly complicates things. |
| 13:05 |
Dyrcona |
And, to top it off, those table both join with a third table in the query. |
| 13:18 |
dbs |
Use WITH to consolidate the UNION as a "single table" and just join that to the third table? |
| 13:19 |
Dyrcona |
maybe.... Trouble is that this is optional and the query is build in real time, more or less in order in the code. |
| 13:20 |
Dyrcona |
I think I'm gonna go with the UNION when required and just modify the main query when not required. |
| 13:27 |
Dyrcona |
Basically, I'm opionally joining acn, acp, and auricnm, with possibly other limitations on the joins, so I think the union when both acp and auricnm are required is the "best" solution. |
| 13:41 |
JBoyer |
Yay "enterprise" installations that are missing registry entries. |
| 13:41 |
JBoyer |
Bonus: Yay Java. |
| 13:41 |
JBoyer |
Yay |
| 13:42 |
Dyrcona |
Yay...? :) |
| 14:10 |
|
annagoben joined #evergreen |
| 14:10 |
|
JBoyer_alt joined #evergreen |
| 14:37 |
|
stephengwills joined #evergreen |
| 14:44 |
|
rthimons joined #evergreen |
| 14:54 |
rthimons |
Could someone give me some pointers on proper process for migrating an evergreen database from one postgresql server to another? |
| 14:57 |
rthimons |
I've used pg_dump and pg_restore a great deal in the last few days so I'm familiar with the process, but following the standard instructions I'm getting a lot of missing functions and types on my new server |
| 14:59 |
|
jvwoolf joined #evergreen |
| 15:01 |
|
hbrennan joined #evergreen |
| 15:02 |
hbrennan |
dbs++ |
| 15:02 |
Dyrcona |
rthimons: You should install the prerequisites for the database on the database server. |
| 15:03 |
rthimons |
I ran the make file so I thought they would have already installed. |
| 15:04 |
Dyrcona |
You did make -f $PATH/src/extras/Makefile.install postgres-server-$distro ? |
| 15:04 |
rthimons |
I'll run it again just to be sure. I have several environments so it's possible I missed something. |
| 15:05 |
Dyrcona |
You probably need to load some extensions in the db also. I'm facing that on my testing server, I think. |
| 15:05 |
rthimons |
I'll run that make file one more time. Any suggestions on how to find the missing extensions? |
| 15:08 |
Dyrcona |
rthimons: Look in Open-ILS/src/sql/Pg/create_database_extensions.sql under your Evergreen directory. |
| 15:09 |
jeffdavis |
If you're using psql you can do \dx to check if the extensions in that file are actually installed on your new server. |
| 15:12 |
rthimons |
do you think I'll need to drop the database and restore it clean or could I just restore the schema over what's there? |
| 15:12 |
rthimons |
after verifying the extensions are there that is |
| 15:13 |
Dyrcona |
I usually use -C -c -d postgres which drops and recreates the database. |
| 15:13 |
Dyrcona |
If you're using -j, it might help to use a lower value. |
| 15:14 |
Dyrcona |
On pg_restore that is. |
| 15:14 |
Dyrcona |
I got some errors with the unaccent stuff earlier, but when I look the extension is in my database. |
| 15:15 |
Dyrcona |
So, I'm trying again with a lower value on -j. |
| 15:17 |
rthimons |
I definitely had that error as well. It was on some indexes. I went through an export of schema only and added the unaccent function manually |
| 15:17 |
rthimons |
I'll try restoring again and see what I get |
| 15:19 |
Dyrcona |
rthimons: bug 1671150 |
| 15:19 |
pinesol_green |
Launchpad bug 1671150 in Evergreen "Unqualified references in evergreen.unaccent_and_squash lead to index creation failures with pg_restore" [Undecided,In progress] https://launchpad.net/bugs/1671150 |
| 15:19 |
Dyrcona |
Says it's in progress but no one is working on it. |
| 15:19 |
rthimons |
so I'm not crazy :) |
| 15:20 |
rjackson_isl |
web clinet patron hold list question - noticing that holds for a patron do not show if Current Copy would be No Copy in the legacy staff client? Any way to have all holds show even if a copy has not been identified yet for the hold? |
| 15:20 |
Dyrcona |
rthimons: jeff updated a branch last week. I'll take a look. I think he's done. |
| 15:26 |
* Dyrcona |
messes with bug targets though it may not make it into tomorrow's releases. |
| 15:31 |
abneiman |
Dyrcona: gmcharlt miker & dbwells briefly discussed pushing monthlies back to 11/29 somewhere upthread. So you may have time! |
| 15:32 |
Dyrcona |
abneiman++ # I missed that. I stepped away to have some lunch. |
| 15:33 |
Dyrcona |
Testing this without messing with production will be interesting. |
| 15:33 |
Dyrcona |
I have extra db servers, but moving dumps around will require some networking gymnastics. ;) |
| 15:50 |
csharp |
Dyrcona: pg_basebackup from one of the free servers? |
| 15:50 |
csharp |
requires a bit-for-bit copy of the DB, but very quick and handy |
| 15:51 |
Dyrcona |
csharp: They're not on the same network, not even in the same building. |
| 15:51 |
csharp |
aha |
| 15:51 |
Dyrcona |
It will clobber the bandwidth. |
| 15:51 |
csharp |
of course ;-) |
| 15:51 |
csharp |
s/quick and handy/super damn slow in your case/ |
| 15:51 |
Dyrcona |
rsync with --bandwidth= is my best bet. |
| 15:52 |
Dyrcona |
Well, at one location the bandwidth is asymmetrical and that's the one that I'd be sending from, so I don't want to crush what others are doing. |
| 15:52 |
Dyrcona |
I've had that happen just sending marc records to the masslnc servers for testing. |
| 15:53 |
Dyrcona |
So, yeah, gymnastics are required. :) |
| 15:53 |
Dyrcona |
Hm... It happened on this testing server again with -j 4. |
| 15:54 |
Dyrcona |
I should see if it happens on the development server. |
| 16:43 |
|
gsams joined #evergreen |
| 17:00 |
pinesol_green |
News from qatests: Test Failure <http://testing.evergreen-ils.org/~live> |
| 17:01 |
bshum |
That's interesting that it failed again |
| 17:02 |
bshum |
On getting the postgresql apt repo key |
| 17:02 |
bshum |
It worked fine this morning, but not in the afternoons. I wonder why. Hmm. |
| 17:02 |
bshum |
Something to study later. |
| 17:27 |
jeff |
bshum: cipher suite mismatch -- some of the servers support a cipher suite that wget + gnutls on wheezy can support, but others do not. |
| 17:27 |
jeff |
bshum: depending on which one is returned by DNS, you either fail or not. |
| 17:27 |
csharp |
@band add Cipher Suite Mismatch |
| 17:27 |
pinesol_green |
csharp: Band 'Cipher Suite Mismatch' added to list |
| 17:28 |
jeff |
at present, only zetar.postgresql.org is claiming support for TLS_DHE_RSA_WITH_AES_128_CBC_SHA256 |
| 18:50 |
csharp |
comcast-- |
| 18:50 |
csharp |
comcast-- |
| 18:50 |
csharp |
comcast-- |
| 19:23 |
|
beanjammin joined #evergreen |
| 19:44 |
|
jvwoolf joined #evergreen |
