Multimedia/Discussion/General/Aviage MME release 20.14 - Database schema mismatch/List of Posts
 
Forum Topic - Aviage MME release 20.14 - Database schema mismatch:
   
Update
Radek Pesina
03/26/2009 2:16 AM
post25274
Aviage MME release 20.14 - Database schema mismatch   
Hi,

We have tried updating our Aviage Mulitimedia Suite from v20.13 to v20.14 and when for example we plug in a USB memory 
stick with audio media files on it, during the database automatic synchronisation process we recieve the error:

Database Schema versions mismatched
File:mme.sql Database:main expected:30 got:<not found> File:mme_library.sql Database:mme_library expected:12 got:<not 
found> File:mme_temp.sql Database:mme_temp expected:7 got:<not found>


Does anyone know why we received this error?  It appears that some of the SQL libraries/binaries were not updated in the
 20.14 patch.


Regards,
Radek.
Ryan Allen(deleted)
03/26/2009 4:53 AM
post25285
Re: Aviage MME release 20.14 - Database schema mismatch   
Radek Pesina wrote:
> Database Schema versions mismatched
> File:mme.sql Database:main expected:30 got:<not found> File:mme_library.sql Database:mme_library expected:12 got:<not 
found> File:mme_temp.sql Database:mme_temp expected:7 got:<not found>
> 
> Does anyone know why we received this error?  It appears that some of the SQL libraries/binaries were not updated in 
the 20.14 patch.

If the sql files weren't updated the expected result would show 
"expected:<new_version> got:<old_version>", but the result here says 
"not found".

I suspect that means you're either running the MME with a -V argument 
and qdb isn't running, or qdb is running but the .sql files weren't 
loaded (or aren't valid).

If you're looking at the source look at services/mme/lib/mme.c and 
lib/sql.c for references to the function sql_verify_database_versions().

-- 
Ryan J. Allen
QNX Software Systems
Dan Cardamore(deleted)
03/26/2009 11:33 AM
post25362
Re: Aviage MME release 20.14 - Database schema mismatch   
I'm guessing that your real database files have 0 size (see your qdb.cfg file for where you have pointed to create them)
.

Best delete the database files and see if QDB can create them again when you start it.  Run with verbosity on QDB to get
 more error output.  Make sure you're not putting the database files onto a CIFS, NFS, or /dev/shmem, none of those are 
supported.
Radek Pesina
03/26/2009 6:01 PM
post25409
Re: Aviage MME release 20.14 - Database schema mismatch   
Okay thanks, yes this problem was caused by some of the .sql files were missing. The folder name db which contains the 
necessary .sql files has gone for some reason after updating Aviage Multimedia Suite from 20.13 to 20.14. I think 
Momentics needs to be re-installed on the PC used as it has shown some abnormal behaviour which is not occurring on 
other installs.

Cheers,
Radek.

Return