Re: [BUGS] fsync and semctl errors with 8.1.5/win32

2006-11-28 Thread Jeremy Haile
I am currently running 8.1.5, but I'm willing to upgrade to whatever version, use a patched exe, etc. Just let me know what I need to do. On Tue, 28 Nov 2006 23:39:00 +0100, "Thomas H." <[EMAIL PROTECTED]> said: > > Perhaps this should be #ifdef WIN32, although there's probably no harm > > in doi

Re: [BUGS] fsync and semctl errors with 8.1.5/win32

2006-11-28 Thread Thomas H.
Perhaps this should be #ifdef WIN32, although there's probably no harm in doing it on Unixen too. Can someone test this idea? if magnus/dave could provide me a patched rc1 exe, i could run it in our semi-productive environment for some tests. - thomas ---(end of

Re: [BUGS] fsync and semctl errors with 8.1.5/win32

2006-11-28 Thread Jeremy Haile
Yes - processmon always shows the files being locked by postgres.exe processes. My database is being used as a data warehouse, so about all I am doing is bulk insert/updates. I have a job that runs every 5 minutes and loads data into the database. I typically load between 10,000 and 100,000 r

Re: [BUGS] fsync and semctl errors with 8.1.5/win32

2006-11-28 Thread Tom Lane
"Jeremy Haile" <[EMAIL PROTECTED]> writes: > Here's a few seconds of the log output (this has been going on for 10 > mins as of this e-mail being sent): > 2006-11-28 16:16:10 LOG: could not fsync segment 0 of relation > 1663/16404/30267: Permission denied > 2006-11-28 16:16:10 ERROR: storage sync

Re: [BUGS] fsync and semctl errors with 8.1.5/win32

2006-11-28 Thread Thomas H.
I forgot to mention - this problem is occurring on multiple Windows machines. One of them is running Windows XP Professional. The other is running Windows Server 2003. I have disabled indexing, virus scanning, and all non-essential services on both of them. The problem continues to show up eve

Re: [BUGS] fsync and semctl errors with 8.1.5/win32

2006-11-28 Thread Jeremy Haile
I forgot to mention - this problem is occurring on multiple Windows machines. One of them is running Windows XP Professional. The other is running Windows Server 2003. I have disabled indexing, virus scanning, and all non-essential services on both of them. The problem continues to show up even

Re: [BUGS] fsync and semctl errors with 8.1.5/win32

2006-11-28 Thread Jeremy Haile
OK - after uninstalling the virus scanner (McAfee), I still get the same disk access errors. Here's a few seconds of the log output (this has been going on for 10 mins as of this e-mail being sent): 2006-11-28 16:16:10 LOG: could not fsync segment 0 of relation 1663/16404/30267: Permission denied

[BUGS] could not rename temporary statistics file: No such file or directory

2006-11-28 Thread Jeremy Haile
I'm continuing to have file-access related errors with 8.1.5 on Windows. (see my previous post here http://tinyurl.com/yfqhnm) Today I'm having a new problem, which results in the following log output: 2006-11-28 12:15:45 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "gl

Re: [BUGS] BUG #2792: not able to install postgress

2006-11-28 Thread Alvaro Herrera
Santhinesh Kumar wrote: > > The following bug has been logged online: > > Bug reference: 2792 > Logged by: Santhinesh Kumar > Email address: [EMAIL PROTECTED] > PostgreSQL version: 7.1.3 > Operating system: Fedora - 4 > Description:not able to install postgress > Deta

[BUGS] BUG #2791: Error while commiting

2006-11-28 Thread Raman Dabhade
The following bug has been logged online: Bug reference: 2791 Logged by: Raman Dabhade Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Win XP Description:Error while commiting Details: ERROR: SPI_execute_plan failed executing query "commi

[BUGS] BUG #2792: not able to install postgress

2006-11-28 Thread Santhinesh Kumar
The following bug has been logged online: Bug reference: 2792 Logged by: Santhinesh Kumar Email address: [EMAIL PROTECTED] PostgreSQL version: 7.1.3 Operating system: Fedora - 4 Description:not able to install postgress Details: I tried to install postgress of versi

Re: [BUGS] BUG #2785: Exception Issue

2006-11-28 Thread pat hayes
Tom, Thank you for your input. I found a way to check for it by counting the return from a count. Thanks again for your help. PAT From: Tom Lane <[EMAIL PROTECTED]> To: "Patrick Hayes" <

Re: [BUGS] BUG #2790: constructor for int2vector seems to be buggy

2006-11-28 Thread Gurjeet Singh
On 11/28/06, Tom Lane <[EMAIL PROTECTED]> wrote: The syntax is space-separated integers; where did you get the idea to use commas? I donno... I just tried and it worked. But silently ignoring invalid input...!!??? Potential bug's symptoms: http://www.postgresql.org/docs/current/static/bug-re

Re: [BUGS] BUG #2790: constructor for int2vector seems to be buggy

2006-11-28 Thread Tom Lane
"Gurjeet Singh" <[EMAIL PROTECTED]> writes: > In the first INSERT statement, the array elements are separated by a > comma and a space; in the second one, the ones that are separated by just a > comma, do not get inserted! The syntax is space-separated integers; where did you get the idea to u

Re: [BUGS] BUG #2781: database dump/restore problems

2006-11-28 Thread Thomas H.
regarding pg_dump: where there some changes from b3 to rc1 that would explain the resulting rc1 pg_dump output (-c) being half as big as with b3? No... regards, tom lane well, it was 300mb before rc1, and now its only 188mb. inbetween i did a vacuum full on one table. that shoulnd't affect

[BUGS] BUG #2790: constructor for int2vector seems to be buggy

2006-11-28 Thread Gurjeet Singh
The following bug has been logged online: Bug reference: 2790 Logged by: Gurjeet Singh Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2beta3 Operating system: Windows Description:constructor for int2vector seems to be buggy Details: I couldn't find any docum

Re: [BUGS] BUG #2784: Performance serious degrades over a period of a month

2006-11-28 Thread Heikki Linnakangas
Michael Simms wrote: The following bug has been logged online: Bug reference: 2784 Logged by: Michael Simms Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Linux kernel 2.6.12 Description:Performance serious degrades over a period of a mo

Re: [BUGS] BUG #2786: PGADMIN 1.6

2006-11-28 Thread Dave Page
Gilberto Xavier wrote: The following bug has been logged online: Bug reference: 2786 Logged by: Gilberto Xavier Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Linux and Windows Description:PGADMIN 1.6 Details: Where was set the backup a