[MDEV-18514]  Assertion `!writer.checksum_len || writer.remains == 0' failed Created: 2019-02-08  Updated: 2020-06-15  Resolved: 2020-01-10

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.2, 10.3, 10.4
Fix Version/s: 10.2.31, 10.3.22, 10.4.12

Type: Bug Priority: Minor
Reporter: Alice Sherepa Assignee: Sujatha Sivakumar (Inactive)
Resolution: Fixed Votes: 0
Labels: binlog_cache

Attachments: File 1.7z     File core.7z    
Issue Links:
Relates
relates to MDEV-11092 Assertion `!writer.checksum_len || wr... Closed

 Description   

10.4 e80bcd7f64fc8ff6f46c1f

2019-02-08  7:44:23 11 [Warning] mysqld: Disk is full writing './mysql-bin.000001' (Errcode: 28 "No space left on device"). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
2019-02-08  7:44:23 11 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
2019-02-08  7:54:23 11 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
2019-02-08  8:04:23 11 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
2019-02-08  8:14:23 11 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
mysqld: /git/10.4/sql/log.cc:7152: int MYSQL_BIN_LOG::write_cache(THD*, IO_CACHE*): Assertion `!writer.checksum_len || writer.remains == 0' failed.
 
stdlib/abort.c:91(__GI_abort)[0x7f4e5de4902a]
assert/assert.c:92(__assert_fail_base)[0x7f4e5de3fbd7]
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f4e5de3fc82]
sql/log.cc:7154(MYSQL_BIN_LOG::write_cache(THD*, st_io_cache*))[0x5595ec4f2b83]
sql/log.cc:8147(MYSQL_BIN_LOG::write_transaction_or_stmt(MYSQL_BIN_LOG::group_commit_entry*, unsigned long long))[0x5595ec4f84bd]
sql/log.cc:7903(MYSQL_BIN_LOG::trx_group_commit_leader(MYSQL_BIN_LOG::group_commit_entry*))[0x5595ec4f658e]
sql/log.cc:7700(MYSQL_BIN_LOG::write_transaction_to_binlog_events(MYSQL_BIN_LOG::group_commit_entry*))[0x5595ec4f533d]
sql/log.cc:7370(MYSQL_BIN_LOG::write_transaction_to_binlog(THD*, binlog_cache_mngr*, Log_event*, bool, bool, bool))[0x5595ec4f3b6f]
sql/log.cc:1785(binlog_flush_cache(THD*, binlog_cache_mngr*, Log_event*, bool, bool, bool))[0x5595ec4d5d62]
sql/log.cc:1837(binlog_commit_flush_stmt_cache(THD*, bool, binlog_cache_mngr*))[0x5595ec4d631e]
sql/log.cc:2109(binlog_rollback(handlerton*, THD*, bool))[0x5595ec4d7ad0]
sql/handler.cc:1850(ha_rollback_trans(THD*, bool))[0x5595ec24dd40]
sql/transaction.cc:573(trans_rollback_stmt(THD*))[0x5595ebe8d425]
sql/sql_parse.cc:6359(mysql_execute_command(THD*))[0x5595ebb1fdd8]
sql/sql_parse.cc:8120(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5595ebb2a014]
sql/sql_parse.cc:1808(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5595ebb02ca9]
sql/sql_parse.cc:1356(do_command(THD*))[0x5595ebaffe13]
sql/sql_connect.cc:1399(do_handle_one_connection(CONNECT*))[0x5595ebe5d950]
sql/sql_connect.cc:1303(handle_one_connection)[0x5595ebe5d31a]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f4e5ec886ba]
x86_64/clone.S:111(clone)[0x7f4e5df1941d]



 Comments   
Comment by Alice Sherepa [ 2019-12-24 ]

please run as

 ./mtr 1_my.test --mysqld=--log_bin --mysqld=--max_binlog_cache_size=64K --mysqld=--binlog_format='row'

--source include/have_innodb.inc
 
CREATE TABLE t1 (
  a char(64),
  b datetime,
  c char(64),
  d int,
  e enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  f set('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  h int,
  i enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  j set('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  k datetime,
  l set('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  m enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  n enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  o char(64),
  p int,
  pk int DEFAULT 0,
  q char(64),
  r enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  s int,
  t char(64),
  u set('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  v enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  w set('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  x int,
  y int,
  z enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  z1 int,
  z2 datetime,
  z3 char(64),
  z4 char(64),
  z5 int,
  z6 int,
  z7 int,
  z8 char(64),
  z9 char(64),
  z10 set('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  z11 set('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  z12 datetime,
  z13 datetime,
  z14 char(64),
  z15 char(64),
  z16 set('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  z17 char(64),
  z18 set('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  z19 enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  z20 set('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  z21 set('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  z22 enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  z23 datetime,
  z24 enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  z25 int,
  z26 enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  z27 set('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
  z28 int 
) ENGINE=InnoDB;
 
 
INSERT INTO t1 VALUES ('scholar',NULL,'zurptyfwfohbutgvcwzkmuzqulbjyyepaqdekwadynioqcgcrunknviqwkotvnln',3,NULL,'v',-2079391744,'e','e','1973-02-22 00:00:00','','h','w','complaint',4,1,'z','m',-630980608,'t','','x','',1668153344,NULL,'m',1621557248,'0000-00-00 00:00:00','m','rptyfwfohbutgvcwzkmuzqulbjyyepaqdekwadynioqcgcrunknviqwkotvnlndo',8,NULL,0,'c','w','','o','2020-11-15 07:41:25','2013-06-22 00:00:00','tyfwfohbutgvcwzkmuzqulbjyyepaq','yfwfohbutgvcwzkmuzqulbjyyepaqdekwadynioqcgcrunknviqwkotvnlndoyph','','e','','z','','','v',NULL,'f',-1442840576,'p','',2),('mine','2029-08-27 01:29:14','ohbutgvcwzkmuzqulbjyyepaqdekwadynioqcgcrunknviqwkotvnlndoyphvlyo',0,NULL,'',2,'r','','2001-04-05 08:12:54','p','d','g','hb',6,2,'nut',NULL,9,'o','','k','h',-523960320,NULL,'i',2,'1979-07-06 08:54:41','a','eat',8,9,0,'p','utgvcwzkmuzqulbjyyepaqdekwadynioqcgcrunknviqwkotvnlndoyphvlyolsx','','m','0000-00-00 00:00:00','0000-00-00 00:00:00','next','tgvcwzkmuzqulbjyye','','a','g','v','','',NULL,'0000-00-00 00:00:00','i',NULL,'h','z',NULL),('vcwzkmuzqulbjyyepaqdekwadynioqcgcrunknviqwkotvnlndoyphvlyolsxzyw',NULL,'marriage',8,'i','',NULL,'g','r','2026-07-01 00:00:00','',NULL,'o','cwzkmuzqulbjyyepaqde',NULL,3,'s','q',9,'t','','l','k',-422313984,477626368,'i',0,'1981-07-16 11:08:10','e','m',8,-2108817408,0,'wrong','privately','x','l','2029-06-10 12:16:46','1992-06-11 00:00:00','zkmuzqul','d','m','kmuzqulbjyyepaqdekwadynioqcgcrunknviqwkotvnlndoyphvlyolsxzywkzze','',NULL,'','',NULL,'2006-09-24 07:50:54','f',1,'j','',NULL),('z',NULL,'z',3,'f','',0,'x','','1983-07-07 00:00:00','s','b','o','organ',6,4,'i','u',6,'qulbjyyepaqdekwadynioqcgcrunknviqwkotvnlndoyphvlyolsxzywkzzewgfu','',NULL,'',-1790246912,923074560,'i',NULL,'0000-00-00 00:00:00','purse','playoff',8,NULL,0,'v','d','y','u','0000-00-00 00:00:00','1972-09-24 00:00:00','tough','lbjyyepaqdekwadynioqcgcrunknviqwkotvnlndoyphvlyolsxzywkzzewgfudv','','u','','f','d','','o',NULL,'s',-587137024,'s','',0),('y',NULL,'yepaqdekwadynioqcgcrunknviqwkotv',1350631424,NULL,'',NULL,'d','','0000-00-00 00:00:00','','u','c','scale',NULL,5,'epaqdekwadynioqcgcrunknviqwkotvnlndoyphvlyolsxzywkzzewgfudvctsxo','f',7,'paqdekwadynioqcgc','','s','',9,NULL,'s',748421120,NULL,'c','aqdekwadynioqcgcr',8,NULL,0,'luck','u','','','1983-07-13 07:20:57','0000-00-00 00:00:00','rest','dekwadynioqcgcrunknviqwkotvnlndoyphvlyolsxzywkzzewgfudvctsxozptl','l','but','','q','q','','u','0000-00-00 00:00:00',NULL,1258094592,'t','f',3),('ideological','0000-00-00 00:00:00','peak',5,NULL,'i',-724500480,'i','','2019-01-03 19:59:03','e','d','g','a',1432682496,6,'kwadynioqcgcrunknviqwkotvnlndoyphvlyolsxzywkzzewgfudvctsxozptlcp','o',-1770061824,'nature','s',NULL,'p',1,0,'x',NULL,'0000-00-00 00:00:00','wadynioqcgcrunknviqwkotvnlndoyphvlyolsxzywkzzewgfudvctsxozptlcpl','husband',8,NULL,0,'cook','q','','','0000-00-00 00:00:00','0000-00-00 00:00:00','loan','glory','s','echo','','v','c','','s','0000-00-00 00:00:00','e',1049886720,'y','u',NULL),('nioqcgcrunknviqwkotvnlndoyphv','1996-07-15 17:08:58','l',0,'s','',NULL,'x','','1974-09-23 00:00:00','e',NULL,NULL,'o',NULL,7,'ioqcgcrunknviqwkotvnlndoyphvlyolsxzywkzzewgfudvctsxozptlcpltrxic','i',5,'l','c',NULL,'',-1878392832,0,'m',6,'1993-06-14 17:33:54','o','qcgcrunknviqwkotvnlndoyphvlyolsxzywkzzewg',8,8,0,'a','n','s','','1977-03-28 07:54:09','2012-10-07 00:00:00','insert','d','','instructional','w','k','t','m',NULL,NULL,'m',6,'f','',NULL),('i',NULL,'gcrunknviqwkotvnlndoyphvly',256638976,'b','',2,'f','','1976-05-08 22:10:45','',NULL,'b','airplane',222625792,8,'contemporary','o',NULL,'m','','q','e',2,0,'d',67305472,'2005-06-13 00:00:00','unknviqwkotvnlndoyphvlyolsxzywkzzewgfudvctsxozptlcpltrxiclcpmuba','revenue',8,NULL,0,'nknviqwkotvnlndoyphvlyolsxzywkzzewgfudvctsxozptlcpltrxiclcpmubav','immediately','f','u','2030-08-19 00:00:00',NULL,'d','grandmother','a','k','',NULL,'','','g','0000-00-00 00:00:00','h',NULL,'p','',9),('i','1999-09-10 00:00:00','viqwkotvnlndoyphvlyolsxzywkzzewgfudvctsxozptlcpltrxiclcpmubavnzi',6,'l','q',NULL,'s','q','0000-00-00 00:00:00','','a','z','qwkotvnlndoyphvlyolsxzywkzzewgfudvctsxozptlcpltrxiclcpmubav',NULL,9,'take',NULL,NULL,'nose','','v','',1,9,'c',2,'2026-12-27 00:00:00','k','t',8,-804913152,0,'accessible','pie','','','2008-12-03 16:01:24','0000-00-00 00:00:00','y','t','','brief','f','b','c','','s',NULL,'c',-846200832,'b','',NULL),('h','2026-01-26 09:05:25','initial',8,'v','a',NULL,'l','','2020-01-11 00:00:00','','p','x','against',0,10,'o','z',0,'w','','c','',945160192,2,'n',0,'1987-08-05 00:00:00','p','v',8,2,0,'v','nlndoyphvlyolsxzywkzzewgfudvctsxozptlcpltrxiclcpmubavnzitnlelfxi','','v','2025-12-19 00:00:00','0000-00-00 00:00:00','f','priority','e','s','','s','u','','q',NULL,'u',8,'h','x',1831469056),('y','2028-06-13 00:00:00','behalf',9,NULL,'',NULL,'q','','1976-07-08 00:00:00','w',NULL,'g','oyphvlyolsxzywkzzewgfudvctsxozptlcpltrxiclcpmubavnzitnlelfxilgxm',8,11,'yphvlyolsxzywkzzewgfudvctsxozptlcpltrxiclcpmubavnzitnlelfxilgxmy','g',1,'r','j','w','',1912602624,2,'b',2,'2031-12-05 00:00:00','t','hvlyolsxzywkzzewgfudvctsxo',8,-231211008,0,'vlyolsxzywkzzewgfudvctsxozptlcpltrxiclcpmubavnzitnlelfxilgxmyjru','lyolsxzywkzzewgfudvctsxozptlcpltrxiclcpmubavnzitnlelfxilgxmyjruw','','','0000-00-00 00:00:00','0000-00-00 00:00:00','g','clue','','faculty','','r','c','','i','0000-00-00 00:00:00','m',NULL,'x','',NULL);
INSERT INTO t1 VALUES ('h','2031-05-15 02:38:55','n',0,'h','g',-1460797440,'g','','0000-00-00 00:00:00','','x','j','touchdown',NULL,12,'h','v',9,'k','','a','',-143785984,7,'p',0,'0000-00-00 00:00:00','f','zewgfudvctsxozptlcpltrxiclcpmuba',8,4,0,'l','m','','f','2018-03-04 00:00:00','1992-10-01 15:03:39','q','g','','defensive','','e','','c',NULL,NULL,'h',8,'j','',NULL),('fudvctsxozptlcpltrxiclcpmubavnzitnlelfxilgxmyjruwjyfvndgdkboanyp',NULL,'r',3,NULL,'y',1,'u','','0000-00-00 00:00:00','',NULL,'p','udvctsxozptlcpltrxiclcpmubavnzitnlelfxilgxmyjruwjyfvndgdkboanypv',6,13,'dvctsxozptlcpltrxiclcpmubavnzitnlelfxilgxmyjruwjyfvndgdkboan','t',4,'scene','',NULL,'',3,1,'c',NULL,NULL,'pick','regret',8,NULL,0,'tsxozptlcplt','sxozptlcpltrxiclcpmubavnzitnlelfxilgxmyjruwjyfvndgdkboanypvp','r','','2034-08-03 00:00:00',NULL,'xozptlcpltrxiclcpmubavnzitnlelfxilgxmyjruwjyfvndgdkboanypvpbdyos','ozptlcp','','s','','h','','m',NULL,NULL,'a',510918656,'h','d',4),('catalog',NULL,'zptlcpltrxiclcpmubavnzitnlelfxilgxmyjruwjyfvndgdkboanypvpbdyosjp',1,NULL,'',125239296,'m','','0000-00-00 00:00:00','k',NULL,NULL,'tlcpltrxiclcpmubavnzitnlelfxilgxmyjruwjyfvndgdkboanypvpbdyosjpsm',1264058368,14,'lcpltrxiclcpmubavnzitnlelfxilgxmyjruwjyfvndgdkboanypvpbdyosjpsmv','j',NULL,'n','','a','',4,5,'r',NULL,'0000-00-00 00:00:00','b','ltrxiclcpmubavnzitnlelfxilgxmyjruwjyfvndgdkboanypvpbdyosjpsmvusq',8,NULL,0,'given','immediate','','','1973-11-12 00:00:00','1993-03-14 07:43:43','d','n','','x','j','x','k','b','r','0000-00-00 00:00:00','h',4,'b','f',0),('ridge','2003-07-26 11:02:04','l',8,'k','',-760283136,'b','','2007-08-23 02:01:24','g','y','r','k',NULL,15,'s','b',NULL,'p','','a','',5,NULL,'p',NULL,'2011-10-28 00:00:00','cpmubavnzitnlelfxilgxmyjruwjyfvndgdkboa','o',8,NULL,0,'r','v','o','','1989-06-14 01:22:26','0000-00-00 00:00:00','pmubavnzitnlelfxilgxmyjruwjyfvndgdkboanypvpbdyosjpsmvusqpxzykuvw','mubavnzitnlelfxilgxmyjruw','','bavnzitnlelfxilgxmyjruwjyfvndgdkboanypvpbdyosjpsmvusqpxzykuvwrfq','f',NULL,'h','e','j','0000-00-00 00:00:00',NULL,6,'s','',1825308672),('year','0000-00-00 00:00:00','v',543817728,'k','',369754112,'g','','0000-00-00 00:00:00','r','o','z','nzitnlelfxilgxmyjruwjyfvndgdkboanypvpbdyosjpsmvusqpxzykuvwrfqbgs',1,16,'a','l',2,'melt','','m','',1,NULL,'g',NULL,'0000-00-00 00:00:00','itnl','tnlelfxilgxmyjruwjyfvndgdkboanypvpbdyosjpsmvusqpxzykuvwrfqbgsdpt',8,9,0,'q','sea','j','','0000-00-00 00:00:00',NULL,'f','nlelfxilgxmyjruwjyfvndgdkboanypvpbdyosjpsmvusqpxzykuvwrfqbgsdpt','c','lelfxilgxmyjruwjyfvndgdkboanypvpbdyosjpsmvusqpxzykuvwrfqbgsdptpf','s',NULL,'','e','j','0000-00-00 00:00:00','o',-971112448,'u','',NULL),('examination','2007-11-09 18:23:08','coast',1148715008,'e','',NULL,'q','','0000-00-00 00:00:00','j',NULL,'u','suffering',8,17,'u','h',NULL,'still','a','g','',0,0,'t',1,'1999-09-04 00:00:00','k','southwest',8,412680192,0,'lfxilgxmyjruwjyfvndgdkboanypvpbdyosjpsmvusqpxzykuvwrfqbgsdptpfie','accomplish','t','','2009-01-26 00:00:00','1998-05-16 16:55:13','fxilgxmyjruwjyfvndgdkboanypvpbdyosjpsmvusqpxzykuvwrfqbgsdptpfies','refrigerator','','ilgxmyjruwjyfvndgdkboanypvpbdyosjpsmvusqpxzykuvwrfqbgsdpt','l','b','','','m',NULL,'n',7,'k','',NULL);
INSERT INTO t1 VALUES ('w','2020-08-24 00:00:00','f',1525809152,'h','s',476643328,'m','o','0000-00-00 00:00:00','m','b','u','human',9,18,'gxmyjruwjyfvndgdkboanypvp','x',NULL,'xmyjruwjyfvndgdkboanypvpbdyosjpsmvusqpxzykuvwrfqbgsdptpfiesrmzsd','','g','r',1,5,'o',2115043328,'2033-10-20 00:00:00','myjruwjyfvndgdkboanypvpbdyosjpsmvusqpxzykuvwrfqbgsdptpfiesrm','draw',8,4,0,'immune','yjruwjyfvndgdkboanypvpbdyosjpsmvusqpxzykuvwrfqbgsdptpfiesrmzsdfz','','i','2029-11-17 00:00:00','0000-00-00 00:00:00','junior','ancient','','jruwjyfvndgdkboanypvpbdyosjpsmvusqpxzykuvwrfqbgsdptpfiesrmzsdfzi','j','b','b','','j',NULL,'r',0,'f','c',0),('u','0000-00-00 00:00:00','steadily',9,NULL,'j',8,'b','','1973-10-24 00:00:00','','k','c','x',2098724864,19,'f',NULL,NULL,'j','f','t','u',6,NULL,'h',6,'0000-00-00 00:00:00','jury','t',8,-238157824,0,'uwjyfvndgdkboany','x','c','','0000-00-00 00:00:00',NULL,'t','involved','','container','','f','k','','q','2003-02-12 00:00:00','s',1,'e','k',NULL),('class',NULL,'yfvndgdkboanypvpbdyosjpsmvusqpxzykuvwrfqbgsdptpfiesrmzsdfzijvisn',0,NULL,'',NULL,'r','','1981-12-19 00:00:00','','e','x','s',NULL,20,'stake',NULL,NULL,'often','','a','j',-690749440,0,'d',NULL,'0000-00-00 00:00:00','else','d',8,2,0,'r','n','','','2006-05-08 00:00:00','2014-10-13 00:00:00','vndgdkboanypvpbdyosjpsmvusqpxzy','k','','dgdkboanypvpbdyosjpsmvusqpxzykuv','','v','','u',NULL,NULL,'l',NULL,'o','',NULL),('w','0000-00-00 00:00:00','d',3,'i','x',3,'t','','0000-00-00 00:00:00','b','b','n','marry',623312896,21,'b','v',9,'valuable','','f','',8,NULL,'n',7,NULL,'voting','f',8,1,0,'u','m','','','0000-00-00 00:00:00',NULL,'f','h','','program','','r','','','v',NULL,'o',853278720,'o','',NULL),('dna','0000-00-00 00:00:00','gentle',4,'a','a',NULL,'g','o','0000-00-00 00:00:00','','c',NULL,'b',551288832,22,'wave','z',729612288,'x','','d','',4,0,'j',NULL,'2024-09-12 23:05:50','f','vpbdyosjpsmvusqpxzykuvw',8,1,0,'pbdyosjpsmvusqpxzykuvwrfqbgsdptpfiesrmzsdfzijvisntkcrdknkznndepi','sole','','','2024-10-28 18:51:30',NULL,'b','x','p','bowl','g','p','','','i','2027-01-02 00:00:00','r',2,'d','',5),('osjpsmvusqpxzykuvwrfqbgsdptpfiesrmzsdfzijvisntkc','1995-06-07 00:00:00','u',0,'q','',0,'a','d','2003-06-02 09:50:15','',NULL,'i','aim',NULL,23,'q','m',819396608,'n','s',NULL,'',1696202752,4,'q',0,'0000-00-00 00:00:00','whisper','heavily',8,-567607296,0,'psmvusqpxzykuvwrfqbgsdptpfiesrmzsdfzijvisntkcrdknkznn','smvusqpxzykuvwrfqbgsdptpfiesrm','','','0000-00-00 00:00:00',NULL,'violate','vusqpxzykuvwrfqbgsdptpfiesrmzsdfzijvisntkcrdknkznndepifzgwzklrod','','usqpxzykuvwrfqbgsdptpfiesrmzsdfzijvisntkcrdknkznndepifzgwzklrodm','','f','','','y',NULL,'b',NULL,'t','v',4),('qpxzykuvwrfqbgsdptpfiesrmzsdfzijvisntkcrdknkznndepifzgwzklrodmez',NULL,'pxzykuvwrfqbgsdptpfiesrmzsdfzijvisntkcrdknkznndepifzgwzklrodmezm',5,'f','',-2046623744,'k','d','1986-12-10 00:00:00','','s',NULL,'xzykuvwrfqbgsdptpfiesrmzsdfzijvisntkcrdknkznndepifzgwzklrodmezmt',0,24,'s','b',-1205010432,'pioneer','s','t','',-195559424,1,'z',9,'1995-07-06 00:00:00','a','ykuvwrfqbgsdptpfiesrmzsdfzijvisntkcrdknkznndepifzgwzklrodmezmtpj',8,2066087936,0,'kuvwrfqbgsdptpfiesrmzsdfzijvisntkcrdknkznndepifzgwzklrodmezmtpjj','uvwrfqbgsdptpfiesrmzsdfzijvisntkcrdknkznndepifzgwzklrodme','','m','2008-11-05 10:13:09','0000-00-00 00:00:00','vwrfqbgsdptpfiesrmzsdfzijvisntkcrdknkznndepifzgwzklrodmezmtpjj','i','','w','',NULL,'w','','q','0000-00-00 00:00:00','h',1614807040,'a','',0);
INSERT INTO t1 VALUES ('e','2027-06-22 03:56:13','bitter',0,'w','l',-911212544,'x','','2020-09-10 00:00:00','e',NULL,'t','j',5,25,'i','z',2,'remove','m','t','t',7,0,'w',NULL,'1973-08-20 00:00:00','fqbgsdptpfiesrm','h',8,9,0,'qbgsdptpfiesrmzsdfzijvisntkcrdknkznndepifzgwzklrodmezmtpjjeriwru','disappear','','r','2001-07-11 00:00:00','2029-05-07 22:40:04','embrace','gsdptpfiesrmzsdfzijvisntkcrdknkznndepifzgwzklrodmezmtpjjeriwruvm','','dptpfiesrmzsdfzijvisntkcrdknkznndepifzgwz','t','f','','','t','1991-07-11 00:00:00',NULL,7,'w','t',2123300864),('pfiesrmzsdfzijvisntkcrdknkznndepifzgwzklrodmezmtpjjeriwruvmajvsx','2011-06-06 09:31:23','fiesrmzsdfzijvisntkcrdknkznndepif',8,'t','',1549533184,'b','','1981-06-05 00:00:00','','y','f','b',NULL,26,'w','m',2,'yield','','y','h',1380581376,1733951488,'t',6,'2004-07-17 17:19:48','capital','everywhere',8,-437518336,0,'flexible','g','','','0000-00-00 00:00:00','1999-09-21 00:00:00','rmzsdfzijvisntkcrdknkznndepifzgwzklrodme','proud','g','mzsdfzijvisntkcrdknkznndepifzgwzklrodmezmtpjjeriwruv','','u','','','t','2029-05-03 07:46:46','g',4,'e','',8),('suggest','1974-03-14 16:54:19','expression',4,'d','l',NULL,'n','p','2003-04-28 00:00:00','',NULL,'i','able',9,27,'p','p',NULL,'dfzijvisntkcrdknkznndepifzgwzklrodmezmtpjjeriwruvmajvsxckblslkhc','f','o','',2,NULL,'e',5,NULL,'zijvisntkcrdknkznndepifzgwzklrodmezmtpjjeriwruvmajvsxckblslkhciv','ijvisntkcrdknkznndepifzgwzklrodme',8,-372178944,0,'critic','t','u','','2015-07-23 00:00:00','2011-07-03 18:14:26','k','s','n','y','','j','','','t',NULL,NULL,0,'i','',NULL),('isntkcrdknkznndepifzgwzklrodmezmtpjjeriwruvmajvsxckblslkhcivtanh','1992-03-22 00:00:00','x',0,'q','',NULL,'i','','2005-04-16 00:00:00','',NULL,'k','w',NULL,28,'tkcrdknkznndepifzgwzklrodmezmtpjjeriwruvmajvsxckblslkhcivtanhljh','e',630128640,'y','','y','',4,NULL,'u',5,NULL,'imagine','cancer',8,8,0,'kcrdknkznndepifzgwzklrodmezmtpjjeri','highway','k','y','0000-00-00 00:00:00',NULL,'each','surprise','','well-known','','o','','s','e','2027-11-28 00:00:00','b',NULL,'z','',NULL),('dknkznndepifzgwzklrodmezmtpjjeriwruvmajvsxckblslkhcivtanhljhqseu','2007-01-20 00:00:00','o',0,'u','',48037888,'p','','1983-08-06 00:00:00','','y',NULL,'g',NULL,29,'knkznndepifzgwzklrodmezmtpjjeriwruvmajvsxckblslkhcivtanhljhqs','b',NULL,'fast','',NULL,'e',1,0,'k',1,'0000-00-00 00:00:00','kznndepifzgwzklrodmezmtpjjeriwruvmajvsxckblslkhcivtanhljhqseurkv','v',8,6,0,'s','c','','','1975-08-01 14:42:48','2024-01-08 00:00:00','term','lie','','nndepifzgwzklrodmezmtpjjeriwruvmajvsxckblslkhcivtanhljhqseurkvov','o','r','f','p','q','1974-02-17 00:00:00',NULL,NULL,'h','',149749760),('site',NULL,'first',2,'c','w',1526661120,'v','','0000-00-00 00:00:00','','c','q','nurse',1905065984,30,'epifzgwzklrodmezmtpjjeriwruvmajvsxckblslkhcivtanhljhqseurkvovqgz','w',NULL,'e','','l','',8,NULL,'t',9,'2030-03-10 00:00:00','f','n',8,NULL,0,'shortly','m','','','2020-09-23 14:33:23','1992-10-14 02:15:12','v','q','','install','','w','','',NULL,'0000-00-00 00:00:00','r',-1283194880,'e','m',1440219136);
INSERT INTO t1 VALUES ('mountain','1979-12-28 00:00:00','narrow',1034551296,'w','',NULL,'c','','0000-00-00 00:00:00','','j','b','wzklrodmezmtpjjeriwruvmajvsxckblslkhcivtanhljhqseurkvovqgzncxksg',1768751104,31,'laughter','b',-431423488,'zklrodmezmtpjjeriwruvmajvsxckblslkhcivtanhljhqseurkvovqgzncxksge','','q','x',-522911744,0,'r',0,'2030-11-16 00:00:00','klrodmezmtpjjeriwruvmajvsxckblslkhcivtanhljhqseurkvovqgzncxksgem','dip',8,3,0,'z','mouse','k','','2001-01-28 00:00:00',NULL,'survey','lrodmezmtpjjeriwruvmajvsxckblslkhcivtanhljhqseurkvovqgz','','x','','h','','','a','1992-11-03 01:07:57','p',-1575813120,'d','',2),('stability','0000-00-00 00:00:00','u',589692928,'h','u',NULL,'j','','2008-08-03 00:00:00','h',NULL,'e','ezmtpjjeriwruvmajvsxckblslkhcivtanhljhqseurkvovqgzncx',NULL,32,'most','o',NULL,'m','j','f','a',7,9,'h',NULL,NULL,'zmtp','inherit',8,1775370240,0,'v','b','t','','0000-00-00 00:00:00',NULL,'mtpjjeriwruvmajvsxckblslkhcivtanhljhqseurkvovqgzncxksgemuyshzcwx','m','','t','',NULL,'','','n','0000-00-00 00:00:00','o',NULL,'z','',1922891776),('u',NULL,'delight',0,'d','',537133056,'r','','0000-00-00 00:00:00','','b','y','physician',NULL,33,'eriwruvmajvsxckblslkhcivtanhljhqseurkvovq','l',NULL,'riwruvmajvsxckblslkhcivtanhljhqseurkvovqgzncxksgemuyshzcwxgtgnok','','d','b',1138884608,8,'v',0,'2011-01-24 00:00:00','confident','man',8,NULL,0,'u','o','','y','2014-10-19 00:00:00','2003-10-16 07:21:37','f','potato','l','iwruvmajvsxckblslkhcivtanhljhqseurkvovqgzncxksgemuyshzcwxgtgnokt','','z','','k','v','0000-00-00 00:00:00',NULL,5,'v','',NULL),('seminar','0000-00-00 00:00:00','four',9,'o','',1,'w','','0000-00-00 00:00:00','',NULL,'q','vmajvsxckblslkhcivtanhljhqseurkv',0,34,'island','m',1218248704,'ma','m','q','',0,NULL,'k',NULL,NULL,'stupid','l',8,NULL,0,'t','j','c','','2004-06-13 13:28:41',NULL,'jvsxckblslkhcivtanhljhqseurkvovqgzncxksgemuyshzcwxgtgnoktqvavgsn','vsxckblslkhcivtanhljhqseurkvovqgzncxksgemuyshzcwxgtgnoktqvavgsnw','','sxckblslkhcivtanhljhqseurkvovqgzncxk','','r','b','','h',NULL,'j',-801112064,'c','',9),('ckblslkhcivtanhljhqseurkvovqgzncxksgemuyshzcwxgtgnoktqvavgsnwndj','0000-00-00 00:00:00','m',4,'s','',-2022965248,'x','j','2001-01-14 20:08:06','','v','g','full',3,35,'blslkhcivtanhljhqseurkvovqgzncxksgemuyshzcwxgtgnoktqvavgsnwndjsh','y',9,'oh','','s','l',2,563478528,'v',0,'0000-00-00 00:00:00','slk','lkhcivtanhljhqseurkvovqgzncxksgemuyshzcwxgtgnoktqvavgsnwndjshocd',8,NULL,0,'b','e','','','0000-00-00 00:00:00','2010-07-22 00:00:00','khcivtanhljhqseurkvovqgzncxksgemuyshzcwxgtgnoktqvavgsnwndjsh','mill','','hcivtanhljhqseurkvovqgzncxksgemuyshzcwxgtgnokt','','n','b','','c','0000-00-00 00:00:00','f',0,'t','',704118784),('round',NULL,'civtanhljhqseurkvovqgzncxksgemuyshzcwxgtgnoktqvavgsnwndjshocdecn',0,'d','',4,'s','','0000-00-00 00:00:00','d','x',NULL,'ivtanhljhqseurkvovqgzncxksgemuyshzcwxgtgnoktqvavgsnwndjshocdecnh',1014431744,36,'arrange','u',2,'mineral','','o','',1,NULL,'g',1709506560,'1998-03-14 02:43:16','l','b',8,2049966080,0,'v','impact','','b','0000-00-00 00:00:00',NULL,'anhljhqseurkvovqgzncxksgemuyshzcwxgtgnoktqvavgsnwndjshocdecnhxzs','direction','','dimension','b','g','','','w','1981-04-11 00:00:00','b',NULL,'i','',0),('r','2030-06-14 00:00:00','creative',6,'y','',4,'q','c','2015-11-27 00:00:00','u','l','q','hljhqseurkvovqgzncxksgemuyshzcwxgtgnoktqvavgsnwndjshocdecnhxzslm',NULL,37,'u','e',876937216,'b','','e','m',8,NULL,'r',NULL,NULL,'d','evening',8,715259904,0,'t','tragedy','','','0000-00-00 00:00:00','2028-12-24 00:00:00','hqseurkvovqgzncxksgemuyshzcwxgtgnoktqvavgsnwndjshocdecnhx','qseurkvovqgzncxksgem','','presumably','o','b','','','v','1972-11-25 04:12:43','l',-386662400,'l','l',0),('ear','0000-00-00 00:00:00','y',1274937344,'a','',-1152843776,'n','','0000-00-00 00:00:00','','o',NULL,'shareholder',0,38,'rkvovqgzncxksgemuyshzcwxgtgnoktqvavgsnwndjshoc','e',6,'k','','l','',-890175488,7,'j',NULL,NULL,'supportive','ovqgzncxksgemuyshzcwxgtgnoktqvavgsnwndjshocdecnhxzslmqpsnixw',8,NULL,0,'t','modern','','','2028-09-19 00:00:00','1993-05-01 00:00:00','bother','qgzncxksgemuyshzcwxgtgno','r','gzncxksgemuysh','w',NULL,'f','','g','0000-00-00 00:00:00','n',2,'d','g',3),('ncxksgemuyshzcwxgtgnoktqv','1998-07-27 00:00:00','eastern',5,'u','z',-1671036928,'y','i','1975-05-06 01:11:20','','q','g','s',NULL,39,'credibility','o',9,'xksgemuyshzcwxgtgnoktqvavgsnwndjshocdecnhxzslm','','b','r',5,0,'m',8,NULL,'please','c',8,-503971840,0,'sgemuyshzcwxgtgnoktqvavgsnwndj','cultural','','o','0000-00-00 00:00:00','1976-06-23 13:09:20','q','initiative','x','sensitivity','c','h','p','','l','2018-06-26 12:21:42','r',1,'x','',0),('gemuyshzcwxgtgnoktqvavgsnwndjshocdecnhxzslmqpsn','0000-00-00 00:00:00','h',670629888,NULL,'v',-590086144,'m','z','1975-10-04 00:00:00','','v','z','muyshzcwxgtgnoktqvavgsnwndjshocdecnhxzslmqpsnixwjjbgevggqypftjxp',1013186560,40,'extended','g',NULL,'l','r','i','c',231604224,4,'o',0,'0000-00-00 00:00:00','uyshzcwxgtgnoktqvavgsnwndjshocdecnhxzslmqpsnixwjjbgevggqypftjxpd','x',8,683999232,0,'w','i','y','','0000-00-00 00:00:00',NULL,'s','yshzcwxgtgnoktqvavgsn','z','measurement','p','n','','','f',NULL,'p',0,'a','',8),('hzcwxgtgnoktqvavgsnwndjshocdecnhxzslmqpsnixwjjbgevggqy','0000-00-00 00:00:00','zcwxgtgnoktqvavgsnwndjshocdecnhxzslmqpsnixwjjbgevggqypftjxpdizih',3,'d','',NULL,'o','u','2029-04-27 00:00:00','','d','z','wxgtgnoktqvavgsnwndjshocdecnhxz',0,41,'f','i',NULL,'x','','t','i',1331757056,NULL,'i',0,'0000-00-00 00:00:00','stable','j',8,1,0,'productive','xgtgnoktqvavgsnwndjshocdecnhxzslmqpsnixwjjbgevggqypftjxpdizihyqc','','','2012-10-05 00:00:00',NULL,'w','tgnoktqvavgsnwndjshocdecnhxzslmqpsnixwjjbgevggqypftjxpdizihyqcqj','','y','i','n','','',NULL,'0000-00-00 00:00:00','t',9,'i','r',2077229056);
INSERT INTO t1 VALUES ('grateful','2021-11-24 00:00:00','edge',8,NULL,'',981467136,'e','','2029-01-01 11:49:52','i','o',NULL,'q',6,42,'holy',NULL,NULL,'noktqvavgsnwndjshocdecnhxzslmqpsnixwjjbgevggqypftjxpdizihyqcqjjf','s','h','a',3,826540032,'x',NULL,NULL,'oktqvavgsnwndjshocdecnhxzslmqpsnixwjjbgevggqypftjxpdizihyqcqjjfk','j',8,NULL,0,'widely','k','m','c','2012-12-23 00:00:00','1984-04-23 16:21:06','kt','tqvavgsnwndjshocdecnhxzslmqpsnixwjjbgevggqypftjxpdizihyqcqjjfker','','m','h','u','l','p','s','1985-02-18 15:57:29','f',NULL,'g','f',7),('v','0000-00-00 00:00:00','qvavgsnwndj',2062942208,'r','',NULL,'y','','1997-07-27 14:40:29','o','b','n','u',7,43,'a',NULL,173670400,'avgsnwndjshocdecnhxzslmqpsnixwjjbgevggqypftjxpdizihyqcqjjfkeraen','','r','',1359740928,NULL,'j',0,'2002-07-27 00:00:00','admire','long',8,NULL,0,'k','x','','','2028-04-13 04:34:55',NULL,'reinforce','e','','budget','','h','','r','y','2032-08-18 00:00:00',NULL,NULL,'o','h',NULL),('proper','2025-07-08 00:00:00','q',1901723648,'x','w',1,'s','','0000-00-00 00:00:00','','t','t','wndjshocdecnhxzslmqpsn',NULL,44,'ndjshocdecnhxzslmqpsnixwjjbgevggqypftjxpdizihyqcqjjfkeraenxsxror','l',82509824,'scandal','q',NULL,'h',639827968,2,'q',9,NULL,'m','djshocdecnhxzslmqpsnixw',8,-1150812160,0,'three','v','x','','2008-10-11 00:00:00','2015-11-10 03:11:31','instruct','h','','planet','',NULL,'u','m','g',NULL,'n',1835139072,'p','',NULL),('l','1992-04-13 00:00:00','market',9,NULL,'',989986816,'c','','0000-00-00 00:00:00','','k','e','virus',NULL,45,'decnhxzslmqpsnixwjjbgevggqypftjxpdizihyqcqjjfkeraenxsxroryfmfsvu','h',-2110062592,'ecnhxzslmqpsnixwjjbgevggqypftjxpdizihyqcqjjfkeraenxsxroryfmfsvus','','w','',2013462528,NULL,'r',1,'2021-02-09 02:53:07','divine','f',8,9,0,'efficient','cnhxzslmqpsnixwjjbgevggqypftjxpdizihyqcqjjfkeraenxsxro','','','0000-00-00 00:00:00','0000-00-00 00:00:00','alcohol','striking','r','xzslmqpsnix','','h','','','o','1998-01-04 00:00:00','n',-1160118272,'p','',NULL),('lmqpsnixwjjbgevggqypftjxpdizihyqcqjjfkeraenxsxroryfmfsvusaertnqn','2028-06-04 00:00:00','exchange',9,NULL,'',593362944,'x','','0000-00-00 00:00:00','',NULL,'m','psnixwjjbgevggqypftjxpdizihyqcqjjfkeraenxsxroryfmfsvusaertnqndmq',NULL,46,'o',NULL,NULL,'accept','r','b','',-1759117312,1,'t',0,'2024-07-15 06:09:54','nixwjjbgevggqypftjxpdizihyqcqjjfkeraenxsx','association',8,6,0,'q','shelf','','','2000-10-28 00:00:00','0000-00-00 00:00:00','p','c','v','t','i','m','','','h','0000-00-00 00:00:00','e',NULL,'g','',0),('v','1994-10-08 00:00:00','jbgevggqypftjxpdizihyqcqjjfkeraenxsxroryfmfsvusaertnqndmqjhurzdw',0,'l','',NULL,'z','f','2008-04-05 00:00:00','j','z',NULL,'bgevggqypftjxpdizihyqcqjjfkeraenxsxroryfmfsvusaertnqndmqjhurzdwr',420741120,47,'gevggqypftjxpdizihyqcqjjfkeraen',NULL,600506368,'evggqypftjxpdizihyqcqjjfkeraenxsxroryfmfsvusaertnqndmqjhurzdwrts','c','h','',-1474101248,2005008384,'u',NULL,'2015-08-04 00:00:00','acquisition','soup',8,NULL,0,'ggqypftjxpdizihyqcqjjfkeraenxsxroryfmfsvusaertnqndmqjhurzdwrtsot','meal','','','2000-09-02 13:05:59','2001-03-23 00:00:00','coming','income','l','gqypftjxpdizihyqcqjjfkeraenxsxroryfmfsvusaertnqndmqjhurzdwrtsotl','','m','','','j','1982-03-05 11:59:04','x',-974716928,'t','d',765591552),('ypftjxpdizihyqcqjjfkeraenxsxroryfmfsvusaertnqndmqjhurzdwrtsotlkl',NULL,'pftjxpdizihyqcqjjfkeraenxsxroryfmfsvusaertnqndmqjhurzdwrtsotl',0,'g','',-1906180096,'i','o','1980-05-23 22:59:00','','j','l','tax',0,48,'o','a',NULL,'disappear','','w','f',9,1,'g',NULL,'0000-00-00 00:00:00','ftjxpdizihyqcqjjfkeraenxsxroryfmfsvusaertnqndmqjhurzdwrtsotlklii','cliff',8,NULL,0,'v','d','','','2034-08-27 01:27:59',NULL,'wing','conversation','s','jxpdizihyqcqjjfkeraenxsxroryfmfsvusaert','','s','','m','q','0000-00-00 00:00:00',NULL,-1210318848,'e','l',5),('a','0000-00-00 00:00:00','a',7,'i','o',NULL,'n','','2004-03-06 00:00:00','','d','s','izihyqcqjjfkeraenxsxroryfmfsvusaertnqndmqjhu',0,49,'zihyqcqjjfkeraenxsxroryfmfsvusaertnqndmqjhurzdwrtsotlkliihfjncvd','y',4,'ihyqcqjjfkeraenxsxroryfmfsvusa','',NULL,'',-882311168,8,'q',NULL,'0000-00-00 00:00:00','k','q',8,NULL,0,'hy','k','','r','1990-06-09 23:18:56','0000-00-00 00:00:00','s','guideline','','qcqjjfkeraenxsxroryfmfsvusaertnqndmqjhurz','','o','e','e',NULL,'2015-08-08 00:27:56','x',NULL,'n','q',0),('cqjjfkeraenxsxroryfmfsvusaertnqndmqjhurzdwrtsotlkliihfjncvdjfsna','2015-05-19 00:00:00','qjjfkeraenxsxroryfmfsvusaertnqndmqjhurzdwrtsotlkliihfjncvdjfsnan',323420160,'r','',NULL,'y','','0000-00-00 00:00:00','b','k','h','jfkeraenxsxroryfmfsvusaertnqndmqjhurzdwrtsotlkliihfjncvdjfsnanch',NULL,50,'o',NULL,NULL,'fkeraenxsxr','','c','e',276103168,1746731008,'b',9,'0000-00-00 00:00:00','j','abroad',8,-1703870464,0,'keraenxsxroryfmfsvusaertnqndm','exam','','a','0000-00-00 00:00:00',NULL,'y','j','','b','','b','','b','b','1974-11-11 07:20:57',NULL,NULL,'i','',NULL),('oven','0000-00-00 00:00:00','associated',1388707840,'g','',2,'r','','2019-06-09 00:00:00','','c','u','enxsxroryfmfsvusaertnqndmqjhurzdwrtsotlkliihfjncvdjfsnanchmzyjdh',NULL,51,'nxsxroryfmfsvusaertnqndmqjhurzdwrts','f',-1321205760,'minority','','b','',2,NULL,'f',NULL,'2001-08-11 00:00:00','bull','n',8,-1843200000,0,'excellent','sxro','f','','2023-01-24 09:50:04','2031-01-14 07:39:17','m','f','','difference','','v','h','','s','1975-04-27 00:00:00','l',6,'f','',5),('fmfsvusaertn','1980-11-10 04:26:33','q',6,'u','',-1238237184,'k','','0000-00-00 00:00:00','','b',NULL,'u',0,52,'destroy','g',-980090880,'fsvus','','u','',-1454833664,NULL,'i',NULL,'0000-00-00 00:00:00','p','application',8,8,0,'wood','svusae','','','0000-00-00 00:00:00','1974-06-28 18:40:21','i','all','','c','',NULL,'','','i',NULL,'d',NULL,'k','h',NULL),('rtnqndmqjhurzdwrtsotlkl','0000-00-00 00:00:00','w',2,'f','f',2,'r','','0000-00-00 00:00:00','q','i','c','offer',NULL,53,'heel','a',-321126400,'though','m','a','',26476544,0,'n',NULL,'2013-07-25 00:00:00','w','tnqndmqjhurzdwrtsotlkliihfjncvdjfsnanc',8,1375076352,0,'nqndmqjhurzdwrtsotlkliihfjncvdjfsnanchm','register','m','','0000-00-00 00:00:00','2006-04-08 00:00:00','e','k','','ndmqjhurzdwrts','r','n','','v','a',NULL,'l',1,'o','',NULL),('mqjhurzdwrtsotlkliihfjncvdjfsnanchmzyjdhfzrizlottedllyasyzbnbcrt','1977-07-16 08:50:22','j',591790080,'k','n',1756823552,'l','','0000-00-00 00:00:00','','l','c','r',0,54,'health',NULL,791871488,'hurzdwrtsotlkliihfjncvdjfsnanchmzyjdhfzrizlottedllyasyzbnbcrtzhl','','y','',-61341696,1623719936,'i',5,'0000-00-00 00:00:00','m','rzdwrtsotlkliihfjncvdjfsnanchmzyjdhfzrizlottedllyasyzbnbcrtzhlks',8,7,0,'zdwrtsotlkliihfjncvdjfsnanchmzyjdhfzrizlottedllyasyzbnbcrtzh','h','f','','2018-05-18 00:00:00','0000-00-00 00:00:00','wrtsotlkliihfjncvdjfsnanchmzyjdhfzrizlottedllyasyzbnbcrtzhlkszry','rt','','s','','c','','','i',NULL,'a',NULL,'e','',NULL),('o',NULL,'dealer',9,'n','',1177485312,'x','e','0000-00-00 00:00:00','','r','n','scatter',5,55,'plant','l',-2029584384,'c','n','y','x',-1136918528,NULL,'z',NULL,'0000-00-00 00:00:00','b','x',8,1,0,'extent','tlkliihfjncvdjfsnanchmz','x','','0000-00-00 00:00:00','0000-00-00 00:00:00','p','lkliihfjncvdjfsnanchmzyjdhfzrizlottedllyasyzbnbcrtzhlkszryvkbmws','x','a','','h','','',NULL,NULL,'y',NULL,'a','',NULL),('iihfjncvdjfsnanchmzyjdhfzrizlottedllyasyzbnbcrtzhlkszryvkbmwsmk','2016-12-09 00:00:00','x',1435435008,'s','',7,'g','','2003-11-15 00:00:00','a','a','r','g',0,56,'therapy',NULL,NULL,'computer','','c','z',3,3,'u',5,'2013-02-01 00:00:00','m','fierce',8,NULL,0,'fjncvdjfsnanchmzyjdhfzrizlottedllyasyzbnbcrtzhlkszryvkbmwsmkwwzw','jncvdjfsnanchmzyjdhfzrizlottedllyasyzbnbcrtzhlkszr','','','1982-08-25 00:00:00','0000-00-00 00:00:00','odds','mansion','','vdjfsnanchmzyjdhfzrizlottedllyasyzbnbcrtzhlkszryvkbmwsmkwwzwuhdt','z','c','','','g','0000-00-00 00:00:00','t',0,'p','o',1950547968),('jf','2015-05-07 00:00:00','fsnanchmzyjdhfzrizlottedllyasy',1415512064,'k','',NULL,'w','m','2030-05-16 19:37:02','','o',NULL,'anchmzyjdhfzrizlottedllyasyzbnbcrtzhlkszryvkbmws',0,57,'genre','a',NULL,'scramble','t',NULL,'',5,NULL,'i',0,NULL,'nchmzyjdhfzrizl','mystery',8,-99549184,0,'chmzyjdhfzrizlottedllyasyzbnbcrtzhlkszryvkbmwsmkwwzwuhdtxkuzdrrw','hmzyjdhfzrizlottedllyasyzbnbcrtzhlkszryvkbmwsmkwwzwuhdtxkuzdrrwv','','k','0000-00-00 00:00:00',NULL,'harm','zyjdhfzrizlottedllyasyzbnbcrtzhlkszryvkbmwsmkwwzwuhdtxkuzdrrwvqh','u','l','','y','','x','x','0000-00-00 00:00:00','j',NULL,'l','',7),('dhfzrizlottedllyasyzbnbcrtzhlkszryvkbmwsmkwwzwuhdtxkuzdrrwvqhgrs','2014-10-17 00:00:00','v',771751936,'c','u',NULL,'x','','1988-02-12 00:00:00','','p','h','bankruptcy',1,58,'african-american','e',NULL,'a','p','a','',0,NULL,'m',NULL,'2015-03-17 20:44:03','u','hfzrizlottedllyasy',8,3,0,'fzrizlottedllyasyzbnbcrtzhlkszryvkbmwsmkwwz','zrizlottedllyasyzbnbcrtzhlkszryvkbmwsmkwwzwuhdtxkuzdrrwvqhgrszny','','t','0000-00-00 00:00:00','1971-09-11 00:00:00','izlottedllyasyz','model','','w','','k','f','t','n','2028-12-26 00:00:00','p',NULL,'m','p',NULL),('journey',NULL,'herb',0,'l','',9,'l','g','2028-06-10 18:32:35','','w',NULL,'try',NULL,59,'found',NULL,NULL,'r','','l','',1397948416,8,'z',0,NULL,'ttedllyasyzbnbcrtzhlkszryvkbmwsmkwwzwuhdtxkuzdrrwvqhgrsznyxipumz','tedllyasyzbnbcrtzhlkszryvkbmwsmkwwzwuhdtxku',8,4,0,'u','o','','','2007-02-15 09:12:53','0000-00-00 00:00:00','given','real','l','edllyasyzbnbcrtzhlkszr','','e','','','m','1973-01-28 11:12:20',NULL,-712835072,'q','l',236453888),('llyasyzbnb','2012-04-28 02:30:28','department',0,'q','',7,'n','','2013-01-14 11:03:26','','j','f','asyzbnbcrtzhlkszryvkbmwsmkwwzwuhdtxkuzdrrwvqhg',1453522944,60,'n','b',-196673536,'hell','j','i','',3,5,'a',1848180736,'2024-06-07 00:00:00','convey','to',8,1881276416,0,'t','korean','q','o','0000-00-00 00:00:00','2002-10-17 00:00:00','u','opinion','l','accurately','u','c','x','','p','2016-08-16 09:51:34','j',2043871232,'r','b',NULL),('spectacular','2009-01-16 00:00:00','yzbnbcrtzhlkszryvkbmwsmkwwzwuhdt',0,NULL,'',2080178176,'j','','0000-00-00 00:00:00','','k','k','y',1,61,'cage',NULL,3,'bnbcrtzhlkszryvkbm','n',NULL,'',885194752,4,'k',NULL,'2024-02-18 01:21:35','n','bcrtzhlkszryvkbmwsmkwwzwuhdtxkuzdrrwvqhgrsznyxipumzzdhadqulqhozf',8,-1174274048,0,'d','belief','','x','0000-00-00 00:00:00','2009-04-16 00:00:00','aide','technique','','j','','p','a','','o',NULL,'d',3,'z','p',685899776),('c','0000-00-00 00:00:00','household',0,'w','',NULL,'p','','2022-03-05 00:00:00','',NULL,'f','healthy',0,62,'k','w',1383792640,'n','','d','',-89128960,0,'i',NULL,'2020-05-16 23:11:44','corner','d',8,NULL,0,'tzhlkszryvkbmwsmkwwzwuhdtxkuzdrrwvqhgrsznyxipumzzdhadqulqhozfufb','w','','f','1990-01-07 02:06:31','2009-10-03 00:00:00','zhlkszryv','h','z','lkszryv','',NULL,'','',NULL,'1998-04-21 11:13:04',NULL,NULL,'x','e',NULL),('zryvkbmwsmkwwzwuhdt','2023-12-19 00:00:00','ryvkbmwsmkwwzwuhdtxkuzdrrwvqhgrsznyxipumzzdhadqulqhozfufbfuncjxh',0,'v','',1994457088,'i','','0000-00-00 00:00:00','','p','n','scheme',602603520,63,'r','i',9,'s','','h','',598409216,3,'u',0,'2025-05-13 00:00:00','integrity','mwsmkwwzwuhdtxkuzdrrwvqhgrsznyxipumzzdhadqulqhozfufbfuncjxhlwcxv',8,836370432,0,'tightly','show','','','1971-02-19 10:45:46','2019-08-20 21:39:22','a','transformation','','gym','b','t','','',NULL,'1985-05-25 00:00:00','f',-412876800,'y','',NULL),('u',NULL,'wwzwuhdtxkuzdrrwvqhgrsznyxipumzzdhadqulqhozfufbf',933036032,'m','',2010054656,'t','','1974-12-01 00:00:00','','d','i','awareness',0,64,'barely','r',-2040594432,'zwuhdtxkuzdrrwvqhgrsznyxipumzzdhadqulqhozfufbfuncjxhlwcxvlujngjm','h','e','',-1740636160,NULL,'z',NULL,'2008-12-03 00:00:00','wuhdtxkuzdrrwvqhgrsznyxipumzzdhadqulqhozfufbfuncjxhlwcxvlu','b',8,-1319567360,0,'outfit','no','','','1996-02-06 12:54:21','2013-08-25 07:57:36','similarity','maintain','','i','','z','','g','l','2022-07-04 00:00:00',NULL,5,'v','',1162477568),('txkuzdrrwvqhgrsznyxipumzzdhadqulqhozfufbfuncjxhlwcxvlujngjmaqiac','2004-03-01 00:00:00','xkuzdrrwvqhgrsznyxipumzzdhadqulqhozfufbfuncjxhlwcxvlujngjmaqi',5,'h','z',NULL,'d','','1979-03-05 14:35:11','','o','x','bug',NULL,65,'ocean','o',NULL,'o','f',NULL,'',7,NULL,'y',NULL,NULL,'t','zdrrwvqhgrsznyxipumzzdhadqulqhozfufbfuncjxhlwcxvlujngjmaqiacfxsp',8,1365180416,0,'o','drrwvqhgrsznyxipumzzdhadqulqhozfufbfuncjxhlwcxvlujngjmaqiacfxspn','','k','2029-02-26 00:00:00','1989-02-19 00:00:00','rwvqhgrsznyxipumzzdhadqulqhozfufbfuncjxhlwcxvlujngjmaqiacfxspnoz','o','','j','','c','','','t',NULL,'p',-1759903744,'x','',0),('grsznyxipumz','2004-09-02 00:00:00','j',5,'d','',8,'p','','0000-00-00 00:00:00','','g',NULL,'internet',1918500864,66,'n','n',NULL,'znyxipumzzdhadqulqhozfufbfuncjxhlwcxvlujngjmaq','',NULL,'',2,1276051456,'c',NULL,'1997-05-03 08:47:16','y','yxipumzzdhadqulqhozfufbfuncjxhlwcxvlujngjmaqiacfxspn',8,1,0,'a','please','','v','2006-02-22 00:00:00',NULL,'proportion','xipumzzdhadqulqhozfufbfuncjxhlwcxvlujngjmaqiacfxspnozqzgxhchmjon','','several','','t','','',NULL,NULL,NULL,7,'i','w',0),('g','1971-02-05 00:00:00','mzzdhadqulqhozfufbfuncjxhlwcxvlujngjmaqiacfxspnozqzgxhchmjondzsm',9,'t','',NULL,'j','','0000-00-00 00:00:00','b','l','f','y',5,67,'zzdhadqulqhozfufbfuncjxhlwcxvlujngjmaqiacfxspnozqzgxhchmjondzsmc','a',-652279808,'beam','','x','w',3,1982660608,'y',NULL,'0000-00-00 00:00:00','j','l',8,0,0,'loan','publish','','','2029-05-21 00:00:00','0000-00-00 00:00:00','f','k','','league','',NULL,'','','w','0000-00-00 00:00:00','v',-67764224,'e','',1),('m','0000-00-00 00:00:00','m',0,'w','',-19136512,'g','','1987-11-11 05:18:34','',NULL,'r','lqhozfufbfuncjxhlwcxvlujngjmaqiacfxspnoz',NULL,68,'phase','w',1362821120,'evolve','','c','',2,1,'t',1691090944,'1979-04-15 00:00:00','qhozfu','hozfufbfuncjxhlwcxvlujngjmaqiacfxspnozqzgxhchmjondzsmcnuzxbrjolq',8,NULL,0,'n','a','q','','0000-00-00 00:00:00',NULL,'zfufbfuncjxhlwcxvlujngjmaqiacfxspnozqzgxhchmjondzsmcnuzxbrjolqry','v','','k','','p','','','j',NULL,'u',NULL,'p','g',2),('q','2006-10-24 00:00:00','l',8,'d','',8,'e','','1979-02-22 00:00:00','e',NULL,'n','prediction',7,69,'skilled','h',6,'a','z','j','u',-1961885696,1,'c',NULL,'1977-02-21 22:46:39','r','q',8,NULL,0,'s','fbfuncjxhlwcxvlujngjmaqiacfxspnozqzgxhchmjondzsmcnuzxbrjolqrycky','y','','2005-09-11 00:00:00',NULL,'bfuncj','bacteria','','funcjxhlwcxvlujngjmaqiacfxspnozqzgxhchmjondzsmcnuzxbrjolqrycky','',NULL,'d','x','n','2001-03-04 21:28:03','x',7,'j','x',4),('expansion',NULL,'l',6,'n','b',-2083782656,'v','c','1974-07-22 00:00:00','','l','a','g',0,70,'b','u',NULL,'hope','','s','i',-37421056,725811200,'z',NULL,NULL,'b','cjxhlwcxvlujngjmaqiacfxspnozqzgxhchmjondzsmcnuzxbrjolqryckytzdgv',8,7,0,'t','c','','','0000-00-00 00:00:00','2031-06-21 21:00:52','hlwcxvluj','lwcxvlujngjmaqiacfxspnozqzgxhchmjond','','n','','v','i','n','g','1995-01-04 00:00:00',NULL,638910464,'n','t',NULL),('x','2025-03-21 01:22:54','h',0,'i','y',NULL,'z','','0000-00-00 00:00:00','',NULL,'v','xvlujngjmaqiacfxspnozqzgxhchmjondzsmcnuzxbrjolqryckytzdgvaswjgrd',4,71,'vlujngjmaqiacfxspnozqzgxhchmjondzsmcnuzxbrjolqryckytzdgvaswjgrda','i',NULL,'lujngjm','b','h','',-1257111552,NULL,'j',0,'2020-08-10 00:00:00','j','ujngjmaqiacfxspnozqzgxhchmjondzs',8,NULL,0,'jngjmaqiacfxspnozqzgxhchmjondzsmcnuzxbrjolqryckytzdg','ngjmaqiacfxspno','b','','1991-08-13 00:00:00','2001-07-27 18:18:30','jmaqiacfxspnozqzgxhchmjondzsmcnuzxbrjolqryckytzdg','maqiacfxspnozqzgxhchmjondzsmcnuzxbrjolqryckytzdgvaswjgrdavmycbxr','','aqiacfxspnozqzgxhchmjondzsmcnuzxbrjolqryckytzdgvaswjgrdavm','y',NULL,'z','m','m',NULL,'h',NULL,'x','',NULL),('stomach','0000-00-00 00:00:00','identification',695009280,'a','',1854013440,'t','n','1990-10-14 00:00:00','',NULL,'o','anyway',1261174784,72,'compromise','c',1189412864,'m','w','q','',-215678976,5,'r',9,NULL,'temperature','about',8,489226240,0,'written','addition','','','2002-10-21 00:00:00',NULL,'l','s','','cfxspnozqzgxhchmjondzsmcnuzxbrjolqryckytzdgvaswjg','t','v','','','y','0000-00-00 00:00:00','x',789315584,'d','v',0),('xspno','1989-12-06 00:00:00','spnozqzgxhchmjondzsmcnuzxbrjolqryckytzdgvaswjgrdavmycbxrzfrhttkv',1306591232,'s','v',4,'u','a','2035-01-22 00:00:00','','r','o','negotiation',4,73,'f',NULL,NULL,'sister','','z','j',6,NULL,'j',7,'0000-00-00 00:00:00','leg','overwhelming',8,4,0,'pnozqzgxhchmjondzsmcnuzxbrjolqryckytzdgvaswjgrdavmycbxrzfrhttkvq','b','','','1971-04-10 00:00:00','2005-11-09 04:58:46','somewhat','tool','b','p','','s','x','','v','0000-00-00 00:00:00','j',1,'a','',6),('b','2007-04-18 22:44:46','zqzgxhchmjondzsmcnuzxbrjolqryckytzdgvaswjgrdavmycbxrzfrhttkvqwaw',7,'b','f',NULL,'w','','2009-12-27 00:48:09','','o','g','capacity',4,74,'expect','t',1485111296,'u','',NULL,'',1012203520,1,'i',NULL,NULL,'xhchmjondzsmcnuzxbrjolqryckytzdgvaswjgrdavmycbxrzfrhttkvqwawwafg','hchmjondzsmcnuzxbrjolqryckytzdgvaswjgrdavmycbxrzfrhttkvqw',8,5,0,'chmjondzsmcnuzxbrjolqryckytzdgva','hmjondzsmcnu','','','2007-11-02 00:00:00','0000-00-00 00:00:00','a','jondzsmcnuzxbrjolqryckytzdgvaswjgrdavmycbxrzf','','concede','x',NULL,'v','u','j','0000-00-00 00:00:00','y',NULL,'w','',159842304),('sword','2016-03-05 00:00:00','seed',460652544,'m','d',NULL,'b','h','1987-03-02 16:47:40','k','p','e','u',0,75,'ndzsmcnuzxbrjolqryckytzdgvaswjgrdavmycbxrzfrhttkvqwawwafgpvqepzm',NULL,NULL,'d','','h','',7,6,'e',NULL,'2030-01-15 00:00:00','smcnuzxbrjolqryckytzdgvaswjgrdavmycbxrzfrhttkvqwawwafgpvqepzmzir','mcnuzxbrjolqryckytzdgvaswjgrdavmycbxrzfrhttkvq',8,5,0,'cnuzxbrjolqryckytzdgvaswjgrdavmycbxrzfrhttkvqwawwafgpvqepzmziruq','appointment','','n','0000-00-00 00:00:00','0000-00-00 00:00:00','e','seed','y','entrance','v',NULL,'','','v','0000-00-00 00:00:00','o',NULL,'y','',3),('h','2012-08-24 22:08:13','local',1,'w','',NULL,'q','','2032-01-22 18:06:00','l','s','y','uzxbrjolqryckytzdgvaswjgrdavmycbxrzfrhttkvqwawwafgpvqepzmziruqlj',0,76,'r','i',-574357504,'zxbrjolqryckytzdgvaswjgrdavmycbxrzfrhttkv','',NULL,'',1701904384,6,'a',NULL,'2011-03-24 00:00:00','considerable','adventure',8,0,0,'brjolqryckytzdgvaswjgrdavmycbxrzfrhttkvqwawwafgpvqepzmziruqljifx','successfully','','','1990-08-26 13:05:11','1992-10-08 08:05:41','olqryckytzdgvaswjgrdavmycbxrzfrhttkvqwawwafgpvqepzmziruqljifxpzx','lqryckytzdgv','','qryckytzdgvaswjgrdavmycbxrzfrhttkvqwawwafgpvqepzmziruqljifxpzxxh','k','v','','','k','2022-01-03 00:00:00',NULL,NULL,'m','j',9),('c','0000-00-00 00:00:00','i',0,'c','x',NULL,'z','f','1994-08-11 00:00:00','','q','v','j',0,77,'b','x',1993998336,'b','','c','l',-1544093696,1,'z',0,'2022-03-09 00:00:00','l','yckytzdgvaswjgrdavmycbxrzfrhttkvqwawwafgpvqep',8,NULL,0,'b','ckytzdgvaswjgrdavmycbxrzfrhttkvqwawwafgpvqepzmziruqljifxpzxxhyjw','k','b','1992-07-16 00:38:23','0000-00-00 00:00:00','kytzdgvaswjgrdavmycbxrzfrhttkvqwawwafgpvqepzmziruqljifxpzxxhyjwz','flat','','o','m','l','','',NULL,'2025-04-26 00:00:00','c',99745792,'x','',9),('near','2015-01-23 00:00:00','zdgvaswjgrdavmycbxrzfrhttkvqwawwafgpvqepzmziruqljifxpzxxhyjwzmbh',0,'z','',598605824,'i','','1983-01-09 15:41:12','m','r','m','b',0,78,'r',NULL,NULL,'imagine','',NULL,'g',2135556096,NULL,'r',5,'1980-07-20 22:58:00','policeman','u',8,NULL,0,'v','breathe','','','0000-00-00 00:00:00','0000-00-00 00:00:00','hispanic','l','','aswjgrdavmycbxr','',NULL,'','','p','1994-11-16 00:00:00','r',-1277100032,'s','y',NULL),('b','0000-00-00 00:00:00','jgrdavmycbxrzfrhttkvqwawwafgpvqepzmziruqljifxpzxxhyjwzmbhpoyuanj',0,'d','',-2103508992,'l','','1971-07-09 00:00:00','e','a','b','t',0,79,'c','n',8,'rdavmycbxrzfrhttkvqwawwafgpvqepzmziruqlj','g','n','',-217186304,NULL,'c',265682944,NULL,'ago','p',8,NULL,0,'s','avmycbxrzfrhttkvqwawwafgpvqepzm','b','','0000-00-00 00:00:00','0000-00-00 00:00:00','recent','vmycbxrzfrhttkvqwawwafgpvqepzmziruqljifxpzxxhyjwzmbhpoyuanjavh','','mycbxrzfrhttkvqwawwafgpvqep','','y','','','u','0000-00-00 00:00:00','n',NULL,'n','',4),('xrzfrhttkvqwawwaf',NULL,'current',1237516288,'r','u',-76283904,'u','b','0000-00-00 00:00:00','','h','l','zfrhttkvqwawwafgpvqepzmziruqljifxpzxxhyjwzmbhp',5,80,'frhttkvqwawwafgpvqepzmziruqljifxpzxxhyjw','k',NULL,'rhttkvqwawwafgpvqepzmziruqljifxpzxxhyjwzmbhpoyuanjavhbirpiewhhgl','c','y','q',9,1078591488,'v',4,NULL,'edge','a',8,-399572992,0,'l','r','j','b','2006-02-06 00:00:00',NULL,'steel','httkvqwawwafgpvqepzmziruqljifxpzxxhyjwzmbhpoyuanjavhbirpiewhhgll','p','ttkvqwawwaf','p','o','','','p',NULL,'v',32374784,'d','',NULL),('kvqwawwafgpvqepzmziruqljifxpzxxhyjwzmbhpoyuanjavhbirpiewhhgll','1989-10-18 00:00:00','document',8,'k','b',NULL,'b','','2003-04-12 17:08:28','p','i','i','operation',NULL,81,'w','g',2,'w','','k','a',1749483520,1328873472,'q',1690566656,'2035-10-19 00:00:00','presentation','huh',8,8,0,'t','s','','','0000-00-00 00:00:00','0000-00-00 00:00:00','excessive','d','','wawwafgpvqepzmziruqljifx','','m','','','h',NULL,NULL,4,'s','',6),('wafgpvqepzmz',NULL,'rider',2,'j','h',NULL,'x','','1985-10-27 03:43:20','z','v','r','relevant',NULL,82,'fgpvqepzmziruqljifxpzxxhyjwzmbhpoyuanjavhbirpiewhhgllftavqvskswz',NULL,0,'defeat','','u','',2,0,'h',0,NULL,'q','hat',8,2,0,'i','b','i','','2019-03-13 08:00:02',NULL,'t','i','','crystal','','q','','','i','0000-00-00 00:00:00','e',-1470955520,'x','',2),('discovery',NULL,'o',452263936,'p','',NULL,'s','','2020-07-16 13:54:22','','q',NULL,'stream',345047040,83,'h','e',-2126249984,'zmziruqljifxpzxxhyjwzmbhpoyuanjavhbirpiewhhgllftavqvskswzififevp','s','j','',0,0,'g',819789824,'0000-00-00 00:00:00','y','b',8,1,0,'mziruqljifxpzxxhyjwzmbhpoyuanjavhbirpiewhhgllftavqvskswzififevpe','ziruqljifxpzxx','','','1974-08-19 00:00:00','1979-09-27 13:39:02','y','uqljifxpzxxh','e','s','','k','g','','r','1978-05-06 00:00:00','x',-2000617472,'s','',0),('qljifxpzxxhyjwzmbhpoyuanjavhbirpiewhhgllftavqvskswzififevpercyim','1990-05-10 00:00:00','ljifxpzxxhyjwzmbhpoyuanjavhbirpiewhhgllftavqvskswzififevpercyimx',4,'k','',9,'h','','2017-05-11 00:30:28','','p','b','alley',1,84,'instructor','t',1603403776,'h','','h','c',4,1369112576,'x',NULL,NULL,'jifxpzxxhyjwzmbhpoyuanj','forgive',8,NULL,0,'ifxpzxxhyjwzmbhpoyuanjavhbirpiewhhgllftavq','c','q','','0000-00-00 00:00:00','2018-04-15 00:00:00','e','patient','','xpzxxhyjwzmbhpoyuanjavhbirpiew','f','i','','c','v','2019-07-10 00:00:00',NULL,NULL,'b','',9),('xxhyjwzmbhpoyuanjavhbirpiewhhgllftavqvskswzififevpercyimxxyrgljx','2004-06-19 20:32:27','k',4,NULL,'',1304756224,'g','','1987-09-06 20:44:17','','o','i','yjwzmbhpoyuanjavhbirpiewhhgllftavqvskswzififevper',NULL,85,'j','q',157614080,'h','r','n','a',398655488,1258618880,'q',NULL,NULL,'innocent','hunger',8,-1809055744,0,'jwzmbhpoyuanjavhbirpiewhhgllftavqvskswzififevpercyimxxyrgljxyeaq','acknowledge','','','1984-11-11 09:32:33','0000-00-00 00:00:00','mbhpoyuanjavhbirpiewhhgllftavqvskswzififevpercyimxxyrgljxy','bhpoyuanjavhbirpiewhhgllftavqvskswzififevpercyimxxyrgljxyeaqbyxv','o','table','','u','','y',NULL,'1997-08-20 10:24:06','w',1978400768,'m','',NULL),('j','2011-05-03 03:42:05','poyuanjavhbirpiewhhgllftavqvskswzififev',0,'v','b',526450688,'i','','0000-00-00 00:00:00','','q','a','oyuanjavhbirpiewhhgllftavqvskswzififevpercyimxxyrgljxyeaqbyxvgrj',4,86,'w','y',NULL,'yuanjavhbirpiewhhgllftavqvskswzififevpercyimxxyrgljxyeaqbyxvgrjs','w','f','',8,NULL,'x',NULL,'2005-09-26 10:58:10','uanjavhbirpiewhhgllftavqvskswzififevpercyimxxyrgljxyeaqbyxvgrjsc','anjavhbirpie',8,6,0,'l','j','','b','0000-00-00 00:00:00','1989-06-08 00:00:00','tube','w','j','coordinate','','n','m','','m','2014-11-06 10:17:53','f',1,'o','',NULL),('stranger','0000-00-00 00:00:00','recovery',0,NULL,'u',NULL,'o','','2013-09-07 00:25:52','','r',NULL,'neighboring',1250951168,87,'schedule','m',2,'u','',NULL,'',4,1389887488,'s',0,'2005-10-12 20:56:25','entitle','f',8,2,0,'sexuality','g','','a','1979-12-26 00:00:00',NULL,'k','financial','','y','',NULL,'','','a','2003-09-18 17:32:00',NULL,1653735424,'p','',2),('irpiewhhgllftavqvskswzififevpercyimxxyrgljxyeaqbyxvgrjscndzxcqza','0000-00-00 00:00:00','bucket',465764352,'j','',-457375744,'r','m','1984-11-11 15:56:55','v','h','q','survive',6,88,'stage','q',-1405616128,'d','s','y','',2086010880,496828416,'j',2009530368,'2008-10-09 10:35:53','rpiewhhgllftavqvskswzififevpercyimxxyrgljxyeaqby','piewhhgllftavqvskswzififevpercyimxxyrgljxy',8,1,0,'iewh','ewhhgllftavqvskswzififevpercyimxxyrgljxyeaqbyxvgrjscndzxcqzaiyxs','','t','1988-09-16 00:00:00',NULL,'screening','whhgllftavqvskswzififevpercyimxxyrgljxyeaqbyxvgrjscndzxc','','five','','m','','','l','2016-06-04 00:00:00','w',-420478976,'s','',0),('g','0000-00-00 00:00:00','llftavqvskswzififevpercyimxxyrglj',726466560,'j','',1241710592,'r','','0000-00-00 00:00:00','j','d',NULL,'tavqvskswzififevpercyimxxyrgljxyeaqbyxvgrjscndzxcqzaiyxsldyarzsx',NULL,89,'avqvsksw','v',NULL,'j','v','e','',6,NULL,'b',NULL,'2011-09-20 15:47:25','awareness','p',8,NULL,0,'as','vqvskswzififevpercyimxxyrgljxyeaqbyxvgrjscndzxcqzaiyxsldyarzsxhd','e','','2034-11-11 00:00:00','2033-06-01 20:00:16','vskswzififevpercyimxxyrglj','skswzififevpercyimxxyrgljxyeaqbyxvgrjscndzxcqzaiyxsldyarzsxhdb','','landmark','','o','','','v','2005-04-10 00:00:00',NULL,98435072,'q','p',302448640),('wzififevpercyimxxyrgljxyeaqbyxvgrjscndzxcqzaiyxsldyarzsxhdblbwre','0000-00-00 00:00:00','d',0,'x','',2,'w','w','1971-06-06 16:18:04','',NULL,NULL,'fifevpercyimxxyrgljxyeaqbyx',2,90,'j','y',NULL,'ifevpercyimxxyrgljxyeaqbyx','','o','',8,NULL,'r',7,NULL,'vpercyimxxyrgljxyeaqbyxvgrjscndzxcqzaiyxsldyarzsxhdblbwrewrjaijt','c',8,NULL,0,'discussion','layer','','n','2007-10-22 00:00:00',NULL,'percyimxxyrgljxyeaqbyxvgrjscndzxcqzaiyxsldyarzsxhdblbwrewrjaijtt','ercyimxxyrgl','m','e','','z','','j','j','0000-00-00 00:00:00','w',-932249600,'d','h',7),('yimxxyrgljxyeaqbyxvgrjscndz','2025-05-06 00:00:00','imxxyrgljxyeaqbyxvgrjscndzxcqzaiyxsldya',6,'i','z',NULL,'b','','0000-00-00 00:00:00','','z','b','mxxyrgljxyeaqbyxvgrjscndzxcqzaiyxsldyarzsxhdblbwrewrjaijttblbevi',2,91,'regardless','s',-947585024,'prize','i','n','q',-1863778304,NULL,'u',1808531456,'2009-11-18 01:24:57','xxyrgljxyeaqbyxvgrjscndzxcqzaiyxsldyarzsxhdblbwrewrjaijttblbevik','miracle',8,NULL,0,'x','resolution','','','1984-10-27 00:00:00',NULL,'xyrgljxyeaqbyxvgrjscndzxcqzaiyxsldyarzsxhdblbwrewrjaijttblbevika','v','','rgljxyeaqbyxvgrjscndzxcqzaiyxsldyarzsxhdblbwrewrjaijttblbevikaey','','a','','','k','0000-00-00 00:00:00','z',922943488,'z','',945946624),('q','2017-08-04 20:11:32','v',897384448,NULL,'',-570818560,'s','y','1978-10-28 14:46:22','',NULL,NULL,'a',0,92,'e','y',NULL,'aqbyxvgrjscndzxcqzaiyxsldyarzsxhdblbwrewrjaijttblbevikaeynejujb','','s','',1,NULL,'w',936050688,'1991-10-05 00:00:00','p','yxvgrjscndzxcqzaiyxsldyarzsxhdblbwrewrjaijttblbevikaeynejujbnqgk',8,9,0,'s','increasing','d','','1983-11-18 00:00:00','0000-00-00 00:00:00','vgrjscndzxcqzaiyxsldyarzsxhdblbwrewrjaijttblbevikaeynejujbnqgkhy','a','c','u','i','a','','',NULL,NULL,'b',-1876492288,'r','',0),('rjscndzxcqzaiyxsldyarzsxhdblbwrewrjaijttblbevikaeynejujbnqgkhyl','1995-12-02 00:00:00','f',3,'h','k',-200278016,'a','','1972-06-12 12:09:50','','g','f','scndzxcqzaiyxsldyarzsxhdblbwrewrjaijttblbevikaeynejujbnqgkhylyyv',0,93,'cndzxcqzaiyxsldy','h',3,'post','','y','l',-603652096,NULL,'i',0,'2009-06-25 00:38:17','dzxcqzaiyxsldyarzsxhdblbwrewrjaijttblbevikaeynejujbnqgkhylyyvrjt','zxcqzaiyxsldyarzsxhdblbwrewrjaijttblbevikaeynejujbnqgkhylyyvrjty',8,NULL,0,'z','disappointed','r','w','2030-04-27 06:59:04',NULL,'pine','g','','d','','c','','','m',NULL,'f',2036137984,'o','',0),('qzaiyxsldyarzsxhdblbwrewrja',NULL,'c',0,'k','',-1903230976,'h','a','2018-04-09 00:00:00','s','v','q','f',NULL,94,'iyxsldyarzsxhdblbwrewrjaijttblbevikaeynejujbnqgkhylyyvrjtybizzvk','j',NULL,'bottle','',NULL,'',-1383071744,0,'g',459276288,NULL,'detective','meter',8,NULL,0,'yxsldyarzsxhdblbwrewrjaijttblbevikaeynejujbnqgkhylyyvrjtybizzvkz','xsldyarzsxhdblbwrewrjaijttblbevikaeynejujbnqgkhylyyvrjtybizzvkzj','','z','0000-00-00 00:00:00',NULL,'z','e','','l','k','l','','',NULL,'2004-09-25 00:00:00','q',NULL,'p','',NULL),('dyarzsxhdblbwrewrjaijttblbevikaeynejujbnqgkhy','0000-00-00 00:00:00','yarzsxhdblbwrewrjaijttblbevikaeynejujbnqgkhylyyvrjtybizzvkzjuzcn',0,'f','',NULL,'o','','2005-11-22 04:54:15','','k','a','carve',8,95,'h','r',NULL,'h','','h','',-548667392,1263796224,'a',NULL,NULL,'unite','r',8,-345899008,0,'thank','sxhdblbwr','','m','2025-04-27 12:21:38','2020-11-02 00:00:00','hdblbwrew','dblbwrewrjaijttblbevikaeynejujbnqgkhylyyvrjtybizzvkzju','x','exploit','','s','','','b','0000-00-00 00:00:00','o',4,'g','',0),('j','0000-00-00 00:00:00','front',8,'m','q',3,'b','','0000-00-00 00:00:00','','q','l','n',0,96,'dependent','q',NULL,'manipulate','','x','i',4,6,'e',NULL,'1979-10-12 16:43:15','rewrjaijttblbevikaeynejujbnqgkhylyyv','ewrjaijttblbevikaeynejujbnqgkhylyyvrjtybizzvkzjuzcnfbniutagqthoh',8,NULL,0,'wrjaijttblbevikaeynejujbnqgkhylyy','rjaijttblbevikaeynejujbnqgkhylyyvrjtybizzvkzjuzcnfbniutagqthohre','','','0000-00-00 00:00:00','2012-05-01 20:56:45','ignore','ijt','','c','','s','h','v','d',NULL,'s',0,'w','',0),('cooperation','0000-00-00 00:00:00','million',7,'u','',NULL,'j','','1998-10-03 21:01:05','v','r','i','jttblbevikaeynejujbnqgkhylyyvrjtybizzvkzjuzcnfbniutagqthohrepcxg',NULL,97,'v','y',8,'l','y','l','',-877723648,2088435712,'n',NULL,'0000-00-00 00:00:00','ttblbevikaeynejujbnqgkhylyyvrjtybizzvkzjuzcnfbniutagqthohrepcxgf','tblbevikaeynejujb',8,7,0,'s','r','','r','0000-00-00 00:00:00',NULL,'partially','lbevikaeynejujbnqgkhylyyvrjtybizzvkzjuzcnfbniutagqt','','n','i',NULL,'','',NULL,NULL,NULL,NULL,'e','',0),('d','0000-00-00 00:00:00','conventional',4,'f','',NULL,'t','n','2012-04-12 00:00:00','',NULL,'d','vikaeynejujbnqgkhylyyvrjtybizzvkzjuzcnfbniutagqthohrepcxgftubyep',8,98,'f','c',NULL,'w','','l','',1751252992,3,'o',1924136960,'2014-07-24 00:00:00','aeynejujbnqgkhylyyvrjtybiz','eynejujbnqgkhylyyvrjtybizzvkzjuzcnfbniutagqthohrepcxgftubyepvfce',8,2,0,'penalty','palm','q','p','2028-07-27 10:49:08',NULL,'o','ynejujbnqgkhylyyvrjtybizzvkzjuzcnfbniutagqthohrepcxgftubyepvfcec','v','h','x','m','','','r','2025-04-01 06:36:42',NULL,NULL,'y','',0),('performance',NULL,'jujbnqgkhylyyvrjtybizzvkzjuzcnfbniuta',7,'d','a',NULL,'b','f','1994-09-27 00:00:00','',NULL,'c','v',NULL,99,'eighth','t',6,'j','x','l','',-911343616,4,'o',0,NULL,'jbnqgkhylyyvrjtybizzvkzjuzcnfbniutagqthohrepcxgft','bnqgkhylyyvrjtybizz',8,-1006108672,0,'l','input','','','2012-06-27 21:12:04','2026-03-16 11:07:23','frame','j','','e','z','z','c','','b','2014-06-17 00:00:00','i',-538312704,'m','x',0),('y',NULL,'khylyyvrjtybizzvkzjuzcnfbniutagqthohrepcxgftubyepvfcecmwyfjyudzy',9,'w','',8,'v','u','1982-04-08 00:00:00','','a','b','lyyvrjtybizzvkzjuzcnfbniutagqthohrepcxgftubyepvfcec',1591345152,100,'g','q',781778944,'milk','','c','',1,NULL,'u',3,NULL,'vrjtybizz','rjtybizzvkzjuzcnfbniutagqthohrepcxgftubyepvfcecmwyfjyudzyezwkllz',8,NULL,0,'jtybizzvkzjuzcnfbniutagqthohrepcxgftubyepvfcecmwyfjyudzyezwkllzq','e','','','1985-03-21 00:00:00','0000-00-00 00:00:00','soccer','tybizzvkzjuzcnfbniutagqthohrepcxgftubyepvfcecmwyfjyudzyezwkllzqj','','performer','z','s','','','f','2018-08-21 20:27:54','w',465567744,'c','',0);
 
START TRANSACTION ;
--error 1197,1534
UPDATE t1 SET z3 = 9 ;
commit;

10.2

#3  <signal handler called>
#4  0x00007f2f9f7da428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
#5  0x00007f2f9f7dc02a in __GI_abort () at abort.c:89
#6  0x00007f2f9f7d2bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x556c6b3017c8 "!writer.checksum_len || writer.remains == 0", file=file@entry=0x556c6b2febd0 "/10.2/sql/log.cc", line=line@entry=7090, function=function@entry=0x556c6b3042e0 <MYSQL_BIN_LOG::write_cache(THD*, st_io_cache*)::__PRETTY_FUNCTION__> "int MYSQL_BIN_LOG::write_cache(THD*, IO_CACHE*)") at assert.c:92
#7  0x00007f2f9f7d2c82 in __GI___assert_fail (assertion=0x556c6b3017c8 "!writer.checksum_len || writer.remains == 0", file=0x556c6b2febd0 "/10.2/sql/log.cc", line=7090, function=0x556c6b3042e0 <MYSQL_BIN_LOG::write_cache(THD*, st_io_cache*)::__PRETTY_FUNCTION__> "int MYSQL_BIN_LOG::write_cache(THD*, IO_CACHE*)") at assert.c:101
#8  0x0000556c6aaa855f in MYSQL_BIN_LOG::write_cache (this=0x556c6bd4c260 <mysql_bin_log>, thd=0x7f2f44000af0, cache=0x7f2f44057640) at /10.2/sql/log.cc:7090
#9  0x0000556c6aaaaba3 in MYSQL_BIN_LOG::write_transaction_or_stmt (this=0x556c6bd4c260 <mysql_bin_log>, entry=0x7f2f905f0d90, commit_id=0) at /10.2/sql/log.cc:8132
#10 0x0000556c6aaa9e84 in MYSQL_BIN_LOG::trx_group_commit_leader (this=0x556c6bd4c260 <mysql_bin_log>, leader=0x7f2f905f0d90) at /10.2/sql/log.cc:7848
#11 0x0000556c6aaa97c5 in MYSQL_BIN_LOG::write_transaction_to_binlog_events (this=0x556c6bd4c260 <mysql_bin_log>, entry=0x7f2f905f0d90) at /10.2/sql/log.cc:7649
#12 0x0000556c6aaa8e1f in MYSQL_BIN_LOG::write_transaction_to_binlog (this=0x556c6bd4c260 <mysql_bin_log>, thd=0x7f2f44000af0, cache_mngr=0x7f2f440574a0, end_ev=0x7f2f905f0f50, all=true, using_stmt_cache=false, using_trx_cache=true) at /10.2/sql/log.cc:7323
#13 0x0000556c6aa9a345 in binlog_flush_cache (thd=0x7f2f44000af0, cache_mngr=0x7f2f440574a0, end_ev=0x7f2f905f0f50, all=true, using_stmt=false, using_trx=true) at /10.2/sql/log.cc:1742
#14 0x0000556c6aa9a6bd in binlog_commit_flush_trx_cache (thd=0x7f2f44000af0, all=true, cache_mngr=0x7f2f440574a0) at /10.2/sql/log.cc:1812
#15 0x0000556c6aa9ae39 in binlog_commit (hton=0x556c6d783e00, thd=0x7f2f44000af0, all=true) at /10.2/sql/log.cc:2009
#16 0x0000556c6a99b5c1 in commit_one_phase_2 (thd=0x7f2f44000af0, all=true, trans=0x7f2f44003db8, is_real_trans=true) at /10.2/sql/handler.cc:1604
#17 0x0000556c6a99b4c4 in ha_commit_one_phase (thd=0x7f2f44000af0, all=true) at /10.2/sql/handler.cc:1585
#18 0x0000556c6a99ad8e in ha_commit_trans (thd=0x7f2f44000af0, all=true) at /10.2/sql/handler.cc:1452
#19 0x0000556c6a87ce5b in trans_commit (thd=0x7f2f44000af0) at /10.2/sql/transaction.cc:307
#20 0x0000556c6a71cb65 in mysql_execute_command (thd=0x7f2f44000af0) at /10.2/sql/sql_parse.cc:5307
#21 0x0000556c6a723f65 in mysql_parse (thd=0x7f2f44000af0, rawbuf=0x7f2f44012558 "commit", length=6, parser_state=0x7f2f905f2080, is_com_multi=false, is_next_command=false) at /10.2/sql/sql_parse.cc:7740
#22 0x0000556c6a71223a in dispatch_command (command=COM_QUERY, thd=0x7f2f44000af0, packet=0x7f2f44034581 "commit", packet_length=6, is_com_multi=false, is_next_command=false) at /10.2/sql/sql_parse.cc:1831
#23 0x0000556c6a710b4e in do_command (thd=0x7f2f44000af0) at /10.2/sql/sql_parse.cc:1385
#24 0x0000556c6a86760b in do_handle_one_connection (connect=0x556c6dd5ad20) at /10.2/sql/sql_connect.cc:1336
#25 0x0000556c6a867376 in handle_one_connection (arg=0x556c6dd5ad20) at /10.2/sql/sql_connect.cc:1241
#26 0x0000556c6b08f6da in pfs_spawn_thread (arg=0x556c6d8363d0) at /10.2/storage/perfschema/pfs.cc:1862
#27 0x00007f2fa04176ba in start_thread (arg=0x7f2f905f3700) at pthread_create.c:333
#28 0x00007f2f9f8ac41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Comment by Sujatha Sivakumar (Inactive) [ 2019-12-31 ]

Hello Andrei,

Can you please review the fix for MDEV-18514.

Patch: https://github.com/MariaDB/server/commit/e8d3583fc88ea8c08a94aceba5a21bd5e367c454
BuildBot: http://buildbot.askmonty.org/buildbot/grid?category=main&branch=bb-10.2-sujatha

Thank you.

Comment by Sujatha Sivakumar (Inactive) [ 2020-01-10 ]

Andrei provided his approval over slack.

Review comments: we should aim at dropping the error flag in binlog_cache_data::truncate()

Addressed them.

Comment by Sujatha Sivakumar (Inactive) [ 2020-01-10 ]

Addressed review comments. Cherry-picked changes to higher versions and tested on build bot.

10.3: https://github.com/MariaDB/server/commit/5618b12a4060a52bdb727fd72fdcaef921086e1a
10.4: https://github.com/MariaDB/server/commit/4d31827c9858e033faba64ecc3de00ea48b49abb

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