#21484: sql logging incomplete
----------------------------------------------+--------------------
Reporter: brian | Owner: nobody
Type: Bug | Status: new
Component: Database layer (models, ORM) | Version: 1.6
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
----------------------------------------------+--------------------
As discussed here https://docs.djangoproject.com/en/dev/topics/logging/
django supports logging of raw SQL queries. "For example, every SQL
statement executed by a request is logged at the DEBUG level to this
logger."
However, at least for mysql, this doesn't include initialization or
session management SQL queries.
Using wireshark I see a number of extra queries, that are never logged,
like:
{{{
SET NAMES utf8
set autocommit=0
SET SQL_AUTO_IS_NULL = 0
set autocommit=1
set autocommit=0
rollback
set autocommit=1
}}}
I assume "commit" is also on this list, however not part of this test.
Being able to see all the queries is important in order to debug obscure
problems.
Thanks
--
Ticket URL: <https://code.djangoproject.com/ticket/21484>
Django <https://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 unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/048.c783796b7ffdef734bfc3e29883ca8bc%40djangoproject.com.
For more options, visit https://groups.google.com/groups/opt_out.
