This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.
Subject: [HACKERS] v6.5.3 oddness ... From: The Hermit Hacker <scrappy@hub.org> Date: Thu, 30 Mar 2000 00:33:15 -0400 (AST) I'm still looking at this, and please excuse the content, but this is for a client ... ============================================================ photos=> select version(); version ------------------------------------------------------------ PostgreSQL 6.5.3 on i386-unknown-freebsd3.4, compiled by cc (1 row) photos=> insert into photos values ( 1 ) ; INSERT 401449 1 photos=> select * from photos; handle_id|picture_url |description|category|posting_date|keywords ---------+-----------------------------------------------------------------------------------------+-----------+--------+------------+-------- | | | | ussy tag on the rocks | | | | e crams a large dildo into her pussy while kissing! | | | | s are naked and horny for eachother | | | | es her girlfriend's clit piercing with her tongue | | | | ly licks her busty friend's lybia | | | | are having a little fun in the dentist's office! | | | | r her girlfriend's face | | | | he 69 for their own devious desires | | | | ree surfer girls got something in mind other than waves | | | | pussy sandwich - a lesbian dream cum true! | | | | teen lesbo lovingly licks her girlfriend's clit | | | | es her girlfriend's wet twat expertly | | | | e lesbian sucks lustfully on her girlfriend's tit | | | | ning their tongues as a prelude to more | | | | s share in a sensual upside down kiss | | | | lays with her girlfriend's and her pussy! | | | | nette dykes kissing on the beach for all to enjoy | | | | red dykes can't wait to get dirty in the sand | | | | e eachother's tonsils | | | | ms a stiff dildo into her girlfriend's twat | | | | wift tongue lashing | | | | teen gets an expert pussy eating from her g/f | | | | y dykes are playing house... who's the man tonight? | | | | y cowboy as they prepare to go for a ride 1| | | | | (25 rows) ================================================================ the interesting part is if I do a pg_dump -t photos photos, I get totally different results: COPY "photos" FROM stdin; \N \N1-0002\Njpg,Lu\Nydykes\Nery sexy lesbians play pussy tag on the rocks \N \N1-0002\Njpg,Lu\Nydykes\Nlonde dyke crams a large dildo into her pussy while kissing! \N \N1-0002\Njpg,Lu\Nydykes\Nhese beach bunnies are naked and horny for eachother \N \N1-0002\Njpg,Lu\Nydykes\Nesbo fondles her girlfriend's clit piercing with her tongue \N \N1-0002\Njpg,Lu\Nydykes\Nuxom blonde expertly licks her busty friend's lybia \N \N1-0002\Njpg,Lu\Nydykes\Nhese dykes are having a little fun in the dentist's office! \N \N1-0002\Njpg,Lu\Nydykes\Norny lesbo cums all over her girlfriend's face \N \N1-0002\Njpg,Lu\Nydykes\Niny teens adapt the 69 for their own devious desires \N \N1-0003\Njpg,Lu\Nydykes\Nhese three surfer girls got something in mind other than waves \N \N1-0003\Njpg,Lu\Nydykes\Nriiple decker pussy sandwich - a lesbian dream cum true! \N \N1-0003\Njpg,Lu\Nydykes\Nute little teen lesbo lovingly licks her girlfriend's clit \N \N1-0003\Njpg,Lu\Nydykes\Nusty lesbo tongues her girlfriend's wet twat expertly \N \N2-0002\Njpg,Lo\Nadykes\Norny blonde lesbian sucks lustfully on her girlfriend's tit \N \N2-0002\Njpg,Lo\Nadykes\Nexy dykes entwining their tongues as a prelude to more \N \N2-0002\Njpg,Lo\Nadykes\Norny young lesbos share in a sensual upside down kiss \N \N2-0002\Njpg,Lo\Nadykes\Nrunette dyke plays with her girlfriend's and her pussy! \N \N2-0002\Njpg,Lo\Nadykes\Nensual brunette dykes kissing on the beach for all to enjoy \N \N2-0002\Njpg,Lo\Nadykes\Not and bothered dykes can't wait to get dirty in the sand \N \N2-0002\Njpg,Lo\Nadykes\Niny titted lesbos explore eachother's tonsils \N \N2-0002\Njpg,Lo\Nadykes\Nlonde dyke rams a stiff dildo into her girlfriend's twat \N \N2-0003\Njpg,Lo\Nadykes\Nexy lesbo enjoys a good swift tongue lashing \N \N2-0003\Njpg,Lo\Nadykes\Nerky titted teen gets an expert pussy eating from her g/f \N \N2-0003\Njpg,Lo\Nadykes\Nhese horny dykes are playing house... who's the man tonight? \N \N2-0003\Njpg,Lo\Nadykes\Nhese dykes play cowboy as they prepare to go for a ride 1 \N \N \N \N \N \. So far, I can't figure out what caused this ... anyone see something similar to this? This table used to have *thousands* of tuples in it, and now nadda: %ls -lt photos* -rw------- 1 pgsql pgsql 737280 Mar 28 23:57 photos -rw------- 1 pgsql pgsql 188416 Mar 23 00:13 photos_hid %ls -lt photos* -rw------- 1 pgsql pgsql 8192 Mar 29 23:28 photos === Subject: Re: [HACKERS] v6.5.3 oddness ... From: Lamar Owen <lamar.owen@wgcr.org> Date: Thu, 30 Mar 2000 11:36:59 -0500 The Hermit Hacker wrote: > > I'm still looking at this, and please excuse the content, but this is for > a client ... [snip] > I can't even think of how/where to debug this ... if it was just a matter > of a delete on the table, and inserting new data, fine, I could deal with > that ... but psql is showing different results then pg_dump? > Jsut thought I'd bring it up ... now much I can do about the lost records, > unfortunately ... This almost identical thing happened to me with one of my tables. Was never able to track it down. I had about 1500 tuples in the relation 'calendar' -- and about three-quarters of them disappeared between 8:30PM and 1:00AM (when I do my automatic backups). No trace, no log, no OS error, no nothing. I figured it was crackers, so I tightened the screws down on some permissions, and it hasn't happened since. This incident (which happened a month or so ago) is what has prompted me to try to get better logging in the RPM dist. I was blocking connections to port 5432 both in pg_hba.conf and at my firewall. The user postgres cannot be directly logged in to from anywhere. The web interface not only logs all deletions to 'calendar', but e-mails me a notification when it is used to delete a 'calendar' item. No e-mails were received. No telnet connections are allowed to this machine. I have not had the same problem again, nor with any other relation. ===