ERROR 122 .. opening a column file ...

1 post / 0 new
doug@leadertech.com
doug@leadertech.com's picture
Offline
Last seen: 6 months 4 days ago
Joined: Feb 6 2013
Junior Boarder

Posts: 5

Doug Sorensen
ERROR 122 .. opening a column file ...

Hi.

Running the community edition, I've begun getting:

ERROR 122 (HY000): CAL0007: Update failed on XXX table. opening a column file. The file was not found or was inaccessible.

when I try to do straightforward updates to various tables, i.e.

update XXX set x = 'aaa' where x = 'bob';

I can query each of the tables just fine, but can't update.

Suggestions?

(addenda): if I leave a session after getting the above message, then when I start a new session and try to do an update I get:

ERROR 122 (HY000): IDB-2010: Unable to perform DDL/DML because session [prior #] is currently updating XXX

Thanks --