Subject | Strange error while restoring a DB: String Truncated |
---|---|
Author | Lele Gaifax |
Post date | 2003-07-04T13:59:15Z |
Hi all,
I'm experiencing a strange problem: trying to do a multifile
backup-restore cycle, I get an error message during the restore
phase.
I'm doing the backup with this command:
gbak -b -g -v pathDB1 pathGBK1 1800M pathGBK2
while the restore command is:
gbak -r -v -p 8192 -y pathlog pathGBK1 pathGBK2 pathDB1 \
245000 pathDB2 245000 pathDB3
The original "pathDB1" database is spreaded in three files, the first
is filled at 2Gb, the second is actually 1Gb and the third is empty.
The resulting "pathGBK1" backup is sliced in two parts, 1.7Gb the
first and about 300Mb the second.
Here is the restore log:
gbak: opened file /disk1/dati1/winsipexib/bck/wsx_bck_fo_master.gbk
gbak: opened file /disk1/dati1/winsipexib/bck/wsx_bck_fo_master2.gbk
gbak: transportable backup -- data in XDR format
gbak: backup file is compressed
gbak: created database /disk1/dati1/winsipexib/bck/test_marco.gdb, page_size 8192 bytes
gbak: started transaction
gbak: adding file /disk1/dati1/winsipexib/bck/test_marco2.gdb, starting at page 245001
gbak: adding file /disk1/dati1/winsipexib/bck/test_marco3.gdb, starting at page 490001
gbak: committing secondary files
gbak: restoring domain RDB$759
gbak: ... [omissis] ...
gbak: restoring data for table ZONESETTORI
gbak: 149 records restored
gbak: restoring index IDX_ZONA
gbak: restoring index ZONEPROCESSO0
gbak: ... [omissis] ...
gbak: restoring data for table VARIANTIRIGA
gbak: 10000 records restored
gbak: 20000 records restored
gbak: ... [omissis] ...
gbak: 150000 records restored
gbak: 160000 records restored
gbak: ERROR: string truncated
gbak: Exiting before completion due to errors
The original table VARIANTIRIGA contains more than 2 millions records,
and is coded as
CREATE TABLE VARIANTIRIGA (
CODVARIANTE INTEGER,
FILLER VARCHAR(10) CHARACTER SET NONE,
IDVARIANTERIGA INTEGER NOT NULL,
IDRIGAORDINE INTEGER NOT NULL,
VALORE VARCHAR(30) CHARACTER SET NONE
);
Digging in the original DB did not reveal nothing special in that
table, so I'm really short of idea on what may be going on here...
Any hint?
thanks in advance,
bye, lele.
--
nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri
real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.
I'm experiencing a strange problem: trying to do a multifile
backup-restore cycle, I get an error message during the restore
phase.
I'm doing the backup with this command:
gbak -b -g -v pathDB1 pathGBK1 1800M pathGBK2
while the restore command is:
gbak -r -v -p 8192 -y pathlog pathGBK1 pathGBK2 pathDB1 \
245000 pathDB2 245000 pathDB3
The original "pathDB1" database is spreaded in three files, the first
is filled at 2Gb, the second is actually 1Gb and the third is empty.
The resulting "pathGBK1" backup is sliced in two parts, 1.7Gb the
first and about 300Mb the second.
Here is the restore log:
gbak: opened file /disk1/dati1/winsipexib/bck/wsx_bck_fo_master.gbk
gbak: opened file /disk1/dati1/winsipexib/bck/wsx_bck_fo_master2.gbk
gbak: transportable backup -- data in XDR format
gbak: backup file is compressed
gbak: created database /disk1/dati1/winsipexib/bck/test_marco.gdb, page_size 8192 bytes
gbak: started transaction
gbak: adding file /disk1/dati1/winsipexib/bck/test_marco2.gdb, starting at page 245001
gbak: adding file /disk1/dati1/winsipexib/bck/test_marco3.gdb, starting at page 490001
gbak: committing secondary files
gbak: restoring domain RDB$759
gbak: ... [omissis] ...
gbak: restoring data for table ZONESETTORI
gbak: 149 records restored
gbak: restoring index IDX_ZONA
gbak: restoring index ZONEPROCESSO0
gbak: ... [omissis] ...
gbak: restoring data for table VARIANTIRIGA
gbak: 10000 records restored
gbak: 20000 records restored
gbak: ... [omissis] ...
gbak: 150000 records restored
gbak: 160000 records restored
gbak: ERROR: string truncated
gbak: Exiting before completion due to errors
The original table VARIANTIRIGA contains more than 2 millions records,
and is coded as
CREATE TABLE VARIANTIRIGA (
CODVARIANTE INTEGER,
FILLER VARCHAR(10) CHARACTER SET NONE,
IDVARIANTERIGA INTEGER NOT NULL,
IDRIGAORDINE INTEGER NOT NULL,
VALORE VARCHAR(30) CHARACTER SET NONE
);
Digging in the original DB did not reveal nothing special in that
table, so I'm really short of idea on what may be going on here...
Any hint?
thanks in advance,
bye, lele.
--
nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri
real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.