Error when iterating over a GArray

[G159w]

Hi 👋,

Context:

I need to read data from a local SQLight database. First I tried to use JS libraries but couldn't make them works, so I decided to use the the sqlite godot library addon. Then, I made a GDscript with a generic function taking a query as paramater, that will just send it the sqlite library and returning the result. Then, I created a SQLManager which is TS class that will call the GDscript function with the .call Node method.

Issue:

When I am doing a query, the sqlite function returns me an GArray of 13 000 GDictionnary (which have an Id and name). I would like to convert it to a MyObject[] with MyObject corresponding to GDictionnary. If i do this by iterating on the GArray then the app just shut down with no errors. When I launch the Godot editor with console, I can read this on the concole x1000 times:

ERROR: Condition "space_left() < 1" is true. Returning: FAILED
   at: RingBuffer<class Variant *>::write (D:\a\GodotJS-Build\GodotJS-Build\godot\core/templates/ring_buffer.h:145)

Do you know why it is happenning ? It is because i am asking too much resources in the "js realm" ?
Also If you have a better solution for handling a local sqlite database I am interested.

[ialex32x]

Shortly, yes. The current implementation uses a limited size of ringbuffer to exchange Variant between gc thread and main thread to deallocate. I'll improve it right away.

For now, is it possible to read the row one by one from the sqlite addon before this issue get fixed?
BTW, is there any trouble to directly access the sqlite addon in TS instead of gdscript?

[G159w]

Just tried and thank for the tip, it totally works inside the ts ecosystem, I did not need of a gdscript

[ialex32x]

I've requested a new build at GodotJS-Build: Godot4.3_GodotJS0.9.9f1_bundle with a fix for this issue (commit 441fb61).

[G159w]

It works with this v8 editor release, thank you !
(I still have this error with the quickjs-ng editor)

[ialex32x]

Ah yes, quickjs support uses a different process to delete Variant since it's gc is run synchronously, I'll fix it later.

[ialex32x]

Hi @G159w , I double checked it with Godot4.3_GodotJS0.9.9f1_bundle/editor_windows_x64_qjs_ng.zip and locally built editor without encountering this error. May I ask for more details about how the data is read on your side to reproduce it?

[G159w]

Ok after trying it looks like this not the same errror. It crashed at the exact moment where It previously crashed so I thought is was the same, sorry. After investigating, I noticed crashes are not exactly happening at the same time (I cannot find what code cause this problem) but the error in the console is always the same:

ERROR: FATAL: Condition "!(!swapping_free_queue_)" is true.
   at: v8::Isolate::swap_free_queue (D:\a\GodotJS-Build\GodotJS-Build\godot\modules\GodotJS\impl\quickjs\jsb_quickjs_is)

================================================================
CrashHandlerException: Program crashed
Engine version: Godot Engine v4.3.1.rc.custom_build (90f21a35c71107d2afe95a3875bb761ba2170d90)
Dumping the backtrace. Please include this when reporting the bug to the project developer.
[0] <couldn't map PC to fn name>
[1] <couldn't map PC to fn name>
[2] <couldn't map PC to fn name>
[3] <couldn't map PC to fn name>
[4] <couldn't map PC to fn name>
[5] <couldn't map PC to fn name>
[6] <couldn't map PC to fn name>
[7] <couldn't map PC to fn name>
[8] <couldn't map PC to fn name>
[9] <couldn't map PC to fn name>
[10] <couldn't map PC to fn name>
[11] <couldn't map PC to fn name>
[12] <couldn't map PC to fn name>
[13] <couldn't map PC to fn name>
[14] <couldn't map PC to fn name>
[15] <couldn't map PC to fn name>
[16] <couldn't map PC to fn name>
[17] <couldn't map PC to fn name>
[18] <couldn't map PC to fn name>
[19] <couldn't map PC to fn name>
[20] <couldn't map PC to fn name>
[21] <couldn't map PC to fn name>
[22] <couldn't map PC to fn name>
[23] <couldn't map PC to fn name>
[24] <couldn't map PC to fn name>
[25] <couldn't map PC to fn name>
[26] <couldn't map PC to fn name>
[27] <couldn't map PC to fn name>
[28] <couldn't map PC to fn name>
[29] <couldn't map PC to fn name>
[30] <couldn't map PC to fn name>
[31] <couldn't map PC to fn name>
[32] <couldn't map PC to fn name>
[33] <couldn't map PC to fn name>
-- END OF BACKTRACE --
================================================================

For info I have a loading scene checking if new files should be downloaded, if it true then download it, then once finished, go to the main menu. Crashes occurs on both of them, and at the best the menu appears for one minute.