Sorry to hear you are having problems with your failover server.  I&#39;ve had problems with failovers servers and backups before, it&#39;s not fun.<br><br>Have you checked the memory and hard drive of the failover server?  (the host)  That would be my first guess.  Also, it may be the filesystem on either the host or the guest, but I&#39;m not up on file systems so I can&#39;t say for sure.<br>
<br>There&#39;s a good chance the row number in the error message relates to the biblioitemnumber.  You could try just querying the database for rows around that.  Something like &#39;select * from biblioitems where biblioitemnumber &gt; 41470 and biblioitemnumber &lt; 41600.  If you see the error it could be data, disk, or filesystem related.  If you don&#39;t it&#39;s probably memory related, but maybe filesystem related.<br>
<br>Good luck.<br><br><div class="gmail_quote">2010/9/17 Christopher Curry <span dir="ltr">&lt;<a href="mailto:ccurry@amphilsoc.org">ccurry@amphilsoc.org</a>&gt;</span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">



  

<div text="#000000" bgcolor="#ffffff">
Hello all,<br>
<br>
I&#39;m trying to create a mirrored failover server with data from our live
Koha.  In
order to do so, I&#39;m using <b>mysqldump</b> and <b>mysql</b> for
backup and restore.<br>
<br>
I&#39;ve discovered a troubling problem and I can&#39;t determine the cause.  <br>
<br>
I run this command to backup the live server: <br>
<br>
<b>mysqldump --single-transaction -ukoha -p koha &gt;
/home/koha/KohaServerBackups/koha.`/bin/date +\%Y\%m\%d\%H\%M\%S`.sql</b><br>
<br>
This seems to work correctly (and very quickly!  1.7 GB database
exports in 2 min)<br>
<br>
Then, I run this command:<br>
<br>
<b>mysql -v -ukoha -p koha &lt;
/home/koha/KohaServerBackups/backupFileName.sql</b><br>
<br>
This also seems to work, as I receive no warnings or error messages.<br>
<br>
I&#39;m exporting from a 3.00.05.001 system and importing to a 3.00.05.003
system, so I then run the <b>$KOHA_SOURCE/installer/data/mysql/<a href="http://updatedatabase.pl" target="_blank">updatedatabase.pl</a></b>
script.<br>
<br>
Relevant specs:<br>
<br>
MySQL version: mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu
(i486) using readline 5.2
<br>
OS: Debian Lenny<br>
<br>
Failover server is virtual, running on VirtualBox 3.2.8, on an Ubuntu
10.4 host.<br>
<br>
<br>
All GUI functions of the Koha failover server seem to operate
correctly, but when I run <b>mysqlcheck -ukoha -p koha</b> the check
fails on koha.biblioitems with the following error message:<br>
<br>
mysqlcheck: Got error: 2013: Lost connection to MySQL server during
query when executing &#39;CHECK TABLE ... &#39;<br>
<br>
If I try mysqldump, I get the same error, but it is more specific,
reporting that it falls on row 41536.<br>
<br>
If I check /var/log/syslog, I see this <a href="http://pastebin.com/YuuFBHry" target="_blank">http://pastebin.com/YuuFBHry</a><br>
<br>
&quot;InnoDB: Database page corruption on disk or a failed file read of page
58164&quot;, etc.<br>
<br>
Both mysqlcheck &amp; mysqldump work without error on the live server,
so I&#39;m thinking that something must be happening to the data during the
export or import that corrupts the InnoDB data, but this is
speculation, since I&#39;m not a MySQL expert.<br>
<br>
Has anyone seen behavior like this?  Any suggestions for further
troubleshooting/resolution?<br>
<br>
<div>-- <br>
<span style="font-size: 12px; font-family: Arial;">
<p>Cheers,</p>
<p>Christopher Curry<br>
Assistant Technical Librarian / Assistant IT Officer</p>
<p>American Philosophical Society<br>
105 South Fifth Street<br>
Philadelphia, PA 19106-3386<br>
Tel. (215) 599-4299</p>
<p><a href="mailto:ccurry@amphilsoc.org" target="_blank">ccurry@amphilsoc.org</a></p>
Main Library number: (215)440-3400<br>
APS website: <a href="http://www.amphilsoc.org" target="_blank">http://www.amphilsoc.org</a>
<p><br>
</p>
</span>
</div>
</div>

<br>_______________________________________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br></blockquote></div><br>