From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Nik <XLPizza(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: No buffer space available |
Date: | 2007-03-08 15:57:30 |
Message-ID: | 45F0326A.9090402@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Nik wrote:
> have an SQL file with a set of about 3000 insert statements. This
> file is executed twice from a remote client machine running Windows
> XP. The first time it is executed against a Windows 2003 Server
> running PostgreSQL 8.0. The second time it is executed against a
> Windows 2003 Server running PostgreSQL 8.2. This setup has been in
> place for about a year now and never had any issues.
>
> However, I noticed today that all the file executions fail with
> [nativecode=could not send data to server: No buffer space available
> (0x00002747/10055)] error.
>
> I attempted to run the same file using pgAdmin III version 1.6.2, but
> every time the file is executed the only return in messages pane is
> the colon sign ":". No data is inserted.
>
> I attempted to run the same file using psql.exe and this worked
> without any problems.
>
> I also noticed that if I use less inserts, for example only a few
> hundred, the file executes fine.
>
> What could be the issue?
>
>
First, this is the wrong place to ask this question. pgsql-hackers is
about development of postgres itself, not about usage questions. Perhaps
you should ask on pgsql-general.
Second, if you can run the file using psql, then it does not appear to
be a problem with postgres at all, but rather with the client you are
using (you don't say what that client is). Perhaps your client is trying
a naive method of batching inserts and thus running out of buffer space
- it's hard to tell since you haven't given much information.
In the case of pgAdminIII, you might need to ask on its lists.
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2007-03-08 15:58:33 | Re: |
Previous Message | Tom Lane | 2007-03-08 15:48:12 | Re: WSAStartup() in libpq |