Hello,
I don't know if it's appropriate, but because I can't register monetdb's bugzilla, I'm going to report a bug here. This problem causes the insert statement to hang and mserver5 takes up 100% of the CPU time. Here is the code that caused the problem:
Create table a(a int, b int, id bigserial);
-- comment any of the next 2 lines will resolve the problem Create ordered index a_pk on a(id); Create index a_idx1 on a(a);
Insert into a(a) values(1); -- this line will hang
Enviroment: macOS Catalina 10.15 MonetDB v11.33.11
I hope the development team can check if there is this problem.
Thank you
There is indeed a problem (server crash) when doing this. However, there is no point in creating an ordered index and then appending to a column: the ordered index necessarily has to be removed when the table is changed. This is because the index contains ordering information on the column which changes in such a way that the index cannot be maintained.
On 03/11/2019 04.35, lhy1149 wrote:
Hello,
I don't know if it's appropriate, but because I can't register monetdb's bugzilla, I'm going to report a bug here. This problem causes the insert statement to hang and mserver5 takes up 100% of the CPU time. Here is the code that caused the problem:
Create table a(a int, b int, id bigserial);
-- comment any of the next 2 lines will resolve the problem Create ordered index a_pk on a(id); Create index a_idx1 on a(a);
Insert into a(a) values(1); -- this line will hang
Enviroment: macOS Catalina 10.15 MonetDB v11.33.11
I hope the development team can check if there is this problem.
Thank you _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
On 3 Nov 2019, at 04:35, lhy1149 lhy1149@gmail.com wrote:
Hello,
I don't know if it's appropriate, but because I can't register monetdb's bugzilla,
Hai,
What’s the reason that you can’t register? Did you get any error message? With which email address have you tried to register? We have noticed that with a Gmail address, it can take (>8) hours before the registration confirmation arrives.
I'm going to report a bug here. This problem causes the insert statement to hang and mserver5 takes up 100% of the CPU time. Here is the code that caused the problem:
Pedro created a bug for this:
https://www.monetdb.org/bugzilla/show_bug.cgi?id=6781
We’ll fix the crash.
But to actually have any benefit from the index, please see what Sjoerd has already explained.
Regards, Jennie
Create table a(a int, b int, id bigserial);
-- comment any of the next 2 lines will resolve the problem Create ordered index a_pk on a(id); Create index a_idx1 on a(a);
Insert into a(a) values(1); -- this line will hang
Enviroment: macOS Catalina 10.15 MonetDB v11.33.11
I hope the development team can check if there is this problem.
Thank you _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (3)
-
lhy1149 -
Sjoerd Mullender -
Ying Zhang