On 24-8-2018 18:31, pab...@adinet.com.uy [firebird-support] wrote: > As I could backup and restore databases from and to firebird 3 on the > same running platform, next step is apply it to raspberry pi. > > I'm getting the following when restoring the same backup file wich > should be "transportable by default" : > > gbak:opened file mybackup-file.fbk > gbak:transportable backup -- data in XDR format > gbak: backup file is compressed > gbak:backup version is 10 > gbak:created database mydb, page_size 8192 bytes > gbak:started transaction > ... > gbak: restoring index RDB$PRIMARY1 > gbak:restoring data for table PLG$SRP > gbak: 2 records restored > gbak: restoring index PK_TABLALOG > gbak: restoring index FK_TABLALOG_USUARIO > gbak:restoring data for table TABLALOG > gbak: ERROR:message length error (encountered -31984, expected 33552) > gbak: ERROR:gds_$send fa iled > gbak:Exiting before completion due to errors > > Are format in these platforms compatible ? Both are, at least, little > endian.
It looks like a mix up of signed and unsigned 16 bit ints. -31984 is a signed 16 bit int as hex 0x8310, and as unsigned 16 bit int, that is 33552. > Restoring file from v2.5 backup, gets the same problem . > > Maybe I stop amd64 server and copy live db to rpi ? Probably not. The database can use platform specific representations of data, and index values depend on the installed ICU version. -- Mark Rotteveel