[Django] #12171: transaction.rollback_savepoint fails with postgresql database backend

[noreply-71]

#12171: transaction.rollback_savepoint fails with postgresql database backend
------------------------------------------+---------------------------------
 Reporter:  andrewbadr                    |       Owner:  nobody    
   Status:  new                           |   Milestone:            
Component:  Database layer (models, ORM)  |     Version:  1.1      
 Keywords:                                |       Stage:  Unreviewed
Has_patch:  0                             |  
------------------------------------------+---------------------------------
 Calls to transaction.rollback_savepoint fail because they try to create a
 new cursor, which executes "SET client_encoding to 'UNICODE'" inside the
 already failed transaction. This is in 1.1 and trunk (r11724).

 To repro: create a project w/the "postgresql" database backend, and do
 `python runtests.py get_or_create`.

 Example traceback:
 {{{
  File "/var/www/yourworld/ywot/views.py", line 136, in send_edits
    tile, _ = Tile.objects.get_or_create(world=world, tileY=tileY,
 tileX=tileX)

  File "/usr/local/lib/python2.6/dist-
 packages/django/db/models/manager.py", line 123, in get_or_create
    return self.get_query_set().get_or_create(**kwargs)

  File "/usr/local/lib/python2.6/dist-packages/django/db/models/query.py",
 line 339, in get_or_create
    transaction.savepoint_rollback(sid)

  File "/usr/local/lib/python2.6/dist-packages/django/db/transaction.py",
 line 199, in savepoint_rollback
    connection._savepoint_rollback(sid)

  File "/usr/local/lib/python2.6/dist-
 packages/django/db/backends/__init__.py", line 67, in _savepoint_rollback
    self.cursor().execute(self.ops.savepoint_rollback_sql(sid))

  File "/usr/local/lib/python2.6/dist-
 packages/django/db/backends/__init__.py", line 81, in cursor
    cursor = self._cursor()

  File "/usr/local/lib/python2.6/dist-
 packages/django/db/backends/postgresql/base.py", line 127, in _cursor
    cursor.execute("SET client_encoding to 'UNICODE'")

 ProgrammingError: ERROR:  current transaction is aborted, commands ignored
 until end of transaction block

 SET client_encoding to 'UNICODE'
 }}}

--
Ticket URL: <http://code.djangoproject.com/ticket/12171>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Django updates" group.
To post to this group, send email to django-updates@...
To unsubscribe from this group, send email to django-updates+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---

[noreply-71]

#12171: transaction.rollback_savepoint fails with postgresql database backend
---------------------------------------------------+------------------------
          Reporter:  andrewbadr                    |         Owner:  nobody
            Status:  new                           |     Milestone:        
         Component:  Database layer (models, ORM)  |       Version:  1.1  
        Resolution:                                |      Keywords:        
             Stage:  Unreviewed                    |     Has_patch:  0    
        Needs_docs:  0                             |   Needs_tests:  0    
Needs_better_patch:  0                             |  
---------------------------------------------------+------------------------
Changes (by andrewbadr):

  * needs_better_patch:  => 0
  * needs_tests:  => 0
  * needs_docs:  => 0

Comment:

 Eh, botched the title. :)

--
Ticket URL: <http://code.djangoproject.com/ticket/12171#comment:1>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Django updates" group.
To post to this group, send email to django-updates@...
To unsubscribe from this group, send email to django-updates+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---

[noreply-71]

#12171: transaction.savepoint_rollback fails with postgresql database backend
---------------------------------------------------+------------------------
          Reporter:  andrewbadr                    |         Owner:  nobody
            Status:  new                           |     Milestone:        
         Component:  Database layer (models, ORM)  |       Version:  1.1  
        Resolution:                                |      Keywords:        
             Stage:  Unreviewed                    |     Has_patch:  0    
        Needs_docs:  0                             |   Needs_tests:  0    
Needs_better_patch:  0                             |  
---------------------------------------------------+------------------------
Changes (by andrewbadr):

  * summary:  transaction.rollback_savepoint fails with postgresql database
              backend => transaction.savepoint_rollback fails
              with postgresql database backend

Comment:

 I mean it *has* tests. Am I missing something?

--
Ticket URL: <http://code.djangoproject.com/ticket/12171#comment:2>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Django updates" group.
To post to this group, send email to django-updates@...
To unsubscribe from this group, send email to django-updates+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---

[noreply-71]

#12171: transaction.savepoint_rollback fails with postgresql DATABASE_ENGINE
---------------------------------------------------+------------------------
          Reporter:  andrewbadr                    |         Owner:  nobody
            Status:  new                           |     Milestone:        
         Component:  Database layer (models, ORM)  |       Version:  1.1  
        Resolution:                                |      Keywords:        
             Stage:  Unreviewed                    |     Has_patch:  0    
        Needs_docs:  0                             |   Needs_tests:  0    
Needs_better_patch:  0                             |  
---------------------------------------------------+------------------------
Changes (by andrewbadr):

  * summary:  transaction.savepoint_rollback fails with postgresql database
              backend => transaction.savepoint_rollback fails
              with postgresql DATABASE_ENGINE

Comment:

 To clarify, this is with DATABASE_ENGINE = "postgresql", *not*
 "postgresql_psycopg2".

--
Ticket URL: <http://code.djangoproject.com/ticket/12171#comment:3>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Django updates" group.
To post to this group, send email to django-updates@...
To unsubscribe from this group, send email to django-updates+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---

[noreply-71]

#12171: transaction.savepoint_rollback fails with postgresql DATABASE_ENGINE
---------------------------------------------------+------------------------
          Reporter:  andrewbadr                    |         Owner:  nobody
            Status:  new                           |     Milestone:        
         Component:  Database layer (models, ORM)  |       Version:  1.1  
        Resolution:                                |      Keywords:        
             Stage:  Unreviewed                    |     Has_patch:  0    
        Needs_docs:  0                             |   Needs_tests:  0    
Needs_better_patch:  0                             |  
---------------------------------------------------+------------------------
Comment (by jonathan):

 Hello Andrew,

 This is a duplicate of #12087.
 I have the same problem with postgresql, postgresql_psycopg2, on 1.1.1 and
 TRUNK versions.
 FYI, I use postgresql 8.3

--
Ticket URL: <http://code.djangoproject.com/ticket/12171#comment:4>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Django updates" group.
To post to this group, send email to django-updates@...
To unsubscribe from this group, send email to django-updates+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---

[noreply-71]

#12171: transaction.savepoint_rollback fails with postgresql DATABASE_ENGINE
---------------------------------------------------+------------------------
          Reporter:  andrewbadr                    |         Owner:  nobody
            Status:  new                           |     Milestone:        
         Component:  Database layer (models, ORM)  |       Version:  1.1  
        Resolution:                                |      Keywords:        
             Stage:  Unreviewed                    |     Has_patch:  0    
        Needs_docs:  0                             |   Needs_tests:  0    
Needs_better_patch:  0                             |  
---------------------------------------------------+------------------------
Comment (by andrewbadr):

 Jonathan, it looks like these are separate issues. The ticket you refer to
 is only about tests, and successfully repro's under psycopg2. Neither of
 those are true for this ticket. Also, I'd try changing your setup to
 isolate the bug because other people can run the tests fine without
 running into what you're seeing.

--
Ticket URL: <http://code.djangoproject.com/ticket/12171#comment:5>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Django updates" group.
To post to this group, send email to django-updates@...
To unsubscribe from this group, send email to django-updates+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---

[noreply-71]

#12171: transaction.savepoint_rollback fails with postgresql DATABASE_ENGINE
---------------------------------------------------+------------------------
          Reporter:  andrewbadr                    |         Owner:  nobody
            Status:  new                           |     Milestone:        
         Component:  Database layer (models, ORM)  |       Version:  1.1  
        Resolution:                                |      Keywords:        
             Stage:  Unreviewed                    |     Has_patch:  0    
        Needs_docs:  0                             |   Needs_tests:  0    
Needs_better_patch:  0                             |  
---------------------------------------------------+------------------------
Changes (by andrewbadr):

 * cc: andrewbadr.etc@... (added)

--
Ticket URL: <http://code.djangoproject.com/ticket/12171#comment:6>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Django updates" group.
To post to this group, send email to django-updates@...
To unsubscribe from this group, send email to django-updates+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---