Subject | Re: Frequent database corruption |
---|---|
Author | cprund |
Post date | 2007-07-23T12:46:12Z |
Did you do a surface-scan of the HDD? Considering you're playing with
old hardware, I assume old HDD.
--
Cosmin Prund
--- In firebird-support@yahoogroups.com, "Aeschbacher,
Fabrice" <fabrice.aeschbacher@...> wrote:
old hardware, I assume old HDD.
--
Cosmin Prund
--- In firebird-support@yahoogroups.com, "Aeschbacher,
Fabrice" <fabrice.aeschbacher@...> wrote:
>corruption. The
> Hi,
>
> OS : Linux kernel 2.4.21
> Version: LI-V6.3.1.4481 Firebird 1.5 / superserver
>
> We are using firebird on an embedded device for a while (i386,
> RAM=128MB), and are experiencing very frequent database
> database file is in this case even no more being able to bebackuped
> with gbak. In firebird.log, I can see many errors:length
>
>
> eds2-2STD-VID (Server) Wed Jul 4 11:05:00 2007
> Database: /data/db/sistore_cx.fdb
> internal gds software consistency check (wrong record
> (183))length
> ...
>
> eds2-2STD-VID (Server) Wed Jul 18 16:59:54 2007
> Database: /data/db/sistore_cx.fdb
> internal gds software consistency check (wrong record
> (183))20
>
> In this case, some SQL queries will allways fail:
> SELECT * FROM EventsUnfinished( '____00__', '____0_0_', '2007-07-
> 17:10:34.000' )and
> => internal gds software consistency check (can\'t continue after
> bugcheck)
>
> In this case, the only thing we can do is to delete the database
> re-create a new one. Allmost all databases get corrupted, soon orlater,
> leading to a complete loss of all datas.
>
> In the application, there is only one unique thread executing all
> queries (so no consequent access at all).
>
> Has someone any idea that could help us to solve this problem?
>
> Best regards
> Fabrice Aeschbacher
>