Skip to content
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

REST Error during ClickHouse Flow Query #6015

Closed
lucaderi opened this issue Oct 25, 2021 · 4 comments
Closed

REST Error during ClickHouse Flow Query #6015

lucaderi opened this issue Oct 25, 2021 · 4 comments
Labels
Bug Not Yet Working Ready to Test a feedback is needed on a proposal or implementation

Comments

@lucaderi
Copy link
Member

25/Oct/2021 16:23:10 [LuaEngine.cpp:1253] WARNING: Script failure [/home/deri/ntopng/scripts/lua/pro/rest/v2/get/host/flows/flows_info.lua][...png/scripts/lua/pro/modules/flow_db/clickhouse_utils.lua:451: bad argument #4 to 'format' (number expected, got nil)]

@MatteoBiscosi MatteoBiscosi added the Ready to Test a feedback is needed on a proposal or implementation label Oct 25, 2021
@MatteoBiscosi
Copy link
Member

MatteoBiscosi commented Oct 25, 2021

Should be fixed, please update and let me know (pro repo)

@lucaderi
Copy link
Member Author

A new bug arose
25/Oct/2021 17:39:42 [MySQLDB.cpp:1016] ERROR: MySQL error: [Code: 53. DB::Exception: Cannot convert string 90.147.160.70 to type UInt32: while executing 'FUNCTION equals(IPV4_DST_ADDR : 6, '90.147.160.70' : 7) -> equals(IPV4_DST_ADDR, '90.147.160.70') UInt8 : 9'. (TYPE_MISMATCH) (version 21.10.2.15 (official build))][53][SELECT COUNT(*) AS totalRows FROM flows WHERE (( (IPV4_DST_ADDR='90.147.160.70' OR IPV4_SRC_ADDR='90.147.160.70') )) AND (FIRST_SEEN >= 1634571578) AND (LAST_SEEN <= 1635176378)]
25/Oct/2021 17:39:42 [LuaEngine.cpp:1253] WARNING: Script failure [/home/deri/ntopng/scripts/lua/pro/rest/v2/get/host/flows/flows_info.lua][/home/deri/ntopng/scripts/lua/modules/ntop_utils.lua:114: bad argument #1 to 'for iterator' (table expected, got string)]

@MatteoBiscosi
Copy link
Member

this bug was due to the fact that the ip was not converted into the numeric version, please update pro repo, the problem should be fixed

@lucaderi
Copy link
Member Author

Seems to work now

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Not Yet Working Ready to Test a feedback is needed on a proposal or implementation
Projects
None yet
Development

No branches or pull requests

2 participants