Redisgraph: apply_join.c crash (v 1.99.8)

[m4g005]

Still trying to track down the query that caused this, but got this stack trace in the logs:

=== REDIS BUG REPORT START: Cut & paste starting from here ===
1:M 13 Jan 2020 23:07:33.429 # Redis 5.0.7 crashed by signal: 11
1:M 13 Jan 2020 23:07:33.429 # Crashed running the instruction at: 0x7efc5a9e9611
1:M 13 Jan 2020 23:07:33.429 # Accessing address: (nil)
1:M 13 Jan 2020 23:07:33.429 # Failed assertion: <no assertion failed> (<no file>:0)

------ STACK TRACE ------
redis-server: /redisgraph/src/execution_plan/optimizations/apply_join.c:130: applyJoin: Assertion `lhs_resolving_stream != rhs_resolving_stream' failed.
EIP:
/lib/x86_64-linux-gnu/libc.so.6(abort+0x1fd)[0x7efc5a9e9611]

Backtrace:
redis-server *:6379(logStackTrace+0x32)[0x5604b324a572]
redis-server *:6379(sigsegvHandler+0x9e)[0x5604b324ac4e]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x12730)[0x7efc5ab9a730]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x1fd)[0x7efc5a9e9611]
/lib/x86_64-linux-gnu/libc.so.6(+0x2240f)[0x7efc5a9e940f]
/lib/x86_64-linux-gnu/libc.so.6(+0x30102)[0x7efc5a9f7102]
/usr/lib/redis/modules/redisgraph.so(+0x180855)[0x7efc597ae855]
/usr/lib/redis/modules/redisgraph.so(optimizePlan+0x21)[0x7efc597af5d1]
/usr/lib/redis/modules/redisgraph.so(NewExecutionPlan+0x3d0)[0x7efc597a1fe0]
/usr/lib/redis/modules/redisgraph.so(Graph_Query+0x2a0)[0x7efc5979caa0]
/usr/lib/redis/modules/redisgraph.so(+0x19a76d)[0x7efc597c876d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7fa3)[0x7efc5ab8ffa3]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7efc5aac04cf]

------ INFO OUTPUT ------
# Server
redis_version:5.0.7
redis_git_sha1:00000000
redis_git_dirty:0
redis_build_id:b671f408463590b9
redis_mode:standalone
os:Linux 3.10.0-957.27.2.el7.x86_64 x86_64
arch_bits:64
multiplexing_api:epoll
atomicvar_api:atomic-builtin
gcc_version:8.3.0
process_id:1
run_id:0ff0f60fdc95b50fee1b5183c9014231d032cad2
tcp_port:6379
uptime_in_seconds:745
uptime_in_days:0
hz:10
configured_hz:10
lru_clock:1898549
executable:/data/redis-server
config_file:

# Clients
connected_clients:3
client_recent_max_input_buffer:2
client_recent_max_output_buffer:20504
blocked_clients:3

# Memory
used_memory:1569960672
used_memory_human:1.46G
used_memory_rss:1860980736
used_memory_rss_human:1.73G
used_memory_peak:1935138384
used_memory_peak_human:1.80G
used_memory_peak_perc:81.13%
used_memory_overhead:908722
used_memory_startup:824504
used_memory_dataset:1569051990
used_memory_dataset_perc:99.99%
allocator_allocated:1576079504
allocator_active:1589088256
allocator_resident:2405953536
total_system_memory:59085271040
total_system_memory_human:55.03G
used_memory_lua:37888
used_memory_lua_human:37.00K
used_memory_scripts:0
used_memory_scripts_human:0B
number_of_cached_scripts:0
maxmemory:0
maxmemory_human:0B
maxmemory_policy:noeviction
allocator_frag_ratio:1.01
allocator_frag_bytes:13008752
allocator_rss_ratio:1.51
allocator_rss_bytes:816865280
rss_overhead_ratio:0.77
rss_overhead_bytes:-544972800
mem_fragmentation_ratio:1.19
mem_fragmentation_bytes:291257776
mem_not_counted_for_evict:0
mem_replication_backlog:0
mem_clients_slaves:0
mem_clients_normal:83538
mem_aof_buffer:0
mem_allocator:jemalloc-5.1.0
active_defrag_running:0
lazyfree_pending_objects:0

# Persistence
loading:0
rdb_changes_since_last_save:0
rdb_bgsave_in_progress:0
rdb_last_save_time:1578956108
rdb_last_bgsave_status:ok
rdb_last_bgsave_time_sec:-1
rdb_current_bgsave_time_sec:-1
rdb_last_cow_size:0
aof_enabled:0
aof_rewrite_in_progress:0
aof_rewrite_scheduled:0
aof_last_rewrite_time_sec:-1
aof_current_rewrite_time_sec:-1
aof_last_bgrewrite_status:ok
aof_last_write_status:ok
aof_last_cow_size:0

# Stats
total_connections_received:498
total_commands_processed:490
instantaneous_ops_per_sec:7
total_net_input_bytes:595517
total_net_output_bytes:9208818
instantaneous_input_kbps:12.75
instantaneous_output_kbps:11.84
rejected_connections:0
sync_full:0
sync_partial_ok:0
sync_partial_err:0
expired_keys:0
expired_stale_perc:0.00
expired_time_cap_reached_count:0
evicted_keys:0
keyspace_hits:463
keyspace_misses:0
pubsub_channels:0
pubsub_patterns:0
latest_fork_usec:0
migrate_cached_sockets:0
slave_expires_tracked_keys:0
active_defrag_hits:0
active_defrag_misses:0
active_defrag_key_hits:0
active_defrag_key_misses:0

# Replication
role:master
connected_slaves:0
master_replid:3dbe918251a5eefb3d0f4757eded30d18e80b426
master_replid2:0000000000000000000000000000000000000000
master_repl_offset:0
second_repl_offset:-1
repl_backlog_active:0
repl_backlog_size:1048576
repl_backlog_first_byte_offset:0
repl_backlog_histlen:0

# CPU
used_cpu_sys:168.407041
used_cpu_user:139.911132
used_cpu_sys_children:0.006106
used_cpu_user_children:0.000738

# Commandstats
cmdstat_config:calls=7,usec=60,usec_per_call=8.57
cmdstat_graph.QUERY:calls=463,usec=16956,usec_per_call=36.62
cmdstat_keys:calls=20,usec=278,usec_per_call=13.90

# Cluster
cluster_enabled:0

# Keyspace
db0:keys=13,expires=0,avg_ttl=0

------ CLIENT LIST OUTPUT ------
id=1507 addr=172.18.0.5:33446 fd=8 name= age=0 idle=0 flags=b db=0 sub=0 psub=0 multi=-1 qbuf=0 qbuf-free=0 obl=0 oll=0 omem=0 events=r cmd=graph.QUERY
id=1510 addr=172.18.0.5:33450 fd=9 name= age=0 idle=0 flags=b db=0 sub=0 psub=0 multi=-1 qbuf=0 qbuf-free=0 obl=0 oll=0 omem=0 events=r cmd=graph.QUERY
id=1513 addr=172.18.0.5:33470 fd=10 name= age=0 idle=0 flags=b db=0 sub=0 psub=0 multi=-1 qbuf=0 qbuf-free=32768 obl=0 oll=0 omem=0 events=r cmd=graph.QUERY

------ REGISTERS ------
1:M 13 Jan 2020 23:07:33.432 #
RAX:0000000000000000 RBX:0000000000000000
RCX:0000000000000000 RDX:0000000000000000
RDI:0000000000000002 RSI:00007efc566250b0
RBP:00007efc5ab4bee0 RSP:00007efc566251d0
R8 :0000000000000000 R9 :00007efc566250b0
R10:0000000000000008 R11:0000000000000246
R12:00007efc59ddbef0 R13:00007efc59ddbf30
R14:0000000000000082 R15:0000000000000007
RIP:00007efc5a9e9611 EFL:0000000000010246
CSGSFS:0000000000000033
1:M 13 Jan 2020 23:07:33.432 # (00007efc566251df) -> 0000000000000000
1:M 13 Jan 2020 23:07:33.432 # (00007efc566251de) -> 0000000000000000
1:M 13 Jan 2020 23:07:33.432 # (00007efc566251dd) -> 0000000000000000
1:M 13 Jan 2020 23:07:33.432 # (00007efc566251dc) -> 0000000000000000
1:M 13 Jan 2020 23:07:33.432 # (00007efc566251db) -> 0000000000000000
1:M 13 Jan 2020 23:07:33.432 # (00007efc566251da) -> 0000000000000000
1:M 13 Jan 2020 23:07:33.432 # (00007efc566251d9) -> 0000000000000000
1:M 13 Jan 2020 23:07:33.432 # (00007efc566251d8) -> 0000000000000000
1:M 13 Jan 2020 23:07:33.432 # (00007efc566251d7) -> 0000000000000000
1:M 13 Jan 2020 23:07:33.432 # (00007efc566251d6) -> 0000000000000000
1:M 13 Jan 2020 23:07:33.432 # (00007efc566251d5) -> 0000000000000000
1:M 13 Jan 2020 23:07:33.432 # (00007efc566251d4) -> 0000000000000000
1:M 13 Jan 2020 23:07:33.432 # (00007efc566251d3) -> 0000000000000000
1:M 13 Jan 2020 23:07:33.432 # (00007efc566251d2) -> 0000000000000000
1:M 13 Jan 2020 23:07:33.432 # (00007efc566251d1) -> 0000000000000000
1:M 13 Jan 2020 23:07:33.432 # (00007efc566251d0) -> 0000000000000020

------ FAST MEMORY TEST ------
1:M 13 Jan 2020 23:07:33.432 # Bio thread for job type #0 terminated
1:M 13 Jan 2020 23:07:33.432 # Bio thread for job type #1 terminated
1:M 13 Jan 2020 23:07:33.432 # Bio thread for job type #2 terminated
*** Preparing to test memory region 5604b3378000 (2248704 bytes)
*** Preparing to test memory region 5604b4a12000 (135168 bytes)
*** Preparing to test memory region 7efa3b3e8000 (327155712 bytes)
*** Preparing to test memory region 7efa50bf4000 (67108864 bytes)
*** Preparing to test memory region 7efa56479000 (3670016 bytes)
*** Preparing to test memory region 7efa56ffb000 (8388608 bytes)
*** Preparing to test memory region 7efa577fb000 (6291456 bytes)
*** Preparing to test memory region 7efa57efc000 (3670016 bytes)
*** Preparing to test memory region 7efa5827d000 (8388608 bytes)
*** Preparing to test memory region 7efa58a7d000 (9961472 bytes)
*** Preparing to test memory region 7efa595fe000 (6291456 bytes)
*** Preparing to test memory region 7efa59bff000 (8388608 bytes)
*** Preparing to test memory region 7efa5ac00000 (912261120 bytes)
*** Preparing to test memory region 7efa913f9000 (197132288 bytes)
*** Preparing to test memory region 7efa9d27c000 (6291456 bytes)
*** Preparing to test memory region 7efa9da7d000 (496500736 bytes)
*** Preparing to test memory region 7efabb3fe000 (8388608 bytes)
*** Preparing to test memory region 7efabbbff000 (8388608 bytes)
*** Preparing to test memory region 7efabc400000 (8388608 bytes)
*** Preparing to test memory region 7efabcc00000 (27262976 bytes)
*** Preparing to test memory region 7efabe7fd000 (14680064 bytes)
*** Preparing to test memory region 7efabf5fe000 (8388608 bytes)
*** Preparing to test memory region 7efabfdff000 (8388608 bytes)
*** Preparing to test memory region 7efac0600000 (8388608 bytes)
*** Preparing to test memory region 7efac0e00000 (8388608 bytes)
*** Preparing to test memory region 7efac17fe000 (8388608 bytes)
*** Preparing to test memory region 7efac1fff000 (8388608 bytes)
*** Preparing to test memory region 7efac2800000 (8388608 bytes)
*** Preparing to test memory region 7efac3000000 (48234496 bytes)
*** Preparing to test memory region 7efac6800000 (8388608 bytes)
*** Preparing to test memory region 7efac7000000 (138412032 bytes)
*** Preparing to test memory region 7efacf5f9000 (62914560 bytes)
*** Preparing to test memory region 7efad31fa000 (8388608 bytes)
*** Preparing to test memory region 7efad39fb000 (8388608 bytes)
*** Preparing to test memory region 7efad41fc000 (8388608 bytes)
*** Preparing to test memory region 7efad49fd000 (8388608 bytes)
*** Preparing to test memory region 7efad51fe000 (8388608 bytes)
*** Preparing to test memory region 7efad59ff000 (8388608 bytes)
*** Preparing to test memory region 7efad6200000 (8388608 bytes)
*** Preparing to test memory region 7efad6a00000 (69206016 bytes)
*** Preparing to test memory region 7efadac7d000 (35127296 bytes)
*** Preparing to test memory region 7efadcdfe000 (8388608 bytes)
*** Preparing to test memory region 7efadd5ff000 (8388608 bytes)
*** Preparing to test memory region 7efadde00000 (8388608 bytes)
*** Preparing to test memory region 7efade600000 (94507008 bytes)
*** Preparing to test memory region 7efae8000000 (135168 bytes)
*** Preparing to test memory region 7efaec000000 (135168 bytes)
*** Preparing to test memory region 7efaf0000000 (2662400 bytes)
*** Preparing to test memory region 7efaf41fe000 (48234496 bytes)
*** Preparing to test memory region 7efaf7100000 (15863808 bytes)
*** Preparing to test memory region 7efafc000000 (3215360 bytes)
*** Preparing to test memory region 7efb00000000 (135168 bytes)
*** Preparing to test memory region 7efb04000000 (135168 bytes)
*** Preparing to test memory region 7efb08000000 (135168 bytes)
*** Preparing to test memory region 7efb0c000000 (135168 bytes)
*** Preparing to test memory region 7efb10000000 (135168 bytes)
*** Preparing to test memory region 7efb14000000 (135168 bytes)
*** Preparing to test memory region 7efb18000000 (2568192 bytes)
*** Preparing to test memory region 7efb1c000000 (2576384 bytes)
*** Preparing to test memory region 7efb20000000 (2568192 bytes)
*** Preparing to test memory region 7efb24000000 (2568192 bytes)
*** Preparing to test memory region 7efb28000000 (135168 bytes)
*** Preparing to test memory region 7efb2c000000 (2568192 bytes)
*** Preparing to test memory region 7efb30000000 (135168 bytes)
*** Preparing to test memory region 7efb34000000 (135168 bytes)
*** Preparing to test memory region 7efb38000000 (135168 bytes)
*** Preparing to test memory region 7efb3c000000 (135168 bytes)
*** Preparing to test memory region 7efb40000000 (135168 bytes)
*** Preparing to test memory region 7efb44000000 (135168 bytes)
*** Preparing to test memory region 7efb48000000 (135168 bytes)
*** Preparing to test memory region 7efb4c000000 (135168 bytes)
*** Preparing to test memory region 7efb50000000 (135168 bytes)
*** Preparing to test memory region 7efb54000000 (135168 bytes)
*** Preparing to test memory region 7efb58000000 (135168 bytes)
*** Preparing to test memory region 7efb5c000000 (135168 bytes)
*** Preparing to test memory region 7efb60000000 (135168 bytes)
*** Preparing to test memory region 7efb64000000 (2097152 bytes)
*** Preparing to test memory region 7efb643ff000 (4194304 bytes)
*** Preparing to test memory region 7efb64a00000 (1130500096 bytes)
*** Preparing to test memory region 7efbac000000 (135168 bytes)
*** Preparing to test memory region 7efbb0000000 (135168 bytes)
*** Preparing to test memory region 7efbb4000000 (135168 bytes)
*** Preparing to test memory region 7efbb8000000 (135168 bytes)
*** Preparing to test memory region 7efbbc000000 (135168 bytes)
*** Preparing to test memory region 7efbc0000000 (135168 bytes)
*** Preparing to test memory region 7efbc4000000 (135168 bytes)
*** Preparing to test memory region 7efbc8000000 (135168 bytes)
*** Preparing to test memory region 7efbcc000000 (135168 bytes)
*** Preparing to test memory region 7efbd0000000 (135168 bytes)
*** Preparing to test memory region 7efbd4000000 (135168 bytes)
*** Preparing to test memory region 7efbd8000000 (135168 bytes)
*** Preparing to test memory region 7efbdc000000 (135168 bytes)
*** Preparing to test memory region 7efbe0000000 (135168 bytes)
*** Preparing to test memory region 7efbe4000000 (135168 bytes)
*** Preparing to test memory region 7efbe8000000 (135168 bytes)
*** Preparing to test memory region 7efbec000000 (135168 bytes)
*** Preparing to test memory region 7efbf0000000 (135168 bytes)
*** Preparing to test memory region 7efbf4000000 (135168 bytes)
*** Preparing to test memory region 7efbf8000000 (135168 bytes)
*** Preparing to test memory region 7efbfc000000 (135168 bytes)
*** Preparing to test memory region 7efc00000000 (135168 bytes)
*** Preparing to test memory region 7efc04000000 (135168 bytes)
*** Preparing to test memory region 7efc08000000 (135168 bytes)
*** Preparing to test memory region 7efc0c000000 (135168 bytes)
*** Preparing to test memory region 7efc10000000 (135168 bytes)
*** Preparing to test memory region 7efc14000000 (135168 bytes)
*** Preparing to test memory region 7efc18000000 (135168 bytes)
*** Preparing to test memory region 7efc1c000000 (135168 bytes)
*** Preparing to test memory region 7efc20000000 (135168 bytes)
*** Preparing to test memory region 7efc24000000 (4194304 bytes)
*** Preparing to test memory region 7efc2457d000 (8912896 bytes)
*** Preparing to test memory region 7efc24ffe000 (6291456 bytes)
*** Preparing to test memory region 7efc255ff000 (8388608 bytes)
*** Preparing to test memory region 7efc25e00000 (8388608 bytes)
*** Preparing to test memory region 7efc26600000 (430051328 bytes)
*** Preparing to test memory region 7efc4411c000 (203948032 bytes)
*** Preparing to test memory region 7efc5039d000 (8388608 bytes)
*** Preparing to test memory region 7efc50b9e000 (8388608 bytes)
*** Preparing to test memory region 7efc5139f000 (8388608 bytes)
*** Preparing to test memory region 7efc51ba0000 (8388608 bytes)
*** Preparing to test memory region 7efc523a1000 (8388608 bytes)
*** Preparing to test memory region 7efc52ba2000 (8388608 bytes)
*** Preparing to test memory region 7efc533a3000 (8388608 bytes)
*** Preparing to test memory region 7efc53ba3000 (2621440 bytes)
*** Preparing to test memory region 7efc53e24000 (8388608 bytes)
*** Preparing to test memory region 7efc54625000 (8388608 bytes)
*** Preparing to test memory region 7efc54e26000 (8388608 bytes)
*** Preparing to test memory region 7efc55627000 (8388608 bytes)
*** Preparing to test memory region 7efc55e28000 (8388608 bytes)
*** Preparing to test memory region 7efc56629000 (8388608 bytes)
*** Preparing to test memory region 7efc56e2a000 (8388608 bytes)
*** Preparing to test memory region 7efc5762b000 (8388608 bytes)
*** Preparing to test memory region 7efc57e2c000 (8388608 bytes)
*** Preparing to test memory region 7efc5862d000 (8388608 bytes)
*** Preparing to test memory region 7efc58e2e000 (8388608 bytes)
*** Preparing to test memory region 7efc59ffd000 (12288 bytes)
*** Preparing to test memory region 7efc5a000000 (8388608 bytes)
*** Preparing to test memory region 7efc5a9c1000 (24576 bytes)
*** Preparing to test memory region 7efc5ab84000 (16384 bytes)
*** Preparing to test memory region 7efc5aba5000 (16384 bytes)
*** Preparing to test memory region 7efc5ad3b000 (8192 bytes)
*** Preparing to test memory region 7efc5ad3e000 (4096 bytes)
*** Preparing to test memory region 7efc5ad68000 (4096 bytes)

[m4g005]

I found an example of the query that caused the crash -- we know this is a sucky query and are fixing it. B-)

GRAPH.QUERY graph:anesthesia "MATCH (f0:fact_anesthesia)<-[:link_anesthesia_facility]-(deyb:dim_facility) WHERE (deyb.facility_name = 'BCSC Surgery') MATCH (f1:fact_anesthesia)<-[:link_anesthesia_procedure]-(dndf:dim_procedure) WHERE (dndf.procedure_name = 'Correction Penile Torsion/Buried Penis' OR dndf.procedure_name = 'Excision Lesion Penis' OR dndf.procedure_name = 'zzRelease Buried Penis (zz 04/09/19)' OR dndf.procedure_name = 'zzRelease Buried Penis/Circ/Lysis Adhesi' OR dndf.procedure_name = 'zzRelease Buried Penis/Circumcision (zz' OR dndf.procedure_name = 'zzRelease Buried Penis/Detorq/Scrotoplas' OR dndf.procedure_name = 'zzRelease Buried Penis/Detorque/Circ (zz' OR dndf.procedure_name = 'zzRelease Buried Penis/Flap/Circ (zz 04/' OR dndf.procedure_name = 'zzRelease Buried Penis/Scrotoplasty/Circ' OR dndf.procedure_name = 'Circumcision' OR dndf.procedure_name = 'zzCircumcision GEN' OR dndf.procedure_name = 'zzCircumcision/Lysis Penile Adhesions (z' OR dndf.procedure_name = 'zzCircumcision/Scrotoplasty (zz 04/08/19' OR dndf.procedure_name = 'zzDetorque Penile/Circ/Lysis Adhesions (' OR dndf.procedure_name = 'zzDetorquing Penile/Circumcision (zz 04/' OR dndf.procedure_name = 'zzDetorquing Penile/Scrotoplasty/Circ (z' OR dndf.procedure_name = 'zzRelease Chordee/Circumcision (zz 04/08' OR dndf.procedure_name = 'zzRelease Chordee/Detorquing/Circumcisio' OR dndf.procedure_name = 'zzRelease Chordee/Scrotoplasty/Circ (zz' OR dndf.procedure_name = 'zzRepair Hypospadias/Circumcision (zz 04' OR dndf.procedure_name = 'zzRepair Hypospadias/Scrotoplasty/Circ (' OR dndf.procedure_name = 'Repair Hypospadias' OR dndf.procedure_name = 'zzRepair Hypospadias/Detorquing Penile (' OR dndf.procedure_name = 'zzRepair Hypospadias/Release Chordee (zz' OR dndf.procedure_name = 'zzRepair Hypospadias/Scrotoplasty (zz 04') MATCH (f2:fact_anesthesia)<-[:link_anesthesia_patient]-(dyby:dim_patient) WHERE dyby.age_years >= 0.0 AND dyby.age_years <= 4.0 MATCH (f3:fact_anesthesia)<-[:link_anesthesia_block]-(ddql:dim_block) WHERE ddql.block = 'Centroneuraxis Block' AND ddql.nerve_site = 'Caudal' MATCH (f4:fact_anesthesia)<-[:link_anesthesia_block]-(dekl:dim_block) WHERE dekl.block = 'Centroneuraxis Block' AND dekl.nerve_site = 'Caudal' MATCH (f5:fact_anesthesia)<-[:link_anesthesia_facility]-(denz:dim_facility) WHERE (denz.facility_name = 'BCSC Surgery') MATCH (f6:fact_anesthesia)<-[:link_anesthesia_procedure]-(dkyl:dim_procedure) 
WHERE (dkyl.procedure_name = 'Correction Penile Torsion/Buried Penis' OR dkyl.procedure_name = 'Excision Lesion Penis' OR dkyl.procedure_name = 'zzRelease Buried Penis (zz 04/09/19)' OR dkyl.procedure_name = 'zzRelease Buried Penis/Circ/Lysis Adhesi' OR dkyl.procedure_name = 'zzRelease Buried Penis/Circumcision (zz' OR dkyl.procedure_name = 'zzRelease Buried Penis/Detorq/Scrotoplas' OR dkyl.procedure_name = 'zzRelease Buried Penis/Detorque/Circ (zz' OR dkyl.procedure_name = 'zzRelease Buried Penis/Flap/Circ (zz 04/' OR dkyl.procedure_name = 'zzRelease Buried Penis/Scrotoplasty/Circ' OR dkyl.procedure_name = 'Circumcision' OR dkyl.procedure_name = 'zzCircumcision GEN' OR dkyl.procedure_name = 'zzCircumcision/Lysis Penile Adhesions (z' OR dkyl.procedure_name = 'zzCircumcision/Scrotoplasty (zz 04/08/19' OR dkyl.procedure_name = 'zzDetorque Penile/Circ/Lysis Adhesions (' OR dkyl.procedure_name = 'zzDetorquing Penile/Circumcision (zz 04/' OR dkyl.procedure_name = 'zzDetorquing Penile/Scrotoplasty/Circ (z' OR dkyl.procedure_name = 'zzRelease Chordee/Circumcision (zz 04/08' OR dkyl.procedure_name = 'zzRelease Chordee/Detorquing/Circumcisio' OR dkyl.procedure_name = 'zzRelease Chordee/Scrotoplasty/Circ (zz' OR dkyl.procedure_name = 'zzRepair Hypospadias/Circumcision (zz 04' OR dkyl.procedure_name = 'zzRepair Hypospadias/Scrotoplasty/Circ (' OR dkyl.procedure_name = 'Repair Hypospadias' OR dkyl.procedure_name = 'zzRepair Hypospadias/Detorquing Penile (' OR dkyl.procedure_name = 'zzRepair Hypospadias/Release Chordee (zz' OR dkyl.procedure_name = 'zzRepair Hypospadias/Scrotoplasty (zz 04') MATCH (f7:fact_anesthesia)<-[:link_anesthesia_patient]-(dplp:dim_patient) WHERE dplp.age_years >= 0.0 AND dplp.age_years <= 4.0 MATCH (f8:fact_anesthesia)<-[:link_anesthesia_block]-(dzhh:dim_block) WHERE dzhh.block = 'Centroneuraxis Block' AND dzhh.nerve_site = 'Caudal' MATCH (f9:fact_anesthesia)<-[:link_anesthesia_block]-(dndf:dim_block) WHERE dndf.block = 'Centroneuraxis Block' AND dndf.nerve_site = 'Caudal' MATCH (f_a)<-[]-(dd:dim_date)  WHERE dd.timestamp >= 1420099200.0 AND dd.timestamp <= 1579054846.262591 AND id(f_a)=id(f0) AND id(f_a)=id(f1) AND id(f_a)=id(f2) AND id(f_a)=id(f3) AND id(f_a)=id(f4) AND id(f_a)=id(f5) AND id(f_a)=id(f6) AND id(f_a)=id(f7) AND id(f_a)=id(f8) AND id(f_a)=id(f9) WITH distinct dd.year as date_year, dd.qtr as date_qtr, f_a LIMIT 9999999 
RETURN date_year, date_qtr, AVG(f_a.rescue_pain_score_max) as rescue_pain_score_max_avg, STDEV(f_a.rescue_pain_score_max) as rescue_pain_score_max_std, COUNT( id(f_a)) as record_count"

[DvirDukhan]

reproduces with
graph.explain g "MATCH (n0) MATCH (n1) MATCH (n2) MATCH (n3) MATCH (n4) MATCH (n5) MATCH (n6) MATCH (n7) MATCH (n8) MATCH(n9) MATCH (nr) where id(nr) = id(n0) AND id(nr) = id(n1) AND id(nr) = id(n2) AND id(nr) = id(n3) AND id(nr) = id(n4) AND id(nr) = id(n5) AND id(nr) = id(n6) AND id(nr) = id(n7) AND id(nr) = id(n8) AND id(nr) = id(n8) return nr"

WIP

[DvirDukhan]

@m4g005
we just merged a fix for this issue
please confirm that it solves the crash over your queries

[m4g005]

@DvirDukhan: The explain works, but if you run graph.query g "MATCH (n0) MATCH (n1) MATCH (n2) MATCH (n3) MATCH (n4) MATCH (n5) MATCH (n6) MATCH (n7) MATCH (n8) MATCH(n9) MATCH (nr) where id(nr) = id(n0) AND id(nr) = id(n1) AND id(nr) = id(n2) AND id(nr) = id(n3) AND id(nr) = id(n4) AND id(nr) = id(n5) AND id(nr) = id(n6) AND id(nr) = id(n7) AND id(nr) = id(n8) AND id(nr) = id(n8) return nr" then the server will crash still. I double checked with a query that runs OK through the explain but crashes on query.

Tested on the docker 2.0.0 image.
New stack:

redis-server: /redisgraph/src/execution_plan/record.c:117: Record_Get: Assertion `false' failed.


=== REDIS BUG REPORT START: Cut & paste starting from here ===
1:M 28 Jan 2020 19:31:41.775 # Redis 5.0.7 crashed by signal: 11
1:M 28 Jan 2020 19:31:41.775 # Crashed running the instruction at: 0x7f33815f4611
1:M 28 Jan 2020 19:31:41.775 # Accessing address: (nil)
1:M 28 Jan 2020 19:31:41.775 # Failed assertion: <no assertion failed> (<no file>:0)

------ STACK TRACE ------
EIP:
/lib/x86_64-linux-gnu/libc.so.6(abort+0x1fd)[0x7f33815f4611]

Backtrace:
redis-server *:6379(logStackTrace+0x32)[0x56536a09c572]
redis-server *:6379(sigsegvHandler+0x9e)[0x56536a09cc4e]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x12730)[0x7f33817a5730]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x1fd)[0x7f33815f4611]
/lib/x86_64-linux-gnu/libc.so.6(+0x2240f)[0x7f33815f440f]
/lib/x86_64-linux-gnu/libc.so.6(+0x30102)[0x7f3381602102]
/usr/lib/redis/modules/redisgraph.so(Record_Get+0x3d)[0x7f338039acfd]
/usr/lib/redis/modules/redisgraph.so(+0x1656c5)[0x7f338038f6c5]
/usr/lib/redis/modules/redisgraph.so(+0x1655d1)[0x7f338038f5d1]
/usr/lib/redis/modules/redisgraph.so(AR_EXP_Evaluate+0xc)[0x7f338038fa8c]
/usr/lib/redis/modules/redisgraph.so(_cache_records+0xaf)[0x7f33803a239f]
/usr/lib/redis/modules/redisgraph.so(+0x1786ad)[0x7f33803a26ad]
/usr/lib/redis/modules/redisgraph.so(_cache_records+0xcb)[0x7f33803a23bb]
/usr/lib/redis/modules/redisgraph.so(+0x1786ad)[0x7f33803a26ad]
/usr/lib/redis/modules/redisgraph.so(_cache_records+0xcb)[0x7f33803a23bb]
/usr/lib/redis/modules/redisgraph.so(+0x1786ad)[0x7f33803a26ad]
/usr/lib/redis/modules/redisgraph.so(+0x177294)[0x7f33803a1294]
/usr/lib/redis/modules/redisgraph.so(+0x17e8ba)[0x7f33803a88ba]
/usr/lib/redis/modules/redisgraph.so(+0x179beb)[0x7f33803a3beb]
/usr/lib/redis/modules/redisgraph.so(+0x17d28c)[0x7f33803a728c]
/usr/lib/redis/modules/redisgraph.so(ExecutionPlan_Execute+0x68)[0x7f338039cb38]
/usr/lib/redis/modules/redisgraph.so(Graph_Query+0x2c5)[0x7f3380398b55]
/usr/lib/redis/modules/redisgraph.so(+0x19afdd)[0x7f33803c4fdd]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7fa3)[0x7f338179afa3]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f33816cb4cf]

------ INFO OUTPUT ------
# Server
redis_version:5.0.7
redis_git_sha1:00000000
redis_git_dirty:0
redis_build_id:b671f408463590b9
redis_mode:standalone
os:Linux 4.9.184-linuxkit x86_64
arch_bits:64
multiplexing_api:epoll
atomicvar_api:atomic-builtin
gcc_version:8.3.0
process_id:1
run_id:c714c24c4543a9ebbbd539b0b9ff0612500c55bd
tcp_port:6379
uptime_in_seconds:420
uptime_in_days:0
hz:10
configured_hz:10
lru_clock:3181597
executable:/data/redis-server
config_file:

# Clients
connected_clients:1
client_recent_max_input_buffer:0
client_recent_max_output_buffer:0
blocked_clients:1

# Memory
used_memory:1496706144
used_memory_human:1.39G
used_memory_rss:1455656960
used_memory_rss_human:1.36G
used_memory_peak:1496706144
used_memory_peak_human:1.39G
used_memory_peak_perc:100.05%
used_memory_overhead:874838
used_memory_startup:824504
used_memory_dataset:1495831306
used_memory_dataset_perc:100.00%
allocator_allocated:1496077968
allocator_active:1502060544
allocator_resident:1565892608
total_system_memory:8360783872
total_system_memory_human:7.79G
used_memory_lua:37888
used_memory_lua_human:37.00K
used_memory_scripts:0
used_memory_scripts_human:0B
number_of_cached_scripts:0
maxmemory:0
maxmemory_human:0B
maxmemory_policy:noeviction
allocator_frag_ratio:1.00
allocator_frag_bytes:5982576
allocator_rss_ratio:1.04
allocator_rss_bytes:63832064
rss_overhead_ratio:0.93
rss_overhead_bytes:-110235648
mem_fragmentation_ratio:0.97
mem_fragmentation_bytes:-40366616
mem_not_counted_for_evict:0
mem_replication_backlog:0
mem_clients_slaves:0
mem_clients_normal:49694
mem_aof_buffer:0
mem_allocator:jemalloc-5.1.0
active_defrag_running:0
lazyfree_pending_objects:0

# Persistence
loading:0
rdb_changes_since_last_save:0
rdb_bgsave_in_progress:0
rdb_last_save_time:1580239481
rdb_last_bgsave_status:ok
rdb_last_bgsave_time_sec:-1
rdb_current_bgsave_time_sec:-1
rdb_last_cow_size:0
aof_enabled:0
aof_rewrite_in_progress:0
aof_rewrite_scheduled:0
aof_last_rewrite_time_sec:-1
aof_current_rewrite_time_sec:-1
aof_last_bgrewrite_status:ok
aof_last_write_status:ok
aof_last_cow_size:0

# Stats
total_connections_received:1
total_commands_processed:1
instantaneous_ops_per_sec:0
total_net_input_bytes:2045
total_net_output_bytes:0
instantaneous_input_kbps:0.00
instantaneous_output_kbps:0.00
rejected_connections:0
sync_full:0
sync_partial_ok:0
sync_partial_err:0
expired_keys:0
expired_stale_perc:0.00
expired_time_cap_reached_count:0
evicted_keys:0
keyspace_hits:1
keyspace_misses:0
pubsub_channels:0
pubsub_patterns:0
latest_fork_usec:0
migrate_cached_sockets:0
slave_expires_tracked_keys:0
active_defrag_hits:0
active_defrag_misses:0
active_defrag_key_hits:0
active_defrag_key_misses:0

# Replication
role:master
connected_slaves:0
master_replid:19e619b91d86b7fc578fead748e58cef31aa7e73
master_replid2:0000000000000000000000000000000000000000
master_repl_offset:0
second_repl_offset:-1
repl_backlog_active:0
repl_backlog_size:1048576
repl_backlog_first_byte_offset:0
repl_backlog_histlen:0

# CPU
used_cpu_sys:15.320000
used_cpu_user:57.290000
used_cpu_sys_children:0.000000
used_cpu_user_children:0.000000

# Commandstats
cmdstat_graph.QUERY:calls=1,usec=63,usec_per_call=63.00

# Cluster
cluster_enabled:0

# Keyspace
db0:keys=12,expires=0,avg_ttl=0

------ CLIENT LIST OUTPUT ------
id=92 addr=172.18.0.1:53276 fd=8 name= age=0 idle=0 flags=b db=0 sub=0 psub=0 multi=-1 qbuf=0 qbuf-free=32768 obl=0 oll=0 omem=0 events=r cmd=graph.QUERY

------ REGISTERS ------
1:M 28 Jan 2020 19:31:41.779 #
RAX:0000000000000000 RBX:0000000000000000
RCX:0000000000000000 RDX:0000000000000000
RDI:0000000000000002 RSI:00007f3380226e80
RBP:00007f3381756ee0 RSP:00007f3380226fa0
R8 :0000000000000000 R9 :00007f3380226e80
R10:0000000000000008 R11:0000000000000246
R12:00007f33809d9888 R13:00007f33809d5044
R14:0000000000000075 R15:00007f3312a19030
RIP:00007f33815f4611 EFL:0000000000010246
CSGSFS:002b000000000033
1:M 28 Jan 2020 19:31:41.779 # (00007f3380226faf) -> 0000000000000000
1:M 28 Jan 2020 19:31:41.779 # (00007f3380226fae) -> 0000000000000000
1:M 28 Jan 2020 19:31:41.779 # (00007f3380226fad) -> 0000000000000000
1:M 28 Jan 2020 19:31:41.779 # (00007f3380226fac) -> 0000000000000000
1:M 28 Jan 2020 19:31:41.779 # (00007f3380226fab) -> 0000000000000000
1:M 28 Jan 2020 19:31:41.779 # (00007f3380226faa) -> 0000000000000000
1:M 28 Jan 2020 19:31:41.779 # (00007f3380226fa9) -> 0000000000000000
1:M 28 Jan 2020 19:31:41.779 # (00007f3380226fa8) -> 0000000000000000
1:M 28 Jan 2020 19:31:41.780 # (00007f3380226fa7) -> 0000000000000000
1:M 28 Jan 2020 19:31:41.780 # (00007f3380226fa6) -> 0000000000000000
1:M 28 Jan 2020 19:31:41.780 # (00007f3380226fa5) -> 0000000000000000
1:M 28 Jan 2020 19:31:41.780 # (00007f3380226fa4) -> 0000000000000000
1:M 28 Jan 2020 19:31:41.780 # (00007f3380226fa3) -> 0000000000000000
1:M 28 Jan 2020 19:31:41.780 # (00007f3380226fa2) -> 0000000000000000
1:M 28 Jan 2020 19:31:41.780 # (00007f3380226fa1) -> 0000000000000000
1:M 28 Jan 2020 19:31:41.780 # (00007f3380226fa0) -> 0000000000000020

------ FAST MEMORY TEST ------
1:M 28 Jan 2020 19:31:41.780 # Bio thread for job type #0 terminated
1:M 28 Jan 2020 19:31:41.780 # Bio thread for job type #1 terminated
1:M 28 Jan 2020 19:31:41.781 # Bio thread for job type #2 terminated
*** Preparing to test memory region 56536a1ca000 (2248704 bytes)
*** Preparing to test memory region 56536ab6f000 (135168 bytes)
*** Preparing to test memory region 7f330c000000 (147456 bytes)
*** Preparing to test memory region 7f3312780000 (518520832 bytes)
*** Preparing to test memory region 7f333177d000 (1225261056 bytes)
*** Preparing to test memory region 7f337a7fe000 (8388608 bytes)
*** Preparing to test memory region 7f337afff000 (8388608 bytes)
*** Preparing to test memory region 7f337b800000 (8388608 bytes)
*** Preparing to test memory region 7f337c000000 (6291456 bytes)
*** Preparing to test memory region 7f337c7a3000 (2621440 bytes)
*** Preparing to test memory region 7f337ca24000 (8388608 bytes)
*** Preparing to test memory region 7f337d225000 (8388608 bytes)
*** Preparing to test memory region 7f337da26000 (8388608 bytes)
*** Preparing to test memory region 7f337e227000 (8388608 bytes)
*** Preparing to test memory region 7f337ea28000 (8388608 bytes)
*** Preparing to test memory region 7f337f229000 (8388608 bytes)
*** Preparing to test memory region 7f337fa2a000 (8388608 bytes)
*** Preparing to test memory region 7f3380bfc000 (16384 bytes)
*** Preparing to test memory region 7f3380c00000 (8388608 bytes)
*** Preparing to test memory region 7f33815cc000 (24576 bytes)
*** Preparing to test memory region 7f338178f000 (16384 bytes)
*** Preparing to test memory region 7f33817b0000 (16384 bytes)
*** Preparing to test memory region 7f3381946000 (8192 bytes)
*** Preparing to test memory region 7f3381949000 (4096 bytes)
*** Preparing to test memory region 7f3381973000 (4096 bytes)
.O.O.O.O.O.O.O.O.O.O.O.O.O.O.O.O.1:C 28 Jan 2020 19:31:49.230 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo

[m4g005]

@DvirDukhan one of my hawk-eyed engineers noticed a mistake in the query you used (it does crash the graph). The corrected query does not:
graph.query graph:anesthesia "MATCH (n0) MATCH (n1) MATCH (n2) MATCH (n3) MATCH (n4) MATCH (n5) MATCH (n6) MATCH (n7) MATCH (n8) MATCH(n9) MATCH (nr) where id(nr) = id(n0) AND id(nr) = id(n1) AND id(nr) = id(n2) AND id(nr) = id(n3) AND id(nr) = id(n4) AND id(nr) = id(n5) AND id(nr) = id(n6) AND id(nr) = id(n7) AND id(nr) = id(n8) AND id(nr) = id(n9) return nr"
But to be clear, the graph will still crash when running queries like the one I originally posted.

[DvirDukhan]

@m4g005
thanks, sorry for the long fix.
I'll start working on it right away

[m4g005]

No worries! Everything you guys are doing is appreciated!

[DvirDukhan]

@m4g005
@jeffreylovitz added a new fix for this issue.
I hope we solved it.

[m4g005]

@DvirDukhan confirmed -- no more crashes with docker container using 2.0.1. thanks!