wasm streaming compile failed Suddenly

[radiantone]

sql-wasm.js:98 wasm streaming compile failed: LinkError: WebAssembly.instantiate(): Import #34 "a" "I": function import requires a callable
(anonymous) @ sql-wasm.js:98Understand this errorAI
sql-wasm.js:98 falling back to ArrayBuffer instantiation
(anonymous) @ sql-wasm.js:98Understand this errorAI
sql-wasm.js:98 failed to asynchronously prepare wasm: LinkError: WebAssembly.instantiate(): Import #34 "a" "I": function import requires a callable
(anonymous) @ sql-wasm.js:98Understand this errorAI
sql-wasm.js:97 Aborted(LinkError: WebAssembly.instantiate(): Import #34 "a" "I": function import requires a callable)
G @ sql-wasm.js:97Understand this errorAI
2sql-wasm.js:40 Uncaught (in promise) Error: LinkError: WebAssembly.instantiate(): Import #34 "a" "I": function import requires a callable
at Object.onAbort (sql-wasm.js:40:20)
at G (sql-wasm.js:97:26)
at sql-wasm.js:98:131Understand this errorAI
sql-wasm.js:97 Uncaught (in promise) RuntimeError: Aborted(LinkError: WebAssembly.instantiate(): Import #34 "a" "I": function import requires a callable). Build with -sASSERTIONS for more info.
at G (sql-wasm.js:97:66)
at sql-wasm.js:98:131

Google Chrome (Linux)

[radiantone]

Looks like the recent commit(s) are responsible

[lovasoa]

Hello! Can you provide a reproduction?

[lovasoa]

Can you provide a small, self contained reproduction without any other dependency than sql.js itself?

Please also make sure that the JavaScript code and Wasm binary are from the exact same sql.js version.

[Muhammad-The-Conqueror]

I have the same problem
const sqlPromise = await initSqlJs({ locateFile: (file) =>https://sql.js.org/dist/${file}`,
});
`
the line above is where the error is thrown

[Muhammad-The-Conqueror]

Downloading a matching sql-wasm.wasm file a serving it locally fixed the problem
const sqlPromise = await initSqlJs({ locateFile: () => "/sql-wasm.wasm", });

[lovasoa]

it looks like you are downloading the latest wasm from sql.js.org but using an old version of the JavaScript.

to prevent this from ever happening again, you should either download both the wasm and the JavaScript from the same source or reference both from SQL.js.org

[radiantone]

Ok, let me try that, but I hadn't changed anything from the prior day and then the error just starting happening.

[lovasoa]

yes, if you use a fixed version of the js but the live online latest version of the wasm, then it's gonna break when we update it.

[radiantone]

yes, if you use a fixed version of the js but the live online latest version of the wasm, then it's gonna break when we update it.

Maybe an npm update I did caused it. Here is what my npm says

(venv) darren@pop-os:~/git/va/visualagents$ npm ls |grep sql
├── sql.js@1.11.0
├── sqlite3@5.1.7
├── typeorm-sqljs@1.2.2

<script src="https://cdnjs.cloudflare.com/ajax/libs/sql.js/1.11.0/sql-wasm.js" integrity="sha512-tz0jOZaOg9RtWWB6AdxSkINQwIs7S5obj1Dlml9KewZLPTblTWCux5eLtnexBb8kbLUo5crPmjsi8/vI17Vw0w==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>

The 1.11.0 sql-wasm.js script loads the https://sql.js.org/dist/sql-wasm.wasm which seems to be incompatible. I don't load the .wasm. This code does:

const SQL = await window.initSqlJs({
        // Required to load the wasm binary asynchronously. Of course, you can host it wherever you want
        // You can omit locateFile completely when running in node
        locateFile: (file) => `https://sql.js.org/dist/${file}`,
      });

Still broke for me.

[radiantone]

Ok, here's what I did. I downloaded the latest release zip 1.13.0 of sql.js and locally stored the sql-wasm.js and sql-wasm.wasm files and remove all previous web loading. I removed my node package sql.js which seems redundant. I get this error now.

const SQL = await window.initSqlJs({
        // Required to load the wasm binary asynchronously. Of course, you can host it wherever you want
        // You can omit locateFile completely when running in node
        locateFile: () => "/sql-wasm.wasm",
      });

sql-wasm.js:168 Uncaught (in promise) TypeError: x is not a function
    at x (sql-wasm.js:168:81)
    at f.onRuntimeInitialized (sql-wasm.js:75:315)
    at a (sql-wasm.js:169:432)
    at cd (sql-wasm.js:170:315)
    at bd (sql-wasm.js:168:418)
    at a (sql-wasm.js:161:323)
    at sql-wasm.js:162:21

[lovasoa]

Can you please provide a single self-contained easily executable reproduction ?

[lovasoa]

If you use https://cdnjs.cloudflare.com/ajax/libs/sql.js/1.11.0/sql-wasm.js for the js, but https://sql.js.org/dist/${file}, then your code will break whenever sql.js is updated. If you want to use cdnjs with a fixed version of sql.js, then load the wasm file from there too

[radiantone]

Can you please provide a single self-contained easily executable reproduction ?

https://jsfiddle.net/ywsjqt6m/

There is no CDN url for version 1.13.0 so I had to load 1.12.0 in the fiddle. Maybe you can fix the fiddle so it works?

[radiantone]

If you use https://cdnjs.cloudflare.com/ajax/libs/sql.js/1.11.0/sql-wasm.js for the js, but https://sql.js.org/dist/${file}, then your code will break whenever sql.js is updated. If you want to use cdnjs with a fixed version of sql.js, then load the wasm file from there too

I see what you mean. Trying that.

[radiantone]

Yeah, if I use 1.12.0 for js and wasm both from cdnjs then it works. Thank you.