Restore/Load just hangs for hours (Windows Jan2014)
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.
Hi, Whatever it is doing can not be seen, indeed. I would normally use the mclient tool with the echo input feature to see how far I am in re-running a dump and to understand what it is doing. A hinge, it might be locked up in building a hash/join index on a box with insufficient memory, leading large numbers of small disk accesses. regards,Martin On 27/03/14 13:36, Bryan Senseman wrote:
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 https://www.monetdb.org/mailman/listinfo/users-list
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
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>\
---------------------------------------------------------------------- ---------------------------------------------------------------------- ---------------------------------------------------------------------- ----------------------------------------------
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 https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ 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.
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.
participants (2)
-
Bryan Senseman -
Martin Kersten