mysql - How do I cancel / abort a rollback in infinidb? -
when start infinidb, getting following error message, making impossible service start. in log file, says there problem rollback. there way abort rollback can start service again? ok losing data.
starting calpont infinidb database platform: ....... done warning! dbrm in read-only mode! updates not propagate! starting calpont infinidb mysql: starting mysql . * validate infinidb system catalog: validation succesfully completed perform functionality test: infinidb logging check: done platform process check: error: problem infinidb process dmlproc, should single version running ***stopping infinidb allow process problem resolved. shutting down calpont infinidb mysql: shutting down mysql ... * shutting down calpont infinidb database platform:
/var/log/calpont/crit.log
dmlproc[4292]: 41.458706 |0|0|0| c 20 cal0002: dmlproc failed start due : problem rollback. version buffer file not exists.
i tried removing files in /usr/local/calpont/data1/systemfiles/datatransaction
still won't start.
this how able solve it.
while service starting:
# service infinidb start
in ssh session go /usr/local/calpont/bin
, transaction id causing problem:
# ./rollback -p
once find out, run rollback command transaction id see:
./rollback -r 64536
it respond ok , service started time. had twice because first attempt not able rollback transaction on time.
Comments
Post a Comment