API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 20th, 2017
102
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.30 KB | None | 0 0
raw download clone embed print report
  1. =======================================================
  2. WARNING: Using mysql-test-run.pl version 1!
  3. =======================================================
  4. Logging: lib/v1/mysql-test-run.pl --start-and-exit --mysqld=--maria --skip-ndb --mysqld=--core-file --mysqld=--loose-new --mysqld=--sql-mode=no_engine_substitution --mysqld=--relay-log=slave-relay-bin --mysqld=--loose-innodb --mysqld=--loose-falcon-debug-mask=2 --mysqld=--secure-file-priv= --mysqld=--max-allowed-packet=16Mb --mysqld=--loose-innodb-status-file=1 --mysqld=--master-retry-count=65535 --vardir=/my/vardir --master_port=19300 --mysqld=--sync-sys=0 --mysqld=--safe-mode --mysqld=--sync-sys=0 --mysqld=--log-output=file --mysqld=--maria_log_purge_type=at_flush --mysqld=--loose-maria-group-commit=hard --mysqld=--loose-maria_group_commit_interval=0 --mysqld=--maria-checkpoint-interval=120 --mysqld=--maria-block-size=4K 1st
  5. MySQL Version 5.1.50
  6. Using dynamic switching of binlog format
  7. Skipping ndbcluster
  8. Setting mysqld to support SSL connections
  9. Binaries are debug compiled
  10. Using MTR_BUILD_THREAD = 930
  11. Using MASTER_MYPORT = 19300
  12. Using MASTER_MYPORT1 = 19301
  13. Using SLAVE_MYPORT = 19302
  14. Using SLAVE_MYPORT1 = 19303
  15. Using SLAVE_MYPORT2 = 19304
  16. Using IM_PORT = 19307
  17. Using IM_MYSQLD1_PORT = 19308
  18. Using IM_MYSQLD2_PORT = 19309
  19. Killing Possible Leftover Processes
  20. Removing Stale Files
  21. Creating Directories
  22. Installing Master Database
  23. =======================================================
  24.  
  25. TEST RESULT TIME (ms)
  26. -------------------------------------------------------
  27.  
  28.  
  29. Servers started, exiting
  30. # 2010-10-13T21:05:47 Starting
  31. # 2010-10-13T21:05:47 gentest.pl \
  32. # 2010-10-13T21:05:47 --gendata=conf/engines/varchar.zz \
  33. # 2010-10-13T21:05:47 --engine=Maria \
  34. # 2010-10-13T21:05:47 --reporter=ErrorLog \
  35. # 2010-10-13T21:05:47 --reporter=Backtrace \
  36. # 2010-10-13T21:05:47 --reporter=Recovery \
  37. # 2010-10-13T21:05:47 --reporter=Shutdown \
  38. # 2010-10-13T21:05:47 --threads=10 \
  39. # 2010-10-13T21:05:47 --queries=100000000 \
  40. # 2010-10-13T21:05:47 --duration=30 \
  41. # 2010-10-13T21:05:47 --dsn=dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test \
  42. # 2010-10-13T21:05:47 --grammar=conf/engines/varchar.yy \
  43. # 2010-10-13T21:05:47 --seed=time \
  44. # 2010-10-13T21:05:47 --mask=14207 \
  45. # 2010-10-13T21:05:47 --mask-level=2 \
  46. # 2010-10-13T21:05:47 --rows=10000
  47. # 2010-10-13T21:05:47 Converting --seed=time to --seed=1286993147
  48. # 2010-10-13T21:05:47 -------------------------------
  49. # 2010-10-13T21:05:47 Configuration
  50. # 2010-10-13T21:05:47 dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test']
  51. # 2010-10-13T21:05:47 duration => 30
  52. # 2010-10-13T21:05:47 engine => Maria
  53. # 2010-10-13T21:05:47 gendata => conf/engines/varchar.zz
  54. # 2010-10-13T21:05:47 grammar => conf/engines/varchar.yy
  55. # 2010-10-13T21:05:47 mask => 14207
  56. # 2010-10-13T21:05:47 mask-level => 2
  57. # 2010-10-13T21:05:47 queries => 100000000
  58. # 2010-10-13T21:05:47 reporters => ['ErrorLog', 'Backtrace', 'Recovery', 'Shutdown']
  59. # 2010-10-13T21:05:47 rows => 10000
  60. # 2010-10-13T21:05:47 seed => time
  61. # 2010-10-13T21:05:47 threads => 10
  62. # 2010-10-13T21:05:47 validators => ['']
  63. # 2010-10-13T21:05:47 Executor initialized, id
  64. # 2010-10-13T21:05:47 Default schema: test
  65. # 2010-10-13T21:05:47 # Creating MySQL table: test.table10000_maria_varchar_1024_not_null; engine: maria; rows: 10000 .
  66. # 2010-10-13T21:05:57 # Progress: loaded 10000 out of 10000 rows
  67. # 2010-10-13T21:05:58 # Creating MySQL table: test.table10000_maria_key_pk_parts_2_varchar_1024_not_null; engine: maria; rows: 10000 .
  68. # 2010-10-13T21:06:08 # Progress: loaded 10000 out of 10000 rows
  69. # 2010-10-13T21:06:08 Reporters: ErrorLog, Backtrace, Recovery, Shutdown
  70. # 2010-10-13T21:06:08 Validators: ErrorMessageCorruption
  71. # 2010-10-13T21:06:08 Starting 10 processes, 100000000 queries each, duration 30 seconds.
  72. # 2010-10-13T21:06:08 GenTest::ErrorFilter(25032) started
  73. # 2010-10-13T21:06:08 Executor initialized, id 1
  74. # 2010-10-13T21:06:08 Default schema: test
  75. # 2010-10-13T21:06:08 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test
  76. # 2010-10-13T21:06:08 Executor initialized, id 1
  77. # 2010-10-13T21:06:08 Default schema: test
  78. # 2010-10-13T21:06:08 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test
  79. # 2010-10-13T21:06:09 Executor initialized, id 1
  80. # 2010-10-13T21:06:09 Default schema: test
  81. # 2010-10-13T21:06:09 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test
  82. # 2010-10-13T21:06:09 Executor initialized, id 1
  83. # 2010-10-13T21:06:09 Default schema: test
  84. # 2010-10-13T21:06:09 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test
  85. # 2010-10-13T21:06:09 Executor initialized, id 1
  86. # 2010-10-13T21:06:09 Default schema: test
  87. # 2010-10-13T21:06:09 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test
  88. # 2010-10-13T21:06:09 Executor initialized, id 1
  89. # 2010-10-13T21:06:09 Default schema: test
  90. # 2010-10-13T21:06:09 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test
  91. # 2010-10-13T21:06:09 Executor initialized, id 1
  92. # 2010-10-13T21:06:09 Default schema: test
  93. # 2010-10-13T21:06:09 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test
  94. # 2010-10-13T21:06:09 Executor initialized, id 1
  95. # 2010-10-13T21:06:09 Default schema: test
  96. # 2010-10-13T21:06:09 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test
  97. # 2010-10-13T21:06:09 Executor initialized, id 1
  98. # 2010-10-13T21:06:09 Default schema: test
  99. # 2010-10-13T21:06:09 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test
  100. # 2010-10-13T21:06:09 Executor initialized, id 1
  101. # 2010-10-13T21:06:09 Default schema: test
  102. # 2010-10-13T21:06:09 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test
  103. # 2010-10-13T21:06:09 Started periodic reporting process...
  104. # 2010-10-13T21:06:12 Query: INSERT INTO `table10000_maria_varchar_1024_not_null` ( `col_varchar_1024_latin1` ) SELECT `col_varchar_1024_latin1_not_null` FROM `table10000_maria_varchar_1024_not_null` WHERE `col_varchar_1024_utf8` = 'z' ORDER BY `col_varchar_1024_latin1` , `col_varchar_1024_latin1_key` LIMIT 6 failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed.
  105. # 2010-10-13T21:06:12 Query: REPLACE INTO `table10000_maria_key_pk_parts_2_varchar_1024_not_null` ( `col_varchar_1024_utf8_not_null_key` ) SELECT `col_varchar_1024_utf8_not_null_key` FROM `table10000_maria_varchar_1024_not_null` WHERE `col_varchar_1024_utf8` >= 'lhwordcntxurelyokhobkdclxshumqcdnvkeexquaatmxzgwlkrmiemmjxzofmudxwufrxtynmphobieuvsmuyhmlemqaokfatvjhlenwvftxyiynshktygdczmndepcxgjowvttilgyaewmhumacminxqahjqnwifplingznntnovabagziuboddkxp' LIMIT 6 failed: 1032 Can't find record in 'table10000_maria_key_pk_parts_2_varchar_1024_not_null'
  106. # 2010-10-13T21:06:12 Killing child process with pid 25040...
  107. # 2010-10-13T21:06:12 Killing child process with pid 25042...
  108. # 2010-10-13T21:06:12 Killing child process with pid 25038...
  109. # 2010-10-13T21:06:12 Killing child process with pid 25034...
  110. # 2010-10-13T21:06:12 Killing child process with pid 25046...
  111. # 2010-10-13T21:06:12 Killing child process with pid 25052...
  112. # 2010-10-13T21:06:12 Killing child process with pid 25036...
  113. # 2010-10-13T21:06:12 Killing child process with pid 25044...
  114. # 2010-10-13T21:06:12 Killing child process with pid 25050...
  115. # 2010-10-13T21:06:13 Killing periodic reporting process with pid 25033...
  116. # 2010-10-13T21:06:13 Kill GenTest::ErrorFilter(25032)
  117. # 2010-10-13T21:06:13 Sending SIGKILL to server with pid 24995 in order to force a recovery.
  118. # 2010-10-13T21:06:18 Copying datadir... (interrupting the copy operation may cause a false recovery failure to be reported below
  119. # 2010-10-13T21:06:18 Attempting database recovery using maria_read_log ...
  120. # 2010-10-13T21:06:19 Copying complete
  121. The transaction log starts from lsn (1,0x2007)
  122. TRACE of the last maria_read_log
  123. /home/my/maria-5.1/mysql-test//../storage/maria/maria_read_log: Maria engine: starting recovery
  124. recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% (11.3 seconds); tables to flush: 3 2 1 0 (2.3 seconds);
  125. /home/my/maria-5.1/mysql-test//../storage/maria/maria_read_log: Maria engine: recovery done
  126. maria_read_log: SUCCESS
  127. # 2010-10-13T21:06:36 maria_read_log apparently returned success
  128. Checking MARIA file: test/table10000_maria_key_pk_parts_2_varchar_1024_not_null#P#p0.MAI
  129. Data records: 3481 Deleted blocks: 0
  130. - check file-size
  131. - check key delete-chain
  132. - check index reference
  133. - check data record references index: 1
  134. - check records and index references
  135.  
  136. ---------
  137.  
  138. Checking MARIA file: test/table10000_maria_key_pk_parts_2_varchar_1024_not_null#P#p1.MAI
  139. Data records: 6520 Deleted blocks: 0
  140. - check file-size
  141. - check key delete-chain
  142. - check index reference
  143. - check data record references index: 1
  144. - check records and index references
  145.  
  146. ---------
  147.  
  148. Checking MARIA file: test/table10000_maria_varchar_1024_not_null.MAI
  149. Data records: 9998 Deleted blocks: 0
  150. - check file-size
  151. - check key delete-chain
  152. - check index reference
  153. - check data record references index: 1
  154. - check records and index references
  155. # 2010-10-13T21:06:37 maria_chk_result apparently returned success
  156. # 2010-10-13T21:06:37 Attempting database recovery using the server ...
  157. # 2010-10-13T21:06:37 Executing /home/my/maria-5.1/mysql-test//../sql/mysqld --no-defaults --core-file --loose-console --loose-maria-block-size=4096 --language=/home/my/maria-5.1/sql/share/english/ --loose-lc-messages-dir= --datadir="/my/vardir/master-data_recovery" --log-output=file --general_log=ON --general_log_file="/my/vardir/master-data_recovery/query-recovery.log" --datadir="/my/vardir/master-data_recovery" --socket="/my/vardir/tmp/master.sock" --port=19300 --loose-plugin-dir=/home/my/maria-5.1/mysql-test/lib/mysql/plugin --loose-skip-innodb --loose-skip-pbxt 2>&1 .
  158. # 2010-10-13T21:06:37 101013 21:06:37 [Note] Plugin 'PBXT' is disabled.
  159. # 2010-10-13T21:06:37 101013 21:06:37 [Note] Plugin 'InnoDB' is disabled.
  160. # 2010-10-13T21:06:37 101013 21:06:37 [Note] mysqld: Maria engine: starting recovery
  161. # 2010-10-13T21:06:48 recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% (6.0 seconds); tables to flush: 3 2 1 0 (2.4 seconds);
  162. # 2010-10-13T21:06:48 101013 21:06:48 [Note] mysqld: Maria engine: recovery done
  163. # 2010-10-13T21:06:48 101013 21:06:48 [Warning] /home/my/maria-5.1/mysql-test//../sql/mysqld: unknown variable 'loose-lc-messages-dir='
  164. # 2010-10-13T21:06:48 101013 21:06:48 [Note] Event Scheduler: Loaded 0 events
  165. # 2010-10-13T21:06:48 101013 21:06:48 [Note] /home/my/maria-5.1/mysql-test//../sql/mysqld: ready for connections.
  166. # 2010-10-13T21:06:48 Server Recovery was apparently successfull.
  167. # 2010-10-13T21:06:48 Testing database consistency
  168. # 2010-10-13T21:06:48 Version: '5.1.50-MariaDB-valgrind-max-debug' socket: '/my/vardir/tmp/master.sock' port: 19300 Source distribution
  169. # 2010-10-13T21:06:48 Verifying table: table10000_maria_key_pk_parts_2_varchar_1024_not_null; database: test
  170. # 2010-10-13T21:06:50 Executing CHECK TABLE `test`.`table10000_maria_key_pk_parts_2_varchar_1024_not_null` EXTENDED.
  171. # 2010-10-13T21:06:54 Executing ANALYZE TABLE `test`.`table10000_maria_key_pk_parts_2_varchar_1024_not_null`.
  172. # 2010-10-13T21:06:54 Executing OPTIMIZE TABLE `test`.`table10000_maria_key_pk_parts_2_varchar_1024_not_null`.
  173. # 2010-10-13T21:06:56 Executing REPAIR TABLE `test`.`table10000_maria_key_pk_parts_2_varchar_1024_not_null` EXTENDED.
  174. # 2010-10-13T21:07:03 Executing ALTER TABLE `test`.`table10000_maria_key_pk_parts_2_varchar_1024_not_null` ENGINE = MARIA.
  175. # 2010-10-13T21:07:12 Verifying table: table10000_maria_varchar_1024_not_null; database: test
  176. # 2010-10-13T21:07:13 Executing CHECK TABLE `test`.`table10000_maria_varchar_1024_not_null` EXTENDED.
  177. # 2010-10-13T21:07:16 Executing ANALYZE TABLE `test`.`table10000_maria_varchar_1024_not_null`.
  178. # 2010-10-13T21:07:16 Executing OPTIMIZE TABLE `test`.`table10000_maria_varchar_1024_not_null`.
  179. # 2010-10-13T21:07:18 Executing REPAIR TABLE `test`.`table10000_maria_varchar_1024_not_null` EXTENDED.
  180. # 2010-10-13T21:07:23 Executing ALTER TABLE `test`.`table10000_maria_varchar_1024_not_null` ENGINE = MARIA.
  181. # 2010-10-13T21:07:29 Shutting down the server...
  182. # 2010-10-13T21:07:29 101013 21:07:29 [Note] Got signal 15 to shutdown mysqld
  183. # 2010-10-13T21:07:29 101013 21:07:29 [Note] /home/my/maria-5.1/mysql-test//../sql/mysqld: Normal shutdown
  184. # 2010-10-13T21:07:29
  185. # 2010-10-13T21:07:29 101013 21:07:29 [Note] Event Scheduler: Purging the queue. 0 events
  186. # 2010-10-13T21:07:29 Waiting for mysqld with pid 24995 to terminate...
  187.  
  188. # 2010-10-13T21:07:29 ... waiting complete.
  189. # 2010-10-13T21:07:29 Test completed with failure status STATUS_DATABASE_CORRUPTION (105)
  190. # 2010-10-13T21:07:29 gentest.pl exited with exit status STATUS_DATABASE_CORRUPTION (105)
  191. 2010-10-13T21:07:29 [24968] ./runall.pl will exit with exit status STATUS_DATABASE_CORRUPTION (105)
  192. (/home/my/randgen) # 2010-10-13T21:07:31 101013 21:07:31 [Note] /home/my/maria-5.1/mysql-test//../sql/mysqld: Shutdown complete
  193. # 2010-10-13T21:07:31
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!