Mercurial > p > roundup > code
annotate doc/debugging.txt @ 6565:2c2dbfc332ba
Try to handle multiple connections better.
The session database is a hot spot. When multiple requests (e.g. 20)
come in at the same time session database contention can get great.
The original code didn't retry session database access when the open
failed. This resulted in errors at the client.
The second pass delayed 0.01 seconds and retried. It was better but we
still had multiple second stalls. I think the first request got in,
everybody else backed up and then retried at the same time. Again they
stepped on each other. With logging I would see many counters go all
the way to low single digits or to -1 indicating falure.
This pass uses randomint to generate delays from 0-.125 seconds in 5ms
increments. This performs better in testing. I rarely saw a counter
less than 13 (2 failed retries). Current logging starts after 6
failures and counts down until success or failure.
| author | John Rouillard <rouilj@ieee.org> |
|---|---|
| date | Thu, 16 Dec 2021 20:02:00 -0500 |
| parents | a635a60ffb84 |
| children |
| rev | line source |
|---|---|
|
4377
b6f1aaba4827
Small documentation update regarding debugging aids:
Bernhard Reiter <Bernhard.Reiter@intevation.de>
parents:
1836
diff
changeset
|
1 Debugging Aids |
|
b6f1aaba4827
Small documentation update regarding debugging aids:
Bernhard Reiter <Bernhard.Reiter@intevation.de>
parents:
1836
diff
changeset
|
2 -------------- |
|
1836
94e430ad4fdb
make the RDBMS common backend and the SQLite and MYsql backend create...
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
3 |
|
4377
b6f1aaba4827
Small documentation update regarding debugging aids:
Bernhard Reiter <Bernhard.Reiter@intevation.de>
parents:
1836
diff
changeset
|
4 Try turning on logging of DEBUG level messages. This may be done a number |
|
b6f1aaba4827
Small documentation update regarding debugging aids:
Bernhard Reiter <Bernhard.Reiter@intevation.de>
parents:
1836
diff
changeset
|
5 of ways, depending on what it is you're testing: |
|
1836
94e430ad4fdb
make the RDBMS common backend and the SQLite and MYsql backend create...
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
6 |
|
4377
b6f1aaba4827
Small documentation update regarding debugging aids:
Bernhard Reiter <Bernhard.Reiter@intevation.de>
parents:
1836
diff
changeset
|
7 1. If you're testing the database unit tests, then set the environment |
|
b6f1aaba4827
Small documentation update regarding debugging aids:
Bernhard Reiter <Bernhard.Reiter@intevation.de>
parents:
1836
diff
changeset
|
8 variable ``LOGGING_LEVEL=DEBUG``. This may be done like so: |
|
1836
94e430ad4fdb
make the RDBMS common backend and the SQLite and MYsql backend create...
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
9 |
|
6297
a635a60ffb84
Remove standalone pytest run_tests.py bundle
John Rouillard <rouilj@ieee.org>
parents:
4377
diff
changeset
|
10 LOGGING_LEVEL=DEBUG python -m pytest test/ |
|
1836
94e430ad4fdb
make the RDBMS common backend and the SQLite and MYsql backend create...
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
11 |
|
4377
b6f1aaba4827
Small documentation update regarding debugging aids:
Bernhard Reiter <Bernhard.Reiter@intevation.de>
parents:
1836
diff
changeset
|
12 This variable replaces the older HYPERDBDEBUG environment var. |
|
1836
94e430ad4fdb
make the RDBMS common backend and the SQLite and MYsql backend create...
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
13 |
|
4377
b6f1aaba4827
Small documentation update regarding debugging aids:
Bernhard Reiter <Bernhard.Reiter@intevation.de>
parents:
1836
diff
changeset
|
14 2. If you're testing a particular tracker, then set the logging level in |
|
b6f1aaba4827
Small documentation update regarding debugging aids:
Bernhard Reiter <Bernhard.Reiter@intevation.de>
parents:
1836
diff
changeset
|
15 your tracker's ``config.ini``. |
|
1836
94e430ad4fdb
make the RDBMS common backend and the SQLite and MYsql backend create...
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
16 |
|
94e430ad4fdb
make the RDBMS common backend and the SQLite and MYsql backend create...
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
17 SENDMAILDEBUG |
|
94e430ad4fdb
make the RDBMS common backend and the SQLite and MYsql backend create...
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
18 ============= |
|
94e430ad4fdb
make the RDBMS common backend and the SQLite and MYsql backend create...
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
19 |
|
4377
b6f1aaba4827
Small documentation update regarding debugging aids:
Bernhard Reiter <Bernhard.Reiter@intevation.de>
parents:
1836
diff
changeset
|
20 Set to a filename and roundup will write each email message |
|
b6f1aaba4827
Small documentation update regarding debugging aids:
Bernhard Reiter <Bernhard.Reiter@intevation.de>
parents:
1836
diff
changeset
|
21 that it sends to that file instead to the internet. |
|
b6f1aaba4827
Small documentation update regarding debugging aids:
Bernhard Reiter <Bernhard.Reiter@intevation.de>
parents:
1836
diff
changeset
|
22 This environment variable is independent of the python -O flag. |
|
1836
94e430ad4fdb
make the RDBMS common backend and the SQLite and MYsql backend create...
Anthony Baxter <anthonybaxter@users.sourceforge.net>
parents:
diff
changeset
|
23 |
