[p4dti-discussion] Perforce\Bugzilla out of sync

[Bill Farrow]

> I guess I should mention that we're using very old versions of
> Perforce(2003.2) and p4dti to match; and my skills are somewhat limited
> when it comes to Linux and python.
> 
> Any help would be greatly appreciated.

No guarantees here. I have done some of these steps in the past, but I am no expert in mysql you should double check what I am saying with your own research and man page reading.

> (P4DTI-891X)  Error (_mysql_exceptions.OperationalError): (1034,
> "Incorrect key file for table: 'p4dti_replications'. Try to repair it")

Your mysql database is corrupt or broken, and you will need to repair it.  It probably broke when the server crashed and it was doing a write to the a file.

Backup your mysql database files (*.frm, *.MYD, *.MYI). If you were running debian the commands would be:
  $ /etc/init.d/mysql stop
  $ tar zcf ~/mysql-files-backup-2007-12-04.tgz /var/lib/mysql
  $ /etc/init.d/mysql start

See if you can dump out the database in question as another form of backup:
  $ mysqldump -u root -p your_bugzilla_database_name > ~/mysql-bugzilla-backup-2007-12-04.sql

If you don't know the mysql database name that you are using run:
  $ mysql -u root -p
  mysql> show databases;

Now check the database tables for problems:
  $ cd /var/lib/mysql
  $ myisamchk *.MYI 

Then do the repair action:
  $ myisamchk -r *.MYI  

And then restart the database service:
  $ /etc/init.d/mysql restart



> www.monteris.com
> Monteris Medical

Good to see another interesting company doing in-vivo laser medical devices.
Good luck,

Bill Farrow
www.optiscan.com