I noticed that my performance results (possibly other keyvals) are not
in my database. When I looked at the parse log (full log attached) for
an iozone job I recently ran I see:
parsing test ---- SERVER_JOB
! Reparse returned new test testname='CLIENT_JOB.0' subdir=None
* testname, status, reason: ---- GOOD
* testname, status, reason: iozone GOOD completed successfully
/usr/local/autotest/tko/db.py:255: Warning: Column 'owner' cannot be null
self.cur.execute(sql, values)
/usr/local/autotest/tko/db.py:255: Warning: Field 'subdir' doesn't have
a default value
self.cur.execute(sql, values)
Traceback (most recent call last):
File "/usr/local/autotest/tko/parse.py", line 221, in parse_leaf_path
mail_on_failure)
File "/usr/local/autotest/tko/db.py", line 104, in run_with_retry
result = function(*args, **dargs)
File "/usr/local/autotest/tko/parse.py", line 162, in parse_one
db.insert_job(jobname, job)
File "/usr/local/autotest/tko/db.py", line 373, in insert_job
self.insert_test(job, test, commit=commit)
File "/usr/local/autotest/tko/db.py", line 422, in insert_test
commit=commit)
File "/usr/local/autotest/tko/db.py", line 276, in insert
self._exec_sql_with_commit(cmd, values, commit)
File "/usr/local/autotest/tko/db.py", line 255, in _exec_sql_with_commit
self.cur.execute(sql, values)
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174,
in execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line
36, in defaulterrorhandler
raise errorclass, errorvalue
IntegrityError: (1062, "Duplicate entry '543' for key 'PRIMARY'")
When I manually inspect (where I think the results should be stored) I see:
mysql> select * from tko_iteration_result;
+----------+-----------+------------+-------+
| test_idx | iteration | attribute | value |
+----------+-----------+------------+-------+
| 540 | 1 | num_forked | 9 |
+----------+-----------+------------+-------+
1 row in set (0.01 sec)
I'm running autotest 0.15.1 on an ubuntu 12.04.3 LTS machine. Any help
is greatly appreciated.
Thanks
Josh
{'drone': 'AutotestKernel', 'job_queued': 1397581735, 'job_started': 1397581753, 'user': 'debug_user', 'hostname': '172.25.43.13', 'status_version': 1, 'label': 'iozone'}
MACHINE NAME: 172.25.43.13
MACHINE GROUP: None
parsing partial test ---- SERVER_JOB
STATUS: INFO ---- ---- kernel=3.10.24-3.10.0-amd64-12048653 localtime=Apr 15 17:09:16 timestamp=1397581756
STATUS: START ---- ---- timestamp=1397581766 localtime=Apr 15 17:09:26
parsing partial test None CLIENT_JOB.0
RUNNING: RUNNING
CLIENT_JOB.0
STATUS: START iozone iozone timestamp=1397581767 localtime=Apr 15 17:09:27
parsing partial test iozone iozone
RUNNING: RUNNING
Subdir: iozone
Testname: iozone
STATUS: GOOD iozone iozone timestamp=1397582152 localtime=Apr 15 17:15:52 completed successfully
update RUNNING reason: completed successfully
STATUS: END GOOD iozone iozone timestamp=1397582152 localtime=Apr 15 17:15:52
parsing test iozone iozone
ADD: GOOD
Subdir: iozone
Testname: iozone
completed successfully
STATUS: END GOOD ---- ---- timestamp=1397582153 localtime=Apr 15 17:15:53
parsing test None CLIENT_JOB.0
ADD: GOOD
Subdir: None
Testname: CLIENT_JOB.0
parsing test ---- SERVER_JOB
********************************************************************************
17:16:11 04/15/14> ['nice', '-n', '10', '/usr/local/autotest/tko/parse', '--write-pidfile', '-l', '2', '-r', '-o', u'/usr/local/autotest/results/108-debug_user/172.25.43.13']
********************************************************************************
Scanning 108-debug_user/172.25.43.13 (/usr/local/autotest/results/108-debug_user/172.25.43.13)
{'job_started': 1397581753, 'job_finished': 1397582160, 'hostname': '172.25.43.13', 'status_version': 1, 'label': 'iozone', 'drone': 'AutotestKernel', 'job_queued': 1397581735, 'user': 'debug_user'}
MACHINE NAME: 172.25.43.13
MACHINE GROUP: None
+ Parsing dir=/usr/local/autotest/results/108-debug_user/172.25.43.13, jobname=108-debug_user/172.25.43.13
parsing partial test ---- SERVER_JOB
STATUS: INFO ---- ---- kernel=3.10.24-3.10.0-amd64-12048653 localtime=Apr 15 17:09:16 timestamp=1397581756
STATUS: START ---- ---- timestamp=1397581766 localtime=Apr 15 17:09:26
parsing partial test None CLIENT_JOB.0
RUNNING: RUNNING
CLIENT_JOB.0
STATUS: START iozone iozone timestamp=1397581767 localtime=Apr 15 17:09:27
parsing partial test iozone iozone
RUNNING: RUNNING
Subdir: iozone
Testname: iozone
STATUS: GOOD iozone iozone timestamp=1397582152 localtime=Apr 15 17:15:52 completed successfully
update RUNNING reason: completed successfully
STATUS: END GOOD iozone iozone timestamp=1397582152 localtime=Apr 15 17:15:52
parsing test iozone iozone
ADD: GOOD
Subdir: iozone
Testname: iozone
completed successfully
STATUS: END GOOD ---- ---- timestamp=1397582153 localtime=Apr 15 17:15:53
parsing test None CLIENT_JOB.0
ADD: GOOD
Subdir: None
Testname: CLIENT_JOB.0
parsing test ---- SERVER_JOB
! Reparse returned new test testname='CLIENT_JOB.0' subdir=None
* testname, status, reason: ---- GOOD
* testname, status, reason: iozone GOOD completed successfully
/usr/local/autotest/tko/db.py:255: Warning: Column 'owner' cannot be null
self.cur.execute(sql, values)
/usr/local/autotest/tko/db.py:255: Warning: Field 'subdir' doesn't have a default value
self.cur.execute(sql, values)
Traceback (most recent call last):
File "/usr/local/autotest/tko/parse.py", line 221, in parse_leaf_path
mail_on_failure)
File "/usr/local/autotest/tko/db.py", line 104, in run_with_retry
result = function(*args, **dargs)
File "/usr/local/autotest/tko/parse.py", line 162, in parse_one
db.insert_job(jobname, job)
File "/usr/local/autotest/tko/db.py", line 373, in insert_job
self.insert_test(job, test, commit=commit)
File "/usr/local/autotest/tko/db.py", line 422, in insert_test
commit=commit)
File "/usr/local/autotest/tko/db.py", line 276, in insert
self._exec_sql_with_commit(cmd, values, commit)
File "/usr/local/autotest/tko/db.py", line 255, in _exec_sql_with_commit
self.cur.execute(sql, values)
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
IntegrityError: (1062, "Duplicate entry '543' for key 'PRIMARY'")
_______________________________________________
Autotest-kernel mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/autotest-kernel
