Ticket #13320: output_of_python_db_test.py.txt

File output_of_python_db_test.py.txt, 2.8 KB (added by rcrdnalor, 18 months ago)

Output of python test script for cheking tinouts

Line 
1$ ./python_db_test.py
2
3Python Version  : 2.7.15rc1
4SQL Driver Version: ('MySQLdb', 1, 3, 10, 'final', 0)
5
6This test run in 2 steps:
7 - tc #1 uses the old version of MysqlDB.ping: '_ping121(self): self._get_db().ping(True)'
8 - tc #2 uses the new version of MysqlDB.ping: '_ping122(self): self._get_db().ping()'
9Each test connects to mysql via the MythTV Python Bindings and checks connection recovery after a timeout occured.
10Note: MythTV Python uses a pool of connections to MysqlDB. For test purposes, this script allows only one connection at a time.
11
12Connect to MythDB (tc = 1) :
13  Allow only one connection from Python Bindings to mysql: MythDB.db.resizePool(1)
14  MYSQL version : 10.1.34-MariaDB-0ubuntu0.18.04.1
15    Connection_ID : 152
16  current SQL timeouts for this session:
17    session.wait_timeout : 28800
18    session.interactive_timeout : 28800
19    Connection_ID : 152
20  set session timeouts to 60 secs:
21    Connection_ID : 152
22    session.wait_timeout set to 60
23    session.interactive_timeout set to 60
24  check again current timeouts:
25    session.wait_timeout : 60
26    session.interactive_timeout : 60
27    Connection_ID : 152
28  sleep 50 secs (should not time out) ...
29        ping db connection with _ping121()
30  sleep 50 secs (should not time out) ...
31        ping db connection with _ping121()
32  sleep 80 secs (should time out) ...
33        ping db connection with _ping121()
34    Connection_ID : 153
35    Is this Connection_ID ident to the original one ( 152 <> 153 ) ?
36
37Connect to MythDB (tc = 2) :
38  Allow only one connection from Python Bindings to mysql: MythDB.db.resizePool(1)
39  MYSQL version : 10.1.34-MariaDB-0ubuntu0.18.04.1
40    Connection_ID : 154
41  current SQL timeouts for this session:
42    session.wait_timeout : 28800
43    session.interactive_timeout : 28800
44    Connection_ID : 154
45  set session timeouts to 60 secs:
46    Connection_ID : 154
47    session.wait_timeout set to 60
48    session.interactive_timeout set to 60
49  check again current timeouts:
50    session.wait_timeout : 60
51    session.interactive_timeout : 60
52    Connection_ID : 154
53  sleep 50 secs (should not time out) ...
54        ping db connection with _ping122()
55  sleep 50 secs (should not time out) ...
56        ping db connection with _ping122()
57  sleep 80 secs (should time out) ...
58        ping db connection with _ping122()
59XXX rollback called !
60Traceback (most recent call last):
61  File "./python_db_test.py", line 126, in <module>
62    %(connection_id_1, connection_id_2) )
63  File "/usr/lib/python2.7/dist-packages/MythTV/database.py", line 1431, in __exit__
64    def __exit__(self, ty, va, tr): return self.db.__exit__(ty, va, tr)
65  File "/usr/lib/python2.7/dist-packages/MythTV/connections.py", line 181, in __exit__
66    cursor.rollback()
67  File "/usr/lib/python2.7/dist-packages/MythTV/_conn_mysqldb.py", line 108, in rollback
68    self._get_db().rollback()
69_mysql_exceptions.OperationalError: (2006, 'MySQL server has gone away')
70