Activity (RSS)

This bug was closed by mistake: the one to be closed should have been the #196. To be reviewed for 2.5.3

For what I can see it's a pip bug which doesn't take in consideration the setup.cfg. I've reported the issue at https://github.com/pypa/pip/issues/1630

Zaar, if...

The difference is that the failing version is building without:

-DPSYCOPG_EXTENSIONS=1 -DPSYCOPG_NEW_BOOLEAN=1 -DHAVE_PQFREEMEM=1

and we haven't really tested...

Uhm... I was going to reply you that you can pip-install a project from a branch: you could have tested my branch with:

pip install -e git+https://github.com/d...

I knew that :)

Don't know what is the problem. Just run

pip install -e git+https://github.com/dvarrazzo/psycopg.git#egg=psycopg2

Simple pip install psycopg2 w...

Thank you for testing: I'll try to clear the issues with poll too and pack up the release within a few days.

Verified: works for me at https://github.com/dvarrazzo/psycopg.git#d1e1243ba851641feb2920148a...

Waiting for 2.5.3.
Thanks!

Can you provide a stack trace of some sort?

Are you sure 2.5.2 is the version you are using?

If crashes are repeated it smells more you are somehow end up using...

Submitted by: ilengyel@yahoo.com

The package compiles without error; however, python codes using psycopg2 crashes randomly and frequently with "double free or c...

Hello, thank you for the report.

The library is doing what intended: mogrify() and query represent the statement to be sent/just sent to the server, hence it is...

Also just noticed that cursor.mogrify() returns bytes in Python 3. Which is okay because cursor.execute() will happily take either (utf-8 or current client enco...

Also just noticed that cursor.mogrify() returns bytes in Python 3. Which is okay because cursor.execute() will happily take either (utf-8 or current client enco...

Although, thinking about it, fixing this bug could break a lot of extent user code, since the typical way to handle it would be:

cursor.query.decode('utf-8')

...

In python 3.3.4, cursor.query returns a bytes sequence, not a string.
Interestingly, cursor.statusmessage returns a string.

If this is intentional behavior on P...

Pushed a change for this bug in a github branch.

https://github.com/dvarrazzo/psycopg/commits/connection-closed

Will merge to master and release in 2.5.3 but fi...

In debug mode, executing into a broken socket connection:

In [4]: cur.execute('select 1')
[19233] psyco_curs_execute: starting execution of new query
[19233] c...

Yeah, I've spotted it while working on Momoko - dead connection detection stopped functioning when one connects through local socket.

Ugh, thank you for the clarification, I wouldn't have expected such a difference.

BTW, to emphasize, that if one connects through TCP and not local socket, then closed attribute is populated properly.

Yup, thank you for the report: i'd noticed something similar in #192. Thank you for the test case, I'll try to fix it.

We may raise an exception instead of exploding.

http://stackoverflow.com/questions/22019341/segmentation-fault-exte...

I don't mind, happy to help :)

Thank you for the diagnosis: I will mention your contribution in the news (if you don't mind).

Great, script does not block anymore. Now connection.poll() throws

OperationalError: could not send SSL negotiation packet: Resource temporarily unavailable

Hello, thank you for the report.

Can you test with the code in the branch "ticket-194" in my repos?

https://github.com/dvarrazzo/psycopg/tree/ticket-194

Thank y...

Hi,

not sure if this is psycopg2's fault but my script blocks when connecting to unavailable server (or when i drop outgoing connections to port 5432 for testin...

...which is ok because there is no meaningful order. Except that it's not, because SQLAlchemy tries to sort objects on them if they are used as pkey.

Postgres ...

Pushed a str implementation for Json in my master. repr won't change.

I'm not planning to release the change in 2.5 as it may change the programs behaviour in a...

I would say no: users of that property don't expect an extra query to be performed to check the connection is still up. For one, it would become a blocking oper...

Submitted by: matt.bradshaw@gmail.com

At present, it appears as though .closed can lag behind the truth of things. If one explicitly .close()'d the connection, ...

As per discussion on github, Json.__str__ should return getquoted() as many adapters already do. Also note:

1) other adapters should be checked too (range?)
2) ...

Currently, attempt to log or print Json object uses default python's implementation which is useless. Using actual serialized content is much better.

I have sen...

Yeah... 2.2.2 is definitely bugged in an obvious way (severe database contention, poor performance). Thanks for the bug report PVaret and the fix Daniele!

Yeah... 2.2.2 is definitely bugged in an obvious way (severe database contention, poor performance). Thanks for the bug report PVaret and the fix Daniele!

I wasn't able to reproduce this issue with python 2.7.3 / psycopg2 on Debian Lenny 2.6 at least. Was this resolved on/after v2.4.5?

Here's my test program (it's...

I wasn't able to reproduce this issue with python 2.7.3 / psycopg2 on Debian Lenny 2.6 at least. Was this resolved on/after v2.4.5?

Here's my test program (it's...

I wasn't able to reproduce this issue with python 2.7.3 / psycopg2 on Debian Lenny 2.6 at least. Was this resolved on/after v2.4.5?

Here's my test program (it's...

I wasn't able to reproduce this issue with python 2.7.3 / psycopg2 on Debian Lenny 2.6 at least. Was this resolved on/after v2.4.5?

Here's my test program (it's...

Thank you guys for your quick responses and for helping with this issue.

Added a FAQ entry and a note in the JSON docs. Closing the bug.

Well, even less, only register_default_json() exist :) That's because I've expected people wanting to customize the way it is parsed more often than with other ...

@Daniele: it is just that not all SQL types provide a register_default_xxx, only the new type-casters. So, I better like to use the low-level method in example ...