[p4dti-discussion] FW: (P4DTI-8636) The replicator failed topollsuccessfully.

[Brent Browning]

I ran this command:

myisamchk --recover p4dti_replications 

That repaired the table and now everything appears to be working.  

Thanks for the quick response!

- Brent


-----Original Message-----
From: alex.pavloff at l-3com.com
Sent: Thursday, November 29, 2007 4:34 PM
To: Perforce Defect Tracking Integration discussion
Subject: Re: [p4dti-discussion] FW: (P4DTI-8636) The replicator failed
topollsuccessfully.


Try repairing the table via your favorite MySQL maintenance interface.
I've had an occasional error like that due to an unplanned shutdown.

	-Alex

-----Original Message-----
From: p4dti-discussion-bounces at ravenbrook.com
[mailto:p4dti-discussion-bounces at ravenbrook.com] On Behalf Of Brent
Browning
Sent: Thursday, November 29, 2007 4:06 PM
To: p4dti-discussion at ravenbrook.com
Subject: [p4dti-discussion] FW: (P4DTI-8636) The replicator failed to
pollsuccessfully.

I have been successfully using P4DTI for years now.  I just starting
getting the error below.  How do I fix this?  Can I clean out the
p4dti_replications table by hand?  

- Brent


-----Original Message-----
From: perforce at labcyte.com [mailto:perforce at labcyte.com]
Sent: Thursday, November 29, 2007 3:47 PM
To: perforce
Subject: (P4DTI-8636) The replicator failed to poll successfully.

(P4DTI-8658)  This is an automatically generated e-mail from the
Perforce Defect Tracking Integration replicator 'replicator0'.

(P4DTI-8647)  The replicator failed to poll successfully, because of the
following problem:

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

(P4DTI-8523)  Here's a full Python traceback:

Exception:
OperationalError: (1034, "Incorrect key file for table:
'p4dti_replications'. Try to repair it") Traceback (innermost last):
  File "replicator.py", line 857, in carefully_poll_databases
    self.poll_databases()
    locals:
      self: <replicator.replicator instance at 8198700>
  File "replicator.py", line 1220, in poll_databases
    self.dt.mark_changes_done(dt_marker)
    locals:
      _: {}
      self: <replicator.replicator instance at 8198700>
      changed_issues: <replicator.list_cursor instance at 8223948>
      changelists: [...deleted, contains company confidential info...]}
      p4_marker: 56742
  File "dt_bugzilla.py", line 615, in mark_changes_done
    self.bugzilla.end_replication()
    locals:
      self: <dt_bugzilla.dt_bugzilla instance at 8194930>
      replication: '2007-11-29 16:46:30'
  File "bugzilla.py", line 1915, in end_replication
    'end != 0 and '
    locals:
      self: <bugzilla.bugzilla instance at 81810e8>
  File "bugzilla.py", line 618, in delete_rows_rid_sid
    self.delete_rows(table, where +
    locals:
      self: <bugzilla.bugzilla instance at 81810e8>
      table: 'p4dti_replications'
      where: 'end != 0 and end < date_sub(now(), INTERVAL 1 HOUR)'
  File "bugzilla.py", line 612, in delete_rows
    self.execute('delete from %s where %s;' % (table, where))
    locals:
      self: <bugzilla.bugzilla instance at 81810e8>
      table: 'p4dti_replications'
      where: "end != 0 and end < date_sub(now(), INTERVAL 1 HOUR) and
rid = 'replicator0' and sid = 'perforce0'"
  File "bugzilla.py", line 102, in execute
    self.cursor.execute(sql)
    locals:
      sql: "delete from p4dti_replications where end != 0 and end <
date_sub(now(), INTERVAL 1 HOUR) and rid = 'replicator0' and sid =
'perforce0';"
      self: <bugzilla.bugzilla instance at 81810e8>
  File "/usr/lib/python1.5/site-packages/MySQLdb/cursors.py", line 95,
in execute
    return self._execute(query, args)
    locals:
      args: None
      self: <MySQLdb.cursors.Cursor instance at 818d018>
      query: "delete from p4dti_replications where end != 0 and end <
date_sub(now(), INTERVAL 1 HOUR) and rid = 'replicator0' and sid =
'perforce0';"
  File "/usr/lib/python1.5/site-packages/MySQLdb/cursors.py", line 114,
in _execute
    self.errorhandler(self, exc, value)
    locals:
      query: "delete from p4dti_replications where end != 0 and end <
date_sub(now(), INTERVAL 1 HOUR) and rid = 'replicator0' and sid =
'perforce0';"
      value: <_mysql_exceptions.OperationalError instance at 818ce80>
      TupleType: <type 'tuple'>
      self: <MySQLdb.cursors.Cursor instance at 818d018>
      exc_info: <built-in function exc_info>
      ListType: <type 'list'>
      args: None
      exc: <class _mysql_exceptions.OperationalError at 8178020>
  File "/usr/lib/python1.5/site-packages/MySQLdb/connections.py", line
33, in defaulterrorhandler
    raise errorclass, errorvalue
    locals:
      error: (<class _mysql_exceptions.OperationalError at 8178020>,
<_mysql_exceptions.OperationalError instance at 818ce80>)
      connection: <MySQLdb.connections.Connection instance at 818b9a8>
      errorvalue: <_mysql_exceptions.OperationalError instance at
818ce80>
      cursor: <MySQLdb.cursors.Cursor instance at 818d018>
      errorclass: <class _mysql_exceptions.OperationalError at 8178020>



_______________________________________________
P4DTI-discussion mailing list
P4DTI-discussion at ravenbrook.com
http://mailman.ravenbrook.com/mailman/listinfo/p4dti-discussion

_______________________________________________
P4DTI-discussion mailing list
P4DTI-discussion at ravenbrook.com
http://mailman.ravenbrook.com/mailman/listinfo/p4dti-discussion