Hello Team, Hello monetdb team, We have a table with 126 columns and approx. 94000 rows. We are trying to load approx 2500 records from temporary table into main table using query “insert into select” query. The database crashes upon query execution. No specific error is created in log file. When tried with 1500 records, it works. We also created another table with same DDL, that table is empty & inserted all the records from temp successfully without any issue. What could be the reason? Is 126 cols an issue? Please help. We are stuck. (btw: We have machine about 200GB of hard disk & 16 GB RAM (14 GB free)) Thank you [image: Description: Description: Description: Description: logo] * Souri Ratnaparkhi United Software Associates Pvt. Ltd. Pune, India Mob: 8975677255* * Phone (India Lines): (91) 020-25445550 **www.usain.com* http://www.usain.com/
Hello Souri, Hannes
On 04 Mar 2016, at 06:02, Souri Ratnaparkhi
wrote: We have a table with 126 columns and approx. 94000 rows. We are trying to load approx 2500 records from temporary table into main table using query “insert into select” query. The database crashes upon query execution. No specific error is created in log file.
we need some more details here. Which version of MonetDB, which operating system, what is the table structure and the query you run, can you share the dataset somehow? Generally, we would appreciate a minimal reproducible example and a bug report at http://bugs.monetdb.org Best,
When tried with 1500 records, it works. We also created another table with same DDL, that table is empty & inserted all the records from temp successfully without any issue.
What could be the reason? Is 126 cols an issue? Please help. We are stuck. 126 columns is no problem. I would be worried from 100,000 columns onwards.
participants (2)
-
Hannes Mühleisen
-
Souri Ratnaparkhi