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

12 views
Skip to first unread message

Evgeny M.

unread,
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

unread,
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():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
Reply all
Reply to author
Forward
0 new messages