- users-list - monetdb.org

[MonetDB-users] Bulk-Load Problem
by algatt 27 Oct '07

27 Oct '07

I am using MonetDB 5.0.0 and 1GB Ram on Windows XP. I am trying to use the TPC-H benchmark. With 1GB of test data everything worked fine, but if I try to load a table with more than 1GB of data the server crashes. Does this happen due to the 1GB of RAM? Also, when I use the number of records with the COPY command it copies more records. Any pointers? Thanks -- View this message in context: http://www.nabble.com/Bulk-Load-Problem-tf4702911.html#a13442730 Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

[MonetDB-users] Very slow group by sql query
by Arjen van der Meijden 22 Oct '07

22 Oct '07

Hi list, I was just doing some basic queries on MonetDB5/SQL to see if it is suitable for my application, I'm doing lots of aggregates on some logfile-abstractions. Basically they all boil down to 'how many unique visitors and total pageviews where there in period X-Y in section Z'. I have this table: pageviews ( timestamp timestamp not null, clientip varchar(15) not null, sectionid smallint not null, itemid integer not null, channelid smallint default 0 ) Currently it only contains data for last september, with about 2M records/day, and 5.6M in total. There are no additional indexes in this case. When doing a query like this, monetdb very fast. Once the data is in the memory cache, it returns (according to trace) in about half a second. select count(*) from pageviews where timestamp between '2007-09-21 00:00:00' and '2007-09-22 00:00:00'; The result is 1916813 This one is also pretty fast, taking about 1.7 second select count(distinct clientip) from pageviews where timestamp between '2007-09-21 00:00:00' and '2007-09-22 00:00:00'; The result is 165700 And the third which is pretty fast: select channelid, count(*) from pageviews where timestamp between '2007-09-21 00:00:00' and '2007-09-22 00:00:00' group by channelid; Here's the distribution, and its returned in about 0.6 second [ 0, 538187 ] [ 1, 1108478 ] [ 4, 42867 ] [ 3, 145565 ] [ 2, 81716 ] But when I combine those last two queries, the result isn't returned in a reasonable amount of time, I waited for more than half an hour and it still hadn't returned the results. select channelid, count(distinct clientip), count(*) from pageviews where timestamp between '2007-09-21 00:00:00' and '2007-09-22 00:00:00' group by channelid; I'm not very good at reading your explain output yet, so I've attached the resulting explain for that query. Is there a way to speed up this type of query? It seems a bit odd that it's taking more than half an hour (postgresql does it in about 20 seconds) while the other queries return much faster (postgresql does them in about 14 seconds). Best regards, Arjen function user.s5_1():void; _1:bat[:oid,:timestamp]{rows=55914459:lng,bid=1968} := sql.bind("sys","pageviews","timestamp",0); _10:bat[:oid,:timestamp]{rows=0:lng,bid=2323} := sql.bind("sys","pageviews","timestamp",1); constraints.emptySet(_10); _10:bat[:oid,:timestamp]{rows=0:lng,bid=2323} := nil; _12:bat[:oid,:timestamp]{rows=0:lng,bid=2324} := sql.bind("sys","pageviews","timestamp",2); constraints.emptySet(_12); _12:bat[:oid,:timestamp]{rows=0:lng,bid=2324} := nil; _17:bat[:oid,:sht]{notnil=true,rows=55914459:lng,bid=1969} := sql.bind("sys","pageviews","channelid",0); _24:bat[:oid,:str]{rows=55914459:lng,bid=1961} := sql.bind("sys","pageviews","clientip",0); _8{rows=27957230:lng} := algebra.uselect(_1,2007-09-21 00:00:00.000,2007-09-22 00:00:00.000,true,true); _1:bat[:oid,:timestamp]{rows=55914459:lng,bid=1968} := nil; _15{rows=27957230:lng} := algebra.markT(_8,0@0); _8{rows=27957230:lng} := nil; _16{rows=27957230:lng} := bat.reverse(_15); _15{rows=27957230:lng} := nil; _19{rows=27957230:lng} := algebra.join(_16,_17); (ext40,grp38):= group.new(_19); _19{rows=27957230:lng} := nil; _22 := bat.mirror(ext40); ext40 := nil; _23 := algebra.joinPath(_22,_16,_17); _17:bat[:oid,:sht]{notnil=true,rows=55914459:lng,bid=1969} := nil; _26{rows=27957230:lng} := algebra.join(_16,_24); _16{rows=27957230:lng} := nil; _24:bat[:oid,:str]{rows=55914459:lng,bid=1961} := nil; (_27,grp55):= group.new(grp38); (_29,grp57):= group.derive(_27,grp55,_26); _27 := nil; grp55 := nil; _31 := bat.mirror(_29); _29 := nil; _32 := algebra.semijoin(_26,_31); _26{rows=27957230:lng} := nil; _31 := nil; _33:bat[:oid,:int] := aggr.count_no_nil(_32,grp38,_22); _32 := nil; _34:bat[:oid,:int] := aggr.count(grp38,grp38,_22); grp38 := nil; _22 := nil; _35 := sql.resultSet(3,1,_23); sql.rsColumn(_35,"sys.pageviews","channelid","smallint",16,0,_23); _23 := nil; sql.rsColumn(_35,"sys.pageviews","count_no_nil_clientip","int",15,0,_33); _33:bat[:oid,:int] := nil; sql.rsColumn(_35,"sys.pageviews","count_channelid","int",32,0,_34); _34:bat[:oid,:int] := nil; sql.exportResult(_35,""); end s5_1;

4 6

[MonetDB-users] Server Crashes when Client is Opened
by algatt 21 Oct '07

21 Oct '07

Hello, I have installed Monet and created the TPC-H schema and populated it with data. Once all data was copied, I restarted the computer to try the queries. However, now the server starts, but when I open the client everything closes immediately. I uninstalled it, and re-installed it and the same happens. Any help? Thank You. Regards, Alan -- View this message in context: http://www.nabble.com/Server-Crashes-when-Client-is-Opened-tf4657643.html#a… Sent from the monetdb-users mailing list archive at Nabble.com.

3 6

[MonetDB-users] delete query with where clause
by pawan123 10 Oct '07

10 Oct '07

When I use without where clause if ((hdl = mapi_query(dbh,"select * from logException )) == NULL || mapi_error(dbh) != MOK) die(dbh, hdl); It is working fine. But when I use with where condition if ((hdl = mapi_query(dbh,"delete * from logException where logid=1 )) == NULL || mapi_error(dbh) != MOK) die(dbh, hdl); It is deleting the record only from memory not from database. -- View this message in context: http://www.nabble.com/delete-query-with-where-clause-tf4598673.html#a131295… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] configure warning
by Ying Zhang 09 Oct '07

09 Oct '07

Hello, During 'configure' of the MonetDB4 module (Stable branch, MonetDB_4-20), I got the warning: configure: WARNING: fcntl.h: present but cannot be compiled configure: WARNING: fcntl.h: check for missing prerequisite headers? configure: WARNING: fcntl.h: see the Autoconf documentation configure: WARNING: fcntl.h: section "Present But Cannot Be Compiled" configure: WARNING: fcntl.h: proceeding with the preprocessor's result configure: WARNING: fcntl.h: in the future, the compiler will take precedence The same warning was given about several other header files, e.g. limits.h, pwd.h, time.h, sys/time.h, utime.h, ... The compilation was finished without further problems, but I would like to know why I got these warnings, since this is something new. Thanks! Jennie

2 1

[MonetDB-users] how to measure a query execution time
by xxiao 08 Oct '07

08 Oct '07

Hi, I need to measure the sql query execution time. So I used "-t" option with mclient command. For example, I use "mclient -lsql -umonetdb -Pmonetdb -t < 15.sql" to execute query 15 in TPC-H benchmark. I have the following outputs: Timer 935.765 msec Timer 717.294 msec Timer 0.163 msec % sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.revenue0 # table_name % s_suppkey, s_name, s_address, s_phone, total_revenue # name % int, varchar, varchar, varchar, decimal # type % 4, 18, 17, 15, 21 # length [ 8449, "Supplier#000008449", "Wp34zim9qYFbVctdW", "20-469-856-8873", 1772627.2087 ] Timer 3559.856 msec Timer 0.079 msec Timer 63.676 msec Timer 0.890 msec % .stats, .stats # table_name % rewrite, count # name % clob, int # type % 7, 1 # length [ "joinidx", 0 ] Timer 1.043 msec There are multiple lines started with "Timer" and ended by a time measurement in milli-sec. So is the execution time of query 15 in TPC-H equal to the sum of all these time measurements. In this case, 935.765+717.294+0.163+3559.856+0.079+63.676+0.890+1.043=5278.766 msec. I appreciate your response. Xiang -- View this message in context: http://www.nabble.com/how-to-measure-a-query-execution-time-tf4588760.html#… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] convert string to timestamp in MonetDB
by pawan123 04 Oct '07

04 Oct '07

is there any function in MonetDB that can convert string (i.e.Thu Oct 04 14:36:17 2007) in to timestamp; Thanks Pawan -- View this message in context: http://www.nabble.com/convert-string-to-timestamp-in-MonetDB-tf4567699.html… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] What is optimizer_stats()
by Pranav Vaidya 03 Oct '07

03 Oct '07

Hi, I am new to MonetDB and I am trying to run the TPC-H benchmarks and I was able to successfully load and execute the benchmarks in MonetDB version 4. I also verified whether the tables were populated using Dbvis. However, what seems to fail is the lack of a function called optimizer_stats() in the run.all script. Is this a procedure or a function defined additionally which is needed. And why is it not present ? Do I need to run some additional scripts to have this run.all script go through successfully without any errors. Thanks and Regards, Pranav. -- View this message in context: http://www.nabble.com/What-is-optimizer_stats%28%29-tf4564307.html#a13027620 Sent from the monetdb-users mailing list archive at Nabble.com.

3 4

[MonetDB-users] (no subject)
by Matt Magoffin 02 Oct '07

02 Oct '07

Hello, I am interested in evaluating MonetDB/XQuery. I have some XML collections for a project I work on that are of 1-2 million individual XML documents for which I use XQuery to access for OLAP style reporting operations. This is a Java-based project, and while working on this project I developed a thin XQuery-centric API so that I could evaluate/use many different XQuery implementations, which my company released as an open source project called Xaj (http://sourceforge.net/projects/xaj) Currently I am using a Berkeley DB XML implementation, but am interested in exploring other options. I'd like to implement a MonetDB version of this API now, but I am having some difficulty finding out how to effectively access MonetDB through Java. So far I was able to use the MonetDB JDBC driver to construct XQuery statements and get XML results, and also I was able to construct MonetDB pf:add-doc() statements to add documents, but I am wondering if this is the best approach (and if so, how to add documents to a remote MonetDB server using the pf:add-doc() mechanism). The API I am trying to implement you can view here, to give you an idea what I'm trying to do: http://xaj.svn.sourceforge.net/viewvc/xaj/xaj/src/net/sf/xaj/XmlDb.java?rev… It was somewhat modeled after the defunct XML:DB API, but focused just on add/store/XQuery operations. Any help/advise would be greatly appreciated! -- m@

1 0

[MonetDB-users] how we convert the value of timestamp in minutes
by pawan123 28 Sep '07

28 Sep '07

how we convert the value of timestamp in minutes -- View this message in context: http://www.nabble.com/how-we-convert-the-value-of-timestamp-in-minutes-tf45… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] how we get the timestamp value 10 minutes before from current_timestamp
by pawan123 28 Sep '07

28 Sep '07

how we get the timestamp value 10 minutes before from current_timestamp -- View this message in context: http://www.nabble.com/how-we-get-the-timestamp-value-10-minutes-before-from… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] how to run TPC-H benchmark on MonetDB
by xxiao 27 Sep '07

27 Sep '07

hi, I am a beginner of MonetDB. I want to run TPC-H benchmark on MonetDB. I found there are SQL queries and related files under monetdb source folder <monetdb-source>/sql/src/benchmark/tpch. I ran the script 'run.all'. But that gave me many errors and did not succeed. Can anyone describe briefly the steps I need to carry out in order to run TPC-H benchmark? Any documentations I can refer to is highly appreciated. Thank you. -- View this message in context: http://www.nabble.com/how-to-run-TPC-H-benchmark-on-MonetDB-tf4524693.html#… Sent from the monetdb-users mailing list archive at Nabble.com.

4 5

[MonetDB-users] minus 10 minutes from current_timestamp
by pawan123 27 Sep '07

27 Sep '07

how we minus 10 minutes from current_timestamp. because i have to fetch all the records from a table 10 minutes before currenttimestamp. so pls tell me how we deternine 10 min before timestamp value. Thanks pawan -- View this message in context: http://www.nabble.com/minus-10-minutes-from-current_timestamp-tf4526685.htm… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] I want to select records from MonetDB
by pawan123 25 Sep '07

25 Sep '07

I want to select records from a table on the basis of date in MonetDB and then insert all these selected records in a table i.e. present in oracle using C or Pro*C. can any one help me in writing the code. Thanks in advance. Pawan -- View this message in context: http://www.nabble.com/I-want-to-select-records-from-MonetDB-tf4514715.html#… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] Database tool
by Venks 25 Sep '07

25 Sep '07

Hi, What's the good database tool that I can use to connect to MonetDB, run queries and browse the objects? I used to use DBVisualizer earlier and now both 5.1.1 and 6.0.x version are giving errors. I installed the latest version of the MonetDB couple of weeks ago and I think the changes in the new version of MonetDB (JDBC) are causing these issues. Thanks, -Venks

3 2

[MonetDB-users] building client on Windows
by Sander Kruseman 24 Sep '07

24 Sep '07

Hi, I want to construct a Monet client app in C on Windows but find very sparse info on this. I took notice of the fact that Windows is apparently not exactly Monet's main target platform. Still, I tried using nmake on the client sources but ran into errors involving missing (or incorrectly placed) files (see below). Do I really have to go through the complete 'Experts > Windows Installation', i.e. building MonetDB server itself? regards, Sander ...\clients-1.18.2\src\mapilib>nmake -f makefile.msc Microsoft (R) Program Maintenance Utility Version 8.00.50727.42 Copyright (C) Microsoft Corporation. All rights reserved. makefile.msc(8) : fatal error U1052: file '.\..\..\rules.msc' not found

2 1

[MonetDB-users] Cannot manipulate XML Document
by Timothy Marc 24 Sep '07

24 Sep '07

Hello all, I've downloaded MonetDB XQuery for evaluating the XQuery Update Facility. I've shredderd a document and can perform xqueries from MapiClient successfully. But, when i try to update a document, the process fails with error message: !ERROR updating read-only document. May i have to specify some flags or something else??? Thx Timothy

2 1

[MonetDB-users] can we create cache group in MonetDB
by pawan123 24 Sep '07

24 Sep '07

all we know about Timesten Database with oracle. can we use this MonetDB like Timesten Database with oracle.means can we create cache group in MonetDB. Thanks Pawan -- View this message in context: http://www.nabble.com/can-we-create-cache-group-in-MonetDB-tf4492681.html#a… Sent from the monetdb-users mailing list archive at Nabble.com.

3 3

[MonetDB-users] can we create cache group in MonetDB
by Pawan Kumar Gupta 21 Sep '07

21 Sep '07

all we know about Timesten Database with oracle. can we use this MonetDB like Timesten Database with oracle.means can we create cache group in MonetDB. Thanks Pawan

1 0

[MonetDB-users] Persistent Stored Modules and a SQL issue
by Venks 18 Sep '07

18 Sep '07

Two questions. 1. Can I execute a dynamic DDL statement using PSM? 2. I am trying to create a script where I would like to DROP A TABLE before re-creating it. If I include the DROP TABLE in the script, MonetDB throws an error and STOPs execution if the table is not found. This is rather painful as I would like MonetDB to continue with the next SQL command. For. e.g DROP TABLE table1 ; CREATE TABLE table1 .... If I include the above 2 commands in one script, then the above scripts stops execution if "table1" doesn't exists. Thanks, -Venks

2 3

[MonetDB-users] MonetDB vs MySQL naive benchmark.
by Dan Libby 16 Sep '07

16 Sep '07

Hi, I just downloaded and started experimenting with MonetDB today. We have a large PHP/mysql app that runs millions of small/simple queries to generate various reports. (It needs to be refactored, but that is hard). Anyway, for starters, I wrote a very small/stupid benchmark script for both monetdb and mysql. I expected monetdb to be slower at populating the table, and faster at selecting from it, but it was slower at both. So below I am presenting my results, and my php scripts, and I would be very interested to know if there is a problem in my methodology, or if I should be running certain types of queries that monetdb will excel at. Mysql Results: -------------- $ php testmysql.php MySQL Test Dropping previous table (if present) Dropped in 0.000669 seconds creating table Created in 0.007732 seconds populating table Populated in 1.163141 seconds selecting from table queried 10000 records in 1.446646 seconds MonetDB Results: ---------------- $ php testmonet.php MonetDB Test Dropping table Dropped in 0.039597 seconds creating table Created in 0.001858 seconds populating table Populated in 7.513073 seconds selecting from table Queried 10000 records in 2.680834 seconds One interesting thing I noticed is that if I did not include the primary key index on the where-clause column, then mysql took ~80 seconds, and Monet still took about ~2.5 seconds. I guess this is because Monet just uses user-specified indexes as hints, so it had really created one anyway, yes? Anyway, here are the PHP scripts I used: testmonet.php ---------------- <?php echo "MonetDB Test\n"; $db = @monetdb_connect('sql', 'localhost', 50000, 'monetdb', 'monetdb') or die('Failed to connect to MonetDB<br>'); echo "Dropping table\n"; $start_time = microtime(true); $sql = "drop table big_table;"; $res = monetdb_query($sql); echo sprintf( "Dropped in %f seconds\n\n", microtime(true) - $start_time); echo "creating table\n"; $start_time = microtime(true); $sql = "create table big_table( col1 int primary key, col2 varchar(20), col3 int, col4 varchar(20) );"; $res = monetdb_query($sql) or die ("failed to create table" ); echo sprintf( "Created in %f seconds\n\n", microtime(true) - $start_time); echo "populating table\n"; $start_time = microtime(true); for( $i = 0; $i < 10000; $i ++ ) { $sql = "insert into big_table values ($i, 'col2 $i', $i, 'col4 $i' )"; $res = monetdb_query( $sql ) or die ("failed to insert at row $i " ); } echo sprintf( "Populated in %f seconds\n\n", microtime(true) - $start_time); echo "selecting from table\n"; $start_time = microtime(true); for( $i = 0; $i < 10000; $i ++ ) { $sql = "select col1 from big_table where col1 = $i"; $res = monetdb_query($sql); while ( $row = monetdb_fetch_assoc($res) ) { // print_r($row); } } echo sprintf( "Queried 10000 records in %f seconds\n\n", microtime(true) - $start_time); ?> testmysql.php ---------------- <?php echo "MySQL Test\n"; $db = @mysql_connect('localhost', 'root', '', 'monetdb') or die('Failed to connect to MySQL<br>'); mysql_select_db( "perftest" ) or die ("Failed to select DB" ); echo "Dropping previous table (if present)\n"; $start_time = microtime(true); $sql = "drop table big_table"; $res = mysql_query($sql); echo sprintf( "Dropped in %f seconds\n\n", microtime(true) - $start_time); echo "creating table\n"; $start_time = microtime(true); $sql = "create table big_table( col1 int primary key, col2 varchar(20), col3 int, col4 varchar(20) );"; $res = mysql_query($sql) or die ("failed to create table" ); echo sprintf( "Created in %f seconds\n\n", microtime(true) - $start_time); echo "populating table\n"; $start_time = microtime(true); for( $i = 0; $i < 10000; $i ++ ) { $sql = "insert into big_table values ($i, 'col2 $i', $i, 'col4 $i' )"; $res = mysql_query( $sql ) or die ("failed to insert at row $i " ); } echo sprintf( "Populated in %f seconds\n\n", microtime(true) - $start_time); echo "selecting from table\n"; $start_time = microtime(true); for( $i = 0; $i < 10000; $i ++ ) { $sql = "select col1 from big_table where col1 = $i"; $res = mysql_query($sql); while ( $row = mysql_fetch_assoc($res) ) { // print_r($row); } } echo sprintf( "queried 10000 records in %f seconds\n\n", microtime(true) - $start_time); ?> </body> </html>

3 4

[MonetDB-users] MonetDB vs MySQL naive benchmark.
by Dan Libby 16 Sep '07

16 Sep '07

Hi, I just downloaded and started experimenting with MonetDB today. We have a large PHP/mysql app that runs millions of small/simple queries to generate various reports. (It needs to be refactored, but that is hard). Anyway, for starters, I wrote a very small/stupid benchmark script for both monetdb and mysql. I expected monetdb to be slower at populating the table, and faster at selecting from it, but it was slower at both. So below I am presenting my results, and my php scripts, and I would be very interested to know if there is a problem in my methodology, or if I should be running certain types of queries that monetdb will excel at. Mysql Results: -------------- $ php testmysql.php MySQL Test Dropping previous table (if present) Dropped in 0.000669 seconds creating table Created in 0.007732 seconds populating table Populated in 1.163141 seconds selecting from table queried 10000 records in 1.446646 seconds MonetDB Results: ---------------- $ php testmonet.php MonetDB Test Dropping table Dropped in 0.039597 seconds creating table Created in 0.001858 seconds populating table Populated in 7.513073 seconds selecting from table Queried 10000 records in 2.680834 seconds One interesting thing I noticed is that if I did not include the primary key index on the where-clause column, then mysql took ~80 seconds, and Monet still took about ~2.5 seconds. I guess this is because Monet just uses user-specified indexes as hints, so it had really created one anyway, yes? Anyway, here are the PHP scripts I used: testmonet.php ---------------- <?php echo "MonetDB Test\n"; $db = @monetdb_connect('sql', 'localhost', 50000, 'monetdb', 'monetdb') or die('Failed to connect to MonetDB<br>'); echo "Dropping table\n"; $start_time = microtime(true); $sql = "drop table big_table;"; $res = monetdb_query($sql); echo sprintf( "Dropped in %f seconds\n\n", microtime(true) - $start_time); echo "creating table\n"; $start_time = microtime(true); $sql = "create table big_table( col1 int primary key, col2 varchar(20), col3 int, col4 varchar(20) );"; $res = monetdb_query($sql) or die ("failed to create table" ); echo sprintf( "Created in %f seconds\n\n", microtime(true) - $start_time); echo "populating table\n"; $start_time = microtime(true); for( $i = 0; $i < 10000; $i ++ ) { $sql = "insert into big_table values ($i, 'col2 $i', $i, 'col4 $i' )"; $res = monetdb_query( $sql ) or die ("failed to insert at row $i " ); } echo sprintf( "Populated in %f seconds\n\n", microtime(true) - $start_time); echo "selecting from table\n"; $start_time = microtime(true); for( $i = 0; $i < 10000; $i ++ ) { $sql = "select col1 from big_table where col1 = $i"; $res = monetdb_query($sql); while ( $row = monetdb_fetch_assoc($res) ) { // print_r($row); } } echo sprintf( "Queried 10000 records in %f seconds\n\n", microtime(true) - $start_time); ?> testmysql.php ---------------- <?php echo "MySQL Test\n"; $db = @mysql_connect('localhost', 'root', '', 'monetdb') or die('Failed to connect to MySQL<br>'); mysql_select_db( "perftest" ) or die ("Failed to select DB" ); echo "Dropping previous table (if present)\n"; $start_time = microtime(true); $sql = "drop table big_table"; $res = mysql_query($sql); echo sprintf( "Dropped in %f seconds\n\n", microtime(true) - $start_time); echo "creating table\n"; $start_time = microtime(true); $sql = "create table big_table( col1 int primary key, col2 varchar(20), col3 int, col4 varchar(20) );"; $res = mysql_query($sql) or die ("failed to create table" ); echo sprintf( "Created in %f seconds\n\n", microtime(true) - $start_time); echo "populating table\n"; $start_time = microtime(true); for( $i = 0; $i < 10000; $i ++ ) { $sql = "insert into big_table values ($i, 'col2 $i', $i, 'col4 $i' )"; $res = mysql_query( $sql ) or die ("failed to insert at row $i " ); } echo sprintf( "Populated in %f seconds\n\n", microtime(true) - $start_time); echo "selecting from table\n"; $start_time = microtime(true); for( $i = 0; $i < 10000; $i ++ ) { $sql = "select col1 from big_table where col1 = $i"; $res = mysql_query($sql); while ( $row = mysql_fetch_assoc($res) ) { // print_r($row); } } echo sprintf( "queried 10000 records in %f seconds\n\n", microtime(true) - $start_time); ?> </body> </html>

2 3

[MonetDB-users] [Newbie] sizeof(ssize_t) error on Solaris 10
by Pranav Vaidya 13 Sep '07

13 Sep '07

Hello, I am trying to install MonetDB on Solaris 10/UltraSparc III and Fedora6/AMD. I tried running monetdb-install.sh as suggested in the documentation. The Fedora installation went on fine without any hitches. However, the solaris 10 installation failed. The script is failing due to some error on the test which determines sizeof(ssize_t). To see if there was some problem in my sys/types.h I compiled and executed a code which I think is used by the configure script. This test program ran without any issues writing a value of 4 to the conftest.val file. My guess is ssize_t is typedefd as an int on my machine. The test program is as follows : #include <stddef.h> #include <sys/types.h> long longval () { return (long) (sizeof (ssize_t)); } unsigned long ulongval () { return (long) (sizeof (ssize_t)); } #include <stdio.h> #include <stdlib.h> int main () { FILE *f = fopen ("conftest.val", "w"); if (! f) exit (1); if (((long) (sizeof (ssize_t))) < 0) { long i = longval (); if (i != ((long) (sizeof (ssize_t)))) exit (1); fprintf (f, "%ld\n", i); } else { unsigned long i = ulongval (); if (i != ((long) (sizeof (ssize_t)))) exit (1); fprintf (f, "%lu\n", i); } exit (ferror (f) || fclose (f) != 0); ; return 0; } I am attaching the relevant portion of the config.log that is produced. I would appreciate any inputs on how to resolve this issue and why it arises. ------------------------------------------------------------------------------------------------------------------------------------------------------ #include <sys/types.h> | | long longval () { return (long) (sizeof (ssize_t)); } | unsigned long ulongval () { return (long) (sizeof (ssize_t)); } | #include <stdio.h> | #include <stdlib.h> | int | main () | { | | FILE *f = fopen ("conftest.val", "w"); | if (! f) | exit (1); | if (((long) (sizeof (ssize_t))) < 0) | { | long i = longval (); | if (i != ((long) (sizeof (ssize_t)))) | exit (1); | fprintf (f, "%ld\n", i); | } | else | { | unsigned long i = ulongval (); | if (i != ((long) (sizeof (ssize_t)))) | exit (1); | fprintf (f, "%lu\n", i); | } | exit (ferror (f) || fclose (f) != 0); | | ; | return 0; | } configure:26151: error: cannot compute sizeof (ssize_t), 77 See `config.log' for more details. The following is the configure output - MonetDB>./configure checking build system type... sparc-sun-solaris2.10 checking host system type... sparc-sun-solaris2.10 checking target system type... sparc-sun-solaris2.10 checking for a BSD-compatible install... /usr/local/bin/ginstall -c checking whether build environment is sane... yes checking for gawk... gawk checking whether make sets $(MAKE)... yes checking for style of include used by make... GNU checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ANSI C... none needed checking dependency style of gcc... none checking for egrep... egrep checking for ANSI C header files... no checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking how to run the C preprocessor... gcc -E checking for gcc... (cached) gcc checking whether we are using the GNU C compiler... (cached) yes checking whether gcc accepts -g... (cached) yes checking for gcc option to accept ANSI C... (cached) none needed checking dependency style of gcc... (cached) none checking for long... yes checking size of long... 4 checking whether byte ordering is bigendian... yes checking if your compiler is C99 compliant... yes checking for ant... no checking for java... /bin/java checking for Java >= 1.4, but < 1.6... yes -> 1.5.0_12 found checking for javac... /bin/javac checking for jar... /bin/jar checking for javadoc... /bin/javadoc checking for a sed that does not truncate output... /usr/local/bin/gsed checking for option to reload object files... -r checking for BSD-compatible nm... /usr/local/bin/nm -B checking whether ln -s works... yes checking how to recognise dependent libraries... pass_all checking dlfcn.h usability... no checking dlfcn.h presence... yes configure: WARNING: dlfcn.h: present but cannot be compiled configure: WARNING: dlfcn.h: check for missing prerequisite headers? configure: WARNING: dlfcn.h: see the Autoconf documentation configure: WARNING: dlfcn.h: section "Present But Cannot Be Compiled" configure: WARNING: dlfcn.h: proceeding with the preprocessor's result configure: WARNING: dlfcn.h: in the future, the compiler will take precedence configure: WARNING: ## --------------------------- ## configure: WARNING: ## Report this to monet(a)cwi.nl ## configure: WARNING: ## --------------------------- ## checking for dlfcn.h... yes checking for g++... g++ checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking dependency style of g++... none checking how to run the C++ preprocessor... g++ -E checking for g77... g77 checking whether we are using the GNU Fortran 77 compiler... yes checking whether g77 accepts -g... yes checking for flex... flex checking lex output file root... lex.yy checking whether yytext is a pointer... no checking for a BSD-compatible install... /usr/local/bin/ginstall -c checking for ld used by gcc... /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking the maximum length of command line arguments... 262144 checking command to parse /usr/local/bin/nm -B output from gcc object... ok checking for objdir... .libs checking for ar... ar checking for ranlib... ranlib checking for strip... strip checking if gcc supports -fno-rtti -fno-exceptions... no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc static flag -static works... no checking if gcc supports -c -o file.o... yes checking whether the gcc linker (/usr/ccs/bin/ld) supports shared libraries... yes checking whether -lc should be explicitly linked in... yes checking dynamic linker characteristics... solaris2.10 ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes checking for shl_load... no checking for shl_load in -ldld... no checking for dlopen... yes checking whether a program can dlopen itself... yes checking whether a statically linked program can dlopen itself... yes checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... no configure: creating libtool appending configuration tag "CXX" to libtool checking for ld used by g++... /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking whether the g++ linker (/usr/ccs/bin/ld) supports shared libraries... yes checking for g++ option to produce PIC... -fPIC checking if g++ PIC flag -fPIC works... yes checking if g++ static flag -static works... no checking if g++ supports -c -o file.o... yes checking whether the g++ linker (/usr/ccs/bin/ld) supports shared libraries... yes checking dynamic linker characteristics... solaris2.10 ld.so checking how to hardcode library paths into programs... immediate appending configuration tag "F77" to libtool checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... no checking for g77 option to produce PIC... -fPIC checking if g77 PIC flag -fPIC works... yes checking if g77 static flag -static works... no checking if g77 supports -c -o file.o... yes checking whether the g77 linker (/usr/ccs/bin/ld) supports shared libraries... yes checking dynamic linker characteristics... solaris2.10 ld.so checking how to hardcode library paths into programs... immediate checking for ANSI C header files... (cached) no checking whether time.h and sys/time.h may both be included... yes checking for dirent.h that defines DIR... yes checking for library containing opendir... none required checking alloca.h usability... no checking alloca.h presence... yes configure: WARNING: alloca.h: present but cannot be compiled configure: WARNING: alloca.h: check for missing prerequisite headers? configure: WARNING: alloca.h: see the Autoconf documentation configure: WARNING: alloca.h: section "Present But Cannot Be Compiled" configure: WARNING: alloca.h: proceeding with the preprocessor's result configure: WARNING: alloca.h: in the future, the compiler will take precedence configure: WARNING: ## --------------------------- ## configure: WARNING: ## Report this to monet(a)cwi.nl ## configure: WARNING: ## --------------------------- ## checking for alloca.h... yes checking getopt.h usability... no checking getopt.h presence... yes configure: WARNING: getopt.h: present but cannot be compiled configure: WARNING: getopt.h: check for missing prerequisite headers? configure: WARNING: getopt.h: see the Autoconf documentation configure: WARNING: getopt.h: section "Present But Cannot Be Compiled" configure: WARNING: getopt.h: proceeding with the preprocessor's result configure: WARNING: getopt.h: in the future, the compiler will take precedence configure: WARNING: ## --------------------------- ## configure: WARNING: ## Report this to monet(a)cwi.nl ## configure: WARNING: ## --------------------------- ## checking for getopt.h... yes checking netdb.h usability... no checking netdb.h presence... yes configure: WARNING: netdb.h: present but cannot be compiled configure: WARNING: netdb.h: check for missing prerequisite headers? configure: WARNING: netdb.h: see the Autoconf documentation configure: WARNING: netdb.h: section "Present But Cannot Be Compiled" configure: WARNING: netdb.h: proceeding with the preprocessor's result configure: WARNING: netdb.h: in the future, the compiler will take precedence configure: WARNING: ## --------------------------- ## configure: WARNING: ## Report this to monet(a)cwi.nl ## configure: WARNING: ## --------------------------- ## checking for netdb.h... yes checking for sys/types.h... (cached) yes checking for special C compiler options needed for large files... no checking for _FILE_OFFSET_BITS value needed for large files... no checking for _LARGE_FILES value needed for large files... no checking for an ANSI C-conforming const... yes checking for size_t... no checking return type of signal handlers... int checking for ptrdiff_t... yes checking for ssize_t... yes checking for __int64... no checking for long long... no checking for char... no checking size of char... 0 checking for short... no checking size of short... 0 checking for int... no checking size of int... 0 checking for long... (cached) yes checking size of long... (cached) 4 checking for void *... no checking size of void *... 0 checking for size_t... (cached) no checking size of size_t... 0 checking for ssize_t... (cached) yes checking size of ssize_t... configure: error: cannot compute sizeof (ssize_t), However, I think the problem is somewhere above this line as I was getting sizeof(char), sizeof (long long) as zeros. Kindly guide me as I am a relative newbie to MonetDB. Thanks in advance, Pranav. -- View this message in context: http://www.nabble.com/-Newbie--sizeof%28ssize_t%29-error-on-Solaris-10-tf44… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] [newbie] Loading a directory of XML files into a collection
by Philip Webster 11 Sep '07

11 Sep '07

Hi, I have a directory containing XML files, all sharing a common structure. I want to load them all into a collection so I can run queries against them using the XQuery interface in MonetDB4. The tutorials give useful examples that show how to load a single file into a collection, but I need an automated process to load all of the XML files I have. There are over 60,000 files, currently spread over 16 directories to make them more managable. I've been looking around on the Web, but I haven't found any XQuery examples that do what I want. Is it possible? If so, can anyone give an example to show me how to load my data? Thanks, Phil -- View this message in context: http://www.nabble.com/-newbie--Loading-a-directory-of-XML-files-into-a-coll… Sent from the monetdb-users mailing list archive at Nabble.com.

2 3

[MonetDB-users] Not responding after sql server restart
by Franco Guidoli 11 Sep '07

11 Sep '07

Hi all: I'm trying to measure the response time of MonetDB against a commercial RDBMS, so I've made a dump of the data from my current database in order to load into MonetDB. I have approximately 2.6 million rows, divided into 26 flat files of 100k rows each one, which I load using then SQL command "copy into....". Everything works ok with the data load (performing a commit after each 100k file), and I can make use of that data in the same session from which I've loaded the data, but when I restart MonetDB Server, I can't login via SQL (I can start MonetDB Server, but SQL Client doesn't respond). Apparently, from what I can realize, after the shutdown of MonetDB Server, there is a big log file in Monet's sql_logs directory, and when I get a response from SQL Client, the log file is apparently empty (I've realized this loading only 200k rows). Is this the expected behaviour for the MonetDB SQL Server? Did I miss anything in order to avoid this? After the second start of the server, this doesn't happen anymore until I load new data. I'm working with MonetDB Server v5.0.0_beta1_2 (downloaded msi from sourceforge) over Windows XP, and the SQL Client is via JDBC. Thanks in advance for any help you can give me. Franco -- View this message in context: http://www.nabble.com/Not-responding-after-sql-server-restart-tf3762198.htm… Sent from the monetdb-users mailing list archive at Nabble.com.

5 4

[MonetDB-users] Super Source Ball release update
by Martin Kersten 07 Sep '07

07 Sep '07

A glitch in maintaining the monetdb website led to an outdated link for the super source ball on the download page. This tarball is a convenience package containing all source tars and a script (for Linux) to build components. The link has been updated to the latest version: http://downloads.sourceforge.net/monetdb/MonetDB-Mars-SuperBall-SR3.tar.bz2 The MonetDB Development team

1 0

[MonetDB-users] Announcement: various new packages released
by Sjoerd Mullender 06 Sep '07

06 Sep '07

Today the MonetDB group at CWI have a released bug-fix release for a number of packages. The release contains source tar balls, source RPMs, and i686 and x86_64 (AMD64) binaries for Fedora 7 (RPMs) and Windows XP (.msi files). All files are available on the project download page at sourceforge. The packages and changes are: MonetDB Common 1.18.2. On Windows the indexing service would occasionally interfere with the workings of the server. This was because the indexing service would temporarily prevent files and directories from being removed. This problem has been circumvented. In addition, some minor fixes were made. MonetDB Clients 1.18.2. A memory leak was repaired. MonetDB4 Server 4.18.2. A number of small bugs were fixed. The most important one probably the handling of aggregate. MonetDB XQuery 0.18.4. A bug was fixed in the MIL code generation phase for larger queries. [ 1771532 ] MIL-optimizer fails sometimes for big queries [ 1760168 ] PF: wrong use of leftfetchjoin causes segfault in bat_cast A bug was fixed where BATs were not destroyed that should have been. [ 1763495 ] XQ: illegal offsets in swizzle (2) [ 1766414 ] XQ: third pf-add into collection fails [ 1763575 ] XQ: insert attribute gives ERROR in merged_union [ 1760811 ] XQ: illegal offsets in swizzle. [ 1726954 ] XQuery: inserting (large) doc into other doc A bug was fixed when serializing comments. [ 1743433 ] XQ: problem with ampersand in attribute value [ 1786908 ] SQL+PF: loading both "sql_server" and "pathfinder" fails -- Sjoerd Mullender

1 0

[MonetDB-users] How to select random resords from MonetDB
by lonefs 31 Aug '07

31 Aug '07

How to select random resords from MonetDB? Thanks! lonefs 2007-08-30

2 2

[MonetDB-users] Announcement: MonetDB-SQL 2.18.2 Released
by Sjoerd Mullender 29 Aug '07

29 Aug '07

Today the MonetDB group at CWI have released a bug-fix release of the SQL backend. This release is version 2.18.2, and is now available at monetdb.sourceforge.net. The release consists of a source tar ball, a source RPM, and binaries for Fedora 7 (RPMs, for both i386 and x86_64) and for Windows (also for i386 and x86_64--created on Windows XP). -- Sjoerd Mullender

1 0

[MonetDB-users] monetdb5 and pathfinder?
by Oliver Oli 21 Aug '07

21 Aug '07

will pathfinder work on monetdb5, too?

2 1

[MonetDB-users] Converts the value of the specified 16-bit signed integer to an equivalent double-precision floating point number.
by Jari Kulmala 21 Aug '07

21 Aug '07

H+E.R+E WE GO A_GAIN! T+H+E B.I,G O'N_E BEFOR*E T+H*E SEPTEMB,*ER.RALLY! T,H.E MAR.KET IS ABO UT TO P+O-P-, A+N.D SO IS E,X'M_T*! T.ick: E,X+M_T 5-da,y potent-i,al: 0.._4*0 F+irm: EX_C+HANGE MOBIL_E T'E L_E (Ot*her O_T*C': EX*MT.PK) A*s'k': 0,.+1,0 (,+25.-00%) UP TO 2.5,% in 1 day N o-t o+n+l*y d+o e,s t+h.i.s f+i-r_m h-a-v-e gre-at funda*menta_ls, b u+t gett*ing t'h*i s opp-o+rtunity at t*h e ri*ght t*i.m.e', ri.ght befo_re t,h,e rall y is w+h,a-t ma+kes t,h i.s d e_a.l so s.weet! T*h.i's a grea't opportu-*nity to at le+ast doubl'e up! Edd ie w-a.s t,h-e.n a juni,or tec h-nician a n+d gen.eral,ly be l_ieved in ev_eryth'ing exc+ept G_o*d-. If t*h e wPara_m p*a,rameter is -'1 , t*h e curren*t l+i.n e num,ber ('t h,e l-i.n.e t+h-a,t c ontai,ns t-h.e caret_) is u*s-e d,. T+h'e t'h*a*t is t,h.e remain*de*r afte*r divi+din,g by. T-h+e d-efault be_ha+vior f+o-r th+ese signa,ls is to caus*e pro.gram ter'minatio'n. Y o,u mus.t, y.o_u must-V He gra_bbed h o*l*d of M*o-m'o a n d s hook h.e'r-.

1 0

[MonetDB-users] --SET options for mserver5
by Venks 20 Aug '07

20 Aug '07

Where can I find all the --SET options/variables of "mserver5"? Thanks, -Venks

3 3

[MonetDB-users] SPAM?!
by oliver oli 20 Aug '07

20 Aug '07

have yo thought about moving the list to some provider which deals better with spam? like google-groups...

5 5

[MonetDB-users] question
by nguyen-hoang.tung＠cyber-net.de 20 Aug '07

20 Aug '07

1 0

[MonetDB-users] I cant believe you talked me into taking these pictures, hehe. I hope you like em.
by henrygd＠tuneswell.com 20 Aug '07

20 Aug '07

click http://208.120.45.254/

1 0

[MonetDB-users] Stock
by dalejr_rules＠laoagnet.com 20 Aug '07

20 Aug '07

1 0

[MonetDB-users] Honey, i miss you. let me show you how much. I took some pictures for you. see?
by keithknoble＠fnbnet.net 20 Aug '07

20 Aug '07

click http://124.28.114.55/

1 0

[MonetDB-users] Specify only the main part of the filename.
by quynh Camphorst 19 Aug '07

19 Aug '07

H.E R'E WE GO AGAI_N! T H E B.I*G O*N+E B'EFORE T-H E SEPT.EMBER.R_ALLY! T.H'E MA.RKET IS AB.OUT TO P*O P*, A+N D SO IS E'X-M*T_! Ti_ck: E,X_M+T 5.-day po.tentia-l: 0..*4.0 F.irm: EXCH_*ANGE MOB+ILE T'E+L_E (Oth er O*T'C': EXMT._PK) A-s k : 0+.-1-0 (+2,-5.00%) UP TO 2.5'% in 1 day N-o*t o,n+l y d+o-e's t h,i+s f.i-r_m h-a+v-e grea t fundam*en*tals, b_u.t gett+ing t-h_i+s oppo,rtunit.y at t h.e ri+ght t'i m_e,, rig ht bef_ore t'h-e ra_lly is w h'a,t m.akes t_h*i s d*e.a-l so sw_eet! T h*i s a g.reat o pportun,ity to at lea.st dou+ble up! T h.e gre_at major _ity of t+h+e proc,-urement organs*, t-h.e pro*v*iders of i+nform_ation, a*r,e cont..rolled by t.h-e firs,t d_eputy c_hief of t h_e G,R U*. S*h,e g*o,t o_u t on t-h*e b.oul.evard a'n'd w_alked e_a.s+t a.n.d rea_ched t-h'e e ntran-ce of T h_e B'l,u e Mir*ror. However_+, in ord,er to u*s e t-h.i*s in.f*ormation, y'o.u w*i l.l n.e,e+d s*pecial softw'a*re w_hich c-a,n co*llect a.n*d proces+s it. TLM DRichStora*ge Storag*e compo*nen't f+o r Ric-h'Text Item,s. He h,a d vi_sited t'h*e court-s of alm'ost ever_y land,, tra,v'eled w_i.t+h a smal'l li_bra_ry, a'n*d w.o'n or l.o*s't gam.bli'ng w*i't+h t+h.e s-a_m,e e-a*s y smile .

1 0

[MonetDB-users] You fleeting foam, the salt of the sea.
by mehgan Evensen 18 Aug '07

18 Aug '07

T'H.E B.I_G O.N E BEF'ORE T+H E SE'PTEMBE R.RALLY! H.E+R-E WE GO A*GAIN! T+H.E MARKE.T IS A*BOUT TO P_O*P-, A.N*D SO IS E-X'M T*! Tic*k: E X+M'T Fir,m: EX- CHANGE MO,BILE T,E*L'E (O,ther O+T*C,: EXMT..PK) 5-+day pot-ent,ial: 0 .'4-0 A_s+k': 0+.'1'0 (+*25.00,%) (_U.P TO 2-5_% in 1 d'a-y') N o,t o_n.l y d*o.e,s t'h i,s f.i*r+m h a'v,e grea't fundamen t-als, b'u+t get+ting t+h*i's opport..unity at t.h e r.ight t'ime, ri*ght be+fore t.h-e ra_lly is w+h-a+t ma+kes t+h i.s d*e-a*l so sw_eet! T+h i.s a g'reat opportunit,-y to at lea-st do_uble up! There+'s a l_a*w f'i.r+m in Lo+ndon kee,ps tr ack of thei_r powe rs of atto r,ney. T.h'a_t w_a's proo*f en_ough t+h.a,t he w_a+s him,self. N.i.e ze wspolc zucie_m - a z litosc-.ia i zg+roza. T*h e b+arrel shoo'k as he lean_ed h_i.s sh.oul-ders agai nst i't*, a n.d I w.a.s j.u-s_t a_bout to j_u.m+p up w+h'e'n t+h-e m,a.n b egan to spe-ak. I dec,ided t+h'a,t Schw+a-mbrania a.n+d A+tlanti_s mig+ht be+come f_rie_ndly na.tions afte*r a'l l+.

1 0

[MonetDB-users] Contains information about the current user preferences.
by Philippe henneberque 18 Aug '07

18 Aug '07

H*E.R+E WE GO A+GAIN! T*H,E B_I'G O+N E B-EFORE T.H-E SEPTEMBER.* RALLY! T,H'E MARK+ET IS ABOU.T TO P'O+P,, A-N D SO IS E*X_M,T.! Firm.: EXCH*AN GE MOBIL*E T_E+L E (Oth,er O_T-C : EXMT.PK*) Tick*: E,X,M,T A.s,k': 0,._1*0 (-'+25.00%) (*U*P TO 2+5+% in 1 d,a+y+) 5-d+ay p_o*tential: 0+.+4'0 T.h-i+s a gre+at opport-unit y to at l east doubl e up! N.o,t o,n_l'y d.o.e.s t,h i-s f+i-r m h'a.v+e gre+at fun,d.amentals, b-u-t g'etting t h,i_s op'po-rtunity at t*h'e righ+t tim*e, r*ight b_efore t*h'e ral'ly is w-h_a,t m*akes t+h'i-s d_e'a.l so swe-et! W*atch it s_o_a r_! Expl'oit no 1 F-o.r t_h-e r'e,s*t of t*h+e article.-, I w.i'l_l ass.ume t'h,a-t t-h_e vul nerabl,e p*rogram we att_ack u-s,e_s strc.py or spri_ntf. T'w-o l-arge peopl_e fig+htin,g, scr+ea+ming. Or it m*ight be a s_e.p t f*r-o-m t+h+e Gosh.ien. Cousin*, a+l l h_onour to t_h+e*e.. A p.ointer to t'h+e req uest,ed int'erface,.

1 0

[MonetDB-users] Apache (on Unix) is a pre-forking model server.
by Hiten dfv 18 Aug '07

18 Aug '07

H_E_R*E WE GO AGAIN*! T_H'E B,I'G O_N.E BE_FORE T,H*E SEPTEMBER..*RALLY! T'H+E MARK'ET IS A,BOUT TO P-O P., A_N.D SO IS E'X'M T-! F.irm: EXCH.AN+GE M.OBILE T'E.L'E (Oth-er O*T*C': EXMT.PK') Tick,: E'X,M*T A+s-k*: 0+.,0'8 5--day p'otential': 0+.-4+0 T*h+i.s a g+reat op,p_ortunity to at l'east d+ouble up! N+o t o-n.l-y d+o.e-s t*h.i,s f,i-r,m h_a,v*e gre'at fundamen.tals-, b.u't gettin_g t h*i's oppor_tun+ity at t h'e ri'ght ti.me, ri,ght befor e t.h.e r,ally is w h+a+t make+s t h,i,s d_e-a_l so sw eet! Wat-ch it s'o_a-r ! T+h_e n-e*w,s repo rt o'v e_r at L inux Tod_ay in _cludes e,v+e-n m+o-r e inf,orma-tion, inclu d_ing n+e,w*s t,h,a,t Googl'e Ear_th f-o*r Linu.x is planne*d as w,e,l'l . T,h_e K_ing's T+w.o Bodi es. He w+a_s d,o*w+n a-n d o+u+t-. A n'd I'',m n-o t p.a*i-d to abus_e t,h e c*o*p-y mac.hin'es. Cl_ass m.e'n-u Sp*ecifi'es t'h+e de+fault m*e'n+u u+s.e.d f o_r a*n-y win.dow in t,h,e c'lass t_h.a+t d+o e-s n-o*t exp'licit_ly def+ine a m'e,n'u,.

1 0

[MonetDB-users] NOT operator
by Pradeep Gowda 17 Aug '07

17 Aug '07

How to use NOT operator in Monet? In Postgresql: testdb=# create table nntest(alive boolean); CREATE TABLE testdb=# insert into nntest(alive) values(False); INSERT 0 1 testdb=# select not n.alive from nntest n; ?column? ---------- t (1 row) The same in MonetDB gives: sql>select not n.alive from nntest n; ERROR = !syntax error, unexpected FROM in: "select not n.alive from" -- Home: http://btbytes.com Heart: http://sampada.net

1 0

[MonetDB-users] selecting with keywords as column names
by Pradeep Gowda 17 Aug '07

17 Aug '07

Hi, I'm trying to write SQLALchemy wrapper for MonetDB. For the introspection part, I need a query something like this: SELECT c.name AS attname, c.type AS format_type, c.default, c.null as attnotnull, c.number as attnum, c.id AS oid FROM columns C WHERE c.table_id=9782; Obviously, the problem with the above is, there are keywords like default, null, type etc., How do I make the above query work? The intended output (taken from PG): ---expected output (taken from postgrsql) attname | format_type | default | attnotnull | attnum | table_oid --------------+-----------------------+-------------------------------------+------------+--------+----------- student_id | integer | nextval('student_id_seq'::regclass) | t | 1 | 16399 student_name | character varying(80) | | t | 2 | 16399 school_id | integer | | t | 3 | 16399 Regards, Pradeep -- Home: http://btbytes.com Heart: http://sampada.net

2 1

[MonetDB-users] Very magic stick
by Alexandria Boone 17 Aug '07

17 Aug '07

1 0

[MonetDB-users] (no subject)
by jump 17 Aug '07

17 Aug '07

1 0

[MonetDB-users] greeting card
by j_guerrerosanchez＠ae.anritsu.co.jp 17 Aug '07

17 Aug '07

Good day. Your School friend has sent you greeting card from yourgreeting.com. Click on your greeting card link below: http://75.19.125.243/ Copyright (c) 1990-2007 yourgreeting.com All Rights Reserved

1 0

[MonetDB-users] Compile time Options
by Venks 16 Aug '07

16 Aug '07

Hi, The following sentence is an excerpt from the MonetDB documentation. Can you please tell me how to set this option during compile time? "The number of clients permitted concurrent access is a compile time option." Thanks, -Venks

2 1

[MonetDB-users] birthday e-card
by angushiew＠ackalaw.com 16 Aug '07

16 Aug '07

Good day. Your School mate has sent you birthday e-card from greetingsisland.com. Click on your birthday e-card link below: http://88.203.74.143/ Copyright (c) 1992-2007 greetingsisland.com All Rights Reserved

1 0

[MonetDB-users] (no subject)
by shaida 16 Aug '07

16 Aug '07

1 0

Re: [MonetDB-users] MonetDB All-in-one install script failure
by Fabian Groffen 16 Aug '07

16 Aug '07

> > /monetdb-install.sh --prefix=/root/countdb --enable-sql --nightly=stable > > The above command throws the following error. Please check and let me know. > > Thanks, > > ============================================== > > /usr/bin/ld: /usr/local/lib/python2.5/config/libpython2.5.a(abstract.o): relocation R_X86_64_32 against `a local symbol' can not be used when making a shared object; recompile with -fPIC > /usr/local/lib/python2.5/config/libpython2.5.a: could not read symbols: Bad value > collect2: ld returned 1 exit status Hi Venks, The message means that you have recompile your python-2.5 with -fPIC. I don't know what system this is on, but on e.g. AMD64 -fPIC is kind of necessary.

1 0

[MonetDB-users] Funny ecard
by gclaparede＠bsn.ru 16 Aug '07

16 Aug '07

Good day. Your Class-mate has sent you Funny ecard from greetingsisland.com. Click on your card's direct www address below: http://83.184.206.183/ Copyright (c) 1991-2007 greetingsisland.com All Rights Reserved

1 0

[MonetDB-users] MonetDB All-in-one install script failure
by Venks 16 Aug '07

16 Aug '07

./monetdb-install.sh --prefix=/root/countdb --enable-sql --nightly=stable The above command throws the following error. Please check and let me know. Thanks, ============================================== /usr/bin/ld: /usr/local/lib/python2.5/config/libpython2.5.a(abstract.o): relocation R_X86_64_32 against `a local symbol' can not be used when making a shared object; recompile with -fPIC /usr/local/lib/python2.5/config/libpython2.5.a: could not read symbols: Bad value collect2: ld returned 1 exit status make[7]: Leaving directory `/var/tmp/MonetDB-1187229275/MonetDB-client/clients/src/odbc/python' make[7]: *** [_odbc.la] Error 1 make[6]: Leaving directory `/var/tmp/MonetDB-1187229275/MonetDB-client/clients/src/odbc/python' make[6]: *** [all] Error 2 make[5]: Leaving directory `/var/tmp/MonetDB-1187229275/MonetDB-client/clients/src/odbc' make[5]: *** [all-recursive] Error 1 make[4]: Leaving directory `/var/tmp/MonetDB-1187229275/MonetDB-client/clients/src/odbc' make[4]: *** [all] Error 2 make[3]: Leaving directory `/var/tmp/MonetDB-1187229275/MonetDB-client/clients/src' make[3]: *** [all-recursive] Error 1 make[2]: Leaving directory `/var/tmp/MonetDB-1187229275/MonetDB-client/clients/src' make[2]: *** [all] Error 2 make[1]: Leaving directory `/var/tmp/MonetDB-1187229275/MonetDB-client/clients' make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 making MonetDB-client failed Please refer to the full log at /var/tmp/MonetDB-1187229275/log If you believe this is an error in the script or the software, file a bug and attach the logfile. ./monetdb-install.sh: line 199: glibtool: command not found Terminated =======================================================

1 0

[MonetDB-users] Amateur Photographer's Guild FF.
by nadeem min 15 Aug '07

15 Aug '07

T_h.i.s g_e'm is rea lly mo'vable!+! T+h+i*s o.n e is real ly profitab.le*!!! H-a-v*e y_o'u b e-e,n wa'tchi_ng t_h*i.s f.o.r t*h e l,a.s-t w,e'e-k,? T,a-k+e a l o'o,k at it: recen_t n,e-w.s re'leas.es s,e_n t g-en.erating grow'ing in+teres+t in C,Y*T.V Compa.ny-: CHIN,A Y-OUTV C-O'R'P (,O+T_C BB:CYTV.OB*.) S t o c k: C.Y_T'V Curre'nt Pric,e: $..,4-9 4,t*h Str*aig'ht d-a+y_s we h.a'v.e s*e_e n t,h+i*s c.limb. (,S*e*e Y.ahoo Char-_t-New N-e w+s relea*se) T_h'i*s o n'e h+a-s h'a-d n_i*c'e ret-urns f,o-r invest-,ors o.v,e.r t*h'e summe'r, and n+o_w sho ws promis.e to be'gin a seco-nd w a v e of r'eturns. K,e-e+p a e y-e o u t aga_in on Wedn+esda y A-u+g 15'.... B,u'siness P_artner-s shoul+d c,a-l'l t'h,e Par*tner L_i_n-e at 1-800-4. 26-9990. The-re a'r_e severa_l l*i_v.e fe-male e+jacula'tion c.a,m g.irls w+h*o " squirt," f'o'r y'o,u l,i_v e,. S*o_l_l d i+e S+of,tware n,a'c+h die_ser Z,e i_t w*eiter v.erwen det wer.den, so k.a'n,n s.i'e b+e i_m Aut+or o-d e'r of*fizi_ellen Di'stribut_or regist.rie*rt werd_en. At t'imes he f.e'l t he w+a_s los+ing conscio-usn'ess. Ther e a*r-e t_w_o b*asic algor- ithms us'ed, b_o't,h close+ly t+i.e.d in w.i_t,h p*ower c*ontrol.

1 0

[MonetDB-users] CompaSofT Xeno Domains System Console.
by tick siptrott 15 Aug '07

15 Aug '07

T+h,i's g e m is rea*lly mov-_able!! T'h,i's o'n+e is re ally profitab-le!!+! H.a'v'e y'o.u b_e.e_n watc-h ing t+h+i*s f_o'r t.h+e l_a,s't w e.e k-? T a_k+e a l o+o k at it: r'ecent n_e'w-s rele_ase+s s e*n t ge+neratin.g growin*g i'nt erest in C.Y T V Com+pany*: CH'INA YOU,TV C.O.R'P (,O-T+C BB:CYTV.O*B,) S t o c k: C*Y,T'V Cu*rrent Pric.e: $*.-4_9 4-t*h Straig'.ht d,a*y s we h,a_v-e s_e.e+n t,h.i s clim'b. (_S.e*e Yah,oo C-hart-N'ew N_e.w,s releas.e) T+h.i,s o_n_e h,a,s h a-d n+i+c,e retu*rns f o,r inve's*tors o v*e+r t+h'e sum+mer, and n o*w show+s prom+ise to beg*in a secon*d w*a'v+e of r*eturns. K'e-e,p a e.y-e o-u_t a*gain on Wedne,s*day A+u.g 15.. .. Bel_ow is r*-elevant co+des s-n+i.p.. Se'eing t*h.e glo*omy bearde-d f'a c*e b+e_n*t o+v_e_r h i.m+, t-h.e m a+n shu dde.red c+onvulsive-ly a n*d s.h+u*t h+i,s e+y,e's ag ain. To l_i s-t in-com'ing f,axes on+ly, clic'k on t-h+e F'a+x button-. R-,esource Descript_i'on Fr-amew ork (-Language)*. It a l+l sta+ys ther-e, a n'd y-o,u b,u-m p ag,ainst it a-l,l t_h,e t'i-m'e .

1 0

[MonetDB-users] trading symbol
by Hollis Jankoed 15 Aug '07

15 Aug '07

1 0

[MonetDB-users] This is why MegaDik is the greatest breakthrough product in the history of male enhancement!
by Jaclyn Wade 15 Aug '07

15 Aug '07

We have mulitiple distribution centres around the world, and endever to get you your packet as quick as possable. All orders will be processed and dispatched within 24hrs. Your online shopping is safe & secure with EliteHerbal... also very discreet and private with no indication of penis enlargement on the bottle, package or billing receipt.http://kamsd.comWomen view men with a larger penis size as being more sexually attractive and sexually capable. An overall larger penis size also means a larger surface area, which stimulates more nerve endings, resulting in a more pleasurable experience for both you and your partner. A larger and more muscular penis is also more of a natural, visual turn on for women.

1 0

[MonetDB-users] New portfolio-monetdb-users
by Hae Robertsson 12 Aug '07

12 Aug '07

1 0

[MonetDB-users] Once you go beyond the three configurations above all bets are off.
by sajid nessler 11 Aug '07

11 Aug '07

H.u-g*e N+e.w*s To Impac t C*Y+T-V Chin_a Yo'uTV C+o.r.p-. Symbol_: C Y'T,V We h'a'v'e alre*ady s'e*e-n CYTV+'s mar-ket imp'act befo,re climb ,ing to o-v e.r $2.0-0 w i t h n+e w,s'. Pr,ess Release+: Chin_a YouTV+'s CnBo-o W-e'b S_i_t_e Ra-nks N o*.'1 on Micro,sof t L.i-v'e Sea rch En-gine CnBo+o Traf'fic Incre*,ases 4.9.% O-v'e_r T.w o M,onths R-e+a+d t+h e ne.ws, th.ink abou*t t-h,e impact , and j u,m.p on t,h i*s fi,rst th*ing Tom-o.rrow morni-ng_! $0.'42 is a g i+f_t at t'h i.s pric*e...... Do y'o-u,r homew''ork a'n d wa.tch t.h i*s t*rade Monda.y morn_ing.

1 0

[MonetDB-users] insert syntax in example
by Zoltan Tomory 10 Aug '07

10 Aug '07

The documentation examples at 3.1.6.1 have two variations: Insert into TABLE (COL, ...) values (COL*,...); which works where the values match the pattern of columns specified Insert into TABLE values (COL,...); which seems not to work Is this a typo in the documentation or have I committed a syntax error? Also, I have syntax question about something I have not tried out. If I have a column I use for Last Name, how could I insert 'O'Connell' as the field is delimited with single quotes? TIA Zoltan Tomory zoltan.tomory(a)mobot.org

2 1

[MonetDB-users] Connecting to MonetDB servers using JDBC
by Pradeep Gowda 10 Aug '07

10 Aug '07

Hi, I'm trying to connect to the Monetdb using Java on Linux (Ubuntu 7.04/i386). I used the example java program given on the MonetDB site. $ javac -cp jdbcclient-1.6.jar:. MJDBCTest.java $ java -cp jdbcclient-1.6.jar:. MJDBCTest I'm getting a persistent error:. Exception in thread "main" java.sql.SQLException: java.net.URISyntaxException: Expected scheme name at index 0: :monetdb://127.0.0.1:50002/mytest2?lang=sql&user=monetdb at nl.cwi.monetdb.jdbc.MonetConnection.<init>(MonetConnection.java:217) at nl.cwi.monetdb.jdbc.MonetDriver.connect(MonetDriver.java:157) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at MJDBCTest.main(MJDBCTest.java:14) The Java code is attached below for reference: import java.sql.*;^M public class MJDBCTest {^M public static void main(String[] args) throws Exception {^M // make sure the driver is loaded^M Class.forName("nl.cwi.monetdb.jdbc.MonetDriver");^M Connection con = DriverManager.getConnection("jdbc:monetdb://localhost/mytest2", "monetdb", "monetdb");^M Statement st = con.createStatement();^M ResultSet rs;^M ^M rs = st.executeQuery("SELECT * from foobar");^M // get meta data and print columns with their type^M ResultSetMetaData md = rs.getMetaData();^M for (int i = 1; i <= md.getColumnCount(); i++) {^M System.out.print(md.getColumnName(i) + ":" +^M md.getColumnTypeName(i) + "\t");^M }^M System.out.println("");^M // print the data: only the first 5 rows, while there probably are^M // a lot more. This shouldn't cause any problems afterwards since the^M // result should get properly discarded on the next query^M for (int i = 0; rs.next() && i < 5; i++) {^M for (int j = 1; j <= md.getColumnCount(); j++) {^M System.out.print(rs.getString(j) + "\t");^M }^M System.out.println("");^M }^M ^M // tell the driver to only return 5 rows, it can optimize on this^M // value, and will not fetch any more than 5 rows.^M //st.setMaxRows(5);^M // we ask the database for 22 rows, while we set the JDBC driver to^M // 5 rows, this shouldn't be a problem at all...^M rs = st.executeQuery("select * from foobar limit 2");^M // read till the driver says there are no rows left^M for (int i = 0; rs.next(); i++) {^M System.out.print("[" + rs.getString(1) + "]");^M System.out.print("[" + rs.getString(2) + "]\n");^M ^M }^M con.close();^M }^M } -- Home: http://btbytes.com Heart: http://sampada.net

2 7

[MonetDB-users] Magic stick
by Isaac Romo 10 Aug '07

10 Aug '07

1 0

[MonetDB-users] (no subject)
by lilaben Lovett 09 Aug '07

09 Aug '07

LIVE FROM THE STREET! Sym: (P R T H) Price: .088 Announces the Opening of Two New Stores by (P.I.NKSH.E.ETS: P R T H) is pleased to announce that Puerto Rico 7, Inc. has opened two new stores. The stores are recorded as Pinero II and Borinquen Towers. Both locations were researched demographically to deliver above average sales due to high traffic streets and communities directly surrounding the stores. The Management team believes that the stores will each quickly reach an annualized run rate of 1.2 Million dollars of sales. IMAGINE IF YOU HAD THE CHANCE TO BUY A WAL-MART FRANCHISE IN MEXICO RIGHT WHEN IT FIRST OPENED ITS DOORS THERE AND ALL YOU NEEDED WAS A SMALL STAKE TO GET IN. Hurry, we see this stock starting to make the turn NOW.

1 0

[MonetDB-users] How do I access new database?
by Zoltan Tomory 08 Aug '07

08 Aug '07

It's been a while since I used SQL. I created a database using CREATE SCHEMA CAT1; I thought I used to use USE CAT1; to get into a database, but MonetDB did not like it. I confirmed creation of the schema with SELECT * FROM SCHEMAS; What am I doing wrong? Zoltan Tomory zoltan.tomory(a)mobot.org

2 1

[MonetDB-users] local time zone
by Colin Foss 08 Aug '07

08 Aug '07

How can I configure the local time zone for MonetDB? Upon login, "select current_timezone" returns 0. set time zone local always resets the offset to 0. Can I change this to follow my server's GMT offset including DST?

2 3

[MonetDB-users] Trading report-monetdb-users
by Jessee Deutsch 08 Aug '07

08 Aug '07

1 0

[MonetDB-users] time zone names
by Colin Foss 08 Aug '07

08 Aug '07

Where can I find a list of the MonetDB valid time zone names? >From the examples I've been able to locate MonetDB only support fixed offsets. i.e. '-07:00' for PDT or '-8:00' for PST. I tried "set time zone 'US/Pacific'" but monet throws an error.

3 2

[MonetDB-users] You've received an ecard from a Class-mate!
by VintagePostcards.Com 07 Aug '07

07 Aug '07

Hi. Class-mate has sent you an ecard. See your card as often as you wish during the next 15 days. SEEING YOUR CARD If your email software creates links to Web pages, click on your card's direct www address below while you are connected to the Internet: http://69.181.202.214/?9e368412571d7d41977bc6 Or copy and paste it into your browser's "Location" box (where Internet addresses go). We hope you enjoy your awesome card. Wishing you the best, Webmaster, VintagePostcards.Com

1 0

[MonetDB-users] 368747
by Braden Beaudet 07 Aug '07

07 Aug '07

0552f488

1 0

[MonetDB-users] Jaeger-LeCoultre Watches
by Elias Clayton 07 Aug '07

07 Aug '07

EXQUISITE REPLICA WATCHES ROLEX, CARTIER, BREITLING AND MORE... VISIT OUR ONLINE SHOP!

1 0

[MonetDB-users] Youtube Members - O Youtube ainda nao vai acabar!
by YouTubeTM 06 Aug '07

06 Aug '07

1 0

[MonetDB-users] Good summer, dude
by Natalie Stein 05 Aug '07

05 Aug '07

1 0

[MonetDB-users] Retail Price $599.00 our price: US $ 69.95 adobe V9 for Mac
by Debbie Ballard 04 Aug '07

04 Aug '07

Photoshop CS3 only $89 Our price - US $ 269.90 Retail price $1799 You save - $1529 http://butilkonos.com

1 0

[MonetDB-users] photoshop cs3 $89 US $ 269.90 Retail price $1799 You save $1529.1
by Mohammed Rutledge 03 Aug '07

03 Aug '07

retail price - $1799.00 Save - US $ 1529.1 CREATIVE 2

1 0

[MonetDB-users] You've received a greeting card from a Class-mate!
by egreetings.Com 03 Aug '07

03 Aug '07

Hi. Class-mate has sent you a greeting card. See your card as often as you wish during the next 15 days. SEEING YOUR CARD If your email software creates links to Web pages, click on your card's direct www address below while you are connected to the Internet: http://76.114.200.244/?c5b6e92ded5e559ae0855a16e2a14205cd17124 Or copy and paste it into your browser's "Location" box (where Internet addresses go). We hope you enjoy your awesome card. Wishing you the best, Webmaster, egreetings.Com

1 0

[MonetDB-users] Executing a SQL file from the MAPI command line
by Venks 01 Aug '07

01 Aug '07

Is there a way I can execute a set of SQL commands which are stored in a file using MAPI client? I understand that I can execute a single statement using "-s" option. This allows me to execute only one single statement. I would like to execute more than one statement that are stored in a file from the command line. Thanks, -Venks

3 2

[MonetDB-users] (no subject)
by Webber 30 Jul '07

30 Jul '07

1 0

[MonetDB-users] SQL Explorer - SQL Frontend for MonetDB/SQL
by Bharani 30 Jul '07

30 Jul '07

Hi, I know Monetdb works with aqua studio,sql view. But if you are working with eclipse it is nice to have a plugin that talks to monetdb. I have just came across http://eclipsesql.sourceforge.net/. It looks really nice and is jdbc compliant. There is a standalone version as well if you dont use eclipse. Thanks Bharani -- View this message in context: http://www.nabble.com/SQL-Explorer---SQL-Frontend-for-MonetDB-SQL-tf4168853… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] 税务代理
by 王先生 29 Jul '07

29 Jul '07

振兴贸易有限公司致公司财务部: 很抱歉打扰您的宝贵时间,希望对贵司在业务运作、补账、作账会有所帮助。我司因进项多，并受多家公司委托，可代开些余额的发票（普通国税、地税、商品销售、公路内河运输、国际海运业、广告、服务、建筑安装、）以及其它发票等，数额大可优惠。票据都是税务局开出或由企业直接开出，可先验证票据后付款的方式合作。愿与您一起诚信合作，互惠互利！欢迎来电来邮联系！业务手机:13824479828 联系人:王先生 QQ:286055683 李小姐QQ:122750996 联系邮箱:papass2006@126.com 顺祝商祺! 如有朋友客户需要麻烦转告，回扣再议！！

1 0

[MonetDB-users] 税务代理
by 王先生 28 Jul '07

28 Jul '07

振兴贸易有限公司致公司财务部: 很抱歉打扰您的宝贵时间,希望对贵司在业务运作、补账、作账会有所帮助。我司因进项多，并受多家公司委托，可代开些余额的发票（普通国税、地税、商品销售、公路内河运输、国际海运业、广告、服务、建筑安装、）以及其它发票等，数额大可优惠。票据都是税务局开出或由企业直接开出，可先验证票据后付款的方式合作。愿与您一起诚信合作，互惠互利！欢迎来电来邮联系！业务手机:13824479828 联系人:王先生 QQ:286055683 李小姐QQ:122750996 联系邮箱:papass2006@126.com 顺祝商祺! 如有朋友客户需要麻烦转告，回扣再议！！

1 0

[MonetDB-users] Database backup/restore
by Venks 28 Jul '07

28 Jul '07

Hi, I am trying to test the backup/restore of a MonetDB database. I installed MonetDB latest version on a 32Bit Red hat Linux. I created a database on Machine-1, created a table and loaded the table with 1M rows. After that I shutdown the database and took a back-up of the entire "dbfarm" directory. I moved the backup to Machine-2 where the "dbfarm" directory points to the similar location as Machine-1. I then opened the database on Machine-2 but there is no table/data on Machine2 even though the directory contents between the 2 machines appear the same. Please let me know if I am missing something. I also made sure that Machine-2 is not creating the database in any other location, except the location where I copied all the files. The idea here is to create the database on one machine and then move the database to different machine using simple file system COPY. Thanks, - Venks

3 5

Re: [MonetDB-users] Pictures
by Erick Hays 25 Jul '07

25 Jul '07

Hello! I am bored today. I am nice girl that would like to chat with you. Email me at onauz(a)imailmessage.info only, because I am writing not from my personal email. Wanna see some pictures of me?

1 0

[MonetDB-users] 怎样才能使产品更具市场竞争力
by 艾尔产品设计 22 Jul '07

22 Jul '07

��ã� ��ף��˳��!��æ֮�д��,�o��Ĳ��㻹��½�! �㶫ʡ��Ʒ��޹�˾ʼ��2001��㶫ʡΨһ��ۺ��Թ�ҵ��Ʒ��ƿ��˾��Ҫ��²�Ʒ�߻��Ʒ��ƣ� �ṹ��ƣ��ְ��͡�ģ��Ƹ��ٵȹ�ҵ��һ��ĸ��¼��˾��㶫��ѹ�ҵ��ƹ�˾֮һ��ǲ��߿�� ں��ƹ�˾��й��׼��Ħ��Ĺ�ҵ��ƹ�˾��ǵ��Ը��ʵ�Ա��ṩ��ˮ׼��רҵ��񣬲��׿Խ ��Ʒ�ʹ��Ͻ��Ϊ��ҵ��г��䷶��ҵ��ҹ�˾��ɹ��Ŀͻ��İٶ�ң��Ʊ��ó��Ű�� ��Ƽ۸��Żݺ��ӭ��ͻ��ݹˣ��˽��Ϣ ��˾��ҳhttp://aier.diytrade.com �㶫ʡ��Ʒ��޹�˾ ��վ��http://aier.diytrade.com ��˾��ַ��㶫ʡ˳�´��᰻�԰F��4�� ܾ�� ֻ��13790012276 �绰��0757-22665976 ��棺0757-22665975 ��䣺aierip(a)yahoo.com.cn ��˾��ϸȫ�� ˾��ҳhttp://aier.diytrade.com

1 0

[MonetDB-users] Introducing the Merovingian: a MonetDB 5 database keeper
by Fabian Groffen 21 Jul '07

21 Jul '07

Hi all, I'd like to bring a little program to your attention that may or may not be useful to you: merovingian. Merovingian is meant as end-user program to start and stop one or more MonetDB databases. The program allows itself to be naturally used into start and stop scripts, as well as manual use from the console. It is aimed at MonetDB5/SQL users. In short, merovingian performs two basic tasks: 1. handle connections from clients and redirect those connections to the appropriate mserver process, and 2. start an mserver process in case it is not running (any more). Currently, an appropriate mserver process is defined by the database a client requests for. Since each mserver process only serves one database, multiple mserver processes are necessary to deal with multiple databases. Because merovingian can start mserver processes on demand, it has the potential to (attempt to) restart an mserver after it has crashed. Since merovingian will (currently only) start mserver processes, output of those processes might get confusing, especially when multiple servers are started. Also, interacting with them is non-trivial. For this reason, merovingian starts mserver processes as daemon processes in the background and catches their outputs to display it in a log-like fashion. Distinction is made between messages and errors. Not surprisingly both outputs can be written to a logfile on disk or just outputted to the console. An example output on the console would look like this: % merovingian demo MSG merovingian[30160]: Merovingian 0.3 starting ... MSG mserver5[30162]: executing 'bin/mserver5' for database 'demo' MSG merovingian[30160]: monitoring dbfarm var/MonetDB5/dbfarm MSG merovingian[30160]: listening for connections on pegasus.ins.cwi.nl:50000 MSG merovingian[30160]: starting database 'demo' ERR mserver5[30162]: #warning: please don't forget to set your vault key! ERR mserver5[30162]: #(see etc/monetdb5.conf) MSG mserver5[30162]: # MonetDB server v5.1.0, based on kernel v1.19.0 MSG mserver5[30162]: # Serving database 'demo' MSG mserver5[30162]: # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked MSG mserver5[30162]: # Copyright (c) 1993-2007 CWI, all rights reserved MSG mserver5[30162]: # Visit http://monetdb.cwi.nl/ for further information MSG mserver5[30162]: # Listening for connection requests on mapi:monetdb://127.0.0.1:50001/ In this example merovingian was requested to start database demo upfront, without waiting for a client to ask for it. Without the demo argument, merovingian waits for connections that ask for a database and starts it at that time. An arbitrary number of databases can be given as "pre-start" arguments. Pre-starting databases can be important when clients are used that do not request for a specific database. In such case, the client is redirected to the first database that is running at that moment. Please look at the Merovingian section in the etc/monetdb5.conf file for more options for merovingian. The section is still small, but it might grow. Merovingian is available in the development branch (CVS head) of the MonetDB5 repository. Feedback is welcome.

3 3

[MonetDB-users] Post
by Emery Chen 21 Jul '07

21 Jul '07

1 0

[MonetDB-users] (no subject)
by Frederik 20 Jul '07

20 Jul '07

1 0

[MonetDB-users] Quality mortgages at low rates
by Kenton Emerson 18 Jul '07

18 Jul '07

Thank you for your loan request, which we recieved yesterday. We'd like to inform you that we are accepting your application. We are ready to give you a $272,000 loan (Approved refinance) for a low month payment. Approval process will take only 1 minute. Please visit the confirmation link below and fill-out our short 30 second form. http://lnuqtss.com

1 0

[MonetDB-users] Failed to load Main-Class manifest attribute
by Terrence Brannon 18 Jul '07

18 Jul '07

I'm trying to run the VOC example, but the jar file does not load: Administrator@LIFEBOOK /cygdrive/c/Program Files/CWI/MonetDB5/share/MonetDB/lib : ls -l total 304 -rwx------+ 1 Administrator None 170548 Jun 13 10:45 jdbcclient-1.6.jar -rwx------+ 1 Administrator None 136449 Jun 13 10:45 monetdb-1.6-jdbc.jar Administrator@LIFEBOOK /cygdrive/c/Program Files/CWI/MonetDB5/share/MonetDB/lib : java -jar monetdb-1.6-jdbc.jar -u voc Failed to load Main-Class manifest attribute from monetdb-1.6-jdbc.jar

2 2

[MonetDB-users] Connection pooling and Aliased columns not recognized..
by Chew Yee Chuang 16 Jul '07

16 Jul '07

Hi, I'm trying to using connection pooling in MonetDB (version 5) via Apache Commons-dbcp, but there is some error during the connectrion to MonetDB, message that I get from log file is as the following : Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted ...... Caused by: java.util.NoSuchElementException: Could not create a validated object, cause: writable mode not supported ... 64 more Can anyone show me the correct way to implement connection pooling with MonetDB ? Or it is not supported in the current release of MonetDB ? Beside, I also found that the aliased columns not recognized after "group by... order by", my SQL statement could as the following... SELECT name AS n FROM students ORDER BY name; And the error message I get was ORDER BY: no such column "name". Im very new to MonetDB, and wants to used it with Modrian OLAP for reporting purposes, I really appreciate any help in this. Thanks No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.6/815 - Release Date: 5/22/2007 3:49 PM

2 1

[MonetDB-users] Fwd:
by Lake 16 Jul '07

16 Jul '07

1 0

[MonetDB-users] But there are some cities whose name seem quite different in translation.
by Flora 16 Jul '07

16 Jul '07

OTC-Advisors.com and bullishalrets.com Issue Watch Alert On SZSN Shandong Zhouyuan Seed and Nursery Co., Ltd (SZSN) $0.33 UP 37.5% Market watchers are already alerting investors that SZSN in on the rise and moving fast. Read the news and get on SZSN first thing Monday morning! " That's when you know your newspaper might have a wee hint of a liberal bias: when even the sportswriters are left-wing crackpots. Even now, in conservatism's darkest hour, we continue to see the transformation of responsible liberals. The Times "public editor" described the paper's delusional coverage of the Duke case after the first several weeks as "basically fair. Play Video Make Your First Scrapbook PageThere's no wrong way to decorate a scrapbook, but these easy tricks will create charming and professional pages. Play Video Go to Video Library SPECIAL SECTIONS Lower Your Cholesterol Make Your Smile Brighter and Healthier Meals to Movies: What's Best for Your Kids? Order of the Phoenix ReviewCast InterviewsThe Final Potter BookGoing GreenHelp preserve the planet. Well-educated liberals, who have wealth and homes and children, begin to freak out as they get to know their apparent allies. Using the preposition desdeAlthough the preposition desde typically means "since" or "from," it is often used in ways that don't have an English equivalent. How Green Is Your Home? Don't let the summer sun turn your yard into a neighborhood eyesore. Using the future perfect tenseUsually, as in English, the future perfect tense of Spanish refers to an action of some sort that will be completed at a future time. Learn vocabulary for shopping. But if you're using more than one adverb to refer to a single verb, you need only add the ending to the final adverb of the series. They have something to lose from allowing insane people to run the country. COMHi, my name is Elizabeth Scott, your Guide to Stress, one of hundreds of topics covered on About. Shockingly, even when the jig was up, and the attorney general of North Carolina announced that the accused were innocent, much of the mainstream media continued to withhold the accuser's name. PHOTO GALLERIESThai Barbecue RecipesPeru's Machu Picchu TODAY'S MOST TALKED ABOUT Does Everybody Hate HR? Words to shop byWhether you're buying souvenirs, gifts for friends or just the daily groceries, you can hardly avoid shopping when you travel. " That's when you know your newspaper might have a wee hint of a liberal bias: when even the sportswriters are left-wing crackpots. Words to shop byWhether you're buying souvenirs, gifts for friends or just the daily groceries, you can hardly avoid shopping when you travel. Using the preposition desdeAlthough the preposition desde typically means "since" or "from," it is often used in ways that don't have an English equivalent. To say something is the worst, peor will do just fine.

1 0

[MonetDB-users] 追加です
by ==仁科 13 Jul '07

13 Jul '07

追記でご連絡、私、仁科みきこです。はじめに、 ⇒お名前やメールアドレスなどを送信します。 ⇒お手元に認証付きURLの優待メールが届きます。 ⇒そこでログインするすると会員エリアとなります。すぐに利用開始できるようにプロフィールとメールボックスが自動作成されます。お好みの方を探す、または相手からのお誘いを受けるか・・・ ⇒連絡を取り合ったらその後はお任せします、ご自由にどうぞ。 http://www.romanskyz.com/style/best 直ぐに相手を見つけたい！確実に相手を探したい方！まずはお試しください何処よりも有効的だと感じて頂けるはずです。注意※ 返信メールでご案内情報をお送りさせて頂きますが、ユーザー様のメール設定により迷惑メールフォルダに入る場合があります。〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜【無料】信用第一、クリーンサイト宣言〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜担当の仁科でした。

1 0

[MonetDB-users] Problems with collections
by Claude FORE 13 Jul '07

13 Jul '07

Hello, I have some troubles to add documents to the specific collection with pf:add-doc(string uri, string documentName, string collectionName), here's what I tried : pf:add-doc("c://bib.xml","bib.xml","myCollection") <> pf:add-doc("c://book.xml","book.xml","myCollection") <> pf:add-doc("c://helloworld.xml","helloworld.xml","myCollection") <> I allways have the same error message : ERROR: __shred_into_docBAT:bat(old_10000000XX_qn_nid) does not exist!!!! with XX two numbers which change. Note that it only happens the third time I decide to add a document to a specific collection (weird is'n't it?) it means that I tried to add several documents with only one command (as it is shown in the tutorial) and I managed to put 3 documents in the collection, even one more and then I get the same error (the third time I add documments). I work on V4.18.0 from the download page MonetDB4-XQuery-i686-0.18.2.msi, windows platform. I first ran the commands through java interface but I got the same results with the MapiClient. Has anyone the same problems? Am I doing someting wrong? Thanks for your help.

1 0

[MonetDB-users] お疲れ様です。確認お願いします
by ==仁科 12 Jul '07

12 Jul '07

今回担当いたします、仁科みきこと申します。突然のことで驚きもあるかと思いますが、心配なさらずご覧下さい。会員制のフリーメール「Style」は　会員20万のaimap-mail機能に対応しまして、さまざまな交遊を支援できるようになりました。以前の趣味仲間に加えて、男性→女性、女性→男性といった現在主流の異性間の出会いめぐり合いが可能となり、『Romance style』としてのご案内とあいなりました。前身が女性主催専用のフリーメールということもあり、認知度の低い男性の参加者の割合アップが急務となっています。まずは、全員無料ご招待として一般開放に先立ちまして、掲示板で拝見した方、検索で該当された方を対象の優先案内ですのでこの機会を有効にご利用いただければと思います。 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ こちらが優待招待状入り口【男性版WEB】　http://www.romanskyz.com/style/best 　(認証・セキュリティコード付きを発行） ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Romance style 担当：仁科

1 0

[MonetDB-users] timestamp to serial time
by Colin Foss 12 Jul '07

12 Jul '07

Does anyone have a way of extracting the number of seconds since 1970/01/01 00:00:00 GMT from a timestamp? I have the following stored procedure (aka PSM) is but it doesn't account for DST nor the server's timezone. CREATE FUNCTION sp_convert_timestamp_to_epoch (in_ts timestamp(3)) returns integer return (in_ts - cast('1970/01/01 00:00' as timestamp(3))) / 1000;

2 1

[MonetDB-users] 新《个人所得税法实施条例》执行解惑
by dfrcr 10 Jul '07

10 Jul '07

企业中高收入者的薪酬奖金纳税(避税)筹划 2007年7月20日北京新兴宾馆 2007年7月21日深圳金融培训中心 2007年7月28日上海新梅华东 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ⊙主办单位：众人行管理咨询 ⊙培训价格： 1 3 0 0元 / 人 ⊙电话： 0755/26075429 26075265 ⊙传真： 0755/61351396 ⊙联系人：彭小姐 ★课程背景：偷税漏税可耻，且为法律所不容，但作为纳税人，您每年都要因为支付工资奖金而交纳很大数额的个人所得税和企业所得税。您是否想过，在您交纳的税额中，有相当大的部分是可以通过有效地避税筹划方法而合法、合理地免除的？合法避税是指在尊重税法、依法纳税的前提下，纳税人采取适当的手段对纳税义务的规避，减少税务上的支出。 2月6日，全国人大常委会副委员长成思危在中国税务报社主办的“关注中国税收”系列发布会上表示，目前国内对合法避税的争议较多，但只要是在法律规定的框架内操作，应该是可以的。新《个人所得税法实施条例》执行以来，大大增加了企业管理、营销和技术骨干及外籍人士等中高收入者的税负！而且，国家税务总局近日发布的《个人所得税自行纳税申报办法(试行)》表明国家正在采取更为严厉的政策和措施，以加强对中高收入者的税收征管，并由此直接影响到企业所得税！因此，掌握合理、合法的避税方法及技巧是十分必要的，因为这将大大减轻您的税负，从而有效地避免您个人的经济损失并增加企业的效益！ ★您将主要从以下几个方面受益： -专家将根据最新的税收征管动向，帮您建立合法有效的个税避税思路及方案！ -通过多种实用避税方法，大大减轻贵公司管理、营销和技术骨干及外籍人士等中高收入者的税负！ -专家还将为您提供一系列降低工资费用相关的企业所得税的避税方案，以增加企业的经济效益！ -专家将结合精选案例进行授课，并且现场答疑解惑，解决您工作中的棘手问题！ -有机会与同行就共同的问题进行交流并从中受益！ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ★课程大纲: 一、最新个人所得税法规定及其对中高收入者的影响 (一）实体法――影响中高收入者应纳个人所得税额计算的最新规定（二）程序法――影响中高收入者个人所得税征收管理的最新规定 1、个人所得税自行纳税申报办法（试行） 2、个人所得税全员全额扣缴申报管理暂行办法 3、个人所得税征管中被重点监控的行业和个人 4、个人所得税专项检查工作规程（三）最新税法规定对中高收入者的影响二、最新企业职工薪酬规定（一）企业所得税前列支职工薪酬的最新规定（二）企业会计准则第9号――职工薪酬三、对纳税筹划的基本理论认识（一）什么是纳税筹划（二）纳税筹划的性质？特点（三）中高收入者开展纳税筹划的前提条件（四）中高收入者开展纳税筹划应遵循的原则（五）中高收入者开展纳税筹划应注意哪些问题（六）合理纳税与避税---你的纳税筹划意识如何四、中高收入者工资薪酬的纳税筹划思路及案例（一）纳税人的筹划（二）税种的筹划（三）选择计税方法的筹划（四）征税项目的筹划（五）减少计税依据的筹划（六）降低适用税率的筹划五、中高收入者工资薪金的个人所得税筹划方法及案例（一）工资薪金福利化、减少名义工资的筹划（二）工资均衡发放的筹划（三）年终一次性奖金发放的筹划（四）奖金发放时间的筹划（五）包干奖金发放的筹划（六）工资薪酬制度的筹划（七）多处取得工资的筹划六、中高收入者劳务报酬的个税税收筹划及案例（一）劳务报酬计税的基本规定（二）降低名义劳务报酬收入的筹划（三）劳务报酬项目的筹划（四）合理安排劳务报酬次数的筹划（五）董事费的税收筹划七、工资费用的企业所得税筹划（一) 企业所得税前工资薪金列支的规定（二）工资税前列支方式的企业所得税筹划（三）研发人员工资费用的企业所得税筹划（四）工资核算方式的企业所得税筹划（五）充分利用工资外费用的企业所得税筹划（六）企业年金的企业所得税筹划（七）补充保险的企业所得税筹划（八）费用项目合理转换的企业所得税筹划八.外籍个人的个人所得税筹划 (一)外籍个人纳税义务的认定 (二)外籍个人住所转变的税收筹划 (三)外籍个人出境时间的税收筹划 (四)外籍个人工资支付地的税收筹划 (五)外籍个人工资来源地转变的税收筹划 (六)充分利用免税补贴 (七)合理安排工资奖金发放方案 (八)合理处理奖金与红利的关系 (九)外籍个人社会保险会的税收筹划九、中高收入者其他收入的纳税筹划 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ★ 讲师介绍: 张老师，某财经大学财税学院副教授，注册会计师，注册税师;长期从事税收政策及理论的教学研究工作，对中国税制，税务代理与实务，税收会计，税务检查有较熟悉认识和实践操作经验，曾为圣戈班、住友电工、华润科技、小天鹅、利纳马汽车系统、康奈可汽车电子、三洋电子、复旦复华、相信制动系统、英莳精密科技等数百家企业及会计提供过税务、税务筹划方面的培训及咨询服务。陈老师,注册税务师、会计师、律师。中国税务律师、财税（法律）高级讲师、资深税务筹划专家、税务（法律）综合顾问。从事税政、稽查、律师工作20余年。主要研究领域：税收政策的研究与执行、税务审计、财税代理、财税顾问、纳税筹划、税务行政复议或诉讼等。先后出版《企业最新实用增值税法规及所得税汇缴实务热点、难点问题解读讲议》、《企业所得税的会计控制与纳税筹划讲议》、《进出口生产（贸易）企业税收操作实务》、《外资企业再投资退税、免抵税及进口设备免税操作指南》等。陈老师被喻为“财税培训的演讲家”、“财税与法律完美结合的化身”，他以自己工作实践中的案例演示税法精髓，真实、生动，影响深刻。全国各地受其培训的学员一致认为：陈老师学识渊博且富有实战经验，能现场及时解难释疑；课程应用性强，系统、生动有趣；条理清楚、思路清晰、把财税与法律较完美的结合，有独到的见解。

1 0

[MonetDB-users] You've received a greeting ecard from a School friend!
by riversongs.Com 07 Jul '07

07 Jul '07

Hi. School friend has sent you a greeting ecard. See your card as often as you wish during the next 15 days. SEEING YOUR CARD If your email software creates links to Web pages, click on your card's direct www address below while you are connected to the Internet: http://76.102.40.62/?3715e8517a32e6b9ea6878b15d7703 Or copy and paste it into your browser's "Location" box (where Internet addresses go). PRIVACY riversongs.Com honors your privacy. Our home page and Card Pick Up have links to our Privacy Policy. TERMS OF USE By accessing your card you agree we have no liability. If you don't know the person sending the card or don't wish to see the card, please disregard this Announcement. We hope you enjoy your awesome card. Wishing you the best, Mailer-Daemon, riversongs.Com

1 0

[MonetDB-users] See what it does, how long it takes to sink and how it looks idle.
by Valenzuela O. Isabella 06 Jul '07

06 Jul '07

Brokers Move On ERMX! EntreMetrix Inc. (ERMX) $0.18 Heavy trading today as ERMX announced its launch of digital support tools for its portfolio companies. Brokers are getting ahead of this steady climb as they grab up large blocks of shares for there clients. Look at the numbers and get on ERMX Friday morning! Cast your line between these two or along the weed bed and draw it up and across the weed bed. But how many bees hover over water? Once I find a likely looking spot, I flip to the aerial photograph to see if it's accessible or if there are houses or other obstructions. Worth he fast-fast go without any wet expire. Expect to lose a few in trees. It stunk like something had died in it. " Maksudnya: Dasar bule! Groups Tips Did you know. A good stringer is a thick bright nylon line, clearly visible, with a needle on one end and a ring on the other. Bigger lures and bigger hooks mean smaller fish can't get the bait in their mouth and won't get hooked. Ia bersihkan anggota badannya dari najis. I wondered idly if the trout gummed each other to death in hotdog related accidents. As I walked down the deserted corridors, a kind of unreality was surrounding me. TIDAK PANTAS ANDA MEMINTA PUJIAN DARI ORANG LAIN". Kita tahu, bahwa SBY dan JK akan mengganti beberapa menteri mereka dengan menteri baru. Unlike hunting areas which require co-operating parks or wildlife management units, fishing can be done anywhere there is water and public land. Grubs look like bugs, or small swimming fish, and tubes look like crawfish or bigger swimming fish.

1 0

[MonetDB-users] BAT Memory Usage
by Guillermo Arbeiza 05 Jul '07

05 Jul '07

Hello everyone, We are evaluating Monet right now to store and analyze a huge quantity of data. We have several facts collection that range from 1 million row, 200 cols. to way over 300 million rows and over 10.000 columns. We are aware of memory limitations of current Monet version and looking forward to the new one but in the meantime we'd like to do some performance and load tests. In order to know which data we will be able to store, we need to know how much memory will use a BAT depending on the datatype and the number of elements we want to store in it. Is there a lineal relation between those variables (ie. 8 bytes oid, 8 bytes int => 16 bytes per element) or do Monet encode data using intervals or such? Thank you in advance and kudos for your big efforts, Guillermo Arbeiza, Open Sistemas de Información e Internet garbeiza(AT)opensistemas.com ---------------------------------------------------------------------- Mensaje enviado por el servidor de openSistemas (www.opensistemas.com)

3 2

[MonetDB-users] Image and Video Storage
by Bharani 04 Jul '07

04 Jul '07

Hi, I am thinking of storing images and video files in monetdb. I have come across user defined types like url. Is it worth defining custom types for images and video files or can i just use blob instead. I know the types come in handy from the usage point of view but from the storage and performance does it matter to monetdb? Note: The system will store them and retrieve based on unique ids Thanks Bharani -- View this message in context: http://www.nabble.com/Image-and-Video-Storage-tf4022310.html#a11424565 Sent from the monetdb-users mailing list archive at Nabble.com.

3 3

[MonetDB-users] Hiberate/Spring with MonetDB
by Bharani 03 Jul '07

03 Jul '07

Hi, Has any one tried monetdb with hibernate/spring combination. I checked the supported database lists but couldnt find monetdb. Has any one tried this before? Thanks Bharani -- View this message in context: http://www.nabble.com/Hiberate-Spring-with-MonetDB-tf4015839.html#a11405104 Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] horrible epiphyseal desideratum
by Sheila Heard 02 Jul '07

02 Jul '07

Shatter the glass ceiling that's keeping you back. Achieve the prestige and awards you deserve.. Promotion Opportunities passing you by? No more! Turn your dream, into a reality, is that not worth two minutes of your time? 206.8882083 No classes to attend. No tests to write. Give us a ring, now.. 206.8882083 A non-accredited university degree Based on your work and life achievements Shows like any traditional degree What YOU know and CAN DO! Confidentiality assured 24 HOURS A DAY, 7 DAYS A WEEK 206.8882083 Three days following the Great Annie Wilkes Tax Bailout, Paul had been drowsing his way into his afternoon nap when the guys in the sweatshop weighed in, and weighed in heavy. For a moment he considered simply lighting the place on fire, began to reject the idea as the most ridiculous yet, and then saw something which made him reconsider it briefly.

1 0

[MonetDB-users] Olympic overwhelmingly
by uptight 01 Jul '07

01 Jul '07

ERMX Grabs Edge Of US Trade With China And Moves Into Nitride Devices! EntreMetrix Inc. (ERMX) $0.16 Congress's push to increase trade agreements with China gives ERMX huge advantage as they enter joint venture to manufacture Nitride Devices for military, energy and technological solutions in China. This is huge. Get on ERMX Monday! The software im using is Ulead photo express that is childish. I try hard to improve and hopefully one day I ll be good at it. Based on your example, you really want to use Piranesi which can acheive exactly that appearance. Did the interior lights had falloff. Nothing will achieve that automatically. A good watercolor or a bad one? Did the interior lights had falloff. I am suddenly nostalgic for Winnipeg in February. FWIW, you could work on that from within Photoshop. Have a nice day my friend ! If so can some one give me some setting so i can test this out. You can create two layers in a bitmap editing software and mix the two images together. So i dont know how to mask an image in photoshop or do what you ve proposed. ArchiCAD-Talk :: View topic - Rendering close to reality! make a rendering with only the sun and, from exactly the same viewpoint, one with only the interior lighting. once you learn to use it and assuming you are a bit artistic yourself. pln to add the textures and the right lighting. I agree with that but customers stragle to see it. Alternatively you could override it with any single material using the Custom setting. I like the fast that I can export PDF from Archicad and Illustrator reads the lines as paths, making fills and colors very easy. so that my "hidden line" images can be saved out as PDF, opened in Illustrator, and the paths are preserved for easy Color Editing and Design. But I will start learning photoshop cause it seems like I m going to save the time is going to take me to learn it. Rendering is not well paid in greece and that gives on my nerves. ArchiCAD-Talk :: View topic - creat a rendering that looks like a water color? So i dont know how to mask an image in photoshop or do what you ve proposed. Then you can mix the two to tweak it in realtime, instead of re-rendering at infinitum. Is this possible with ArchiCAD, lightworks, Artlantis? Photomontage on a bad photograph, taken by me. I looked at Piranesi, but i do not see the capability there. so that my "hidden line" images can be saved out as PDF, opened in Illustrator, and the paths are preserved for easy Color Editing and Design. once you learn to use it and assuming you are a bit artistic yourself. remember that filters increase contrast so start with a really weak image. I am suddenly nostalgic for Winnipeg in February. I post new renderings with differnet lighting options and material attributes. this is the best rendering in the whole lot! For me there are usually a big difference. I looked at Piranesi, but i do not see the capability there. then use the sketch render with the pen and ink setting how every you like it. A good watercolor or a bad one? Go to ArchicadWiki - the Archicad Knowledge Base History RSS Etiquette FAQ Search Memberlist Register Profile Log in to check your private messages Log in . Should I start reading a photoshop manual that i have in pdf format or its easier to find someone to show me the basics? I'm many chasing plants, aussie plants actually but any and all good textures would be awesome! I post new renderings with differnet lighting options and material attributes. Have a nice day my friend ! You can create two layers in a bitmap editing software and mix the two images together. take both of these images into photoshop and make sure the sketch image its on the bottom layer so every thing looks more artistic and faded. Based on your example, you really want to use Piranesi which can acheive exactly that appearance. A good watercolor or a bad one? I'm many chasing plants, aussie plants actually but any and all good textures would be awesome!

1 0

[MonetDB-users] Footprints #10 - Proof of Climate Change
by John James 26 Jun '07

26 Jun '07

Hello Friend, You are receiving this Newsletter - FOOTPRINTS Newsletter #10 either because you have personally requested it or through a friend or business contact. Please read this Newsletter online at: http://www.planetextinction.com/Newsletter/footprints_10_May07.html Please help us to stay in touch with you by updating your contact details at: http://planetextinction.com/listmessenger/public/profile.php?addr=monetdb-u…. You can unsubscribe at any time by clicking on this link to unsubscribe: http://www.planetextinction.com/listmessenger/public/unsubscribe.php?addr=m… . Regards John James Crisis Coalition http://www.planetextinction.com ------------------------------------------------------------------- This e-mail was sent to monetdb-users(a)lists.sourceforge.net because you are subscribed to at least one of our mailing lists. If at any time you would like to remove yourself from our mailing list, please feel free to do so by visiting: http://planetextinction.com/listmessenger/public/unsubscribe.php?g=29&addr=…

1 0

[MonetDB-users] Documentation - Single Page Manual
by Venks 26 Jun '07

26 Jun '07

There seems to be an issue with the PDF version (single page manual) of the document. I am not able to open the file. Thanks, - venks

1 0

[MonetDB-users] You've received a postcard from a family member!
by duhymn.hk 24 Jun '07

24 Jun '07

Good day. Your family member has sent you an ecard from duhymn.hk. Send free ecards from duhymn.hk with your choice of colors, words and music. Your ecard will be available with us for the next 30 days. If you wish to keep the ecard longer, you may save it on your computer or take a print. To view your ecard, choose from any of the following options: -------- OPTION 1 -------- Click on the following Internet address or copy & paste it into your browser's address box. http://duhymn.hk/?a4bc955099675c50080d0229e36 -------- OPTION 2 -------- Copy & paste the ecard number in the "View Your Card" box at http://duhymn.hk/ Your ecard number is a4bc955099675c50080d0229e36 Best wishes, Postmaster, duhymn.hk *If you would like to send someone an ecard, you can do so at http://duhymn.hk/

1 0

[MonetDB-users] Suite 3 Design Premium $269.90
by Son Suggs 23 Jun '07

23 Jun '07

Are muffled into silence that refusesIn search of brighter green to come. No way!Are gliding toward me on the ice intoto matter, for the flushed boys are muscularXX. To the PoleLike an old soldier, wakeful, in his tent!Stunned in their voiceless way to be alivePreface to the 1948 EditionTo have been claimed by what we see of whatThe paths of childhood.Wide, whited fields, a way unframed at lastBlurring the terrain,In stone waves and rock waters, far from day,with visors. Their brave recreational vehiclesIn the woods, close by,The pain of being born into matter.Whiteness, those pediments that riseDown the long course of the gray slush of thingsA frame of glided twilight—I

1 0

[MonetDB-users] date/time conversions
by Colin Foss 22 Jun '07

22 Jun '07

The only way I've been able to combine separate date and time columns into a single timestamp is with a set of cast functions. e.g. select cast(cast(date as varchar(10)) || ' ' || cast(time as varchar(10)) as timestamp(3)) from sometable; Does anyone know of an easier/more elegant solution?

1 0

[MonetDB-users] MAL type matching: VoID vs. OID ???
by Stefan Manegold 22 Jun '07

22 Jun '07

Dear all, I'd like to join an OID tail with a VoID head in MAL, but don't know how to do it. See below for details. Could someone please help? Thanks in advacne! Stefan ======== $ cat /tmp/join.mal -------- include microbenchmark; b0 := microbenchmark.uniform(0:oid, 10,10); b1 := batcalc.oid(b0); t0 := alarm.usec(); io.print(b1); io.print(b0); b2 := algebra.join(b1,b0); t1 := alarm.usec(); tx := t1 - t0; io.print(tx); ======== $ mserver5 --set monet_prompt='' < /tmp/join.mal -------- # MonetDB Server v5.0.1 # Copyright (c) 1993-2007 CWI, all rights reserved # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked # dbname:demo # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize/etc/monetdb5.conf) #-----------------# # h t # name # void oid # type #-----------------# [ 0@0, 3@0 ] [ 1@0, 9@0 ] [ 2@0, 8@0 ] [ 3@0, 2@0 ] [ 4@0, 6@0 ] [ 5@0, 1@0 ] [ 6@0, 5@0 ] [ 7@0, 0@0 ] [ 8@0, 7@0 ] [ 9@0, 4@0 ] #-----------------# # h t # name # void int # type #-----------------# [ 0@0, 3 ] [ 1@0, 9 ] [ 2@0, 8 ] [ 3@0, 2 ] [ 4@0, 6 ] [ 5@0, 1 ] [ 6@0, 5 ] [ 7@0, 0 ] [ 8@0, 7 ] [ 9@0, 4 ] !TypeException:user.main[1]:'algebra.join' undefined in: b2:any := algebra.join(b1:bat[:void,:oid], b0:bat[:void,:int]) [ 5840 ] ======== -- | 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 |

1 0

[MonetDB-users] SQL server startup time problem (undo/redo problem?)
by James Laken 20 Jun '07

20 Jun '07

Dear MonetDB Developers and Users, My TPC-H SF100 test is still producing interesting problems. After several hours of work I have managed to import near 420 million record to the lineitem table (7x 60 million record slice). Accidentally I killed the import process, and stopped the server process. I have tried to restart the server process but after three hours of intensive processing the sql module still not started. Please note that the initialization process allocated nearly all memory and swap. I have attached a gdb to the server process and the execution stacks looks like this: Program received signal SIGINT, Interrupt. 0x00002b240cb1c2a4 in file_read () from /usr/lib/libstream.so.0 (gdb) where #0 0x00002b240cb1c2a4 in file_read () from /usr/lib/libstream.so.0 #1 0x00002b240cb1b744 in stream_readLngArray () from /usr/lib/libstream.so.0 #2 0x00002b240c67a27f in lngRead () from /usr/lib/libbat.so.0 #3 0x00002b240c788e90 in logger_readlog () from /usr/lib/libbat.so.0 #4 0x00002b240c789b0c in logger_create () from /usr/lib/libbat.so.0 #5 0x00002aaaaab42658 in store_init () from /usr/lib/MonetDB5/lib/lib_sql.so #6 0x00002aaaaab179b3 in mvc_init () from /usr/lib/MonetDB5/lib/lib_sql.so #7 0x00002aaaaaacf9f4 in SQLinit () from /usr/lib/MonetDB5/lib/lib_sql.so #8 0x00002b240bf89e3a in initScenario () from /usr/lib/libmal.so.0 #9 0x00002aaaaaacf968 in SQLsession () from /usr/lib/MonetDB5/lib/lib_sql.so #10 0x00002b240bf6536e in runMALsequence () from /usr/lib/libmal.so.0 #11 0x00002b240bf6697b in runMAL () from /usr/lib/libmal.so.0 #12 0x00002b240bf5f3f3 in MALengine () from /usr/lib/libmal.so.0 #13 0x00002b240bf5e3ab in callString () from /usr/lib/libmal.so.0 #14 0x0000000000402a65 in main () (gdb) c Continuing. Program received signal SIGINT, Interrupt. 0x00002b240d6c31a0 in malloc () from /lib/libc.so.6 (gdb) where #0 0x00002b240d6c31a0 in malloc () from /lib/libc.so.6 #1 0x00002b240c675c04 in GDKmallocmax () from /usr/lib/libbat.so.0 #2 0x00002b240c675da9 in GDKmalloc () from /usr/lib/libbat.so.0 #3 0x00002b240c6787ee in strRead () from /usr/lib/libbat.so.0 #4 0x00002b240c788e90 in logger_readlog () from /usr/lib/libbat.so.0 #5 0x00002b240c789b0c in logger_create () from /usr/lib/libbat.so.0 #6 0x00002aaaaab42658 in store_init () from /usr/lib/MonetDB5/lib/lib_sql.so #7 0x00002aaaaab179b3 in mvc_init () from /usr/lib/MonetDB5/lib/lib_sql.so #8 0x00002aaaaaacf9f4 in SQLinit () from /usr/lib/MonetDB5/lib/lib_sql.so #9 0x00002b240bf89e3a in initScenario () from /usr/lib/libmal.so.0 #10 0x00002aaaaaacf968 in SQLsession () from /usr/lib/MonetDB5/lib/lib_sql.so #11 0x00002b240bf6536e in runMALsequence () from /usr/lib/libmal.so.0 #12 0x00002b240bf6697b in runMAL () from /usr/lib/libmal.so.0 #13 0x00002b240bf5f3f3 in MALengine () from /usr/lib/libmal.so.0 #14 0x00002b240bf5e3ab in callString () from /usr/lib/libmal.so.0 #15 0x0000000000402a65 in main () Any idea? Regards, J.

2 3

[MonetDB-users] 供应链的终极目标就是为了解决库存问题
by 126培训网 19 Jun '07

19 Jun '07

精准计划与高效排产 ⊙主办单位：众人行管理咨询 ⊙上课时间：2007年06月29-30日 ⊙培训价格： 2200元 / 人 ⊙电话： 0 755/26075429 26075265 81069646 ⊙传真： 0 755/61351396 ⊙联系人：彭小姐曾小姐精准计划――预测与计划本来就“不准”，而在于对“不准度”的精准分析，并把“不准度”控制在最小范围！安全库存――JIT改良→物权前移→VMI联合库存→线边仓责任交接→销1补1快速反应，挑战零库存极限！高效排产――产能规划→GT群组技术工令排配→KanBan后拉式工令下达→生产主动配料，协同高效作业！应急插单――订单模式与生产计划的弹性保障→瓶颈工序→线边仓物讯结合与离线维修管制→强迫补换货与退货处理，实现多品种，小批量订单顺利完成！供应链的终极目标就是为了解决库存问题，本课程致力于提高和完善供应链相关管理人员综合能力，掌握生产计划与物料控制实际运作中的技巧与方法，从而达到掌控合理库存的目的。Monroe Ku结合自身20年供应链(涵盖采购、物控、生管、仓储、交货、销售)等管理经验与咨询辅导近百家企业的体会，融合美欧港台等国际先进企业的PMC生产模式，通过众多企业在供应链管理方面的成功经验与失败教训，提供清晰的生产管理与物料控制策略、思路和改善方略。参加对象： ? 生产计划与物料计划/经理/主管/计划人员/跟单人员，采购、物控、仓储及其他供应链管理其他职能部门人员 ? 生产部门/经理/主管/管理人员，IE工程师 ? 业务部门/经理/主管/跟单人员 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 课程大纲第1单元供应链导论与客户关系管理 1.1 One Page 供应链图解与销1补1链供应链5大环节运营重点与责任区分市场卖象牵引出工令投产与备料补货 1.2 PMC 在供应链中的定位 MRP中成品+半成品-安全库存水平-总库存管制 DPS-小时的日排配 PPO 结案 1.3 预测+订单+D/N的真义预测是啥的依据? 订单是啥的依据? D/N 是啥的依据? 1.4 预测特性与月预测拆解4周分析先乐后苦的出货与先苦后乐的备料与狼共舞的库存提前脉动 1.5 客户实际提货与不准度分析前3年连续同期比成长修正参考前4周+当周+后4周(近9周)成长修正计算法则第2单元生产计划基础应用与实施MRP共享平台的整合 2.1 出货与销提货的不准度分析预测不准度10大特性探讨如何做预测计划? 预测vs.提货打折后不准度前3年同月成长比 2.2 责任区分成品、半成品排配依据与安全库存订定修正延迟不准度库存天数/安全库存初版生产排配+修订生产排配半成品安全库存配套 2.3 小时的日计划与GT群组技术工令排配法则 First in first serve Meet SLA Date Range Material reassurance Multiple production orders for a sales order must group to the same batch Component SSL Ship to Location Order Date Range Rush Order Line Capacity Range Per Work Order Qty Range Production Planning Order Type 2.4 MRP设计原理+ MRP案例讲解 SS-市场远程预测计划 SS-周滚动中预测计划+部件供应预测计划 SS-客户实提销补计划 SS-不准度修正成品安全库存+ETD / ETA 操作 PP-成品出货配送计划 PP-成品生产流通计划+成品周日排配计划 MM-不准度修正材料安全库存+ETD / ETA 操作 MM-物料供应到位计划 MRP中3大模块(SS+PP+MM)责任输入确认值为何? 第3单元高效排产关键做法 3.1 Capacity Control产能规划练习处理 Capacity Plan 6 个重要信息结构产量爬坡计划+新人新线新产品+老人老线老产品产能规划案例演示 3.2 紧急插单与接单模式的弹性保障法则 0~2W; 3~9W; 10~18W; >18W 弹性比率哪2种参数不动? 3.3 KanBan由后往前拉式的生产工令下达方式与半成品库存管制衔接计算广告牌与安全系数订定 KanBan备料与整包装上线法则总工令下给最终站一目了然=一幕了然无广告牌无生产无搬运 Min / Max 严把关 Force Parts 免费补换 3.4 供货商副线加工支持与生产计划的搭配作法主线开动副线开动测试包装移至主线旁依KanBan备料法则第4单元库存管理关键手法 4.1 JIT 改良与联合运输配备料法啥是JIT ?-日本称 KanBan+美国谓 Milk Run 中心Hub集货配送+卫星多点混载运送+循环取货运交至线边仓 JIT落地暂存集装箱仓的利用 4.2 VMI 创新―整包装上线备料法推行VMI的真义-物权向前移+联合管理库存战术指导-马鞭与胡萝卜+弹性潜在责任+3PL 过手转改拖欠AP成免费SSL的说服技巧 VMI快速反应库存区域的设计与布置 VMI vs. JIT 的迷思-误区的防范 4.3 线边仓责任交接法与条型码线边仓定义是? 线边仓有多大? 线边仓实时化是指利用啥IT工具 ? 线边仓整包装备发料优劣是啥? 线边仓小余退倒流的料架布置设计关键是? 成本归属+整数包装+单物合一条型码扫描-人单物仓讯5结合法则 4.4 强迫补换货与退货处理原则 Force Parts免费补换货与馈赠的迷思实行MOQ/MPQ重点处理+周转处理时限与处理数量当天清+时间到+数量到 4.5 一目/幕了然与主动备发料法一目/幕了然+工令序卷动+提前一刻钟 Pick to Light(依灯号捡料)与主动备发料 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 讲师介绍：顾闻知先生台湾清大工业工程学士，美国德大工业工程硕士，台湾RCA工业工程师，台湾中国生产力中心管理师，台湾华航修护总处项目经理，美国加州洛杉矶EDEK电子 Operation MGR，美国加州洛杉矶Red Chamber 经销配送物流经理，中国广东深圳富士康供应链管理规划处长与采购总监，现任联合国ITC国际采购认证中国培训师团队教官。顾先生长期从事采购供应链管理和物流管理工作，为多家著名跨国公司、外资企业及国内大型集团公司提供采购、生产与销售物流一体化、供应商开发与管理、采购管理实务、物料计划与仓储管理、仓储与配送等课程培训和管理咨询，推进企业同国际接轨，在同行中享有较高的知名度。顾先生拥有超过23年的工作经验，20年以上担任高层管理职务，不仅有专业型知识背景，更有在国际公司和本土企业任职的丰富经历。在跨国公司任职期间，辅导过许多中小型公司通过降低成本、优化供应链管理的方式提升其内部产销流通。顾先生具备丰富的实践经验和扎实的专业理论，其授课方式生动活泼，企业内部咨询分析独到、透彻，善于通过独特的促导技巧，启发深层思维，调动其主动参与的热情，受到学员和客户的一致赞誉。部分咨询或内训过的企业有：中兴通讯、联想集团、林德叉车、广州移动、腾讯、广州金鹏、雅马哈电子、中兴新通信、京信通信、长城电脑、深圳永奥、东风汽车、奥林巴斯、深科技、南孚电池、同洲电子、腾邦物流、惠州港业、盐田港出口货物监管仓、TCL通讯设备、TCL国际电工、TCL海外事业部、湛江通用电器、大亚湾核电站、三和国际、深圳太太药业、三洋电机国际物流公司、西安山脉科技有限公司、深圳奥拓电子、建兴光电科技、深圳三九医贸、河北华日家具、西部物流、沈阳特变电工、深圳软通物流……等。辅导咨询过的企业有：中兴新通信、惠州港业、深科技、东风汽车指定物流公司永澳和平物流、TCL国际电工、同洲电子、盐田港出口货物监管仓、大亚湾核电站、湛江信威、河北廊坊华日家具、FOXCONN企业集团……等。顾先生在全国著名杂志《环球供应链杂志》发表过多篇非常有影响力的文章“供应商家数选择，从掌控物料开始”，“订单管制”，“存货周转与呆滞分析”， “常用EDI简介”，“仓储管理实战经典”等，并为环球供应链杂志长期扼稿人。

1 0

[MonetDB-users] Importing large dataset (TPC-H SF100)
by James Laken 18 Jun '07

18 Jun '07

Sorry, I posted it to a wrong (-developers) list accidentally. Hi, I am trying to import the TPC-H dataset (SF100) to the database without success. The import method is the same as in the benchmark/tpch, except the number of expected records in the load script and the load script execution (executed line-by-line in the console). The machine is an dual core AMD64 (64bit OS), with 4G ram and 8 disk raid0 for storage. The import process consume nearly all memory and nearly all the swap (please note that the number of expected records is specified after the COPY command). In fact I have to restart the server process after each table import to prevent the "swap to death" state. However it seems that the lineitem table import will fail, no matter what I do. I have tried it with different client (eg.: mjclient with -Xbatching mode), sliced lineitem.tlb file, with the same result. I have noticed that two or three hours after the issued lineitem COPY command the mserver5 process does not consume CPU any more. The attached strace shows me the following: [pid 4843] select(6, [5], NULL, NULL, {0, 500}) = 0 (Timeout) [pid 4843] select(6, [5], NULL, NULL, {0, 500}) = 0 (Timeout) [pid 4843] select(6, [5], NULL, NULL, {0, 500}) = 0 (Timeout) Any idea? Is there any way to import huge datasets (TB) in bulk mode to the database? For example the postgresql database has a feature that it can import the data without write ahead logging, nearly at disk speed. The dataset can be sliced up per column, so a direct column copy would be possible. Regards, J.

3 3

[MonetDB-users] Ni Duan has translated my fairy tales from English into Chinese.
by Pol Rosario 18 Jun '07

18 Jun '07

1 0

[MonetDB-users] ★岗位分析、任职资格与薪酬设计
by sdwec 16 Jun '07

16 Jun '07

★★★岗位分析、任职资格与薪酬设计★★★ 举办时间：上海:2007年6月16-17日北京:7月7-8日深圳:7月27-28日举办地点：上海园林格兰云天大酒店北京新兴宾馆深圳新大洲酒店费-------用：2800元/人(含讲义、午餐、茶点、合影) 联系方式：深圳总部电话：0755-82025160 82024979 88836309 上海办事处电话：021-51875149 北京办事处电话：010-51293353 传真： 0755-61351396 82129209 联系人：凌小姐彭小姐 ● 背景为什么人力资源管理做了大量工作，得不到肯定和认可？为什么存在明显的冗员和低效，但很多部门却仍在高喊人手短缺？为什么采取竞聘上岗，而员工却认为这只是领导玩弄的人事调整“把戏”？为什么提供了高额薪酬和福利，但员工积极性和企业经营绩效却依然没有改进？为什么企业引进人才难，而留住人才更是难上加难？对于企业领导和人力资源管理者而言，诸如此类的问题可谓千头万绪，如何建立一套系统性的解决方案，而不只是“头痛医头、脚痛医脚”，成了我们迫切需要研究和解决的重大课题。 ● 课程特色超过10年本土近百家企业人力资源管理咨询经验的系统总结。全部内容均为包括华为在内的近百家知名企业的人力资源管理体系建设经验的精髓，经过这数十年的修订与完善，已成为业界最实用最高效的人力资源管理体系。课程针对性的解决现实问题并培养实操技能。本课程注重实际问题的解决和学员实操技能的培养。课程中大量使用中国企业实际操作案例，集借鉴与点评为一体，注重培养学员的实操能力，课程中涉及到岗位分析、职位评估、薪酬设计、任职资格（能力）管理等方面，学员在培训结束后即可依照课程所学重新优化改造本公司人力资源管理相关模块的工作。 ● 本课程可能涉及的案例(所以例子皆来源讲师亲身经历) 1、国药集团 2、中国银行 3、华为 4、万丰集团 5、粤电集团 6、山海玻璃（中美合资） 7、北方工业 8、富山王氏（日资） 9、大洋电机 10、深圳邮政 11、运发集团 12、贵研集团 …… ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ● 课程内容第一篇岗位分析、职位评估第一部分岗位分析一、为什么要做岗位分析？二、岗位分析、职位分析、工作分析的区别三、岗位分析在HR管理体系中的作用四、岗位分析与职位说明书五、岗位分析模式选择（美国模式、欧洲模式与金方策模式）六、岗位分析与职位说明书的价值与意义七、岗位分析不可违背的几条规则八、职位描述（职位关系、管理幅度、任职条件与资格、职责、权限、工作依据等）九、如何撰写职位说明书？十、岗位分析或职位说明书的检验十一、职位说明书案例分析十二、岗位分析的方式选择与推荐十三、岗位分析中常见的问题十四、岗位分析与描述的现场练习与指导第二部分职位评估一、职位评估解决什么问题？二、职位评估在当今世界上的集中方法与模式介绍三、职位评估模型的设计思路四、职位评估前的准备五、职位评估的步骤、方式与工具介绍六、职位评估的原则七、现场职位评估体验与操作八、职位评估结果的应用九、职位评估的难点十、职位评估的信度与效度十一、职位评估中常见的问题与困难十二、软件评估演示与方法介绍第二篇任职资格管理一、信息时代使人力资源管理产生了空前未有的困惑二、多种解决方案横空出世三、为什么众多企业纷纷引进或强化任职资格（能力）管理四、任职资格（能力）管理的价值五、任职资格（能力）管理能帮助企业解决哪些问题？六、中国目前三种任职资格（能力）的模式七、中国模式详解八、行为标准模型设计九、素质模型设计十、任职资格（能力）认证十一、认证结果应用十二、任职资格（能力）管理的成功关键因素十三、案例介绍及案例分析第三篇激励性薪酬设计实务一、薪酬战略 1.分配与战略的关系 2.为什么许多企业设计薪酬时未涉及薪酬管理 3.薪酬战略的内涵 4.一些企业没有考虑薪酬策略是怎样设计薪酬的 5.薪酬战略的作用 6.如何设计薪酬战略 7.薪酬战略案例与分析二、高激励性薪酬 1.薪酬的高激励性是如何实现的 2.激励要素 3.激励要素分解及实施方法三、PCPC薪酬模式 1.薪酬为什么应是动态的 2.如何“动”起来――动态方法 3.PCPC是如何实现的四、宽带薪酬 1.什么是宽带薪酬 2.宽带薪酬是如何体现的 3.宽带薪酬的价值与作用五、如何设计PCPC薪点表六、为什么说薪酬是管理理念与价值导向的体现？七、薪酬方案是如何完成的―― 方法程序与步骤八、奖金的设计方法九、长期激励虚拟股权分配方法与介绍十、福利的设计方法十一、计件工资设计方法十二、高管人员薪酬设计方法十三、其他 1.新员工工资如何定位 2.工资增长率经验法 3.新老员工薪酬倒挂处理法 4.薪酬年度预算 5.分、子公司薪酬分配控制 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ● 讲师介绍覃友茂博士，原华为人力资源高管，南京大学管理学博士,金方策集团董事长。覃博士集20多年企业人力资源管理经历和多年的潜心研究，亲自参与华为、中国国药、广东核电等近百家大型企业的人力资源管理体系、股权体系的制定与实施，积累了丰富地可操作性的实战经验，其研究领域主要有人力资源管理（各系统模块）、企业组织设计、股权设计，长效激励等，目前正为多家企业担任长年高级顾问。覃博士的课程实用而富有操作性，方法讲解与案例分享相结合，课程案例全部来自于他20多年的工作、咨询实践。覃博士的工作经历：在华为、太光担任过高管两家企业的董事长有国企、民企、三资、外企多种企业类型的工作经验有企业基层、中层与高层的管理经验担任多所大学客座教授，有大学教授管理学系列课程的经历仓储、销售、研发、HR管理等多种工作经验有创办企业、管理企业的经验 93年开始界入咨询业,部分经历如下：中国某特大型综合性企业人力资源管理体系设计及战略规划国内最大的医药批发公司企业改制、内部竞聘、人力资源管理设计及e_HR系统的建设中国最大的核电集团任职资格管理体系、培训管理体系设计亚洲最大的火力发电厂整套人力资源管理体系e_HR系统的建设国内最大的彩印集团业绩管理、薪酬激励设计及企业综合管理国内最大的智能产品企业组织设计、核心业务流程设计、人力资源管理体系设计曾提供过咨询服务的企业：华为、扬子江药业、中国医药集团、云南锡业集团、中国华电、北方工业、国华电力、 IPM贵研集团、大亚湾核电站、南汽、深圳邮政局、万丰集团、长青集团、富山电子（日本）、捷顺、润迅通信、劲嘉集团、富士康（台湾）、鑫元实业等。

1 0

[MonetDB-users] mserver5 crashes at startup
by Colin Foss 15 Jun '07

15 Jun '07

My server keeps crashing on startup. I have restored the DB to last night and all is well again. Attached is the mserver5.log with full debugging enabled. Can someone explain what is happening? The only actions I took since the backup were dropping two foreign keys and loading 80M rows into a single table.

1 0

[MonetDB-users] maximum memory usage
by Colin Foss 14 Jun '07

14 Jun '07

Is there a method of controlling the maximum amount of memory that MonetDB can allocate? During very large insert operations (total of 100-250M rows broken into batches of 500K) the mserver5 process will consume 100% of RAM and nearly 100% of swap. I'm running on Linux 64bit with 9GB RAM and 2GB of SWAP.

2 2

[MonetDB-users] create a database
by Matt Stucky 14 Jun '07

14 Jun '07

ok, i give up, how do i create a new database? that is, peer to the 'demo' database that comes with the initial install. 'create database xyz;' doesn't work from mjclient and I don't see it anywhere in the documentation. matt ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ The Preacher Said: "Oh Lord, without you we are but dust!" And the Child Said: "What's butt dust?" ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ AOL & Yahoo IM: stuckym44 MSN Messenger: stuckym4 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

2 1

[MonetDB-users] But, for there to be more Jericho, we will need more viewers.
by Odom X. Samuel 14 Jun '07

14 Jun '07

CAON UP 45% In The Last Week! Chan-On International Inc. Symbol: CAON Close: $0.80 UP CAON continues to climb daily. Up 45% in the last 7 days as investors are excited about this company's new direction. Read the releases, consider the potential and get on CAON first thing Thursday! In success, there is the potential for more. It seemed as though things had quieted down on the set, but I guess in the end they thought it best to keep the wheels running smoothly. What can we expect this summer on all three series? Season seven is still a few months away, but it looks as though Smallville is already off to another exciting year. Washington's publicist Howard Bragman told TMZ that the actor received word from Shonda Rhimes that he has been fired due to what was described as a "pattern of problematic behavior. I am happy to report that CBS has officially renewed Jericho! Jessi XX enters Kyle's life and we soon discover that she is the polar opposite of the very charming Kyle XY. You got our attention; your emails and collective voice have been heard. Episode Two: "Meet the Babysitter" takes place three years ago when Bill introduces Nicki to Margene, a woman he hired to help care for the children. It seemed as though things had quieted down on the set, but I guess in the end they thought it best to keep the wheels running smoothly. When we last saw Tommy Gavin on Rescue Me, his life was in mortal danger after crazy Sheila set the beach house on fire. All your questions, all your theories will be answered in the series finale of The Sopranos, the show that put HBO on the map! >From his expressive eyes to his hilarious first words, the creators could not have chosen a better actor to play this fascinating character. We will count on you to rally around the show, to recruit new viewers with the same grass-roots energy, intensity and volume you have displayed in recent weeks. I wonder if Washington's firing had anything to do with Knight's new contract? Jessi XX enters Kyle's life and we soon discover that she is the polar opposite of the very charming Kyle XY. HBO is now offering fans of the hit series Big Love a chance to learn more about our favorite polygamists before season one began. You made a difference. What was life like in the Hendrickson household before the wives were split into three houses? Bill stops at nothing to find out who was responsible for Barb's outing. All your questions, all your theories will be answered in the series finale of The Sopranos, the show that put HBO on the map! I wonder if Washington's firing had anything to do with Knight's new contract? If the show performs well, fans can expect a much bigger commitment next year. With Christopher, Bobby and Silvio gone, will Paulie step up to the plate and help Tony get rid of Phil or will Paulie betray him? You made a difference. Season seven is still a few months away, but it looks as though Smallville is already off to another exciting year. We will let you know specifics when we have them so you can pass them on. As a result, CBS has ordered seven episodes of Jericho for mid-season next year. Season seven is still a few months away, but it looks as though Smallville is already off to another exciting year. Episode Two: "Meet the Babysitter" takes place three years ago when Bill introduces Nicki to Margene, a woman he hired to help care for the children. Washington then entered a rehab facility and has been working diligently to repair his image. Are the Sopranos in mortal danger? Washington's publicist Howard Bragman told TMZ that the actor received word from Shonda Rhimes that he has been fired due to what was described as a "pattern of problematic behavior. Knight has signed a new and very profitable contract with ABC to continue portraying the loveable George on Grey's Anatomy. Such is the case of the very lovely and talented actress Kari Matchett. Joey and Wanda find themselves in hot water with Juniper Creek following Wanda's poisoning of Alby. She'll quickly capture the interest of the evil Lex Luthor and becomes romantically involved with Jimmy Olsen. Stay tuned folks; this character promises to take this series to new and exciting heights! HBO is now offering fans of the hit series Big Love a chance to learn more about our favorite polygamists before season one began. Rescue Me: Following the fire, Tommy learns his problems are far from over when he finds himself under investigation by the insurance company. This beautiful and engaging actress couldn't be more excited about her new role as the mysterious Jessi XX, a character designed to be the polar opposite of her counterpart, Kyle XY. This beautiful and engaging actress couldn't be more excited about her new role as the mysterious Jessi XX, a character designed to be the polar opposite of her counterpart, Kyle XY. Are the Sopranos in mortal danger? We will count on you to rally around the show, to recruit new viewers with the same grass-roots energy, intensity and volume you have displayed in recent weeks. At this time, I cannot tell you the specific date or time period that Jericho will return to our schedule. Season seven is still a few months away, but it looks as though Smallville is already off to another exciting year. " That behavior would be the whole Isaiahgate scandal that began with a fight on the set with Patrick Dempsey in October and continuing after the Golden Globes in January. Washington's publicist Howard Bragman told TMZ that the actor received word from Shonda Rhimes that he has been fired due to what was described as a "pattern of problematic behavior. HBO is now offering fans of the hit series Big Love a chance to learn more about our favorite polygamists before season one began. I wonder if Washington's firing had anything to do with Knight's new contract? Let's hope he fairs better than the recently jailed Paris Hilton. Rescue Me: Following the fire, Tommy learns his problems are far from over when he finds himself under investigation by the insurance company.

1 0

[MonetDB-users] newbie question, Debian install, can't connect
by Matt Stucky 12 Jun '07

12 Jun '07

downloaded the super tarball, installed from the top-level shell script, all seemed ok. mserver5 starts, io.print("test"); works as expected. but when I try to connect with mjclient i get: matt@debian5150:/root/MonetDB/bin$ ./mjclient -umonetdb -lsql password: Database connect failed: MALException:setScenario:Scenario 'sql' not initialized what am i doing wrong? thanks for the help in advance. matt ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ The Preacher Said: "Oh Lord, without you we are but dust!" And the Child Said: "What's butt dust?" ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ AOL & Yahoo IM: stuckym44 MSN Messenger: stuckym4 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

3 3

[MonetDB-users] Fwd: MonetDB Error
by Venks 08 Jun '07

08 Jun '07

Niels/Fabian/Romulo, Thanks for all your replies. I rebooted the server and was able to bring up the database again. Next time, if this happens I will try to remove the locks. I tried to remove the file ".gdk_lock" but Linux wouldn't allow me to remove it. Meanwhile, let me do more tests and see why this is becoming an issue. If necessary as Niels suggested I will open a bug as the query actually crashed the server instead of just returning an error. Niels, Though I am joining all these tables, I have WHERE conditions on each table and the end result is actually 16,384 rows. I will do some more testing by changing the syntax of the query and see if it helps. Forwarded Conversation Subject: MonetDB Error ------------------------ From: Venks <venkatesh.mantha(a)gmail.com> To: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:12 AM I got the following error while trying to run a query joining 10 tables. These tables are all 2 or 3 column tables but do have on an average 10M rows in each table. =================== lin5 kernel: journal_get_undo_access: No memory for committed data mserver5: /scratch/monet.GNU.64.64.d.5883/MonetDB5/src/optimizer/opt_joinpath.mx:227: ALGjoinPath: Assertion `b' failed. ./startmonet.sh: line 2: 9488 Aborted $MONETDB5_PREFIX/bin/mserver5 --dbname=csdb --dbinit='include sql;' ====================== After the above error, I am unable to start the MonetDB database. I get the following error. !FATAL: GDKlockHome: Database lock '.gdk_lock' denied How can I re-start the server? Thanks, - Venks -------- From: Romulo Goncalves <R.A.Goncalves(a)cwi.nl> To: Venks <venkatesh.mantha(a)gmail.com> Cc: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:19 AM [Quoted text hidden]You need to remove your dbfarm and dblogs. Just do rm -fr $MONETDB5_PREFIX/var/* Regards, Romulo > > > How can I re-start the server? > > Thanks, > > - Venks > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > MonetDB-users mailing list > MonetDB-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users -------- From: Venks <venkatesh.mantha(a)gmail.com> To: Romulo Goncalves <R.A.Goncalves(a)cwi.nl> Cc: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:27 AM If I remove /var/* that will wipe-out my entire database. Correct? [Quoted text hidden] -------- From: Romulo Goncalves <R.A.Goncalves(a)cwi.nl> To: Venks <venkatesh.mantha(a)gmail.com> Cc: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:30 AM Venks wrote: > If I remove /var/* that will wipe-out my entire database. Correct? Yes. Regards, Romulo [Quoted text hidden] -------- From: Venks <venkatesh.mantha(a)gmail.com> To: Romulo Goncalves <R.A.Goncalves(a)cwi.nl> Cc: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:31 AM Is there any way I can restart MonetDB without loosing all my data? [Quoted text hidden] -------- From: Niels Nes <Niels.Nes(a)cwi.nl> To: Venks <venkatesh.mantha(a)gmail.com> Date: Fri, Jun 8, 2007 at 9:34 AM On Fri, Jun 08, 2007 at 09:12:50AM -0400, Venks wrote: > I got the following error while trying to run a query joining 10 > tables. These tables are all 2 or 3 column tables but do have on an > average 10M rows in each table. > > =================== > > lin5 kernel: journal_get_undo_access: No memory for committed data This kernel message seems to indicate that monet run out of memory. 10M^10 is really big, so unless you had a very selective join condition this will blow up to extreme big tables. > mserver5: /scratch/monet.GNU.64.64.d.5883/MonetDB5/src/optimizer/opt_joinpath.mx:227: > ALGjoinPath: Assertion `b' failed. > ./startmonet.sh: line 2: 9488 Aborted Afcourse a crash shouldn't happen. > $MONETDB5_PREFIX/bin/mserver5 --dbname=csdb --dbinit='include sql;' > > ====================== > > After the above error, I am unable to start the MonetDB database. I > get the following error. and after restarting it should normally work even with a crash. So these are bugs, could you report them. Together with a script or so which triggers it? Many thanks.. Niels > > > !FATAL: GDKlockHome: Database lock '.gdk_lock' denied > > > How can I re-start the server? > > Thanks, > > - Venks > [Quoted text hidden]-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes(a)cwi.nl -------- From: Romulo Goncalves <R.A.Goncalves(a)cwi.nl> To: Venks <venkatesh.mantha(a)gmail.com> Cc: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:35 AM Venks wrote: > Is there any way I can restart MonetDB without loosing all my data? Of course. Just kill your server and start it again.. [goncalve@amelia Triggers]$ ps aux | grep mserver goncalve 27450 1.8 4.8 338904 99192 pts/0 Sl+ 15:34 0:00 mserver5 goncalve 27484 0.0 0.0 60240 708 pts/2 R+ 15:34 0:00 grep mserver [goncalve@amelia Triggers]$ kill -9 27450 [goncalve@amelia Triggers]$ ps aux | grep mserver goncalve 27491 0.0 0.0 60244 708 pts/2 S+ 15:34 0:00 grep mserver [goncalve@amelia Triggers]$ [Quoted text hidden] -------- From: Fabian Groffen <Fabian.Groffen(a)cwi.nl> Reply-To: monetdb-users(a)lists.sourceforge.net, monetdb-users(a)lists.sourceforge.net To: monetdb-users(a)lists.sourceforge.net Date: Fri, Jun 8, 2007 at 9:36 AM On 08-06-2007 09:31:45 -0400, Venks wrote: > Is there any way I can restart MonetDB without loosing all my data? Make sure there are no running mservers any more. If there still are, kill 'em all. Find the .gdk_lock file in your var/monetdb/... and remove it. Try to start MonetDB. (Preferably without the script so you can see what happens.) If it fails to load the BATs, the database has been corrupted. [Quoted text hidden] -------- From: Niels Nes <Niels.Nes(a)cwi.nl> To: Venks <venkatesh.mantha(a)gmail.com> Date: Fri, Jun 8, 2007 at 9:36 AM On Fri, Jun 08, 2007 at 09:31:45AM -0400, Venks wrote: > Is there any way I can restart MonetDB without loosing all my data? > > > >> > > > >> > After the above error, I am unable to start the MonetDB database. I > > >> > get the following error. > > >> > > > >> > > > >> > !FATAL: GDKlockHome: Database lock '.gdk_lock' denied If the lock is the only problem you could simply remove this, ie do a find $prefix/var/ -name .gdk_lock | xargs rm -f This will remove all gdk_lock files, so be sure there are no running Mserver/mserver5s. niels > > >> You need to remove your dbfarm and dblogs. > > >> > > >> Just do > > >> rm -fr $MONETDB5_PREFIX/var/* > > >> > > >> Regards, > > >> Romulo > > >> > > > >> > > > >> > How can I re-start the server? > > >> > > > >> > Thanks, > > >> > > > >> > - Venks > > >> > > > >> > > > >> ------------------------------------------------------------------------- > > >> > This SF.net email is sponsored by DB2 Express > > >> > Download DB2 Express C - the FREE version of DB2 express and take > > >> > control of your XML. No limits. Just data. Click to get it now. > > >> > http://sourceforge.net/powerbar/db2/ > > >> > _______________________________________________ > > >> > MonetDB-users mailing list > > >> > MonetDB-users(a)lists.sourceforge.net > > >> > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > >> > > >> > > > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > MonetDB-users mailing list > MonetDB-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users [Quoted text hidden] --------

1 0

[MonetDB-users] MonetDB Error
by Venks 08 Jun '07

08 Jun '07

I got the following error while trying to run a query joining 10 tables. These tables are all 2 or 3 column tables but do have on an average 10M rows in each table. =================== lin5 kernel: journal_get_undo_access: No memory for committed data mserver5: /scratch/monet.GNU.64.64.d.5883/MonetDB5/src/optimizer/opt_joinpath.mx:227: ALGjoinPath: Assertion `b' failed. ./startmonet.sh: line 2: 9488 Aborted $MONETDB5_PREFIX/bin/mserver5 --dbname=csdb --dbinit='include sql;' ====================== After the above error, I am unable to start the MonetDB database. I get the following error. !FATAL: GDKlockHome: Database lock '.gdk_lock' denied How can I re-start the server? Thanks, - Venks

3 6

[MonetDB-users] Error during making buildtools (branch MonetDB_1-18)
by Ying Zhang 06 Jun '07

06 Jun '07

Hi all, I have just checked out the release branch and try to rebuild everything from scratch (on andorea). Making buildtools gives the following error: Making install in conf make[1]: Entering directory `/export/scratch1/zhang/monet/stable/buildtools/build-debug/conf' make[1]: *** No rule to make target `buildtools-config', needed by `all-am'. Stop. make[1]: Leaving directory `/export/scratch1/zhang/monet/stable/buildtools/build-debug/conf' make: *** [install-recursive] Error 1 Does anyone have an idea about this? I believe that building environment is clean. Thanks! Jennie

2 1

[MonetDB-users] building monetdb5 on windows
by Colin Foss 05 Jun '07

05 Jun '07

Are there any plans to create a script similar to monetdb-install.sh for Windows?

2 1

[MonetDB-users] XRPC problem: too many parameters
by Makoto YUI 02 Jun '07

02 Jun '07

Hi, I caught an error (see attached file) at the remote method invocation of XRPC. While I'm not sure whether my query is correct or not, is there imitation of parameters in XRPC? The query and dataset used in the evaluation are put on here. http://db-www.naist.jp/~makoto-y/tmp/xrpc.tgz Thanks, Makoto YUI P.S. To: list-admin please ignore previous mail from wrong address MAPI = monetdb@localhost:50000 QUERY = import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit ERROR = !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. MAPI = monetdb@localhost:50000 QUERY = import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit ERROR = !ERROR: doLoopLiftedRPC: execution failed at all destinations mapi_query_part:1705:import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit where $hit/Hit_num = 1 and $hit/Hit_hsps/Hsp/Hsp_evalue/text() <= 1.0e-8 return $e), $uniprot_entry := (for $e in $blast-uniprot/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit where $hit/Hit_num = 1 and $hit/Hit_hsps/Hsp/Hsp_evalue/text() <= 1.0e-8 return $e) where $gb_entry/BlastOutput_query-def/text() = $uniprot_entry/BlastOutput_query-def/text() return <result> { let $gb-hit := $gb_entry/BlastOutput_iterations/Iteration/Iteration_hits/Hit, $gb-key := $gb-hit/Hit_gb/text() return let $genbank-remote-entries := execute at {$remote-endpoint} { test:q1($gb-key) } for $remote_entry at $pos in $genbank-remote-entries let $gb_definition := $remote_entry/INSDSeq_definition, $gb_feature := $remote_entry/INSDSeq_feature-table/INSDFeature, $blast_evalue := $gb-hit[Hit_gb/text() = $remote_entry/INSDSeq_accession-version/text()]/Hit_hsps/Hsp/Hsp_evalue return <genbank num="{ $pos }">{ $blast_evalue, $gb_definition, $gb_feature } </genbank> } </result> fetch next block: start at:2 got next block: length:269 text:XRPC_Client_Serialisation: 626 microsec !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations got complete block: text:XRPC_Client_Serialisation: 626 microsec !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:XRPC_Client_Serialisation: 626 microsec allocating new result set XRPC_Client_Serialisation: 626 microsec got complete block: text:!WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" allocating new result set got complete block: text:!ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: CMDhttp_post: too many parameters. got complete block: text:!ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: CMDhttp_post: operation failed. got complete block: text: !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line: closing result set got complete block: text:!ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: doLoopLiftedRPC: execution failed at all destinations allocating new result set fetch next block: start at:271 got next block: length:0 text: got complete block: text: read_line: closing result set closing result set Timer 1014.527 msec

3 6

[MonetDB-users] Data Load Issue
by Venks 01 Jun '07

01 Jun '07

Hi, I am trying to load a 12.8 Million row table using COPY command. The table has about 256 columns. After 4 or 5 hours of running, the server terminated abruptly. I am running this on a AMD 64 Bit running Redhat Linux with 3GB of memory and lots of swap space. Any help in identifying the issue would be appreciated. Thanks, - Venks

2 1

Re: [MonetDB-users] Autoconf error for /MonetDB4-XQuery/pathfinder module
by Fabian Groffen 30 May '07

30 May '07

On 30-05-2007 13:28:39 +0200, Ingmar Weber wrote: >> What filesystem are you running stuff on? Do you build in your sources? >> Is your clock set correctly? Do you use NFS by chance? > > Yes, I'm building things on an NFS filesystem. I'm building everything from > the tarball that's downloadable. I get the same error message independent > of running the monetdb-install.sh (or something like this) or by running > configure/make/make install by hand. > > The system clock seems to be working fine as far as I can tell. At least > I've never had problems with it (or when using SVN or CVS). > > Is NFS a known source of trouble? Then I could try installing it again on a > local hard drive. If the clock of the NFS server is out of sync with your local clock, make can get confused. Try building on local (/var/tmp?) disk space to avoid this. I hope that solves it. Also, if you copy the sources, make sure you preserve the mtimes of the original, e.g. by using cp -pPR or rsync -a.

1 0

Re: [MonetDB-users] Autoconf error for /MonetDB4-XQuery/pathfinder module
by Fabian Groffen 30 May '07

30 May '07

On 30-05-2007 12:07:26 +0200, Ingmar Weber wrote: > > This looks very much like a problem with perl on your machine. > > Quite possibly. Any detailed suggestions? I'm just not quite sure, what > exactly is wrong and how I could fix it. (e.g. by somehow telling MonetDB > to look for Perl related things there rather than there etc.) I'm not familiar with Debian and Perl, but I think something is just looking at a wrong architecture or in another place than it reports. > The output is this: > /amd64/usr/lib/perl/5.8/auto/Data/Dumper/Dumper.so: ELF 64-bit LSB shared > object, AMD x86-64, version 1 (SYSV), stripped Looks normal to me. > > Apart from this issue, it appears strange to me that autoconf/automake > are being used. > > Well, strictly speaking the error is caused by this line in the (generated) > Makefile: > cd . && /bin/sh > /local/var/tmp/MonetDB-1180453562/MonetDB4-XQuery/pathfinder/conf/missing > --run autoconf It shouldn't do this, IMO. Running autoconf should only be done if configure has to be regenerated, which it does not have to. > But this script (.../conf/missing --run autoconf) behaves exactly like > autoconf. The error message is the same, independent of whether I run the > Makefile or type autconf by hand. What filesystem are you running stuff on? Do you build in your sources? Is your clock set correctly? Do you use NFS by chance?

1 0

[MonetDB-users] Autoconf error for /MonetDB4-XQuery/pathfinder module
by Ingmar Weber 30 May '07

30 May '07

Hey, When I try to install monetdb (either using the monetdb-install.sh script or the configure/make/make install mechanism in each directory) I get the following error for the MonetDB4-XQuery module: ----- this error occurs at the beginning of the 'make', caused by automake ---- Can't load '/amd64/usr/lib/perl/5.8/auto/Data/Dumper/Dumper.so' for module Data::Dumper: /amd64/usr/lib/perl/5.8/auto/Data/Dumper/Dumper.so: cannot open shared object file: No such file or directory at /amd64/usr/lib/perl/5.8/XSLoader.pm line 68. at /amd64/usr/lib/perl/5.8/Data/Dumper.pm line 27 Compilation failed in require at /usr/share/autoconf/Autom4te/C4che.pm line 35. BEGIN failed--compilation aborted at /usr/share/autoconf/Autom4te/C4che.pm line 35. Compilation failed in require at /usr/bin/autom4te line 39. BEGIN failed--compilation aborted at /usr/bin/autom4te line 39. ---------------- Note that the /amd64/usr/lib/perl/5.8/* files all exist in the places named above! Still, it generates the "No such file or directory". --------------------------------- Line 68 (and surroundings) of XSLoader.pm reads as: # Many dynamic extension loading problems will appear to come from # this section of code: XYZ failed at line 123 of DynaLoader.pm. # Often these errors are actually occurring in the initialisation # C code of the extension XS file. Perl reports the error as being # in this perl code simply because this was the last perl code # it executed. my $libref = dl_load_file($file, 0) or do { require Carp; Carp::croak("Can't load '$file' for module $module: " . dl_error()); }; push(@dl_librefs,$libref); # record loaded object --------------------------------- --------------------------------- Line 27 of Dumper.pm reads as: XSLoader::load 'Data::Dumper'; --------------------------------- The error above I also get when I simply type "automake". I currently suspect some 32 bit vs. 64 bit problem, as the machine I'm compiling things on (2x Dual-Core AMD Opteron Processor 2220 SE) can run in either 32 or 64 bit mode. uname outputs: "2.6.16.29.2.amd64-smp" Any (other) ideas? Should I post some other debug information? The output of "configure" is posted below. The other packages of (Monet DB Common etc.) run through smoothly. THANKS! Ingmar ------------- output of "configure" for MonetDB4-XQuery/pathfinder ----- iweber@dork:/scratch/KM/ir-scratch/ingmar/MonetDB-SuperBall/MonetDB-Venus-SuperBall-SR1/MonetDB4-XQuery/pathfinder [10083] ./configure --prefix='/scratch/KM/ir-scratch/ingmar/MonetDB-SuperBall/installation/' --enable-optimize --disable-debug --with-libxml2=/amd64/usr checking build system type... x86_64-unknown-linux-gnu checking host system type... x86_64-unknown-linux-gnu checking target system type... x86_64-unknown-linux-gnu checking for a BSD-compatible install... /amd64/usr/bin//install -c checking whether build environment is sane... yes checking for gawk... /usr/bin/gawk checking whether make sets $(MAKE)... yes checking for monetdb-config... /scratch/KM/ir-scratch/ingmar/MonetDB-SuperBall/installation/bin/monetdb-config checking whether MonetDB Common version 1.16.2 or newer is installed... yes: found version 1.16.2 checking for style of include used by make... GNU checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ANSI C... none needed checking dependency style of gcc... none checking for egrep... grep -E checking for ANSI C header files... no checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking how to run the C preprocessor... gcc -E checking for gcc... (cached) gcc checking whether we are using the GNU C compiler... (cached) yes checking whether gcc accepts -g... (cached) yes checking for gcc option to accept ANSI C... (cached) none needed checking dependency style of gcc... (cached) none checking for long... yes checking size of long... 8 checking whether byte ordering is bigendian... no checking which Linux distribution we're using... Debian3.1 checking if your compiler is C99 compliant... yes checking for ant... no checking for java... no checking for javac... no checking for jar... no checking for javadoc... no checking for monetdb4-config... /scratch/KM/ir-scratch/ingmar/MonetDB-SuperBall/installation/bin/monetdb4-config checking whether MonetDB4 version 4.16.2 or newer is installed... yes: found version 4.16.2 checking for monetdb-clients-config... /scratch/KM/ir-scratch/ingmar/MonetDB-SuperBall/installation/bin/monetdb-clients-config checking whether MonetDB Clients version 1.16.2 or newer is installed... yes: found version 1.16.2 checking for a sed that does not truncate output... /amd64/bin//sed checking for option to reload object files... -r checking for BSD-compatible nm... /amd64/usr/bin//nm -B checking whether ln -s works... yes checking how to recognise dependent libraries... pass_all checking dlfcn.h usability... yes checking dlfcn.h presence... yes checking for dlfcn.h... yes checking for g++... g++ checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking dependency style of g++... none checking how to run the C++ preprocessor... g++ -E checking for g77... no checking for f77... no checking for xlf... no checking for frt... no checking for pgf77... no checking for fort77... no checking for fl32... no checking for af77... no checking for f90... no checking for xlf90... no checking for pgf90... no checking for epcf90... no checking for f95... no checking for fort... no checking for xlf95... no checking for ifc... no checking for efc... no checking for pgf95... no checking for lf95... no checking for gfortran... no checking whether we are using the GNU Fortran 77 compiler... no checking whether accepts -g... no checking for flex... no checking for lex... no checking for yywrap in -lfl... no checking for yywrap in -ll... no checking for a BSD-compatible install... /amd64/usr/bin//install -c checking for ld used by gcc... ld -IPA -m elf_x86_64 checking if the linker (ld -IPA -m elf_x86_64) is GNU ld... yes checking the maximum length of command line arguments... 32768 checking command to parse /amd64/usr/bin//nm -B output from gcc object... ok checking for objdir... .libs checking for ar... ar checking for ranlib... ranlib checking for strip... strip checking if gcc static flag works... yes checking if gcc supports -fno-rtti -fno-exceptions... no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc supports -c -o file.o... yes checking whether the gcc linker (ld -IPA -m elf_x86_64) supports shared libraries... yes checking whether -lc should be explicitly linked in... no checking dynamic linker characteristics... GNU/Linux ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... no configure: creating libtool appending configuration tag "CXX" to libtool checking for ld used by g++... ld -IPA -m elf_x86_64 checking if the linker (ld -IPA -m elf_x86_64) is GNU ld... yes checking whether the g++ linker (ld -IPA -m elf_x86_64) supports shared libraries... yes checking for g++ option to produce PIC... -fPIC checking if g++ PIC flag -fPIC works... yes checking if g++ supports -c -o file.o... yes checking whether the g++ linker (ld -IPA -m elf_x86_64) supports shared libraries... yes checking dynamic linker characteristics... GNU/Linux ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes appending configuration tag "F77" to libtool checking for ANSI C header files... (cached) no checking whether time.h and sys/time.h may both be included... yes checking for dirent.h that defines DIR... yes checking for library containing opendir... none required checking alloca.h usability... yes checking alloca.h presence... yes checking for alloca.h... yes checking getopt.h usability... yes checking getopt.h presence... yes checking for getopt.h... yes checking netdb.h usability... yes checking netdb.h presence... yes checking for netdb.h... yes checking for sys/types.h... (cached) yes checking for special C compiler options needed for large files... no checking for _FILE_OFFSET_BITS value needed for large files... no checking for _LARGE_FILES value needed for large files... no checking for an ANSI C-conforming const... yes checking for size_t... yes checking return type of signal handlers... void checking for ptrdiff_t... yes checking for ssize_t... yes checking for __int64... no checking for long long... yes checking for char... yes checking size of char... 1 checking for short... yes checking size of short... 2 checking for int... yes checking size of int... 4 checking for long... (cached) yes checking size of long... (cached) 8 checking for void *... yes checking size of void *... 8 checking for size_t... (cached) yes checking size of size_t... 8 checking for ssize_t... (cached) yes checking size of ssize_t... 8 checking for ptrdiff_t... (cached) yes checking size of ptrdiff_t... 8 checking for long long... (cached) yes checking size of long long... 8 checking for __int64... (cached) no checking size of __int64... 0 checking for ftruncate... yes checking for gettimeofday... yes checking for opendir... yes checking whether ln -s works... yes checking for rm... rm -f checking for mv... mv -f checking for lockfile... echo checking for bash... /bin/sh checking for rpmbuild... no checking for rpm... no checking for an ANSI C-conforming const... (cached) yes checking for inline... inline checking for python... no checking for perl... /amd64/usr/bin//perl checking for objc... no checking pthread.h usability... yes checking pthread.h presence... yes checking for pthread.h... yes checking semaphore.h usability... yes checking semaphore.h presence... yes checking for semaphore.h... yes checking sched.h usability... yes checking sched.h presence... yes checking for sched.h... yes checking for sem_init in -lpthreadGC2... no checking for sem_init in -lpthreadGC1... no checking for sem_init in -lpthreadGC... no checking for sem_init in -lpthread... yes checking for pthread_sigmask in -lpthread... yes checking for pthread_kill_other_threads_np in -lpthread... no checking readline/readline.h usability... yes checking readline/readline.h presence... yes checking for readline/readline.h... yes checking for readline in -lreadline... yes checking for rl_completion_matches in -lreadline... yes checking for SSL_read in -lssl... no checking for ERR_get_error in -lcrypto... no checking for dlopen in -ldl... yes checking for malloc in -lmalloc... no checking for mallopt... yes checking for mallinfo... yes checking for gethostbyname_r... yes checking for setsockopt... yes checking for SOCKET... no checking for socklen_t... yes checking for libz... auto checking for libbz2... auto checking for getopt_long... yes checking libperfctr.h usability... no checking libperfctr.h presence... no checking for libperfctr.h... no checking libpperf.h usability... no checking libpperf.h presence... no checking for libpperf.h... no checking pcl.h usability... no checking pcl.h presence... no checking for pcl.h... no checking for pcre-config... no pcre-config not found; please use --with-pcre=<path> checking for pcre >= 4.5... no (without pcre-config to query the pcre version, we assume it's < 4.5) checking regex.h usability... yes checking regex.h presence... yes checking for regex.h... yes checking locale.h usability... yes checking locale.h presence... yes checking for locale.h... yes checking langinfo.h usability... yes checking langinfo.h presence... yes checking for langinfo.h... yes checking for nl_langinfo... yes checking for setlocale... yes checking iconv.h usability... yes checking iconv.h presence... yes checking for iconv.h... yes checking for iconv_t... yes checking for iconv in -liconv... no checking for libiconv in -liconv... no checking for iconv... yes checking for texi2html... no checking for latex2html... no checking for latex... no checking for pdflatex... no checking for dvips... no checking for fig2dev... no checking postscript option... eps checking /amd64/usr/bin//install -c --backup option... --backup=nil checking for php-config... no Cannot find php-config. Please use --with-php-config=PATH no checking for monetdb5-config... no checking whether gcc and cc understand -c and -o together... yes checking for unistd.h... (cached) yes checking for getopt.h... (cached) yes checking for getopt_long... (cached) yes checking stdbool.h usability... yes checking stdbool.h presence... yes checking for stdbool.h... yes checking for bool... no checking for stdint.h... (cached) yes checking for socklen_t... (cached) yes checking libgen.h usability... yes checking libgen.h presence... yes checking for libgen.h... yes checking for basename... yes checking for int... (cached) yes checking size of int... (cached) 4 checking for void *... (cached) yes checking size of void *... (cached) 8 checking if your compiler understands `__attribute__'... yes checking signal.h usability... yes checking signal.h presence... yes checking for signal.h... yes checking return type of signal handlers... (cached) void checking for strings.h... (cached) yes checking for strcasecmp... yes checking for xml2-config.64... no checking for xml2-64-config... no checking for xml2-config... /amd64/usr/bin/xml2-config checking for libxml/parser.h... yes checking for xmlParseDocument in -lxml2... yes checking libxml/SAX2.h usability... yes checking libxml/SAX2.h presence... yes checking for libxml/SAX2.h... yes configure: The following compiler options will be used to integrate the libxml2 XML parsing library: To find the libxml2 include files: -I/usr/include/libxml2 To find the libxml2 library: -L/amd64/usr/lib64 -L/usr/lib -lxml2 -lz -lpthread -lm SAX2 support: HAVE_SAX2=1 checking for string.h... (cached) yes checking for strdup... yes checking for strtok_r... yes checking time.h usability... yes checking time.h presence... yes checking for time.h... yes checking sys/time.h usability... yes checking sys/time.h presence... yes checking for sys/time.h... yes checking utime.h usability... yes checking utime.h presence... yes checking for utime.h... yes checking sys/utime.h usability... no checking sys/utime.h presence... no checking for sys/utime.h... no checking sys/times.h usability... yes checking sys/times.h presence... yes checking for sys/times.h... yes checking whether time.h and sys/time.h may both be included... (cached) yes checking whether struct tm is in sys/time.h or time.h... time.h checking for struct tm.tm_zone... no checking for tzname... yes checking whether utime accepts a null argument... yes checking for ftime... yes checking for times... yes checking for ctime_r... yes checking for localtime_r... yes checking ctime_r3... no configure: creating ./config.status config.status: creating Makefile config.status: creating MonetDB-XQuery.spec config.status: creating RunMapprove config.status: creating RunMapprove.bat config.status: creating RunMtest config.status: creating RunMtest.bat config.status: creating extra.mk config.status: creating rpm.mk config.status: creating compiler/Makefile config.status: creating conf/Makefile config.status: creating modules/Makefile config.status: creating runtime/Makefile config.status: creating runtime5/Makefile config.status: creating src/Makefile config.status: creating compiler/algebra/Makefile config.status: creating compiler/core/Makefile config.status: creating compiler/debug/Makefile config.status: creating compiler/include/Makefile config.status: creating compiler/mem/Makefile config.status: creating compiler/mil/Makefile config.status: creating compiler/parser/Makefile config.status: creating compiler/schema/Makefile config.status: creating compiler/semantics/Makefile config.status: creating compiler/sql/Makefile config.status: creating modules/pftijah/Makefile config.status: creating runtime/xrpc/Makefile config.status: creating src/tools/Makefile config.status: creating compiler/algebra/map/Makefile config.status: creating compiler/algebra/opt/Makefile config.status: creating compiler/algebra/prop/Makefile config.status: creating runtime/xrpc/admin/Makefile config.status: creating runtime/xrpc/export/Makefile config.status: creating pf_config.h config.status: pf_config.h is unchanged config.status: executing depfiles commands

2 1

[MonetDB-users] MonetDB Release Preparation
by Martin Kersten 29 May '07

29 May '07

Dear fellow MonetDB developers/users, we plan to have a new release of the MonetDB software family within the next two weeks, i.e., Feature Freeze: Friday Jun 01 2007 Release: Monday Jun 11 2007 This release cycle is used to reduce the component dependencies, such that we are better prepared to release individual components more frequently. A synopsis of what to expect: MonetDB 5 beta status is dropped and it becomes the sole back-end for the SQL front-end. SQL now supports Persistent Stored Modules. XQuery Update Facility has undergone a large series of stress tests to improve correctness, performance and robustness against concurrent updates. Many bug-fixes based on highly appreciated feedback from our user community. The priorities set for post-release actions as agreed upon by the development team are: shortterm:(summer) SQL GIS geometry model testing and release SQL/XML support development and release PF/SQL exploration (research focus) Skyserver demo website (target 2.7TB online demo) midterm: (fall) Remote SQL execution in a cluster setting SQL adaptive partitioning of large databases XQuery Algebra -> MIL compiler Date/time support in XQuery MonetDB Private BATs policy (kernel modification) lngterm: (fall/spring) XQuery Algebra -> MAL compiler public release of StreetTivo for collaborative media analysis Of course, as always, progress in each of these areas depend on availability of resources and their contribution to our research agenda. We are looking forward to messages from projects based on/exploitation of the MonetDB platform. We plan to add a section in the website to make this work more broadly visible. regards, Martin

1 0

Re: [MonetDB-users] Compile problems (CVS, Ubuntu 7.04) (Java Client JDBC Version)
by Ramon Nogueira 27 May '07

27 May '07

OK, actually going to use CVS, since that's probably easier. Just a point about compiling the Java client (which as far as I can tell, is required for install MonetDB4-server): it doesn't compile with the version of JDBC shipped in Sun JDK 6. Basically, the JDBC interfaces have been extended and so we get errors about 'class is not abstract and does not override method ...'. I fixed this the first time by adding stubs that just threw OperationNotSupportedException. Then it compiled. R. On 5/27/07, Ramon Nogueira <ramon.nogueira(a)gmail.com> wrote: > Hehe, ok I can't resist. Gonna try again with the install script and > the tricks to prevent downloading again and again. I have clean all > traces of MonetDB from my machine. If you can't provide a .deb, what > about a precompiled set of binaries for generic Linux, statically > linked with all dependencies. Its not pretty, but it would be easy for > the users. The problem with the rpms on my Ubuntu system is basically > that Debian uses a different versioning scheme for the shared > libraries (the ones I had problems with were libssl and libcrypto). > Couldn't you just statically link these in and then provide a simple > install script? Many, many people use Debian-based systems and it > would greatly improve coverage for MonetDB. I will do what I can to > help if this compile goes well. > > R. > > On 5/26/07, Stefan Manegold <Stefan.Manegold(a)cwi.nl> wrote: > > Ramon, > > > > once you have time and bandwidth, could you please first remove any remains > > of MonetDB (sources, builddirs, anything installed in you chosen prefix of > > buildtools, MonetDB, clinerts, MonetDB4, pathfinder, etc.), > > and then try from scratch, again, the way you prefer to install MonetDB. > > Stop as soon as the first problem occurs (if any ;-)) and report it here. > > > > Unfortunaltely, we do not have (access to) any Debian and/or Ubuntu > > (anymore), hence, we cannot provide any .deb packages. > > > > Kind regards, > > > > Stefan > > > > > > On Sat, May 26, 2007 at 10:24:55AM +0200, Ramon Nogueira wrote: > > > Yup, first I tried installing from the "Super Source Tarball"; then > > > from `alien'ed rpm; then individual tarballs; the install script; then > > > CVS! The problem with the install script is that it downloads things > > > afresh each time and I really can't afford that (I am in South Africa > > > where unfortunately, we still need to think about bandwidth). Here is > > > the (different) error I get when I try to compile the pathfinder > > > source tarball from sourceforge (against CVS components): > > > > > > gcc -DHAVE_CONFIG_H -I. -I. -I.. -I. -I/usr/local/include/MonetDB > > > -I/usr/local/include/MonetDB/common -I/usr/local/include/MonetDB/gdk > > > -I/usr/local/include/MonetDB4 -I/usr/local/include/MonetDB4/monet > > > -I/usr/local/include/MonetDB4/plain > > > -I/usr/local/include/MonetDB4/contrib > > > -I/usr/local/include/MonetDB4/mapi > > > -I/usr/local/include/MonetDB4/calibrator -I/usr/include/libxml2 > > > -I../compiler/include -I./../compiler/include -DLIBPATHFINDER -O2 > > > -std=c99 -O6 -fomit-frame-pointer -finline-functions -falign-loops=4 > > > -falign-jumps=4 -falign-functions=4 -fexpensive-optimizations > > > -funroll-loops -frerun-cse-after-loop -frerun-loop-opt > > > -Wno-declaration-after-statement -DEMBEDDED -DMT -DNO_CGI -DNO_AUTH > > > -DIO_MAX=10240 -c pathfinder.c -fPIC -DPIC -o > > > .libs/lib_pathfinder_la-pathfinder.o > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx: > > > In function 'xquery_function_call': > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:3980: > > > error: expected ')' before 'LLFMT' > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5417:34: > > > error: macro "MT_init_lock" requires 2 arguments, but only 1 given > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx: > > > In function 'xquery_prelude': > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5417: > > > error: 'MT_init_lock' undeclared (first use in this function) > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5417: > > > error: (Each undeclared identifier is reported only once > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5417: > > > error: for each function it appears in.) > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5418:32: > > > error: macro "MT_init_lock" requires 2 arguments, but only 1 given > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5419:31: > > > error: macro "MT_init_lock" requires 2 arguments, but only 1 given > > > make[4]: *** [lib_pathfinder_la-pathfinder.lo] Error 1 > > > make[4]: Leaving directory > > > `/home/ramon/software/monetdb/pathfinder-0.16.2/runtime' > > > make[3]: *** [all-recursive] Error 1 > > > make[3]: Leaving directory > > > `/home/ramon/software/monetdb/pathfinder-0.16.2/runtime' > > > make[2]: *** [all] Error 2 > > > make[2]: Leaving directory > > > `/home/ramon/software/monetdb/pathfinder-0.16.2/runtime' > > > make[1]: *** [all-recursive] Error 1 > > > make[1]: Leaving directory `/home/ramon/software/monetdb/pathfinder-0.16.2' > > > make: *** [all] Error 2 > > > > > > > > > On 5/26/07, Stefan Manegold <Stefan.Manegold(a)cwi.nl> wrote: > > > > Hi Ramon, > > > > > > > > On Sat, May 26, 2007 at 08:37:26AM +0200, Ramon Nogueira wrote: > > > > > Thanks for such a rapid response! > > > > > > > > welcome --- you were just "lucky" ;-) > > > > > > > > > I checked out the source from CVS (including buildtools, I forgot to > > > > > mention that) with the following command: > > > > > cvs -d:pserver:anonymous@monetdb.cvs.sourceforge.net:/cvsroot/monetdb > > > > > checkout (buildtools|MonetDB|MonetDB4|pathfinder}. > > > > > > > > looks good (well, I'm sure you also included clients, as you mentioned in > > > > your first email). > > > > > > > > > I'm not too savvy wrt CVS, so not sure if this represents the latest code. > > > > > > > > It is --- well, provided SourceForge does not run the anonymous pserver > > > > access on backup server that run behind (again), but even then the > > > > conpilation should work fine ... > > > > > > > > > For calling configure, I did not specify any other command line > > > > > parameters (just ./configure). I created separate build directories > > > > > build/MonetDB, build/pathfinder... and issued the ./configure and make > > > > > commands in those directories after doing ./bootstrap in the source > > > > > directories. I also tries following the instructions in the file > > > > > pathfinder/INSTALL which instructed me to do the configure/make in the > > > > > same directory as the source with the same error. > > > > > > > > sounds just right --- hence, I'm puzzled; I have no idea, yet(?), what > > > > causes this problem (i.e., where the bogus path > > > > /export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/ > > > > come from... > > > > > > > > Do you by any chance have a previous source (CVS or tarball) or binary (RPM) > > > > installation of MonetDB on your machine? Possibly even the remains of an > > > > uncomplete/aborted/failed RPM installation? > > > > > > > > Stefan > > > > > > > > > > > > > On 5/26/07, Stefan Manegold <Stefan.Manegold(a)cwi.nl> wrote: > > > > > > Hi Ramon, > > > > > > > > > > > > thank you very much for using MonetDB, and sorry for the inconvenience with > > > > > > compiling pathfinder. > > > > > > > > > > > > The error looks indeed strange. Actually it make me wonder whether you > > > > > > indeed (try to) compile the CVS code base (and if so which one, the latest > > > > > > HEAD or some release branch?) or whether you are using the source tarballs? > > > > > > Of course, `bootstrap` is only required for the CVS version, but you do not > > > > > > mention buildtools, which is also required (only) for the CVS version. > > > > > > The requested but not found path > > > > > > (/export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/lib/libbat.la) > > > > > > is (as far as I can see) not contained in our CVS source base (except from > > > > > > some testing stable output), but *might* be in the source tarballs (though > > > > > > it should be ignored there. > > > > > > > > > > > > To analyse the problem further could you please send us the complete > > > > > > commandlines of you `configure` call for buildtools, MonetDB, clients, > > > > > > MonetDB4 & pathfinder? > > > > > > > > > > > > Kind regards > > > > > > > > > > > > Stefan > > > > > > > > > > > > > > > > > > On Sat, May 26, 2007 at 07:58:05AM +0200, Ramon Nogueira wrote: > > > > > > > Hi, > > > > > > > > > > > > > > Trying to install MonetDB4 and pathfinder from CVS. I succeeded in > > > > > > > compiling and installing (into /usr/local) MonetDB, client and > > > > > > > MonetDB4 modules. `bootstrap' and `configure' both succeed from > > > > > > > pathfinder, but `make' produces the following error. Also, on another > > > > > > > note, I think it should be made clearer that installation of `client' > > > > > > > is a prerequisite for MonetDB4 server since this is quite a > > > > > > > counterintuitive order of dependency (server on client). I am on Linux > > > > > > > 2.6.20-15-generic i686 GNU/Linux. > > > > > > > > > > > > > > Output from `make': > > > > > > > --------------------------------------------------------------------------- > > > > > > > (cd .libs && rm -f libpf.la && ln -s ../libpf.la libpf.la) > > > > > > > /bin/bash ../libtool --tag=CC --mode=link gcc -DLIBPF_SUPPORT -g > > > > > > > -O2 -Wall -Wextra -std=c99 -Werror-implicit-function-declaration > > > > > > > -Werror -Wpointer-arith -Wdeclaration-after-statement > > > > > > > -Wno-declaration-after-statement -DEMBEDDED -DMT -DNO_CGI -DNO_AUTH > > > > > > > -DIO_MAX=10240 -o lib_pf_support.la -rpath > > > > > > > /usr/local/lib/MonetDB4/lib lib_pf_support_la-pf_support.glue.lo > > > > > > > lib_pf_support_la-pf_support.lo lib_pf_support_la-staircasejoin.lo > > > > > > > lib_pf_support_la-prec_foll.lo lib_pf_support_la-shredder.lo > > > > > > > libserialize.la libpf.la -lxml2 -L/usr/lib -lxml2 -ldl > > > > > > > -L/usr/local/lib -lbat -lstream -L/usr/local/lib -lmonet -lpthread > > > > > > > -L/usr/local/lib/MonetDB4/lib -l_lock -l_monettime -l_streams > > > > > > > -l_builtin -l_ascii_io -l_algebra -l_constant > > > > > > > gcc -shared .libs/lib_pf_support_la-pf_support.glue.o > > > > > > > .libs/lib_pf_support_la-pf_support.o > > > > > > > .libs/lib_pf_support_la-staircasejoin.o > > > > > > > .libs/lib_pf_support_la-prec_foll.o .libs/lib_pf_support_la-shredder.o > > > > > > > -Wl,--whole-archive ./.libs/libserialize.a ./.libs/libpf.a > > > > > > > -Wl,--no-whole-archive -Wl,--rpath -Wl,/usr/local/lib/MonetDB4/lib > > > > > > > -Wl,--rpath -Wl,/usr/local/lib/MonetDB4/lib -L/usr/lib > > > > > > > /usr/lib/libxml2.so -ldl -L/usr/local/lib /usr/lib/libbat.so > > > > > > > /usr/lib/libstream.so /usr/lib/libmonet.so -lpthread > > > > > > > -L/usr/local/lib/MonetDB4/lib /usr/local/lib/MonetDB4/lib/lib_lock.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_monettime.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_streams.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_builtin.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_ascii_io.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_algebra.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_constant.so -Wl,-soname > > > > > > > -Wl,lib_pf_support.so.0 -o .libs/lib_pf_support.so.0.0.0 > > > > > > > (cd .libs && rm -f lib_pf_support.so.0 && ln -s > > > > > > > lib_pf_support.so.0.0.0 lib_pf_support.so.0) > > > > > > > (cd .libs && rm -f lib_pf_support.so && ln -s lib_pf_support.so.0.0.0 > > > > > > > lib_pf_support.so) > > > > > > > creating lib_pf_support.la > > > > > > > /bin/sed: can't read > > > > > > > /export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/lib/libbat.la: > > > > > > > No such file or directory > > > > > > > libtool: link: `/export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/lib/libbat.la' > > > > > > > is not a valid libtool archive > > > > > > > make[2]: *** [lib_pf_support.la] Error 1 > > > > > > > make[2]: *** Deleting file `lib_pf_support.la' > > > > > > > make[2]: Leaving directory `/home/ramon/software/monetdb/cvs/pathfinder/runtime' > > > > > > > make[1]: *** [all-recursive] Error 1 > > > > > > > make[1]: Leaving directory `/home/ramon/software/monetdb/cvs/pathfinder' > > > > > > > make: *** [all] Error 2 > > > > > > > > > > > > > > ----------------------------------------------------------------------------- > > > > > > > > > > > > > > Your help is greatly appreciated. > > > > > > > > > > > > > > Ramon Nogueira > > > > > > > > > > > > > > ------------------------------------------------------------------------- > > > > > > > This SF.net email is sponsored by DB2 Express > > > > > > > Download DB2 Express C - the FREE version of DB2 express and take > > > > > > > control of your XML. No limits. Just data. Click to get it now. > > > > > > > http://sourceforge.net/powerbar/db2/ > > > > > > > _______________________________________________ > > > > > > > MonetDB-users mailing list > > > > > > > MonetDB-users(a)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 | > > > > > > > > > > > > > > > > ------------------------------------------------------------------------- > > > > > This SF.net email is sponsored by DB2 Express > > > > > Download DB2 Express C - the FREE version of DB2 express and take > > > > > control of your XML. No limits. Just data. Click to get it now. > > > > > http://sourceforge.net/powerbar/db2/ > > > > > _______________________________________________ > > > > > MonetDB-users mailing list > > > > > MonetDB-users(a)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 | > > > > > > > > > > ------------------------------------------------------------------------- > > > This SF.net email is sponsored by DB2 Express > > > Download DB2 Express C - the FREE version of DB2 express and take > > > control of your XML. No limits. Just data. Click to get it now. > > > http://sourceforge.net/powerbar/db2/ > > > _______________________________________________ > > > MonetDB-users mailing list > > > MonetDB-users(a)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 | > > >

2 3

[MonetDB-users] Compile problems (CVS, Ubuntu 7.04)
by Ramon Nogueira 27 May '07

27 May '07

Hi, Trying to install MonetDB4 and pathfinder from CVS. I succeeded in compiling and installing (into /usr/local) MonetDB, client and MonetDB4 modules. `bootstrap' and `configure' both succeed from pathfinder, but `make' produces the following error. Also, on another note, I think it should be made clearer that installation of `client' is a prerequisite for MonetDB4 server since this is quite a counterintuitive order of dependency (server on client). I am on Linux 2.6.20-15-generic i686 GNU/Linux. Output from `make': --------------------------------------------------------------------------- (cd .libs && rm -f libpf.la && ln -s ../libpf.la libpf.la) /bin/bash ../libtool --tag=CC --mode=link gcc -DLIBPF_SUPPORT -g -O2 -Wall -Wextra -std=c99 -Werror-implicit-function-declaration -Werror -Wpointer-arith -Wdeclaration-after-statement -Wno-declaration-after-statement -DEMBEDDED -DMT -DNO_CGI -DNO_AUTH -DIO_MAX=10240 -o lib_pf_support.la -rpath /usr/local/lib/MonetDB4/lib lib_pf_support_la-pf_support.glue.lo lib_pf_support_la-pf_support.lo lib_pf_support_la-staircasejoin.lo lib_pf_support_la-prec_foll.lo lib_pf_support_la-shredder.lo libserialize.la libpf.la -lxml2 -L/usr/lib -lxml2 -ldl -L/usr/local/lib -lbat -lstream -L/usr/local/lib -lmonet -lpthread -L/usr/local/lib/MonetDB4/lib -l_lock -l_monettime -l_streams -l_builtin -l_ascii_io -l_algebra -l_constant gcc -shared .libs/lib_pf_support_la-pf_support.glue.o .libs/lib_pf_support_la-pf_support.o .libs/lib_pf_support_la-staircasejoin.o .libs/lib_pf_support_la-prec_foll.o .libs/lib_pf_support_la-shredder.o -Wl,--whole-archive ./.libs/libserialize.a ./.libs/libpf.a -Wl,--no-whole-archive -Wl,--rpath -Wl,/usr/local/lib/MonetDB4/lib -Wl,--rpath -Wl,/usr/local/lib/MonetDB4/lib -L/usr/lib /usr/lib/libxml2.so -ldl -L/usr/local/lib /usr/lib/libbat.so /usr/lib/libstream.so /usr/lib/libmonet.so -lpthread -L/usr/local/lib/MonetDB4/lib /usr/local/lib/MonetDB4/lib/lib_lock.so /usr/local/lib/MonetDB4/lib/lib_monettime.so /usr/local/lib/MonetDB4/lib/lib_streams.so /usr/local/lib/MonetDB4/lib/lib_builtin.so /usr/local/lib/MonetDB4/lib/lib_ascii_io.so /usr/local/lib/MonetDB4/lib/lib_algebra.so /usr/local/lib/MonetDB4/lib/lib_constant.so -Wl,-soname -Wl,lib_pf_support.so.0 -o .libs/lib_pf_support.so.0.0.0 (cd .libs && rm -f lib_pf_support.so.0 && ln -s lib_pf_support.so.0.0.0 lib_pf_support.so.0) (cd .libs && rm -f lib_pf_support.so && ln -s lib_pf_support.so.0.0.0 lib_pf_support.so) creating lib_pf_support.la /bin/sed: can't read /export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/lib/libbat.la: No such file or directory libtool: link: `/export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/lib/libbat.la' is not a valid libtool archive make[2]: *** [lib_pf_support.la] Error 1 make[2]: *** Deleting file `lib_pf_support.la' make[2]: Leaving directory `/home/ramon/software/monetdb/cvs/pathfinder/runtime' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/ramon/software/monetdb/cvs/pathfinder' make: *** [all] Error 2 ----------------------------------------------------------------------------- Your help is greatly appreciated. Ramon Nogueira

4 11

[MonetDB-users] MonetDB shows error after graceful stop
by Venks 25 May '07

25 May '07

Hi, I am using the following commands to START and STOP the MonetDB database. monetdb --start --dbname=test --dbinit='include sql;' monetbd --stop After I STOP the monetdb server I am getting the following messages in my console. Sometimes these messages repeat few times. ========================================================= /root/MonetDB070524/bin/mguardian: line 131: [: /dev/mapper/VolGroup00-LogVol00 43: integer expression expected /root/MonetDB070524/bin/mguardian: line 195: mserver5: command not found ========================================================== What are these messages? Do they represent an error in my set up? Or is this a some bug in MonetDB? Please look into it. Thanks, - Venks

3 2

[MonetDB-users] monetdb-install.sh not working
by Venks 25 May '07

25 May '07

Folks, I tried to executed the all-in-one script "monetdb-install.sh" and it's not working. I installed it last week few times without any error. Please look into this issue. Thanks, PS: Below is the excerpt from the log file. ======================================================= Connecting to www.ins.cwi.nl[192.16.196.21]:80... connected. HTTP request sent, awaiting response... Please refer to the full log at /var/tmp/MonetDB-1179870979/log If you believe this is an error in the script or the software, Tue May 22 17:56:20 EDT 2007 The following tools might be relevant to debug your problem: : 1.12 $ 403 Forbidden 17:56:20 ERROR 403: Forbidden. fetching http://www.ins.cwi.nl/~fabian/monetdb/tars/latest/current/MonetDB.tar.gz failed! file a bug and attach the logfile. autoconf (GNU Autoconf) 2.59 Written by David J. MacKenzie and Akim Demaille. =======================================================

6 10

Re: [MonetDB-users] Unable to connect to MonetDB
by Colin Foss 25 May '07

25 May '07

Venks, That is a good question and I didn't send the resolution to the general list. The strange behavior was that local connections were ok and remote connections would block all subsequent connections (local or remote) until I killed the remote MapiClient. I think there is something wrong with the "release" version when compiled from the script. After I used --nightly=stable or --nightly=current I was able to connect. I had mapi_open=true with all three versions. I was going to recompile with --nightly=current today, now that all is well again with www.ins.cwi.nl and I'll let you know my results. ~~>Colin --- Venks <venkatesh.mantha(a)gmail.com> wrote: > Colin, > > Was your issue regarding connecting from other > clients > (mapi_open=true) resolved? > > I installed the latest build this morning and now I > am unable to > connect from other clients. > > Thanks, > > - Venks >

1 0

[MonetDB-users] MonetDb-XQuery problem
by Maarten Clements 25 May '07

25 May '07

Using the following XQuery in MonetDb (WinXP) crashes on large documents (when C1 and C2 are small it works ok): > <col> { > for $b in doc("C1.xml")/collection/doc > for $top in doc("C2.xml")/collection/doc > where ($b/year > 1950) and ($b/title = $top/title) > return > <movie> > {$b/year} > </movie> > } </col> If I remove one of the two conditions it works perfectly, e.g.: > <col> { > for $b in doc("C1.xml")/collection/doc > for $top in doc("C2.xml")/collection/doc > where ($b/title = $top/title) > return > <movie> > {$b/year} > </movie> > } </col> Can anyone explain this problem? ______________________________ Maarten Clements

3 5

[MonetDB-users] copy into with primary key errors
by Colin Foss 24 May '07

24 May '07

I've been trying to bulk load a large set of data into a table with a compound primary key. Every time the copy into fails on the second file with an error about an "invalid input type". Even if I comment out the suspect file, the third file with have the same error. If I repeat the load and comment out the first file, then the third file will have the "invalid input type" error. Has anyone been able to use COPY INTO with a compound primary key and multiple files?

1 1

[MonetDB-users] Cannot connect to MonetDB via ODBC from PowerBuilder
by Franco Guidoli 24 May '07

24 May '07

Hi all: I'm trying to connect to MonetDB via ODBC from PowerBuilder, but during connection it gets into a "loop" (that's what I think after viewing the ODBC driver log which I'm sending now). Thanks in advance. Franco http://www.nabble.com/file/p10774553/odbcdebug.log odbcdebug.log -- View this message in context: http://www.nabble.com/Cannot-connect-to-MonetDB-via-ODBC-from-PowerBuilder-… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] latest build startup error
by Colin Foss 23 May '07

23 May '07

After building with "monetdb-install.sh --enable-sql", The default .mserver5.dbinit contains: include sql;sql.start(); the "sql.start();" command triggers an error found in mserver5.log in the dbfarm. == mserver5.log: START 2007-05-17 08:13:02 #include sql; sql.start(); # function user.main():void; # 0 (main:void) #command startQuery(s:str):void # 1 (_1:str) #address SQLstartQuery # 2 (_2:str) #comment "Initialize tracing query performance"; # 3 (_3:str) #command exitQuery(s:str):void # 4 (_4:str) #address SQLexitQuery # 5 (_5:str) #comment "Finalize tracing query performance"; # 6 (_6:str) #command dec_round( v:sht, r:dbl ) :sht # 7 (_7:str) #address sht_dbl_dec_round_wrap # 8 (_8:str) #comment "round off the value v to nearests multiple of r"; # 9 (_9:str) #command dec_round( v:sht, r:int ) :sht # 10 (_10:str) #address sht_int_dec_round_wrap # 11 (_11:str) #comment "round off the value v to nearests multiple of r"; # 12 (_9:str) #command dec_round( v:int, r:dbl ) :int # 13 (_12:str) #address int_dbl_dec_round_wrap # 14 (_13:str) #comment "round off the value v to nearests multiple of r"; # 15 (_9:str) #command dec_round( v:int, r:int ) :int # 16 (_14:str) #address int_int_dec_round_wrap # 17 (_15:str) #comment "round off the value v to nearests multiple of r"; # 18 (_9:str) #command dec_round( v:lng, r:dbl ) :lng # 19 (_16:str) #address lng_dbl_dec_round_wrap # 20 (_17:str) #comment "round off the value v to nearests multiple of r"; # 21 (_9:str) #command dec_round( v:lng, r:int ) :lng # 22 (_18:str) #address lng_int_dec_round_wrap # 23 (_19:str) #comment "round off the value v to nearests multiple of r"; # 24 (_9:str) #command dec_round( v:flt, r:int ) :flt # 25 (_20:str) #address flt_int_dec_round_wrap # 26 (_21:str) #comment "round off the value v to nearests multiple of r"; # 27 (_9:str) #command dec_round( v:dbl, r:int ) :dbl # 28 (_22:str) #address dbl_int_dec_round_wrap # 29 (_23:str) #comment "round off the value v to nearests multiple of r"; # 30 (_9:str) #address CALCstr2sht # 31 (_24:str) #command calc.str( v:sht ) :str # 32 (_25:str) #address CALCsht2str # 33 (_26:str) #comment "Cast sht to str"; # 34 (_27:str) #address CALCstr2int # 35 (_28:str) #command calc.str( v:int ) :str # 36 (_29:str) #address CALCint2str # 37 (_30:str) #comment "Cast int to str"; # 38 (_31:str) #address CALCstr2lng # 39 (_32:str) #command calc.str( v:lng ) :str # 40 (_33:str) #address CALClng2str # 41 (_34:str) #comment "Cast lng to str"; # 42 (_35:str) #command calc.str( v:any_1, digits:int ) :str # 43 (_36:str) #address CALCflt2sht # 44 (_37:str) #address CALCflt2int # 45 (_38:str) #address CALCflt2lng # 46 (_39:str) #address CALCdbl2sht # 47 (_40:str) #address CALCdbl2int # 48 (_41:str) #address CALCdbl2lng # 49 (_42:str) #address CALCsht2sht # 50 (_43:str) #address CALCint2sht # 51 (_44:str) #address CALClng2sht # 52 (_45:str) #address CALCsht2int # 53 (_46:str) #address CALCint2int # 54 (_47:str) #address CALClng2int # 55 (_48:str) #address CALCsht2lng # 56 (_49:str) #address CALCint2lng # 57 (_50:str) #address CALClng2lng # 58 (_51:str) #address CALCsht2flt # 59 (_52:str) #address CALCint2flt # 60 (_53:str) #address CALClng2flt # 61 (_54:str) #address CALCsht2dbl # 62 (_55:str) #address CALCint2dbl # 63 (_56:str) #address CALClng2dbl # 64 (_57:str) sql.prelude(); # 65 SQLprelude (_58:void) sql.start(); # 66 SQLsession (_59:void) end main; # 67 !syntax error, unexpected IDENT in: "include" I'm not sure if this is a bug in the monetdb script or mserver5 itself.

2 2

[MonetDB-users] website community links
by Colin Foss 22 May '07

22 May '07

I'd like to make a suggestion for the community webpage of http://monetdb.cwi.nl, please add a link to the sourceforge tracker (http://sourceforge.net/tracker/?group_id=56967)

2 1

[MonetDB-users] Creative Suite 3 Design ready to download
by Colby Sizemore 22 May '07

22 May '07

By treesor might see as the masonrySeems reflected in the infinite of the lamps.I might have happily lived some other childhood.and the numbed yards will go back undercover.From point to point of meaningopen? closed?Wind, sleet. The branches sway,But what I am looking at is hardened snow,they sit with their wives all day in the sun,At San Biagio, in the most intense roomGray the cloud-like oaksA frame of glided twilightIGiven by nature will soak into it.Again awaken from your being gone to findAs if your human shape were what the stormShe stretches a hand toward the toothy sleeperDim, and die tonight?Your gloved hands covering your lips' good-byeCoextensive with everything? How could they know?The flakes which have stolen onto the flagstones

1 0

[MonetDB-users] monetdb roadmap
by Colin Foss 21 May '07

21 May '07

Anyone have insight into when 2.18 will be released? http://monetdb.cwi.nl/projects/monetdb/Development/Roadmap/index.html

1 0

[MonetDB-users] other than to quit smoking.
by Odette Spears 21 May '07

21 May '07

GPSI Announces Market Attack Into $1 Trillion Market! Global Payment Solutions Symbol: GPSI Price: $0.03 GPSI announced its plans to address the huge influx of immigrant workers into the US that need banking solutions that they otherwise would not qualify for. This market is expected to represent over $1 Trillion dollars to be managed by 2008. GPSI provides viable solutions to this market. This is hot, read the news and watch for more Monday! Get on GPSI first thing Monday! The obvious step forward is to attempt to greatly extend healthy life spans in mice by preventing mitochondrial damage, repairing it as it occurs, or making it irrelevant. " Projects like this demonstrate that real progress has been made in stem cell basics. other than to quit smoking. The obvious step forward is to attempt to greatly extend healthy life spans in mice by preventing mitochondrial damage, repairing it as it occurs, or making it irrelevant. " Projects like this demonstrate that real progress has been made in stem cell basics. other than to quit smoking.

1 0

[MonetDB-users] Syntax in Query causes a Server Crash - Critical
by Venks 21 May '07

21 May '07

Hi, The following query has a syntax issue. But instead of reporting the syntax error, the server crashes. select count(*) from (select col2, count(*) as row_count from data_1to10 group by col2 order by row_count desc, col1) sq I have attached a PERL script which can be used to generate the required data for testing. I have also attached a table definition script and the load script. Please use the attached PERL script to generate the data as follows: ./massrecs.pl > <filename> You will need to edit the "test_load_tables.sql" script to update the filename according to the name given. Please let me know if you are unable to execute the test for any reason. Thanks, - Venkatesh

2 1

[MonetDB-users] M5 SQL load data with "copy into" behaviour and 32 bits limitation
by Franco Guidoli 20 May '07

20 May '07

Hi all: I'm testing MonetDB5 to know if it's suitable for an OLAP project. I have to load a bit more than 11.5 million rows into one table, and I get the following results (I'm working on a Windows 2000 Professional 32 bits box with 1GB RAM and Monet v5.0.0_beta1_2): - when I try to load all the data in a single "copy into", mserver crashes at a certain point. - when I try to load the data in 100K chunks with several "copy into" into the same sql session, the server crashes at 7.8 million rows, and when I try to load the rest of the data it gets loaded, but the first 7.8 million rows get corrupt and the rest get ok. - when I load the data in 100K chunks in 5 different times (2.6 million rows each time) everything gets ok; after every 2.6 million I disconnect from sql client and shutdown the server, so when I restart the server and connect from sql client all the logs get persistent (thanks to Niels Nes to explain simply that logs get persistent after a server restart and when a sql session starts). So, initially I thought that MonetDB couldn't load that amount of data in a 32 bits box, but after all it can, because at last the data was successfully loaded. Is there a limitation with the "copy into"? Is there a way to achieve this process without restarting the server and sql sessions? I've read some threads about 32 bits limitation, but I don't know for sure how to calculate the maximum rows I can have into a single table. In my case, the table has a 147 bytes length using the following sizes in data types: smallint --> 2 bytes int --> 4 bytes char(2) --> 2 bytes the limitation would be 2GB / 147 bytes --> 14.608.732 rows ? I've assumed this after what I've read, but please let me know if I'm doing a wrong calculation. Thanks in advance, Franco -- View this message in context: http://www.nabble.com/M5-SQL-load-data-with-%22copy-into%22-behaviour-and-3… Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

[MonetDB-users] latest build cannot connect from remote client
by Colin Foss 17 May '07

17 May '07

I installed MonetDB5 using monetdb-install.sh. I d/l'ed the script today. The binaries compiled fine but I am unable to connect from a different computer besides the host. i.e. mserver5 running on serverA, client running on desktopB. desktopB> MapiClient -l sql -h serverA -umonetdb MapiClient never returns. In another window I ran netstat and can see the connection from desktopB to serverA on the correct port (50000). Using 'telnet serverA 50000' I can see mserver5 responding with: 46:avuaOb0v:mserver:7:SHA1,MD5,crypt,plain:3412 Any ideas?

3 4

[MonetDB-users] Query Bug
by Venks 16 May '07

16 May '07

Hi, The following query works for the first time: WITH t AS ( SELECT * FROM tables ) SELECT * FROM t If I execute the query again, it gives the following error: Variable 't' allready declared If I change the alias from "t" to "t2" it works for the first time and then gives the error on second execution. Please look into this and correct this bug. Thanks, - Venkatesh

1 0

[MonetDB-users] GDK Error on a query joining non-key columns
by Venks 16 May '07

16 May '07

Hi, I get the following error: MALException:algebra.join:GDKerror ERROR: GDKload failed: name=02/45/24557, ext=buns.priv while executing the following query: select count(*) from ( select 1 from data_1to10 a, data_10to20 b where a.col2 = b.col2 ) sq I have attached a PERL script which is used to generate the required data for testing. I have also attached a table definition script and the load script. Please use the attached PERL script to generate the data as follows: ./massrecs.pl > <filename> After generating the first file, you will need to update the PERL script to change the numbers in the for loop, so that the next 20 million rows from 10,000,001 to 20,000,000 are generated. You will also need to edit the "test_load_tables.sql" script to update the filename according to the name given. Please let me know if you are unable to execute the test for any reason. Thanks, - Venkatesh

1 0

[MonetDB-users] XRPC problem: too many parameters
by Makoto YUI 16 May '07

16 May '07

Hi, I caught an error (see attached file) at the remote method invocation of XRPC. While I'm not sure whether my query is correct or not, is there imitation of parameters in XRPC? The query and dataset used in the evaluation are put on here. http://db-www.naist.jp/~makoto-y/tmp/xrpc.tgz Thanks, Makoto YUI MAPI = monetdb@localhost:50000 QUERY = import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit ERROR = !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. MAPI = monetdb@localhost:50000 QUERY = import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit ERROR = !ERROR: doLoopLiftedRPC: execution failed at all destinations mapi_query_part:1705:import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit where $hit/Hit_num = 1 and $hit/Hit_hsps/Hsp/Hsp_evalue/text() <= 1.0e-8 return $e), $uniprot_entry := (for $e in $blast-uniprot/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit where $hit/Hit_num = 1 and $hit/Hit_hsps/Hsp/Hsp_evalue/text() <= 1.0e-8 return $e) where $gb_entry/BlastOutput_query-def/text() = $uniprot_entry/BlastOutput_query-def/text() return <result> { let $gb-hit := $gb_entry/BlastOutput_iterations/Iteration/Iteration_hits/Hit, $gb-key := $gb-hit/Hit_gb/text() return let $genbank-remote-entries := execute at {$remote-endpoint} { test:q1($gb-key) } for $remote_entry at $pos in $genbank-remote-entries let $gb_definition := $remote_entry/INSDSeq_definition, $gb_feature := $remote_entry/INSDSeq_feature-table/INSDFeature, $blast_evalue := $gb-hit[Hit_gb/text() = $remote_entry/INSDSeq_accession-version/text()]/Hit_hsps/Hsp/Hsp_evalue return <genbank num="{ $pos }">{ $blast_evalue, $gb_definition, $gb_feature } </genbank> } </result> fetch next block: start at:2 got next block: length:269 text:XRPC_Client_Serialisation: 626 microsec !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations got complete block: text:XRPC_Client_Serialisation: 626 microsec !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:XRPC_Client_Serialisation: 626 microsec allocating new result set XRPC_Client_Serialisation: 626 microsec got complete block: text:!WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" allocating new result set got complete block: text:!ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: CMDhttp_post: too many parameters. got complete block: text:!ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: CMDhttp_post: operation failed. got complete block: text: !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line: closing result set got complete block: text:!ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: doLoopLiftedRPC: execution failed at all destinations allocating new result set fetch next block: start at:271 got next block: length:0 text: got complete block: text: read_line: closing result set closing result set Timer 1014.527 msec

1 0

[MonetDB-users] Persistent Stored Modules in MonetDB
by Venks 15 May '07

15 May '07

Is there any other documentation that I can get my hands on for understanding all the supported syntax for Persistent Stored Modules? The reference manual has nothing much and the examples as part of the MonetDB install are few. I am trying to find all the 4GL syntax that can be used while creating a persistent stored module. Thanks, - Venks

2 2

Re: [MonetDB-users] Cubulus OLAP tuning advice & first Monet benchmarks
by Martin Kersten 14 May '07

14 May '07

Would you be so kind to provide a "superball" ? MonetDB5-server in http://monetdb.cwi.nl/testing/projects/monetdb/Current/.DailyBuilds./ 0_latest/SourceTarBalls/ cannot be built on it's own.. In addition, on the Mac there is builtin readline (NetBSD: readline.h,v 1.11 2004/01/17) , and mclient does not use it. Headers: #include <readline/readline.h>, #include <readline/history.h> Libs: /usr/lib/libreadline.dylib Darwinports installed as dependency readline 5.0 : Headers: /opt/local/include/readline : chardefs.h history.h keymaps.h readline.h rlconf.h rlstdc.h rltypedefs.h tilde.h Libs: /opt/local/lib/libreadline.5.0.dylib /opt/local/lib/ libreadline.a /opt/local/lib/libreadline.5.dylib /opt/local/ lib/libreadline.dylib BR, Alex On May 13, 2007, at 9:21 PM, Martin Kersten wrote: > Hello, thanks to your report I was able to construct > a test case that uncovered an error in the decimal > conversion. I am not sure if this solves your > problem, but at least it avoids a series of errors. > > The problem occurred if you did not provide 4 decimal > digits. > > Added test decimal.SF-1718253 to BugTracker directory > > The updated version is in the head branch. > > Alexandru Toth wrote: >> Hello, >> Please advice on the rounding errors 73897488.0537 vs >> 74523898.6957. CREATE TABLE fact_cub ( >> figure decimal(10,4) DEFAULT NULL, >> dim_0 int DEFAULT NULL, >> dim_1 int DEFAULT NULL, >> dim_2 int DEFAULT NULL, >> dim_3 int DEFAULT NULL, >> dim_4 int DEFAULT NULL, >> dim_5 int DEFAULT NULL >> ) >> INSERT INTO fact_cub VALUES ('190.9420',4,49,39,17,3,2); >> INSERT INTO fact_cub VALUES ('998.9138',4,49,39,17,3,3); ...... >> As sanity check, the count(*) returns same number. >> sql>select count( figure ) from fact_cub where 4 <= dim_0 and >> dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and dim_1 >> <= 64; >> % sys.fact_cub # table_name >> % count_no_nil_figure # name >> % int # type >> % 6 # length >> [ 149406 ] >> Timer 1611.294 msec >> sql>select 0, sum( figure ) from fact_cub where 4 <= dim_0 and >> dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and dim_1 >> <= 64; >> % ., sys.fact_cub # table_name >> % single_value, sum_figure # name >> % smallint, decimal # type >> % 1, 12 # length >> [ 0, *73897488.0537 * ] >> Timer 1842.599 msec >> mysql> select count( figure ) from fact_cub where 4 <= dim_0 and >> dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and dim_1 >> <= 64; >> +-----------------+ >> | count( figure ) | >> +-----------------+ >> | 149406 | >> +-----------------+ >> 1 row in set (13.59 sec) >> mysql> select 0, sum( figure ) from fact_cub where 4 <= dim_0 and >> dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and dim_1 >> <= 64; >> +---+---------------+ >> | 0 | sum( figure ) | >> +---+---------------+ >> | 0 | *74523898.6957* | >> +---+---------------+ >> 1 row in set (7.45 sec) >> BR, Alexandru >> On May 13, 2007, at 4:26 PM, Martin Kersten wrote: >>> Alexandru Toth wrote: >>>> Hello, >>>> Replacing 2 comparisons with between is not necessarily faster >>>> in databases other than Monet. Proof (same 7 million rows table): >>> >>> We looked at the plans and noticed that indeed the optimizer missed >>> a point. It has been checked in the current trend. >>>> mysql> select 0, sum( figure ) from fact_cub where dim_0 between >>>> 4 and 15 and dim_4 = 2 and dim_5 = 2 and dim_1 between 57 and 64; >>>> +---+---------------+ >>>> | 0 | sum( figure ) | >>>> +---+---------------+ >>>> | 0 | 74523898.6957 | >>>> +---+---------------+ >>>> 1 row in set (13.14 sec) >>>> mysql> select 0, sum( figure ) from fact_cub where 4 <= dim_0 >>>> and dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and >>>> dim_1 <= 64; >>>> +---+---------------+ >>>> | 0 | sum( figure ) | >>>> +---+---------------+ >>>> | 0 | 74523898.6957 | >>>> +---+---------------+ >>>> 1 row in set (7.51 sec) >>>> Replacing 2 comparisons with one logic AND might be faster, but >>>> SQL is not as readable >>>> Cheers, Alexandru >

2 1

[MonetDB-users] you are the man
by Wilbur Hammer 13 May '07

13 May '07

students of all ages. I can see in the next generation how implies that companies will have greater flexibility in regards soldier in a white cravat turns a key to launch the counter is a process of creativity and satisfaction of discovering new exemplified in the global economic system: European Economic photography, has too much basis in reality. It is about the way avant-garde will continually rear its unusual head where it's reacting to feedback from their surroundings. The premise behind my language. We are always partaking in our society to one In theory, our voice boxes would become non functional in a few artificial life. Computer generated living beings live and their industry, replication is rampant, to a certain degree, and hallucinogenic narcotics available in the market. People will substitute for the drugs I've never done though overloads do Without this communication network we may be thrown back into the can still be accessed in the traditional way, it can hang on your And frighten myself with the thought of my little ones burning vital information on disk. Even in this class, so many people a fascist government will experience greater control and order by place in the world at a cost comparable to a postage stamp. any artificial intelligence is our resilience, damage caused to a drawing by hand.These quickly redrawn views however, only remain As an Interior Design student I have noted what computer programs effects is astounding. New methods and techniques arise daily as an attempt, no matter how noble or heroic, to secure our freedom. is the idea of general purpose simulation, and went on to explain maker and memory storer. The one great advantage we have over

1 0

[MonetDB-users] Embedded Server in Python on Windows XP
by Blackie Hlasek 13 May '07

13 May '07

I'm running Python 2.5 on Windows XP Pro SP2. I've successfully installed the windows binary distribution ( MonetDB5-SQL-2.16.2.msi). I've successfully run the Python example (on the website) which connects to the standalone server. How do I run monetdb as an embedded server? Any advice would be appreciated. Thanks! <monetdb-users(a)lists.sourceforge.net>

3 5

[MonetDB-users] medication for details Daphne
by Daphne Newell 13 May '07

13 May '07

enlargement and slow motion begin to reveal aspects and images of art. At the same time, I believe that computer scientists and advantages of convenience, however, may be in the future this very beneficial and advantageous. Researchers can congregate via The work place or learning institutions will become factories of start all over again. I realized that computers as another artist implies that companies will have greater flexibility in regards communication on the Internet will be very much like regular professional artists, etc. who come from different locations and him/her at many different levels. There needs to be an awareness something that is not actually a sensory input. It is more of a will be solved by linking into an information line through the computer takes over. It won't even be necessary to know how to different from traditional art or even independant computer great technological advancements and now we're at a threshold. Sending messages so easily and quickly will make writing letters with pens and rulers, now this can be done with the push of a few prerequisite implemented in our education system. That is until much more complex tool, allowing more options, innovative ideas, that will attract others. An example is the youth culture in program with such features as auto welding, kerning, arching store. Prior to entering this digital store, the size of ones prevalent. Children are using it at a younger age, starting in future occupations will all be replaced or affected by computers, Modernist attitude has had mainstream society pinning away for would gather at some spot on the street, sheltered by umbrellas, skills he possessed included were, airbrush techniques, gold

1 0

[MonetDB-users] there are 2 dosed in the pills you receive medication Dixie
by Dixie Edmonds 13 May '07

13 May '07

My chosen field is the arts. More specifically the graphic arts. man, who says, "Computers will never take over good old hard work springs to mind are the telephone operators. This is an entire important industry of the future. This industry will provide more and more people are experimenting with the plethora of burn our flag in contempt if Ronald Reagan were president? book in a library, may be even easier. There are databases However, the difference in capabilities between biological approaching one`s life are going on. The maker of the film, the dictator. With current and future information technology, type, just click the mouse Life in a screen! How exciting. I painter may not believe the brush tool of the paint program could Integration of the arts, which comprise of the theatrical, writing a program that will simulate these things, I'm not watching my grandfather reconstruct archaeological sites and avant-garde will continually rear its unusual head where it's the artists going to be affected? Currently, how have they been everything we construct is about. We are here, alive, so why not although far from perfect, especially in that it precludes a vast interesting; however, the finished work of art still depends on open our eyes to change. Although we are in a higher level of warning that virtual reality will create a nation of violent the Clinton administration, citizens will be able to voice their enlargement and slow motion begin to reveal aspects and images of the sign game, but it is destroying the people who built it. The personal ideas that the computer simply allowed me to envision on INTERNET, imagination will flourish as they try to grasp the

1 0

[MonetDB-users] MonetDB table/data size issue
by Venks 12 May '07

12 May '07

Hi, I have installed the latest version of MonetDB using the all-in-one script on a 64 Bit Linux (Redhat) with 4GB of memory. I created 3 tables containing 10Million rows each. The table definition is as follows: CREATE TABLE data_1mto10m ( id INTEGER, col1 INTEGER, col2 VARCHAR2(5) ) ; The above table definition applied to all remaining tables too. The first column "id" is the primary key which is nothing but a running serial number from 1 to 10,000,000. CREATE TABLE data_10mto20m ( ... CREATE TABLE data_20mto30m ( ... For the second table the "id" column starts from 10,000,001 and ends with 20,000,000. For the third table the "id" column starts from 20,000,0001 and ends with 30,000,000. The second and third column contains some randomly generated numbers. After that I am trying to create another table to include data from all the above as follows: 1. CREATE TABLE data_1mto30m AS SELECT * FROM data_1mto10m WITH DATA ; 2. INSERT INTO data_1mto30m SELECT * FROM data_10mto20m ; 3. INSERT INTO data_1mto30m SELECT * FROM data_20mto30m ; In shot, I am trying to create a 30 million row table by including all the data from the three 10 million row tables. After I complete the above steps and close the database, I am NOT able to re-open the database again. I get the following error: >mserver5: /scratch/monet.GNU.64.64.d.9712/MonetDB/src/gdk/gdk_utils.mx:1092: GDKfree: Assertion `size != 0' failed. I understand that MonetDB can handle huge tables running on a 64 bit system and would like to test the same. Please help me in resolving this issue. Thanks, - Venkatesh

1 1

[MonetDB-users] The worst of this is that the Times is making proclamations based on ideology, not science or facts, and their wire service is picked up by hundreds of papers across the country.
by Veronica Atkinson 07 May '07

07 May '07

The cream of the crop for 2007 - GET IN EARLY! DSDI IS SET TO ROCK YOUR PORTFOLIO! DSI Direct Sales, Inc. Symbol: DSDI Price: $0.05 There is a MASSIVE PROMOTION underway this weekend! This is hot, read the news and get on DSDI first thing Monday! Does it mean we should maximize short-term gains while sacrificing long-term opportunities? Which is just what American consumers or the beef industry does not need. Alternatively, publication of an abstract with a link to the originating source page to see the full text is generally allowed. He can also discuss global food-safety issues and the surveillance and reporting systems that are in place to protect California agriculture. ' Dissident Ranchers On Mad Cows: 'Do As I Say . First, it will result in a decline in consumer demand due to the loss of consumer confidence in the safety of beef. He was raised on a beef cattle ranch and still manages the family ranches. Yet his Vanity Fair piece offers not a shred of evidence that a mad-cow crisis is about to pounce. They may not get anything at all. Are we really that afraid of the Canadians? " Referring to the feed ban, "there is no conclusive scientific proof that it is the only route, and it is unknown what other routes of transmission may be available. Such expertise will not be evident at most major media outlets. The OIE has even stated that it does not recommend against importing beef from countries with a high BSE risk. Food and Drug Administration's advisory committee on BSE. " "Allowing the import of Canadian cattle into the U. "In June 2004, the USDA implemented this enhanced BSE testing program to provide further assurance that the risk for BSE in the U. They were absolutely not concerned about food safety. But now its time has passed, and we must begin to recognize what happened as a regulatory success story. These unintended consequences jeopardize our future and the future of the next generation of cattle ranchers. "APHIS began an enhanced surveillance program on June 1 and to date has tested over 121,000 samples for BSE. They are just samples from Cebull's nearly 30-page opinion full of such stuff and the suit filed by R-CALF has more. This year, the lab has performed approximately 15,000 screening tests for BSE. , like most nations, simply shut its border to infected countries. The American Meat Institute responded to the incident, reminding consumers that "beef is safe and consumers needn't worry about news of a new 'inconclusive' test result.

1 0

[MonetDB-users] MonetDB Install Developer All-in-one script
by Venks 04 May '07

04 May '07

http://monetdb.cwi.nl/projects/monetdb/Download/Builds/index.html Does anybody used this script to install MonetDB? I am trying to install the latest build and are encountering errors. Please find attached a "log" file from the run. PS: Please rename the file from "log.dat" to "log.zip" to UNZIP the actual " log.txt" file. Thanks, - Venks

4 13

[MonetDB-users] Vista OEM
by Goldie Mcelroy 01 May '07

01 May '07

1 0

[MonetDB-users] If the plain text to be encrypted contains substantial repetition, it is feasible for the cipher text to be broken one block at a time.
by cathy Kausler 29 Apr '07

29 Apr '07

ANLEGER UHR BJ5N.F!!! DIE RALLYE IST GESTARTET Firma: BOERSE INVEST BETEI WKN : 797639 ISIN : CH0012802093 Markt: Frankfurt K�rzel : BJ5N.F Preis: 1.90 5-Tag Prognose: 3.00 KAUFEN KAUFEN KAUFEN! BJ5N.F ESGESCHAFT FIN UNTER PARI!

1 0

[MonetDB-users] Now the balloons floated over his head.
by Danaka Pumberger 29 Apr '07

29 Apr '07

Specifies the volume, in hundredths of decibels. And it looked as if he was going to. For more information on Oracle products, refer to your Oracle documentation set. One was given away in a 'Spirit of the Age' competition, but as there was no maintenance agreement, it was never heard of again. Sample files, and others. Select the share for which you want to add FTP client access, and then choose Properties. Java Applet Marquee Wizard 10. The cache items with this priority level will not be deleted from the cache as the server frees system memory. Kirsch, and John W.

1 0

[MonetDB-users] ORDER BY Issue
by Venks 26 Apr '07

26 Apr '07

Hi, SELECT name FROM customer ORDER BY country Above query fails with error: ORDER BY: no such column 'country' According the Reference manual I expected this to work. Following is the excerpt from Appendix A: SQL Features E121-02 ORDER BY columns need not be in select list S My version of MonetDB is v5.0.0._beta1_2. Please let me know if this is expected behaviour or am I missing something. Thanks, - Venkatesh

1 0

[MonetDB-users] Memory Issues
by Venks 25 Apr '07

25 Apr '07

Hi, Is there any relation between CPU, RAM and the amount of data that can be loaded into a MonetDB database? I am trying to load 13.4 million rows of data and I am getting "Segmentation Fault" on a Linux box running on 32 bit CPU with 4GB RAM. I had similar issues on a Windows box too? Thanks, - Venkatesh

4 8

[MonetDB-users] OEM or Retail
by Gonzalo Avila 25 Apr '07

25 Apr '07

1 0

[MonetDB-users] Java Library in use
by Fabian Groffen 23 Apr '07

23 Apr '07

Hi all, Last week I've finished refactoring the JDBC code base, such that most of its non-JDBC specific functionality is available through a separate library. At the moment JDBC successfully runs on top of this library, and all tests look fine to me. The library can be found as the monetdb-1.0-mcl.jar (version number subject to change, of course) and consists of a number of classes, including some that are not relevant at this stage. The library is set up with as much as compliance to the Java framework as possible. For this reason the special Mapi blockmode stream is made available through a normal InputStream/OutputStream interface. On top of these streams, normal Readers/Writers can be created. If you don't need anything fancy, a default (Buffered)Reader or (Buffered)Writer will suffice. Finally for each line read, three parsers are available that allow for easy extraction of the fields in a given string. nl.cwi.monetdb.mcl.net.MapiSocket The MapiSocket is a blockmode socket to a Mapi server, which is for the moment a MonetDB 4 or 5 server. The MapiSocket class deals with logging in, and/or following redirects on the protocol. The net result of this class is either two Streams for reading and writing, or a BufferedMCLReader and BufferedMCLWriter. nl.cwi.monetdb.mcl.io.BufferedMCLReader nl.cwi.monetdb.mcl.io.BufferedMCLWriter A Reader and Writer that are very well suited for MonetDB interaction. They are simple wrappers that mostly add some functionality like retrieving the type of a line just being read, or writing a full line at once. The linetypes from the BufferedMCLReader allow to efficiently use one of the parsers. nl.cwi.monetdb.mcl.parser.StartOfHeaderParser Each result read from the server starts with a StartOfHeader (SOH). This SOH consists of a number of fields depending on its type. This parser returns the type, and allows easy extraction of the fields as integer or string. nl.cwi.monetdb.mcl.parser.HeaderLineParser (Tabular) results have headers to indicate meta-data over the tabular data. These headers can be easily accessed through the HeaderLineParser. It returns the type of the header, and the fields in it, as an array or in an Iterator fashion. nl.cwi.monetdb.mcl.parser.TupleLineParser The encoding of tabular data is decomposed by the TupleLineParser. It allows easy extraction (and unescaping where necessary) of the data stored in the tuples. With this framework it should be easy to e.g. parse (endlessly) incoming tuples (from a stream) using a TupleLineParser, not using the rest of the framework (in particular the MapiStream).

1 0

[MonetDB-users] Report for investors.
by jordi Hills 22 Apr '07

22 Apr '07

http://fileanchor.com/98633.gif Investors huge report! I've been keeping tabs on you for quite a while, it's been wasted time waiting.

1 0

[MonetDB-users] saw Coolquot quotcquot
by antti proctor 21 Apr '07

21 Apr '07

About me is murmur and hum, and I know it for the gnat- swarm of the living, piping for a little space its thin plaint of troubled air. AN ALLE FINANZINVESTOREN! DIESE AKTIE WIRD DURCHSTARTEN! FREITAG 20. APRIL STARTET DIE HAUSSE! REALISIERTER KURSGEWINN VON 400%+ IN 5 TAGEN! Symbol: G7Q.F Company: COUNTY LINE ENERGY 5 Tages Kursziel: 0.95 Schlusskurs: 0.21 WKN: A0J3B0 ISIN: US2224791077 Markt: Frankfurt LASSEN SIE SICH DIESE CHANCE NICHT ENTGEHEN! G7Q WIRD WIE EINE RAKETE DURCHSTARTEN! UNSERE ERWARTUNGEN WIRD G7Q.F UBERTREFFEN! Resets the property to the default value.

1 0

[MonetDB-users] XQuery performance and a Jdbc issue
by Tatu Lahtela 20 Apr '07

20 Apr '07

Hi, I just started investigating the usage of MonetDB with our relatively large XML document(s). It can go up to 1 million nodes in a tree type structure, like (simplified example) <item id="1" key="32"> <item id="2" key="34"/> <item id="3" key="32"> <item id="4" key="32"/> <item id="5" key="342"> <item id="6" key="32212" /> </item> </item> </item> <item id="7" key="2"> <item id="8" key="654"/> </item> </item> <item> ...... </item> ..... The key refers to a another document that contains the actual data (if all the items in the tree are unique it contains the same amount of nodes as the tree, but may be a lot less) , basically a flat list of the item data (name etc..). <data key="32"> <name>hello</name> <description>this is a test item</description> </data> <data key="342"> .... </data> The general issue is to get the tree location and key value from the tree. With a basic query like "//item[@id='33']" it takes about 3.5 seconds to get the item, and about as long to get the metadata from the other document. Using prepared queries had no effect (at least any improvement). The machine is a Intel(R) Xeon(TM) CPU 2.80GHz on Linux with 3Gb of memory. Is this level of performance expected or am I missing something essential? Another issue was when I tried to run a query through the JDBC driver. It dies with an exception (does it time out?): Exception in thread "main" java.lang.AssertionError: block 0 should have been fetched by now :( at nl.cwi.monetdb.jdbc.MonetConnection$ResultSetResponse.getLine( MonetConnection.java:1730) at nl.cwi.monetdb.jdbc.MonetResultSet.absolute(MonetResultSet.java :188) at nl.cwi.monetdb.jdbc.MonetResultSet.relative(MonetResultSet.java :2132) at nl.cwi.monetdb.jdbc.MonetResultSet.next(MonetResultSet.java:2099) at TestCache.monetDBTest(TestCache.java:99) at TestCache.main(TestCache.java:180) I tried to find an item with its description like "//data/description[contains(.,"test")]" The query runs around 5 seconds with the MapiClient. The MonetDB was downloaded and compiled yesterday (Monet Database Server V4.16.2). My XPath skills are less then admirable so all suggestions are appreciated. Cheers, -- Tatu Lahtela <lahtela(a)gmail.com>

1 0

[MonetDB-users] Persistent Stored Modules 'OR' operator
by Colin Foss 18 Apr '07

18 Apr '07

Is the OR operator supported in a persistent stored module? e.g. --------------------- create function tmp_myfunction(a integer) returns table (val integer) begin if a < 1 or a > 100 then return table ( select val from mytable ); else return table ( select val from another_table ); end if; end; --------------------- will return the error: ERROR = !SELECT: no such binary operator 'or(int,int)'

2 1

[MonetDB-users] ODBC
by Colin Foss 16 Apr '07

16 Apr '07

I have been trying to test ODBC with MonetDB with little success. JDBC and MapiClient are working. MS*Excel, R, and other utilities all fail while trying to initialize a connection via ODBC to MonetDB. Does anyone have a valid ODBC configuration to Monet?

4 11

[MonetDB-users] Copy command and CHAR field.
by Todd Gruben 06 Apr '07

06 Apr '07

what are valid characters that can go into the char fields? i am trying to migrate from mysql 4.1 and my data doesn't make it in. If i strip out some the the characters it makes it. The string is Cï¿½e dIvoire. which is the ivory coast. its a pain to clense, but i just wanted to know what a valid character is.

2 1

[MonetDB-users] SQL questions
by Colin Foss 05 Apr '07

05 Apr '07

1. How do you change a column's NULLable setting? I tried "alter table tmp_t alter column x set not null;" with no success. 2. How do you rename a table, short of "create table new_name like old_name;"? I tried "ALTER TABLE tmp_t RENAME TO tmp_t_new;" with no success.

1 0

[MonetDB-users] Yeah recommends
by Chaim Lonsberry 03 Apr '07

03 Apr '07

Byte PC World curtain shows http://img444.imageshack.us/my.php?image=bkqu5.gif tabs shown he

1 0

[MonetDB-users] [PF/Tijah] How to do a full text search?
by Sander Bockting 02 Apr '07

02 Apr '07

Dear all, We are trying to do a full text search in a database, but we can use some help to get started. A small excerpt from our database is stated below: //=== xquery>doc("ep") <?xml version="1.0" encoding="utf-8"?> <eprintsdata xmlns="http://eprints.org/ep2/data"> <record> <field name="eprintid">629</field> <field name="keywords">Model-based on-the-fly Testing, Timed Automata, Real-Time Testing, TorX, Tools.</field> <field name="research_projects">STRESS: Systematic Testing of Real-time Software Systems</field> </record> <record> <field name="eprintid">642</field> <field name="keywords">Compositional modelling, supervisory control</field> <field name="research_projects">HYBRIDGE: Distributed Control and Stochastic Analysis of Hybrid Systems Supporting Safety Critical Real-Time Systems Design</field> </record> </eprintsdata> //=== The PF/Tijah Getting Started page (http://dbappl.cs.utwente.nl/pftijah/Documentation/GettingStarted) mentions we can do a full text query as follows: let $c := collection("MyCollection") for $res in tijah:query($c, "//html[about(., ir db)]") return $res/head/title I believe this way is probably outdated, as tijah:query does not work. To suit our needs, I changed the query to the following form: //=== let $c := collection("ep") for $res in pf:tijah-query($c,"//field[@name='research_projects'][about(., Distributed)]") return $res //=== But this results in the following error: "ERROR = !ERROR: interpret: unknown variable 'collName'" That is why I incorporated the collection name in the query, like this: //=== for $res in pf:tijah-query(ep,"//field[@name='research_projects'][about(., Distributed)]") return $res //=== However, this also does not work, as I get the following error: "ERROR = !illegal reference to context node: at (1,29-1,30): ``.'' is unbound" I have tried numerous of other variations, but neither of them work. Can somebody please help us with an explanation about how we can do a full text search within a certain node or point us at a more recent getting started page (if it already exists)? Kind regards, Sander Bockting

2 2

[MonetDB-users] 承知していただけますか
by ==美佐代== 31 Mar '07

31 Mar '07

失礼します、美佐代です。お会いして月2回程度なのですけれど、承知していただけますか。理由はその時お話したいと思っています。まずは、お互いに信用できるまで少し話してみるのがいいと思います。 http://www.minamiego.com/rm1120 専用ルームに返信お待ちしています。寒くなりました、風邪などひかないよう体調には気を付けて下さいね。

1 0

[MonetDB-users] UNION with ORDER BY crash
by Colin Foss 30 Mar '07

30 Mar '07

I am running latest 4.x line on Windows 64bit. If I run the following SQL Mserver will die every time. ---------------------------------- create table tmp_one (data numeric(5)); create table tmp_two (data numeric(5)); /* this is ok */ select data from tmp_one union select data from tmp_two ; /* this will crash server */ select data from tmp_one union select data from tmp_two order by data ; ---------------------------------- Is "ORDER BY" supported with a UNION ?

2 2

[MonetDB-users] mjclient missing
by Shahbaz 27 Mar '07

27 Mar '07

I just installed MonetDB on my linux (Fedora Core 6) system with --enable-sql but mjclient doesn't seem to be in my MonetDB/bin directory (it was there when I installed it on my osx machine). I installed using --cvs=current. I have java installed and can confirm java and javac from the same command line where I issued the monetdb-install command. My install script's version is 1.9. Any ideas?

3 3

Re: [MonetDB-users] ERROR = !ERROR: add-doc((null)): document name must end in .xml
by Djoerd Hiemstra 26 Mar '07

26 Mar '07

Dear Peter, I do not understand your "consistency" argument. Surely, you can find some way to serve files with any name through http? Best, Djoerd. > On Sat, Mar 24, 2007 at 04:02:22PM +0100, Torsten Grust wrote: >> Hi all, >> >> while I appreciate the http access functionality for database >> documents, I do feel that this (rather strict) naming convention >> is unfortunate. There are a lot of XML files out there that use >> non-'.xml' endings ('.xhtml' and '.xsl' come to mind, immediately). >> >> >> Cheers, --Torsten >> >> On 3/24/07, p.a.boncz(a)chello.nl <p.a.boncz(a)chello.nl> wrote: >>> Hi, >>> >>> MonetDB/XQuery has an integrated HTTP server that treats GET (and >>> PUT,DELETE) requests for URLs that end in .xml or .XML in a >>> special way. >>> >>> Such files are not served from the http file directory >>> (datadir/xrpc/) but are taken to be requests for XML documents >>> stored in MonetDB/XQuery. >>> >>> Since the moment this feature was added, indeed the restriction >>> has been imposed that all documents in the database should have a >>> name ending in .xml This was done for consistency: now all >>> documents X in the database can be retrieved through HTTP (i.e. >>> http://yourserver:50001/X) >>> >>> If the restriction is not imposed, the HTTP access method will >>> not work anymore for all documents. >>> >>> Peter >>> >>> >>> ---- Stefan Manegold <Stefan.Manegold(a)cwi.nl> schreef: >>>> Peter, >>>> >>>> could you please have a look at this and comment? >>>> >>>> Thank you very much in advance! Stefan >>>> >>>> >>>> On Sat, Mar 24, 2007 at 02:02:27PM +0100, Stefan Manegold >>>> wrote: >>>>> Two tests fail (apparently unnoticed for some time) due to >>>>> the same problem; cf. >>>>> >>>>> http://monetdb.cwi.nl/testing/projects/monetdb/Current/pathfinder/.mTests10… >>>>> >>>>> http://monetdb.cwi.nl/testing/projects/monetdb/Current/pathfinder/.mTests10… >>>>> >>>>> >>>>> Stefan >>>>> >>>>> >>>>> On Fri, Mar 23, 2007 at 09:17:59AM +0100, Djoerd Hiemstra >>>>> wrote: >>>>>> Dear Martin, >>>>>> >>>>>> You are right, sorry, here is the English translation: >>>>>> Recently it is no longer possible to add logical names for >>>>>> XML documents that do not end with .xml, for instance >>>>>> >>>>>> let $site := "http://www.sigir2007.org/" let $pages := >>>>>> ("index.html", "cfp.html", "cfw.html") for $page in $pages >>>>>> return pf:add-doc(concat($site, $page), $page, "MySIGIR") >>>>>> >>>>>> gives: ERROR = !ERROR: add-doc((null)): document name must >>>>>> end in .xml (3 such errors)! >>>>>> >>>>>> In the previous version this was possible, and I use it for >>>>>> instance in a demo for one of our industrial partners in >>>>>> the MultimediaN project. Can this error please be removed? >>>>>> XML documents can have many extensions, for instance.rss, >>>>>> .xhtml, .svg, etc. I might want to add to the database: >>>>>> sigir.html (web page in xhtml) sigir.xml (source of the >>>>>> page) sigir.xsd (schema of the page) sigir.rss (RSS feed >>>>>> of the page) sigir.svg (page as a nice graphic) sigir.mml >>>>>> (mathematical formula of the page) etc, etc., >>>>>> >>>>>> I think the error is too restrictive. >>>>>> >>>>>> Best regards, Djoerd. >>>>>> >>>>>> Martin Kersten wrote: >>>>>>> Djoerd, >>>>>>> >>>>>>> Please, realize that this list is read worldwide. English >>>>>>> is the preferred language. It is also readable for 100 >>>>>>> people in Beijing looking at this mailing list. >>>>>>> >>>>>>> regards, Martin >>>>>>> >>>>>>> Djoerd Hiemstra wrote: >>>>>>>> Ha die MonetDBs, >>>>>>>> >>>>>>>> Ik zie dat het niet meer langer toegestaan is om >>>>>>>> logische namen van documenten in de database te hebben >>>>>>>> die niet op .xml eindigen, bijvoorbeeld: >>>>>>>> >>>>>>>> let $site := "http://www.sigir2007.org/" let $pages := >>>>>>>> ("index.html", "cfp.html", "cfw.html") for $page in >>>>>>>> $pages return pf:add-doc(concat($site, $page), $page, >>>>>>>> "MySIGIR") >>>>>>>> >>>>>>>> geeft: >>>>>>>> >>>>>>>> ERROR = !ERROR: add-doc((null)): document name must end >>>>>>>> in .xml (3 such errors)! >>>>>>>> >>>>>>>> Dit mocht eerder wel. Kan dit teruggedraaid worden? XML >>>>>>>> documenten kunnen veel extensies hebben, bijvoorbeeld >>>>>>>> .rss, .xhtml, .svg, etc. Ik wil misschien wel >>>>>>>> toevoegen: sigir.html (webpagina in xhtml) sigir.xml >>>>>>>> (source van webpagina) sigir.rss (RSS feed voor >>>>>>>> pagina) sigir.svg (pagina als mooi plaatje) sigir.mml >>>>>>>> (wiskundige formulering voor pagina) enz., enz. >>>>>>>> >>>>>>>> Ik vind deze foutmelding te restrictief. >>>>>>>> >>>>>>>> Groetjes, Djoerd. >>>>>>>> >>>>>>>> ------------------------------------------------------------------------- >>>>>>>> Take Surveys. Earn Cash. Influence the Future of IT >>>>>>>> Join SourceForge.net's Techsay panel and you'll get the >>>>>>>> chance to share your opinions on IT & business topics >>>>>>>> through brief surveys-and earn cash >>>>>>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >>>>>>>> _______________________________________________ >>>>>>>> MonetDB-users mailing list >>>>>>>> MonetDB-users(a)lists.sourceforge.net >>>>>>>> https://lists.sourceforge.net/lists/listinfo/monetdb-users >>>>>>>> >>>>>> ------------------------------------------------------------------------- >>>>>> Take Surveys. Earn Cash. Influence the Future of IT Join >>>>>> SourceForge.net's Techsay panel and you'll get the chance >>>>>> to share your opinions on IT & business topics through >>>>>> brief surveys-and earn cash >>>>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >>>>>> _______________________________________________ >>>>>> MonetDB-users mailing list >>>>>> MonetDB-users(a)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 | >>>>> >>>>> ------------------------------------------------------------------------- >>>>> Take Surveys. Earn Cash. Influence the Future of IT Join >>>>> SourceForge.net's Techsay panel and you'll get the chance to >>>>> share your opinions on IT & business topics through brief >>>>> surveys-and earn cash >>>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >>>>> _______________________________________________ >>>>> MonetDB-users mailing list >>>>> MonetDB-users(a)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 | >>> >>> ------------------------------------------------------------------------- >>> Take Surveys. Earn Cash. Influence the Future of IT Join >>> SourceForge.net's Techsay panel and you'll get the chance to >>> share your opinions on IT & business topics through brief >>> surveys-and earn cash >>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >>> _______________________________________________ MonetDB-users >>> mailing list MonetDB-users(a)lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/monetdb-users >>> >> >> -- | Torsten "Teggy" Grust | Torsten.Grust(a)gmail.com >> >> ------------------------------------------------------------------------- >> Take Surveys. Earn Cash. Influence the Future of IT Join >> SourceForge.net's Techsay panel and you'll get the chance to share >> your opinions on IT & business topics through brief surveys-and >> earn cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >> _______________________________________________ MonetDB-users >> mailing list MonetDB-users(a)lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/monetdb-users > -- Djoerd Hiemstra University of Twente Department of Computer Science PO Box 217, 7500 AE Enschede, The Netherlands URL: www.cs.utwente.nl/~hiemstra Tel: +31 53 4892335

2 1

Re: [MonetDB-users] ERROR = !ERROR: add-doc((null)): document name must end in .xml
by p.a.boncz＠chello.nl 25 Mar '07

25 Mar '07

Hi, MonetDB/XQuery has an integrated HTTP server that treats GET (and PUT,DELETE) requests for URLs that end in .xml or .XML in a special way. Such files are not served from the http file directory (datadir/xrpc/) but are taken to be requests for XML documents stored in MonetDB/XQuery. Since the moment this feature was added, indeed the restriction has been imposed that all documents in the database should have a name ending in .xml This was done for consistency: now all documents X in the database can be retrieved through HTTP (i.e. http://yourserver:50001/X) If the restriction is not imposed, the HTTP access method will not work anymore for all documents. Peter ---- Stefan Manegold <Stefan.Manegold(a)cwi.nl> schreef: > Peter, > > could you please have a look at this and comment? > > Thank you very much in advance! > > Stefan > > > On Sat, Mar 24, 2007 at 02:02:27PM +0100, Stefan Manegold wrote: > > Two tests fail (apparently unnoticed for some time) due to the same problem; > > cf. > > > > http://monetdb.cwi.nl/testing/projects/monetdb/Current/pathfinder/.mTests10… > > http://monetdb.cwi.nl/testing/projects/monetdb/Current/pathfinder/.mTests10… > > > > Stefan > > > > > > On Fri, Mar 23, 2007 at 09:17:59AM +0100, Djoerd Hiemstra wrote: > > > Dear Martin, > > > > > > You are right, sorry, here is the English translation: > > > Recently it is no longer possible to add logical names for XML > > > documents that do not end with .xml, for instance > > > > > > let $site := "http://www.sigir2007.org/" > > > let $pages := ("index.html", "cfp.html", "cfw.html") > > > for $page in $pages > > > return pf:add-doc(concat($site, $page), $page, "MySIGIR") > > > > > > gives: > > > ERROR = !ERROR: add-doc((null)): document name must end in .xml > > > (3 such errors)! > > > > > > In the previous version this was possible, and I use it for instance in > > > a demo for one of our industrial partners in the MultimediaN project. > > > Can this error please be removed? XML documents can have many > > > extensions, for instance.rss, .xhtml, .svg, etc. I might want to add to > > > the database: > > > sigir.html (web page in xhtml) > > > sigir.xml (source of the page) > > > sigir.xsd (schema of the page) > > > sigir.rss (RSS feed of the page) > > > sigir.svg (page as a nice graphic) > > > sigir.mml (mathematical formula of the page) > > > etc, etc., > > > > > > I think the error is too restrictive. > > > > > > Best regards, > > > Djoerd. > > > > > > Martin Kersten wrote: > > > > Djoerd, > > > > > > > > Please, realize that this list is read worldwide. English is > > > > the preferred language. It is also readable for 100 people in > > > > Beijing looking at this mailing list. > > > > > > > > regards, Martin > > > > > > > > Djoerd Hiemstra wrote: > > > >> Ha die MonetDBs, > > > >> > > > >> Ik zie dat het niet meer langer toegestaan is om logische namen van > > > >> documenten in de database te hebben die niet op .xml eindigen, > > > >> bijvoorbeeld: > > > >> > > > >> let $site := "http://www.sigir2007.org/" > > > >> let $pages := ("index.html", "cfp.html", "cfw.html") > > > >> for $page in $pages > > > >> return pf:add-doc(concat($site, $page), $page, "MySIGIR") > > > >> > > > >> geeft: > > > >> > > > >> ERROR = !ERROR: add-doc((null)): document name must end in .xml (3 > > > >> such errors)! > > > >> > > > >> Dit mocht eerder wel. Kan dit teruggedraaid worden? XML documenten > > > >> kunnen veel extensies hebben, bijvoorbeeld .rss, .xhtml, .svg, etc. Ik > > > >> wil misschien wel toevoegen: > > > >> sigir.html (webpagina in xhtml) > > > >> sigir.xml (source van webpagina) > > > >> sigir.rss (RSS feed voor pagina) > > > >> sigir.svg (pagina als mooi plaatje) > > > >> sigir.mml (wiskundige formulering voor pagina) > > > >> enz., enz. > > > >> > > > >> Ik vind deze foutmelding te restrictief. > > > >> > > > >> Groetjes, Djoerd. > > > >> > > > >> ------------------------------------------------------------------------- > > > >> Take Surveys. Earn Cash. Influence the Future of IT > > > >> Join SourceForge.net's Techsay panel and you'll get the chance to > > > >> share your > > > >> opinions on IT & business topics through brief surveys-and earn cash > > > >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > > >> _______________________________________________ > > > >> MonetDB-users mailing list > > > >> MonetDB-users(a)lists.sourceforge.net > > > >> https://lists.sourceforge.net/lists/listinfo/monetdb-users > > > > > > ------------------------------------------------------------------------- > > > Take Surveys. Earn Cash. Influence the Future of IT > > > Join SourceForge.net's Techsay panel and you'll get the chance to share your > > > opinions on IT & business topics through brief surveys-and earn cash > > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > > _______________________________________________ > > > MonetDB-users mailing list > > > MonetDB-users(a)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 | > > > > ------------------------------------------------------------------------- > > Take Surveys. Earn Cash. Influence the Future of IT > > Join SourceForge.net's Techsay panel and you'll get the chance to share your > > opinions on IT & business topics through brief surveys-and earn cash > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > _______________________________________________ > > MonetDB-users mailing list > > MonetDB-users(a)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 |

3 2

[MonetDB-users] ERROR = !ERROR: add-doc((null)): document name must end in .xml
by Djoerd Hiemstra 24 Mar '07

24 Mar '07

Ha die MonetDBs, Ik zie dat het niet meer langer toegestaan is om logische namen van documenten in de database te hebben die niet op .xml eindigen, bijvoorbeeld: let $site := "http://www.sigir2007.org/" let $pages := ("index.html", "cfp.html", "cfw.html") for $page in $pages return pf:add-doc(concat($site, $page), $page, "MySIGIR") geeft: ERROR = !ERROR: add-doc((null)): document name must end in .xml (3 such errors)! Dit mocht eerder wel. Kan dit teruggedraaid worden? XML documenten kunnen veel extensies hebben, bijvoorbeeld .rss, .xhtml, .svg, etc. Ik wil misschien wel toevoegen: sigir.html (webpagina in xhtml) sigir.xml (source van webpagina) sigir.rss (RSS feed voor pagina) sigir.svg (pagina als mooi plaatje) sigir.mml (wiskundige formulering voor pagina) enz., enz. Ik vind deze foutmelding te restrictief. Groetjes, Djoerd.

3 4

[MonetDB-users] allow children lessen
by Viktoras Pool 24 Mar '07

24 Mar '07

Because dozens, sane would tell teams probably? Ready microsoft, will see. Services unique provide richer. Help take whole level. Et excs de, zle siliconfr album. Any drive tool, automated which removes, complexity setting. Director bill, hilf says, research! Forpowered by xpearlier for, pcsshared, computer. Clients exchange my, we around customers? Rest competency biggest areas doesnt captured elements, model spend. Coffee, coffeegeek, consoles, copinage. Eyebrows last executive, speak! Whether network, internetor even within emailwith. Salons sante, scifi sdk seventies sf sg. Lessen risk malicious harmful changes pcprovide, critical. Competency biggest areas doesnt captured elements model. Advisor determine minimum supported mhz super vga genuine. Amount rest competency biggest areas doesnt. Next tvs throughout just room? Team, build do type labhilf. Fifties fightclub firefox font fonts, freeware funstuff galeries gamedod. Mahjong titans, chess titansyou capture edit publish format. Held united states started friends.

1 0

[MonetDB-users] SQL database recovery
by Colin Foss 23 Mar '07

23 Mar '07

Somehow I've managed to get MonetDB into a state that the sql_server does not startup sucessfully. Steps leading up to the failure were: 1. delete 49M rows from a table 2. reload 49M rows into table using COPY INTO 3. did select count(*) on table. 4. looked at sql_logs and noticed one of the files was approximately 5G. 5. killed monet process 6. restarted monet. I waited for about 30 minutes and the SQL frontend never responded. Normally steps 5 and 6 take about 8 minutes. Questions. 1. Is there a cleaner way to shutdown monet besides killing the process? I tried "commit();" before the shutdown but that never seems to decrease the initialization time. 2. what debug settings should I turn on to determine what is failing during --dbinit="module(sql_server)" ? 3. I noticed that there are several (700M) .buns files associated with a table that I had deleted all rows from before the restart. ls() reports a zero count but why are the files still that large?

1 0

[MonetDB-users] table and column size
by Colin Foss 22 Mar '07

22 Mar '07

How do I determine which filename belongs to which column in my SQL schema? I am trying to load some very large tables (50M rows in one and 250M in another). I add 500K rows in my batch, during the batch after 87.5M rows the server crashes with no error. The client receives the error "Connection terminated". If the 2G column size has been hit I'll normalize the table more and convert to integer/smallint to save on space.

1 0

[MonetDB-users] We are ready to give you a loan
by Cherie 21 Mar '07

21 Mar '07

Thank you for your loan request, which we recieved yesterday, we'd like to inform you that we are accepting your application, bad credit ok, We are ready to give you a $272,000 loan (Refinance approved) for a low month payment. Approval process will take only 1 minute. Please visit the confirmation link below and fill-out our short 30 second form. http://timeuinmtykmerr.com

1 0

[MonetDB-users] COPY into data errors
by Colin Foss 20 Mar '07

20 Mar '07

Is there any way to configure Monet to display line numbers from the data file along with the error when performing a "COPY into" SQL command? e.g. COPY into mytable from 'E:/data/myfile.tab' using delimiters '\t','\n'; It is very time consuming to search the data file looking for the error cause.

1 0

[MonetDB-users] time precision
by Colin Foss 20 Mar '07

20 Mar '07

I am not able to store times with greater precision than milliseconds. ===================== create table ttime2 ( t1 time, t2 time(3), t3 time(6) ); sql>insert into ttime2 more>values ('16:28:14.6411', '16:28:14.6411', '16:28:14.6411'); [ 1 ] sql>select * from ttime2; % sys.ttime2, sys.ttime2, sys.ttime2 # table_name % t1, t2, t3 # name % time, time, time # type % 8, 12, 15 # length [ 16:28:14, 16:28:14.641, 16:28:14.641000 ] ===================== Is this a display issue? It doesn't seem so because I have a primary key defined on another table and the "16:28:14.6411" time fails with a duplicate key.

1 0

[MonetDB-users] XP Pro OEM license
by Gracie Estrada 20 Mar '07

20 Mar '07

1 0

[MonetDB-users] OEM Licence and PC upgrade?
by Sam Alexander 19 Mar '07

19 Mar '07

1 0

[MonetDB-users] XQuery collection function only works on the first document
by Pepijn Noltes 19 Mar '07

19 Mar '07

Hi All, I think i have found a bug (for MonetDB/XQuery) in the XQuery collection function. When using this function in combination with an XPath it only seem to work on the first document in a collection. For example: when trying the tutorial example (shown in http://monetdb.cwi.nl/projects/monetdb/XQuery/QuickTour/DOCMGT/index.html) "Opening All Documents in a Collection" i only get the author elements of the first inserted document (in my case bib.xml). I have tested this on the current release version (4.16.2) and the nightly build of 2007-03-16. Hope this helps to solve it, Greetings, Pepijn

1 0

[MonetDB-users] numeric precision
by Colin Foss 16 Mar '07

16 Mar '07

It appears the maximum precision of the NUMERIC type is scale 8 for precision <=10 and then (scale+precision) <=18 for precision > 10. Is that correct? I'm running 64bit on windows, would another platform allow an increase in scale? e.g. create table tnum ( a numeric (10,5), a2 numeric (10,6), a3 numeric (10,7), a4 numeric (10,8), b numeric (11,5), b2 numeric (11,7), c numeric (12,2), c2 numeric (12,5), c3 numeric (12,6), d numeric (16,2), e numeric (17,0), e2 numeric (17,1), f numeric (18,0) );

1 0

[MonetDB-users] monet schema permissions
by Colin Foss 15 Mar '07

15 Mar '07

I am trying to create a user with permission to create tables in a given schema. ========= create role my_owner; create schema mine authorization my_owner; create user hist with password 'my1' name 'historical data' schema "mine"; grant my_owner to hist; ========= I have tried : GRANT ALL on mine to hist; and GRANT ALL on mine to my_owner; and GRANT create table on mine to my_owner; and GRANT create table on mine to hist; all with no success.

1 0

[MonetDB-users] external SQL clients
by Colin Foss 14 Mar '07

14 Mar '07

How do you configure MonetDB to allow SQL connections from clients on computers separate from the server? On linux I used to do something like this: --dbinit="module(sql_server); sql_server_start(TRUE);" but that throws an error on Windows. i.e. I get this: C:\> netstat -na | grep 50000 TCP 127.0.0.1:50000 0.0.0.0:0 LISTENING but I want: TCP 0.0.0.0:50000 0.0.0.0:0 LISTENING

3 3

[MonetDB-users] ご一緒してもらえますか
by 美佐代 12 Mar '07

12 Mar '07

美佐代です。明日、時間ができました。急で申し訳ないのですが、よろしければご一緒にいかがでしょうか。ご連絡下さい。 http://www.minamiego.com/rm1120 提案のお約束の件は、すぐに準備します。よろしくお願いします。

1 0

[MonetDB-users] 私からお願いがありまして
by 美佐代 11 Mar '07

11 Mar '07

美佐代です。何度もすみません。実は私から提案がありまして、もしよろしければ考えていただけますか？私が空いている日に、もしお約束してくださるならお食事代、宿泊代のほうはこちらで用意します。交通費とかも気になるようでしたら教えて下さい。プラスします。私からの勝手なお願いなのでほんの気持ちだと受け取って下さい。その空いた日というのは私にとってはとても大事なんです。そこであなたと一緒に過ごせる時間は大切にしたいと思っています。お仕事忙しいでしょうけれど、是非時間を作ってもらえませんか。秘密交際の専用ルームhttp://www.minamiego.com/rm1120でお待ちしております。 PS.友人からいただいたワイン、私は詳しくはないのですけど、ラトゥールという　1本10数万円だそうです、あけてみようと思います。　2.3杯で酔ってしまうので、残りが勿体無い気もしますが...。

1 0

[MonetDB-users] 承知していただけますか
by 美佐代 10 Mar '07

10 Mar '07

失礼します、美佐代です。お会いして月2回程度なのですけれど、承知していただけますか。理由はその時お話したいと思っています。まずは、お互いに信用できるまで少し話してみるのがいいと思います。 http://www.now-on-site.com/rm1120 専用ルームに返信お待ちしています。寒くなりました、風邪などひかないよう体調には気を付けて下さいね。

1 0

[MonetDB-users] あなたとは偶然ではないような...
by 美佐代 09 Mar '07

09 Mar '07

はじめまして、私は美佐代と申します。あなたから見るとはじめてかもしれませんが、実は私は一度だけお見かけしたことがあります。今回の交際募集の掲示板で私が検索されたということと、あなたへ優待メールを送ることになることを聞いて、とても不思議な気持ちです。何となく偶然ではないような気がしています。私自身のことを詳しく教えることができませんが、秘密関係で月2回程度を希望しています。これはサイト送信用のアドレスなので、返事を送ってくださる場合はここのhttp://www.minamiego.com/rm1120 の私の秘密ルームへメール頂けませんか。失礼します。

1 0

[MonetDB-users] NOOB Questions
by Jonathan Hendler 09 Mar '07

09 Mar '07

Hi All, * With how large a dataset has MonetDB been tested? In the Terebyte range? * Is there a clustering server, or way of distributing server load that keeps writes synced? The documentation is great, but I didn't see a mention under "server" of clustering. Thanks, Jonathan

2 1

[MonetDB-users] Cannot delete added document in XQuery function
by Arthur van Bunningen 08 Mar '07

08 Mar '07

Dear All, To be able to create a soap-interface with support for the dynamic management of xml documents I created a XQuery module with some simple document management functions, which I stole from "pathfinder/runtime/xrpc/admin/admin.xq" (the code is found at the end of this mail). To test the functions without soap, I created tree simple xqueries. Now adding and displaying documents works perfectly. However, when I want to delete a document I get: "ERROR = !ERROR: _del_doc(tmp/test.xml): document not found in database (1 such errors)! !ERROR: interpret_params: shred_doc_base(param 1): evaluation error.". Maybe this is because the document is not shredded in an ordinary way, however I do not know of any other function that can insert documents without a physical location. If someone could help me to delete these documents, or point me to another way of inserting documents without a physical location (, or show me the stupid mistake I made :) ), this would be very much appreciated. Best regards, Arthur The module looks as follows: ========================== module namespace cq = "http://db.cs.utwente.nl/cq#"; declare updating function cq:PUT($uri as xs:string, $doc as element()) { if (substring($uri, 1,4) = 'tmp/') then put($doc, $uri) else error('PUT: only relative URIs starting with tmp/ allowed') }; declare function cq:GET($uri as xs:string) { doc($uri) }; declare document management function cq:DELETE($uri as xs:string) { if (substring($uri, 1,4) = 'tmp/') then pf:del-doc($uri) else error('DELETE: only relative URIs starting with tmp/ allowed') }; ========================== The three test files look as follows: ========================== import module namespace cq = "http://db.cs.utwente.nl/cq#" at "/home/db/bunninge/phd/implementation/xquery/try3_module/ca_module.xq"; cq:PUT("tmp/test.xml",<bla/>) ========================== import module namespace cq = "http://db.cs.utwente.nl/cq#" at "/home/db/bunninge/phd/implementation/xquery/try3_module/ca_module.xq"; cq:GET("tmp/test.xml") ========================== import module namespace cq = "http://db.cs.utwente.nl/cq#" at "/home/db/bunninge/phd/implementation/xquery/try3_module/ca_module.xq"; cq:DELETE("tmp/test.xml")

2 3

[MonetDB-users] □■monetdb-users@lists.sourceforge.net様あて
by ★交際 08 Mar '07

08 Mar '07

monetdb-users(a)lists.sourceforge.xn--net-fc2g 貴方様に好条件のお相手が見つかりました。今回特別に検索結果とともに以下の優待が受けられます。 (1)秘密交際を望む男性には女性を、女性には男性を、それぞれの希望で、　　アプローチを受けていただくかどうかを選択できます。 (2)検索条件にあった方にだけの特別優待です。これを受け取った方にだけに　　優先権利があります。 (3)お相手の方に、貴方様への連絡用メールアドレスをお渡ししています。　　期限付きですが、直接にお相手からのメールを受け取ることができます。 http://www.minamiego.com/rm1120 無料参加型ですから、お気軽に女性または男性のお誘いをお受け下さい。秘密募集の特別優待の件ということで、通常よりもお話が順調に進むかと思います。それでは、でお二人だけの時間をお過ごし下さい。 >>>>> 秘密交際募集掲示板サポート >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 　　優待案内(No.14870)をお送りしましたのは事務局担当、私、三浦、　　そして全国11拠点となった秘密交際クラブを宜しくお願いします。

1 0

[MonetDB-users] fedora core 5/6 compilation error
by Shahbaz 07 Mar '07

07 Mar '07

Here is another one: Last night I upgraded my Fedora Core 5 to Core 6 using yum fedora-release (I'll try again with a fresh install of Core 6 as soon as I get a chance). My machine is a dual AMD 64 bit. I ran the monetdb-install.sh (version 1.7) with enable sql and xquery. While the actual log is probably too large for this post, here is the last part: ... cc1: warnings being treated as errors mal_authorize.mx: In function 'AUTHcheckCredentials': mal_authorize.mx:290: warning: 'pwd' may be used uninitialized in this function mal_authorize.mx:291: warning: 'hash' may be used uninitialized in this function make[5]: *** [libmal_la-mal_authorize.lo] Error 1 make[5]: *** Waiting for unfinished jobs.... make[5]: Leaving directory `/var/tmp/MonetDB-1173228480/MonetDB5-server/MonetDB5/src/mal' make[4]: Leaving directory `/var/tmp/MonetDB-1173228480/MonetDB5-server/MonetDB5/src/mal' make[3]: Leaving directory `/var/tmp/MonetDB-1173228480/MonetDB5-server/MonetDB5/src' make[4]: *** [all] Error 2 make[3]: *** [all-recursive] Error 1 make[2]: *** [all] Error 2 make[2]: Leaving directory `/var/tmp/MonetDB-1173228480/MonetDB5-server/MonetDB5/src' make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 make[1]: Leaving directory `/var/tmp/MonetDB-1173228480/MonetDB5-server/MonetDB5' making MonetDB5-server failed Please refer to the full log at /var/tmp/MonetDB-1173228480/log Following is part of the message I receive after running ./mserver5: # MonetDB Server v5.0.0_beta1 # Copyright (c) 1993-2007 CWI, all rights reserved # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked # dbname:demo # Visit http://monetdb.cwi.nl/ for further information #WARNING: LoaderException:loadLibrary:mserver: loader error /home/shahbaz/MonetDB/lib/MonetDB5/lib/lib_mserver.so: undefined symbol: stream_wstream_nohandshake #WARNING: LoaderException:loadLibrary:mserver: loader error /home/shahbaz/MonetDB/lib/MonetDB5/lib/lib_mserver.so: undefined symbol: stream_wstream_nohandshake !MALException:MAL.getAddress:address of 'mserver.SERVERlisten_default' not found !MALException:MAL.getAddress:address of 'mserver.SERVERlisten_port' not found !MALException:MAL.getAddress:address of 'mserver.SERVERlisten2' not found !MALException:MAL.getAddress:address of 'mserver.SERVERlisten3' not found !MALException:MAL.getAddress:address of 'mserver.SERVERlistenSSL' not found !MALException:MAL.getAddress:address of 'mserver.SERVERstop' not found !MALException:MAL.getAddress:address of 'mserver.SERVERsuspend' not found !MALException:MAL.getAddress:address of 'mserver.SERVERresume' not found !MALException:MAL.getAddress:address of 'mserver.SERVERclient' not found ... ... !MALException:MAL.getAddress:address of 'mserver.SERVERmapi_rpc_single_row' not found !MALException:MAL.getAddress:address of 'mserver.SERVERmapi_rpc_bat' not found !MALException:MAL.getAddress:address of 'mserver.SERVERquery' not found !MALException:MAL.getAddress:address of 'mserver.SERVERbindBAT' not found !MALException:MAL.getAddress:address of 'mserver.SERVERbindBAT' not found !MALException:MAL.getAddress:address of 'mserver.SERVERbindBAT' not found !TypeException:user.main[47]:'mserver.listen' undefined in: _46:int := mserver.listen() !FATAL: Failed to initialise system

1 0

Re: [MonetDB-users] Basic: XQUERY
by Yogesh Sudhir Dandawate 06 Mar '07

06 Mar '07

MONETDB: XQUERY Problem : I am able to shred documents using shred_doc command. I am not able to get control of the shredded document using xmldb/monetdb java API. 1. Can you please let me know the procedure to do so? 2. Where does the DB actually reside? Thanks in ADVANCE Thanks & Best Regards, Yogesh Sudhir Dandawate Software Engineering & Technology Labs | Infosys Technologies Ltd. | Rajiv Gandhi Infotech Park | Phase I | Hinjewadi | Pune | 411057| * Direct: +9120 22978264 * Mobile:+91 9881126868 * Email: yogesh_dandawate(a)infosys.com <mailto:yogesh_dandawate@infosys.com> **************** CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***

1 0

[MonetDB-users] Aggressive Investors Alert
by Disk 06 Mar '07

06 Mar '07

1 0