[MonetDB-users] SQL database recovery
Somehow I've managed to get MonetDB into a state that the sql_server does not startup sucessfully. Steps leading up to the failure were: 1. delete 49M rows from a table 2. reload 49M rows into table using COPY INTO 3. did select count(*) on table. 4. looked at sql_logs and noticed one of the files was approximately 5G. 5. killed monet process 6. restarted monet. I waited for about 30 minutes and the SQL frontend never responded. Normally steps 5 and 6 take about 8 minutes. Questions. 1. Is there a cleaner way to shutdown monet besides killing the process? I tried "commit();" before the shutdown but that never seems to decrease the initialization time. 2. what debug settings should I turn on to determine what is failing during --dbinit="module(sql_server)" ? 3. I noticed that there are several (700M) .buns files associated with a table that I had deleted all rows from before the restart. ls() reports a zero count but why are the files still that large?
participants (1)
-
Colin Foss