I have a problem when I load citus and pg_strom.I have loaded two extensions : citus and pg_strom , when I started the server , the server outputs some error in logfile,such as:
ERROR: function dump_local_wait_edges() does not exist at character 15
HINT: No function matches the given name and argument types,You might need to add explicit type casts
Error: (cuda_program.c:1370) failed on cuModuleData : CUDA_ERROR_OUT_OF_MEMORY - out of memory
when I am doing some queries,some servers may crash and I have to restart them.
My Operating System is Centos7.5 , I7 7700,16G Ram,GPU is TITAN V postgresql version is 10.4, citus version is 7.4-3, pg_strom version is 2.0, cuda version is 9.2.88
I make 6 worker nodes,citus.replication_model is streaming,citus.shard_count is 60
I have a problem when I load citus and pg_strom.I have loaded two extensions : citus and pg_strom , when I started the server , the server outputs some error in logfile,such as:
ERROR: function dump_local_wait_edges() does not exist at character 15 HINT: No function matches the given name and argument types,You might need to add explicit type casts Error: (cuda_program.c:1370) failed on cuModuleData : CUDA_ERROR_OUT_OF_MEMORY - out of memory
when I am doing some queries,some servers may crash and I have to restart them.
My Operating System is Centos7.5 , I7 7700,16G Ram,GPU is TITAN V postgresql version is 10.4, citus version is 7.4-3, pg_strom version is 2.0, cuda version is 9.2.88
I make 6 worker nodes,citus.replication_model is streaming,citus.shard_count is 60
create TABLE T_DNS( SRCIP INT8, DESTIP INT8, SRCPORT INT4, DESTPORT INT4, CAPTURETIME INT8, FLAG INT4, TTL INT4, PROTOCOL INT2, ISP VARCHAR(3), AREA VARCHAR(3), QUERYTYPE INT4, RESOURCEKEY INT8, HKEY INT2,li QUERYCONTENT VARCHAR(512), RR VARCHAR(8000) );
I insert into 121249776 lines, then I do this query:select count(*) from t_dns , the server crash just like I said before.
please help me.