mysqlmysql-cluster

Got temporary error 899 'Rowid already allocated' from NDBCLUSTER


im experiencing this NDB CLUSTER Error for a while now. It started after a cluster shutdown for 2 days due to production shutdown.

Any insights will help. TIA


Solution

  • 899 means that the rowid is already allocated. It is a problem due to the distributed nature of NDB Cluster. Normally it is a temporary problem that goes away after a few microseconds.

    If it stays then probably some bug have caused the primary replica and backup replica to be inconsistent.

    If that is the scenario the best method to get back to normal operation is to do the following: 1) Take a backup 2) Perform an initial node restart of one of the data nodes (presuming that you have 2 data nodes).

    The problem should hopefully go away after this. The backup is simply to ensure that you have the latest possible backup if something more happens.