-
Notifications
You must be signed in to change notification settings - Fork 93
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
Selected scale factor is NOT valid && Connection timed out #31
Comments
You have multiple segments down. Did the database crash during the test? |
Hello. There was no failure during the test. Segments 77 and 54 are fine. Segment Info Segment Info
DETAIL: could not connect to server: Connection timed out psql -v ON_ERROR_STOP=0 -A -q -t -P pager=off -v EXPLAIN_ANALYZE="" -f /date/TPC-DS/05_sql/172.tpcds.72.sql | wc -l |
And in the process, the following error appears: |
And here's another warning: |
This means the database crashed during the query execution.
This also means the database crashed. The psql command attempted to connect while the postmaster process was restarting the database.
There is a log file in the /home/gpadmin directory named gpdist.4023.log that you can inspect. I am guessing you have some other process running on that port which you can check with netstat.
That is output from the TPC-DS binary. It just means the scale factor (how many GB of data you want to test) is not an acceptable size to publish the results. You can ignore this. |
Hello. Thanks for the answer. When analyzing the logs and the output of the command, netstat did not find any errors. Port 4023 is free. I am sending you the log files and the initial parameters file. Can I reinstall the database cluster? Please help me figure it out. Active Internet connections (servers and established)
|
You are using a fork of TPC-DS from ArenaData and not this repo. |
Hello. I am getting some errors, described below. And because of this, the script is not finalized. Please help me to sort out the problem.
psql:/date/TPC-DS/05_sql/171.tpcds.71.sql:40: ERROR: failed to acquire resources on one or more segments
DETAIL: could not connect to server: Connection timed out
Is the server running on host "10.3.11.38" and accepting
TCP/IP connections on port 10029?
(seg77 10.3.11.38:10029)
psql -v ON_ERROR_STOP=0 -A -q -t -P pager=off -v EXPLAIN_ANALYZE="" -f /date/TPC-DS/05_sql/172.tpcds.72.sql | wc -l
psql:/date/TPC-DS/05_sql/172.tpcds.72.sql:28: ERROR: failed to acquire resources on one or more segments
DETAIL: could not connect to server: Connection timed out
Is the server running on host "10.3.11.38" and accepting
TCP/IP connections on port 10006?
(seg54 10.3.11.38:10006)
Copyright Transaction Processing Performance Council (TPC) 2001 - 2015
Warning: Selected scale factor is NOT valid for result publication
stream_number: 1
mv /date1/TPC-DS/07_multi_user/query_0.sql /date1/TPC-DS/07_multi_user/1/
stream_number: 2
mv /date1/TPC-DS/07_multi_user/query_1.sql /date1/TPC-DS/07_multi_user/2/
stream_number: 3
mv /date1/TPC-DS/07_multi_user/query_2.sql /date1/TPC-DS/07_multi_user/3/
stream_number: 4
mv /date1/TPC-DS/07_multi_user/query_3.sql /date1/TPC-DS/07_multi_user/4/
stream_number: 5
mv /date1/TPC-DS/07_multi_user/query_4.sql /date1/TPC-DS/07_multi_user/5/
/date1/TPC-DS/07_multi_user/test.sh 5000 1 false
/date1/TPC-DS/07_multi_user/test.sh 5000 2 false
/date1/TPC-DS/07_multi_user/test.sh 5000 3 false
/date1/TPC-DS/07_multi_user/test.sh 5000 4 false
/date1/TPC-DS/07_multi_user/test.sh 5000 5 false
The text was updated successfully, but these errors were encountered: