Error message during the execution of the TPC-E test in Benchmark Factory. (4374863)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Error message during the execution of the TPC-E test in Benchmark Factory.
Beschreibung

Running a TPC-E test against SQL Server, and throws an error message while executing TPC-E job.

Error message:
“Agent (BMF-AGENT5) Error: Execute statement1 failure. Transaction "XXXX Transaction" run failed by virtual user 270 in agent 5 of BMF-AGENT.”
Ursache

Deadlock issues are caused because the database is not able to handle a large number of concurrent insert requests.
Lösung

Reduce the number of Virtual users and try again.
Weitere Informationen

Error logs: Error log Location: - C:\..\ Documents\My Benchmark Factory\8.4.2\x64\Error Logs. This deadlock message will appear. “Connected to 'Database_Name' on Port: '4568' Execute XXXX statement1 failure. Transaction "XXXX Transaction" run failed by virtual user 424 in agent 4 of XXXX ODBC Error (40001,4B5, 1) - [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Transaction (Process ID 487) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Transaction "XXXX Transaction" run failed by virtual user 424 in agent 4 of Database_Name”

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Artikelhistorie:: Erstellt am: 2/19/2024
Letzte Aktualisierung am: 2/19/2024

Titel