[Koha] Please Help: Authority Search - Not returning Result. Zebra Index Picks up 4 Authority Records

Mon Nov 2 20:35:43 NZDT 2009

I fixed those permissions issues, they were not the problem.  It seems
indexing does not happen for some reason.

Kindly note below the zebra server log and the indexing log.

====== STARTING SERVER MANUALLY ===========

11:13:05-02/11 [log] zebra_start /etc/koha/zebradb/zebra-biblios.cfg 1.3.50
11:13:05-02/11 [log] zebra_start
/etc/koha/zebradb/zebra-authorities-dom.cfg 1.3.50
11:13:05-02/11 [server] Adding dynamic listener on
unix:/var/run/koha/zebradb/bibliosocket id=1
11:13:05-02/11 [server] Adding dynamic listener on
unix:/var/run/koha/zebradb/authoritysocket id=2
11:13:05-02/11 [server] Starting server zebrasrv pid=20923
11:14:30-02/11 zebrasrv(1) [session] Session - OK 1
unix:/var/run/koha/zebradb/authoritysocket 26487
11:14:30-02/11 zebrasrv(1) [log] User perm for perm.koha: rw
11:14:30-02/11 zebrasrv(1) [request] Auth idPass koha -
11:14:30-02/11 zebrasrv(1) [request] Init OK - ID:81/81
Name:ZOOM-C/YAZ Version:1.116/2.1.54
11:14:30-02/11 zebrasrv(1) [log] ResultSet '1'
11:14:30-02/11 zebrasrv(1) [debug][log] zebra_register_open rw = 0
useshadow=0 p=0x944db68,n=,rp=(none)
11:14:30-02/11 zebrasrv(1) [log]
profilePath=/etc/koha/zebradb/authorities/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/authorities:/etc/koha/zebradb/lang_defs/en:/etc/koha/zebradb/xsl
cwd=/var/lib/koha/zebradb/authorities
11:14:30-02/11 zebrasrv(1) [log] 0 keys, 0 sysnos, sort
11:14:30-02/11 zebrasrv(1) [log] term="0" nn=0 type=void count=0
11:14:30-02/11 zebrasrv(1) [log] term="CORPO_NAME" nn=0 type=void count=0
11:14:30-02/11 zebrasrv(1) [log] term="Chris" nn=0 type=void count=0
11:14:30-02/11 zebrasrv(1) [log] user/system: 0/0
11:14:30-02/11 zebrasrv(1) [request] Search authorities ERROR 109 1
1+0 RPN @attrset Bib-1 @or @attr "1=Heading" @attr 7=1 0 @and @attr
5=100 @attr "1=authtype" CORPO_NAME @attr 4=6 @attr 5=1 @attr
"1=Heading" Chris
11:14:31-02/11 zebrasrv(1) [session] Connection closed by client
11:14:31-02/11 zebrasrv(1) [debug][log] zebra_register_close p=0x944db68
11:15:04-02/11 zebrasrv(2) [session] Session - OK 2
unix:/var/run/koha/zebradb/authoritysocket 28481
11:15:04-02/11 zebrasrv(2) [log] User perm for perm.koha: rw
11:15:04-02/11 zebrasrv(2) [request] Auth idPass koha -
11:15:04-02/11 zebrasrv(2) [request] Init OK - ID:81/81
Name:ZOOM-C/YAZ Version:1.116/2.1.54
11:15:04-02/11 zebrasrv(2) [log] ResultSet '1'
11:15:04-02/11 zebrasrv(2) [debug][log] zebra_register_open rw = 0
useshadow=0 p=0x944db68,n=,rp=(none)
11:15:04-02/11 zebrasrv(2) [log]
profilePath=/etc/koha/zebradb/authorities/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/authorities:/etc/koha/zebradb/lang_defs/en:/etc/koha/zebradb/xsl
cwd=/var/lib/koha/zebradb/authorities
11:15:04-02/11 zebrasrv(2) [log] 0 keys, 0 sysnos, sort
11:15:04-02/11 zebrasrv(2) [log] term="0" nn=0 type=void count=0
11:15:04-02/11 zebrasrv(2) [log] term="PERSO_NAME" nn=0 type=void count=0
11:15:04-02/11 zebrasrv(2) [log] term="susan" nn=0 type=void count=0
11:15:04-02/11 zebrasrv(2) [log] user/system: 0/0
11:15:04-02/11 zebrasrv(2) [request] Search authorities ERROR 109 1
1+0 RPN @attrset Bib-1 @or @attr "1=Heading" @attr 7=1 0 @and @attr
5=100 @attr "1=authtype" PERSO_NAME @attr 4=6 @attr 5=1 @attr
"1=Heading" susan
11:15:05-02/11 zebrasrv(2) [session] Connection closed by client
11:15:05-02/11 zebrasrv(2) [debug][log] zebra_register_close p=0x944db68

=====================================

Then looking at the zebra_rebuild -a log i see

===================

mistuser at MIST-Koha-Test:~$ sudo perl -I /usr/share/koha/lib
/usr/share/koha/bin/migration_tools/rebuild_zebra.pl -aZebra
configuration information
================================
Zebra biblio directory      = /var/lib/koha/zebradb/biblios
Zebra authorities directory = /var/lib/koha/zebradb/authorities
Koha directory              = /usr/share/koha/intranet/cgi-bin
BIBLIONUMBER in :     999$c
BIBLIOITEMNUMBER in : 999$d
================================
====================
exporting authority
====================
1..
Records exported: 3
====================
REINDEXING zebra
====================
11:27:12-02/11 zebraidx(10017) [log] zebra_start
/etc/koha/zebradb/zebra-authorities-dom.cfg 1.3.50
11:27:12-02/11 zebraidx(10017) [debug][log] zebra_register_open rw = 1
useshadow=1 p=0x823a058,n=,rp=(none)
11:27:12-02/11 zebraidx(10017) [log] enabling cache
spec=/var/lib/koha/zebradb/authorities/shadow:1G
11:27:12-02/11 zebraidx(10017) [log] cache_fname =
/var/lib/koha/zebradb/authorities/shadow/cache
11:27:12-02/11 zebraidx(10017) [log]
profilePath=/etc/koha/zebradb/authorities/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/authorities:/etc/koha/zebradb/lang_defs/en:/etc/koha/zebradb/xsl
cwd=/home/mistuser
11:27:12-02/11 zebraidx(10017) [log] dir /tmp/zzuTCKMwth/authority
11:27:12-02/11 zebraidx(10017) [warn] No such record type:
dom./etc/koha/zebradb/authorities/etc/dom-config-marc.xml
11:27:12-02/11 zebraidx(10017) [log] zebra_end_trans
11:27:12-02/11 zebraidx(10017) [log] sorting section 1
11:27:12-02/11 zebraidx(10017) [log] Iterations . . .     30
11:27:12-02/11 zebraidx(10017) [log] Distinct words .     15
11:27:12-02/11 zebraidx(10017) [log] Updates. . . . .     11
11:27:12-02/11 zebraidx(10017) [log] Deletions. . . .      2
11:27:12-02/11 zebraidx(10017) [log] Insertions . . .      2
11:27:12-02/11 zebraidx(10017) [debug][log] zebra_register_close p=0x823a058
11:27:12-02/11 zebraidx(10017) [log] Records:       0 i/u/d 0/0/0
11:27:12-02/11 zebraidx(10017) [log] user/system: 0/0
11:27:12-02/11 zebraidx(10017) [debug][log] zebra_stop
11:27:12-02/11 zebraidx(10017) [log] zebraidx times:  0.03  0.00  0.00
11:27:12-02/11 zebraidx(10020) [log] zebra_start
/etc/koha/zebradb/zebra-authorities-dom.cfg 1.3.50
11:27:12-02/11 zebraidx(10020) [log] enabling cache
spec=/var/lib/koha/zebradb/authorities/shadow:1G
11:27:12-02/11 zebraidx(10020) [log] cache_fname =
/var/lib/koha/zebradb/authorities/shadow/cache
11:27:12-02/11 zebraidx(10020) [log] commit start
11:27:12-02/11 zebraidx(10020) [debug][log] zebra_stop
skipping biblios
====================
CLEANING
====================

===================================

I hope someoen can tell me WHY my authority database does not insert data!!
As you can see in 11:27:12-02/11 zebraidx(10017) [log] Records:       0
i/u/d 0/0/0

Awaiting all the helpful replies,

Thanks

On Mon, Nov 2, 2009 at 11:05 AM, john smith <smith_me at live.com> wrote:

>
>  Hi
> It looks like erro in your permission verify it
>
> zebra_lock_create fail fname=/var/lock/koha/zebradb/authorities/shadow..LCK
> [Permission denied]
> John Smith
>
> ------------------------------
> Date: Sun, 1 Nov 2009 19:44:09 +0400
> From: susan.mustafa at gmail.com
> To: koha at lists.katipo.co.nz
> Subject: [Koha] Please Help: Authority Search - Not returning Result. Zebra
> Index Picks up 4 Authority Records
>
>
>
>
> Hi everyone,
>
> I hope I can get a reply soon as it seems this is a very urgent issue and
> stopping me from going live.
>
> Please note the following problem:
>
> Simple Explanation: I create a new "Personal Name" authority framework, add
> only enter "Susan M" in Tab 1, Tag @a --Save
>
> Do rebuild_zebra -a -r <-- For rebuilding Authority Indexes.  It says
> exported 4 records, which is correct.  I created 4 Authority Records in
> Koha.
>
> Search Authority in Koha - Drop down [Personal Name]-Contains-  Susan <--
> Returns Nothing.
>
>
> -----------------------
> Biblios works perfectly fine.  Only Authorities do not show in Koha. I
> really did do my best, but I can't seem to solve it on my own.  So any help
> is greatly appreciated.
>
>
> Tail - Copy/Paste of koha-err.log
> [Sun Nov 01 16:22:41 2009] [error] [client 172.21.255.32] [Sun Nov  1
> 16:22:41 2009] authorities-home.pl: oAuth error: Database unavailable
> (109) authorities Bib-1, referer:
> http://172.21.236.24:8080/cgi-bin/koha/authorities/detail.pl?authid=4
> mistuser at MIST-Koha-Dev-V2:/$
>
> From zebraquedaemon
>
> <Susan-Dev> 13:53:59-15/11 zebrasrv(107) [request] Search authorities
> ERROR 109 1 1+0 RPN @attrset Bib-1 @or @attr "1=Heading" @attr 7=1 0 @attr
> 4=6 @attr 5=1 @attr "1=Heading" susan 13:54:00-15/11 zebrasrv(107) [session]
> Connection closed by client 14:04:21-15/11 zebrasrv(108) [session] Session -
> OK 108 unix:/var/run/koha/zebradb/authoritysocket 369 14:04:21-15/11
> zebrasrv(108) [log] User perm for perm.koha: rw 14:04:21-15/11 zebrasrv(108)
> [request] Auth idPass koha - 14:04:21-15/11 zebrasrv(108) [request] Init OK
> - ID:81/81 Name:ZOOM-C/YAZ Version:1.116/2.1.54 14:04:21-15/11 zebrasrv(108)
> [warn] zebra_lock_create fail
> fname=/var/lock/koha/zebradb/authorities/norm..LCK [Permission denied]
> 14:04:21-15/11 zebrasrv(108) [warn] zebra_lock_create fail
> fname=/var/lock/koha/zebradb/authorities/shadow..LCK [Permission denied]
> 14:04:21-15/11 zebrasrv(108) [request] Search authorities ERROR 109 1 1+0
> RPN @attrset Bib-1 @or @attr 2=103 @attr "1=_ALLRECORDS" '' @attr
> "1=Heading" @attr 7=1 0 14:04:21-15/11 zebrasrv(108) [session] Connection
> closed by client mistuser at MIST-Koha-Dev-V2:/var/lock/koha/zebradb$
>
>
> Hope someone can help me.  Please do try :)  Don't mind the timestamp
> differences. I just copied the errors at different times.
>
> I hope someone can help me.
>
> Thank you,
>
>
>
>
>
>
> ------------------------------
> Windows Live: Make it easier for your friends to see what you’re up to on
> Facebook.<http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_2:092009>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20091102/9d8db424/attachment-0001.htm 