Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error: pgsql12 is not a valid connection running PostgreSQL with connect pool option #720

Closed
sm-shaw opened this issue Jul 10, 2024 · 0 comments · Fixed by #723
Closed
Assignees
Labels
bug Something isn't working database Database specific

Comments

@sm-shaw
Copy link
Contributor

sm-shaw commented Jul 10, 2024

Guidance
Bug reports are for when HammerDB is not behaving as expected.
Bug reports should not be submitted for help in understanding database performance related questions.
General questions on database performance or HammerDB usability should be submitted under Discussions.

Describe the bug
Issue #681 was only a partial fix. When selecting the connect pool option for PostgreSQL the workload runs to completion but prints an error at the end such as follows:

Benchmark Run jobid=668E5AD961CE03E203731383
Error in Virtual User 2: Error: pgsql12 is not a valid connection
Error in Virtual User 3: Error: pgsql16 is not a valid connection

Also when running in the CLI there is the following error.

indexes are 17593 and 21728
Error: failed to match arguments for text delete in script : fastdelete 17593
Script loaded, Type "print script" to view

To Reproduce
Use PostgreSQL and configure and select the XML connect pool option.

Expected behavior
Workload should run without errors.

Screenshots
If applicable, add screenshots to help explain your problem.

HammerDB Version (please complete the following information):

  • Version: v4.11
  • Build: [e.g. Release download or build from source]

HammerDB Interface (please complete the following information):

  • UI: both

Operating System (please complete the following information):

  • Server OS: all
  • Client OS: all

Database Server (please complete the following information):

  • Database name: PostgreSQL

Database Client (please complete the following information):

  • Database client name: [e.g. ODBC Driver 18 for SQL Server]

Additional context
Error introduced by changing the value for the inline script editing. Additional changes need for feature to work correctly for PostgreSQL and other databases require verification to prevent the same.

@sm-shaw sm-shaw self-assigned this Jul 10, 2024
@sm-shaw sm-shaw added bug Something isn't working database Database specific labels Jul 10, 2024
@sm-shaw sm-shaw linked a pull request Jul 11, 2024 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working database Database specific
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant