[Koha] New items not showing

[Tomas Cohen Arazi]

My suggestion is:

# get the instance name
$ sudo koha-list
# fix permissions
$ sudo chown -R <instance>-koha:<instance>-koha /var/lib/koha/<instance>
# perform a full rebuild, the package's way
$ sudo koha-rebuild-zebra -f -a -b -v <instance>
# make sure the indexer is enabled (should read USE_INDEXER_DAEMON="yes")
$ sudo vim /etc/default/koha-common
# start the indexer
$ sudo koha-indexer --restart <instance>

The init service 'koha-common' already handles the koha-indexer, so you can
just
$ sudo service koha-common restart

One thing you can do is running this on a terminal:
$ watch -n 0.5 'echo "SELECT * FROM zebraqueue WHERE done=0;| sudo
koha-mysql <instance>"'

You will see the 'pending' updates. If it is empty, you can just edit
something and see things added, and then disappear.
If they don't seem to be updated (the indexes) then you should look at
/var/log/koha/<instance>/indexer*.log

BTW: I strongly suggest you upgrade (at least) to the 20.05 release (19.11
is still maintained but not sure how long).

Good luck!


El vie, 5 mar 2021 a las 10:58, Scott Owen (<sowen at almaschools.net>)
escribió:

> yes.
>
> On Fri, Mar 5, 2021 at 8:55 AM Tomas Cohen Arazi <tomascohen at gmail.com>
> wrote:
>
>> Did you install Koha using the Debian repository at
>> debian.koha-community.org and then installing 'koha-common'?
>>
>>
>> El vie, 5 mar 2021 a las 10:51, Scott Owen (<sowen at almaschools.net>)
>> escribió:
>>
>>> Version:
>>>
>>> ***********************************************
>>> Koha version: 17.11.18.000
>>> OS version ('uname -a'): Linux hskoha 3.16.0-4-686-pae #1 SMP Debian
>>> 3.16.51-3 (2017-12-13) i686
>>> Perl interpreter: /usr/bin/perl
>>> Perl version: 5.020002
>>> Perl @INC: /usr/share/koha/lib
>>> /etc/perl
>>> /usr/local/lib/i386-linux-gnu/perl/5.20.2
>>> /usr/local/share/perl/5.20.2
>>> /usr/lib/i386-linux-gnu/perl5/5.20
>>> /usr/share/perl5
>>> /usr/lib/i386-linux-gnu/perl/5.20
>>> /usr/share/perl/5.20
>>> /usr/local/lib/site_perl
>>> .
>>> MySQL version: mysql Ver 14.14 Distrib 5.5.62, for debian-linux-gnu
>>> (i686) using readline 6.3
>>> Apache version: Server version: Apache/2.4.10 (Debian)
>>> Memcached: Servers: undefined | Namespace: koha | Status: unknown |
>>> Config read from: Nowhere Note that the right place to define the memcached
>>> config is in your $KOHA_CONF file. Currently you do not have a valid
>>> memcached configuration defined. | Effective caching method:
>>> Zebra version: Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free
>>> software, covered by the GNU General Public License, and you are welcome to
>>> change it and/or distribute copies of it under certain conditions. SHA1 ID:
>>> c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU
>>> ***********************************************************
>>>
>>>
>>> " and maybe that's why the incremental indexer is failing, as it is
>>> running as the instance's user."
>>> -- certainly sounds possible.
>>>
>>> --  Any way to test / verify koha-indexer ?? (login as different users
>>> via putty and run the command ?? What output should I expect to see ...if
>>> any... )
>>>
>>> thank you!
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Fri, Mar 5, 2021 at 8:35 AM Tomas Cohen Arazi <tomascohen at gmail.com>
>>> wrote:
>>>
>>>> What Koha version are you using and what install method?
>>>>
>>>> When you use Debian packages, you are provided with a script
>>>> (koha-indexer) that can be used to start/stop the incremental indexing of
>>>> any changes on the DB, without the need of a full reindex.
>>>> Also, the fact you are used to manually run rebuild_zebra.pl (instead
>>>> of, again, the management scripts the packages provide like
>>>> koha-rebuild-zebra) with the --run-as-root flag, makes me suspect running
>>>> with --run-as-root is generating a permissions issue on the Zebra index
>>>> files, and maybe that's why the incremental indexer is failing, as it is
>>>> running as the instance's user.
>>>>
>>>> Hope it clarifies
>>>> Keep us posted
>>>>
>>>> El vie, 5 mar 2021 a las 10:23, Scott Owen (<sowen at almaschools.net>)
>>>> escribió:
>>>>
>>>>> ..until I do a DB repair/rebuild.
>>>>> Items are added, lookups done at LOC etc...everything seems OK...
>>>>> but...the items never "show up" in Koha...ie: users search for the
>>>>> items,
>>>>> but get no results until I run a rebuild/repair
>>>>>
>>>>> I'm unsure of where to even start looking?
>>>>>
>>>>>
>>>>> export PERL5LIB=/usr/share/koha/lib/
>>>>> export KOHA_CONF=/etc/koha/sites/<My_Site>/koha-conf.xml
>>>>> perl /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -v
>>>>> -run-as-root
>>>>> _______________________________________________
>>>>>
>>>>> Koha mailing list  http://koha-community.org
>>>>> Koha at lists.katipo.co.nz
>>>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>>
>>>>
>>>>
>>>> --
>>>> Tomás Cohen Arazi
>>>> Theke Solutions (http://theke.io)
>>>> ✆ +54 9351 3513384
>>>> GPG: B2F3C15F
>>>>
>>>
>>
>> --
>> Tomás Cohen Arazi
>> Theke Solutions (http://theke.io)
>> ✆ +54 9351 3513384
>> GPG: B2F3C15F
>>
>

-- 
Tomás Cohen Arazi
Theke Solutions (http://theke.io)
✆ +54 9351 3513384
GPG: B2F3C15F