At 10:22 AM 10/1/2012 +1300, Robin Sheat wrote:
Paul schreef op za 29-09-2012 om 17:54 [-0400]:
> 17:32:00-29/09 zebraidx(2632) [warn] isamb: Inconsistent register (2)
> zebraidx: isamb.c:1102: insert_leaf: Assertion `*lookahead_mode'
> failed.
> 17:32:00-29/09 zebraidx(2637) [warn] previous transaction didn't reach
> commit
>
> that are "novel."
>
> Any suggestions, thoughts?
Those errors are really annoying.
Have a look to see if there's something funny about the MARC for biblio
17765. Especially missing 999$c and $d (I think.)
I've been following up on on Robin's suggestion looking for "something
funny" in our records that might explain current indexing (or at least
reassure me that it's not a db rather than system error) and wrote a script
to verify our inhouse barcodes:
mysql> select items.barcode, items.biblionumber, biblio.title,
biblio.author, items.itemcallnumber from items join biblio on
(items.biblionumber = biblio.biblionumber) where items.barcode NOT REGEXP
'^[[:digit:]]{1}[[:alnum:]]{4}[[:digit:]]{8}$';
+------------------+--------------+----------------------+-------------------------+----------------+
| barcode | biblionumber | title |
author | itemcallnumber |
+------------------+--------------+----------------------+-------------------------+----------------+
| 1AERO9107_221230 | 16603 | Heroes of the air, | Fraser, Chelsea
Curtis, | AERO-FRAS-1 |
| 1AERO111564 | 17408 | Fights and flights / | Samson, Charles
Rumney, | AERO-SAMS-1 |
+------------------+--------------+----------------------+-------------------------+----------------+
2 rows in set (0.02 sec)
However, these are totally unfindable in Koha (by barcode, biblionumber,
callnumber, etc) via any type of search (normal, advanced etc) [N.B. we
have these two items under a different biblio, call, barcode, all valid and
searchable.]
But, I can use 'Tools ==> Export bibliographic and holdings' and produce
what appear to be perfectly valid Marc21 records
Could these 2 be (I'm wildly guessing) the reason for the "[warn] isamb:
Inconsistent register (2)"?
Does anyone have a ready made method to delete a complete record in
Mysql? They're unwanted elements -- but how to remove them?
tnx and br -- paul
_______________________________________________
Koha-devel mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/