python - Django-Axes causing DatabaseError - Transaction Block -



python - Django-Axes causing DatabaseError - Transaction Block -

so i've updated django 1.4.5 , postgres 9.2.3 , psycopg2 2.4.6 . runserver , looks ok, when go localhost:8000 see infamous 'current transaction aborted..' on request.session.save() in sessions/middleware.py(36).

i ran syncdb , migrate, no errors or changes matter. added in 'databases' - 'options': {'autocommit': true, }, still no help. , tried this:

from django.db import connection connection._rollback()

in django shell.

i tried stop postgres with:

pg_ctl -d /usr/local/var/postgres stop -s -m fast

and get:

pg_ctl: server not shut downwards

running pg -ef|grep postgres shows no hanging queries.

how can resolve block? how find causes it?

answer: a summery of did solve error

i enabled sql logging:

debug=true logging = { 'version': 1, 'disable_existing_loggers': false, 'handlers': { 'null': { 'level': 'debug', 'class': 'django.utils.log.nullhandler', }, 'console': { 'level': 'debug', 'class': 'logging.streamhandler', 'formatter': 'simple' } }, 'loggers': { 'django': { 'handlers': ['console'], 'level': 'debug', }, } }

this showed me sql statements beingness executed, including 1 causing internal db error, in case caused django-axes(i upgraded before version 1.2.9).

django-axes requires tables created. re-running syncdb didn't solve problem b.c there alter within 1 of tables (new field - username).

python manage.py sqlclear axes - showed me tables drop, went psql , did that. after ran 1 time again python manage.py syncdb , got updated tables.

and found bug within __init__.py of axes module, in get_version() - wrong string formatting. fixing solved mess :)

finally, happy ending!

python django transactions django-postgresql

Comments

Post a Comment

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer - when trying request rest service @ time of response getting exception.. feb 21, 2013 2:34:49 pm com.sun.jersey.spi.container.containerresponse mapmappablecontainerexception severe: exception contained within mappablecontainerexception not mapped response, re-throwing http container java.lang.noclassdeffounderror: not initialize class net.sf.cglib.proxy.enhancer @ org.hibernate.proxy.pojo.cglib.cgliblazyinitializer.getproxyfactory(cgliblazyinitializer.java:117) @ org.hibernate.proxy.pojo.cglib.cglibproxyfactory.postinstantiate(cglibproxyfactory.java:43) @ org.hibernate.tuple.entity.pojoentitytuplizer.buildproxyfactory(pojoentitytuplizer.java:162) @ org.hibernate.tuple.entity.abstractentitytuplizer.<init>(abstractentitytuplizer.java:135) @ org.hibernate.tuple.entity.pojoentitytuplizer.<init>(pojoentitytuplizer.java:55) @ org.hibernate.tuple.e...
Read more

Accessing MATLAB's unicode strings from C -

Accessing MATLAB's unicode strings from C - how can access underlying unicode info of matlab strings through matlab engine or mex c interfaces? here's example. let's set unicode characters in utf-8 encoded file test.txt, read as fid=fopen('test.txt','r','l','utf-8'); s=fscanf(fid, '%s') in matlab. now if first feature('defaultcharacterset', 'utf-8') , c engevalstring(ep, "s") , output text file utf-8. proves matlab stores unicode internally. if mxarraytostring(enggetvariable(ep, "s")) , unicode2native(s, 'latin-1') give me in matlab: non-latin-1 characters replaced character code 26. need getting access underlying unicode info c string in unicode format (utf-8, utf-16, etc.), , preserving non-latin-1 characters. is possible? my platform os x, matlab r2012b. addendum: documentation explicitly states "[mxarraytostring()] supports multibyte encoded characters...
Read more

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more