linux-traipu team mailing list archive

[Daniel Nichter <daniel@xxxxxxxxxxx>]

Henrik,

Does logging_query have this problem too?  Its code says:

    // a single write has a kernel thread lock, thus no need mutex guard this
    wrv= write(fd, msgbuf.c_str(), msgbuf.length());
    assert(wrv == msgbuf.length());

Whereas query_log does,

    _fh << "# start_ts=" << event->ts
    ...

which isn't thread-safe (and yes, that's my fault :-).  If write() is
indeed thread-safe, then it will be easy to make query_log use it like
logginq_query.

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/1001199

Title:
  query_log output is mangled due to multithreadedness

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  New

Bug description:
  When enabling query_log plugin and directing 32 sysbench threads
  against it, I get output like below:

  # start_ts=2012-05-18T10:56:32.046310
  # session_id=12 query_id=11 rows_examined=1 rows_sent=1 tmp_tables=0 warnings=0
  # execution_time=# start_ts=2012-05-18T10:56:32.045882
  # session_id=12 query_id=11 rows_examined=1 rows_sent=1 tmp_tables=HERE id=0lock_time=
   warnings=0
  # execution_time=0.002518 session_time=0.034174
  # error=false
  # schema="sbtest"
  SELECT pad FROM sbtest1 WHERE id=20176010;
  #
  # start_ts=2012-05-18T10:56:32.046310
  # session_id=12 query_id=11 rows_examined=1 rows_sent=1 tmp_tables=0 warnings=0
  # execution_time=# start_ts=2012-05-18T10:56:32.045882
  # session_id=12 query_id=11 rows_examined=1 rows_sent=1 tmp_tables=HERE id=0lock_time=
   warnings=0
  # execution_time=0.002518 session_time=0.034174
  # error=false
  # schema="sbtest"
  SELECT pad FROM sbtest1 WHERE id=20176010;
  #
  0.031333 lock_time=0.002518 session_time=0.034174
  # error=false
  # schema="sbtest"
  SELECT pad FROM sbtest1 WHERE id=20176010;
  #
  ....

  
  It seems that output from multiple threads is mixed together.

To manage notifications about this bug go to:
https://bugs.launchpad.net/drizzle/+bug/1001199/+subscriptions