Hi Andrei,

What API do you use? It would be great if you can share your code with us.
It would be absolutely fantastic if you can give us code and data
(privately if it needed) to reproduce it :).

"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."

Did you turn off autocommit mode?

Ivan Shcheklein,
Sedna Team




On Wed, Jun 19, 2013 at 1:31 PM, Andrei <andreim...@gmail.com> wrote:

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

Reply via email to