On 3 Nov 2019, at 04:35, lhy1149 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