How to find all running processes and their statuses in MonetDB??
I found this...
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/monitor
But I couldn't get this work... I ran a query (which took some 20 seconds
to complete) in a window and connected the same database in another
terminal and ran "select * from sys.queue" (several times during those 20
seconds) but I could get only this...
sql>select * from sys.queue;
+-------+---------+----------------------------+----------------------------+----------+---------+------------+--------------------------+
| qtag | user | started | estimate
| progress | status | tag | query |
+=======+=========+============================+============================+==========+=========+============+==========================+
| 27339 | monetdb | 2015-08-13 05:35:40.000000 | null
| null | running | 12532134@0 | select * from sys.queue; |
+-------+---------+----------------------------+----------------------------+----------+---------+------------+--------------------------+
I am using Oct-2014 version of monetdb on CentOS...
Is there a way to find all running processes and their statuses in
MonetDB??
Thanks & Regards,
Vijayakrishna.P.
Mobile : (+91) 9500402305.
Dear all,
Is there a way to concatenate more than 2 strings at once?
The CONCAT function only allow for concatenating 2 strings.
Also, hhe JDBC driver for MonetDB reports that the following string
functions are supported (see the list below).
Are these functions documented somewhere?
ascii
char_length
character_length
code
concat
copyfrom
difference
editdistance
editdistance2
get_value_for
ilike
index
insert
lcase
left
length
levenshtein
like
locate
lower
lpad
ltrim
next_value_for
not_ilike
not_like
octet_length
patindex
qgramnormalize
repeat
replace
restart
right
rpad
rtrim
similarity
soundex
space
splitpart
strings
substring
trim
truncate
ucase
upper
Best regards,
Sebastien
--
Parc d'activité Tolstoï
4 rue Edouard Aynard
69100 Villeurbanne
Tél. +33 (0)4 78 95 05 80
Fax +33 (0)4 78 95 00 17
www.passman.frwww.passman-hotels.comwww.passman-camping.comwww.passman-sante.com
<https://www.facebook.com/PASSMAN-187787814053/>
Hi all,
I am currently extending the NodeJS connector for MonetDB, that
communicates with the mserver process using Mapi. However, I face some
unexpected behavior when I insert timestamptz values into a table and
then retrieve it. This is the Mapi:
TX: sCREATE TABLE bar (a timestamptz);
RX: &3
TX: sINSERT INTO bar VALUES ('2015-10-29 11:31:35.000000+01:00');
RX: &2 1 -1
TX: sSELECT * FROM bar;
RX: &1 0 1 1 1
% sys.bar # table_name
% a # name
% timestamptz # type
% 32 # length
[ 2015-10-29 10:31:35.000000+00:00 ]
As you can see, inserting the timestamptz string '2015-10-29
11:31:35.000000+01:00', results in it being stored as its equivalent
'2015-10-29 10:31:35.000000+00:00'. If I do the same with mclient, this
does not happen, and I get the exact same string back. Does anyone know
why this might be happening?
Hi,
I'm aware the embedded "monetdblite" library isn't released yet - but it
seems perfect for my use case so am very excited to try it. I've tried
compiling the source from the pyapi branch but run into:
"ImportError:
/usr/local/lib/python2.7/dist-packages/monetdb5/lib/monetdb5/lib_pyapi.so:
undefined symbol: batint_dec2_dbl" when I
"import monetdblite" on Linux Mint 17 with python 2.7 or 3.4
Any chance of some build instructions for this module? Or do I just need to
be patient for the release? :)
Ta,
Ben
Hi all,
I'm pretty sure I already know the answer, but is it possible to select the
database at runtime instead of "hardcoded" into the connection string?
For example, my (JDBC) connection string would only be the MonetDB host
(i.e. jdbc:monetdb://192.168.0.1/) and then I'd be able to execute a query
to select the right database (e.g. SET DATABASE dbname).
Best regards,
Dennis
Hi,
Is it possible to change the default role of a user? I want to avoid the
step of having to execute the "SET ROLE role" statement before being able
to run my queries.
Best regards,
Dennis Pallett
Hi all,
We are using MoentDB since 6 months with quite good results.(thanks to the
dev team for their good work)
Unfortunately yesterday we came across an issue for which we can't find a
solution.
Our database crashed for an unknown reason (RAM was fine, Disk space was
fine) and now each time we re-use the same table with a query we used
during the crash, the database crash with a seg fault
Query : select * from storage();
OS Version : CentOS release 6.7 (Final)
MonetDB Version : MonetDB Database Server Toolkit v1.1 (Jul2015)
tail /var/log/messages :
kernel: mserver5[9945]: segfault at 18 ip 00007f9e86fd534b sp
00007f9e862912e0 error 4 in lib_sql.so[7f9e86eb1000+182000]
merovingian.log :
database 'BI-DEV' (9972) was killed by signal SIGSEGV
Log from gbd :
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7ffa24edc700 (LWP 4683)]
0x00007ffa25c1f34b in delta_bind_bat () from /usr/lib64/monetdb5/lib_sql.so
(gdb) bt
#0 0x00007ffa25c1f34b in delta_bind_bat () from
/usr/lib64/monetdb5/lib_sql.so
#1 0x00007ffa25b20fee in sql_storage () from /usr/lib64/monetdb5/lib_sql.so
#2 0x00007ffa321aea45 in runMALsequence () from
/usr/lib64/libmonetdb5.so.19
#3 0x00007ffa321afe29 in callMAL () from /usr/lib64/libmonetdb5.so.19
#4 0x00007ffa25b369f7 in SQLexecutePrepared () from
/usr/lib64/monetdb5/lib_sql.so
#5 0x00007ffa25b36efc in SQLengineIntern () from
/usr/lib64/monetdb5/lib_sql.so
#6 0x00007ffa321c87dd in runScenarioBody () from
/usr/lib64/libmonetdb5.so.19
#7 0x00007ffa321c886f in runScenario () from /usr/lib64/libmonetdb5.so.19
#8 0x00007ffa321c9738 in MSserveClient () from /usr/lib64/libmonetdb5.so.19
#9 0x00007ffa321ca816 in MSscheduleClient () from
/usr/lib64/libmonetdb5.so.19
#10 0x00007ffa32266e0f in doChallenge () from /usr/lib64/libmonetdb5.so.19
#11 0x00007ffa31d2adcf in thread_starter () from /usr/lib64/libbat.so.12
#12 0x00007ffa2f97da51 in start_thread (arg=0x7ffa24edc700) at
pthread_create.c:301
#13 0x00007ffa2f6ca93d in clone () at
../sysdeps/unix/sysv/linux/x86_64/clone.S:115
Any help to understand and correct what is going on would be nice.
Regards
Mathieu
hi, this is just a general request for the awesome folks at cwi: could you
give some serious thought to optimizing ram usage on windows? this happens
to me a lot, i end up just leaving these big joins to run overnight--
http://s30.postimg.org/saeo9ca7l/overloaded.png
happy to write up some r-driven reproducible examples if there's
willingness to combat these bottlenecks. thanks as always from your
biggest fan.
Hello everyone! I am facing some (probably simple) problems. A snippet
of a timestamp column in my table:
+----------------------------+
| ts |
+============================+
| 1595-04-02 00:00:00.000000 |
| 1595-04-02 00:00:00.000000 |
| 1595-04-02 00:00:00.000000 |
| 1595-04-02 00:00:00.000000 |
| 1598-03-25 00:00:00.000000 |
+----------------------------+
I want to fill all the times in these fields with a random value
(uniformly distributed is fine). This faces me with the following problems:
1) Adding an interval to a timestamp does not seem to be suited for
dynamic intervals:
This works fine:
UPDATE "table" SET ts = (ts + INTERVAL '5000' SECOND);
This doesn't:
UPDATE "table" SET ts = (ts + INTERVAL (CAST(5000 AS STRING)) SECOND);
Does someone maybe know of a way to accomplish this?
2) Does someone know how to normalize the output of the RAND operator
available in SQL? It seems to calculate a random BIGINT, and in order
for me to normalize it, I would need the maximum value of a BIGINT,
which of course is platform dependent. Is there a way to get the max
value of BIGINT on the SQL level? Or can I go about this another way?
All help is much appreciated!
Robin
Does anyone know of a Presto connector for MonetDB? There are connectors for MySQL and PostgreSQL among others, but I don't see one for MonetDB.
Thanks,
Steve
