Service Virtualization

Expand all | Collapse all

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

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

    Posted 08-22-2018 04:42 AM

    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!



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

    Posted 08-22-2018 04:45 AM

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



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

    Posted 08-22-2018 05:15 AM

    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.



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

    Posted 08-23-2018 11:24 PM

    Support Case 01173708 was created by this reporter.



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

    Posted 11-08-2018 04:10 PM

    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.