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/

Reply via email to