[Koha] problems with the holdings and mysql database

[Haik Zargaryan]

----- Forwarded Message -----
From: Haik Zargaryan <haikzargaryan at yahoo.com>
To: "hayk_zargaryan at flib.sci.am" <hayk_zargaryan at flib.sci.am> 
Sent: Saturday, January 26, 2013 10:55 PM
Subject: Fw: problems with the holdings and mysql database
 



----- Forwarded Message -----
From: Haik Zargaryan <haikzargaryan at yahoo.com>
To: "hayk at flib.sci.am" <hayk at flib.sci.am> 
Sent: Saturday, January 26, 2013 10:54 PM
Subject: problems with the holdings and mysql database
 

Dear friends,

We have experienced a very strange problem with koha 3.8. We have imported 100000 records with their holdings (they were exported from the Aleph and processed with the MarcEdit to comply with the Koha's holdings' standard) and indexed them successfully. Everything was working fine but suddenly the items became unavailable. Although being physically attached to the record they were not shown in the search results. 

I have decided to reboot the server and after that koha refused to work at all. The problem was that the mysql server was not running. I have tried to do it manually but nonetheless the service failed to work. Fortunately, I have backed up the initial mysql database (without any records) so I have simply restored it back and everything started to work. Interestingly, the zebra index with 100000 records was still active and when I searched for a record several records were retrieved. Surprisingly, all items were shown.  
 
2 items, 2 available:
	* Fundamental Scientific Library [PII/539097] (1) 
Books
	* Fundamental Scientific Library [PII/545962] (1) 
Books

So, I suspect that the items were not shown due to a problem with the mysql. I have no clue what we have done wrong. Maybe something is incorrect with the imported records, or the mysql server was not properly installed? Anyway, I am attaching a sample record below. 

When surfing the web for similar problems, I have encountered this discussion. But the final solution is unclear. So, is there anyone who had a similar problem, or can anyone suggest a solution to this problem? Please, take into account that this is a very serious issue for us.

Thanks in advance,
Haik.
----------------------------------
=LDR  01477nam a2200313 u 4500
=001  000891960
=003  AM-YeHGA
=005  20120531145650.0
=008  120517s2011\\\\|||\\\\\r\\\\\000\0\eng\d
=020  \\$a9789041134370 (hardback : acid-free paper)
=020  \\$a9041134379 (hardback : acid-free paper)
=040  \\$cFSL
=040  \\$aAM-YeHGA
=041  0\$aeng
=100  1\$aReis, Tarcisio Hardman.
=245  10$aCompensation for environmental damages under international law :$bThe role of the international judge /$cTarcisio Hardman Reis.
=260  \\$aAlphen aan den Rijn, The Netherlands :$bKluwer Law International ;$aFrederick, MD :$bSold and distributed in North, Central and South America by Aspen Publishers,$c2011.
=300  \\$axxii, 215 p. ;$c25 cm.
=490  1\$aEnergy and environmental law & policy series ;$vVol. 17
=504  \\$aIncludes bibliographical references (p. [191]-208) and index.
=650  \0$aLiability for environmental damages.
=650  \0$aEnvironmental law, International.
=650  \0$aCompensation (Law)
=830  \0$aEnergy and environmental law & policy series ;$vVol. 17.
=856  41$3Table of contents only$uhttp://www.loc.gov/catdir/toc/fy11pdf03/2011287020.html
=942  \\$2udc$cBK
=952    $yBK$8GEN$pFL0223379$oИ III/114865$aFSL$z30 Days Loan$bFSL