Is the attached representative of the creating a hash/index without enough
memory?
-----Original Message-----
From: Bryan Senseman [mailto:monetdb@openbi.com]
Sent: Thursday, March 27, 2014 11:58 AM
To: 'Communication channel for MonetDB users'
Subject: RE: Restore/Load just hangs for hours (Windows Jan2014)
Martin,
It failed on a grant in the end and rolled back everything :( See Below:
An improvement suggestion; commit after all the data is loaded then attempt
grants, waiting ~24 hours to find out I forgot to create a role in the new
database is painful.
Bryan
Welcome to mclient, the MonetDB/SQL interactive terminal (Jan2014)
Database: MonetDB v11.17.9 (Jan2014), 'iis_bi_reporting'
Type \q to quit, \? for a list of available commands auto commit mode: on
sql>set schema iis_bi_reporting;
auto commit mode: on
sql>\
For about 3 hours I saw cyclical activity on memory and disk when
loading the 55GB dump file (created on Linux via \D), however for the last 12 hours it has just sat there doing nothing. No CPU activity, no disk; this happened last time and I believe after 17 hours of "nothing" it popped up with a series of "operation completed" messages, what is it doing?
----------------------------------------------------------------------
----------------------------------------------------------------------
----------------------------------------------------------------------
----------------------------------------------
This transmission is confidential and intended solely for the use of
the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.
_______________________________________________
users-list mailing list
users-list@monetdb.org
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list -- ------------------------------ This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.
