[MonetDB-users] using MonetDB for INEX data
Dear MonetDB users, We are trying to add load the INEX XML Wikipedia data into MonetDB but we get some strange error messages: When adding documents: $ echo 'pf:add-doc("/data/erikt/inex2009/tmp/330.xml", "330")' | /storage/erikt/MonetDB/bin/mclient -lxquery MAPI = monetdb@localhost:50000 QUERY = pf:add-doc("/data/erikt/inex2009/tmp/330.xml", "330") ERROR = !ERROR: interpret_params: insert(param 3): invalid BAT. When querying the data: $ echo -e 'let $c := collection("330")\nfor $t in $c//article\nreturn($t//title/text())' | /storage/erikt/MonetDB/bin/mclient -lxquery ... text {"The Black Stallion (film)"}, text {"Halle, Germany"}, text {"FLCL"}, write error We get only 5% of the data that was expected from the query and then it crashes with the message "write error". Does anyone know what could cause these problems? Please respond to me personally (e.f.tjong.kim.sang(at)rug.nl) since I am not a member of this mailing list. Erik TKS -------- e-mail: e.f.tjong.kim.sang@rug.nl WWW: http://www.let.rug.nl/erikt/
Hi Erik, which version of MonetDB are you using on which platform (OS, HW)? The output of `Mserver --version` would give us some helpful information ... Since I'm not an INEX "expert", I would also be helpful (at least to me), whether you loaded only that one document or others as well, and how large the document(s) is(are). Stefan On Tue, Sep 01, 2009 at 02:03:35PM +0200, Erik Tjong Kim Sang wrote:
Dear MonetDB users,
We are trying to add load the INEX XML Wikipedia data into MonetDB but we get some strange error messages:
When adding documents:
$ echo 'pf:add-doc("/data/erikt/inex2009/tmp/330.xml", "330")' | /storage/erikt/MonetDB/bin/mclient -lxquery MAPI = monetdb@localhost:50000 QUERY = pf:add-doc("/data/erikt/inex2009/tmp/330.xml", "330") ERROR = !ERROR: interpret_params: insert(param 3): invalid BAT.
When querying the data:
$ echo -e 'let $c := collection("330")\nfor $t in $c//article\nreturn($t//title/text())' | /storage/erikt/MonetDB/bin/mclient -lxquery ... text {"The Black Stallion (film)"}, text {"Halle, Germany"}, text {"FLCL"}, write error
We get only 5% of the data that was expected from the query and then it crashes with the message "write error".
Does anyone know what could cause these problems? Please respond to me personally (e.f.tjong.kim.sang(at)rug.nl) since I am not a member of this mailing list.
Erik TKS -------- e-mail: e.f.tjong.kim.sang@rug.nl WWW: http://www.let.rug.nl/erikt/
------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
Stefan Manegold wrote:
which version of MonetDB are you using on which platform (OS, HW)? The output of `Mserver --version` would give us some helpful information ...
$ bin/Mserver --version MonetDB server v4.28.4 (32-bit), based on kernel v1.28.4 (32-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved Visit http://monetdb.cwi.nl/ for further information Configured for prefix: /storage/erikt/MonetDB Libraries: Compiled by: erikt @gialp Compilation: gcc -O2 -std=c99 Linking : /usr/bin/ld
Since I'm not an INEX "expert", I would also be helpful (at least to me), whether you loaded only that one document or others as well, and how large the document(s) is(are).
Yes, I have tried loading three other documents from the same collection and obtained the same error messages. The sizes of the documents are 45MB with about 15MB of text and 40MB of annotation (2 million XML tags per document). The deepest level of nesting is 54.
On Tue, Sep 01, 2009 at 02:03:35PM +0200, Erik Tjong Kim Sang wrote:
Dear MonetDB users,
We are trying to add load the INEX XML Wikipedia data into MonetDB but we get some strange error messages:
When adding documents:
$ echo 'pf:add-doc("/data/erikt/inex2009/tmp/330.xml", "330")' | /storage/erikt/MonetDB/bin/mclient -lxquery MAPI = monetdb@localhost:50000 QUERY = pf:add-doc("/data/erikt/inex2009/tmp/330.xml", "330") ERROR = !ERROR: interpret_params: insert(param 3): invalid BAT.
When querying the data:
$ echo -e 'let $c := collection("330")\nfor $t in $c//article\nreturn($t//title/text())' | /storage/erikt/MonetDB/bin/mclient -lxquery ... text {"The Black Stallion (film)"}, text {"Halle, Germany"}, text {"FLCL"}, write error
We get only 5% of the data that was expected from the query and then it crashes with the message "write error".
Does anyone know what could cause these problems? Please respond to me personally (e.f.tjong.kim.sang(at)rug.nl) since I am not a member of this mailing list.
Erik TKS -------- e-mail: e.f.tjong.kim.sang@rug.nl WWW: http://www.let.rug.nl/erikt/
participants (2)
-
Erik Tjong Kim Sang -
Stefan Manegold