linux-traipu team mailing list archive

[Henrik Ingo <henrik.ingo@xxxxxxxxxxxxx>]

I did not try logging_query. I'll let you know if I ever do. (This is on
a work computer that I occasionally play with.)

-- 
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