Hi there,

we currently having a problem at some customers we don't really understand.
Sometimes the EDBDatabase.EDBCat File is Zero-Filled .. if we replace it with the .EDBCat.Old file (same size as  the zero'd edbcat) everything works ..

Could you give as a hint or is it bug ?!

Oh yes .. we are using: 2.08 Build 3

Michael


If it was a bug I think people would be setting fire to Tim by now

If the files were different sizes I might suspect something going wrong during an operation such as restructuring or optimising but with them the same size but one zero fillled it sounds as though someone/something is messing around with the file and the most likely culprit (as always) is anti-virus software.


Roy Lambert [Team Elevate]

It's really strange .. the files have the same file-date .. and same-size .. the only difference is the content.

21.05.2012  08:43           218.584 EDBDatabase.EDBCat
21.05.2012  08:43           218.584 EDBDatabase.EDBCat.Old

(EDBDatabase.EDBCat was newer ... [teamviewer download killed the original filedates])


EDBDatabase.EDBCat:

Offset      0  1  2  3  4  5  6  7   8  9 10 11 12 13 14 15

00000000   16 44 82 08 96 30 83 54  38 65 45 75 3E 5E DB 80    D‚ –0ƒT8eEu>^Û€
00000016   00 00 00 00 00 CE 85 01  AA C5 39 B4 BD 4C 54 32        Î… ªÅ9´½LT2
00000032   7E 41 D9 75 B0 8C 03 00  00 00 00 00 00 A0 55 03   ~AÙu°Œ        U
00000048   00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00                   
00000064   00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00                   
00000080   00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00                   
00000096   00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00                   
00000112   00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00                   
00000128   00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00                   
00000144   00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00                   
00000160   00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00                   
00000176   00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00                   
00000192   00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00                   
00000208   00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00                   
00000224   00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00                   
00000240   00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00                   
00000256   00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00                   
00000272   00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00                   
... more zeros till the end


EDBDatabase.EDBCat.Old

00000000   16 44 82 08 96 30 83 54  38 65 45 75 3E 5E DB 80    D‚ –0ƒT8eEu>^Û€
00000016   00 00 00 00 00 CE 85 01  AA C5 39 B4 BD 4C 54 32        Î… ªÅ9´½LT2
00000032   7E 41 D9 75 B0 8C 03 00  00 00 00 00 00 A0 55 03   ~AÙu°Œ        U
00000048   00 00 00 00 00 00 00 00  14 50 00 00 00 00 00 00            P      
00000064   46 4F 00 00 01 00 00 00  04 00 00 00 07 00 00 00   FO              
00000080   44 65 66 61 75 6C 74 0E  00 00 00 44 65 66 61 75   Default    Defau
00000096   6C 74 20 53 63 68 65 6D  61 00 00 00 00 00 00 06   lt Schema       
00000112   00 00 00 53 79 73 74 65  6D 00 00 00 00 2A 00 00      System    *  
00000128   00 66 00 00 00 0A 00 00  00 41 64 64 72 4F 66 66    f       AddrOff
00000144   69 63 65 0E 00 00 00 42  FC 72 6F 20 41 6E 73 63   ice    Büro Ansc
00000160   68 72 69 66 74 00 00 00  00 00 00 06 00 00 00 53   hrift          S
00000176   79 73 74 65 6D 19 00 00  00 32 05 00 00 00 00 00   ystem    2      
00000192   00 00 00 06 00 00 00 53  79 73 74 65 6D 06 00 00          System   
00000208   00 53 79 73 74 65 6D 33  05 00 00 00 00 01 00 00    System3        
00000224   00 06 00 00 00 53 79 73  74 65 6D 06 00 00 00 53        System    S
00000240   79 73 74 65 6D 34 05 00  00 00 00 02 00 00 00 06   ystem4          
00000256   00 00 00 53 79 73 74 65  6D 06 00 00 00 53 79 73      System    Sys
00000272   74 65 6D 35 05 00 00 00  00 03 00 00 00 06 00 00   tem5            
... more content till the end

Michael


I just had a quick look at one of my catalog files in a hex viewer and the first 32 bytes are the same so it looks as though that is a generic header that Tim puts in. The fact that the timestamps are the same suggests that the .OLD was created as part of an operation that requires the catalog to be altered (possibly a restructure). Maybe Tim writes out a load of zeros to ready the catalog for writing essentially reserving space but I doubt it (without the source I don't know for certain).

1. Was a restructure or some other form of block operation carried out at the time the .OLD was created? Looking at the pdf manual it looks like its restructure, optimisation, or repair that create a .OLD.

2. If its only some customers get details of the systems (Bellarc Advisor has a free edition that's pretty good) and from customers that don't have the problem and see what the difference is.

My money is on anti-virus

Roy Lambert [Team Elevate]

My boss told me its happening also in other versions of elevatedb ... i told him about the antivirus idea .. we will see

Michael


This is wild speculation now, but it may be that a very different version of ElevateDB (or the utilities) could cause this - I doubt it but its another thought.

Does your app have restructure, optimise or repair facilities built in? If so try building in some check code around that, if not your users are using EDBManager to do things which can be very dangerous.

Roy Lambert [Team Elevate]

I think I might agree with Roys speculation. If somewhere you have a program on a dramatically different build of EDB it could be messing with structures in this way. I know there can be problems with BLOB field-storage between different builds.

Adam

... and again .. the catalog file is damaged. this time we used the precompiled elevate-server-binary.
So i think the Version is not problem anymore cause all our client-apps are using the server-process.

Well we noticed in the logs an exception while excuting queries .. like .. "Unexpected Networkerror."
but what i cant understand is why everytime this file is getting "zero'd" when it happens.

Just bad timing ?! i don't think so .. well we are trying to get the server-logs from the customer ... perhaps this helps to  locate the error.

Michael


You never answered the question I asked before

"Does your app have restructure, optimise or repair facilities built in? If so try building in some check code around that, if not your users are using EDBManager to do things which can be very dangerous."

Roy Lambert [Team Elevate]