Wrangler d1 execute with arge_sql_file.sql doesn't work correctly

Developers D1
1

I executed about 50000 SQL statements running npx wrangler d1 execute test --file ../database/seeds.sql, but I seem some statement may skip. I confirmed some tables was not created correctly (lack of data).

The log is here.

16:48 🐧 ❯ npx wrangler d1 execute web-speed-hackathon --file ../database/seeds.sql
β–² [WARNING] Processing wrangler.toml configuration:

    - D1 Bindings are currently in alpha to allow the API to evolve before general
  availability.
      Please report any issues to
  https://github.com/cloudflare/wrangler2/issues/new/choose
      Note: set NO_D1_WARNING=true to hide this message


🚧 D1 is currently in open alpha and is not recommended for production data and traffic.
Please report any bugs to https://github.com/cloudflare/wrangler2/issues/new/choose.
To request features, visit https://community.cloudflare.com/c/developers/d1.
To give feedback, visit https://discord.gg/cloudflaredev
Packages @databases/sql, @databases/split-sql-query not available locally. Attempting to use npx to install temporarily.
Installing... (npx --prefer-offline -y -p @databases/[email protected] -p @databases/[email protected])
Installed into /Users/nissy-dev/.npm/_npx/48c3d90e3e285020/node_modules.
To skip this step in future, run: npm install --save-dev @databases/[email protected] @databases/[email protected]
πŸŒ€ Mapping SQL input into an array of statements
πŸŒ€ Parsing 454821 statements
πŸŒ€ We are sending 46 batch(es) to D1 (limited to 10000 statements per batch)
⚠️  Too much SQL to send at once, this execution will be sent as 46 batches.
ℹ️  Each batch is sent individually and may leave your DB in an unexpected state if a
later batch fails.
⚠️  Make sure you have a recent backup. Ok to proceed? (y/n)
πŸŒ€ Let's go
πŸŒ€ Executing on web-speed-hackathon (39074e7f-9519-4d19-9840-58ef91a88fb1):
  PRAGMA foreign_keys=OFF; CREATE TABLE IF NOT EXISTS "user" ("balance" ...
🚣 Executed 976 commands in 29.791649036109447ms
  INSERT INTO odds_item VALUES('7969ed23-6ff7-47c8-96ee-a3ba149ee9c7','[...
🚣 Executed 1 command in 5.565670996904373ms
  INSERT INTO odds_item VALUES('c5e392ed-3c84-4eaa-9f84-e789e5b7efd3','[...
🚣 Executed 1 command in 6.674855001270771ms
  INSERT INTO odds_item VALUES('9d765e60-ea12-469f-b28e-ab3a515b9ef0','[...
🚣 Executed 1 command in 4.469356998801231ms
  INSERT INTO odds_item VALUES('6fe2d7ba-1d2d-4400-b300-9db765bba73f','[...
🚣 Executed 1 command in 6.182218998670578ms
  INSERT INTO odds_item VALUES('62c26f9e-b49b-49ea-a853-7b3c34581a4b','[...
🚣 Executed 1 command in 4.816270999610424ms
  INSERT INTO odds_item VALUES('9b758d39-4238-424b-a3a9-fbaa33552da9','[...
🚣 Executed 1 command in 4.551977999508381ms
  INSERT INTO odds_item VALUES('124eff8a-b50e-4047-b75f-5fd983f3d483','[...
🚣 Executed 1 command in 5.990455999970436ms
  INSERT INTO odds_item VALUES('60192e2c-f63b-4886-bd26-1ce399ce8287','[...
🚣 Executed 1 command in 5.410438999533653ms
  INSERT INTO odds_item VALUES('6a6e5732-27ee-47f2-9622-4fd05c1465d4','[...
🚣 Executed 1 command in 5.699791997671127ms
  INSERT INTO odds_item VALUES('68c959c0-3667-4c7c-9157-9aa46bf0425d','[...
🚣 Executed 1 command in 5.291616998612881ms
  INSERT INTO odds_item VALUES('94638546-38a0-4e40-9ae1-392eebfbd87d','[...
🚣 Executed 1 command in 4.966932997107506ms
  INSERT INTO odds_item VALUES('9db4e060-c214-4bc2-a064-61d3506b8add','[...
🚣 Executed 1 command in 5.890094995498657ms
  INSERT INTO odds_item VALUES('7e1eead3-2a31-412c-88e0-50c268ac9470','[...
🚣 Executed 1 command in 5.19123600423336ms
  INSERT INTO odds_item VALUES('44e3d8f3-2d51-4bb4-8410-ed2b885d60ac','[...
🚣 Executed 1 command in 4.873021997511387ms
  INSERT INTO odds_item VALUES('5c320117-6849-4fe5-b5bf-597cfdd99859','[...
🚣 Executed 1 command in 5.233036994934082ms
  INSERT INTO odds_item VALUES('340f3649-bc71-444e-84c7-ebe69447a401','[...
🚣 Executed 1 command in 6.225169003009796ms
  INSERT INTO odds_item VALUES('d49395ab-4bd6-4c1a-8598-e0a2c6ca5391','[...
🚣 Executed 1 command in 6.377092003822327ms
  INSERT INTO odds_item VALUES('b463babe-9e9b-4e38-a789-7bc8a0727178','[...
🚣 Executed 1 command in 4.878622002899647ms
  INSERT INTO odds_item VALUES('7ebc953c-e7f5-4895-b3ae-5ab029e65d66','[...
🚣 Executed 1 command in 5.55596100538969ms
  INSERT INTO odds_item VALUES('cd6c9557-6f4b-4136-8ee5-9d28c57f682e','[...
🚣 Executed 1 command in 4.2401639968156815ms
  INSERT INTO odds_item VALUES('96271e10-bab6-4c80-8d87-34a4bc98d422','[...
🚣 Executed 1 command in 6.3838309943675995ms
  INSERT INTO odds_item VALUES('d39c1651-6bd1-4f1a-99b1-b09f84dbd800','[...
🚣 Executed 1 command in 4.8253209963440895ms
  INSERT INTO odds_item VALUES('7f2dbd40-8202-40d9-90b9-e5a9e53f4941','[...
🚣 Executed 1 command in 5.290486998856068ms
  INSERT INTO odds_item VALUES('382c3002-fc5b-4c69-a3d1-6c237dc19a98','[...
🚣 Executed 1 command in 4.99159300327301ms
  INSERT INTO odds_item VALUES('bf36f46a-b28f-4e6a-acdb-52a5fb65ef64','[...
🚣 Executed 1 command in 4.901142001152039ms
  INSERT INTO odds_item VALUES('9ddebbfe-80d8-430a-9eae-739f506b014f','[...
🚣 Executed 1 command in 5.113944999873638ms
  INSERT INTO odds_item VALUES('ca68e86a-2b43-4910-bc36-cc7c306d6097','[...
🚣 Executed 1 command in 17.72444599866867ms
  INSERT INTO odds_item VALUES('48002631-3ad1-451d-934e-08180b1762d3','[...
🚣 Executed 1 command in 4.795492000877857ms
  INSERT INTO odds_item VALUES('3311d97d-426d-4f13-8f1a-e0b0493cb0b7','[...
🚣 Executed 1 command in 5.541761003434658ms
  INSERT INTO odds_item VALUES('cc965853-7350-4322-a238-6fcf93be3883','[...
🚣 Executed 1 command in 5.40293899923563ms
  INSERT INTO odds_item VALUES('0856abf9-09c1-4e8e-ad9f-ec8c8f760f66','[...
🚣 Executed 1 command in 4.726671002805233ms
  INSERT INTO odds_item VALUES('52e9797b-4722-4003-9448-6a8deb8ed4c6','[...
🚣 Executed 1 command in 7.168370999395847ms
  INSERT INTO odds_item VALUES('f1ff0eab-3c06-4c89-9e76-10d6e19f1ae2','[...
🚣 Executed 1 command in 4.849272005259991ms
  INSERT INTO odds_item VALUES('18ee0d2c-711a-469b-a948-686e26b2a9fe','[...
🚣 Executed 1 command in 5.311026997864246ms
  INSERT INTO odds_item VALUES('a571df4e-9dc7-49fa-9d87-de457987a6f5','[...
🚣 Executed 1 command in 5.147256001830101ms
  INSERT INTO odds_item VALUES('6112acfc-5619-460b-aed4-b5c9975ecc1f','[...
🚣 Executed 1 command in 5.660262003540993ms
  INSERT INTO odds_item VALUES('8e8c3208-11fc-41fd-89a2-2b2d4e860cc1','[...
🚣 Executed 1 command in 6.511682003736496ms
  INSERT INTO odds_item VALUES('21d89a47-0661-400f-9f0a-8b550ee97012','[...
🚣 Executed 1 command in 5.572791002690792ms
  INSERT INTO odds_item VALUES('55634990-1f01-4440-a19c-f1ea2fbf9d0f','[...
🚣 Executed 1 command in 5.735013000667095ms
  INSERT INTO odds_item VALUES('ef812cac-29b1-4f9a-9579-ef2630ccbea7','[...
🚣 Executed 1 command in 5.4217090010643005ms
  INSERT INTO odds_item VALUES('f0a65471-2e36-4b79-bd41-de3b9aa24639','[...
🚣 Executed 1 command in 5.091364003717899ms
  INSERT INTO odds_item VALUES('a7be859b-1c34-4e85-81a6-1de1c2f24e1d','[...
🚣 Executed 1 command in 5.913704000413418ms
  INSERT INTO odds_item VALUES('13c0b0f2-5ac2-491f-8a0c-5d2150187bc5','[...
🚣 Executed 1 command in 5.649662002921104ms
  INSERT INTO odds_item VALUES('bf0abcb3-72fc-4876-9c3d-044e2bc4e456','[...
🚣 Executed 1 command in 4.816100999712944ms
  INSERT INTO race_entry VALUES('δ»ŠεΊ¦γ“γε‹γ€',2,13.333333333333333925,'76fe0c...
🚣 Executed 4821 commands in 223.80189414322376ms
2

The executed SQL file is https://github.com/nissy-dev/web-speed-hackathon-2022/blob/main/database/seeds.sql.