WIN1250 characters in triggers/procedures may CORRUPTING databases (maybe at
backup/restore)
--------------------------------------------------------------------------------------------
Key: CORE-4723
URL: http://tracker.firebirdsql.org/browse/CORE-4723
Project: Firebird Core
Issue Type: Bug
Components: Engine, GBAK
Affects Versions: 2.5.3 Update 1
Environment: win7, xp
Reporter: Laszlo Szakmari
Example:
http://pcpincer.hu/downloads/corruptdb/termipro.zip
(=10.5MB ... orig size=410MB)
History:
1.) We've changed from v2.1.5 to the new v2.5.3.
2.) We've used the "update metadata" sql script, and seemed to work everything
fine
3.) .. and also using the -fix_metadata option at every (daily) restore
4.) Since than more and more customers reporting corrupted databases.
Symptoms:
1. by adding a few records and doing a backup/restore >> the DB size doubles !
after a few days 100K records = 400MB :( ... instead of 5MB
2. it's getting filled up with garbage
3. Sweep, Mend, repair, backup/restore does NOT help
4. Some triggers / procedures do not work
5. !!! >>> looking at those SPs > I've realized those SPs and Triggers
containing Hungarian characters as comment or exception > ending at half...
6. When opening tables, etc > it's very slow (maybe the big filesize...)
Solution:
- nothing yet :( tried everything
- the only way I can "repair" is to :
1. export every data one by one,
2. make an empty DB (keeping only metadata) (from a not corrupted DB)
3. import data back
4. reactivate triggers and indexies
Personal:
- this "repair" procedure takes me 3-4 hours each time, I had no sleep since 4
days, because can work on remote computers only at night.
Today an other customer called me... have to do it again. And they blame me
for loosing money by not getting correct invoice-money!
Question / possible problem:
- Is it possible that the restore function does not recognize > metadata
already converted to unicode? And re-re-coding it, if we use -fix_metadata ...
switches?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
