[rt-users] Attachment correpted after import from rt2->rt3

Magnus Schmidt bestpractical.com.nospam at 27b-6.de
Sun Jan 8 16:51:13 EST 2006


 I'm trying to upgrade a larger rt2 database to rt3. After the upgrade
path to 3.4.4, the attachements of the imported tickets are corrupted
with random bytes (only a few bytes in each file).

Here is the complete migration path:

- Debian sid, perl v5.8.7
- copy of running rt2-Database
- Basic configured rt2
- searchbuilder 0.48 (from woody)
-> rt-2.0-to-dumpfile

- update searchbuilder to 1.33 (sid)
- Basic configured rt-3.2.0, mysql db initialized, all deps satisfied
-> dumpfile-to-rt-3.0

(Later: delta dumps with both steps above)

- Debian sarge,  perl v5.8.4
- Configured rt-3.2.0, mysql db, all deps satisfied
- Imported dump: rt3 db from Machine1
- rt-3.4.4, make upgrade, uprading db-scripts for 3.3.0 and 3.3.11

After these steps all seems to work. However (besides some single
tickets which popped open again) the attachements of the imported
tickets are now corrupted. However newly created tickets with
attachements work without problems. In each file only a few bytes seem
to have changed randomly.

During the delta dump, the dumpfile-to-rt-3.0 choked on a specific
ticket, which seemed to be corrupted. I manually moved it out of the
dumpdir, and all tickets associated with it. Is this a problem ? The
corrupted attachemts are however in both the orignial import and the
delta dump.


More information about the rt-users mailing list