April 2015 - users-list

MonetDB Cluster
by Luciano Sasso 23 Apr '15

23 Apr '15

Hi, Cluster MonetDB is only partitioning or is replication, or all? Att, -- Luciano Sasso Vieira Data Scientist & Solutions Architect luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br <http://www.gsgroup.com.br> --- Este email foi escaneado pelo Avast antivírus. http://www.avast.com

1 0

Database Size
by Luciano Sasso 23 Apr '15

23 Apr '15

Hi, What is the largest (size in G) database that you have worked? on a single server or cluster. Att, -- Luciano Sasso Vieira Data Scientist & Solutions Architect luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br <http://www.gsgroup.com.br> --- Este email foi escaneado pelo Avast antivírus. http://www.avast.com

1 0

Server crash with DDL in transaction
by Pete Hollobon 23 Apr '15

23 Apr '15

Running this on Oct2014-SP2 crashes the server. CREATE TABLE bugexample ( id INTEGER ); START TRANSACTION; ALTER TABLE bugexample ADD COLUMN newcolumn integer; ALTER TABLE bugexample ALTER COLUMN newcolumn SET NOT NULL; COMMIT; It is reproducible. I've logged a bug - number 3715. Thanks, Pete.

1 0

Table types in MonetDB
by Robert Koch 22 Apr '15

22 Apr '15

Hi all, in the documentation of system catalog (https://www.monetdb.org/Documentation/SQLcatalog/TablesColumns) I found 4 types of tables: 0=Table/1=View/2=Generated/3=Merge What is 2 and 3? Thanks.

2 3

Exactly 10 Seconds Delay during JDBC connect to MonetDB
by Robert Koch 22 Apr '15

22 Apr '15

Hi all, I'm using DBVisualizer to connect via JDBC to MonetDB. There is a delay of very exactly 10 seconds during the connection process. This only happens via JDBC. There are no DNS issues, since the connection is done via IP directly. Connection from the commandline of the server with mclient works perfectly. First step to get closer was to inspect the output of tcpdump. It seems to be on the side of MonetDB, since the last packet is the one sent to MonetDB (192.168.56.102) from my Windows Client (192.168.56.1). 09:33:24.663824 IP 192.168.56.1.57271 > 192.168.56.102.50000: Flags [.], ack 1, win 256, length 0 --- 10 soconds 09:33:34.676884 IP 192.168.56.102.50000 > 192.168.56.1.57271: Flags [P.], seq 1:3, ack 1, win 229, length 2 Additionally, DBVis ist connecting speedy with other databases (PostgreSQL) on the same server. Using following version: MonetDB 11.19.9 MonetDB Native Driver 2.14 (Liberica 20150123 based on MCL v1.11) I did not experience this problem in former versions of MonetDB. Any idea? Thank you.

2 3

Creating an AWS AMI
by Maarten Sander 22 Apr '15

22 Apr '15

Hi everyone, Is there an easy way to create an AWS AMI running MonetDB? Perhaps someone maintains a Packer template? Regards, Maarten

2 4

Strange syntax error when create trigger
by Caroptions Caroptions 21 Apr '15

21 Apr '15

Hi User-List, I am experiencing very strange behavior: CREATE TRIGGER marketdata.calc_sdate BEFORE INSERT ON marketdata.quotes FOR EACH ROW BEGIN ATOMIC -- select * from marketdata.quotes limit 1; END; ERROR: syntax error, unexpected '.', expecting WHILE in: "create trigger marketdata.calc_sdate before insert on marketdata." When I am creating trigger on table without schema it works fine. CREATE TRIGGER marketdata.calc_sdate BEFORE INSERT ON t1 ... Assuming t1 created without schema. All combination of " around schema and table, schema only, table only didn't help. Am I doing something wrong or this is the bug? Thanks,John

2 2

More information about data loss in Bugzilla
by Luciano Sasso 20 Apr '15

20 Apr '15

I found this bug related to loss of data, is exactly what my bug, it was not clear in bugzilla if it was resolved or not, can tell me? I'm very insecure with MonetDB. https://www.monetdb.org/bugzilla/show_bug.cgi?id=3271 Att, -- Luciano Sasso Vieira Data Scientist & Solutions Architect luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br <http://www.gsgroup.com.br> --- Este email foi escaneado pelo Avast antivírus. http://www.avast.com

1 0

More information about data loss
by Luciano Sasso 20 Apr '15

20 Apr '15

Hi, Some more details about data loss in MonetDB, I saw all that yours have commented, and also is aware that I am not with the latest version (update in ), but is a serious mistake in the previous version . Have a comment that said a data synchronization correction was made, has to do with the change or reorganization of data, even when it is only run queries? Will by defragmentation reasons (vacum PostgreSQL), or index creation, the data is changed / moved and in this case can be lost. The query for example is "select product from products where cod_product in (123,12434,33434)", only the data in this column (cod_product) were lost (went blank), and still only clinhas related codes on in. The only thing out of the ordinary has happened is that the ongoing connection was aborted, Pentaho was killed forced, aborting the connections, but the MonetDB service has stopped "stop MonetDB dw", which usually stopped, when start "moentdb start dw", rose correctly without errors, but took a long time to rise, very much, and then went to see the lost data. Att, -- Luciano Sasso Vieira Data Scientist & Solutions Architect luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br <http://www.gsgroup.com.br> --- Este email foi escaneado pelo Avast antivírus. http://www.avast.com

1 0

MAL aggregate function difficulty
by Puthick Hok 20 Apr '15

20 Apr '15

Hi, I'm trying to define an aggregate function in MonetDB to concatenate rows in select group by (GROUP_CONCAT in MySQL). Postgres does not have this but there is an example to define this function. I'm starting to use monetdb from mysql thanks to MonetDB performance for large data sets. For some small tables, we have the feature to allow users to store small amount of custom data in rows and have a web service to convert rows into columns. We have this feature because we can do it in MySQL and Postgres using GROUP_CONCAT. I'm working on an open source breeding system which stores breeding data in MySQL, environment data in Postgres and now marker data in MonetDB in Australia. The system is called KDDart. Going back to my problem is that there is the same question with GROUP_CONCAT about 3 years ago. I have been googling and trying based on the information available for 2 days now. I have learnt how to define a MAL function and make it available in SQL mode by saving it in the autoload. However, when it comes to define and write a MAL aggregate function. I'm unable to find any step-by-step example. I could not start successfully with a simple aggregate solution. I google further that we a documentation on monetdb website about defining an aggregate function in R. I installed R and recompile my MonetDB source (MonetDB-11.19.9) on my openSuSe 12.2 with a pre-compiled R (R-base-2.15.1-1.1.4.x86_64). I followed the instruction to enable rintegration and compile successfully. R integration is loaded with mserver5 instruction. But when using monetdbd it says 'set: no such property: embedr'. I did bit of C debugging but I only got Segmentation fault. I don't know what you could do to help me out. I wish I could write the GROUP_CONCAT MAL function and being able to define it permanently in .mal file and being able to link it to the SQL. I hope you can help me out. Thanks in advance. Puthick

3 3