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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
