Connection reset when using DOT_PRODUCT

Help Query Tuning
1

Hey team,

I’m currently tinkering with the vector side of it (awesome, by the way!) and having an issue.

Take my query:

SELECT `title`, `path`, DOT_PRODUCT(embeddings, JSON_ARRAY_PACK('[-0.012726239,-0.018567327,0.00456776,-0.008825124,-0.019371536,0.019159902,-0.01413713,-0.018355694,0.012676857,-0.016309902,0.015054209,0.008535892,-0.014588615,-0.019286882,-0.0024320236,0.015322278,0.028697526,-0.01206312,0.007886882,-0.011576362,-0.0110472785,0.01439109,0.016450992,-0.0004336286,-0.019216338,-0.008183169,0.014440471,-0.024351982,-0.0073577976,-0.0036101178,0.028683418,0.0030228344,-0.032732677,-0.01542104,-0.028852725,0.0006723778,0.004243255,-0.0048040845,0.012895546,-0.016211139,0.009170793,0.02034505,0.0092554465,-0.0055730203,-0.020768318,0.0134175755,0.0011569308,-0.010475867,-0.00414802,0.006796968,0.01453218,0.020076983,-0.017170547,0.0055412753,-0.013022526,0.021036388,-0.019512625,0.004426671,0.012556932,-0.025226735,-0.022715349,0.009904456,-0.029854458,-0.0060985773,-0.00041312657,-0.00228388,-0.01095557,0.004811139,-0.0066311886,-0.011837377,0.018877724,0.0074706688,-0.019230448,-0.0053719683,0.00953057,-0.020768318,-0.022263862,-0.006352538,0.0027900373,0.0073013618,0.0019223392,-0.038037628,-0.019202229,0.027597032,-0.007428342,0.010920298,0.007364852,0.007336634,-0.030051982,-0.013262377,0.027145546,0.01478614,0.0042467825,0.005893998,-0.023646537,0.012183045,-0.018525,0.0151106445,0.016013615,-0.01101906,-0.012049011,0.026397774,-0.023449011,-0.02452129,-0.0012989017,0.01712822,0.028951487,-0.0034566834,-0.002119864,0.005721164,-0.054403964,0.029149013,0.007005075,-0.00437729,-0.0021498455,0.0015669711,-0.025974507,-0.0022627166,-0.041677725,-0.009445917,0.01464505,0.015928961,0.026101487,-0.005555384,0.0029134904,0.008514728,-0.025480695,-0.007322525,0.01697302,-0.0033685027,0.046898022,-0.01853911,0.02593218,-0.00829604,-0.03205545,0.03758614,-0.012803838,0.01945619,-0.03501832,-0.0017786047,-0.012168936,0.03848911,-0.01801708,0.008119679,0.015124754,0.03436931,0.02763936,-0.013057798,0.021346783,-0.027512379,-0.009678714,0.0027477106,0.013071907,-0.0069521666,0.0011154859,-0.003774134,0.00881807,0.01011609,-0.0057952357,-0.017311634,0.014341709,0.01671906,0.006835768,0.0026789296,-0.00046118506,0.009855075,0.02710322,0.015477477,-0.0030722155,-0.01154109,0.007957426,0.00603156,-0.02799208,0.009029703,-0.0235901,0.024267329,-0.012451115,0.017043566,-0.016267575,-0.013840843,0.00437729,-0.011851486,0.041705944,0.014017204,-0.04486634,-0.019300992,0.0028429457,-0.0073577976,0.0013041926,-0.01999233,-0.0057352725,0.020472031,0.0014752632,-0.0022503715,-0.6695525,-0.006945112,0.013643318,-0.037021786,0.0013218287,0.03775545,0.01855322,-0.0018905943,-0.034595054,0.010236016,-0.013862006,0.04201634,0.016436882,-0.013516338,-0.0013826734,-0.020965843,0.012415842,-0.0024390782,-0.022785893,0.0089521045,-2.6350874e-6,0.0016198795,0.0003280322,-0.00093736086,0.01413713,-0.012803838,-0.022489605,-0.0028958542,-0.006821659,0.02282822,-0.015928961,0.006419555,-0.0030404706,-0.011985521,0.06450594,0.022024011,-0.025918072,0.04060545,-0.003107488,0.069415845,-0.014870794,0.0010802136,0.010236016,0.036711387,0.009142575,0.004574815,-0.0031445238,0.021501983,0.015660893,-0.007273144,0.012429952,-0.0062431935,-0.0010907953,0.01439109,0.017297527,-0.0027653468,0.0052732057,0.0006415146,0.002590749,0.022673022,0.00096205145,0.0017900682,-0.010934407,-0.027935646,0.020260397,0.003426702,-0.02621436,-0.008006807,-0.00030488477,-0.0039011142,0.011442328,0.022404952,-0.00042436962,-0.0085782185,0.0061479583,0.026482427,0.0015308169,-0.02412624,-0.036711387,0.004049258,0.0046488866,-0.013600991,-0.035328716,-0.013227105,0.017791338,-0.0049910275,-0.014207674,0.0011075496,0.020175744,0.026030943,0.004239728,0.018525,-0.015646784,-0.0021533726,-0.030447032,0.025537131,-0.016803714,0.027836883,0.01763614,-0.012013739,-0.014384036,-0.0071214736,0.0032979583,0.006405446,0.013036635,0.003111015,-0.015011882,0.015378714,0.05982179,-0.026567081,0.022743566,0.019174011,0.011265966,-0.022334408,-0.0009673423,-0.035780203,-0.0032732675,0.0043525994,0.03281733,-0.020429704,0.018355694,-0.010652228,0.018002972,-0.024874011,0.016789606,0.025762873,-0.0024955138,-0.024041586,0.022715349,-0.01866609,0.013403466,-0.010934407,0.01530817,-0.024577724,0.011265966,-0.022066338,0.020048764,0.012973145,-5.924641e-5,-0.008846288,-0.03710644,0.01633812,-0.013071907,-0.031067824,-0.00992562,-0.0059680697,-0.016676733,0.00085050287,-0.015251734,0.001279502,0.009742204,-0.016648516,-0.0014567452,0.00086108455,0.023307923,-0.0051744436,0.0010220143,-0.02449307,0.0049733915,-0.03992822,-0.0013967822,0.0022715349,-0.021360893,0.013262377,0.01674728,-0.003929332,-0.038855944,-0.015251734,0.006931003,-0.02335025,0.009939728,-0.016944803,0.0019152848,0.019103467,0.009713986,0.0151106445,-0.021741834,-0.028697526,0.0055765472,0.0074071786,0.00075262226,-0.010588738,-0.014461635,0.0022415535,0.017988862,0.00082978036,0.009551734,0.003220359,-0.015181189,0.02670817,-0.0010123145,0.0025872218,-0.0021798268,0.013396412,0.0038411513,0.013770298,0.0018570855,0.025410151,0.009805694,0.009495297,0.026764605,-0.014369926,0.034679707,-0.020500248,-0.0064583546,-0.035244063,0.013720917,-0.03137822,0.012521659,0.0006701733,-0.013692699,-0.00049645733,-0.015322278,0.0044160895,0.02464827,0.027455943,-0.011802105,-0.012980199,-0.0044160895,-0.020401487,0.01700124,-0.039335646,0.013777353,0.0020599011,0.015040101,0.014130075,-0.024732923,0.023505447,0.013685645,-0.012422897,5.8640166e-5,-0.013241214,0.014757922,0.0016066524,0.03304307,0.019794803,0.003102197,-0.028443567,0.03267624,-0.0014470452,0.020161634,0.020048764,0.0048534656,0.012161883,0.010729828,-0.00615854,0.008126733,-0.0071250005,-0.014461635,0.020330941,-0.007110892,0.012789729,-0.030221289,0.0046488866,-0.0018817761,-0.004969864,0.021685397,0.009283664,0.014588615,0.031039607,-0.021022279,-0.016930694,-0.009227228,-0.013911387,0.007505941,0.0022591895,0.005632983,-0.005696473,-0.0058128717,-0.015364605,0.010631065,-0.013410521,0.0038411513,-0.016803714,0.021953467,0.011597525,0.014080694,0.008987377,-0.018482674,0.01893416,-0.010631065,-0.02763936,0.020965843,0.019696042,0.0006128559,-0.0068322406,-0.015759654,-0.010447649,-0.016535645,0.02243317,-0.0024937503,0.022503715,-0.0014973083,-0.019512625,0.015858417,0.016493319,0.016648516,-0.015985398,-0.0021727725,-0.0016877786,0.011378838,0.009812748,-0.015900744,-0.03995644,0.017622031,0.025311388,-0.021106932,-0.005491894,-0.014842575,0.001014078,-0.0068322406,0.00022838802,-0.025833419,-0.029544061,0.03874307,-0.010038491,-0.0086276,-0.004253837,0.008310149,0.028500002,-0.015068318,-0.019131685,-0.029261883,0.007957426,0.056830697,-0.020020546,-0.0064936266,0.0026983295,-0.018849507,-0.023773517,-0.041480202,-0.0038940597,0.02735718,-0.010257179,-0.007781065,0.0071567455,-0.0076823025,-0.0049416465,0.018186387,0.008253713,-0.0034602107,-0.009523516,-0.008684035,-0.0029170176,0.0042150375,-0.016408665,0.031096041,0.025452478,0.02243317,-0.0022926982,0.022376735,0.0026383665,0.012980199,-0.021995794,-0.01304369,0.034707922,0.007322525,0.021360893,-0.00037322482,0.008479456,0.0070756194,0.030898517,0.004871102,-0.014461635,0.023717081,0.017706685,0.02463416,-0.014257056,-0.019442081,-0.010334778,-0.007929209,0.014426363,-0.008218441,-0.016013615,0.008204333,-0.0085782185,-0.0023244433,-0.02192525,0.018214606,0.022785893,0.022066338,-0.021558417,-0.020062873,-0.038065843,0.0070509287,-0.0052873148,-0.005834035,-0.006313738,-0.016831933,-0.018962378,-0.009248392,-0.0038129336,-0.028189607,0.0024514236,-0.010652228,0.01568911,-0.0052379337,0.011802105,0.011879704,0.00041290614,0.008514728,-0.01738218,0.0039152233,0.02634134,0.0010669865,-0.007992699,-0.011964357,-0.018101733,-0.005689419,0.016098268,-0.00048323022,-0.008366585,-0.031829704,0.009523516,-0.00050262996,-0.018496783,0.026567081,-0.017720794,0.0055906563,-0.0052837874,0.0028623454,0.02631312,0.008020916,-0.011534035,-0.0011578125,-0.028485894,-0.008225496,-0.012578095,-0.014743813,0.012472278,0.004931065,0.00875458,-0.01173156,-0.0033720299,0.030108418,-0.026990348,-0.0047547035,0.00034412518,-0.0056682555,0.010017328,-0.013438739,0.0037882428,0.0034196475,0.0030722155,-0.00013811303,-0.03448218,0.0075553223,0.029402973,0.0007041229,0.01225359,-0.006264357,-0.017198764,0.024027478,-0.011202476,-0.02179827,0.015576239,-0.015576239,0.020133417,-0.013347031,-0.014278219,0.022870546,0.011230694,-0.012239481,-0.017057674,-0.03151931,0.012528714,-0.002105755,-0.003742389,0.016154705,-0.03733218,-0.0072061266,0.01439109,-0.008606437,0.022926982,-0.006638243,-0.025635893,0.0002938622,-0.02903614,-0.016944803,-0.031434655,0.0013183014,0.0074495054,0.034820795,0.020147527,0.0229552,0.00027402153,0.022136884,-0.026510645,0.011724506,0.0022680075,-0.0013209468,-0.0048464113,-0.02021807,-0.011174258,-0.0016234067,0.013720917,0.01141411,-0.026242577,8.9558525e-5,0.014313491,-0.017875992,-0.01879307,0.0005687655,-0.032648023,0.013149506,0.010560521,-0.02203812,0.0035713182,-0.041818816,-0.008528837,0.0072378716,-0.004257364,0.0029822714,-0.009671659,0.010355941,-0.0120983925,0.026468318,-0.004454889,0.013149506,0.015265843,-0.020034656,-0.025974507,0.0023191525,0.030813864,0.018341586,0.0091214115,-0.010066709,0.011124877,-0.024605943,0.02319505,-0.018990595,0.017184654,-0.0016754332,-0.026552971,0.0036506809,0.0044972156,0.010024382,-0.01568911,0.009516461,-0.012458169,-0.017325744,0.027470052,-0.014673268,-0.003294431,0.02282822,-0.017734902,0.021741834,0.00609505,0.012782674,-0.0008888615,-0.0053296415,-0.0073507433,-0.02737129,-0.0008125852,0.019047031,0.01089208,0.008006807,-0.0010960861,-0.0042467825,0.030559903,0.00726609,-0.04108515,-0.02308218,0.016817823,0.004761758,0.00953057,-0.0084089115,-0.015265843,-0.012825001,0.011357674,-0.005195607,0.006253775,0.0055483296,0.002174536,-0.019921783,-0.008387748,-0.017043566,0.025565349,0.0007790765,-0.019089358,0.00051100715,-0.004610087,-0.014489853,-0.0020704828,0.012465224,0.009777476,0.019879457,-0.02154431,0.039392084,-0.0007689357,-0.0146027235,-0.005294369,-0.0018094679,0.02749827,-0.027921537,0.0033244123,0.0045430698,-0.006271411,0.017734902,0.0014100093,-0.015675,-0.03422822,0.0028217824,-0.013833788,0.012415842,0.023293814,-0.008620545,-0.008472402,-0.0052732057,-0.012387625,-0.014123021,-0.004744122,-0.008592327,-0.02138911,-0.005957488,-0.01855322,0.012274753,0.008035026,0.00914963,0.016493319,0.004394926,0.028217824,-0.032450497,0.000154206,-0.015195298,0.0022574258,-0.009163738,0.004282055,-0.007364852,0.00015652075,0.021840597,-0.0008214032,-0.02634134,-0.0010740409,-0.005269679,0.02306807,0.019611388,0.021713616,0.0011983757,0.00843713,-0.005788181,-0.025494805,-0.026962131,0.007117946,-0.022404952,0.01212661,0.017043566,-0.017650248,-0.0038799508,0.0029399446,0.019032922,0.036937132,-0.03953317,-0.00856411,0.0008566755,0.0013712099,0.0024708232,-0.0024567144,-0.008698144,0.005460149,-0.026045052,0.029233666,0.0164651,-0.011336511,-0.011752724,0.011978466,0.00045236698,0.025748765,-0.022531932,0.0051426985,-0.03538515,-0.01101906,-0.037811883,-0.0032097774,-0.008803961,0.045063864,0.024168566,-0.007957426,-0.020514358,-0.015533912,-0.019174011,-0.0018447402,0.0073719067,-0.00075129955,0.03659852,0.004574815,0.00011981552,-0.010278342,-0.0029963802,0.0039716586,-0.022165101,-0.0045571784,-0.015646784,0.0015546257,0.006931003,0.02154431,0.0033332305,0.023971042,0.03606238,-0.007548268,0.030757427,0.013544556,-0.03346634,-0.004751176,0.004888738,0.006959221,-0.0017142328,0.013516338,0.02608738,-0.043935154,-0.014842575,-0.0024637687,-0.010680446,-0.030785646,0.0046594683,0.004839357,-0.011618689,0.018087626,-0.016055942,-0.019300992,0.0013306468,-0.010885025,0.028669309,-0.0402104,-0.011597525,0.012585149,0.0032274136,-0.0016983603,-0.026143814,0.012359407,0.0017856591,-0.024549507,-0.01231708,-0.027300745,-0.01803119,-0.006232612,0.020006437,-0.012613367,0.00550953,-0.029600497,-0.0034249383,-0.02452129,-0.013149506,0.0034372837,-0.0406901,-0.0111530945,0.0017036512,0.010581684,0.009361263,-0.0129026,0.00084300747,0.0043349634,-0.017805448,0.015858417,-0.013749135,-0.025621785,-0.008246659,0.008345421,-0.0031357056,0.027018566,0.186802,-0.0051744436,-0.0022098084,0.022362625,-0.012959036,0.0064900997,-0.004243255,-0.0074071786,-0.02335025,0.010588738,-0.0017142328,-0.003426702,-0.011787996,-0.0033879024,0.011181313,-0.008091461,-0.021600744,-0.015590347,-0.05149753,-0.016761387,0.023942824,0.00456776,-0.011004952,0.002225681,0.01671906,0.0053437506,0.027201982,0.021953467,0.006715842,0.022926982,-0.006652352,-0.0037247527,-0.010313614,-0.0010810954,-0.015025991,0.0007808401,0.023956932,-0.016013615,0.01828515,-0.016620299,0.012923763,-0.010687501,0.022263862,-0.022108665,0.007957426,-0.0006318147,0.005001609,-0.019145794,0.03594951,-0.005227352,-0.03137822,-0.03617525,0.00014803334,0.022588369,0.017396288,0.0012477569,-0.0033226488,0.006669988,0.0012556931,0.009354209,-0.019117575,0.019244555,-0.025776982,0.0013597464,-0.016775496,-0.0022292081,-0.011273021,-0.012472278,0.022489605,-0.016309902,-5.6766326e-5,-0.014715595,-0.019569062,-0.018722527,0.0007332225,-0.028203715,-0.0105746295,0.012147773,0.04497921,0.012041956,0.014003095,0.007830447,-0.008923887,-0.0151106445,-2.1287373e-5,-0.027653467,0.024930447,-0.0077951737,-0.019216338,0.016916586,-0.006239666,-0.0019311573,-0.0068569314,-0.017156437,0.021360893,0.0068745674,-0.0120983925,0.017593814,-0.009615224,0.0089521045,-0.036937132,0.0492401,-0.003745916,-0.0069556935,-0.005100372,0.017170547,-0.00150789,0.007117946,0.011632798,-0.007491832,0.0152799515,-0.007654085,0.0006177058,0.005756436,-0.011195421,0.0065676984,-0.0040527848,-0.019484408,0.014927229,-0.0026154395,0.009601114,-0.01322005,-0.0064266096,-0.005336696,0.009833911,0.021727724,-0.005957488,-0.0039222776,0.023307923,-0.016690843,0.035526242,-0.005340223,-0.009848021,-0.014475743,-0.0010537594,-0.014560397,0.017664358,-0.029007923,-0.0044337255,0.018510893,0.0129096545,0.019371536,0.003056343,-0.004380817,0.012754456,-0.0061338493,0.016944803,0.009650496,-0.007322525,-0.016309902,-0.012973145,0.01302958,-0.013311759,-0.011428218,0.028330695,-0.037416834,-0.00940359,-0.025635893,0.017565595,0.018750744,-0.030277725,-0.014701487,0.031547528,-0.029459408,-0.013481066,-0.023942824,-0.18454456,0.0084089115,0.006966275,-0.028302478,0.013699753,-0.0088815605,0.009269555,0.009960892,-0.020725992,0.01413713,0.025325498,-0.010236016,-0.041254457,-0.028697526,0.011900867,-0.0050862627,-0.008641709,0.00829604,0.014278219,0.022800002,0.02477525,-0.016775496,0.009805694,-0.012874383,0.01866609,0.0009840967,0.004938119,-0.008394803,-0.0186802,-0.0035783728,0.013354085,0.0104405945,0.0035519185,0.028119061,-0.011787996,-0.01315656,-0.013255322,-0.012183045,0.009897402,0.009869184,0.015251734,0.018482674,-0.003742389,0.0032644495,-0.0025554767,0.023660645,0.011964357,0.01972426,0.004592451,0.0057917084,0.025297279,-0.03112426,0.000639751,-0.017325744,0.024098022,0.006779332,0.006511263,-0.010398268,0.007322525,-0.031688616,0.0039152233,-0.02773812,0.01996411,-0.0040139854,-0.025438368,-0.013368194,-0.02296931,0.030447032,-0.016944803,0.02034505,0.004179765,-0.005632983,0.004081003,-0.021939358,0.030813864,-0.008923887,-0.025875745,-0.0023932243,-0.0066911513,-0.012930818,-0.02126213,0.05355743,-0.0025925126,0.0059433794,-0.011167204,0.018087626,-0.0070650377,-0.011138986,-0.015604457,0.011124877,0.014687377,-0.016450992,-0.014440471,-0.021812377,0.00835953,0.031462874,-0.013438739,0.0015175899,0.013939605,-0.019907676,-0.0133188125,0.0151106445,0.0048922654,0.021699507,0.019597279,-0.00076673116,-0.0040951115,0.0147720305,0.02776634,-0.006715842,-0.017523268,0.0243802,0.0057775993,0.004239728,0.012754456,0.03135,0.0042714733,-0.00986213,0.019554952,0.00843713,0.01736807,-0.007336634,0.0020845917,0.008507674,-0.009050867,0.0018817761,-0.090297036,-0.039617825,0.018708417,0.009029703,0.009883293,0.024267329,0.0013668009,0.03180149,-0.023801735,0.012140719,-0.020951735,0.0040951115,-0.011597525,0.0024919866,0.030193072,0.015787873,-0.014630942,-0.005756436,-0.0017283417,0.0286552,-0.009608169,-0.01686015,-0.0055130576,-0.026045052,0.0020017019,-0.008267823,-0.012310025,0.031237131,0.0068146046,-0.0059821787,0.00029783032,-0.01659208,0.015138863,-0.023110397,-0.016648516,0.013036635,-0.0072378716,-0.007008602,0.0034337565,-0.004874629,0.028951487,0.00018639196,0.008154951,-0.012683912,0.02488812,-0.0038199879,-0.0028641091,0.036231685,0.02270124,-0.016577972,-0.03174505,-0.0004788212,-0.014800249,-0.019752476,0.011999629,-0.009452971,0.014715595,0.010370051,-0.0286552,-0.008049134,-0.012274753,-0.03135,-0.008225496,0.025508912,-0.0005511294,0.012690966,-0.022757675,-0.023815844,0.020895299,-0.0020440286,-0.009770421,0.0032997217,-0.019188121,0.009220174,0.002320916,0.005121535,0.0023826426,-0.01687426,-0.0002671875,-0.029515844,-0.019921783,-0.010786263,0.016197031,-0.004913429,0.024789358,0.014221784,0.011244803,0.016041832,-0.007900991,-0.01633812,0.019780695,0.025367824,0.025635893,-0.016295793,-0.009643441,0.011851486,0.0056365104,0.0005304069,0.028739853,0.01841213,0.0038235153,0.0035836636,-0.051441092,0.025664112,0.0059433794,0.012260645,0.0054848394,0.012429952,0.0036189358,-0.024676487,-0.0015713801,0.010976734,-0.033155944,0.021981684,0.012923763,0.0038587875,-0.020119308,-0.015011882,0.016422773,0.0066911513,0.01135062,0.0018465038,0.013361139,-0.018821288,-0.0039469684,0.027695794,-5.4589364e-5,-0.0076681934,-0.013064853,0.017142328,-0.01542104,-0.009650496,0.02710322,-0.016408665,-0.0035025375,0.014101857,-0.002828837,-0.040266834,-0.0033120671,0.024408417,0.02476114,-0.0050509903,-0.014983664,-0.015124754,-0.0069204215,-0.0109485155,-0.024464853,0.0006908958,-0.015040101,0.008945051,0.02296931,-0.003802352,0.00816906,0.020373268,-0.01958317,-0.028104953,-0.016817823,-0.029233666,-0.005470731,-0.003188614,0.0040210397,-0.016211139,0.03346634,0.010370051,0.020415595,0.0054213493,-0.0030175436,-0.003745916,-0.014461635,0.016112378,0.027667576,-0.0070156567,-0.010899135,-0.004035149,-0.016704952,0.0010378868,0.02463416,-0.021318566,-0.0030122527,0.0001311688,-0.016041832,0.02528317,0.021459656,-0.0044160895,-0.035328716,0.044640597,-0.0019823022,-0.009784531,-0.024436636,-0.029600497,-0.023039853,0.015378714,-0.010080817,0.00986213,0.018990595,-0.011611635,-0.012027848,0.015519803,0.0067863865,0.022630695,0.022165101,0.03603416,0.01322005,0.0026895113,0.02528317,-0.01095557,0.004257364,0.011639852,-0.032648023,-0.007548268,-0.001608416,0.010976734,-0.00835953,0.006447773,0.00010972986,0.016916586,-0.013001363,0.032196537,0.0068569314,-0.014038367,-0.0071391095,-0.0018764853,0.023900498,0.006853404,0.0011172495,-0.024436636,0.033663865,-0.007068565,-0.017847775,-0.0018764853,0.009960892,0.023801735,0.013840843,-0.014341709,-0.032140102,-0.02450718,-0.012366462,-0.017565595,0.00031921413,0.010109035,0.03180149,0.08013862,0.020006437,0.008634654,0.01594307,0.0055730203,0.024958665,0.0139254965,0.017749012,-0.021812377,0.026792824,0.026157923,-0.00046912133,0.009452971,-0.0286552,-0.017734902,-0.002407333,-0.0062608295,0.014052477,-0.010708665,-0.004098639,0.022884656,0.008394803,0.02943119,0.013481066,-0.025664112,-0.028711636,-0.014673268,-0.0012407025,-0.035610896,-0.014560397,-0.013361139,0.01671906,-0.017960645,-0.012331189,-0.016013615,-0.0070332927,-0.0044619436,-0.019131685,-0.00048719835,0.03563911,-0.0028076735,-0.020020546,-0.016507426,-0.020838862,0.015068318,0.008020916,0.0012892018,0.007534159,-0.028316587]')) AS Score FROM pages ORDER BY SCORE DESC LIMIT 5

Gets me:

Query 1 ERROR: Leaf Error (127.0.0.1:3307): Error reading from socket. Errno=104 (Connection reset by peer)

UPDATE: Tested on the full singlestore (prod basically) and it works, just doesn’t work on the docker image…

It only seems to be these vector queries, I’m running it from docker (with apple silicon)

2

I don’t know the reason but it could be that our dot_product function is implemented with SIMD and the Intel emulator we use on the docker M1 Mac version of SingleStore cannot handle that.

Has anybody else gotten this to work on Mac M1?

cc: @arnaud

@heychazza consider using our managed service free trial, or an Intel-based machine if you have one available.

3

@heychazza could you add here a small but full repro for that? (create table, insert, select)?

4

This issue seems like a bug in our handling of SIMD instructions when running on M1 Macs using Intel emulation. We are investigating.

5

hey @hanson, thanks for your reply!

I’ve utilised your self-managed solution for the time being, but glad that it’s a bug with Apple Silicon, do you guys know when a proposed fix could be out at all?

R.E. Managed service, I don’t have any credits unfortunately

6

Can you provide a full repro?

7

One of our engineers tested dot_product on the M1 mac setup with vectors of length 1536 like the ones from the popular OpenAI API and it worked fine. So please provide a full repro of the error if you can. Thanks!

8

I’m seeing this same issue on my m1 mac.
create the table:

CREATE TABLE `HS_Stats_Responses` (
  `xEvent` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
  `xResponse` int(11) NOT NULL DEFAULT '0',
  `xRequest` int(11) NOT NULL DEFAULT '0',
  `xPerson` int(11) NOT NULL DEFAULT '0',
  `dtGMTOccured` int(11) NOT NULL DEFAULT '0',
  `noteEmbedding` vector(512, F32),
  PRIMARY KEY (`xEvent`),
  SHARD KEY `__SHARDKEY` (`xEvent`),
  SORT KEY `__UNORDERED` ()
) AUTO_INCREMENT=30818 AUTOSTATS_CARDINALITY_MODE=INCREMENTAL AUTOSTATS_HISTOGRAM_MODE=CREATE AUTOSTATS_SAMPLING=ON SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_ALL_TABLES,NO_AUTO_CREATE_USER';

insert sample data (my dataset is about 30k rows, but just included one example row.

INSERT INTO `HS_Stats_Responses` (`xEvent`, `xResponse`, `xRequest`, `xPerson`, `dtGMTOccured`, `noteEmbedding`)
VALUES
	(4110, 33, 38274, 7, 1271858199, '[0.706345558,1.94390321,-1.74974632,-0.623035371,2.19918394,0.230223298,0.853025794,1.30591249,-0.365261972,-0.876363754,-0.300459445,0.302327156,0.739391208,0.320263684,1.86042738,-1.6241616,-0.449064076,-1.27150881,-0.0870260745,0.394676089,-1.39469862,0.240902394,0.123850293,-0.204079539,0.378776252,0.615238726,0.966893554,0.117126524,-2.62791157,-0.599202573,0.197554797,0.689735532,-0.627443671,0.184792519,-0.251850545,0.196327835,1.42726779,0.722876191,-0.758976579,-0.207320124,1.26870608,0.707038522,-0.700331986,-0.132943124,1.26795113,-1.87761664,0.830153942,-0.107470222,0.317788333,-0.99271661,0.451580137,-0.596858561,1.08701408,-0.445552409,0.891971409,0.313436806,0.766197085,-0.576959252,0.309888333,-1.22246194,0.717762947,0.30568409,-0.00556393526,1.23780656,2.39202213,-0.419237733,-0.915682673,0.683886886,0.32529366,-0.0173160825,0.850676715,-0.720321,0.805051446,0.339938551,-0.774346352,0.122109823,-0.380609214,0.572151661,-0.237459257,0.85236609,0.467165291,-0.551843166,0.0623160303,-0.333446801,1.85438347,0.86270833,-1.60061193,-0.466866523,0.203143448,1.56400979,1.16302133,-1.42521477,-0.185794458,0.487132967,-0.033863049,0.965409458,-0.32336235,-1.42035437,-0.361788213,0.95702064,-1.32831001,-0.46549198,-0.899475515,-0.382895231,0.627173722,1.40245748,-0.026734028,-0.276376575,0.233748078,-1.66564465,-1.07449818,-0.0665682182,-1.18757808,-0.136893779,-0.423284769,0.909978211,2.19205236,-0.97342509,-0.224551618,0.964581013,-0.785372019,-0.346392989,-0.13354367,0.365058124,0.651238441,1.22595072,-2.20555186,-0.178478196,1.0593437,-0.763510942,-0.264609396,0.188573003,-1.45760965,-0.345539033,0.273010671,1.33143365,1.01440477,-0.651180267,1.10948861,0.276840121,0.374761879,1.05629253,-0.334093362,-0.97191602,0.363152623,-1.50070775,0.0160415806,-0.835610032,-1.78337002,0.720862687,0.1446632,1.11750698,-0.885078907,0.558646083,1.21440399,0.945444226,0.565664649,0.276479095,-0.28331399,1.32990074,0.115354151,0.843400657,-1.76110816,0.369169295,-0.292122126,-1.77509856,0.769416332,0.104827203,0.550282478,-0.560073853,-1.06137824,-0.620322347,-1.27795315,0.581946075,1.0663904,0.862409234,0.411621183,-0.823743939,-0.301376075,0.265492886,1.21557641,-0.483208895,0.960186005,-0.197841153,0.478903443,0.357004225,0.459526539,-0.0169983935,-1.40189815,-1.29424083,-2.03861046,-0.206126675,-0.505011499,-0.000701524317,-1.56937647,-0.463481039,1.56714964,-0.555186391,0.871192217,-0.496279836,-0.572930038,-0.523730457,-0.110643059,0.649119496,-0.304016709,0.686308861,-1.40248013,0.789131403,-0.718200564,-0.880512893,1.21837223,-0.317543119,-0.409764677,0.0164828673,-0.88496542,-0.0176413245,0.364137918,-0.2970649,0.0396292619,1.26625538,0.0411101803,1.05962944,-0.964063168,-0.0190312676,0.841840625,0.643677652,-0.233622491,-1.09925103,-0.0980871469,0.345737964,-1.04353881,-1.58915353,-0.00532773137,-0.587318778,-0.0342026427,0.506398916,0.992017984,0.821481228,-0.603052378,1.31088984,1.06895196,0.595236182,-0.202381343,0.513510942,-0.440715492,-0.158080578,-0.104314521,-1.11711836,0.0997201577,0.579746246,0.395529509,0.367483318,0.751426339,-0.217241198,0.54775548,-1.67392349,0.218511865,0.593304873,-0.567913532,-0.4185839,1.11208165,-0.719812274,0.327043056,-0.307640791,-1.52984297,-1.39119852,-0.650952756,0.0432267189,0.785826147,-0.191833258,1.06850147,1.10850275,-0.552853584,0.845985532,-1.05578637,-0.897390485,1.12553954,-1.03380132,-0.852267027,-0.438390195,-0.457472861,0.4067882,-0.902175546,0.161278874,-0.169744551,1.16651034,-0.197375938,-0.260805607,1.3568362,-0.611740053,-0.505108476,0.567648292,-0.143680513,1.03352225,-0.12423341,0.777893662,1.13824952,-1.20562875,-0.340503603,-0.315352857,0.72049278,0.143117443,0.341163635,1.0583775,0.312851489,-0.625586867,0.721568227,0.237119406,0.760761082,0.777384698,-0.464538991,-0.288149595,0.225569725,-0.111790992,-0.545220852,0.463133216,0.179434061,1.26825261,1.12167478,0.1235158,0.997233331,0.164153293,-0.603843451,-0.0330425762,0.135773078,0.951621056,-0.428237647,0.747501373,0.0325912982,0.521014571,-0.856020749,0.423130989,1.81502664,0.550084591,-0.620154679,0.273448169,0.962962329,0.227175802,0.061584346,0.950166941,1.70957899,-0.437513322,0.693511426,0.169152349,0.323502243,0.273647964,0.199269459,0.339639187,0.838477612,0.175954744,-1.07182133,1.15476084,-0.253892988,0.306975663,0.0782429203,0.866018474,0.6035254,-0.0609625354,-0.0118215661,-0.819597244,0.99199307,-0.771671414,1.04915631,-0.418901384,0.743141651,1.24336779,1.03872371,-0.0356747285,0.292540818,-0.154416382,0.330205619,-0.660896957,0.269206673,1.96860719,1.53425813,-0.740807056,-0.297196388,-0.501840949,-1.146119,0.0383173935,-0.122882575,0.476289779,0.0332477279,-0.570068836,0.356945336,-1.61667943,1.31763244,-0.909828424,0.850961864,-0.142125815,-0.291489244,-0.36200732,-0.631996512,-0.309768409,-0.2319078,-0.0281893425,-0.845297694,0.921489298,-1.55146646,1.34429324,-0.420888722,-1.18402469,-0.106035143,0.0666740239,0.822863221,0.641838551,-0.665254831,-0.400889993,1.43979561,-0.369289875,-0.00912195258,1.34361911,-1.07115746,-0.754360676,0.420992196,0.128008008,1.51562452,0.0391564481,0.180409402,0.301205903,-0.678459167,-0.112187579,-1.35108113,0.882867336,1.2561965,0.968666077,-0.472678483,-0.41010794,-0.143287197,-0.219982892,-0.460942119,0.970084846,0.00976699591,0.533963799,-0.0678604394,-0.0750404447,-0.00148988888,0.403680354,-1.07743871,0.653755724,0.707458615,-1.538903,-0.110957295,0.0694952235,0.802472949,2.03150487,0.899248123,-0.899516702,-0.811067522,-0.427783757,0.750365019,0.775078297,0.616069317,0.0105196554,0.597770989,-1.03077459,0.0762109682,-0.409309208,-0.412302673,0.451661021,0.538902402,0.216377616,-0.795298278,-0.95564574,0.470992863,0.289307773,-0.426335305,0.309338331,0.358244628,0.694661975,-1.28641462,0.123244628,0.35981226,-0.451490402,-0.61251986,0.503204823,0.105317004,0.538725197,0.687437534,1.32458901,-0.0372573063,-0.170750573,-0.6189695,-1.58092928,0.0494235642,0.558954358,0.216484278,-1.22999334,0.170984551,-0.426923513,0.849405468,0.956167936,-0.135984078,0.0109323785,-0.259884477,-0.691454232,-1.31873381,0.293399155,0.376826078,0.582515836,0.656065464,0.403661937,-0.822781205,-0.218531966,0.92136538,1.44258261,-1.471874,-0.241407514,-0.57723248,0.982259333,-0.410942107,-0.211797476]');

query data:

SET @vector = ('[-0.090210892260075,0.16734890639782,-1.9463782310486,1.0045500993729,0.67209434509277,-0.51906633377075,-0.017744246870279,0.68122309446335,0.54004997014999,0.73362594842911,-1.7692794799805,1.6067578792572,0.050601467490196,-0.35063496232033,0.11275959014893,1.0355122089386,1.3341422080994,-0.19054892659187,0.37511253356934,-0.39124000072479,0.22185087203979,-1.6681816577911,-0.66199481487274,-0.20994544029236,0.86366534233093,-0.38621079921722,0.1260567009449,0.91724061965942,-1.1670360565186,1.1061844825745,0.85610407590866,-0.58046782016754,0.36640372872353,-0.0075394213199615,-0.19224877655506,0.28708964586258,0.0012352168560028,0.20787470042706,0.020600274205208,-0.19464342296124,0.75887417793274,0.57836014032364,0.56716299057007,-1.2458693981171,1.034551858902,0.84675407409668,1.1402022838593,-1.257474064827,0.33406442403793,-0.17440631985664,-0.19952498376369,-0.84754979610443,-0.73041272163391,-0.47724840044975,0.36421683430672,-0.94426190853119,-0.006463535130024,-1.280121088028,0.30733972787857,-0.62232846021652,1.4645181894302,0.78080058097839,0.60160905122757,1.3509695529938,-1.4742188453674,0.03944830223918,-0.041222289204597,1.4824616909027,0.24130111932755,-0.29245790839195,0.11838385462761,0.32247757911682,-0.27182483673096,0.41326767206192,0.12287959456444,-0.35184445977211,-0.9291552901268,0.090835824608803,0.73478758335114,-0.13291519880295,0.35926395654678,-0.99881637096405,1.957445025444,0.53264629840851,-0.46813577413559,0.51749509572983,-0.21920323371887,-0.048954255878925,-0.82974529266357,-1.0224702358246,0.34148237109184,0.51683270931244,-0.055698186159134,0.49577379226685,0.73968309164047,0.12374226748943,-0.48870551586151,0.59113836288452,-1.5267496109009,1.5497415065765,-1.0561547279358,-1.975269317627,-0.21255545318127,-0.69794821739197,0.59716218709946,0.20578145980835,-0.052073244005442,-0.64948409795761,-0.12511405348778,0.22150799632072,-1.5066771507263,0.43546336889267,0.91985934972763,-0.27050936222076,0.064236298203468,-0.50828540325165,0.55791634321213,-0.58045184612274,0.43103864789009,0.99411475658417,-0.024292498826981,-0.42663514614105,0.11277832090855,0.54297375679016,-0.40974599123001,-0.6235414147377,-0.73811638355255,0.7955037355423,1.382204413414,-0.57577502727509,0.65627211332321,0.16081941127777,-0.59763669967651,0.38985356688499,-0.049298349767923,0.042528063058853,-0.51968401670456,-0.40622633695602,0.30595079064369,-0.38756835460663,0.52699077129364,0.017968565225601,1.0295453071594,-0.12662172317505,1.448677778244,-0.7297106385231,0.41397994756699,-0.71947872638702,-0.49910360574722,-0.15964443981647,0.5370227098465,-1.4128797054291,-0.0068947244435549,0.037512376904488,-0.67316502332687,-1.8032174110413,0.15891478955746,0.45160150527954,0.56823354959488,1.7338849306107,0.70029920339584,-0.27042037248611,0.19393874704838,0.78458875417709,0.3190730214119,-0.42167314887047,-0.86858069896698,1.1325713396072,0.092710420489311,-0.029339089989662,0.65785777568817,-1.0336315631866,0.05202779173851,-0.58591270446777,-0.34380424022675,0.38452997803688,-0.48732733726501,-0.46186482906342,0.58838278055191,-0.86360740661621,1.2439799308777,0.34575819969177,1.8778793811798,0.98188734054565,-0.73466908931732,0.89060127735138,0.82117116451263,0.51798379421234,-0.69452095031738,-0.73417043685913,1.6973434686661,-0.06992506980896,-0.68991822004318,-1.5376973152161,0.34528821706772,-0.51268577575684,0.4106123149395,0.71110278367996,0.47489732503891,0.13962338864803,-1.471110701561,-0.57557940483093,1.2520422935486,0.00043591856956482,-0.6165480017662,1.3564729690552,0.32289737462997,0.14102606475353,-0.95415806770325,0.33717194199562,1.2494251728058,0.6987841129303,-0.71900486946106,-0.6647921204567,-0.48958247900009,0.14929832518101,0.3387465775013,-0.25356638431549,-0.17267662286758,-0.37728261947632,-0.50363773107529,0.67007946968079,-0.51494491100311,0.6900240778923,0.1992769241333,0.098608590662479,-0.78331339359283,-0.91895353794098,0.48337841033936,-0.39116495847702,-0.20171940326691,-1.0217826366425,0.80960750579834,1.2939012050629,0.18834225833416,1.1976506710052,0.19699081778526,0.58386045694351,-0.48402205109596,0.13390438258648,-0.5337907075882,0.98044204711914,1.0376100540161,1.2307403087616,-1.0021541118622,0.19038946926594,-0.7678929567337,-1.6800181865692,1.1459851264954,0.88615131378174,0.81159365177155,-0.81728172302246,-0.28181892633438,0.83250945806503,-0.5554626584053,-0.0093068405985832,-0.47295969724655,0.090919747948647,-0.57123619318008,-0.29664465785027,1.1805356740952,-0.45261669158936,0.057739481329918,0.063470765948296,-0.46518978476524,-0.29622480273247,-1.0368337631226,0.93831074237823,0.43743315339088,-0.030371196568012,0.065280914306641,1.4165351390839,1.0151883363724,1.3461906909943,-0.084420621395111,-1.4216630458832,-0.30028691887856,-0.68292725086212,-0.33818835020065,1.4615924358368,0.63729482889175,-1.6001393795013,0.48809024691582,0.21614852547646,-0.39040368795395,-1.1476851701736,0.27058055996895,1.0505546331406,0.28935998678207,0.56921148300171,-0.19364729523659,0.35635608434677,-1.6363871097565,0.55025225877762,1.2244757413864,0.49417543411255,0.75849890708923,0.96657776832581,-0.65262567996979,-0.45866638422012,0.2505689561367,-0.4489848613739,0.21891474723816,-0.077008724212646,0.3594822883606,-0.63692438602448,0.74384373426437,1.7851995229721,0.97396522760391,0.035301007330418,-0.58400976657867,0.08901135623455,0.56112623214722,0.25986307859421,-1.0254222154617,0.30984324216843,0.82124799489975,0.33886927366257,-0.0093662589788437,-0.49302950501442,-0.43787950277328,0.29667755961418,-0.48837727308273,0.72137653827667,0.008410707116127,0.90816354751587,-0.62906992435455,0.4110209941864,-2.4378402233124,-0.35363304615021,0.091073334217072,2.2401099205017,0.25728005170822,-1.3200571537018,-0.90831464529037,0.021727494895458,0.75182199478149,-1.3477644920349,-0.060333907604218,0.014760836958885,1.7384920120239,-0.25974759459496,-0.30307677388191,-0.58472448587418,0.0058399811387062,0.64409136772156,-0.028063833713531,-1.3484901189804,1.2015352249146,0.10270740836859,-0.23463046550751,1.8500828742981,0.10452224314213,-0.051062762737274,0.90842318534851,-0.65126532316208,-0.086235955357552,0.82483327388763,0.39682966470718,1.310449719429,-0.013473805040121,-0.98153257369995,0.5664187669754,0.046084057539701,0.10121254622936,-0.0083780288696289,0.98280388116837,-0.64892196655273,-0.50941669940948,-1.1412264108658,-0.023679926991463,-1.3905804157257,0.26002612709999,-0.69614243507385,-0.39623910188675,0.29629361629486,-1.1966614723206,-1.5387670993805,-1.3991432189941,0.66110801696777,0.15981763601303,-1.2458307743073,-0.6952605843544,0.098951458930969,-0.10741478204727,-0.085742548108101,0.51250851154327,-0.57490670681,0.39530429244041,1.6151299476624,-0.12686461210251,-0.77737939357758,-0.27620255947113,-0.23337742686272,0.43809702992439,0.074906252324581,0.18495264649391,-0.58504867553711,-1.5498274564743,-0.70797729492188,-1.1622030735016,0.091293752193451,-0.14584279060364,0.78054487705231,-0.45275515317917,1.5725620985031,-0.090577811002731,-1.237907409668,0.38775917887688,0.67733430862427,-0.32147967815399,0.53419750928879,0.2410521954298,-0.52491056919098,-0.31123152375221,0.69980955123901,-0.11639754474163,-0.55255162715912,0.17554289102554,0.22473008930683,0.94818639755249,0.25615155696869,1.9433310031891,-0.11229433119297,-0.084506303071976,-0.50337517261505,-0.17272242903709,0.33899101614952,1.2865617275238,-1.6522656679153,-0.21496841311455,0.38718509674072,-0.79681599140167,0.86697268486023,-0.723140001297,0.22656810283661,1.6079263687134,-1.0061920881271,-0.88355958461761,-0.0004749596118927,0.67483532428741,-0.72882384061813,-1.4778780937195,0.04385706782341,0.54998290538788,1.568599820137,1.4073162078857,0.52957648038864,-0.54094994068146,-0.11630445718765,-0.27543205022812,0.57344514131546,1.8051989078522,0.24452325701714,0.81357431411743,-0.74460864067078,0.30595046281815,1.2585628032684,0.1765243858099,1.402220249176,-0.25910457968712,1.065682053566,0.27838891744614,0.73487663269043,-0.10679097473621,-0.27412188053131,0.7530038356781,0.015810906887054,1.0189734697342,0.18958809971809,0.61832654476166,0.49696254730225,-0.18863105773926,0.66020548343658,-0.31196308135986,0.1504844725132,0.2362479865551,0.1528500020504,0.45367449522018,0.8405002951622,-1.3644531965256,0.1260699480772,-0.87668865919113,-0.10760553181171,0.8965939283371,-0.10428152233362,0.24434918165207,0.30465507507324,-0.24039790034294,-0.3973276913166,-0.17343659698963,0.90520465373993,2.0610761642456,-0.15097174048424,0.44142958521843,-0.24525018036366,-1.8907459974289,0.062827080488205,0.61518651247025,0.060133021324873,0.57695305347443,1.6425399780273,-0.11158975213766,-0.19958457350731,0.90288865566254,-1.8530447483063,-0.7948185801506,-0.28723043203354,-0.62318640947342,-0.098312713205814,-1.2451695203781,-1.6900372505188]'):>VECTOR(512);

select xEvent,noteEmbedding <*> @vector as score from `HS_Stats_Responses` order by score desc limit 1;