calling sp_open/sp_getobject(env, table) twice and using both pointers simultaneously

[Evgeny M.]

What would happen if I call sp_open/sp_getobject(env, table) twice, either by error or because the second instance still runs in background after sp_destroy, and do write operations with both pointers? My tests show that data corruption is possible in this case, but I'm not 100% sure, might be the other reason.

[Dmitry Simonenko]

Probably this will result with error, unless such behaviour is expected: Sophia support two/n-phase recovery, which extensively using sp_open():http://sophia.systems/v2.1/admin/integration.html

Sophia tracks reference counting per database object. Some explanations are available here: https://github.com/pmwkaa/sophia/issues/106