Re: *FIXED* - Re: Database keeps crashing - Assertion Failure?

[Chris DiGanci]

Not sure if this helps or not, but here is the code that deals with that particular error:

/* Create the vector for storing matching document ids
and the positions of the first token of the phrase. */
if (!query->matched) {
ib_alloc_t* heap_alloc;

heap_alloc = ib_heap_allocator_create(heap);

if (!(query->flags & FTS_PROXIMITY)
&& !(query->flags & FTS_PHRASE)) {
query->matched = ib_vector_create(
heap_alloc, sizeof(fts_match_t),
64);
} else {
ut_a(num_token < MAX_PROXIMITY_ITEM);
query->match_array =
(ib_vector_t**) mem_heap_alloc(
heap,
num_token *
sizeof(query->matched));

for (i = 0; i < num_token; i++) {
query->match_array =
ib_vector_create(
heap_alloc, sizeof(fts_match_t),
64);
}

query->matched = query->match_array[0];
}
}


Also, and I don't know if this was very clear through my post, but what I think ultimately fixed my database was dumping the entire thing out to individual files (including the mysql table a few times just in case), using the innodb_recovery 4 option, dropped all of the data databases (leaving the mysql one), then stopping mysql, deleted any remaining data directories (again, leave the mysql one), removed the ibdata and ib log files (I just moved them to another folder), restarting mysql without the recovery option set, then reimported all of the databases one by one. It's been running smooth as glass since.