You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
sql>select "function", (sum(fv.claim_tb) - sum(fv.used_tb)) * 100 / toc.total_overcapacity from sys.filer_volumes as fv, (select sum(claim_tb) - sum(used_tb) as total_overcapacity from sys.filer_volumes) as toc group by fv."function" order by fv."function";
MAPI = (monetdb) /tmp/.s.monetdb.52100
ACTION= read_line
QUERY = select "function", (sum(fv.claim_tb) - sum(fv.used_tb)) * 100 / toc.total_overcapacity from sys.filer_volumes as fv, (select sum(claim_tb) - sum(used_tb) as total_overcapacity from sys.filer_volumes) as toc group by fv."function" order by fv."function";
ERROR = !Connection terminated
Welcome to mclient, the MonetDB/SQL interactive terminal (Feb2013-c94f47b62764)
Database: MonetDB v11.15.8 (Feb2013-c94f47b62764), 'mapi:monetdb://gaia.local:52100/filerdata'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>\d sys.filer_volumes
CREATE TABLE "sys"."filer_volumes" (
"filer" VARCHAR(256) NOT NULL,
"volume" VARCHAR(256) NOT NULL,
"claim_tb" INTEGER,
"used_tb" INTEGER,
"used_perc" SMALLINT,
"function" VARCHAR(24),
CONSTRAINT "filer_volumes_filer_volume_pkey" PRIMARY KEY ("filer", "volume")
);
sql>
merovingian.log:
2013-08-12 09:20:04 MSG filerdata[74564]: arguments: /Users/fgroffen/develop/Mon
etDB/Feb2013/program-x86_64/bin/mserver5 --dbpath=/Users/fgroffen/develop/MonetD
B/monetdb-dbfarms/Feb2013-52100/filerdata --set merovingian_uri=mapi:monetdb://g
aia.local:52100/filerdata --set mapi_open=false --set mapi_port=0 --set mapi_uso
ck=/Users/fgroffen/develop/MonetDB/monetdb-dbfarms/Feb2013-52100/filerdata/.mapi
.sock --set monet_vault_key=/Users/fgroffen/develop/MonetDB/monetdb-dbfarms/Feb2
013-52100/filerdata/.vaultkey --set gdk_nr_threads=4 --set max_clients=64 --set
sql_optimizer=default_pipe --set monet_daemon=yes
2013-08-12 09:20:04 MSG filerdata[74564]: MonetDB 5 server v11.15.8 "Feb2013-c
94f47b62764"
2013-08-12 09:20:04 MSG filerdata[74564]: Serving database 'filerdata', using
4 threads
2013-08-12 09:20:04 MSG filerdata[74564]: Compiled for x86_64-apple-darwin11/6
4bit with 64bit OIDs dynamically linked
2013-08-12 09:20:04 MSG filerdata[74564]: Found 8.000 GiB available main-memor
y.
2013-08-12 09:20:04 MSG filerdata[74564]: Copyright (c) 1993-July 2008 CWI.
2013-08-12 09:20:04 MSG filerdata[74564]: Copyright (c) August 2008-2013 Monet
DB B.V., all rights reserved
2013-08-12 09:20:04 MSG filerdata[74564]: Visit http://www.monetdb.org/ for further information
2013-08-12 09:20:04 MSG filerdata[74564]: Listening for UNIX domain connection requests on mapi:monetdb:///Users/fgroffen/develop/MonetDB/monetdb-dbfarms/Feb2013-52100/filerdata/.mapi.sock
2013-08-12 09:20:04 MSG filerdata[74564]: MonetDB/JAQL module loaded
2013-08-12 09:20:04 MSG filerdata[74564]: MonetDB/SQL module loaded
2013-08-12 13:09:13 ERR filerdata[74564]: Assertion failed: (0), function rel2bin_project, file /Users/fgroffen/develop/MonetDB/Feb2013/hgrepo/sql/backends/monet5/rel_bin.c, line 2310.
2013-08-12 13:09:13 MSG filerdata[74564]: could not find toc.total_overcapacity
2013-08-12 13:09:13 MSG filerdata[74564]: fv.function
2013-08-12 13:09:13 MSG filerdata[74564]: fv.L3
2013-08-12 13:09:13 MSG filerdata[74564]: fv.L4
2013-08-12 13:09:13 MSG filerdata[74564]: fv.function
2013-08-12 13:09:18 MSG merovingian[74552]: database 'filerdata' (74564) was killed by signal SIGABRT
Date: 2013-08-12 13:17:19 +0200
From: @grobian
To: SQL devs <>
Version: 11.15.11 (Feb2013-SP3)
CC: @njnes
Last updated: 2019-01-09 11:49:53 +0100
Comment 18989
Date: 2013-08-12 13:17:19 +0200
From: @grobian
sql>select "function", (sum(fv.claim_tb) - sum(fv.used_tb)) * 100 / toc.total_overcapacity from sys.filer_volumes as fv, (select sum(claim_tb) - sum(used_tb) as total_overcapacity from sys.filer_volumes) as toc group by fv."function" order by fv."function";
MAPI = (monetdb) /tmp/.s.monetdb.52100
ACTION= read_line
QUERY = select "function", (sum(fv.claim_tb) - sum(fv.used_tb)) * 100 / toc.total_overcapacity from sys.filer_volumes as fv, (select sum(claim_tb) - sum(used_tb) as total_overcapacity from sys.filer_volumes) as toc group by fv."function" order by fv."function";
ERROR = !Connection terminated
Welcome to mclient, the MonetDB/SQL interactive terminal (Feb2013-c94f47b62764)
Database: MonetDB v11.15.8 (Feb2013-c94f47b62764), 'mapi:monetdb://gaia.local:52100/filerdata'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>\d sys.filer_volumes
CREATE TABLE "sys"."filer_volumes" (
"filer" VARCHAR(256) NOT NULL,
"volume" VARCHAR(256) NOT NULL,
"claim_tb" INTEGER,
"used_tb" INTEGER,
"used_perc" SMALLINT,
"function" VARCHAR(24),
CONSTRAINT "filer_volumes_filer_volume_pkey" PRIMARY KEY ("filer", "volume")
);
sql>
merovingian.log:
2013-08-12 09:20:04 MSG filerdata[74564]: arguments: /Users/fgroffen/develop/Mon
etDB/Feb2013/program-x86_64/bin/mserver5 --dbpath=/Users/fgroffen/develop/MonetD
B/monetdb-dbfarms/Feb2013-52100/filerdata --set merovingian_uri=mapi:monetdb://g
aia.local:52100/filerdata --set mapi_open=false --set mapi_port=0 --set mapi_uso
ck=/Users/fgroffen/develop/MonetDB/monetdb-dbfarms/Feb2013-52100/filerdata/.mapi
.sock --set monet_vault_key=/Users/fgroffen/develop/MonetDB/monetdb-dbfarms/Feb2
013-52100/filerdata/.vaultkey --set gdk_nr_threads=4 --set max_clients=64 --set
sql_optimizer=default_pipe --set monet_daemon=yes
2013-08-12 09:20:04 MSG filerdata[74564]: MonetDB 5 server v11.15.8 "Feb2013-c
94f47b62764"
2013-08-12 09:20:04 MSG filerdata[74564]: Serving database 'filerdata', using
4 threads
2013-08-12 09:20:04 MSG filerdata[74564]: Compiled for x86_64-apple-darwin11/6
4bit with 64bit OIDs dynamically linked
2013-08-12 09:20:04 MSG filerdata[74564]: Found 8.000 GiB available main-memor
y.
2013-08-12 09:20:04 MSG filerdata[74564]: Copyright (c) 1993-July 2008 CWI.
2013-08-12 09:20:04 MSG filerdata[74564]: Copyright (c) August 2008-2013 Monet
DB B.V., all rights reserved
2013-08-12 09:20:04 MSG filerdata[74564]: Visit http://www.monetdb.org/ for further information
2013-08-12 09:20:04 MSG filerdata[74564]: Listening for UNIX domain connection requests on mapi:monetdb:///Users/fgroffen/develop/MonetDB/monetdb-dbfarms/Feb2013-52100/filerdata/.mapi.sock
2013-08-12 09:20:04 MSG filerdata[74564]: MonetDB/JAQL module loaded
2013-08-12 09:20:04 MSG filerdata[74564]: MonetDB/SQL module loaded
2013-08-12 13:09:13 ERR filerdata[74564]: Assertion failed: (0), function rel2bin_project, file /Users/fgroffen/develop/MonetDB/Feb2013/hgrepo/sql/backends/monet5/rel_bin.c, line 2310.
2013-08-12 13:09:13 MSG filerdata[74564]: could not find toc.total_overcapacity
2013-08-12 13:09:13 MSG filerdata[74564]: fv.function
2013-08-12 13:09:13 MSG filerdata[74564]: fv.L3
2013-08-12 13:09:13 MSG filerdata[74564]: fv.L4
2013-08-12 13:09:13 MSG filerdata[74564]: fv.function
2013-08-12 13:09:18 MSG merovingian[74552]: database 'filerdata' (74564) was killed by signal SIGABRT
It's really toy data:
sql>select count(*) from sys.filer_volumes;
+------+
| L1 |
+======+
| 192 |
+------+
1 tuple (0.882ms)
sql>select * from sys.filer_volumes limit 4;
+----------------+-----------+----------+---------+-----------+----------+
| filer | volume | claim_tb | used_tb | used_perc | function |
+================+===========+==========+=========+===========+==========+
| filer-1 | X/ | 63 | 62 | 99 | size |
| filer-2 | Y/ | 62 | 62 | 99 | size |
| filer-3 | A/ | 61 | 23 | 38 | size |
| filer-4 | B/ | 28 | 23 | 83 | size |
+----------------+-----------+----------+---------+-----------+----------+
4 tuples (1.864ms)
Comment 18999
Date: 2013-08-14 20:56:19 +0200
From: MonetDB Mercurial Repository <>
Changeset 3e860a8ce292 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=3e860a8ce292
Changeset description:
Comment 19000
Date: 2013-08-14 21:16:54 +0200
From: @njnes
fixed. You cannot use columns (of the inner query) after the groupby.
Comment 26783
Date: 2019-01-09 11:49:53 +0100
From: MonetDB Mercurial Repository <>
Changeset fa366cd68200 made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.
For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=fa366cd68200
Changeset description:
The text was updated successfully, but these errors were encountered: