search

ldbc / ldbc_snb_interactive_v1_impls

Reference implementations for LDBC Social Network Benchmark's Interactive workload.
https://ldbcouncil.org/benchmarks/snb-interactive
Apache License 2.0
98 stars 85 forks source link

The postgres benchmark.sh script has been executing for several hours but still does not stop without any error prompts #387

Closed ggssh closed 1 year ago

ggssh commented 1 year ago

image As seen above, benchmark has been running for nearly three hours without stopping, so it is believed that this may be a bug

GLaDAP commented 1 year ago

Could you provide which queries you have enabled, the scale factor and version of SNB? Unfortunately, for Postgres, the path queries (Q13, Q14) can hang during execution.

nevermore3 commented 1 year ago

I have encountered the same problem，when i running benchmark.sh, after the number of queries executed is equal to operation_count, the benchmark does not exit, and the query continues to be executedimage

I'm not using postgres, I'm testing with my own database

GLaDAP commented 1 year ago

Hi @nevermore3, could you provide the scale factor, which queries you have enabled and version of SNB?

nevermore3 commented 1 year ago 
ldbc_snb_interactive_impls  version. Tag 1.0.0
ldbc_snb_interactive_driver version Tag v1.2.0
 I use the dataset sf0.1 to do benchmark

scale factor is 0.1

ldbc.snb.interactive.LdbcQuery1_enable   = false
ldbc.snb.interactive.LdbcQuery2_enable   = true
ldbc.snb.interactive.LdbcQuery3_enable  = true
ldbc.snb.interactive.LdbcQuery4_enable   = true
ldbc.snb.interactive.LdbcQuery5_enable   = true
ldbc.snb.interactive.LdbcQuery6_enable   = true
ldbc.snb.interactive.LdbcQuery7_enable   = true
ldbc.snb.interactive.LdbcQuery8_enable   = true
ldbc.snb.interactive.LdbcQuery9_enable   = true
ldbc.snb.interactive.LdbcQuery10_enable  = true
ldbc.snb.interactive.LdbcQuery11_enable  = true
ldbc.snb.interactive.LdbcQuery12_enable  = true
ldbc.snb.interactive.LdbcQuery13_enable = false
ldbc.snb.interactive.LdbcQuery14_enable = false

ldbc.snb.interactive.LdbcShortQuery1PersonProfile_enable  = true
ldbc.snb.interactive.LdbcShortQuery2PersonPosts_enable    = true
ldbc.snb.interactive.LdbcShortQuery3PersonFriends_enable  = true
ldbc.snb.interactive.LdbcShortQuery4MessageContent_enable = true
ldbc.snb.interactive.LdbcShortQuery5MessageCreator_enable = true
ldbc.snb.interactive.LdbcShortQuery6MessageForum_enable   = true
ldbc.snb.interactive.LdbcShortQuery7MessageReplies_enable = true

ldbc.snb.interactive.LdbcUpdate1AddPerson_enable          =true
ldbc.snb.interactive.LdbcUpdate2AddPostLike_enable        =true
ldbc.snb.interactive.LdbcUpdate3AddCommentLike_enable     =true
ldbc.snb.interactive.LdbcUpdate4AddForum_enable           =true
ldbc.snb.interactive.LdbcUpdate5AddForumMembership_enable =true
ldbc.snb.interactive.LdbcUpdate6AddPost_enable            =true
ldbc.snb.interactive.LdbcUpdate7AddComment_enable         =true
ldbc.snb.interactive.LdbcUpdate8AddFriendship_enable      =true
nevermore3 commented 1 year ago

operation_count=20, But it didn't stop after more than 20 executions

nevermore3 commented 1 year ago

Sorry, my configuration is wrong, the parameter of warmup is set to 100，my problem is solved ，thank u @GLaDAP ,have a nice day

GLaDAP commented 1 year ago

Glad you solved the problem!