[Erp5-report] PERF r28463: 12 Tests, 9 Errors, 9 Failures

nobody at svn.erp5.org nobody at svn.erp5.org
Wed Aug 19 15:16:40 CEST 2009


Test Suite: PERF
Revision: 28463
Result: FAIL

All tests: 12
Failures: 9
Errors: 9


The following tests failed:

  testPerformance                                    (3 failures, 3 errors)
   test_01_viewBarModule (testPerformance.TestPerformance)
   test_02_viewFooObjectWithManyLines (testPerformance.TestPerformance)
   test_viewProxyField (testPerformance.TestPerformance)
   test_00_viewBarObject (testPerformance.TestPerformance)
   test_01_viewBarModule (testPerformance.TestPerformance)
   test_02_viewFooObjectWithManyLines (testPerformance.TestPerformance)

  testPerformance                                    (3 failures, 3 errors)
   test_01_viewBarModule (testPerformance.TestPerformance)
   test_02_viewFooObjectWithManyLines (testPerformance.TestPerformance)
   test_viewProxyField (testPerformance.TestPerformance)
   test_00_viewBarObject (testPerformance.TestPerformance)
   test_01_viewBarModule (testPerformance.TestPerformance)
   test_02_viewFooObjectWithManyLines (testPerformance.TestPerformance)

  testPerformance                                    (3 failures, 3 errors)
   test_01_viewBarModule (testPerformance.TestPerformance)
   test_02_viewFooObjectWithManyLines (testPerformance.TestPerformance)
   test_viewProxyField (testPerformance.TestPerformance)
   test_00_viewBarObject (testPerformance.TestPerformance)
   test_01_viewBarModule (testPerformance.TestPerformance)
   test_02_viewFooObjectWithManyLines (testPerformance.TestPerformance)
-------------- next part --------------
SOFTWARE_HOME: /usr/lib/erp5/lib/python
INSTANCE_HOME: /home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test
Cleaning static files ... 
objective time to view object form 0.1320 < 0.1406 < 0.1380

nb objects = 000100
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0457 < 0.0395
	view = 0.1550 < 0.1528 < 0.1950

nb objects = 000200
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0463 < 0.0395
	view = 0.1797 < 0.1488 < 0.2197

nb objects = 000300
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0452 < 0.0395
	view = 0.2044 < 0.1508 < 0.2444

nb objects = 000400
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0458 < 0.0395
	view = 0.2292 < 0.1526 < 0.2692

nb objects = 000500
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0452 < 0.0395
	view = 0.2539 < 0.1546 < 0.2939

nb objects = 000600
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0456 < 0.0395
	view = 0.2786 < 0.1565 < 0.3186

nb objects = 000700
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0454 < 0.0395
	view = 0.3033 < 0.1582 < 0.3433

nb objects = 000800
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0452 < 0.0395
	view = 0.3280 < 0.1600 < 0.3680

nb objects = 000900
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0453 < 0.0395
	view = 0.3528 < 0.1613 < 0.3928

nb objects = 001000
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0454 < 0.0395
	view = 0.3775 < 0.1629 < 0.4175

time to view object form with many lines 0.3000 < 0.2897 < 0.3200

time to view proxyfield form 0.2150 < 0.2241 < 0.2350


Loading Zope, please stand by ... done (1.562s)
/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ERP5Form/FSForm.py:4: DeprecationWarning: The module, 'Products.CMFCore.CMFCorePermissions' is a deprecated compatiblity alias for 'Products.CMFCore.permissions';  please use the new module instead.
  from Products.CMFCore.CMFCorePermissions import View, ViewManagementScreens
/usr/lib/erp5/lib/python/Products/ZMailIn/__init__.py:25: DeprecationWarning: This will be removed in ZODB 3.6:
   use transaction.get() instead of get_transaction().
   transaction.commit() is a shortcut spelling of transaction.get().commit(),
   and transaction.abort() of transaction.get().abort().
  get_transaction().note('Added GlobalZMailInCatalog')
/usr/lib/erp5/lib/python/Products/ZMailIn/__init__.py:26: DeprecationWarning: This will be removed in ZODB 3.6:
   use transaction.get() instead of get_transaction().
   transaction.commit() is a shortcut spelling of transaction.get().commit(),
   and transaction.abort() of transaction.get().abort().
  get_transaction().commit()
/usr/lib/erp5/lib/python/Products/CMFMailIn/__init__.py:38: DeprecationWarning: The product_name parameter of ToolInit is deprecated and will be ignored in CMF1.6: CMFMailIn
  product_name='CMFMailIn', icon='tool.gif',

Adding ERP5TypeTestCase user ... 
Adding erp5_portal_46b1242f30d521c53e744f4886ef0be0 ERP5 Site ... /usr/lib/erp5/lib/python/Products/PluginRegistry/PluginRegistry.py:111: DeprecationWarning: isImplementedBy has been renamed to providedBy
  if not plugin_type.isImplementedBy(plugin):
/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ERP5Type/Base.py:292: DeprecationWarning: Global function clearCache() is deprecated. Use portal_caches.clearCache() instead.
  clearCache()
done (73.904s)
Running ZServer on port 55195
Adding erp5_base business template ... (imported in 16.812s) done (30.693s)
Adding erp5_ui_test business template ... (imported in 5.682s) done (11.409s)
Executing pending activities ... 345 330 90 11 22 1 done (30.540s)
Logout ... 
done (147.711s)
Ran Unit test of Performance
FFEFEE
======================================================================
ERROR: test_01_viewBarModule (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 111, in __call__
    self.tearDown()
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/base.py", line 102, in tearDown
    self.beforeTearDown()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 109, in beforeTearDown
    transaction.commit()
  File "/usr/lib/erp5/lib/python/transaction/_manager.py", line 84, in commit
    self.get().commit(sub)
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 373, in commit
    self._callBeforeCommitHooks()
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 413, in _callBeforeCommitHooks
    hook(*args, **kws)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/ActivityBuffer.py", line 137, in tpc_prepare
    activity.prepareQueueMessageList(activity_tool, message_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/Activity/SQLQueue.py", line 101, in prepareQueueMessageList
    serialization_tag_list=serialization_tag_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ERP5Type/patches/DA.py", line 224, in DA__call__
    result=DB__.query(query, self.max_rows_)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 295, in query
    return self._access_db(method_id='query', args=args, kw=kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 286, in _access_db
    return getattr(db, method_id)(*args, **kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 441, in query
    c = self._query(qs)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 428, in _query
    raise ProgrammingError(exception[0], "%s '%s' HERE '%s' %s" % (prefix, reference_sql[:error_position], reference_sql[error_position:], suffix))
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near  'INSERT INTO message_queue\n(uid, path, active_process_uid, date, method_id, processing_node, processing, priority, tag, serialization_tag, message)\n' HERE 'VALUES'  at line 3")

======================================================================
ERROR: test_02_viewFooObjectWithManyLines (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 111, in __call__
    self.tearDown()
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/base.py", line 102, in tearDown
    self.beforeTearDown()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 109, in beforeTearDown
    transaction.commit()
  File "/usr/lib/erp5/lib/python/transaction/_manager.py", line 84, in commit
    self.get().commit(sub)
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 373, in commit
    self._callBeforeCommitHooks()
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 413, in _callBeforeCommitHooks
    hook(*args, **kws)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/ActivityBuffer.py", line 137, in tpc_prepare
    activity.prepareQueueMessageList(activity_tool, message_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/Activity/SQLQueue.py", line 101, in prepareQueueMessageList
    serialization_tag_list=serialization_tag_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ERP5Type/patches/DA.py", line 224, in DA__call__
    result=DB__.query(query, self.max_rows_)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 295, in query
    return self._access_db(method_id='query', args=args, kw=kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 286, in _access_db
    return getattr(db, method_id)(*args, **kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 441, in query
    c = self._query(qs)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 428, in _query
    raise ProgrammingError(exception[0], "%s '%s' HERE '%s' %s" % (prefix, reference_sql[:error_position], reference_sql[error_position:], suffix))
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near  'INSERT INTO message_queue\n(uid, path, active_process_uid, date, method_id, processing_node, processing, priority, tag, serialization_tag, message)\n' HERE 'VALUES'  at line 3")

======================================================================
ERROR: test_viewProxyField (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 111, in __call__
    self.tearDown()
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/base.py", line 102, in tearDown
    self.beforeTearDown()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 109, in beforeTearDown
    transaction.commit()
  File "/usr/lib/erp5/lib/python/transaction/_manager.py", line 84, in commit
    self.get().commit(sub)
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 373, in commit
    self._callBeforeCommitHooks()
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 413, in _callBeforeCommitHooks
    hook(*args, **kws)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/ActivityBuffer.py", line 137, in tpc_prepare
    activity.prepareQueueMessageList(activity_tool, message_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/Activity/SQLQueue.py", line 101, in prepareQueueMessageList
    serialization_tag_list=serialization_tag_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ERP5Type/patches/DA.py", line 224, in DA__call__
    result=DB__.query(query, self.max_rows_)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 295, in query
    return self._access_db(method_id='query', args=args, kw=kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 286, in _access_db
    return getattr(db, method_id)(*args, **kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 441, in query
    c = self._query(qs)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 428, in _query
    raise ProgrammingError(exception[0], "%s '%s' HERE '%s' %s" % (prefix, reference_sql[:error_position], reference_sql[error_position:], suffix))
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near  'INSERT INTO message_queue\n(uid, path, active_process_uid, date, method_id, processing_node, processing, priority, tag, serialization_tag, message)\n' HERE 'VALUES'  at line 3")

======================================================================
FAIL: test_00_viewBarObject (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 98, in __call__
    testMethod()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 164, in test_00_viewBarObject
    prefix='objective')
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 142, in checkViewBarObject
    '%.4f < %.4f < %.4f' % (min, req_time, max))
AssertionError: 0.1320 < 0.1406 < 0.1380

======================================================================
FAIL: test_01_viewBarModule (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 98, in __call__
    testMethod()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 241, in test_01_viewBarModule
    'View: %.4f < %.4f < %.4f' % (
AssertionError: View: 0.1550 < 0.1528 < 0.1950

======================================================================
FAIL: test_02_viewFooObjectWithManyLines (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 98, in __call__
    testMethod()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 315, in test_02_viewFooObjectWithManyLines
    '%.4f < %.4f < %.4f' % (
AssertionError: 0.3000 < 0.2897 < 0.3200

----------------------------------------------------------------------
Ran 4 tests in 502.856s

FAILED (failures=3, errors=3)

SOFTWARE_HOME: /usr/lib/erp5/lib/python
INSTANCE_HOME: /home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test
Cleaning static files ... 
objective time to view object form 0.1320 < 0.1412 < 0.1380

nb objects = 000100
	add = 0.0090 < 0.0093 < 0.0110
	tic = 0.0345 < 0.0460 < 0.0395
	view = 0.1550 < 0.1535 < 0.1950

nb objects = 000200
	add = 0.0090 < 0.0093 < 0.0110
	tic = 0.0345 < 0.0461 < 0.0395
	view = 0.1797 < 0.1495 < 0.2197

nb objects = 000300
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0450 < 0.0395
	view = 0.2044 < 0.1517 < 0.2444

nb objects = 000400
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0451 < 0.0395
	view = 0.2292 < 0.1535 < 0.2692

nb objects = 000500
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0452 < 0.0395
	view = 0.2539 < 0.1553 < 0.2939

nb objects = 000600
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0455 < 0.0395
	view = 0.2786 < 0.1572 < 0.3186

nb objects = 000700
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0453 < 0.0395
	view = 0.3033 < 0.1591 < 0.3433

nb objects = 000800
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0455 < 0.0395
	view = 0.3280 < 0.1607 < 0.3680

nb objects = 000900
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0450 < 0.0395
	view = 0.3528 < 0.1621 < 0.3928

nb objects = 001000
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0451 < 0.0395
	view = 0.3775 < 0.1638 < 0.4175

time to view object form with many lines 0.3000 < 0.2903 < 0.3200

time to view proxyfield form 0.2150 < 0.2252 < 0.2350


Loading Zope, please stand by ... done (4.397s)
/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ERP5Form/FSForm.py:4: DeprecationWarning: The module, 'Products.CMFCore.CMFCorePermissions' is a deprecated compatiblity alias for 'Products.CMFCore.permissions';  please use the new module instead.
  from Products.CMFCore.CMFCorePermissions import View, ViewManagementScreens
/usr/lib/erp5/lib/python/Products/ZMailIn/__init__.py:25: DeprecationWarning: This will be removed in ZODB 3.6:
   use transaction.get() instead of get_transaction().
   transaction.commit() is a shortcut spelling of transaction.get().commit(),
   and transaction.abort() of transaction.get().abort().
  get_transaction().note('Added GlobalZMailInCatalog')
/usr/lib/erp5/lib/python/Products/ZMailIn/__init__.py:26: DeprecationWarning: This will be removed in ZODB 3.6:
   use transaction.get() instead of get_transaction().
   transaction.commit() is a shortcut spelling of transaction.get().commit(),
   and transaction.abort() of transaction.get().abort().
  get_transaction().commit()
/usr/lib/erp5/lib/python/Products/CMFMailIn/__init__.py:38: DeprecationWarning: The product_name parameter of ToolInit is deprecated and will be ignored in CMF1.6: CMFMailIn
  product_name='CMFMailIn', icon='tool.gif',

Adding ERP5TypeTestCase user ... 
Adding erp5_portal_46b1242f30d521c53e744f4886ef0be0 ERP5 Site ... /usr/lib/erp5/lib/python/Products/PluginRegistry/PluginRegistry.py:111: DeprecationWarning: isImplementedBy has been renamed to providedBy
  if not plugin_type.isImplementedBy(plugin):
/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ERP5Type/Base.py:292: DeprecationWarning: Global function clearCache() is deprecated. Use portal_caches.clearCache() instead.
  clearCache()
done (72.764s)
Running ZServer on port 55067
Adding erp5_base business template ... (imported in 13.728s) done (27.552s)
Adding erp5_ui_test business template ... (imported in 3.911s) done (9.891s)
Executing pending activities ... 345 330 90 11 22 1 done (30.826s)
Logout ... 
done (142.068s)
Ran Unit test of Performance
FFEFEE
======================================================================
ERROR: test_01_viewBarModule (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 111, in __call__
    self.tearDown()
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/base.py", line 102, in tearDown
    self.beforeTearDown()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 109, in beforeTearDown
    transaction.commit()
  File "/usr/lib/erp5/lib/python/transaction/_manager.py", line 84, in commit
    self.get().commit(sub)
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 373, in commit
    self._callBeforeCommitHooks()
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 413, in _callBeforeCommitHooks
    hook(*args, **kws)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/ActivityBuffer.py", line 137, in tpc_prepare
    activity.prepareQueueMessageList(activity_tool, message_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/Activity/SQLQueue.py", line 101, in prepareQueueMessageList
    serialization_tag_list=serialization_tag_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ERP5Type/patches/DA.py", line 224, in DA__call__
    result=DB__.query(query, self.max_rows_)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 295, in query
    return self._access_db(method_id='query', args=args, kw=kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 286, in _access_db
    return getattr(db, method_id)(*args, **kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 441, in query
    c = self._query(qs)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 428, in _query
    raise ProgrammingError(exception[0], "%s '%s' HERE '%s' %s" % (prefix, reference_sql[:error_position], reference_sql[error_position:], suffix))
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near  'INSERT INTO message_queue\n(uid, path, active_process_uid, date, method_id, processing_node, processing, priority, tag, serialization_tag, message)\n' HERE 'VALUES'  at line 3")

======================================================================
ERROR: test_02_viewFooObjectWithManyLines (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 111, in __call__
    self.tearDown()
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/base.py", line 102, in tearDown
    self.beforeTearDown()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 109, in beforeTearDown
    transaction.commit()
  File "/usr/lib/erp5/lib/python/transaction/_manager.py", line 84, in commit
    self.get().commit(sub)
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 373, in commit
    self._callBeforeCommitHooks()
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 413, in _callBeforeCommitHooks
    hook(*args, **kws)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/ActivityBuffer.py", line 137, in tpc_prepare
    activity.prepareQueueMessageList(activity_tool, message_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/Activity/SQLQueue.py", line 101, in prepareQueueMessageList
    serialization_tag_list=serialization_tag_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ERP5Type/patches/DA.py", line 224, in DA__call__
    result=DB__.query(query, self.max_rows_)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 295, in query
    return self._access_db(method_id='query', args=args, kw=kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 286, in _access_db
    return getattr(db, method_id)(*args, **kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 441, in query
    c = self._query(qs)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 428, in _query
    raise ProgrammingError(exception[0], "%s '%s' HERE '%s' %s" % (prefix, reference_sql[:error_position], reference_sql[error_position:], suffix))
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near  'INSERT INTO message_queue\n(uid, path, active_process_uid, date, method_id, processing_node, processing, priority, tag, serialization_tag, message)\n' HERE 'VALUES'  at line 3")

======================================================================
ERROR: test_viewProxyField (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 111, in __call__
    self.tearDown()
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/base.py", line 102, in tearDown
    self.beforeTearDown()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 109, in beforeTearDown
    transaction.commit()
  File "/usr/lib/erp5/lib/python/transaction/_manager.py", line 84, in commit
    self.get().commit(sub)
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 373, in commit
    self._callBeforeCommitHooks()
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 413, in _callBeforeCommitHooks
    hook(*args, **kws)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/ActivityBuffer.py", line 137, in tpc_prepare
    activity.prepareQueueMessageList(activity_tool, message_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/Activity/SQLQueue.py", line 101, in prepareQueueMessageList
    serialization_tag_list=serialization_tag_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ERP5Type/patches/DA.py", line 224, in DA__call__
    result=DB__.query(query, self.max_rows_)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 295, in query
    return self._access_db(method_id='query', args=args, kw=kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 286, in _access_db
    return getattr(db, method_id)(*args, **kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 441, in query
    c = self._query(qs)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 428, in _query
    raise ProgrammingError(exception[0], "%s '%s' HERE '%s' %s" % (prefix, reference_sql[:error_position], reference_sql[error_position:], suffix))
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near  'INSERT INTO message_queue\n(uid, path, active_process_uid, date, method_id, processing_node, processing, priority, tag, serialization_tag, message)\n' HERE 'VALUES'  at line 3")

======================================================================
FAIL: test_00_viewBarObject (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 98, in __call__
    testMethod()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 164, in test_00_viewBarObject
    prefix='objective')
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 142, in checkViewBarObject
    '%.4f < %.4f < %.4f' % (min, req_time, max))
AssertionError: 0.1320 < 0.1412 < 0.1380

======================================================================
FAIL: test_01_viewBarModule (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 98, in __call__
    testMethod()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 241, in test_01_viewBarModule
    'View: %.4f < %.4f < %.4f' % (
AssertionError: View: 0.1550 < 0.1535 < 0.1950

======================================================================
FAIL: test_02_viewFooObjectWithManyLines (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 98, in __call__
    testMethod()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 315, in test_02_viewFooObjectWithManyLines
    '%.4f < %.4f < %.4f' % (
AssertionError: 0.3000 < 0.2903 < 0.3200

----------------------------------------------------------------------
Ran 4 tests in 498.051s

FAILED (failures=3, errors=3)

SOFTWARE_HOME: /usr/lib/erp5/lib/python
INSTANCE_HOME: /home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test
Cleaning static files ... 
objective time to view object form 0.1320 < 0.1408 < 0.1380

nb objects = 000100
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0457 < 0.0395
	view = 0.1550 < 0.1527 < 0.1950

nb objects = 000200
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0460 < 0.0395
	view = 0.1797 < 0.1489 < 0.2197

nb objects = 000300
	add = 0.0090 < 0.0091 < 0.0110
	tic = 0.0345 < 0.0449 < 0.0395
	view = 0.2044 < 0.1509 < 0.2444

nb objects = 000400
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0453 < 0.0395
	view = 0.2292 < 0.1527 < 0.2692

nb objects = 000500
	add = 0.0090 < 0.0093 < 0.0110
	tic = 0.0345 < 0.0452 < 0.0395
	view = 0.2539 < 0.1544 < 0.2939

nb objects = 000600
	add = 0.0090 < 0.0091 < 0.0110
	tic = 0.0345 < 0.0452 < 0.0395
	view = 0.2786 < 0.1564 < 0.3186

nb objects = 000700
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0445 < 0.0395
	view = 0.3033 < 0.1580 < 0.3433

nb objects = 000800
	add = 0.0090 < 0.0091 < 0.0110
	tic = 0.0345 < 0.0457 < 0.0395
	view = 0.3280 < 0.1595 < 0.3680

nb objects = 000900
	add = 0.0090 < 0.0091 < 0.0110
	tic = 0.0345 < 0.0452 < 0.0395
	view = 0.3528 < 0.1616 < 0.3928

nb objects = 001000
	add = 0.0090 < 0.0091 < 0.0110
	tic = 0.0345 < 0.0452 < 0.0395
	view = 0.3775 < 0.1631 < 0.4175

time to view object form with many lines 0.3000 < 0.2897 < 0.3200

time to view proxyfield form 0.2150 < 0.2245 < 0.2350


Loading Zope, please stand by ... done (1.378s)
/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ERP5Form/FSForm.py:4: DeprecationWarning: The module, 'Products.CMFCore.CMFCorePermissions' is a deprecated compatiblity alias for 'Products.CMFCore.permissions';  please use the new module instead.
  from Products.CMFCore.CMFCorePermissions import View, ViewManagementScreens
/usr/lib/erp5/lib/python/Products/ZMailIn/__init__.py:25: DeprecationWarning: This will be removed in ZODB 3.6:
   use transaction.get() instead of get_transaction().
   transaction.commit() is a shortcut spelling of transaction.get().commit(),
   and transaction.abort() of transaction.get().abort().
  get_transaction().note('Added GlobalZMailInCatalog')
/usr/lib/erp5/lib/python/Products/ZMailIn/__init__.py:26: DeprecationWarning: This will be removed in ZODB 3.6:
   use transaction.get() instead of get_transaction().
   transaction.commit() is a shortcut spelling of transaction.get().commit(),
   and transaction.abort() of transaction.get().abort().
  get_transaction().commit()
/usr/lib/erp5/lib/python/Products/CMFMailIn/__init__.py:38: DeprecationWarning: The product_name parameter of ToolInit is deprecated and will be ignored in CMF1.6: CMFMailIn
  product_name='CMFMailIn', icon='tool.gif',

Adding ERP5TypeTestCase user ... 
Adding erp5_portal_46b1242f30d521c53e744f4886ef0be0 ERP5 Site ... /usr/lib/erp5/lib/python/Products/PluginRegistry/PluginRegistry.py:111: DeprecationWarning: isImplementedBy has been renamed to providedBy
  if not plugin_type.isImplementedBy(plugin):
/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ERP5Type/Base.py:292: DeprecationWarning: Global function clearCache() is deprecated. Use portal_caches.clearCache() instead.
  clearCache()
done (62.342s)
Running ZServer on port 55173
Adding erp5_base business template ... (imported in 13.113s) done (26.909s)
Adding erp5_ui_test business template ... (imported in 3.813s) done (9.662s)
Executing pending activities ... 345 330 90 11 22 1 done (30.611s)
Logout ... 
done (130.557s)
Ran Unit test of Performance
FFEFEE
======================================================================
ERROR: test_01_viewBarModule (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 111, in __call__
    self.tearDown()
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/base.py", line 102, in tearDown
    self.beforeTearDown()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 109, in beforeTearDown
    transaction.commit()
  File "/usr/lib/erp5/lib/python/transaction/_manager.py", line 84, in commit
    self.get().commit(sub)
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 373, in commit
    self._callBeforeCommitHooks()
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 413, in _callBeforeCommitHooks
    hook(*args, **kws)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/ActivityBuffer.py", line 137, in tpc_prepare
    activity.prepareQueueMessageList(activity_tool, message_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/Activity/SQLQueue.py", line 101, in prepareQueueMessageList
    serialization_tag_list=serialization_tag_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ERP5Type/patches/DA.py", line 224, in DA__call__
    result=DB__.query(query, self.max_rows_)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 295, in query
    return self._access_db(method_id='query', args=args, kw=kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 286, in _access_db
    return getattr(db, method_id)(*args, **kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 441, in query
    c = self._query(qs)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 428, in _query
    raise ProgrammingError(exception[0], "%s '%s' HERE '%s' %s" % (prefix, reference_sql[:error_position], reference_sql[error_position:], suffix))
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near  'INSERT INTO message_queue\n(uid, path, active_process_uid, date, method_id, processing_node, processing, priority, tag, serialization_tag, message)\n' HERE 'VALUES'  at line 3")

======================================================================
ERROR: test_02_viewFooObjectWithManyLines (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 111, in __call__
    self.tearDown()
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/base.py", line 102, in tearDown
    self.beforeTearDown()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 109, in beforeTearDown
    transaction.commit()
  File "/usr/lib/erp5/lib/python/transaction/_manager.py", line 84, in commit
    self.get().commit(sub)
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 373, in commit
    self._callBeforeCommitHooks()
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 413, in _callBeforeCommitHooks
    hook(*args, **kws)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/ActivityBuffer.py", line 137, in tpc_prepare
    activity.prepareQueueMessageList(activity_tool, message_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/Activity/SQLQueue.py", line 101, in prepareQueueMessageList
    serialization_tag_list=serialization_tag_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ERP5Type/patches/DA.py", line 224, in DA__call__
    result=DB__.query(query, self.max_rows_)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 295, in query
    return self._access_db(method_id='query', args=args, kw=kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 286, in _access_db
    return getattr(db, method_id)(*args, **kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 441, in query
    c = self._query(qs)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 428, in _query
    raise ProgrammingError(exception[0], "%s '%s' HERE '%s' %s" % (prefix, reference_sql[:error_position], reference_sql[error_position:], suffix))
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near  'INSERT INTO message_queue\n(uid, path, active_process_uid, date, method_id, processing_node, processing, priority, tag, serialization_tag, message)\n' HERE 'VALUES'  at line 3")

======================================================================
ERROR: test_viewProxyField (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 111, in __call__
    self.tearDown()
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/base.py", line 102, in tearDown
    self.beforeTearDown()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 109, in beforeTearDown
    transaction.commit()
  File "/usr/lib/erp5/lib/python/transaction/_manager.py", line 84, in commit
    self.get().commit(sub)
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 373, in commit
    self._callBeforeCommitHooks()
  File "/usr/lib/erp5/lib/python/transaction/_transaction.py", line 413, in _callBeforeCommitHooks
    hook(*args, **kws)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/ActivityBuffer.py", line 137, in tpc_prepare
    activity.prepareQueueMessageList(activity_tool, message_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/CMFActivity/Activity/SQLQueue.py", line 101, in prepareQueueMessageList
    serialization_tag_list=serialization_tag_list)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ERP5Type/patches/DA.py", line 224, in DA__call__
    result=DB__.query(query, self.max_rows_)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 295, in query
    return self._access_db(method_id='query', args=args, kw=kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 286, in _access_db
    return getattr(db, method_id)(*args, **kw)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 441, in query
    c = self._query(qs)
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/unit_test/Products/ZMySQLDA/db.py", line 428, in _query
    raise ProgrammingError(exception[0], "%s '%s' HERE '%s' %s" % (prefix, reference_sql[:error_position], reference_sql[error_position:], suffix))
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near  'INSERT INTO message_queue\n(uid, path, active_process_uid, date, method_id, processing_node, processing, priority, tag, serialization_tag, message)\n' HERE 'VALUES'  at line 3")

======================================================================
FAIL: test_00_viewBarObject (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 98, in __call__
    testMethod()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 164, in test_00_viewBarObject
    prefix='objective')
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 142, in checkViewBarObject
    '%.4f < %.4f < %.4f' % (min, req_time, max))
AssertionError: 0.1320 < 0.1408 < 0.1380

======================================================================
FAIL: test_01_viewBarModule (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 98, in __call__
    testMethod()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 241, in test_01_viewBarModule
    'View: %.4f < %.4f < %.4f' % (
AssertionError: View: 0.1550 < 0.1527 < 0.1950

======================================================================
FAIL: test_02_viewFooObjectWithManyLines (testPerformance.TestPerformance)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 98, in __call__
    testMethod()
  File "/home/buildbot/slave/parts/bot_perf/full.PERF/build/Products/ERP5Type/tests/testPerformance.py", line 315, in test_02_viewFooObjectWithManyLines
    '%.4f < %.4f < %.4f' % (
AssertionError: 0.3000 < 0.2897 < 0.3200

----------------------------------------------------------------------
Ran 4 tests in 485.597s

FAILED (failures=3, errors=3)


More information about the Erp5-report mailing list