Hi all, There's the following error on multiple same type "update insert" queries to database. ERROR SE3008 Unknown message from server
Log text (event.log): ---------------------------------------------------------------- LOG 19/06/2013 09:23:45 (TRN project1 pid=2492 sid=49 trid=49) [tr_functions.cpp:on_user_statement_begin:102]: User query: --- UPDATE insert --- if (fn:not(document('ENVIRONMENT')//opt[@seccode='RI155000BR5'])) then <opt immorcancel='no' nosplit='no' bymarket='no' lotsize='1' active='true' point_cost='64.0854' usecredit='no' cancelbalance='yes' minstep='10' shortname='RTS-6.15M150615PA 155000' seccode='RI155000BR5' decimals='0' /> else () into document('ENVIRONMENT')/environment/market[@id='4'] [... - 100 same type queries] LOG 19/06/2013 09:23:46 (TRN project1 pid=2492 sid=49 trid=49) [tr_functions.cpp:on_user_statement_begin:102]: User query: --- UPDATE insert --- if (fn:not(document('ENVIRONMENT')//bond[@seccode='RU000A0JQ4A2'])) then <bond immorcancel='yes' nosplit='yes' bymarket='no' lotsize='1' active='true' point_cost='10' usecredit='yes' cancelbalance='yes' minstep='0.01' shortname='РљСѓР±РќРёРІР° 01' seccode='RU000A0JQ4A2' decimals='2' /> else () into document('ENVIRONMENT')/environment/market[@id='1'] LOG 19/06/2013 09:23:46 (TRN project1 pid=2492 sid=49 trid=-1) [tr_common_funcs.cpp:on_transaction_end:414]: Transaction has been COMMITED No error... LOG 19/06/2013 09:23:46 (TRN project1 pid=2492 sid=49 trid=49) [tr_functions.cpp:on_user_statement_begin:102]: User query: --- --- declare function local:copy($element as element()) { --- element {node-name($element)} --- {$element/@*, --- for $child in $element/node() --- return if ($child instance of element()) --- then local:copy($child) --- else $child --- } --- }; --- let $x:=document("ENVIRONMENT") --- return local:copy($x/node()) --- LOG 19/06/2013 09:23:47 (TRN project1 pid=2492 sid=49 trid=-1) [tr_common_funcs.cpp:on_transaction_end:414]: Transaction has been COMMITED LOG 19/06/2013 09:23:47 (TRN project1 pid=2492 sid=49 trid=49) [tr_functions.cpp:on_user_statement_begin:102]: User query: --- UPDATE insert --- if (fn:not(document('ENVIRONMENT')//bond[@seccode='RU000A0JR1D1'])) then <bond immorcancel='yes' nosplit='yes' bymarket='no' lotsize='1' active='true' point_cost='10' usecredit='yes' cancelbalance='yes' minstep='0.01' shortname='Р РњР‘ 03' seccode='RU000A0JR1D1' decimals='2' /> else () into document('ENVIRONMENT')/environment/market[@id='1'] [... - 100 same type queries] LOG 19/06/2013 09:23:47 (TRN project1 pid=2492 sid=49 trid=49) [tr_functions.cpp:on_user_statement_begin:102]: User query: --- UPDATE insert --- if (fn:not(document('ENVIRONMENT')//opt[@seccode='GD1950BI3'])) then <opt immorcancel='no' nosplit='no' bymarket='no' lotsize='1' active='true' point_cost='320.427' usecredit='no' cancelbalance='yes' minstep='0.1' shortname='GOLD-9.13M160913CA 1950' seccode='GD1950BI3' decimals='1' /> else () into document('ENVIRONMENT')/environment/market[@id='4'] ERROR 19/06/2013 09:23:48 (TRN project1 pid=2492 sid=49 trid=49) [socket_client.cpp:socket_client::process_unknown_instruction:615]: (SE4612) Commit current transaction before beginning a new one. LOG 19/06/2013 09:23:48 (TRN project1 pid=2492 sid=49 trid=49) [tr_functions.cpp:on_user_statement_begin:102]: User query: --- UPDATE insert --- if (fn:not(document('ENVIRONMENT')//opt[@seccode='GD1950BU3'])) then <opt immorcancel='no' nosplit='no' bymarket='no' lotsize='1' active='true' point_cost='320.427' usecredit='no' cancelbalance='yes' minstep='0.1' shortname='GOLD-9.13M160913PA 1950' seccode='GD1950BU3' decimals='1' /> else () into document('ENVIRONMENT')/environment/market[@id='4'] ---------------------------------------------------------------------------- Is it a bug? Am I doing something wrong? Please, advice. SEDNA version is 3.5.161 (32bit Release) System: Windows 6.1.7601 (SP1.0) x86 ------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev _______________________________________________ Sedna-discussion mailing list Sedna-discussion@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sedna-discussion