The following bug has been logged online:
Bug reference: 3303
Logged by: Purusothaman A
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Windows XP
Description:Postgresql damages file objects when it grows with more
file objects.
Details:
The below output shows clearly that (same file object in different
databases) the last chunk differs in its length.
You notice that the string
"\015\012\015\012" is
missing some characters in SFRS2, SFRS1 and FASP_AVT database outputs.
sfrs2=> select loid, pageno, length(data) from pg_largeobject where loid =
101177 and pageno = 630;
loid | pageno | length
++
101177 |630 |181
(1 row)
sfrs1=> select loid, pageno, length(data) from pg_largeobject where loid =
41642 and pageno = 630;
loid | pageno | length
---++
41642 |630 |193
(1 row)
fasp_avt=> select loid, pageno, length(data) from pg_largeobject where loid
= 101800 and pageno = 630;
loid | pageno | length
++
101800 |630 |193
(1 row)
sfrs=> select loid, pageno, length(data) from pg_largeobject where loid =
24038 and pageno = 630;
loid | pageno | length
---++
24038 |630 |205
(1 row)
fasp_test=> select loid, pageno, length(data) from pg_largeobject where loid
= 106310 and pageno = 630;
loid | pageno | length
++
106310 |630 |205
(1 row)
1. Output of SFRS2 database:
--
--
101177 |630 | ight_val>\015\012
-2.9928278923034668\015\012
23\015\012-1\015\012
-2.9928278923034668
\015\01223\015\012
-1\015\012\015\012
-2.9928278923034668\015\012
23\015\012-1\015\012\015 \012 -
2.9928278923034668\015\012
23\015\012-1<
/haarcascade_frontalface_default>\015\012\015\012
(631 rows)
5. Output of FASP_TEST database: (Not yet corrupted)
106310 |630 | ight_val>\015\012 -
2.9928278923034668\015\012
23\015\012-1<
/haarcascade_frontalface_default>\015\012\015\012
(631 rows)
Have you noticed "" strings? What could have caused to
damage that part?
This problem happens after database files objects grows periodically, cannot
reproduce this bug immediately.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
