July 2009 - users-list

[MonetDB-users] Proofreading your professional documents
by Richard Hounslow 24 Feb '24

24 Feb '24

Dear Professor/Lecturer Please excuse us for contacting you directly. We are offering an efficient service to help you ensure your academic and professional work is written in perfect English. We will check the grammar and style of your work and return it to you to meet your requirements and deadlines. Proof-Reading-Service.com can provide you with a professional proofreading service at a very reasonable rate. All our proofreaders are highly qualified native English speakers. Many work as leading academics in their fields and all have extensive experience of proofreading to the highest standards. If you are interested in our service, please take a look at our website: www.proof-reading-service.com All you have to do is send us your document as a word attachment with the deadline and we will guarantee delivery of a perfectly written document to give you complete confidence when you submit your work. The fee is worked out on a flat rate (£6.95 per thousand words or 0.695 pence per word), so you know exactly how much the proofreading will cost in advance. Once we have received your document(s) we will confirm the word count, the price and the deadline. If you have not heard from us within 2 hours during normal business hours after you have sent your work please resend it from a different email account or send the file to proofreadings(a)gmail.com. We look forward to hearing from you! Yours faithfully Proof-Reading-Service.com

2 2

[MonetDB-users] ubuntu server installation / php modules
by dariuszs 29 Mar '10

29 Mar '10

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.

2 3

[MonetDB-users] Possible wrong results when Querying
by LeonardF 10 Nov '09

10 Nov '09

Hi There, I have some problem with the row_number() over() function. Consider the following table: create table "table1" ("customer" varchar(40), "product" varchar(40), "price" double) insert into "table1" values ('cust1', 'p1', 100) insert into "table1" values ('cust1', 'p2', 200) insert into "table1" values ('cust1', 'p3', 150) insert into "table1" values ('cust2', 'p1', 300) insert into "table1" values ('cust2', 'p3', 200) The following query over this table: SELECT "customer", "product", "sumprice", (Row_number() OVER(PARTITION BY "customer" ORDER BY "sumprice")) as "rank" FROM ( SELECT "customer", "product", (Sum("price")) AS "sumprice" FROM "table1" GROUP BY "customer", "product") AS "temp" Returns: Customer product sumprice rank Cust1 p1 100 1 Cust1 p2 200 2 Cust1 p3 150 3 Cust2 p1 300 1 Cust2 p3 200 2 But doesn’t it suppose to return the following result set?: Customer product sumprice rank Cust1 p1 100 1 Cust1 p3 150 2 Cust1 p2 200 3 Cust2 p3 200 1 Cust2 p1 200 2 Thanks -- Leonard Forgge -- View this message in context: http://www.nabble.com/Possible-wrong-results-when-Querying-tp22821802p22821… Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

[MonetDB-users] ODBC error (specified driver could not be loaded due to system error 126)
by fadk 13 Aug '09

13 Aug '09

I read that there was a bug like this before, but its been fixed. Its seems like installing ODBC drivers is a problem for windows. Can you assist with this ? I am running winXP using the MonetDB 32 installer. http://sourceforge.net/tracker/?func=detail&atid=482468&aid=1902879&group_i… Also, is it possible to only build the client (to use mapi) on winXP given that I have MonetDB installed. ? Thanks for your help. -- View this message in context: http://www.nabble.com/ODBC-error-%28specified-driver-could-not-be-loaded-du… Sent from the monetdb-users mailing list archive at Nabble.com.

4 4

[MonetDB-users] underlying storage
by Mag Gam 01 Aug '09

01 Aug '09

What is the recommended storage for MonetDB? We are planning to buy a Sun storage appliance and were wondering if it would work with MonetDB

4 7

Re: [MonetDB-users] server requires 'SHA512' hash, but client support was not compiled in
by Calum Miller 31 Jul '09

31 Jul '09

Hi, Managed to work around this issue by changing the default hashing algorithm in the configure file from SHA512 to MD. Needed a server rebuild. Calum

2 1

[MonetDB-users] server requires 'SHA512' hash, but client support was not compiled in
by Calum Miller 30 Jul '09

30 Jul '09

Hi, I built monetDb from source on Centos 5.0 but get the following error when I try to connect to the server via "mclient -lsql --time -d demo" server requires 'SHA512' hash, but client support was not compiled in I can't find a reference anywhere on how to resolve this, help much appreciated! Thanks Calum Miller

2 1

[MonetDB-users] Executing tijah query from module fails
by Roy Walter 29 Jul '09

29 Jul '09

[This is a new thread following on from "XRPC issues"] Executing a tijah query in a module from both old and new front ends fails. Using the old front end (\g) produces the following error: xquery>import module namespace test="tj" at "http://localhost:50001/export/tj.xq "; more>execute at {"localhost"} {test:tijahSearch("Heathrow")} more><> doLoopLiftedRPC: error occurred at localhost: MAPI = monetdb@localhost:50000 QUERY = import module namespace test="tj" at "http://localhost:50001/export/tj.x q"; ERROR = !ERROR: HTTP Error Code : 404 Bad Request !ERROR: SOAP Fault Code : env:Sender !ERROR: SOAP Fault Reason: !ERROR: Error occurred during execution. !ERROR: interpret: no matching MIL operator to 'tj_query_handler(bit, BA T[void,BAT], BAT[oid,BAT], BAT[void,BAT], BAT[oid,oid], BAT[oid,BAT], BAT[oid,ln g], BAT[oid,dbl], BAT[oid,str], void)'. !MAYBE YOU MEAN: ! tj_query_handler(bit, BAT[void,BAT], BAT[void,BAT], BAT[void,BAT ], BAT[oid,any], BAT[oid,BAT], BAT[void,lng], BAT[void,dbl], BAT[void,str], BAT[ void,BAT]) : BAT[void,BAT] ! ! !ERROR: CMDhttp_post: operation failed. MAPI = monetdb@localhost:50000 QUERY = import module namespace test="tj" at "http://localhost:50001/export/tj.x q"; ERROR = !ERROR: doLoopLiftedRPC: execution failed at all destinations: !ERROR: localhost: !ERROR: HTTP Error Code : 404 Bad Request !ERROR: SOAP Fault Code : env:Sender !ERROR: SOAP Fault Reason: !ERROR: Error occurred during execution. !ERROR: interpret: no matching MIL operator to 'tj_query_handler(bit, BA T[void,BAT], BAT[oid,BAT], BAT[void,BAT], BAT[oid,oid], BAT[oid,BAT], BAT[oid,ln g], BAT[oid,dbl], BAT[oid,str], void)'. !MAYBE YOU MEAN: ! tj_query_handler(bit, BAT[void,BAT], BAT[void,BAT], BAT[void,BAT ], BAT[oid,any], BAT[oid,BAT], BAT[void,lng], BAT[void,dbl], BAT[void,str], BAT[ void,BAT]) : BAT[void,BAT] ! ! !ERROR: CMDhttp_post: operation failed. !ERROR: !ERROR: xquery> Has anyone succeeded in executing a tijah query from within a module? -- Roy

3 8

[MonetDB-users] massive data loss on stop, start
by Matthew Jones 29 Jul '09

29 Jul '09

I added this information as a comment to bug *2825243* but I'm not sure if it's the same so I thought I'd post it here also to see about getting some feedback: I am experiencing widespread data corruption when restarting the May2009-SP1 MonetDB release also, but mine is much simpler. On 64-bit ubuntu: Linux dsvm01 2.6.24-23-server #1 SMP Wed Apr 1 22:14:30 UTC 2009 x86_64 GNU/Linux With a table defined as follows: CREATE TABLE "tablespace"."test_table" ( "col1" varchar(50), "col2" varchar(50), "col3" varchar(50), "col4" varchar(50), "col5" varchar(50), "col6" int, "col7" timestamp(7), "col8" int, "col9" int, "col10" int ); I imported 20998687 records into this table with all columns populated and ran a couple of queries to check the data: select count(*) from test_table ; [ 20998687 ] select count(*) from test_table where col1 = '' or col2 = '' or col3 = ''; [ 0 ] select max(col7), min(col7) from test_table ; [ 2009-07-25 14:17:15.538000, 2009-07-24 15:29:12.524000 ] During the time I loaded the data and ran these queries I did not restart the database, it had been up for about 3 days I then issued: monetdb stop db and monetdb start db and re-ran the queries: select count(*) from raw_plays ; [ 20998687 ] select count(*) from raw_plays where col1 = '' or col2 = '' or col3 = ''; [ 20852061 ] select max(col7), min(col7) from test_table ; [ 2009-07-25 14:17:15.538000, -1-01-01 00:00:00.000000 ] This is some serious data corruption, I've lost data in the vast majority of these records! 73, Matthew W. Jones (KI4ZIB) http://matburt.net

2 3

[MonetDB-users] Announcement: May2009-SP2 bug fix release
by Sjoerd Mullender 29 Jul '09

29 Jul '09

The MonetDB team at CWI/MonetDB BV is pleased to announce the May 2009-SP2 bug fix release of the MonetDB suite of programs. This is the second bug fix release for the May2009 release. More information on this release can be found at <http://monetdb.cwi.nl/projects/monetdb/Development/Releases/May2009/#May200…>. The sources and binaries are available at <http://monetdb.cwi.nl/projects/monetdb/Download/>. -- Sjoerd Mullender

1 0