Re: Writing Blobs from Streams Failing in SQLite... SOMETIMES...
Posted: 18.10.2022, 12:06
Well, common approach to solving almost any issue is localize it first. So trace all the lines up to DB client lib call and push checks here and there (luckily Zeos comes with sources so you can modify the code).
Another way is to find the exact Zeos commit which introduced the issue. If you say you've had no such issues with v7 then revert to v7 commit and then apply further commits til the issue appears. You can use Git's bisect feature to reduce iterations.
Btw, do you use the same SQLite lib when issue happens and when not? Maybe it's not a Zeos fault?
Another way is to find the exact Zeos commit which introduced the issue. If you say you've had no such issues with v7 then revert to v7 commit and then apply further commits til the issue appears. You can use Git's bisect feature to reduce iterations.
Btw, do you use the same SQLite lib when issue happens and when not? Maybe it's not a Zeos fault?