sagastume
commented
8 months ago Thanks for your report, @aakashjhawar.
I don't think the issue is related to the MATCH clause; most likely, it's a structure or data type that Packstream doesn't recognize. There might be a node in your data containing a structure or data that boltx cannot decode.
I attempted to reproduce the problem with different datasets both on Neo4j Aura and locally, but I couldn't replicate it.
I can suggest two ways to obtain more information:
- Instead of obtaining all the nodes with "MATCH(n) RETURN n" you can segment the queries to find which nodes cause the problem.
- The second thing is to be able to activate the logs
To investigate further, we could try to gather additional information through the logs. Please make sure that when sharing logs, no sensitive or confidential information is included.
Incorporate this configuration into the config.exs or test.exs file as needed.
#config/test.exs
# Print only warnings and errors during test
config :logger, level: :debug
config :boltx,
log: true,
log_hex: false
config :boltx, Bolt,
hostname: "127.0.0.1",
auth: [username: "neo4j", password: "password"],
user_agent: "boltxTest/1",
pool_size: 1,
prefix: :default,
scheme: "bolt",
port: 7687,
name: Boltx
Navigate to your project's test/test_helper.exs file and add the following:
#test/test_helper.exs
ExUnit.start(capture_log: true)Add a file to perform a test with the query.
test/{your_project}_boltx_test.exs
#test/boltx_test.exs
defmodule Blog.BoltxTest do
use ExUnit.Case, async: true
describe "MATCH" do
@tag :debug
test "get all nodes" do
response = Boltx.query!(Boltx, "MATCH(n) RETURN n")
assert %Boltx.Response{results: []} = true
end
end
endRun:
mix test --only debug
The output will be something similar to this:
The following output was logged:
02:22:16.985 [debug] C: MESSAGE_TYPE ~ ["MATCH(n) RETURN n", %{}, %{mode: "w", bookmarks: [], db: nil, tx_metadata: nil}]
02:22:16.994 [debug] S: SUCCESS ~ %{"fields" => ["n"], "t_first" => 2}
02:22:16.997 [debug] C: MESSAGE_TYPE ~ [%{n: -1, qid: -1}]
02:22:17.003 [debug] S: SUCCESS ~ %{"bookmark" => "FB:kcwQGIH38AzVQcSbFJ8oxrKsLQOQ", "db" => "neo4j", "t_last" => 0, "type" => "r"}As a reminder, please ensure that logs do not contain private or sensitive information.
aakashjhawar
I got the following error while running the query.
Boltx.query(Boltx, "MATCH(n) RETURN n")After debugging more, I found out if the query has
MATCHcommand in it, then it throws error.Can you please help me?