Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18237

InnoDB: Unable to drop FTS index aux table and further errors (possibly bogus)

    Details

      Description

      Run the test with

      --mem --mysqld=--innodb-buffer-pool-size=1G --mysqld=--innodb-page-size=64K
      

      and with --repeat=N. N=20 is usually enough for me, but the test is very non-deterministic, so it can vary a lot on different machines and builds.
      I'm not sure whether the InnoDB options above are strictly necessary, but without them it's either not reproducible at all on my machine, or happens extremely rarely.

      The test has two different timeout values, lock_wait_timeout= 4, max_statement_time= 6;. They've chosen empirically on my machine, the lowest values which still allow the failure to happen. It's possible that they'll need to be changed on a different machine.

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (
        c5 varchar(355) CHARACTER SET utf8 not null,
        c0 varchar(355) CHARACTER SET latin1,
        c17 char(255) CHARACTER SET utf8 not null,
        c7 varchar(255) CHARACTER SET utf8,
        c13 char(255) CHARACTER SET utf8,
        c2 varchar(355) CHARACTER SET latin1 default null,
        c4 varchar(355) CHARACTER SET latin1 not null,
        pk integer auto_increment,
        c12 char(255) CHARACTER SET latin1,
        c14 char(255) CHARACTER SET latin1 default null,
        c16 char(255) CHARACTER SET latin1 not null,
        c9 varchar(255) CHARACTER SET utf8 default null,
        c1 varchar(355) CHARACTER SET utf8,
        c15 char(255) CHARACTER SET utf8 default null,
        c11 varchar(255) CHARACTER SET utf8 not null,
        c6 varchar(255) CHARACTER SET latin1,
        c3 varchar(355) CHARACTER SET utf8 default null,
        c8 varchar(255) CHARACTER SET latin1 default null,
        c10 varchar(255) CHARACTER SET latin1 not null,
        fulltext key (c17),
        fulltext key (c7),
        fulltext key (c13),
        fulltext key (c2),
        fulltext key (c4),
        primary key (pk),
        fulltext key (c12),
        fulltext key (c14),
        fulltext key (c15),
        fulltext key (c11),
        fulltext key (c6),
        fulltext key (c3),
        fulltext key (c8),
        fulltext key (c10)
      ) ENGINE=InnoDB;
       
      INSERT INTO t1 VALUES  ('woman', 'camp', 'airplane', 'classify', 'numerous', 'philosophy', 'allegedly', NULL, 'sector', 'predict', 'river', 'require', 'difficult', 'not', 'destruction', 'pasta', 'puzzle', 'mortality', 'admire') ,  ('margin', 'fame', 'african-american', 'if', 'branch', 'station', 'operator', NULL, 'pile', 'than', 'drug', 'have', 'everybody', 'convention', 'short-term', 'current', 'rack', 'impress', 'index') ,  ('aisle', 'hand', 'love', 'notice', 'seldom', 'cycle', 'chinese', NULL, 'strict', 'certain', 'academic', 'breeze', 'invisible', 'tend', 'sweater', 'hit', 'blade', 'village', 'protocol') ,  ('anymore', 'parent', 'around', 'equal', 'guess', 'spark', 'export', NULL, 'totally', 'translate', 'grandparent', 'reason', 'documentary', 'them', 'nobody', 'cancel', 'fragile', 'allow', 'mark') ,  ('instead', 'shooting', 'italian', 'chop', 'alone', 'expression', 'wedding', NULL, 'beautiful', 'possession', 'clinic', 'shopping', 'forever', 'change', 'hopefully', 'ghost', 'science', 'grocery', 'dedicate') ,  ('nail', 'reference', 'must', 'initial', 'steak', 'tension', 'cite', NULL, 'decline', 'quit', 'regular', 'someday', 'settlement', 'thin', 'peel', 'consumer', 'incredible', 'lifestyle', 'block') ,  ('chair', 'ecosystem', 'chief', 'consume', 'management', 'oral', 'valley', NULL, 'since', 'begin', 'discrimination', 'strong', 'lot', 'international', 'regional', 'characteristic', 'age', 'crop', 'weird') ,  ('blood', 'connection', 'particularly', 'punish', 'god', 'require', 'talent', NULL, 'recommendation', 'awareness', 'new', 'rent', 'state', 'mirror', 'write', 'garage', 'fighter', 'explore', 'athletic') ,  ('bank', 'mount', 'personal', 'frontier', 'grand', 'eyebrow', 'farmer', NULL, 'transaction', 'change', 'tie', 'percentage', 'japanese', 'managing', 'electricity', 'floor', 'package', 'unprecedented', 'fail') ,  ('ugly', 'productivity', 'youth', 'enforcement', 'teen', 'grandchild', 'hungry', NULL, 'entitle', 'cart', 'soar', 'license', 'influential', 'incident', 'cease', 'eighth', 'sharp', 'electrical', 'investigate') ,  ('difficulty', 'funny', 'shallow', 'violent', 'verbal', 'blessing', 'arrest', NULL, 'connect', 'forehead', 'sign', 'chemistry', 'deer', 'facility', 'cell', 'branch', 'entity', 'shut', 'invite') ,  ('hang', 'heal', 'voice', 'knock', 'himself', 'requirement', 'infection', NULL, 'fair', 'welfare', 'section', 'graduate', 'streak', 'plead', 'bag', 'junior', 'hotel', 'bride', 'minimal') ,  ('as', 'drunk', 'topic', 'particularly', 'debris', 'welfare', 'acknowledge', NULL, 'following', 'dawn', 'reward', 'subject', 'almost', 'fitness', 'revolutionary', 'swear', 'that', 'schedule', 'parade') ,  ('incorporate', 'reinforce', 'basically', 'shower', 'two', 'month', 'luck', NULL, 'dozen', 'cloth', 'prevent', 'grandchild', 'cultural', 'bull', 'available', 'with', 'adopt', 'wave', 'addition') ,  ('spending', 'evolve', 'critic', 'sigh', 'big', 'compelling', 'rental', NULL, 'finance', 'arrow', 'trust', 'bicycle', 'embrace', 'photo', 'few', 'anyway', 'basketball', 'here', 'indian') ,  ('triumph', 'ourselves', 'activity', 'kid', 'medication', 'dismiss', 'quote', NULL, 'sauce', 'specifically', 'committee', 'ruling', 'attend', 'survivor', 'stick', 'quote', 'medium', 'provided', 'discuss') ,  ('interval', 'unemployment', 'association', 'qualify', 'soul', 'hair', 'school', NULL, 'rim', 'shove', 'tank', 'controversial', 'rose', 'worldwide', 'decline', 'work', 'residence', 'reporter', 'gray') ,  ('dilemma', 'instruct', 'improvement', 'profit', 'bit', 'custody', 'assign', NULL, 'warm', 'join', 'experimental', 'metal', 'sign', 'quarterback', 'drop', 'kingdom', 'common', 'businessman', 'mysterious') ,  ('european', 'cable', 'organization', 'oh', 'chicken', 'access', 'workout', NULL, 'unity', 'vocal', 'request', 'nose', 'unusual', 'drunk', 'corporate', 'aim', 'adjustment', 'operation', 'digital') ,  ('sex', 'theology', 'ridge', 'rent', 'fear', 'waist', 'tendency', NULL, 'application', 'trigger', 'programming', 'ultimately', 'lightly', 'depending', 'god', 'nerve', 'identification', 'wake', 'whether') ,  ('tent', 'process', 'awake', 'ordinary', 'usual', 'thumb', 'rubber', NULL, 'apple', 'group', 'seize', 'elect', 'highlight', 'inevitably', 'universe', 'survey', 'proclaim', 'magnetic', 'preference') ,  ('envelope', 'vacation', 'icon', 'elevator', 'risk', 'altogether', 'trade', NULL, 'walking', 'spine', 'serving', 'sand', 'convert', 'target', 'normally', 'source', 'smoke', 'succeed', 'application') ,  ('dignity', 'feminist', 'bonus', 'cloud', 'promise', 'injury', 'show', NULL, 'seller', 'joint', 'architecture', 'determination', 'diagnose', 'girl', 'sea', 'and/or', 'shopping', 'occasion', 'least') ,  ('suffering', 'agriculture', 'deck', 'away', 'burning', 'artist', 'english', NULL, 'safety', 'relate', 'cope', 'have', 'painful', 'text', 'borrow', 'campaign', 'superior', 'likelihood', 'straighten') ,  ('afterward', 'cast', 'whoever', 'organic', 'brake', 'analyst', 'remain', NULL, 'spectrum', 'them', 'one', 'diversity', 'soar', 'hostile', 'sovereignty', 'limited', 'exit', 'when', 'apple') ,  ('onion', 'skull', 'extent', 'belly', 'employee', 'likewise', 'hopefully', NULL, 'passenger', 'jeans', 'essentially', 'bold', 'corn', 'opportunity', 'last', 'strange', 'wonder', 'quest', 'revolutionary') ,  ('closed', 'contact', 'decline', 'finish', 'arrange', 'alcohol', 'plus', NULL, 'ecological', 'bubble', 'blessing', 'lose', 'magic', 'spiritual', 'evolution', 'library', 'fortunately', 'appropriate', 'marble') ,  ('being', 'midst', 'wherever', 'concept', 'gifted', 'elect', 'horizon', NULL, 'drink', 'guarantee', 'medication', 'variation', 'significantly', 'clay', 'reflect', 'producer', 'bunch', 'proper', 'array') ,  ('lucky', 'flower', 'unite', 'passing', 'initially', 'mrs', 'distinct', NULL, 'heaven', 'too', 'sweep', 'diagnose', 'instructor', 'solve', 'uncomfortable', 'acceptance', 'teammate', 'cope', 'town') ,  ('mr', 'impress', 'meet', 'informal', 'garage', 'democratic', 'adviser', NULL, 'childhood', 'conversion', 'jurisdiction', 'marriage', 'vote', 'cease', 'rebuild', 'extreme', 'regarding', 'shame', 'dessert') ,  ('abortion', 'starter', 'endless', 'new', 'accompany', 'league', 'agent', NULL, 'hair', 'repeatedly', 'president', 'engage', 'harvest', 'baseball', 'balanced', 'african-american', 'routine', 'slave', 'apple') ,  ('punch', 'dish', 'slight', 'pilot', 'domestic', 'nearly', 'talented', NULL, 'curtain', 'chase', 'reach', 'also', 'membership', 'concentrate', 'core', 'mount', 'homeless', 'adopt', 'sink') ,  ('cup', 'constant', 'deny', 'prove', 'economist', 'sick', 'chunk', NULL, 'venture', 'latter', 'economic', 'software', 'life', 'ha', 'due', 'pure', 'rest', 'preparation', 'phone') ,  ('burden', 'away', 'mortgage', 'color', 'booth', 'number', 'reputation', NULL, 'source', 'good', 'frequent', 'missile', 'touchdown', 'custom', 'monument', 'feed', 'nose', 'decide', 'retail') ,  ('hence', 'net', 'plunge', 'come', 'unless', 'sector', 'remove', NULL, 'ignore', 'balance', 'extensive', 'help', 'laboratory', 'rehabilitation', 'adolescent', 'colonial', 'cab', 'surely', 'glad') ,  ('figure', 'verdict', 'textbook', 'rose', 'historically', 'occasional', 'productivity', NULL, 'must', 'eight', 'road', 'lap', 'myself', 'logic', 'consistently', 'scan', 'specialize', 'yes', 'widow') ,  ('away', 'exhibition', 'specialist', 'behavioral', 'stranger', 'necessarily', 'neck', NULL, 'grief', 'historical', 'bike', 'colonial', 'assign', 'guitar', 'backyard', 'cold', 'float', 'leader', 'nasty') ,  ('tube', 'knowledge', 'instruction', 'decade', 'preserve', 'release', 'fiction', NULL, 'silly', 'coup', 'examination', 'ambition', 'ask', 'eighth', 'consensus', 'counseling', 'against', 'cabinet', 'colonial') ,  ('freedom', 'conscience', 'voter', 'given', 'mechanical', 'particularly', 'meaning', NULL, 'colleague', 'facilitate', 'sexy', 'declare', 'colonial', 'formation', 'interested', 'pit', 'gentleman', 'resident', 'closely') ,  ('wooden', 'lighting', 'carpet', 'liberty', 'proportion', 'teen', 'virus', NULL, 'unite', 'question', 'feel', 'chill', 'listener', 'history', 'board', 'promising', 'link', 'electronics', 'number') ,  ('mad', 'versus', 'articulate', 'govern', 'rib', 'recognize', 'quote', NULL, 'ear', 'destruction', 'profit', 'burning', 'pour', 'segment', 'attorney', 'site', 'fade', 'furthermore', 'year') ,  ('enemy', 'bar', 'landscape', 'diabetes', 'introduction', 'orange', 'cut', NULL, 'closet', 'task', 'reply', 'man', 'ring', 'invest', 'mouse', 'glimpse', 'visit', 'yellow', 'easy') ,  ('ms', 'exploration', 'educational', 'special', 'ultimately', 'hair', 'hole', NULL, 'grasp', 'positive', 'crystal', 'leather', 'integrate', 'instructor', 'issue', 'impress', 'output', 'aluminum', 'here') ,  ('manage', 'hispanic', 'fantasy', 'inspiration', 'example', 'kingdom', 'volunteer', NULL, 'disabled', 'wood', 'implication', 'norm', 'steadily', 'format', 'throw', 'philosophical', 'already', 'absolute', 'organization') ,  ('impression', 'rough', 'sauce', 'inspiration', 'medical', 'explosion', 'script', NULL, 'temperature', 'try', 'perfectly', 'farmer', 'necessary', 'revenue', 'counterpart', 'department', 'snow', 'on', 'thinking') ,  ('resemble', 'white', 'occur', 'beauty', 'brief', 'another', 'tale', NULL, 'overcome', 'intimate', 'powder', 'disagree', 'elsewhere', 'metaphor', 'boom', 'cry', 'area', 'finding', 'proof') ,  ('gain', 'shirt', 'witness', 'surprisingly', 'actor', 'exhibit', 'legally', NULL, 'aware', 'tired', 'enemy', 'percentage', 'island', 'throw', 'tail', 'body', 'story', 'joint', 'specifically') ,  ('atop', 'intense', 'weaken', 'investor', 'unfold', 'loyal', 'admission', NULL, 'economy', 'beast', 'stomach', 'fog', 'given', 'only', 'southeast', 'museum', 'cooking', 'recommend', 'photograph') ,  ('kid', 'crack', 'angry', 'theology', 'ranch', 'better', 'we', NULL, 'essence', 'occasional', 'requirement', 'global', 'spot', 'fourth', 'exclusively', 'abuse', 'entitle', 'latter', 'continued') ,  ('illustrate', 'teenager', 'imply', 'reflect', 'commodity', 'favorable', 'murder', NULL, 'wine', 'fresh', 'vary', 'unlikely', 'troop', 'news', 'decline', 'forget', 'grace', 'near', 'attack');
       
      INSERT INTO t1 VALUES  ('lost', 'laugh', 'colonial', 'satisfaction', 'impulse', 'diabetes', 'noise', NULL, 'deeply', 'hit', 'colorful', 'magnitude', 'town', 'architecture', 'course', 'japanese', 'venture', 'totally', 'lobby') ,  ('believe', 'disclose', 'recognition', 'automobile', 'cousin', 'necessity', 'thrive', NULL, 'quarter', 'altogether', 'strongly', 'enter', 'honey', 'board', 'remarkable', 'hole', 'armed', 'punch', 'debut') ,  ('sky', 'gas', 'mind', 'target', 'ally', 'greek', 'mind', NULL, 'rid', 'own', 'effect', 'ourselves', 'acquisition', 'ban', 'lover', 'mail', 'upset', 'formal', 'solar') ,  ('behalf', 'territory', 'ecological', 'selected', 'modify', 'pretend', 'senator', NULL, 'hearing', 'desert', 'poetry', 'significance', 'engage', 'largely', 'tighten', 'famous', 'appearance', 'fresh', 'explanation') ,  ('interrupt', 'magnetic', 'preach', 'art', 'memory', 'romantic', 'quarter', NULL, 'activist', 'dress', 'seat', 'magazine', 'bitter', 'person', 'french', 'harm', 'maker', 'invite', 'swim') ,  ('resign', 'alter', 'breakfast', 'thick', 'deal', 'adventure', 'sprinkle', NULL, 'technician', 'skin', 'university', 'lake', 'everywhere', 'site', 'conduct', 'frontier', 'interview', 'tiny', 'leave') ,  ('regard', 'late', 'tune', 'onto', 'assess', 'workshop', 'positive', NULL, 'commitment', 'currency', 'clue', 'conflict', 'motive', 'exercise', 'distinguish', 'bad', 'rate', 'retreat', 'suggest') ,  ('individual', 'minimal', 'shore', 'painful', 'prevention', 'towel', 'average', NULL, 'wing', 'comprise', 'walk', 'shelter', 'stem', 'reverse', 'forget', 'record', 'refuse', 'confrontation', 'patent') ,  ('aesthetic', 'bind', 'exam', 'stove', 'substantial', 'appear', 'significant', NULL, 'legally', 'curiosity', 'technology', 'demographic', 'confident', 'discourse', 'bombing', 'advise', 'income', 'retain', 'account') ,  ('ingredient', 'stare', 'gasoline', 'discuss', 'bucket', 'hero', 'fate', NULL, 'negative', 'cure', 'bathroom', 'enhance', 'equal', 'surprise', 'out', 'improvement', 'amendment', 'violation', 'furniture') ,  ('found', 'instructor', 'display', 'preliminary', 'year', 'segment', 'front', NULL, 'intention', 'rhetoric', 'initiative', 'producer', 'in', 'essence', 'overcome', 'behavioral', 'concept', 'bush', 'presidency') ,  ('slope', 'bee', 'cooperate', 'dust', 'tonight', 'access', 'tribe', NULL, 'nightmare', 'pc', 'lightning', 'vendor', 'resist', 'regulator', 'presumably', 'reverse', 'himself', 'bit', 'imply') ,  ('ask', 'scandal', 'highway', 'treatment', 'century', 'ownership', 'help', NULL, 'strength', 'example', 'cooperative', 'sex', 'condition', 'recording', 'most', 'approximately', 'metropolitan', 'wheelchair', 'young') ,  ('particle', 'receive', 'relax', 'hostile', 'change', 'structural', 'aunt', NULL, 'skirt', 'imagination', 'wave', 'minimal', 'final', 'clearly', 'alive', 'deadline', 'carpet', 'peace', 'informal') ,  ('dump', 'mixed', 'roll', 'guide', 'drum', 'impulse', 'paper', NULL, 'conservative', 'whenever', 'nor', 'take', 'forth', 'reply', 'why', 'contrast', 'input', 'tired', 'attract') ,  ('acquisition', 'isolated', 'disappear', 'lower', 'characteristic', 'understand', 'shadow', NULL, 'desire', 'brand', 'approximately', 'ambassador', 'mom', 'snake', 'main', 'curtain', 'average', 'thereby', 'coming') ,  ('forward', 'rhetoric', 'banker', 'extended', 'build', 'vehicle', 'correct', NULL, 'diversity', 'bias', 'lose', 'loyalty', 'simultaneously', 'forbid', 'deep', 'mission', 'climb', 'uniform', 'football') ,  ('gentleman', 'bag', 'advertising', 'male', 'producer', 'increasingly', 'constant', NULL, 'inspection', 'bring', 'trigger', 'somehow', 'abuse', 'fur', 'yet', 'such', 'anniversary', 'slavery', 'because') ,  ('thigh', 'exclusively', 'count', 'scientist', 'express', 'surround', 'borrow', NULL, 'swing', 'set', 'lens', 'plastic', 'number', 'stomach', 'oppose', 'innovation', 'allow', 'fist', 'block') ,  ('homeless', 'capability', 'voting', 'measurement', 'idea', 'determine', 'accountability', NULL, 'tomorrow', 'effective', 'corruption', 'unite', 'mutual', 'independent', 'monster', 'sit', 'ticket', 'hallway', 'lawmaker') ,  ('starter', 'examine', 'unlike', 'jaw', 'university', 'mean', 'refuge', NULL, 'exactly', 'chef', 'strain', 'attitude', 'confess', 'device', 'jaw', 'core', 'technician', 'moreover', 'user') ,  ('upset', 'division', 'ritual', 'airplane', 'cite', 'economically', 'sweet', NULL, 'health-care', 'prevail', 'flip', 'knock', 'isolation', 'diplomatic', 'woman', 'toxic', 'delay', 'poll', 'risk') ,  ('elect', 'planning', 'like', 'her', 'measure', 'cheat', 'cover', NULL, 'evidence', 'sleeve', 'inevitably', 'security', 'lake', 'afraid', 'lid', 'most', 'indigenous', 'subject', 'accomplish') ,  ('compensation', 'pot', 'stone', 'user', 'bench', 'formation', 'here', NULL, 'chemical', 'frontier', 'believe', 'asleep', 'mechanic', 'client', 'four', 'rebel', 'statue', 'inner', 'emission') ,  ('inspector', 'contend', 'ordinary', 'probably', 'report', 'project', 'secret', NULL, 'civilian', 'guy', 'lawn', 'highlight', 'regain', 'minute', 'nutrient', 'tea', 'bicycle', 'devil', 'supporter') ,  ('italian', 'combined', 'devil', 'pork', 'wheat', 'beard', 'hide', NULL, 'substantial', 'african-american', 'institution', 'shall', 'belong', 'considerable', 'tip', 'legacy', 'command', 'economist', 'universe') ,  ('territory', 'art', 'structure', 'brown', 'accommodate', 'rice', 'fair', NULL, 'hazard', 'glad', 'nation', 'full-time', 'otherwise', 'character', 'short-term', 'define', 'technician', 'hungry', 'champion') ,  ('sleeve', 'rabbit', 'physics', 'delicate', 'elite', 'onto', 'educate', NULL, 'overnight', 'flour', 'senate', 'square', 'portray', 'congressional', 'rather', 'stem', 'submit', 'swim', 'slow') ,  ('piano', 'earth', 'monitor', 'modern', 'official', 'athlete', 'energy', NULL, 'widespread', 'airplane', 'hot', 'furniture', 'worry', 'magazine', 'famous', 'voice', 'overcome', 'texture', 'closer') ,  ('muslim', 'amazing', 'plead', 'guilty', 'king', 'sweat', 'hold', NULL, 'standing', 'beg', 'handsome', 'standard', 'defense', 'from', 'secretary', 'reject', 'competitive', 'alone', 'participant') ,  ('stimulate', 'instead', 'paint', 'painter', 'strong', 'duck', 'community', NULL, 'lamp', 'breath', 'jungle', 'entire', 'his', 'prayer', 'homeless', 'phase', 'moment', 'threaten', 'informal') ,  ('ceiling', 'obstacle', 'evidence', 'enroll', 'arrangement', 'picture', 'convention', NULL, 'one', 'extension', 'back', 'expedition', 'implement', 'rise', 'duck', 'franchise', 'agricultural', 'wire', 'almost') ,  ('characteristic', 'alike', 'perspective', 'boy', 'soon', 'deny', 'trading', NULL, 'medication', 'district', 'tolerate', 'fat', 'convenience', 'forth', 'bold', 'aircraft', 'check', 'investigation', 'big') ,  ('sum', 'blind', 'classify', 'state', 'appointment', 'evolve', 'iraqi', NULL, 'typical', 'settlement', 'day', 'stair', 'clip', 'jet', 'patient', 'slip', 'ensure', 'anybody', 'question') ,  ('amid', 'shrug', 'more', 'soon', 'asleep', 'eight', 'installation', NULL, 'latter', 'athletic', 'bias', 'isolated', 'presence', 'south', 'analyst', 'flat', 'super', 'church', 'glad') ,  ('remaining', 'it', 'dispute', 'ancient', 'chop', 'ceremony', 'joke', NULL, 'bend', 'satisfy', 'armed', 'glimpse', 'trip', 'hang', 'rip', 'passion', 'various', 'missing', 'proceed') ,  ('eyebrow', 'elementary', 'on', 'we', 'hint', 'rival', 'justify', NULL, 'literary', 'inmate', 'attractive', 'melt', 'actively', 'consequently', 'describe', 'proposed', 'horse', 'upper', 'county') ,  ('take', 'nutrient', 'study', 'depending', 'shrug', 'news', 'uncle', NULL, 'collect', 'wrong', 'light', 'reader', 'precious', 'healthy', 'starter', 'rehabilitation', 'strain', 'severe', 'transport') ,  ('flight', 'wife', 'depth', 'spoon', 'emphasize', 'added', 'full-time', NULL, 'role', 'bad', 'sound', 'thin', 'abortion', 'label', 'wagon', 'acknowledge', 'legal', 'constitution', 'start') ,  ('degree', 'reportedly', 'virtue', 'attach', 'spot', 'illegal', 'entire', NULL, 'station', 'next', 'status', 'earnings', 'inevitably', 'ownership', 'represent', 'establish', 'what', 'officer', 'specifically') ,  ('holy', 'transformation', 'peanut', 'third', 'pride', 'chop', 'seminar', NULL, 'athlete', 'confusion', 'afford', 'fair', 'breeze', 'chunk', 'examine', 'analysis', 'artistic', 'greet', 'taste') ,  ('engagement', 'how', 'legitimate', 'mutual', 'naked', 'emotion', 'overall', NULL, 'clothes', 'according', 'watch', 'compromise', 'response', 'yesterday', 'sentence', 'section', 'governor', 'discrimination', 'motivation') ,  ('muslim', 'legally', 'horizon', 'hunter', 'vision', 'line', 'formerly', NULL, 'margin', 'better', 'seal', 'block', 'aluminum', 'pit', 'nation', 'estate', 'error', 'federal', 'past') ,  ('random', 'stream', 'time', 'idea', 'helpful', 'surprisingly', 'liver', NULL, 'foot', 'athlete', 'theme', 'equivalent', 'notice', 'closer', 'session', 'rise', 'ambition', 'citizenship', 'admire') ,  ('deep', 'either', 'precisely', 'christianity', 'human', 'suspect', 'discover', NULL, 'border', 'tell', 'library', 'defensive', 'statistics', 'tongue', 'deem', 'palm', 'carefully', 'screening', 'flood') ,  ('cheese', 'certain', 'written', 'steal', 'factor', 'independence', 'base', NULL, 'day', 'dominate', 'prisoner', 'this', 'ambassador', 'alternative', 'over', 'radical', 'option', 'korean', 'recovery') ,  ('holiday', 'on', 'concert', 'rod', 'legal', 'like', 'sue', NULL, 'reportedly', 'demonstration', 'till', 'link', 'lower', 'domestic', 'guest', 'gradually', 'row', 'elephant', 'likely') ,  ('pursue', 'manufacturer', 'amount', 'fashion', 'fun', 'apparent', 'chinese', NULL, 'lawyer', 'landing', 'yourself', 'sell', 'endure', 'seller', 'steer', 'whale', 'panel', 'soar', 'hi') ,  ('impulse', 'bench', 'slap', 'above', 'haul', 'abortion', 'draft', NULL, 'allow', 'accurate', 'leader', 'instantly', 'missile', 'considerable', 'chair', 'credit', 'possible', 'demographic', 'mass') ,  ('hostile', 'defense', 'sheer', 'about', 'magic', 'financial', 'marker', NULL, 'literally', 'selection', 'humor', 'up', 'shrink', 'barn', 'register', 'fatigue', 'tower', 'row', 'cultural');
       
      INSERT INTO t1 VALUES  ('festival', 'each', 'volunteer', 'signature', 'command', 'domain', 'punch', NULL, 'plead', 'desperate', 'tile', 'withdraw', 'proclaim', 'lucky', 'west', 'naturally', 'arm', 'boil', 'drown') ,  ('maybe', 'band', 'career', 'bite', 'availability', 'real', 'center', NULL, 'trail', 'potato', 'staff', 'certainly', 'period', 'equivalent', 'earth', 'disclose', 'refuge', 'file', 'someday') ,  ('focus', 'parking', 'devote', 'request', 'demonstrate', 'standing', 'creative', NULL, 'deliver', 'contributor', 'freely', 'domain', 'steal', 'justify', 'telephone', 'pen', 'instruction', 'garage', 'commissioner') ,  ('casual', 'song', 'technology', 'bitter', 'judge', 'percentage', 'experienced', NULL, 'average', 'donation', 'terribly', 'commodity', 'damn', 'license', 'future', 'score', 'constantly', 'intelligence', 'twentieth') ,  ('required', 'distinguish', 'risk', 'collection', 'stage', 'territory', 'scope', NULL, 'enroll', 'boring', 'rat', 'winner', 'trip', 'used', 'naturally', 'powerful', 'above', 'perhaps', 'originally') ,  ('general', 'elevator', 'surely', 'industry', 'you', 'unlikely', 'conceive', NULL, 'suspend', 'expedition', 'incident', 'schedule', 'tap', 'perception', 'turkey', 'perform', 'skirt', 'apparently', 'win') ,  ('rock', 'added', 'presumably', 'politics', 'jacket', 'emergency', 'slip', NULL, 'season', 'health', 'notice', 'true', 'divine', 'reservation', 'speaker', 'celebration', 'mineral', 'donate', 'right') ,  ('hell', 'afternoon', 'consider', 'external', 'wrong', 'corner', 'season', NULL, 'correlation', 'widow', 'succeed', 'genetic', 'assistance', 'sorry', 'poverty', 'those', 'ten', 'depend', 'source') ,  ('sake', 'logic', 'math', 'likelihood', 'engage', 'annual', 'republican', NULL, 'bid', 'substantial', 'competitive', 'protect', 'officially', 'instructional', 'incredibly', 'afterward', 'freedom', 'marker', 'twice') ,  ('drawer', 'opposite', 'ease', 'convenience', 'self', 'guest', 'roof', NULL, 'literary', 'have', 'organ', 'craft', 'diabetes', 'area', 'army', 'dismiss', 'unite', 'african-american', 'border') ,  ('excessive', 'balance', 'fact', 'director', 'worldwide', 'researcher', 'spin', NULL, 'artistic', 'blessing', 'discourse', 'on', 'cute', 'ten', 'eye', 'calculate', 'violation', 'feature', 'file') ,  ('gasoline', 'sleep', 'hurricane', 'sandwich', 'president', 'advocate', 'lobby', NULL, 'careful', 'foot', 'cabin', 'factor', 'etc', 'shareholder', 'gross', 'bullet', 'lighting', 'mechanic', 'delay') ,  ('architect', 'cooperative', 'hallway', 'inevitably', 'weather', 'sexy', 'pitch', NULL, 'solar', 'range', 'parking', 'manager', 'buddy', 'quiet', 'standard', 'urban', 'planet', 'cost', 'morning') ,  ('tooth', 'complain', 'capital', 'football', 'major', 'draw', 'era', NULL, 'constraint', 'recall', 'frozen', 'dose', 'log', 'ought', 'truth', 'ceremony', 'he', 'auto', 'content') ,  ('straight', 'parade', 'vs', 'pay', 'place', 'never', 'observe', NULL, 'into', 'effort', 'toss', 'unless', 'architecture', 'launch', 'democratic', 'career', 'closer', 'suicide', 'tale') ,  ('assessment', 'horror', 'entertainment', 'monkey', 'including', 'pleasure', 'equip', NULL, 'trait', 'democrat', 'soap', 'traveler', 'complicated', 'accuse', 'signal', 'however', 'garage', 'title', 'predict') ,  ('condemn', 'her', 'uh', 'aids', 'visitor', 'resolve', 'hand', NULL, 'sink', 'date', 'melt', 'kneel', 'jury', 'sexually', 'drunk', 'graduation', 'speed', 'acceptable', 'revolutionary') ,  ('strictly', 'entity', 'bag', 'wisdom', 'settlement', 'pride', 'mandate', NULL, 'factory', 'say', 'predict', 'fill', 'technician', 'managing', 'library', 'variety', 'ship', 'accusation', 'sit') ,  ('secretary', 'skilled', 'slice', 'unemployment', 'universal', 'sofa', 'ten', NULL, 'the', 'rest', 'variable', 'question', 'click', 'easily', 'suggestion', 'integrated', 'big', 'uniform', 'measurement') ,  ('behavioral', 'book', 'review', 'protest', 'ethnic', 'fair', 'potentially', NULL, 'light', 'conventional', 'concentration', 'hunt', 'trail', 'everybody', 'transfer', 'declare', 'as', 'contemporary', 'disappear') ,  ('hope', 'uniform', 'page', 'cheek', 'admire', 'dog', 'prescription', NULL, 'summer', 'son', 'date', 'airplane', 'source', 'saving', 'response', 'digital', 'sunny', 'private', 'darkness') ,  ('heal', 'hockey', 'safe', 'counterpart', 'soil', 'flow', 'elderly', NULL, 'narrative', 'away', 'marketplace', 'lab', 'bay', 'change', 'swing', 'disappointment', 'deposit', 'minimize', 'attractive') ,  ('count', 'late', 'indeed', 'plenty', 'peanut', 'solution', 'equality', NULL, 'greatly', 'undermine', 'headache', 'defeat', 'independence', 'above', 'fiscal', 'college', 'absence', 'notion', 'cycle') ,  ('play', 'stair', 'stream', 'rehabilitation', 'changing', 'partial', 'continue', NULL, 'tunnel', 'product', 'known', 'container', 'intimate', 'candy', 'consecutive', 'operating', 'digital', 'participation', 'surrounding') ,  ('circle', 'crucial', 'turn', 'perfectly', 'emerging', 'rarely', 'clinical', NULL, 'sacred', 'auction', 'hostage', 'video', 'anywhere', 'text', 'large', 'strictly', 'event', 'allow', 'governor') ,  ('open', 'ok', 'known', 'wow', 'enter', 'bureau', 'tray', NULL, 'weave', 'user', 'integrated', 'atmosphere', 'process', 'influence', 'cooperation', 'relevant', 'among', 'product', 'harm') ,  ('deer', 'individual', 'vanish', 'distribution', 'elevator', 'tall', 'adolescent', NULL, 'remark', 'funding', 'herb', 'method', 'transform', 'angry', 'hot', 'fiber', 'contractor', 'agent', 'enormous') ,  ('ancient', 'pose', 'bunch', 'owe', 'northeast', 'everyone', 'remove', NULL, 'liberal', 'lung', 'wooden', 'purchase', 'beach', 'electricity', 'previously', 'network', 'transformation', 'russian', 'resolution') ,  ('arm', 'since', 'substantial', 'protein', 'president', 'trauma', 'sense', NULL, 'yourself', 'pole', 'subject', 'expectation', 'snake', 'son', 'five', 'feeling', 'alive', 'exciting', 'over') ,  ('separate', 'slightly', 'intervention', 'politician', 'bread', 'appear', 'assign', NULL, 'bombing', 'her', 'consecutive', 'responsible', 'united', 'golden', 'seriously', 'yell', 'patch', 'racism', 'breathing') ,  ('refrigerator', 'gold', 'tough', 'mixed', 'defense', 'physical', 'hell', NULL, 'execute', 'loop', 'exciting', 'dramatically', 'chapter', 'immigrant', 'weekend', 'steep', 'isolated', 'expand', 'stare') ,  ('pile', 'receiver', 'opera', 'planet', 'similarly', 'sacrifice', 'military', NULL, 'poverty', 'breakfast', 'connect', 'cargo', 'quality', 'basketball', 'spine', 'clear', 'pickup', 'survive', 'highlight') ,  ('poster', 'moreover', 'somebody', 'according', 'elementary', 'importantly', 'mainly', NULL, 'zone', 'tuck', 'scheme', 'pickup', 'collapse', 'channel', 'dawn', 'encounter', 'progressive', 'branch', 'justice') ,  ('broker', 'either', 'loyalty', 'shoulder', 'radar', 'grass', 'find', NULL, 'idea', 'uncle', 'conservative', 'service', 'atmosphere', 'chef', 'forth', 'asian', 'spell', 'conclusion', 'reality') ,  ('rib', 'alcohol', 'time', 'concerned', 'price', 'advise', 'ordinary', NULL, 'knock', 'continued', 'guess', 'activist', 'especially', 'investigator', 'elevator', 'consist', 'rebel', 'discussion', 'strict') ,  ('in', 'danger', 'tightly', 'spending', 'back', 'pleasant', 'center', NULL, 'publisher', 'grandchild', 'blast', 'hello', 'broadcast', 'sidewalk', 'willingness', 'balance', 'enterprise', 'accessible', 'come') ,  ('diagnose', 'anger', 'fool', 'cotton', 'current', 'possess', 'mirror', NULL, 'dog', 'flying', 'tunnel', 'neat', 'premium', 'genuine', 'endorse', 'drink', 'food', 'curriculum', 'mentor') ,  ('historically', 'medication', 'fundamental', 'public', 'difficulty', 'keep', 'winter', NULL, 'regime', 'extreme', 'him', 'participate', 'nearby', 'stiff', 'eat', 'heat', 'nut', 'inner', 'assembly') ,  ('lawn', 'involve', 'teaspoon', 'american', 'producer', 'steam', 'cheek', NULL, 'defeat', 'legislator', 'lung', 'contact', 'foot', 'list', 'progressive', 'praise', 'regarding', 'shallow', 'yell') ,  ('lawyer', 'distribute', 'maker', 'black', 'blink', 'must', 'stability', NULL, 'bike', 'announce', 'thought', 'pension', 'activist', 'pine', 'salad', 'pink', 'actually', 'they', 'edge') ,  ('examine', 'through', 'elementary', 'alcohol', 'discount', 'forgive', 'active', NULL, 'associate', 'record', 'shelf', 'root', 'devote', 'horrible', 'booth', 'limitation', 'enroll', 'dumb', 'precisely') ,  ('odd', 'closer', 'belly', 'temporary', 'item', 'real', 'tool', NULL, 'ass', 'deficit', 'both', 'unfold', 'subject', 'hill', 'galaxy', 'speed', 'medication', 'disaster', 'differently') ,  ('interior', 'statistical', 'deck', 'wind', 'promotion', 'whatever', 'installation', NULL, 'willing', 'trunk', 'unless', 'faculty', 'european', 'devote', 'bulk', 'economist', 'normal', 'plunge', 'object') ,  ('seek', 'recession', 'night', 'comparison', 'beneath', 'sell', 'defender', NULL, 'entirely', 'one', 'abandon', 'darkness', 'tall', 'experiment', 'headache', 'ensure', 'analyze', 'her', 'republic') ,  ('fare', 'poke', 'symptom', 'workout', 'burning', 'prescription', 'counterpart', NULL, 'consultant', 'maximum', 'lifetime', 'president', 'start', 'array', 'developer', 'violence', 'regularly', 'sector', 'absolutely') ,  ('license', 'explicit', 'produce', 'sovereignty', 'adult', 'knock', 'compound', NULL, 'finally', 'foreign', 'reality', 'spill', 'vulnerable', 'village', 'cute', 'set', 'attractive', 'habit', 'diplomatic') ,  ('jeans', 'customer', 'compare', 'lean', 'conduct', 'lucky', 'bench', NULL, 'weakness', 'morning', 'customer', 'lamp', 'resource', 'quote', 'busy', 'gas', 'valid', 'chew', 'rare') ,  ('site', 'pour', 'professor', 'raise', 'alley', 'march', 'fade', NULL, 'installation', 'march', 'sensitive', 'pull', 'reportedly', 'charter', 'reading', 'budget', 'creativity', 'novel', 'green') ,  ('distinctive', 'other', 'clip', 'await', 'mystery', 'morning', 'merchant', NULL, 'purchase', 'frequent', 'closest', 'across', 'silk', 'playoff', 'him', 'programming', 'surgery', 'ever', 'lawsuit') ,  ('comprise', 'conversion', 'scale', 'silk', 'loyal', 'incredible', 'confront', NULL, 'sense', 'wagon', 'deeply', 'lane', 'damn', 'doubt', 'criticism', 'protocol', 'concrete', 'corporation', 'hell');
       
      INSERT INTO t1 VALUES  ('four', 'civil', 'whether', 'grandchild', 'weigh', 'indicate', 'concern', NULL, 'identify', 'independent', 'ten', 'radiation', 'estate', 'banker', 'expect', 'any', 'text', 'name', 'tablespoon') ,  ('chance', 'survive', 'character', 'bid', 'athlete', 'hunt', 'mm-hmm', NULL, 'isolated', 'predict', 'like', 'thoroughly', 'breathe', 'crazy', 'mask', 'quickly', 'somewhere', 'below', 'employment') ,  ('anonymous', 'pregnancy', 'complaint', 'sir', 'intent', 'absence', 'proportion', NULL, 'boss', 'news', 'hockey', 'wooden', 'bag', 'admit', 'besides', 'talent', 'account', 'which', 'lucky') ,  ('age', 'distinguish', 'desert', 'nearby', 'exercise', 'add', 'disappointed', NULL, 'impression', 'necessary', 'talented', 'one', 'ultimately', 'intellectual', 'hip', 'quite', 'grandmother', 'lay', 'career') ,  ('accessible', 'lifetime', 'administrative', 'tremendous', 'thinking', 'lab', 'protein', NULL, 'occasionally', 'swear', 'verdict', 'mechanic', 'relax', 'today', 'if', 'driveway', 'softly', 'counsel', 'sculpture') ,  ('observe', 'pass', 'uncle', 'humanity', 'art', 'icon', 'behave', NULL, 'difficult', 'identity', 'confident', 'fruit', 'flag', 'pause', 'pat', 'frame', 'respect', 'poke', 'supply') ,  ('suffering', 'principal', 'sales', 'leader', 'circumstance', 'into', 'administrator', NULL, 'series', 'evolve', 'advance', 'partial', 'slam', 'deck', 'weave', 'minute', 'thereby', 'dictate', 'privately') ,  ('instant', 'bold', 'oak', 'expose', 'surely', 'pickup', 'serve', NULL, 'rank', 'somehow', 'flying', 'social', 'procedure', 'coat', 'establishment', 'suite', 'simple', 'politician', 'distinct') ,  ('lane', 'await', 'disk', 'involvement', 'door', 'gather', 'minister', NULL, 'ceiling', 'theological', 'garlic', 'wave', 'missing', 'signature', 'decline', 'kick', 'self-esteem', 'aircraft', 'quest') ,  ('await', 'dangerous', 'cruel', 'arrow', 'send', 'evaluation', 'position', NULL, 'satellite', 'fresh', 'publication', 'sufficient', 'alleged', 'reveal', 'plunge', 'economically', 'battle', 'six', 'military') ,  ('donate', 'jurisdiction', 'within', 'involved', 'passing', 'hers', 'amid', NULL, 'adequate', 'manufacturing', 'indeed', 'stay', 'laser', 'rat', 'sin', 'test', 'young', 'dough', 'meanwhile') ,  ('half', 'halfway', 'domestic', 'wrap', 'regulator', 'guy', 'chain', NULL, 'comprehensive', 'walking', 'clerk', 'true', 'trim', 'surprising', 'constitutional', 'distinction', 'rather', 'coming', 'rib') ,  ('accounting', 'meat', 'leave', 'youth', 'confrontation', 'greatest', 'moment', NULL, 'undergo', 'seemingly', 'plenty', 'measure', 'forth', 'flexible', 'potential', 'machine', 'abroad', 'value', 'ship') ,  ('equipment', 'perspective', 'liberty', 'likewise', 'expand', 'politician', 'toss', NULL, 'organization', 'wheat', 'accountability', 'romance', 'suit', 'addition', 'phase', 'situation', 'group', 'normal', 'arm') ,  ('track', 'monument', 'defend', 'fight', 'ignore', 'counselor', 'carbon', NULL, 'encounter', 'better', 'sodium', 'guide', 'teenager', 'sprinkle', 'arise', 'member', 'alongside', 'glory', 'talk') ,  ('sacrifice', 'photography', 'possess', 'three', 'creativity', 'honey', 'so', NULL, 'necessity', 'ceremony', 'true', 'disease', 'cue', 'tone', 'administration', 'despite', 'buck', 'pitch', 'heaven') ,  ('speech', 'northeast', 'racism', 'estate', 'required', 'jeans', 'furniture', NULL, 'consistently', 'joy', 'consent', 'electronics', 'loss', 'reporter', 'hey', 'plane', 'terrorism', 'magic', 'prevail') ,  ('daughter', 'belong', 'specific', 'highway', 'creature', 'hunting', 'discrimination', NULL, 'limitation', 'silent', 'aware', 'export', 'elder', 'magic', 'civil', 'grin', 'account', 'dramatically', 'fourth') ,  ('anybody', 'sodium', 'stair', 'slot', 'agenda', 'copy', 'bias', NULL, 'sword', 'slide', 'steady', 'moment', 'yield', 'consciousness', 'rational', 'winner', 'circumstance', 'suggestion', 'alike') ,  ('religious', 'at', 'throw', 'period', 'theoretical', 'conduct', 'short-term', NULL, 'drink', 'sense', 'file', 'shortly', 'fate', 'chapter', 'you', 'gray', 'him', 'juror', 'activist') ,  ('above', 'player', 'also', 'appear', 'inspection', 'mechanic', 'reveal', NULL, 'substantially', 'outlet', 'surprise', 'distinguish', 'jazz', 'engage', 'council', 'our', 'formula', 'database', 'flexible') ,  ('god', 'phrase', 'softly', 'presidential', 'accurate', 'climb', 'spine', NULL, 'silly', 'common', 'alternative', 'engine', 'injure', 'debut', 'proposal', 'enormous', 'eleven', 'employ', 'scholar') ,  ('correspondent', 'dead', 'do', 're', 'require', 'somewhere', 'those', NULL, 'club', 'express', 'fair', 'danger', 'generally', 'minority', 'plane', 'art', 'hour', 'advance', 'emission') ,  ('defender', 'call', 'anyway', 'closest', 'premise', 'by', 'driving', NULL, 'loss', 'tag', 'wealth', 'output', 'shrug', 'builder', 'chance', 'retailer', 'collect', 'carve', 'punch') ,  ('portion', 'minister', 'primarily', 'alcohol', 'fame', 'detect', 'jew', NULL, 'prosecution', 'hunt', 'handle', 'avoid', 'reflect', 'everybody', 'rise', 'tune', 'large', 'dedicate', 'vision') ,  ('listener', 'bomb', 'signal', 'thereby', 'object', 'scholar', 'assign', NULL, 'traveler', 'temperature', 'scary', 'organization', 'attach', 'circuit', 'appreciation', 'typically', 'step', 'mild', 'grandfather') ,  ('donor', 'entitle', 'rural', 'emotion', 'indigenous', 'rely', 'cool', NULL, 'offering', 'new', 'weapon', 'choose', 'bow', 'artificial', 'with', 'textbook', 'outer', 'elegant', 'autonomy') ,  ('unknown', 'experience', 'availability', 'breeze', 'forgive', 'panel', 'less', NULL, 'essay', 'pure', 'popular', 'tourism', 'mount', 'conclude', 'scheme', 'partnership', 'nice', 'whatever', 'sensitivity') ,  ('documentary', 'gentleman', 'low', 'dense', 'return', 'more', 'initial', NULL, 'skilled', 'bay', 'huh', 'shape', 'lend', 'fewer', 'conclude', 'believe', 'hunting', 'salad', 'indigenous') ,  ('exotic', 'improvement', 'stare', 'lecture', 'intervention', 'disability', 'downtown', NULL, 'frown', 'safely', 'impress', 'item', 'critical', 'kit', 'common', 'cross', 'investment', 'triumph', 'juror') ,  ('mentally', 'inherent', 'sexy', 'miracle', 'convey', 'base', 'perfectly', NULL, 'conservative', 'fully', 'stability', 'specialty', 'inmate', 'obvious', 'commissioner', 'lead', 'excitement', 'mostly', 'ancestor') ,  ('stimulus', 'franchise', 'word', 'gasoline', 'recall', 'eliminate', 'famous', NULL, 'fund', 'democrat', 'through', 'become', 'scope', 'optimistic', 'tend', 'anybody', 'doll', 'strange', 'dancer') ,  ('sudden', 'instinct', 'ultimate'