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

Skip to first unread message

Evgeny M.

Jan 27, 2016, 6:08:47 PM1/27/16
to Sophia database
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

Jan 28, 2016, 3:55:56 AM1/28/16
to Sophia database
Probably this will result with error, unless such behaviour is expected: Sophia support two/n-phase recovery, which extensively using sp_open():

Sophia tracks reference counting per database object. Some explanations are available here:
Reply all
Reply to author
0 new messages