Can't upgrade from v0.2.2 to v0.2.7

[zjshen14]

Whenever we have schema change, we need to migrate db.

{"level":"error","ts":1570859268.5242386,"caller":"committee/committee.go:211","msg":"failed to catch up via network","ioAddr":"io1gh439pm67d4cwxt882xpylj75klys6esepml60","networkAddr":"0.0.0.0:4689","height":7826200,"error":"failed to get record hashes: no such column: ids","errorVerbose":"no such column: ids\nfailed to get record hashes\ngithub.com/iotexproject/iotex-election/committee.(*recordTableOperator).Put\n\t/go/pkg/mod/github.com/iotexproject/[email protected]/committee/recordtableoperator.go:184\ngithub.com/iotexproject/iotex-election/committee.(*archive).PutPoll\n\t/go/pkg/mod/github.com/iotexproject/[email protected]/committee/pollarchive.go:185\ngithub.com/iotexproject/iotex-election/committee.(*committee).storeInBatch\n\t/go/pkg/mod/github.com/iotexproject/[email protected]/committee/committee.go:349\ngithub.com/iotexproject/iotex-election/committee.(*committee).Start.func1\n\t/go/pkg/mod/github.com/iotexproject/[email protected]/committee/committee.go:210\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1337"}

[zjshen14]

This is blocking upgrade to v0.9.0 from v0.8.4 on testnet

[raullenchai]

election-service?

[zjshen14]

BTW, it shouldn't affect mainnet, because mainnet is still on v0.8.3, which is using v0.1.x election

[koseoyoung]

it seems same issue with #117
Because we changed the table schema with same table name between v0.2.2 and v0.2.7. Can we remove the db(new sqlite DB, not old one) and migrate again just for testNet? Or we should find out other way