iovisor / iovisor/bcc

Can't trace YCSB queries for PostgreSQL with dbslower

Open
#4,248 1 comment 0 reactions 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.