search

BemiHQ / BemiDB

Postgres read replica optimized for analytics
https://bemidb.com
GNU Affero General Public License v3.0
1.09k stars 20 forks source link

Support map query ping #16

Open flemzord opened 3 days ago

flemzord commented 3 days ago

Hello

Do you plan to support this feature?

Regards

2024/11/22 12:11:13 [INFO] BemiDB: Accepted connection from 127.0.0.1:65428
2024/11/22 12:11:13 [ERROR] Couldn't map query: -- ping
Unsupported query type
2024/11/22 12:11:13 [INFO] BemiDB: Closed connection from 127.0.0.1:65428
exAspArk commented 3 days ago

Hey @flemzord — thank you for submitting this issue!

We've fixed processing empty or comment-only (e.g. starting with -- ...) queries. Would you be able to download the latest version v0.13.2 and try again?

By the way, could you please share what system did you connect that issued these "ping"-comment queries? We'd love to test it to ensure compatibility.

flemzord commented 3 days ago

Hello @exAspArk I've just downloaded the latest version v0.14.0

2024/11/22 16:11:27 [INFO] BemiDB: Listening on 127.0.0.1:54321
2024/11/22 16:11:27 [INFO] DuckDB: Connected
2024/11/22 16:11:35 [INFO] BemiDB: Accepted connection from 127.0.0.1:55586
2024/11/22 16:11:35 [INFO] BemiDB: Closed connection from 127.0.0.1:55586
2024/11/22 16:11:35 [INFO] BemiDB: Accepted connection from 127.0.0.1:55587
2024/11/22 16:11:35 [ERROR] Statement mismatch: stmtcache_6fe7e3a4ef967b8235918363d4c1cd2674035f4d01fabc25 instead of SELECT * FROM _system.goose_db_version WHERE is_applied ORDER BY version_id DESC LIMIT 1
2024/11/22 16:11:35 [INFO] BemiDB: Closed connection from 127.0.0.1:55587

I am currently running the following software: https://github.com/formancehq/ledger

exAspArk commented 3 days ago

@flemzord thank you for sharing that! We'll take a closer look

flemzord commented 3 days ago

If you have any questions, don't hesitate to ask me :)