Hi Prémon,
Possibly this is a bug.
Can you send me the complete Java code you use to reproduce this behaviour?
Ivan
On Mon, Nov 24, 2008 at 6:10 PM, Prémon Nom <[EMAIL PROTECTED]> wrote:
> Hello,
>
> it seems that the drop query itself takes only 12 seconds but another query
> is executed just after (not asked by me) LOAD STDIN "V1DataSimu2".
>
>
> LOG 24/11/2008 15:43:36 (TRN elb sid=48 trid=49)
> [tr_functions.cpp:on_user_statement_begin:79]: User query:
> --- DROP DOCUMENT("V1DataSimu2")
> LOG 24/11/2008 15:45:48 (TRN elb sid=48 trid=49)
> [tr_functions.cpp:on_user_statement_begin:79]: User query:
> --- LOAD STDIN "V1DataSimu2"
> LOG 24/11/2008 15:46:23 (TRN elb sid=48 trid=49)
> [socket_client.cpp:socket_client::close_file_from_client:330]: Temporary
> file has been deleted C:\sedna\bin\../data/elb_files/tmp.148
>
> Here is my function for asking drop
>
> int SednaDbXml::ExecuteUpdate(struct SednaConnection& a_db, string a_query)
> {
> int iDbReturnValue;
>
> // execute query
> iDbReturnValue = SEexecute(&a_db, a_query.c_str());
> if(iDbReturnValue != SEDNA_UPDATE_SUCCEEDED)
> {
> std::cout << "Update failed:" << endl;
> std::cout << SEgetLastErrorMsg(&a_db) << endl;
> //closing session
> //SEclose(&a_db);
> return EXIT_FAILURE;
> }
> return EXIT_SUCCESS;
> }
>
> It seems that the problem is that query --- LOAD STDIN "V1DataSimu2"
> which takes too long and is automatically executed after the drop by sedna
> server itself. This query isn't a "user query" like the log says since i
> never sent such query.
>
> What is its purpose ? Can't it be avoided ? thanks :)
>
> -----La pièce jointe correspondante suit-----
>
> LOG 24/11/2008 15:40:28 (TRN elb sid=49 trid=-1) [tr.cpp:TRmain:251]:
> Session is ready
> LOG 24/11/2008 15:40:28 (TRN elb sid=49 trid=49)
> [tr_functions.cpp:on_user_statement_begin:79]: User query:
> --- for $b in document('$collections') return $b
> LOG 24/11/2008 15:40:29 (TRN elb sid=49 trid=49)
> [tr_functions.cpp:on_user_statement_begin:79]: User query:
> --- for $b in document('$documents')//documents/document return $b
> LOG 24/11/2008 15:40:29 (TRN elb sid=49 trid=49)
> [tr_functions.cpp:on_user_statement_begin:79]: User query:
> --- for $b in document('$indexes') return $b
> LOG 24/11/2008 15:40:30 (TRN elb sid=49 trid=49)
> [tr_functions.cpp:on_user_statement_begin:79]: User query:
> --- for $b in document("V1DataSimu") return $b
> LOG 24/11/2008 15:40:32 (TRN elb sid=49 trid=49)
> [tr_functions.cpp:on_user_statement_begin:79]: User query:
> --- for $b in document("V1DataSimu2") return $b
> LOG 24/11/2008 15:40:51 (TRN elb sid=48 trid=-1) [tr.cpp:TRmain:251]:
> Session is ready
> LOG 24/11/2008 15:40:53 (TRN elb sid=48 trid=48)
> [tr_functions.cpp:on_user_statement_begin:79]: User query:
> --- DROP DOCUMENT("V1DataSimu")
> LOG 24/11/2008 15:40:57 (TRN elb sid=48 trid=49)
> [tr_functions.cpp:on_user_statement_begin:79]: User query:
> --- LOAD STDIN "V1DataSimu"
> LOG 24/11/2008 15:41:34 (TRN elb sid=48 trid=49)
> [socket_client.cpp:socket_client::close_file_from_client:330]: Temporary
> file has been deleted C:\sedna\bin\../data/elb_files/tmp.148
> SYS 24/11/2008 15:41:41 (SM elb) [uhdd.c:uIsFileExist:369]:
> GetFileAttributes (code = 2): Le fichier spécifié est introuvable.
> LOG 24/11/2008 15:41:41 (SM elb) [trmgr.cpp:checkpoint_thread:172]:
> Checkpoint procedure is finished
> LOG 24/11/2008 15:41:41 (TRN elb sid=48 trid=49)
> [tr_functions.cpp:on_user_statement_begin:79]: User query:
> --- document("V1DataSimu")/ * / *
> LOG 24/11/2008 15:43:36 (TRN elb sid=48 trid=49)
> [tr_functions.cpp:on_user_statement_begin:79]: User query:
> --- DROP DOCUMENT("V1DataSimu2")
> LOG 24/11/2008 15:45:48 (TRN elb sid=48 trid=49)
> [tr_functions.cpp:on_user_statement_begin:79]: User query:
> --- LOAD STDIN "V1DataSimu2"
> LOG 24/11/2008 15:46:23 (TRN elb sid=48 trid=49)
> [socket_client.cpp:socket_client::close_file_from_client:330]: Temporary
> file has been deleted C:\sedna\bin\../data/elb_files/tmp.148
> SYS 24/11/2008 15:46:32 (SM elb) [uhdd.c:uIsFileExist:369]:
> GetFileAttributes (code = 2): Le fichier spécifié est introuvable.
> INFO 24/11/2008 15:46:32 (SM elb)
> [bm_core.cpp:bm_log_out_io_statistics:525]: IO block reads:24569,
> writes:31634
> LOG 24/11/2008 15:46:32 (SM elb) [trmgr.cpp:checkpoint_thread:172]:
> Checkpoint procedure is finished
> LOG 24/11/2008 15:46:32 (TRN elb sid=48 trid=-1) [tr.cpp:TRmain:533]:
> Session is closed
>
> ------------------------------
> *De :* Ivan Shcheklein <[EMAIL PROTECTED]>
> *À :* Prémon Nom <[EMAIL PROTECTED]>
> *Cc :* [email protected]
> *Envoyé le :* Vendredi, 21 Novembre 2008, 17h31mn 53s
> *Objet :* Re: [Sedna-discussion] Sedna Drop document really slow on large
> documents
>
> Hi Prémon,
>
> Can you send us this document to troubleshoot?
> In case you can't, send us please event***.log file(s) (located at
> SEDNA_DIR/data folder).
>
> Ivan Shcheklein,
> Sedna Team
>
> On Wed, Nov 19, 2008 at 7:38 PM, Prémon Nom <[EMAIL PROTECTED]> wrote:
>
>> Hi everyone,
>>
>> I'm learning Sedna and doing some benchmarks on large documents (the
>> resulting XML is about 50 MB).
>> Inserting the xml document (using C API) takes about 38 seconds. Deleting
>> it after using the DROP DOCUMENT "mydoc" command is really long (2 minutes
>> !)
>>
>> If someone has an explanation to why this command takes so long to
>> execute, a tip to decrease this time or an advice on what i may be doing
>> wrong, i thank you in advance.
>>
>>
>> -------------------------------------------------------------------------
>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>> challenge
>> Build the coolest Linux based applications with Moblin SDK & win great
>> prizes
>> Grand prize is a trip for two to an Open Source event anywhere in the
>> world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> Sedna-discussion mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/sedna-discussion
>>
>>
>
>
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
