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

nobody at svn.erp5.org nobody at svn.erp5.org
Wed Aug 19 12:37:40 CEST 2009


Test Suite: PERF
Revision: 28457
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.1405 < 0.1380

nb objects = 000100
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0458 < 0.0395
	view = 0.1550 < 0.1524 < 0.1950

nb objects = 000200
	add = 0.0090 < 0.0091 < 0.0110
	tic = 0.0345 < 0.0459 < 0.0395
	view = 0.1797 < 0.1486 < 0.2197

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

nb objects = 000400
	add = 0.0090 < 0.0091 < 0.0110
	tic = 0.0345 < 0.0454 < 0.0395
	view = 0.2292 < 0.1524 < 0.2692

nb objects = 000500
	add = 0.0090 < 0.0093 < 0.0110
	tic = 0.0345 < 0.0454 < 0.0395
	view = 0.2539 < 0.1545 < 0.2939

nb objects = 000600
	add = 0.0090 < 0.0091 < 0.0110
	tic = 0.0345 < 0.0453 < 0.0395
	view = 0.2786 < 0.1563 < 0.3186

nb objects = 000700
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0449 < 0.0395
	view = 0.3033 < 0.1579 < 0.3433

nb objects = 000800
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0454 < 0.0395
	view = 0.3280 < 0.1595 < 0.3680

nb objects = 000900
	add = 0.0090 < 0.0091 < 0.0110
	tic = 0.0345 < 0.0449 < 0.0395
	view = 0.3528 < 0.1610 < 0.3928

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

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

time to view proxyfield form 0.2150 < 0.2237 < 0.2350


Loading Zope, please stand by ... done (2.525s)
/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 (70.144s)
Running ZServer on port 55355
Adding erp5_base business template ... (imported in 20.955s) done (34.786s)
Adding erp5_ui_test business template ... (imported in 5.933s) done (11.690s)
Executing pending activities ... 345 330 90 11 22 1 done (30.334s)
Logout ... 
done (148.123s)
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.1405 < 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.1524 < 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.2888 < 0.3200

----------------------------------------------------------------------
Ran 4 tests in 502.544s

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.1407 < 0.1380

nb objects = 000100
	add = 0.0090 < 0.0093 < 0.0110
	tic = 0.0345 < 0.0459 < 0.0395
	view = 0.1550 < 0.1529 < 0.1950

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

nb objects = 000300
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0452 < 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.1530 < 0.2692

nb objects = 000500
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0451 < 0.0395
	view = 0.2539 < 0.1548 < 0.2939

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

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

nb objects = 000800
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0453 < 0.0395
	view = 0.3280 < 0.1598 < 0.3680

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

nb objects = 001000
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0449 < 0.0395
	view = 0.3775 < 0.1631 < 0.4175

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

time to view proxyfield form 0.2150 < 0.2244 < 0.2350


Loading Zope, please stand by ... done (5.754s)
/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.726s)
Running ZServer on port 55000
Adding erp5_base business template ... (imported in 13.019s) done (27.009s)
Adding erp5_ui_test business template ... (imported in 3.776s) done (9.694s)
Executing pending activities ... 345 330 90 11 22 1 done (30.501s)
Logout ... 
done (140.971s)
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.1407 < 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.1529 < 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.2896 < 0.3200

----------------------------------------------------------------------
Ran 4 tests in 495.578s

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.1402 < 0.1380

nb objects = 000100
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0463 < 0.0395
	view = 0.1550 < 0.1531 < 0.1950

nb objects = 000200
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0464 < 0.0395
	view = 0.1797 < 0.1490 < 0.2197

nb objects = 000300
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0453 < 0.0395
	view = 0.2044 < 0.1511 < 0.2444

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

nb objects = 000500
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0449 < 0.0395
	view = 0.2539 < 0.1548 < 0.2939

nb objects = 000600
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0452 < 0.0395
	view = 0.2786 < 0.1569 < 0.3186

nb objects = 000700
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0448 < 0.0395
	view = 0.3033 < 0.1585 < 0.3433

nb objects = 000800
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0451 < 0.0395
	view = 0.3280 < 0.1602 < 0.3680

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

nb objects = 001000
	add = 0.0090 < 0.0092 < 0.0110
	tic = 0.0345 < 0.0456 < 0.0395
	view = 0.3775 < 0.1637 < 0.4175

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

time to view proxyfield form 0.2150 < 0.2242 < 0.2350


Loading Zope, please stand by ... done (1.178s)
/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 (61.795s)
Running ZServer on port 55267
Adding erp5_base business template ... (imported in 13.061s) done (26.870s)
Adding erp5_ui_test business template ... (imported in 3.789s) done (9.622s)
Executing pending activities ... 345 330 90 11 22 1 done (30.365s)
Logout ... 
done (129.714s)
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.1402 < 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.1531 < 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.2894 < 0.3200

----------------------------------------------------------------------
Ran 4 tests in 484.529s

FAILED (failures=3, errors=3)


More information about the Erp5-report mailing list