October 2015 - Koha-bugs - lists.koha-community.org

[Bug 13665] New: Retrieve facets from zebra is slow
by bugzilla-daemon＠bugs.koha-community.org 26 Oct '15

26 Oct '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13665 Bug ID: 13665 Summary: Retrieve facets from zebra is slow Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Searching Assignee: gmcharlt(a)gmail.com Reporter: jonathan.druart(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org Depends on: 11232 With a 1 million biblio records installation (MARC21 + DOM), a search is very slow if facets are retrieved from zebra. Debugging, I found where the processing time is spent: In C4::Search::_get_facet_from_result_set, the line my $facet = $rs->record( 0 )->raw; can spent up to 3 seconds! Actually it's the ->record call, not the ->raw. In ZOOM->record, the time is spent in my $_rec = Net::Z3950::ZOOM::resultset_record($this->_rs(), $which); I stopped the track game at this point. So for instance, with a facet holdingbranch, (FacetMaxCount set to 20) the element zebra::facet::su-to:0:20" is set, $rs->size returns 962076, and the total execution time for _get_facet_from_result_set (only for this facet!) is 3.2sec. If I set FacetMaxCount to 1, I got: 0.3 sec, for 10: 1.67. So quite linear. Lets compare with yaz-client: Z> open unix:/home/koha/var/run/zebradb/bibliosocket Connecting...OK. Sent initrequest. Connection accepted by v3 target. ID : 81 Name : Zebra Information Server/GFS/YAZ Version: 4.2.30 98864b44c654645bc16b2c54f822dc2e45a93031 Options: search present delSet triggerResourceCtrl scan sort extendedServices namedResultSets Elapsed: 0.009150 Z> base biblios Z> format xml Z> elem zebra::facet::holdingbranch:0:20 Z> f d Sent searchRequest. Received SearchResponse. Search was a success. Number of hits: 809470, setno 1 SearchResult-1: term=d cnt=809470 records returned: 0 Elapsed: 0.078905 Z> s 1+1 Sent presentRequest (1+1). Records: 1 Record type: XML <record xmlns="http://www.indexdata.com/zebra/"> <facet type="0" index="holdingbranch"> <term coccur="941" occur="103144">br1</term> [...] </facet> </record> nextResultSetPosition = 2 Elapsed: 1.393694 To compare with the old facet method, I calculated the time spend in C4::Search::GetFacets (for 20 facets): >From zebra (new): 9.3sec >From Records (old): 0.16sec (with maxRecordsForFacets = 20) >From Records (old): 1.85sec (with maxRecordsForFacets = 100) >From Records (old): 15.1sec (with maxRecordsForFacets = 1000) Note that the machine is a test machine (VE) and is quite slow. Firebug tells me that with the new method (20 facets), the total load page is ~30sec, with the old method (20 facets calculated from 20 records) is 8-9sec -- You are receiving this mail because: You are watching all bug changes.

1 9

[Bug 15060] New: Setup standard ISBD view
by bugzilla-daemon＠bugs.koha-community.org 26 Oct '15

26 Oct '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15060 Bug ID: 15060 Summary: Setup standard ISBD view Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: z.tajoli(a)cineca.it QA Contact: testopia(a)bugs.koha-community.org For MARC21 setups the default sys prefer ISBD doesn't create a standard ISBD in title area. Now the default is: #245||{ 245a }{ 245b }{245f }{ 245g }{ 245k }{ 245n }{ 245p }{ 245s }{ 245h }|\r\n #246||{ : 246i }{ 246a }{ 246b }{ 246f }{ 246g }{ 246n }{ 246p }{ 246h }|\r\n #242||{ = 242a }{ 242b }{ 242n }{ 242p }{ 242h }|\r\n #245||{ 245c }|\r\n #242||{ = 242c }|\r\n We mix 245 tag in 242 (Translation of Title by Cataloging Agency) and 246 (Varying Form of Title). I think is very difficult to have valuse in 242 and/or 256 with an empty 245. I suggest to insert only #245||{ 245a }{ 245b }{245f }{ 245g }{ 245k }{ 245n }{ 245p }{ 245s }{ 245h }|\r\n #245||{ 245c }|\r\n in default sys pref ISBD -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14584] New: Encoding broken with system preferences
by bugzilla-daemon＠bugs.koha-community.org 26 Oct '15

26 Oct '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14584 Bug ID: 14584 Summary: Encoding broken with system preferences Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: philippe.blouin(a)inlibro.com QA Contact: testopia(a)bugs.koha-community.org This bug is related to #12411 and #11944, since then pushed to master. Whatever we enter with accents in NoLoginInstructions is displayed as gibberish because it ends up being encoded TWICE. It was not doing that before. My solution is to modify Koha::Template::Plugin::Koha::Preference. It might be naive and missing all the changes done in aforementionned bugs, but this does fix my immediate issue in 3.20 and master. -- You are receiving this mail because: You are watching all bug changes.

1 20

[Bug 15007] New: Slips and notices table 'letters' should have an 'id' primary key column
by bugzilla-daemon＠bugs.koha-community.org 26 Oct '15

26 Oct '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15007 Bug ID: 15007 Summary: Slips and notices table 'letters' should have an 'id' primary key column Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: kyle.m.hall(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org The recent issues related to duplicate notices have demonstrated that it would be much better to have an id column on letters so these issues not do re-emerge at a later date. -- You are receiving this mail because: You are watching all bug changes.

1 5

[Bug 12785] New: OPAC normal view displays unwanted ISBD punctuation
by bugzilla-daemon＠bugs.koha-community.org 26 Oct '15

26 Oct '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12785 Bug ID: 12785 Summary: OPAC normal view displays unwanted ISBD punctuation Change sponsored?: --- Product: Koha Version: 3.14 Hardware: PC OS: Windows Status: NEW Severity: minor Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: pesenti411(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Created attachment 30978 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=30978&action=edit Display of the punctuation in Opac normal view When displaying results in Normal view, the publisher data includes the punctuation. Could it be an error in cataloguing, or should I configure the OPAC differently? I use an image of Koha 3.14 in VIrtual Box on Windows 8.1 -- You are receiving this mail because: You are watching all bug changes.

1 4

[Bug 15040] New: Plack testing -- patron files area not behaving as expected
by bugzilla-daemon＠bugs.koha-community.org 26 Oct '15

26 Oct '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15040 Bug ID: 15040 Summary: Plack testing -- patron files area not behaving as expected Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: hbraum(a)nekls.org QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Blocks: 15019 I'm checking the patron file upload with Plack, and seeing something odd; this may or may not be Plack-related. First, I set the patronimages & EnableBorrowerFiles sys prefs to Allow/Do. Here's the oddity I've run into so far (the other one went away while writing the bug report): When I can finally get the Files tab up, the system says the patron has no files attached -- even though I've uploaded 2 files already. But if I upload another file, the now three attached files display, but if I click away from the files area, and come back, the system says the patron has no files attached, yet again. The borrower I was working with: http://test-intra.plack.bywatersolutions.com/cgi-bin/koha/members/files.pl?… Referenced Bugs: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15019 [Bug 15019] Plack testing - Umbrella -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 14725] New: Searching by Author limited to 245$c on Koha 3.12.04.000
by bugzilla-daemon＠bugs.koha-community.org 25 Oct '15

25 Oct '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14725 Bug ID: 14725 Summary: Searching by Author limited to 245$c on Koha 3.12.04.000 Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Searching Assignee: gmcharlt(a)gmail.com Reporter: jesus(a)medios.es QA Contact: testopia(a)bugs.koha-community.org Created attachment 41923 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=41923&action=edit Zebra config files Zebra does not return matching records on 7xx or 1xx when searching Author. It returns only bibs with the search term in 245$c. I checked Zebra config files with no relevant info. -- You are receiving this mail because: You are watching all bug changes.

1 1

[Bug 4158] cannot create list whose title is '0'
by bugzilla-daemon＠bugs.koha-community.org 25 Oct '15

25 Oct '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4158 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |NEW -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 4158] cannot create list whose title is '0'
by bugzilla-daemon＠bugs.koha-community.org 25 Oct '15

25 Oct '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4158 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer(a)bsz-bw.de Status|Patch doesn't apply |ASSIGNED -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 2601] Order fines by date and time
by bugzilla-daemon＠bugs.koha-community.org 25 Oct '15

25 Oct '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |NEW -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.

1 0