SELECT id, name, schema_id, query, type, system, commit_action, readonly, temporary FROM tables WHERE name like '_tables';
-- this should return 2 rows.
select user
-- this should return 1 row with value: monetdb
mclient will not reproduce this behavior.
I also tested it via a dedicated Java test program, but could it also not reproduce.
So please download SQuirreL 3.6 (or copy it from /ufs/dinther/Downloads/squirrel-sql-3.6-standard.jar), install via:
java -jar squirrel-sql-3.6-standard.jar
Next start SQuirreL 3.6 via:
~/squirrel-sql-3.6/./squirrel-sql.sh
Date: 2014-11-28 12:56:15 +0100
From: Martin van Dinther <<martin.van.dinther>>
To: buildtools devs <>
Version: -- development
Last updated: 2015-01-29 14:07:32 +0100
Comment 20475
Date: 2014-11-28 12:56:15 +0100
From: Martin van Dinther <<martin.van.dinther>>
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:33.0) Gecko/20100101 Firefox/33.0
Build Identifier:
Making clean in ruby
make[2]: Entering directory
/ufs/dinther/BUILD/clients/ruby' Making clean in adapter make[3]: Entering directory
/ufs/dinther/BUILD/clients/ruby/adapter'rm -rf .libs _libs
test -z "activerecord-monetdb-adapter-0.1.gem" || rm -f activerecord-monetdb-adapter-0.1.gem
rm -f *.lo
[ '/ufs/dinther/dev/dev/clients/ruby/adapter' -ef . ] || rm -f 'lib/active_record/connection_adapters/monetdb_adapter.rb'
[ '/ufs/dinther/dev/dev/clients/ruby/adapter' -ef . ] || rm -f 'activerecord-monetdb-adapter-0.1.gemspec'
[ '/ufs/dinther/dev/dev/clients/ruby/adapter' -ef . ] || rmdir 'lib/active_record/connection_adapters'
rmdir: failed to remove ‘lib/active_record/connection_adapters’: No such file or directory
make[3]: *** [mostlyclean-local-activerecord-monetdb-adapter-0_1_gemspec] Error 1
make[3]: Leaving directory
/ufs/dinther/BUILD/clients/ruby/adapter' make[2]: *** [clean-recursive] Error 1 make[2]: Leaving directory
/ufs/dinther/BUILD/clients/ruby'make[1]: *** [clean-recursive] Error 1
make[1]: Leaving directory `/ufs/dinther/BUILD/clients'
make: *** [clean-recursive] Error 1
bash-4.2$
Reproducible: Always
Steps to Reproduce:
Actual Results:
first run of make clean finished normally.
second run:
bash-4.2$ make clean
Making clean in buildtools
make[1]: Entering directory
/ufs/dinther/BUILD/buildtools' Making clean in conf make[2]: Entering directory
/ufs/dinther/BUILD/buildtools/conf'rm -rf .libs _libs
test -z "" || rm -f
rm -f *.lo
make[2]: Leaving directory
/ufs/dinther/BUILD/buildtools/conf' make[2]: Entering directory
/ufs/dinther/BUILD/buildtools'rm -rf .libs _libs
test -z "" || rm -f
rm -f *.lo
make[2]: Leaving directory
/ufs/dinther/BUILD/buildtools' make[1]: Leaving directory
/ufs/dinther/BUILD/buildtools'Making clean in common
make[1]: Entering directory
/ufs/dinther/BUILD/common' Making clean in stream make[2]: Entering directory
/ufs/dinther/BUILD/common/stream'rm -rf .libs _libs
test -z "libstream.la" || rm -f libstream.la
rm -f ./so_locations
rm -f *.o
test -z "monetdb-stream.pc" || rm -f monetdb-stream.pc
rm -f *.lo
make[2]: Leaving directory
/ufs/dinther/BUILD/common/stream' Making clean in options make[2]: Entering directory
/ufs/dinther/BUILD/common/options'rm -rf .libs _libs
test -z "libmoptions.la" || rm -f libmoptions.la
rm -f ./so_locations
rm -f *.o
test -z "" || rm -f
rm -f *.lo
make[2]: Leaving directory
/ufs/dinther/BUILD/common/options' Making clean in utils make[2]: Entering directory
/ufs/dinther/BUILD/common/utils'rm -rf .libs _libs
test -z "libmcrypt.la libmutils.la libmsabaoth.la libmuuid.la" || rm -f libmcrypt.la libmutils.la libmsabaoth.la libmuuid.la
rm -f ./so_locations
rm -f *.o
test -z "" || rm -f
rm -f *.lo
make[2]: Leaving directory
/ufs/dinther/BUILD/common/utils' make[2]: Entering directory
/ufs/dinther/BUILD/common'rm -rf .libs _libs
test -z "" || rm -f
rm -f *.lo
make[2]: Leaving directory
/ufs/dinther/BUILD/common' make[1]: Leaving directory
/ufs/dinther/BUILD/common'Making clean in clients
make[1]: Entering directory
/ufs/dinther/BUILD/clients' Making clean in mapilib make[2]: Entering directory
/ufs/dinther/BUILD/clients/mapilib'rm -rf .libs _libs
test -z "libmapi.la" || rm -f libmapi.la
rm -f ./so_locations
rm -f *.o
test -z "monetdb-mapi.pc" || rm -f monetdb-mapi.pc
rm -f *.lo
make[2]: Leaving directory
/ufs/dinther/BUILD/clients/mapilib' Making clean in mapiclient make[2]: Entering directory
/ufs/dinther/BUILD/clients/mapiclient'rm -f mclient msqldump stethoscope tomograph
rm -rf .libs _libs
test -z "libmcutil.la" || rm -f libmcutil.la
rm -f ./so_locations
rm -f *.o
test -z "" || rm -f
rm -f *.lo
make[2]: Leaving directory
/ufs/dinther/BUILD/clients/mapiclient' Making clean in odbc make[2]: Entering directory
/ufs/dinther/BUILD/clients/odbc'Making clean in setup
make[3]: Entering directory
/ufs/dinther/BUILD/clients/odbc/setup' test -z "libMonetODBCs.la" || rm -f libMonetODBCs.la rm -f ./so_locations rm -rf .libs _libs rm -f *.o test -z "" || rm -f rm -f *.lo make[3]: Leaving directory
/ufs/dinther/BUILD/clients/odbc/setup'Making clean in driver
make[3]: Entering directory
/ufs/dinther/BUILD/clients/odbc/driver' test -z "libMonetODBC.la" || rm -f libMonetODBC.la rm -f ./so_locations rm -rf .libs _libs rm -f *.o test -z "ODBC.def" || rm -f ODBC.def rm -f *.lo make[3]: Leaving directory
/ufs/dinther/BUILD/clients/odbc/driver'Making clean in samples
make[3]: Entering directory
/ufs/dinther/BUILD/clients/odbc/samples' rm -f arraytest odbcsample1 testgetinfo rm -rf .libs _libs rm -f rm -f *.o test -z "" || rm -f rm -f *.lo make[3]: Leaving directory
/ufs/dinther/BUILD/clients/odbc/samples'make[3]: Entering directory
/ufs/dinther/BUILD/clients/odbc' rm -rf .libs _libs test -z "" || rm -f rm -f *.lo make[3]: Leaving directory
/ufs/dinther/BUILD/clients/odbc'make[2]: Leaving directory
/ufs/dinther/BUILD/clients/odbc' Making clean in perl make[2]: Entering directory
/ufs/dinther/BUILD/clients/perl'Making clean in MonetDB-CLI-MapiPP
make[3]: Entering directory
/ufs/dinther/BUILD/clients/perl/MonetDB-CLI-MapiPP' Making clean in MonetDB make[4]: Entering directory
/ufs/dinther/BUILD/clients/perl/MonetDB-CLI-MapiPP/MonetDB'Making clean in CLI
make[5]: Entering directory
/ufs/dinther/BUILD/clients/perl/MonetDB-CLI-MapiPP/MonetDB/CLI' rm -rf .libs _libs test -z "" || rm -f rm -f *.lo make[5]: Leaving directory
/ufs/dinther/BUILD/clients/perl/MonetDB-CLI-MapiPP/MonetDB/CLI'make[5]: Entering directory
/ufs/dinther/BUILD/clients/perl/MonetDB-CLI-MapiPP/MonetDB' rm -rf .libs _libs test -z "" || rm -f rm -f *.lo make[5]: Leaving directory
/ufs/dinther/BUILD/clients/perl/MonetDB-CLI-MapiPP/MonetDB'make[4]: Leaving directory
/ufs/dinther/BUILD/clients/perl/MonetDB-CLI-MapiPP/MonetDB' make[4]: Entering directory
/ufs/dinther/BUILD/clients/perl/MonetDB-CLI-MapiPP'rm -rf .libs _libs
test -z "" || rm -f
rm -f *.lo
make[4]: Leaving directory
/ufs/dinther/BUILD/clients/perl/MonetDB-CLI-MapiPP' make[3]: Leaving directory
/ufs/dinther/BUILD/clients/perl/MonetDB-CLI-MapiPP'Making clean in MonetDB-CLI
make[3]: Entering directory
/ufs/dinther/BUILD/clients/perl/MonetDB-CLI' Making clean in MonetDB make[4]: Entering directory
/ufs/dinther/BUILD/clients/perl/MonetDB-CLI/MonetDB'rm -rf .libs _libs
test -z "" || rm -f
rm -f *.lo
make[4]: Leaving directory
/ufs/dinther/BUILD/clients/perl/MonetDB-CLI/MonetDB' make[4]: Entering directory
/ufs/dinther/BUILD/clients/perl/MonetDB-CLI'rm -rf .libs _libs
test -z "" || rm -f
rm -f *.lo
make[4]: Leaving directory
/ufs/dinther/BUILD/clients/perl/MonetDB-CLI' make[3]: Leaving directory
/ufs/dinther/BUILD/clients/perl/MonetDB-CLI'Making clean in DBD
make[3]: Entering directory
/ufs/dinther/BUILD/clients/perl/DBD' Making clean in monetdb make[4]: Entering directory
/ufs/dinther/BUILD/clients/perl/DBD/monetdb'rm -rf .libs _libs
test -z "" || rm -f
rm -f *.lo
make[4]: Leaving directory
/ufs/dinther/BUILD/clients/perl/DBD/monetdb' make[4]: Entering directory
/ufs/dinther/BUILD/clients/perl/DBD'rm -rf .libs _libs
test -z "" || rm -f
rm -f *.lo
make[4]: Leaving directory
/ufs/dinther/BUILD/clients/perl/DBD' make[3]: Leaving directory
/ufs/dinther/BUILD/clients/perl/DBD'Making clean in Tests
make[3]: Entering directory
/ufs/dinther/BUILD/clients/perl/Tests' rm -rf .libs _libs test -z "malsample.pl sqlsample.pl" || rm -f malsample.pl sqlsample.pl rm -f *.lo make[3]: Leaving directory
/ufs/dinther/BUILD/clients/perl/Tests'make[3]: Entering directory
/ufs/dinther/BUILD/clients/perl' rm -rf .libs _libs test -z "" || rm -f rm -f *.lo make[3]: Leaving directory
/ufs/dinther/BUILD/clients/perl'make[2]: Leaving directory
/ufs/dinther/BUILD/clients/perl' Making clean in php make[2]: Entering directory
/ufs/dinther/BUILD/clients/php'Making clean in lib
make[3]: Entering directory
/ufs/dinther/BUILD/clients/php/lib' rm -rf .libs _libs test -z "" || rm -f rm -f *.lo make[3]: Leaving directory
/ufs/dinther/BUILD/clients/php/lib'make[3]: Entering directory
/ufs/dinther/BUILD/clients/php' rm -rf .libs _libs test -z "" || rm -f rm -f *.lo make[3]: Leaving directory
/ufs/dinther/BUILD/clients/php'make[2]: Leaving directory
/ufs/dinther/BUILD/clients/php' Making clean in ruby make[2]: Entering directory
/ufs/dinther/BUILD/clients/ruby'Making clean in adapter
make[3]: Entering directory
/ufs/dinther/BUILD/clients/ruby/adapter' rm -rf .libs _libs test -z "activerecord-monetdb-adapter-0.1.gem" || rm -f activerecord-monetdb-adapter-0.1.gem rm -f *.lo [ '/ufs/dinther/dev/dev/clients/ruby/adapter' -ef . ] || rm -f 'lib/active_record/connection_adapters/monetdb_adapter.rb' [ '/ufs/dinther/dev/dev/clients/ruby/adapter' -ef . ] || rm -f 'activerecord-monetdb-adapter-0.1.gemspec' [ '/ufs/dinther/dev/dev/clients/ruby/adapter' -ef . ] || rmdir 'lib/active_record/connection_adapters' rmdir: failed to remove ‘lib/active_record/connection_adapters’: No such file or directory make[3]: *** [mostlyclean-local-activerecord-monetdb-adapter-0_1_gemspec] Error 1 make[3]: Leaving directory
/ufs/dinther/BUILD/clients/ruby/adapter'make[2]: *** [clean-recursive] Error 1
make[2]: Leaving directory
/ufs/dinther/BUILD/clients/ruby' make[1]: *** [clean-recursive] Error 1 make[1]: Leaving directory
/ufs/dinther/BUILD/clients'make: *** [clean-recursive] Error 1
bash-4.2$
Expected Results:
no error when make clean is run multiple times
Comment 20487
Date: 2014-11-28 18:52:59 +0100
From: Martin van Dinther <<martin.van.dinther>>
I have done a run where I started mserver5 with --trace, so using:
./INSTALL/bin/mserver5 --trace
The trace output file is too large to attach (3MB), but you can read it from /ufs/dinther/trace_2014_11_28.out
I used SQuirreL 3.6 (http://www.squirrelsql.org/installation) to issue the following SQL queries:
-- this should return 2 rows.
-- this should return 1 row with value: monetdb
mclient will not reproduce this behavior.
I also tested it via a dedicated Java test program, but could it also not reproduce.
So please download SQuirreL 3.6 (or copy it from /ufs/dinther/Downloads/squirrel-sql-3.6-standard.jar), install via:
java -jar squirrel-sql-3.6-standard.jar
Next start SQuirreL 3.6 via:
~/squirrel-sql-3.6/./squirrel-sql.sh
setup a Driver and create a Connection Alias, see https://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/Clients/SQuirreL for instructions
Comment 20489
Date: 2014-11-28 18:54:57 +0100
From: Martin van Dinther <<martin.van.dinther>>
ignore the previous comment 1. it belongs to bug #3631.
Comment 20561
Date: 2015-01-20 10:53:04 +0100
From: MonetDB Mercurial Repository <>
Changeset 1f0944853528 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=1f0944853528
Changeset description:
Comment 20600
Date: 2015-01-29 14:07:32 +0100
From: @sjoerdmullender
Oct2014-SP2 has been released.
The text was updated successfully, but these errors were encountered: