What do you mean by "table critical size is 36.6 gb"?
Can't I store jpgs in a blob field?
See the statistcs below of my table with images (jpg) on a blob field:
----------------------------------------
Database header page information:
Flags 0
Checksum 12345
Generation 13469
Page size 16384
ODS version 10.1
Oldest transaction 200
Oldest active 13461
Oldest snapshot 13461
Next transaction 13462
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Oct 7, 2005 18:22:38
Attributes force write, no reserve

Variable header data:
Sweep interval: 20000
*END*


Database file sequence:
File HCobranca.fdb is the only file

Database log page information:
Creation date
Log flags: 2
No write ahead log

Next log page: 0

Variable log data:
Control Point 1:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Control Point 2:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Current File:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
*END*

Analyzing database pages ...

TITULOS (135)
Primary pointer page: 155, Index root page: 156
Data pages: 1143, data page slots: 1143, average fill: 98%
Fill distribution:
0 - 19% = 1
20 - 39% = 4
40 - 59% = 4
60 - 79% = 0
80 - 99% = 1134
----------------------------------------


Best regards,

Valdir Marcos

----- Original Message -----
From: Alexey Kovyazin
To: firebird-support@yahoogroups.com
Sent: Wednesday, October 26, 2005 7:06 AM
Subject: Re: [firebird-support] database corruption without system restart


Hello, Michal!

>Exception: database file appears corrupt ()
>wrong page type
>page 1849263 is of wrong type (expected 7, found 0)

Index was corrupted.


>Exception: database file appears corrupt ()
>wrong page type
>page 4051 is of wrong type (expected 5, found 0)

Table (data) was corrupted.

Did you check RAM?
It may be a reason.

Also you may gather database statisctis and take a look on table size -
the critical size is 36.6 gb.

Please feel free to contact me in private.

Sincerely yours,
Alexey Kovyazin
www.ibsurgeon.com




> hello,
>
> on one system i've experienced the following problem:
>
> firebird ss 1.5.2 on windows 2003
>
> one day, our application stop working, in log files i've found
> exception database corruption:
>
> Exception: database file appears corrupt ()
> wrong page type
> page 1849263 is of wrong type (expected 7, found 0)
>
> i took the last backup and restore - no problems; to check more
> i run gfix -v -full, no error messages. restart the system to
> be sure is clean.
>
> after few days of working again the same problem:
>
> Exception: database file appears corrupt ()
> wrong page type
> page 4051 is of wrong type (expected 5, found 0)
>
> the database is about 40GB size and one table has more than
> 100e6 records. is there some magic number i'm not aware of?
>
> what could cause the problem? hardware rather not - no messages
> in the event log, i will do the disk scan but can not stop computer at
> the moment.
>
> thanks in advance,
> ....michal
>
>


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




------------------------------------------------------------------------------
YAHOO! GROUPS LINKS

a.. Visit your group "firebird-support" on the web.

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


------------------------------------------------------------------------------



[Non-text portions of this message have been removed]