The extremely cantankerous genmapsdata.db3 file......

Darren Clemons

Well-Known Member
Well, again today, the wonderfully and consistently corrupt genmapsdata.db3 file reared it’s ugly head yet again. Can anyone please explain or tell me why that seems to be unfixable?

We were told (back in September) that “that will be fixed when Linux update comes out soon”.....well, it’s six months later and no Linux update and no fix for the corrupt file.

It is, without a doubt, directly tied to archiving and/or the unpacking of jobs and is only a problem when there are those (in my opinion) useless duplicated coordinate systems made. It seems that when those duplicate systems are made, and then the jobs that were associated with those duplicate systems are archived and then deleted, if you don’t also delete the duplicate coordinate system, THAT is when we get the dreaded “cannot read dB” message.

Once you see that message - you’re screwed. It’s time to get out to windows screen, find where the file is stored, delete it, reboot and hope everything’s back in order. Today was probably the 15th to 20th time I’ve had to do this since last September.

Question one. Am I the only one seeing this this often?
Question two. If I am, then what could I possibly be doing that would cause this?

I am on the release version of Jfield, I always start and use Ky State Plane single zone for all my jobs with epoch 2010.

Does no good to send job archive, I’ve sent a few months ago and the machine won’t even DO an archive on the job once that file is corrupt. Then, once file is deleted and system is rebooted,the job is “normal” again....nothing evident that anything was ever wrong.

I certainly have no clue as to the intricacies of the programming within the LS, as it is unimaginable,but this really seems like something that shouldn’t take SIX months to fix.
From my experiences, stop the creation of duplicate coordinate systems and this problem stops. It has NEVER happened in any of our LS’s when there isn’t multiple duplicated coordinate systems in the list.
 

Matt Johnson

Well-Known Member
5PLS
Can anyone please explain or tell me why that seems to be unfixable?

The problem is that no one has found a repeatable way to cause this database file to become corrupt. If you have a step by step procedure that causes it to become corrupt repeatedly it may be more fixable. It may very well be a problem with Microsoft's file system in which case Linux should resolve it.
 

Darren Clemons

Well-Known Member
The problem is that no one has found a repeatable way to cause this database file to become corrupt. If you have a step by step procedure that causes it to become corrupt repeatedly it may be more fixable. It may very well be a problem with Microsoft's file system in which case Linux should resolve it.
....an exact step by step....not really, but it seems to always be after archiving and/or unpacking a job (which I’ve completely stopped doing because of this). This morning, I archived and then deleted 10 jobs, then started one as normal and dumped in about 15 design points. Hadn’t seemed to have it happen since I stopped unpacking previous projects (which, of course is where the duplicate systems are made), but Scott called and had shot a pin three times but when he tried to inverse, the point wasn’t there. I knew immediately what was up. This job was close so I had him return to office instead of getting into RAMS and when I looked at my crd systems, there were two duplicates (my usual single zone but with a date attached at the end). I don’t know how these even came about because these two jobs were not even unpacked from an archive but they WERE specifically tied to a job that I had archived and then deleted earlier this morning - I’m thinking that must’ve had something to do with this latest lockup.

Again, why not just stop having the LS produce duplicate coordinate systems? I truly believe this will stop the problem.
What is the purpose of the duplicated, dated crd system?
 

Mikhail Drakin

Developer
This problem has several aspects. To make a long story short: First of all, there is a Windows CE filesystem bug which from time to time hits one LS device or another causing total data loss with the need to use recovery SD (that's why regularly creating either project archives or full backup is a must). The only way to fix it is going Linux. Next, there are problems with handling GenMapsData.db3 itself. This file (single-file index of data in all projects) is legacy from older times and we hope to eventually eliminate it, though unfortunately it requires major effort. Thirdly, there obviously is some problem with coordinate systems duplication which is not related to the first two abovementioned and which some customers sometimes encounter, @Vladimir Prasolov probably may tell more and investigate your specific case.
All these issues have been partially addressed in 2.1 version which is in Pre-release/Testing update branches now. We decided to postpone releasing it till transition to Linux. Unfortunately, installing 2.1 on Windows has triggered the deadly Windows bug for some persons. If you are on 2.0 now, you may try 2.1 now under guidance of someone from PLS team, they have experience of working with 2.1.
 

Darren Clemons

Well-Known Member
Mikhail, I ran the pre release for about 4 weeks. I was one of the unfortunate users that had a complete system failure upon initially installing it. However, after using recovery SD, it "appeared" to work fine for a while so I stayed on it, but I did start seeing a few bugs so I went back to the current release version.

While I don't believe I ever had the "cannot read db" error message while using it, I did find that I could not successfully archive projects. I would receive an error message every time I tried and was told THAT was also tied to this same infamous file.....

I also started seeing a bug when trying to rotate design points where after moving, the PB I needed to select was absent from my list even though I had just used that exact same point in the move function....anyway, I decided to go back to release.

What seems so odd with this file though is we have been users now for almost 3 years and for the first 2 to 2 1/2 years we NEVER had an issue with this - it just suddenly began about mid summer of last year for some reason.

Sounds as though there's not much hope of it getting "fixed" completely until the switch to Linux is complete, which, of course, leads to the question.....When is it going to be fully functional and ready for us to use?
 

Jim Frame

Well-Known Member
Is it possible to push an OS change over the support connection, or will we have to download an image and launch it from an SD card or thumb drive?
 
Top