libsql-client-ts icon indicating copy to clipboard operation
libsql-client-ts copied to clipboard

Published 20 hours ago • verified publisher icon tursodatabase

Server returned HTTP status 400: SQL text 0 not found

Open xray-robot opened this issue 1 year ago • 4 comments

Hello! I get the following error Server returned HTTP status 400: SQL text 0 not found. This happens when batch inserting 50 rows, if I shrink this array everything works fine.

sqld sqld 0.22.14 (2931e2b5 2024-01-18)
"@libsql/client": "^0.4.3",

import { createClient } from "@libsql/client"
export const sqlite = createClient({ url: dbUrl })

Failed (batch, 50 rows):

    sqlite.batch([`
    INSERT INTO asset (fingerprint, policy_id, asset_name, ref_fingerprint, quantity)
        VALUES
          ('asset100kvrdjjqk4dasq8l8mjv6kmm9gvphv6wq3d32','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279416c6261',NULL,1),('asset1gvcwm2mgn5sz6myyhj5hdcwtykkae9n6rt3fp7','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279416d657468797374',NULL,1),('asset1sqxcm8lllfgxgvlpjhju8u0eu9tdy7mnaztj3z','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279417175616d6172696e65',NULL,1),('asset1yxfr9pmvs6rk2882cpf6t9pmga7muptk6ktmet','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279417368',NULL,1),('asset1qh6tqpzxrr8zhw092fu2fuhhzmkfw6dk8ukj0j','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727941756275726e',NULL,1),('asset1658aap9dkt4rgpx8u5qhl6sx2zd53wuaslu30f','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279417572656c6961',NULL,1),('asset1q0waeyvj0ad0myqmg3mzuv5vy340jglcqxwfww','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279417572656f6c696e',NULL,1),('asset1x2zwa423wlwms3sfely33269deznszxn9zyz7d','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279417765736f6d65',NULL,1),('asset1dq2nr5jnlmxu69syzdhwfjlhh7vyxkvuwj5f3u','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279417a756c',NULL,1),('asset1wdmgm7wpjlk3snsleddaedsnnnp4rd4jmylmtn','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794265696765',NULL,1),('asset1qac03sxstk0e3f97sn62hjn3mc7xypht6mnh8g','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279426572796c',NULL,1),('asset1epq93cxdvgnn30fprzgapmc7yypfdwgl0y3xx2','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279426c61636b',NULL,1),('asset1l9ngavfdwcvdnru34f6vkf5hn3egczr4020zql','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279426c7565',NULL,1),('asset10uqkndrjeluakmslvcvfp3phg6yc5cf2t5k4nn','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279426f6e65',NULL,1),('asset1wh5ae4vx5cda7p4dqsmm09slf0hfnrzcv887l4','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279427269636b',NULL,1),('asset1d3qsqu0zw07l40s89lprz3dl8r9zghwhdzcerw','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727942726f776e',NULL,1),('asset1tjna0let8ckmxdcrygck2jm52tjt66ypcd3ns6','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727942797a616e74696e65',NULL,1),('asset16zgagr75hv3qzxvws6vnx9rhwy5eyepvquurq5','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794361646574',NULL,1),('asset1399lwe4qweyhh0esygura5ny522pmu48vx7yyp','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727943616d656c',NULL,1),('asset1mp747scu2llzsz8ysa2ayzmac03mnc444tfqng','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794361707269',NULL,1),('asset1tcxnum3xsryqls3hhyc0cu5lhlshnusxf4cl5r','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727943617264696e616c',NULL,1),('asset1f094x6pcztetxas844c5rmn6yy23sxg8zxw786','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279436572756c65616e',NULL,1),('asset15dh9d9wman4qhx3ds5j3dhv6jxyclhxqeywv44','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727943686172747265757365',NULL,1),('asset1fu9xeemps4pm7gvg6u3fues9peswdgw4afheje','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279436865727279',NULL,1),('asset1wq78aqrd3qfrweh9796urz947x99d79meqx992','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727943696e6e616d6f6e',NULL,1),('asset1n0k644kvvnruwvqqqwq4rg5muz0hejj3qg88j6','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279436c656d656e74696e65',NULL,1),('asset1sycng9dvyy8vmf5x29u85t9re337sr0mk7kezj','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279436f616c',NULL,1),('asset1h3w7vnlr5av8a2x6cs3t9mqxtnguclj86jhvzt','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279436f62616c74',NULL,1),('asset1w6d5vj264n94skujg2ywhvqm8th4vzuk84r0jv','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279436f66666565',NULL,1),('asset176glpknujjy8xnyp92757gw0krewd5fq0m2xcs','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279436f72616c',NULL,1),('asset1ncqm0xkhpldwcqsn73v73u30kunpfyc0zl9hnd','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794379616e',NULL,1),('asset1ys05vp6vk6gv4mmkzqczq7tgcl0rf8jn65p3tk','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727945626f6e79',NULL,1),('asset1v4zpk9gz3f57z78qhxpsxwdndtzyw6hyrsf6qt','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279456d6572616c64',NULL,1),('asset15tah9fpj6xk05z3uj2razgf9m3nagncred56qt','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727946756368736961',NULL,1),('asset10rnjznavl7u2juqmdsemul7gl4akvk5aszsvr0','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279476f6c64',NULL,1),('asset1m8ufna63dux79ncvyq8hn7qtgk7hcsegyqulu6','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727947726179',NULL,1),('asset1f6eqhqcwqj4f0u7rqw3x7qqxtpyna2qe3sregh','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279477265656e',NULL,1),('asset1d3n2940rspugw6zwqwd3kf7t442jgfatfskrml','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727948617a656c',NULL,1),('asset1cfgqhp8nmasg2n3tvrdjcyekqk848tyjd7wc98','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727948756d62726f6c',NULL,1),('asset1lflhwavuxent76ndnyfht58efj5qfzxltjhe4v','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279496e6469676f',NULL,1),('asset1ygr7hzgc7xpkcufamas3hadsxpa2e8m48m2u76','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727949726973',NULL,1),('asset1whv3vpg4x4dkqqnczc03m0tz5q43gfze0kuve7','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794a616465',NULL,1),('asset1yr4q38h7qzwgw4cjtzzke06kmmfaahjgkxajlc','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794a657474',NULL,1),('asset1x2t5w0ftr2jpqvcwu4dlzhh0gf5ztwqmv5syv2','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794b656c6c79',NULL,1),('asset14g9kfuluw7x9aygyr9f57m4a797md34dl093wh','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794b68616b69',NULL,1),('asset185xpglwudled5ecq8rkp7k4ngxuquvj0cyf00g','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794c617661',NULL,1),('asset1d78z0qtug477dn5krf3jexcm9rk5g3skq493dm','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794c6176656e646572',NULL,1),('asset1k66kvlxdc7y22fgdxaagdfhpzurfxt2uz9308x','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794c656d6f6e',NULL,1),('asset1km30mjmm2qj8earn7745mhlkave4phh5xmkfkv','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794c696d65',NULL,1),('asset18hep6xnnfe8g46mlc2w57hly30cxmsaxa76hrh','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794c757374',NULL,1)
        ON CONFLICT (fingerprint) DO NOTHING
    `])

Success (batch, 1 row):

    sqlite.batch([`
    INSERT INTO asset (fingerprint, policy_id, asset_name, ref_fingerprint, quantity)
        VALUES
          ('asset100kvrdjjqk4dasq8l8mjv6kmm9gvphv6wq3d32','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279416c6261',NULL,1)
        ON CONFLICT (fingerprint) DO NOTHING
    `])

Success (execute, 50 rows):

    sqlite.execute(`
    INSERT INTO asset (fingerprint, policy_id, asset_name, ref_fingerprint, quantity)
        VALUES
          ('asset100kvrdjjqk4dasq8l8mjv6kmm9gvphv6wq3d32','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279416c6261',NULL,1),('asset1gvcwm2mgn5sz6myyhj5hdcwtykkae9n6rt3fp7','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279416d657468797374',NULL,1),('asset1sqxcm8lllfgxgvlpjhju8u0eu9tdy7mnaztj3z','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279417175616d6172696e65',NULL,1),('asset1yxfr9pmvs6rk2882cpf6t9pmga7muptk6ktmet','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279417368',NULL,1),('asset1qh6tqpzxrr8zhw092fu2fuhhzmkfw6dk8ukj0j','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727941756275726e',NULL,1),('asset1658aap9dkt4rgpx8u5qhl6sx2zd53wuaslu30f','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279417572656c6961',NULL,1),('asset1q0waeyvj0ad0myqmg3mzuv5vy340jglcqxwfww','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279417572656f6c696e',NULL,1),('asset1x2zwa423wlwms3sfely33269deznszxn9zyz7d','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279417765736f6d65',NULL,1),('asset1dq2nr5jnlmxu69syzdhwfjlhh7vyxkvuwj5f3u','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279417a756c',NULL,1),('asset1wdmgm7wpjlk3snsleddaedsnnnp4rd4jmylmtn','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794265696765',NULL,1),('asset1qac03sxstk0e3f97sn62hjn3mc7xypht6mnh8g','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279426572796c',NULL,1),('asset1epq93cxdvgnn30fprzgapmc7yypfdwgl0y3xx2','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279426c61636b',NULL,1),('asset1l9ngavfdwcvdnru34f6vkf5hn3egczr4020zql','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279426c7565',NULL,1),('asset10uqkndrjeluakmslvcvfp3phg6yc5cf2t5k4nn','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279426f6e65',NULL,1),('asset1wh5ae4vx5cda7p4dqsmm09slf0hfnrzcv887l4','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279427269636b',NULL,1),('asset1d3qsqu0zw07l40s89lprz3dl8r9zghwhdzcerw','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727942726f776e',NULL,1),('asset1tjna0let8ckmxdcrygck2jm52tjt66ypcd3ns6','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727942797a616e74696e65',NULL,1),('asset16zgagr75hv3qzxvws6vnx9rhwy5eyepvquurq5','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794361646574',NULL,1),('asset1399lwe4qweyhh0esygura5ny522pmu48vx7yyp','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727943616d656c',NULL,1),('asset1mp747scu2llzsz8ysa2ayzmac03mnc444tfqng','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794361707269',NULL,1),('asset1tcxnum3xsryqls3hhyc0cu5lhlshnusxf4cl5r','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727943617264696e616c',NULL,1),('asset1f094x6pcztetxas844c5rmn6yy23sxg8zxw786','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279436572756c65616e',NULL,1),('asset15dh9d9wman4qhx3ds5j3dhv6jxyclhxqeywv44','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727943686172747265757365',NULL,1),('asset1fu9xeemps4pm7gvg6u3fues9peswdgw4afheje','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279436865727279',NULL,1),('asset1wq78aqrd3qfrweh9796urz947x99d79meqx992','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727943696e6e616d6f6e',NULL,1),('asset1n0k644kvvnruwvqqqwq4rg5muz0hejj3qg88j6','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279436c656d656e74696e65',NULL,1),('asset1sycng9dvyy8vmf5x29u85t9re337sr0mk7kezj','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279436f616c',NULL,1),('asset1h3w7vnlr5av8a2x6cs3t9mqxtnguclj86jhvzt','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279436f62616c74',NULL,1),('asset1w6d5vj264n94skujg2ywhvqm8th4vzuk84r0jv','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279436f66666565',NULL,1),('asset176glpknujjy8xnyp92757gw0krewd5fq0m2xcs','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279436f72616c',NULL,1),('asset1ncqm0xkhpldwcqsn73v73u30kunpfyc0zl9hnd','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794379616e',NULL,1),('asset1ys05vp6vk6gv4mmkzqczq7tgcl0rf8jn65p3tk','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727945626f6e79',NULL,1),('asset1v4zpk9gz3f57z78qhxpsxwdndtzyw6hyrsf6qt','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279456d6572616c64',NULL,1),('asset15tah9fpj6xk05z3uj2razgf9m3nagncred56qt','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727946756368736961',NULL,1),('asset10rnjznavl7u2juqmdsemul7gl4akvk5aszsvr0','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279476f6c64',NULL,1),('asset1m8ufna63dux79ncvyq8hn7qtgk7hcsegyqulu6','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727947726179',NULL,1),('asset1f6eqhqcwqj4f0u7rqw3x7qqxtpyna2qe3sregh','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279477265656e',NULL,1),('asset1d3n2940rspugw6zwqwd3kf7t442jgfatfskrml','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727948617a656c',NULL,1),('asset1cfgqhp8nmasg2n3tvrdjcyekqk848tyjd7wc98','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727948756d62726f6c',NULL,1),('asset1lflhwavuxent76ndnyfht58efj5qfzxltjhe4v','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','4265727279496e6469676f',NULL,1),('asset1ygr7hzgc7xpkcufamas3hadsxpa2e8m48m2u76','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','426572727949726973',NULL,1),('asset1whv3vpg4x4dkqqnczc03m0tz5q43gfze0kuve7','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794a616465',NULL,1),('asset1yr4q38h7qzwgw4cjtzzke06kmmfaahjgkxajlc','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794a657474',NULL,1),('asset1x2t5w0ftr2jpqvcwu4dlzhh0gf5ztwqmv5syv2','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794b656c6c79',NULL,1),('asset14g9kfuluw7x9aygyr9f57m4a797md34dl093wh','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794b68616b69',NULL,1),('asset185xpglwudled5ecq8rkp7k4ngxuquvj0cyf00g','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794c617661',NULL,1),('asset1d78z0qtug477dn5krf3jexcm9rk5g3skq493dm','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794c6176656e646572',NULL,1),('asset1k66kvlxdc7y22fgdxaagdfhpzurfxt2uz9308x','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794c656d6f6e',NULL,1),('asset1km30mjmm2qj8earn7745mhlkave4phh5xmkfkv','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794c696d65',NULL,1),('asset18hep6xnnfe8g46mlc2w57hly30cxmsaxa76hrh','b863bc7369f46136ac1048adb2fa7dae3af944c3bbb2be2f216a8d4f','42657272794c757374',NULL,1)
        ON CONFLICT (fingerprint) DO NOTHING
    `)

Error Output:

server@macbook nftcdn % /Users/serv/cdn/node_modules/@libsql/client/lib-cjs/hrana.js:287
        return new api_1.LibsqlError(e.message, code, undefined, e);
               ^
LibsqlError: SERVER_ERROR: Server returned HTTP status 400: SQL text 0 not found
    at mapHranaError (/Users/serv/cdn/node_modules/@libsql/client/lib-cjs/hrana.js:287:16)
    at HttpClient.batch (/Users/serv/cdn/node_modules/@libsql/client/lib-cjs/http.js:113:48)
    at processTicksAndRejections (node:internal/process/task_queues:95:5) {
  code: 'SERVER_ERROR',
  rawCode: undefined,
  [cause]: HttpServerError: Server returned HTTP status 400: SQL text 0 not found
      at errorFromResponse (/Users/serv/cdn/node_modules/@libsql/hrana-client/lib-cjs/http/stream.js:367:12)
      at processTicksAndRejections (node:internal/process/task_queues:95:5) {
    status: 400
  }
}

Table:

CREATE TABLE `asset` (
	`id` integer PRIMARY KEY NOT NULL,
	`fingerprint` text NOT NULL,
	`policy_id` text NOT NULL,
	`asset_name` text,
	`ref_fingerprint` text,
	`quantity` text NOT NULL
);
CREATE UNIQUE INDEX `asset_fingerprint_unique` ON `asset` (`fingerprint`);--> statement-breakpoint
CREATE INDEX `idx_asset_policy_id` ON `asset` (`policy_id`);--> statement-breakpoint
CREATE INDEX `idx_asset_asset_name` ON `asset` (`asset_name`);--> statement-breakpoint

xray-robot avatar Feb 11 '24 09:02 xray-robot

I am having a similar error, did you manage to fix it?

amosbastian avatar Mar 21 '24 21:03 amosbastian

I am having a similar error, did you manage to fix it?

Used db.execute instead of db.batch. No solution found so far

xray-robot avatar Mar 22 '24 07:03 xray-robot

Opened this related issue: https://github.com/tursodatabase/libsql/issues/1280

johtso avatar Apr 03 '24 18:04 johtso

After discuss in Discord: https://discord.com/channels/933071162680958986/1225640840396017725 We find the root cause of this problem.

Batch is using stored_sql. In the Turso code, the stored_sql only support up to 5kb only.

https://github.com/tursodatabase/libsql/blob/e9d637e051685f92b0da43849507b5ef4232fbeb/libsql-server/src/hrana/http/request.rs#L10

The batch method has no way of specifying it not to use stored_sql which most of the time is a better strategy and support larger SQL query.

The root cause is from SQL Cache. https://github.com/tursodatabase/libsql-client-ts/blob/b58d509e0bf0a48b28e7bd02ae2708fcb62a1f22/packages/libsql-client/src/http.ts#L96

Workaround at the moment is to use https://github.com/DaBigBlob/libsql-stateless-easy

invisal avatar Apr 06 '24 06:04 invisal

This seems to be fixed in 0.7.0

Destiner avatar Jun 26 '24 07:06 Destiner