ERROR - Error capturing report data for Database: The database writer cannot keep up with the number of events being generated

[saranya_7290]

Getting the below error when I execute my test suite in my local and also in the remote non-PROD box the suites are getting executed within 10min.

But when the same is executed from the PROD remote agent box(with firewall), the suite is taking more than one hour to execute and complete. Also the results for this is not coming in the devtest portal.

Below is the error:

ERROR - Error capturing report data for Database: The database writer cannot keep up with the number of events being generated

com.itko.lisa.test.EventDeliveryException: The database writer cannot keep up with the number of events being generated

                at com.itko.lisa.history.HistoryWriteSupport.batchWriteToDb(HistoryWriteSupport.java:606)

                at com.itko.lisa.history.HistoryWriteSupport.writeObject(HistoryWriteSupport.java:494)

                at com.itko.lisa.history.HistoryWriteSupport.writeMetricEvent(HistoryWriteSupport.java:482)

                at com.itko.lisa.history.HistoryWriteSupport.pushEventFromCoordinator(HistoryWriteSupport.java:319)

                at com.itko.lisa.report.DefaultReportToDataModel.pushEvent(DefaultReportToDataModel.java:232)

                at com.itko.lisa.coordinator.ReportGenerator.testEvent(ReportGenerator.java:520)

                at com.itko.lisa.test.TestEventMgr.pushEvent(TestEventMgr.java:321)

                at com.itko.lisa.net.RemoteEventDeliverySupport.pushEvent(RemoteEventDeliverySupport.java:146)

                at com.itko.lisa.test.TestEventMgr.pushEvent(TestEventMgr.java:289)

                at com.itko.lisa.coordinator.BaseCoordinator.fireTestEvent(BaseCoordinator.java:453)

                at com.itko.lisa.coordinator.BaseCoordinator.fireTestEvents(BaseCoordinator.java:512)

                at com.itko.lisa.simulator.EventHandler.dump(EventHandler.java:340)

                at com.itko.lisa.simulator.EventHandler.run(EventHandler.java:283)

                at java.lang.Thread.run(Thread.java:745)

ERROR - Waiting to enqueue a database object timed out

 

I have also referred to this thread and we tried the options in https://communities.ca.com/thread/241777037-getting-error-in-registry-log-the-database-writer-cannot-keep-up-with-the-number-of-events-being-generated but it didn't help us.

 

We have also got access for most of the devtest network ports for firewall access. Is there any firewall access required on very specific network ports related to the above error, so that we could double check.

 

Please suggest!

[saranya_7290]

The same is taking less than 15min when run in local / remote non-prod VM's

[saranya_7290]

Please help us by providing the list of ports that we need to ensure that firewall is burn between the remote PROD VM and the related devtest component servers for any test execution to happen without this huge delay and the error.

 

Also please share if there are any other fix for the above error.

[Yusuke Tsuji]

Support Case 01173708 was created by this reporter.

[Marcy Nunns]

Resolution: 
***************************** 
The Workstation on your local machine showed that the registry on the Linux machine is without Coordinator and Simulator. 
When you run a suite, you use the 'run locally' option. 

In that case the Workstation process will execute the suite on your local machine and will need access to the database. 

The Workstation process will retrieve the database settings from 'site.properties' on the Server where the registry is running. 

If there is no database access from the Workstation, then you may see the errors in the workstation.log that you reported: 
ERROR - Error capturing report data for Database: The database writer cannot keep up with the number of events being generated 

 

Configure access to the database (as listed in site.properties) from the Workstation to avoid this error and enable reporting.