users-list February 2010

users-list@monetdb.org

28 participants
29 discussions

[MonetDB-users] Meaning of: Scenario not initialized 'sql'

by Alex Bo.

Hi, Sometimes I get !MALException:setScenario:Scenario not initialized 'sql' from the server when I try to start it in scenarios that usually work without any problems. I can't reproduce it consistently, but sometimes I get it. What does this exception mean? Thanks. -- View this message in context: http://www.nabble.com/Meaning-of%3A-Scenario-not-initialized-%27sql%27-tp26… Sent from the monetdb-users mailing list archive at Nabble.com.

12 years, 1 month

[MonetDB-users] Parallel Processing

by Nafees Ur Rehman

Hi, Does monetdb has support for parallel processing? If some can guide me on that. Regards Nafees Ur Rehman

12 years, 2 months

[MonetDB-users] ubuntu server installation / php modules

by dariuszs

Hi, I've installed monetdb on *Ubuntu 9.04 Server* with apt-get. These are the contents of php client /. /usr /usr/share /usr/share/doc /usr/share/doc/php5-monetdb-client /usr/share/doc/php5-monetdb-client/changelog.Debian.gz /usr/share/doc/php5-monetdb-client/copyright I need the moduels, where are they? Thanks. Dariusz.

12 years, 4 months

[MonetDB-users] Slowdowns after Delete

by Reeves, Matthew J.

Hello, I have a MonetDB database that contains a table of rolling events. There are 200 million records with 500,000 bulk loaded each day with the oldest 500,000 deleted at midnight. I'm finding the database gets slower as time goes on. It gets to the point of being almost unusable after a week. Is there something I should be doing different? Thanks, Matt

12 years, 4 months

[MonetDB-users] Xquery Standoff Annotation Success Stories? GATE too?

by David Epstein

Hello, I am looking for information and experiences with monetdb's standoff annotation extension for Xquery. In particular, I'm looking for a way to more flexibly and conveniently search through documents I've manually annotated for semantic content using GATE (General Architecture for Text Engineering), which has its own standoff format. Has anyone had success in querying GATE documents using monetdb xquery with the standoff extension? If not GATE, what are people using to produce the standoff notation? thank you, -david David Epstein PhD Candidate Urban & Regional Planning University of Michigan USA

12 years, 5 months

[MonetDB-users] path to XML collection using doc() ?

by David Epstein

Hi everyone, Using the GUI (on localhost) I loaded: Migdal_2001_State_in_Society_BOOK.xml into test_collection_01. Using the query below (from http://monetdb.cwi.nl/XQuery/QuickTour/Books/index.html) as a template but using my own setup and schema, I keep getting: ERROR = !ERROR: err:FODC0002, Error retrieving resource (no such document... I've tried just about every permutation in the doc() statement I can think of. What should the path be? <bib> { for $b in doc("http://monetdb.cwi.nl/XQuery/files/bib.xml")/bib/book where $b/publisher = "Addison-Wesley" and $b/@year > 1991 return <book year="{ $b/@year }"> { $b/title } </book> } </bib> thank you, -david

12 years, 5 months

[MonetDB-users] Error on Queries 4.x of Star Schema Benchmark

by Rui Anastácio

Hello, I'm testing MonetDB with Star Schema Benchmark on a Linux Ubuntu box. I'm able to run all queries except 4.1, 4.2 and 4.3 I've tested with Scale Factor of 1, 5 and 10, and with 1, 3 and 7Gb RAM, and in all situations I gets this error: java.sql.SQLException: MALException:algebra.join:GDK reported error. ERROR: HEAPextend: failed to extend to 954941288 for 15/1560tail at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:2208) at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:1967) at nl.cwi.monetdb.jdbc.MonetStatement.internalExecute(MonetStatement.java:434) at nl.cwi.monetdb.jdbc.MonetStatement.execute(MonetStatement.java:347) at nl.cwi.monetdb.jdbc.MonetStatement.executeQuery(MonetStatement.java:451) at test.Main.test(Main.java:188) at test.Main.main(Main.java:158) With 1 Gb of RAM it could be lack of memory but not with 7Gb and a SF of 1. Any idea why this occours? Thanks. Rui Anastácio

12 years, 5 months

[MonetDB-users] Different query results after each execution

by Alex Bo.

Hi, I am getting weird behavior with a query that involves a LIKE comparison: This is the query: SELECT ("test2"."a1") AS "a1", (Count(DISTINCT CASE WHEN (Lower("test2"."a2") LIKE '%aaa%') THEN "test2"."a3" ELSE NULL END)) AS "m1" FROM "test"."test2" GROUP BY "test2"."a1" Whenever I run this query I get different results in my m1 field. If I remove the LIKE then it behaves fine. I can't seem to reproduce it on new tables with little data, but with the data I have (a table with 109402 rows) it does reproduce all the time. Can I upload the dbfarm and file this as a bug? -- View this message in context: http://old.nabble.com/Different-query-results-after-each-execution-tp276669… Sent from the monetdb-users mailing list archive at Nabble.com.

12 years, 5 months

[MonetDB-users] Weird behaviour with namespaces in XQuery

by Ignacio Martín Oya

Hello: I'm using MonetDB for a project. I've observed some weird results when doing a XQuery on an inserted document. Steps to reproduce the bug are: xquery>pf:add-doc ('file://var/tmp/pres-rules.xml', 'pres-rules.xml', 'pres-rules', 1) more>xquery>declare namespace xs="http://www.w3.org/2001/XMLSchema"; more>declare namespace cr="urn:ietf:params:xml:ns:common-policy"; more>declare namespace pr="urn:ietf:params:xml:ns:pres-rules"; more>count (doc('pres-rules.xml')/cr:ruleset/cr:rule[@id="pres_whitelist"]/cr:conditions/cr:identity) more><?xml version="1.0" encoding="utf-8"?> <XQueryResult>0</XQueryResult> However, sometimes, if I restart the Mserver, the same query returns: more>xquery>declare namespace xs="http://www.w3.org/2001/XMLSchema"; more>declare namespace cr="urn:ietf:params:xml:ns:common-policy"; more>declare namespace pr="urn:ietf:params:xml:ns:pres-rules"; more>count (doc('pres-rules.xml')/cr:ruleset/cr:rule[@id="pres_whitelist"]/cr:conditions/cr:identity) more><?xml version="1.0" encoding="utf-8"?> <XQueryResult>1</XQueryResult> What is the expected result. I'm sure it's related with namespaces after some tests. Are you aware of this behaviour? There exists some workaround? Document to test is attached. I'm using latest version of MonetDB with XQuery support: # MonetDB Server v4.34.4 # based on GDK v1.34.4 # Copyright (c) 1993-July 2008, CWI. All rights reserved. # Copyright (c) August 2008-2009, MonetDB B.V.. All rights reserved. # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically linked. # Detected 0.979 GiB (1051709440 bytes) main-memory. # Visit http://monetdb.cwi.nl/ for further information. # PF/Tijah module v0.13.0 loaded. http://dbappl.cs.utwente.nl/pftijah # MonetDB/XQuery module v0.34.4 loaded (default back-end is 'algebra') # XRPC administrative console at http://127.0.0.1:50001/admin Cheers, Nacho. -- -- Ignacio Martín Oya Project Engineer http://www.azetti.com Important: This e-mail may contain information confidential to Azetti Networks. If you are not the intended recipient it may be unlawful for you to read, copy, distribute, disclose or otherwise use information contained in it. If this is the case, please contact us immediately and we will assist you. Tel: +34 91 658 69 53 Fax: +34 91 651 40 42 E-mail: Reply to sender

12 years, 5 months

[MonetDB-users] Monetdb + unixODBC

by Alexander Barkov

Hello, I am a new in MonetDB. I'm testing MonetDB + unixODBC with an application which inserts long BLOB values, and I'm having some problems. Can you please help me? 1. When I use rc= SQLBindParameter(hstmt, position, SQL_PARAM_INPUT, SQL_C_DEFAULT, SQL_LONGVARBINARY, 0, 0, (char*) data, data_size, &BindBuf[position].size); I get error "Optional feature is not implemented". If I change SQL_LONGVARBINARY to SQL_VARCHAR, it works, however it wants the data in HEX notation, instead of raw binary buffer. That means I need 2*data_size extra memory to encode my binary data in hex, and then send the result send to SQLBindParameter. Is there a way to bind raw binary data, to avoid hex encoding? 2. When I insert blob data using rc= SQLExecDirect(hstms, "INSERT INTO t1 (blob_column)" "VALUES " "('<long hex-string>')", SQL_NTS); It works fine for short data, but it returns this error when hex-string is long enough: [SQLSTATE:S1000][unixODBC][MonetDB][ODBC Driver 1.0]current transaction is aborted (please ROLLBACK) I guess I hit some maximum possible query length limit, or maybe maximum possible transaction size. Is there a way to configure MonetDB to allow longer values? 3. Does the native MonetDB API have the same limitations with the bind types and maximum query(or transaction) size? Thank you very much!

12 years, 5 months

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

users-list February 2010