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

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

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

https://community.logos.com/discussion/comment/66986#Comment_66986

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

https://community.logos.com/discussion/comment/66994#Comment_66994

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)

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.)

https://community.logos.com/discussion/comment/67007#Comment_67007

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

https://community.logos.com/discussion/comment/67038#Comment_67038

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:

https://community.logos.com/discussion/comment/67067#Comment_67067

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:

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.

https://community.logos.com/discussion/comment/66986#Comment_66986

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.

https://community.logos.com/discussion/comment/67073#Comment_67073

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

https://community.logos.com/discussion/comment/67076#Comment_67076

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. [:$]

https://community.logos.com/discussion/comment/67082#Comment_67082

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.

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?

https://community.logos.com/discussion/comment/67090#Comment_67090

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)

https://community.logos.com/discussion/comment/67067#Comment_67067

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).

https://community.logos.com/discussion/comment/67045#Comment_67045

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

https://community.logos.com/discussion/comment/67165#Comment_67165

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

Thanks, Bradley. You rock!

https://community.logos.com/discussion/comment/67169#Comment_67169

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

https://community.logos.com/discussion/comment/67192#Comment_67192

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