[MDEV-18340] [Draft] Couldn't repair table: mysql.global_priv Created: 2019-01-22  Updated: 2023-06-19  Resolved: 2023-06-19

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Aria
Affects Version/s: 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Cannot Reproduce Votes: 0
Labels: None

Attachments: File data.tar.gz     File mysql.err     File mysql.log.gz     File trial.log    

 Description   

https://travis-ci.org/elenst/travis-tests/jobs/482522725 [2556 8 1]

10.4 382115b99

2019-01-22  0:14:00 17 [ERROR] mysqld: Table 'global_priv' is marked as crashed and should be repaired
2019-01-22  0:14:00 17 [Warning] Aborted connection 17 to db: 'test' user: 'rqg' host: 'localhost' (Got an error reading communication packets)
2019-01-22  0:14:00 18 [ERROR] mysqld: Table './mysql/global_priv' is marked as crashed and should be repaired
2019-01-22  0:14:00 18 [Warning] Recovering table: './mysql/global_priv'
2019-01-22  0:14:00 18 [ERROR] Couldn't repair table: mysql.global_priv
2019-01-22  0:14:00 18 [Warning] Aborted connection 18 to db: 'test' user: 'rqg' host: 'localhost' (Got an error reading communication packets)
2019-01-22  0:14:00 15 [Note] Deleted Master_info file '/home/travis/logs/vardir/data/master.info'.
2019-01-22  0:14:00 15 [Note] Deleted Master_info file '/home/travis/logs/vardir/data/relay-log.info'.
2019-01-22  0:14:00 19 [ERROR] mysqld: Table './mysql/global_priv' is marked as crashed and last (automatic?) repair failed
2019-01-22  0:14:00 19 [ERROR] mysqld: Table './mysql/global_priv' is marked as crashed and last (automatic?) repair failed
...

elenst-jira-refs 8b68af909d Toolbox: b534cb88ebe

perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1548115997 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/modules/alter_table_columns.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/userstat.yy --redefine=conf/mariadb/modules/foreign_keys.yy -redefine=conf/mariadb/modules/locks.yy --redefine=conf/mariadb/modules/sql_mode.yy --redefine=conf/mariadb/modules/acl.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --redefine=conf/mariadb/modules/locks-10.4-extra.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--default-storage-engine=MyISAM --grammar=conf/engines/engine_stress.yy --gendata=conf/engines/engine_stress.zz --transformers=ExecuteAsIntersect,ExecuteAsExcept,ExecuteAsCTE,ExecuteAsExecuteImmediate,ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff

Not reproducible right away.


Generated at Thu Feb 08 08:43:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.