Hi, I' trying to perform a big insert of about 4 mil rows of data: insert into clustertable1(keyword, p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31,p32,p33,p34,p35,p36,p37,p38,p39,p40,p41,p42,p43,p44,p45,p46,p47,p48,p49,p50) select keyword,p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31,p32,p33,p34,p35,p36,p37,p38,p39,p40,p41,p42,p43,p44,p45,p46,p47,p48,p49,p50 from cluster_submaster where cluster_no = '0'; But the moment I fire this query, the server crashes with the below printed in the logs: 2017-01-25 10:05:11 MSG kwresearch[3418]: # Visit http://www.monetdb.org/ for further information 2017-01-25 10:05:11 MSG kwresearch[3418]: # Listening for UNIX domain connection requests on mapi:monetdb:///monetDB/myfarm/kwresearch/.mapi.sock 2017-01-25 10:05:11 MSG kwresearch[3418]: # MonetDB/SQL module loaded 2017-01-25 10:07:06 MSG merovingian[3201]: proxying client (local) for database 'kwresearch' to mapi:monetdb:///monetDB/myfarm/kwresearch/.mapi.sock?database=kwresearch 2017-01-25 10:07:06 MSG merovingian[3201]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying 2017-01-25 10:07:06 MSG merovingian[3201]: proxying client (local) for database 'kwresearch' to mapi:monetdb:///monetDB/myfarm/kwresearch/.mapi.sock?database=kwresearch 2017-01-25 10:07:06 MSG merovingian[3201]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying 2017-01-25 10:07:12 MSG merovingian[3201]: database 'kwresearch' (3418) was killed by signal SIGSEGV Appreciate any help! Thanks, Shrihari ******************* iquanti.com E-Mail Domain LEGAL DISCLAIMER ******************* This E-Mail may contain confidential and/or legally privileged Information and is meant for the intended recipient(s) only. If you have received this e-mail in error and are not the intended recipient/s, kindly notify us at it@iquanti.com and then delete this e-mail immediately from your system. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail, its contents or its attachment/s other than by its intended recipient/s is strictly prohibited and may be unlawful.
Hi On 25/01/2017 12:10, Shrihari Shastry wrote:
Hi,
I' trying to perform a big insert of about 4 mil rows of data: Where you able to insert 1 row?
insert into clustertable1(keyword, p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31,p32,p33,p34,p35,p36,p37,p38,p39,p40,p41,p42,p43,p44,p45,p46,p47,p48,p49,p50) This looks like a syntax error.
select keyword,p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31,p32,p33,p34,p35,p36,p37,p38,p39,p40,p41,p42,p43,p44,p45,p46,p47,p48,p49,p50 from cluster_submaster where cluster_no = '0';
But the moment I fire this query, the server crashes with the below printed in the logs:
2017-01-25 10:05:11 MSG kwresearch[3418]: # Visit http://www.monetdb.org/ for further information 2017-01-25 10:05:11 MSG kwresearch[3418]: # Listening for UNIX domain connection requests on mapi:monetdb:///monetDB/myfarm/kwresearch/.mapi.sock 2017-01-25 10:05:11 MSG kwresearch[3418]: # MonetDB/SQL module loaded 2017-01-25 10:07:06 MSG merovingian[3201]: proxying client (local) for database 'kwresearch' to mapi:monetdb:///monetDB/myfarm/kwresearch/.mapi.sock?database=kwresearch 2017-01-25 10:07:06 MSG merovingian[3201]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying 2017-01-25 10:07:06 MSG merovingian[3201]: proxying client (local) for database 'kwresearch' to mapi:monetdb:///monetDB/myfarm/kwresearch/.mapi.sock?database=kwresearch 2017-01-25 10:07:06 MSG merovingian[3201]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying 2017-01-25 10:07:12 MSG merovingian[3201]: database 'kwresearch' (3418) was killed by signal SIGSEGV
Appreciate any help!
Thanks, Shrihari
******************* iquanti.com E-Mail Domain LEGAL DISCLAIMER ******************* This E-Mail may contain confidential and/or legally privileged Information and is meant for the intended recipient(s) only. If you have received this e-mail in error and are not the intended recipient/s, kindly notify us at it@iquanti.com and then delete this e-mail immediately from your system. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail, its contents or its attachment/s other than by its intended recipient/s is strictly prohibited and may be unlawful. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Martin Kersten -
Shrihari Shastry