doc/book/admin/rql-logs.rst
author Philippe Pepiot <ph@itsalwaysdns.eu>
Tue, 31 Mar 2020 19:15:03 +0200
changeset 12957 0c973204033a
parent 10491 c67bcee93248
permissions -rw-r--r--
[server] prevent returning closed cursor to the database pool In since c8c6ad8 init_repository use repo.internal_cnx() instead of repo.system_source.get_connection() so it use the pool and we should not close cursors from the pool before returning it back. Otherwise we may have "connection already closed" error. This bug only trigger when connection-pool-size = 1. Since we are moving to use a dynamic pooler we need to get this fixed. This does not occur with sqlite since the connection wrapper instantiate new cursor everytime, but this occur with other databases.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
6646
159d0dbe07d9 [book] move bit about rql logs to its own section
Nicolas Chauvat <nicolas.chauvat@logilab.fr>
parents:
diff changeset
     1
.. -*- coding: utf-8 -*-
159d0dbe07d9 [book] move bit about rql logs to its own section
Nicolas Chauvat <nicolas.chauvat@logilab.fr>
parents:
diff changeset
     2
159d0dbe07d9 [book] move bit about rql logs to its own section
Nicolas Chauvat <nicolas.chauvat@logilab.fr>
parents:
diff changeset
     3
RQL logs
159d0dbe07d9 [book] move bit about rql logs to its own section
Nicolas Chauvat <nicolas.chauvat@logilab.fr>
parents:
diff changeset
     4
========
159d0dbe07d9 [book] move bit about rql logs to its own section
Nicolas Chauvat <nicolas.chauvat@logilab.fr>
parents:
diff changeset
     5
159d0dbe07d9 [book] move bit about rql logs to its own section
Nicolas Chauvat <nicolas.chauvat@logilab.fr>
parents:
diff changeset
     6
You can configure the *CubicWeb* instance to keep a log
159d0dbe07d9 [book] move bit about rql logs to its own section
Nicolas Chauvat <nicolas.chauvat@logilab.fr>
parents:
diff changeset
     7
of the queries executed against your database. To do so,
159d0dbe07d9 [book] move bit about rql logs to its own section
Nicolas Chauvat <nicolas.chauvat@logilab.fr>
parents:
diff changeset
     8
edit the configuration file of your instance
159d0dbe07d9 [book] move bit about rql logs to its own section
Nicolas Chauvat <nicolas.chauvat@logilab.fr>
parents:
diff changeset
     9
``.../etc/cubicweb.d/myapp/all-in-one.conf`` and uncomment the
159d0dbe07d9 [book] move bit about rql logs to its own section
Nicolas Chauvat <nicolas.chauvat@logilab.fr>
parents:
diff changeset
    10
variable ``query-log-file``::
159d0dbe07d9 [book] move bit about rql logs to its own section
Nicolas Chauvat <nicolas.chauvat@logilab.fr>
parents:
diff changeset
    11
159d0dbe07d9 [book] move bit about rql logs to its own section
Nicolas Chauvat <nicolas.chauvat@logilab.fr>
parents:
diff changeset
    12
  # web instance query log file
159d0dbe07d9 [book] move bit about rql logs to its own section
Nicolas Chauvat <nicolas.chauvat@logilab.fr>
parents:
diff changeset
    13
  query-log-file=/tmp/rql-myapp.log
159d0dbe07d9 [book] move bit about rql logs to its own section
Nicolas Chauvat <nicolas.chauvat@logilab.fr>
parents:
diff changeset
    14