4.0a SR-2: crash "SQLiteException: Attempt to write a read-only database" when attempting to Stop a

Rosie Perera
Rosie Perera Member Posts: 26,194 ✭✭✭✭✭
edited November 2024 in English Forum

Steps to Repro:

1. Open Logos with blank layout, Indexing is paused (doesn't matter; the crash happens even if it's running but I paused it to take that out of the equation)
2. Open Passage Guide and run it on entire Bible (Gen-Rev)
3. After a few seconds, click on Stop

Result:
Most of the sections gradually stop their progress bars one by one. But Handouts, Biblical People & Biblical Places keep going. After a few more seconds, Logos crashes.

Log files: 2816.SQLiteException.zip

Comments

  • Rosie Perera
    Rosie Perera Member Posts: 26,194 ✭✭✭✭✭

    Tried again after indexing was completed and after a reboot. Same crash still happens.

  • Chris Elford
    Chris Elford Member Posts: 1,012 ✭✭✭

    Steps to Repro:

    1. Open Logos with blank layout, Indexing is paused (doesn't matter; the crash happens even if it's running but I paused it to take that out of the equation)
    2. Open Passage Guide and run it on entire Bible (Gen-Rev)
    3. After a few seconds, click on Stop

    Result:
    Most of the sections gradually stop their progress bars one by one. But Handouts, Biblical People & Biblical Places keep going. After a few more seconds, Logos crashes.

    Log files: 2816.SQLiteException.zip">http://community.logos.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/76/2816.SQLiteException.zip]

    Wow, that's a big passage, Rosie!

    I'm running it now - overworking my processor like it was indexing! No crash yet and it has been a couple of minutes.

    Not sure what it will do with Cross References and Parallel passages??? For the whole Bible???

    Is this asking too much of the program?

    Chris

  • Chris Elford
    Chris Elford Member Posts: 1,012 ✭✭✭

    My goodness, I'm not reading well this morning - and it is almost noon (here).

    I finally pushed "stop" and everything stopped except the Biblical People, Places and Things - I have handouts closed until Thomas gives them a thumbs up.

    But I'm not getting a crash, still. Running almost 10 minutes and 1 min after I pushed "stop." Not finishing stopping either.

    Chris

     

  • Chris Elford
    Chris Elford Member Posts: 1,012 ✭✭✭

    Rosie,

    Still not getting a crash, but it is frozen now that I've tried to close the panel. Processor is still going hard, but the Biblical Places, People and Things have "stopped" - not showing as "not responding."

  • Bradley Grainger (Logos)
    Bradley Grainger (Logos) Administrator, Logos Employee Posts: 12,054

    2. Open Passage Guide and run it on entire Bible (Gen-Rev)

    If you can confirm for me (using Task Manager) that this step causes Logos 4 to use over 100,000 handles, then you've found a known bug. (I'm working on it right now... when I'm not reading the forums.)

  • George Allakhverdyan
    George Allakhverdyan Member Posts: 1,075 ✭✭✭


    Rosie,

    Still not getting a crash, but it is frozen now that I've tried to close the panel. Processor is still going hard, but the Biblical Places, People and Things have "stopped" - not showing as "not responding."


    You must have a powerful processor! I can get the crash on my single core amd x64 @1.8ghz

  • Rosie Perera
    Rosie Perera Member Posts: 26,194 ✭✭✭✭✭

    If you can confirm for me (using Task Manager) that this step causes Logos 4 to use over 100,000 handles, then you've found a known bug. (I'm working on it right now... when I'm not reading the forums.)

    Nope. Nowhere near. Here's the screen shot showing how many handles were in use by Logos at the time of the crash:

    image

  • George Allakhverdyan
    George Allakhverdyan Member Posts: 1,075 ✭✭✭


    If you can confirm for me (using Task Manager) that this step causes Logos 4 to use over 100,000 handles, then you've found a known bug. (I'm working on it right now... when I'm not reading the forums.)

    Nope. Nowhere near. Here's the screen shot showing how many handles were in use by Logos at the time of the crash:

    image


    Not to ruin your fun, but I believe I have logged both of these issues (read-write error and > 100,000 handles and not responding) last week.

  • Rosie Perera
    Rosie Perera Member Posts: 26,194 ✭✭✭✭✭


    Wow, that's a big passage, Rosie!

    Yeah, I wouldn't have chosen to do that normally, but I was following what Martha said she did as a workaround to see the list of what saved reports you've got. I have no idea how she managed to do it without crashing either. How many resources do you have in your library? Maybe the fact that I've got Portfolio plus a bunch more (2213 total resources) has more to do with it than processor power. I've got a pretty powerful one -- Intel quad core 2.4GHz with 8 GB RAM.

  • Rosie Perera
    Rosie Perera Member Posts: 26,194 ✭✭✭✭✭


    Not to ruin your fun, but I believe I have logged both of these issues (read-write error and > 100,000 handles and not responding) last week.


    That doesn't ruin anything for me. All I'm trying to do is help Logos become a more solid product. It's actually not very fun spending time trying to get a good solid reproducible case for you with logs and all, so I'm pleased that you can reproduce it. The fact that I can still reproduce this in 4.0a SR-2 means that your logging those issues last week wasn't enough to get them fixed in time for the bugfix release yesterday. Hope that doesn't ruin your fun. [:)]

  • MJ. Smith
    MJ. Smith MVP Posts: 54,738

    Yeah, I wouldn't have chosen to do that normally, but I was following what Martha said she did as a workaround to see the list of what saved reports you've got.

    I suspect that it works for me because I use a very stripped down Passage Guide which uses a small subset of resources and skips all the sermon, person, place, thing type stuff ... Sorry it didn't occur to me to mention that. One could build a minimal Passage Guide specifically for this purpose - I just happened to have one as the default. [:$]

    Orthodox Bishop Alfeyev: "To be a theologian means to have experience of a personal encounter with God through prayer and worship."; Orthodox proverb: "We know where the Church is, we do not know where it is not."

  • George Allakhverdyan
    George Allakhverdyan Member Posts: 1,075 ✭✭✭


    Not to ruin your fun, but I believe I have logged both of these issues (read-write error and > 100,000 handles and not responding) last week.

     

    That doesn't ruin anything for me. All I'm trying to do is help Logos become a more solid product. It's actually not very fun spending time trying to get a good solid reproducible case for you with logs and all, so I'm pleased that you can reproduce it. The fact that I can still reproduce this in 4.0a SR-2 means that your logging those issues last week wasn't enough to get them fixed in time for the bugfix release yesterday. Hope that doesn't ruin your fun. Smile


    Trust me Rosie, we really do appreciate the effort! It helps us a ton. The devs are under a LOT of pressure so I don't blame them for not finding a fix yet. It is reasonable to push this to a lower priority since the search is a very extreme case. People don't really have a need to do a search on Gen-Rev, right?

  • Rosie Perera
    Rosie Perera Member Posts: 26,194 ✭✭✭✭✭


    Trust me Rosie, we really do appreciate the effort! It helps us a ton. The devs are under a LOT of pressure so I don't blame them for not finding a fix yet. It is reasonable to push this to a lower priority since the search is a very extreme case. People don't really have a need to do a search on Gen-Rev, right?


    Yes, that totally makes sense. I didn't mean to put any undue pressure on the developers. They've been absolutely terrific, and I hope they know that! I remember being a developer at MS and feeling like the testers were out to get us, but we're all really all on the same team with the same goals.

  • Bradley Grainger (Logos)
    Bradley Grainger (Logos) Administrator, Logos Employee Posts: 12,054


    If you can confirm for me (using Task Manager) that this step causes Logos 4 to use over 100,000 handles, then you've found a known bug. (I'm working on it right now... when I'm not reading the forums.)

    Nope. Nowhere near. Here's the screen shot showing how many handles were in use by Logos at the time of the crash:


    You're right; it looks like a different bug (which I've now been able to reproduce and fix).

  • Chris Elford
    Chris Elford Member Posts: 1,012 ✭✭✭


    Rosie,

    Still not getting a crash, but it is frozen now that I've tried to close the panel. Processor is still going hard, but the Biblical Places, People and Things have "stopped" - not showing as "not responding."


     

    You must have a powerful processor! I can get the crash on my single core amd x64 @1.8ghz

    Sorry, George, for taking so long to respond - I had to terminate L4 finally and then had to do some home chores and lunch - really can't believe my family expects time from me!!!

    I have a dual core Intel at 2.0ghz and 4 Gigs of RAM. Frozen but not crashing is good, right?

    Chris

  • Rosie Perera
    Rosie Perera Member Posts: 26,194 ✭✭✭✭✭


    You're right; it looks like a different bug (which I've now been able to reproduce and fix).


    Thanks, Bradley. You rock!

  • George Allakhverdyan
    George Allakhverdyan Member Posts: 1,075 ✭✭✭


    Sorry, George, for taking so long to respond - I had to terminate L4 finally and then had to do some home chores and lunch - really can't believe my family expects time from me!!!

    No worries!

  • Dave Hooton
    Dave Hooton MVP Posts: 36,082

    Rosie, has your indexing finished OK? Your log indicated it was in the last stage after indexing everything.

    Dave
    ===

    Windows 11 & Android 13

  • Rosie Perera
    Rosie Perera Member Posts: 26,194 ✭✭✭✭✭

    Yes, my indexing has finished fine, but the crashing bug still happens (even after rebooting and restarting Logos), so it didn't have anything to do with Indexing. Not to worry. Bradley has found it and fixed it. I'm still waiting to reboot and try my other crashing bug again to see if that one is still there too.