Can't trace YCSB queries for PostgreSQL with dbslower
- Dominant language
- C
- Stars
- 22.7k
- Forks
- 4.1k
- Avg merge
- 10d 4h
- Merged PRs (30d)
- 3
Description
I am trying to trace the queries of the YCSB for PostgreSQL v14.5 with the dbslower tool on Ubuntu 20.04, but they are not detected. I can trace queries that I input manually from the PostgreSQL client.
This happens with the command `./dbslower.py -m 0 postgres `
Adding a specific PID does not solve this either.
Example YCSB commands:
`bin/ycsb load jdbc -P workloads/workloada -cp jdbc-binding/lib/postgresql-42.5.0.jar -p db.driver=org.postgresql.Driver -p db.url=jdbc:postgresql://127.0.0.1:5432/test -p db.user=user -p db.passwd=password`
`bin/ycsb run jdbc -P workloads/workloada -cp jdbc-binding/lib/postgresql-42.5.0.jar -p db.driver=org.postgresql.Driver -p db.url=jdbc:postgresql://127.0.0.1:5432/test -p db.user=user -p db.passwd=password`
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with dbslower.py and reproduce the issue using the reported ./dbslower.py -m 0 postgres command and the YCSB JDBC load and run commands. Compare this with queries entered manually through the PostgreSQL client, then investigate why the YCSB PostgreSQL queries are not detected. Done means dbslower traces the YCSB queries, including when a specific PID is supplied.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, postgresql, ubuntu
- Domain
- databases, observability
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100