linux-traipu team mailing list archive

Thread
Date

[Bug 659637] Re: transaction log udfs do not report all data if server is stopped and started

To: linux-traipu@xxxxxxxxxxxxxxxxxxx
From: David Shrewsbury <659637@xxxxxxxxxxxxxxxxxx>
Date: Thu, 27 Sep 2012 12:46:43 -0000
Reply-to: Bug 659637 <659637@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

The InnoDB trx log is the standard.

** Changed in: drizzle/7.0
       Status: Confirmed => Won't Fix

** Changed in: drizzle
       Status: Confirmed => Won't Fix

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

Title:
  transaction log udfs do not report all data if server is stopped and
  started

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  Won't Fix
Status in Drizzle 7.0 series:
  Won't Fix

Bug description:
  This may be related to https://bugs.launchpad.net/drizzle/+bug/659633
  but the udfs are not showing any transaction information prior to a
  restart of the server

  drizzle> select * from TRANSACTION_LOG_ENTRIES;
  +--------------+-------------+--------------+
  | ENTRY_OFFSET | ENTRY_TYPE  | ENTRY_LENGTH |
  +--------------+-------------+--------------+
  |         1087 | TRANSACTION |           40 | 
  |         1127 | TRANSACTION |           91 | 
  +--------------+-------------+--------------+
  2 rows in set (0 sec)

  drizzle> select * from TRANSACTION_LOG_TRANSACTIONS;
  +--------------+----------------+-----------+------------------+------------------+----------------+----------+
  | ENTRY_OFFSET | TRANSACTION_ID | SERVER_ID | START_TIMESTAMP  | END_TIMESTAMP    | NUM_STATEMENTS | CHECKSUM |
  +--------------+----------------+-----------+------------------+------------------+----------------+----------+
  |         1087 |              1 |         1 | 1286936975431616 | 1286936975431617 |              0 |        0 | 
  |         1127 |              2 |         1 | 1286937354269769 | 1286937354304734 |              1 |        0 | 
  +--------------+----------------+-----------+------------------+------------------+----------------+----------+
  2 rows in set (0 sec)

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