EXECUTE.BATCH update creates core-file
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
In Progress
|
High
|
Sandhya Sundaresan |
Bug Description
Using atomics suite.
Test 10 is an update test using JDBC batch feature.
Test 12 is a delete test using JDBC batch feature.
Test is configured to batch 500 rows and then does execute batch. See code for update. Similar code for delete.
/* Prepare the insert statement. */
String sqlStmtCmd = "UPDATE " + dbTableName + " SET COL1=?, COL2=? WHERE CNT = ?";
try {
sqlStmt = dbConnection.
} catch (SQLException e) {
log_
return(
}
...
for (i = 0; i < (int)numbtmf; i++) { <== numbtmf is a passed parameter, set to 500 in my tests.
try {
hv_cnt++;
if (hv_cnt >= hv_cnt2) hv_cnt = hv_cnt1; /* Need to restart. */
} catch (SQLException e) {
retcode = e.getErrorCode();
do {
} while ((nextException = nextException.
}
}
beginTXN();
try {
resultCountL = sqlStmt.
rowCnt+
if (resultCountL.
retcode = 1;
} else {
for (i = 0; i < resultCountL.
if ((resultCountL[i] != 1) && (resultCountL[i] != Statement.
retcode = resultCountL[i];
break;
}
}
}
sqlStmt.
} catch (SQLException e) {
log_
SQLException nextException;
nextException = e;
retcode = e.getErrorCode();
do {
} while ((nextException = nextException.
}
commitTXN();
return retcode;
Eventually, get:
Exception in update_with_rowsets
Exception in update_with_rowsets
Batch Update Failed, See next exception for details State: HY000
Batch Update Failed, See next exception for details State: HY000
*** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterfa
org.apache.
Fri Jan 31 14:38:42 UTC 2014, org.apache.
Fri Jan 31 14:38:43 UTC 2014, org.apache.
Fri Jan 31 14:38:44 UTC 2014, org.apache.
Fri Jan 31 14:38:45 UTC 2014, org.apache.
Fri Jan 31 14:38:47 UTC 2014, org.apache.
Fri Jan 31 14:38:49 UTC 2014, org.apache.
Fri Jan 31 14:38:53 UTC 2014, org.apache.
Fri Jan 31 14:38:57 UTC 2014, org.apache.
Fri Jan 31 14:39:05 UTC 2014, org.apache.
Fri Jan 31 14:39:21 UTC 2014, org.apache.
org.apache.
org.apache.
org.apache.
org.trafodion.
. [2014-01-31 14:39:21] State: X08CG
*** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterfa
org.apache.
Fri Jan 31 14:38:42 UTC 2014, org.apache.
Fri Jan 31 14:38:43 UTC 2014, org.apache.
Fri Jan 31 14:38:44 UTC 2014, org.apache.
Fri Jan 31 14:38:45 UTC 2014, org.apache.
Fri Jan 31 14:38:47 UTC 2014, org.apache.
Fri Jan 31 14:38:49 UTC 2014, org.apache.
Fri Jan 31 14:38:53 UTC 2014, org.apache.
Fri Jan 31 14:38:57 UTC 2014, org.apache.
Fri Jan 31 14:39:05 UTC 2014, org.apache.
Fri Jan 31 14:39:21 UTC 2014, org.apache.
org.apache.
org.apache.
org.apache.
org.trafodion.
. [2014-01-31 14:39:21] State: X08CG
Test TSUR0500: 0 loops from 31 Jan 14 14:32:29.970 to 14:44:57.120 for 747 secs
Get similar result when doing batch deletes.
tags: | added: transaction |
tags: |
added: dtm removed: transaction |
Changed in trafodion: | |
importance: | High → Critical |
Changed in trafodion: | |
milestone: | none → r0.7 |
assignee: | Arvind Narain (arvind-narain) → nobody |
assignee: | nobody → Oliver (oliver-bucaojit) |
Changed in trafodion: | |
assignee: | Oliver (oliver-bucaojit) → Atanu Mishra (atanu-mishra) |
information type: | Proprietary → Public |
tags: |
added: sql-cmp removed: dtm |
Changed in trafodion: | |
assignee: | Atanu Mishra (atanu-mishra) → Ravisha Neelakanthappa (ravisha-neelakanthappa) |
tags: |
added: duplicate removed: sql-cmp |
tags: |
added: sql-cmp removed: duplicate |
Changed in trafodion: | |
assignee: | Ravisha Neelakanthappa (ravisha-neelakanthappa) → Sandhya Sundaresan (sandhya-sundaresan) |
milestone: | r0.7 → r1.1 |
milestone: | r1.1 → r0.9 |
Changed in trafodion: | |
assignee: | Sandhya Sundaresan (sandhya-sundaresan) → Mike Hanlon (mike-hanlon) |
milestone: | r0.9 → r1.0 |
Changed in trafodion: | |
importance: | Critical → High |
summary: |
- EXECUTE.BATCH hangs for a long time doing updates or deletes + EXECUTE.BATCH update creates core-file |
Changed in trafodion: | |
milestone: | r1.0 → r1.1 |
Changed in trafodion: | |
milestone: | r1.1 → r2.0 |
assignee: | Mike Hanlon (mike-hanlon) → Sandhya Sundaresan (sandhya-sundaresan) |
Debugging also shows that the initial exception has a code of 0.
IE: In code above
retcode = e.getErrorCode();
retcode has a value of 0.