Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Not a Bug
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
When recovering from various RQG workloads, maria_read_log reported the following:
The transaction log starts from lsn (3,0x2926)
TRACE of the last maria_read_log
/home/buildbot/rqg-buildbot-slave/rqg-weekend/build/mysql-test//../storage/maria/maria_read_log: Maria engine: starting recovery
recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% (1.3 seconds); transactions to roll back: 1 0**WARNING: 11776 UNDO records skipped in UNDO phase; some tables may be left inconsistent!**
(0.3 seconds);
/home/buildbot/rqg-buildbot-slave/rqg-weekend/build/mysql-test//../storage/maria/maria_read_log: Maria engine: recovery done
maria_read_log: DOUBTFUL (1 warnings, check previous output)
Apart from the underlying issue, maria_read_log returned 0, whereas instead this should have been a clear failure and the script should have returned a non-zero failure code.
RQG command line:
- 2010-09-07T14:40:31 # /home/buildbot/randgen/runall.pl \
- 2010-09-07T14:40:31 # --queries=1M \
- 2010-09-07T14:40:31 # --engine=Maria \
- 2010-09-07T14:40:31 # -
mysqld=-log-output=file \ - 2010-09-07T14:40:31 # --reporters=ErrorLog,Backtrace,Recovery,Shutdown \
- 2010-09-07T14:40:31 # --duration=240 \
- 2010-09-07T14:40:31 # --threads=5 \
- 2010-09-07T14:40:31 # --rows=10000 \
- 2010-09-07T14:40:31 # --mask-level=1 \
- 2010-09-07T14:40:31 # -
mysqld=-loose-maria-group-commit=hard \ - 2010-09-07T14:40:31 # -
mysqld=-loose-maria_group_commit_interval=1 \ - 2010-09-07T14:40:31 # -
mysqld=-maria-checkpoint-interval=1 \ - 2010-09-07T14:40:31 # -
mysqld=-maria-block-size=16K \ - 2010-09-07T14:40:31 # --grammar=conf/engines/varchar.yy \
- 2010-09-07T14:40:31 # --gendata=conf/engines/varchar.zz \
- 2010-09-07T14:40:31 # --mask=25153 \
- 2010-09-07T14:40:31 # --queries=100000000 \
- 2010-09-07T14:40:31 # --mask=25153 \
- 2010-09-07T14:40:31 # --basedir=. \
- 2010-09-07T14:40:31 # --seed=time \
- 2010-09-07T14:40:31 # --vardir=/home/buildbot/rqg-buildbot-slave/rqg-weekend/vardir-maria_recovery_weekend/current
bzr version-info:
revision-id: <email address hidden>
date: 2010-09-06 02:48:51 +0300
build-date: 2010-09-08 10:21:55 +0300
revno: 2922
branch-nick: 5.1
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
datadir, logs, etc.
LPexportBug632959_var-bug632959.zip