473,320 Members | 1,948 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

7.3.2 client connecting to 7.2.1 server problem

I have the following packages installed on my system:

libpq3: 7.3.2r1-5
python-pygresql: 7.3.2r1-5
postgresql: 7.2.1-2woody2
postgresql-client: 7.2.1-2woody2

In my application, which is written in python, I get a "server closed the
connection unexpectedly" exception after executing a few sql commands. I
print each query before I execute it (debugging) so I tried executing the
queries through psql with no problems.

Is there a known incompatibility between the versions of client/server that
I'm using? Or a known bug in pygresql?

I tried looking for an option to turn on query logging (I thought one was
present), but for some reason I didn't notice it. Is there a way to log
queries without restarting the server? It's a little troublesome for me to
start and stop the server (it's a production server), but I will if
necessary.

Here are the queries that execute (field names have been obfuscated):
BEGIN;
SELECT active FROM process WHERE xx='aa' FOR UPDATE;
UPDATE process SET active='t' WHERE xx='aa';
COMMIT;
-- server dies while trying to execute query below
SELECT bb.id as id,first,last,type from bb,cc where bb.id=bb_id order by dd
asc limit 1;

Sometimes, strangely, it makes it to a point further in the application but
crashes there instead one a different query (all the same program inputs).
I can't reproduce this result, although I recall it happening twice.

I've been using all that software together for quite some time with no
problems until now.

Any advice is appreciated.

Regards,
Jeff

Nov 11 '05 #1
2 1772
Jeff <as**@asdf.com> writes:
I have the following packages installed on my system:
libpq3: 7.3.2r1-5
python-pygresql: 7.3.2r1-5
postgresql: 7.2.1-2woody2
postgresql-client: 7.2.1-2woody2 In my application, which is written in python, I get a "server closed the
connection unexpectedly" exception after executing a few sql commands.


Hmm. What do you see in the postmaster log when this happens?

BTW, you *really* should update to 7.2.4. There are nasty bugs in
7.2.1. There's not enough info here to guess whether you are hitting
a known bug, though.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 11 '05 #2
On Wed, 2003-09-17 at 21:55, Jeff wrote:
I have the following packages installed on my system:

libpq3: 7.3.2r1-5
python-pygresql: 7.3.2r1-5
postgresql: 7.2.1-2woody2
postgresql-client: 7.2.1-2woody2
[This is clearly a Debian system.]
You seem to have done a partial upgrade to testing; the effect will be
that you have two versions of the libpq library, and python-pygresql
will not be using the same one as pgsql. It looks as though I made the
dependencies too loose in that testing release.
In my application, which is written in python, I get a "server closed the
connection unexpectedly" exception after executing a few sql commands. I
print each query before I execute it (debugging) so I tried executing the
queries through psql with no problems.

Is there a known incompatibility between the versions of client/server that
I'm using? Or a known bug in pygresql?


I suggest you upgrade to the version from unstable (7.3.4-5). Testing
is held up and isn't getting timely upgrades; I would not, myself,
consider it as good as unstable until we get very close to a new Debian
release.

Unstable has versioned python packages. If you want woody versions of
the postgresql packages, you can get them with this apt line:

deb http://people.debian.org/~elphick/debian main

--
Oliver Elphick Ol************@lfix.co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"But my God shall supply all your need according to his
riches in glory by Christ Jesus." Philippians 4:19
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 11 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Krzysztof Pa¼ | last post by:
Hi, I want to make simple client in phyton, which would be able to communicate with Java server using SSL sockets. There is the Java clients, which is doing this - so I'm pretty sure, that Java...
2
by: news.microsoft.com | last post by:
Hi I write dll library which one of it component will be Net socket communication. Communication is working very good, but i've got problem when client is connecting. When server is started,...
7
by: CT | last post by:
Hi, This might seem like a basic question but I have some doubts, please humour me. I have a client-server application using java where each client on each machine needs to directly...
3
by: Roy Souther | last post by:
Trying to get the unixODBC to work connecting to an IBM DB2 UDB V8.1. The DB2 server is running on Red Hat 8 and is tested and confirmed to be serving connections to Windows 98 clients using the...
9
by: DB2 | last post by:
Hello, everyone. Our developers are wondering if their swing Java-based application connecting to a DB2 server through JDBC requires the DB2 client access license (CAL) per user. They've got...
0
by: Usman | last post by:
Hi I'm having problem with a scenarion where I have a server written in C# and client written in VC6++. Here is the server code that i'm using including the Callback function for handling...
5
by: B1ackwater | last post by:
We've fooled around with Access a bit, but only using the single-user store-bought version. It seems to be a good database - versatile and infinitely programmable - and can apparently be used as a...
11
by: David Velazco | last post by:
Hello Everybody, I try to use script to get client IP <% dim IPAddr IPAddr = Request.ServerVariables("remote_addr") Response.Write("Your IP Address is " & IPAddr) %>
6
by: sgulciny | last post by:
hi friends; I have problem about sql server insert and update in client side. I am coding windows application with c#.When I run my code in database server computer all is fine.I can see data,...
0
by: brum2008 | last post by:
Hello! Below is the Netbeans Mobility source code for my application (The application offers SPP service, and then just hangs waiting for a client to connect (using acceptAndOpen()). The other...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.