List:Cluster« Previous MessageNext Message »
From:Richard McCluskey Date:August 17 2010 9:06pm
Subject:Got temporary error 899 'Rowid already allocated' from NDBCLUSTER
during INSERT
View as plain text  
Hi guys,

So under load I am getting this error message from the cluster. I have
filed a bug report for it but was wondering if the forum folks had a
quick workaround?  

Scenario :
I have 6 front end servers that all use tomcat/java to write impressions
to a table on the cluster. Under load our tomcat logs get filled up with
these error msgs ..

tracker.log:java.sql.SQLException: Got temporary error 899 'Rowid
already allocated' from NDBCLUSTER
tracker.log:Caused by: javax.jdo.JDODataStoreException: Insert of
object "com.go2.tracker.db.model.ImpressionsEvent@32598774" using
statement "INSERT INTO `IMPRESSIONS`
(`RESP_CODE`,`RESP_FORM_FACTOR`,`RESP_CONTENT_SCOPE`,`SVR_IP`,`USR_ETHNICITY`,`CONTENT_ID`,`USR_LOC`,`REQ_REF`,`REC_TIME`,`REQ_TS`,`REQ_LAT`,`REQ_LON`,`REQ_SWIDTH`,`RESP_CONTENT_SRC`,`USR_UA`,`IMPRESSION_ID`,`REQ_CID`,`USR_GENDER`,`REQ_SID`,`REC_DATE`,`REQ_IP`,`RESP_CALL_TO_ACTION`,`USR_YOB`,`RESP_CREATIVE_ID`,`USR_TARGET`,`REQ_FMT`,`REQ_PARTNER_ID`,`REQ_VER`)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" failed
: Got temporary error 899 'Rowid already allocated' from NDBCLUSTER


I looked through the Bug DB and found similar errors from 2008 but those
same error message occurred in UPDATES not INSERTS ... 

There is also nothing in the dataNode logs, or the SQL server logs ...

Any help would be much appreciated,

best regards,

Richard




-- 
Richard McCluskey

Senior Engineer

go2 Media

rmccluskey@stripped 

w: 617.671.0057 

10 High Street | Tenth Floor | Boston, MA 02110





Thread
Got temporary error 899 'Rowid already allocated' from NDBCLUSTERduring INSERTRichard McCluskey17 Aug
  • Re: Got temporary error 899 'Rowid already allocated' from NDBCLUSTERduring INSERTAndrew Hutchings17 Aug
  • Re: Got temporary error 899 'Rowid already allocated' from NDBCLUSTER during INSERTStewart Smith18 Aug