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 jTPCCTData : ERROR: portal "" cannot be run #539

Open
RedOtherShoreFlower opened this issue Nov 7, 2023 · 4 comments
Open

ERROR jTPCCTData : ERROR: portal "" cannot be run #539

RedOtherShoreFlower opened this issue Nov 7, 2023 · 4 comments

Comments

@RedOtherShoreFlower
Copy link

Hello, does someone experience a problem like this, "ERROR jTPCCTData : ERROR: portal "" cannot be run".
image
This problem occurred while I was running Benchmarksql.
I set pool_reserve_prepared_statement to yes to save prepared statements.
This is a part of my configuration.
image
I'll appreciate someone who know how to resolve this problem.

@reshke
Copy link
Contributor

reshke commented Nov 7, 2023

HI!
What program do you use to perform tpcc test? how do you run it?

@RedOtherShoreFlower
Copy link
Author

HI! What program do you use to perform tpcc test? how do you run iI use postgresql to perform TPCC test. I

@RedOtherShoreFlower
Copy link
Author

HI! What program do you use to perform tpcc test? how do you run iI use postgresql to perform TPCC test. I

I use postgresql to perform tpcc test.
First, I start postgresql, its port is default 5432;
Second, configure odyssey's configure file as above screenshot shows and start it. Odyssey's port is default 6432;
Third, Make tpcc connect to odyssey and start the test;
Final, tpcc, odyssey and postgresql report the same ERROR;

I printf some logs.
image
Postgresql backend recevied a P message and a B message of command "BEGIN", then it received a P message of "Other SQL". I think backend should receive a E message before the next SQL's P message arrives. But it seems odyssey does not loss the E mesaage of "BEGIN". It sends the E message to backend, and executes the portal of "Other SQL" latter. When the actual E message of "Other SQL" arrives. I cannot run the portal of "Other SQL" since it has been ran by E message of "BEGIN". I think this cause the problem. But I do not know why odyssey postpone to send E message.

@RedOtherShoreFlower
Copy link
Author

HI! What program do you use to perform tpcc test? how do you run it?

Oh, Oh. My Postgresql version is 13, odyssey version is 1.3, BenchmarkSQL is 5.0.
There are 30 test terminals, and odyssey's pool_size is 5.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants