linux-traipu team mailing list archive

[Henrik Ingo <henrik.ingo@xxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: drizzle
     Importance: Undecided
         Status: New


** Tags: query-log-plugin

** Tags added: query-log-plugin

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