Skip to content

Instantly share code, notes, and snippets.

@zehweh

zehweh/logs_mysqld_primary.txt Secret

Created March 15, 2022 09:19
Show Gist options
  • Save zehweh/64546eb197b9ab987efa6ab0d8e36b0d to your computer and use it in GitHub Desktop.
Save zehweh/64546eb197b9ab987efa6ab0d8e36b0d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
logs_mysqld_primary.txt
I0315 08:14:53.664636 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:53.664574Z 230 [Note] Aborted connection 230 to db: 'unconnected' user: 'vt_dba' host: 'localhost' (Got an error reading communication packets)
I0315 08:14:53.665108 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:53.665055Z 231 [Note] Aborted connection 231 to db: 'unconnected' user: 'vt_dba' host: 'localhost' (Got an error reading communication packets)
I0315 08:14:53.665499 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:53.665450Z 232 [Note] Aborted connection 232 to db: 'unconnected' user: 'vt_dba' host: 'localhost' (Got an error reading communication packets)
I0315 08:14:53.665845 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:53.665795Z 233 [Note] Aborted connection 233 to db: 'unconnected' user: 'vt_dba' host: 'localhost' (Got an error reading communication packets)
I0315 08:14:53.666267 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:53.666169Z 234 [Note] Aborted connection 234 to db: 'unconnected' user: 'vt_dba' host: 'localhost' (Got an error reading communication packets)
I0315 08:14:53.666670 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:53.666574Z 235 [Note] Aborted connection 235 to db: 'unconnected' user: 'vt_dba' host: 'localhost' (Got an error reading communication packets)
I0315 08:14:53.666988 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:53.666924Z 236 [Note] Aborted connection 236 to db: 'unconnected' user: 'vt_dba' host: 'localhost' (Got an error reading communication packets)
I0315 08:14:53.667396 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:53.667347Z 237 [Note] Aborted connection 237 to db: 'unconnected' user: 'vt_dba' host: 'localhost' (Got an error reading communication packets)
I0315 08:14:53.667747 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:53.667706Z 238 [Note] Aborted connection 238 to db: 'unconnected' user: 'vt_dba' host: 'localhost' (Got an error reading communication packets)
I0315 08:14:53.668192 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:53.668131Z 239 [Note] Aborted connection 239 to db: 'unconnected' user: 'vt_dba' host: 'localhost' (Got an error reading communication packets)
I0315 08:14:55.663784 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:55.663660Z 288 [Note] Got an error reading communication packets
I0315 08:14:56.740645 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:56.740567Z 289 [Note] Aborted connection 289 to db: '_vt' user: 'vt_dba' host: 'localhost' (Got an error reading communication packets)
I0315 08:14:56.808889 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:56.808781Z 290 [Note] Aborted connection 290 to db: '_vt' user: 'vt_dba' host: 'localhost' (Got an error reading communication packets)
I0315 08:14:56.811166 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:56.811095Z 291 [Note] Aborted connection 291 to db: '_vt' user: 'vt_dba' host: 'localhost' (Got an error reading communication packets)
I0315 08:14:57.170955 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: Killed
I0315 08:14:57.181388 1 mysqld.go:404] Mysqld.Start(1647331788) stdout: 2022-03-15T08:14:57.180829Z mysqld_safe Number of processes running now: 0
I0315 08:14:57.181448 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.180829Z mysqld_safe Number of processes running now: 0
I0315 08:14:57.187471 1 mysqld.go:404] Mysqld.Start(1647331788) stdout: 2022-03-15T08:14:57.186909Z mysqld_safe mysqld restarted
I0315 08:14:57.187502 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.186909Z mysqld_safe mysqld restarted
I0315 08:14:57.414836 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.411102Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
I0315 08:14:57.414871 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.413130Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
I0315 08:14:57.414885 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.413171Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.31-log) starting as process 680 ...
I0315 08:14:57.416537 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.416462Z 0 [Note] InnoDB: PUNCH HOLE support available
I0315 08:14:57.416556 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.416483Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
I0315 08:14:57.416564 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.416487Z 0 [Note] InnoDB: Uses event mutexes
I0315 08:14:57.416571 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.416490Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
I0315 08:14:57.416578 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.416492Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
I0315 08:14:57.416585 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.416495Z 0 [Note] InnoDB: Using Linux native AIO
I0315 08:14:57.416969 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.416935Z 0 [Note] InnoDB: Number of pools: 1
I0315 08:14:57.417089 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.417063Z 0 [Note] InnoDB: Using CPU crc32 instructions
I0315 08:14:57.419045 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.418962Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
I0315 08:14:57.428265 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.428205Z 0 [Note] InnoDB: Completed initialization of buffer pool
I0315 08:14:57.430761 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.430687Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
I0315 08:14:57.449335 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.449276Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
I0315 08:14:57.452155 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.452099Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 3332525
I0315 08:14:57.452174 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.452120Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 3332534
I0315 08:14:57.452183 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.452126Z 0 [Note] InnoDB: Database was not shutdown normally!
I0315 08:14:57.452190 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.452131Z 0 [Note] InnoDB: Starting crash recovery.
I0315 08:14:57.478847 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.478748Z 0 [Note] InnoDB: Last MySQL binlog file position 0 1867, file name vt-1728353218-bin.000001
I0315 08:14:57.612385 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.612298Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
I0315 08:14:57.612404 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.612313Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
I0315 08:14:57.612413 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.612365Z 0 [Note] InnoDB: Setting file '/vt/vtdataroot/vt_1728353218/innodb/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
I0315 08:14:57.650006 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.649905Z 0 [Note] InnoDB: File '/vt/vtdataroot/vt_1728353218/innodb/data/ibtmp1' size is now 12 MB.
I0315 08:14:57.651380 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.651320Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
I0315 08:14:57.651400 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.651344Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
I0315 08:14:57.652015 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.651932Z 0 [Note] InnoDB: 5.7.31 started; log sequence number 3332534
I0315 08:14:57.652268 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.652225Z 0 [Note] InnoDB: Loading buffer pool(s) from /vt/vtdataroot/vt_1728353218/innodb/data/ib_buffer_pool
I0315 08:14:57.652596 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.652515Z 0 [Note] Plugin 'FEDERATED' is disabled.
I0315 08:14:57.663879 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.663790Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220315 8:14:57
I0315 08:14:57.663902 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.663870Z 0 [Note] Recovering after a crash using /vt/vtdataroot/vt_1728353218/bin-logs/vt-1728353218-bin
I0315 08:14:57.664184 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.664136Z 0 [Note] Starting crash recovery...
I0315 08:14:57.664198 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.664165Z 0 [Note] Crash recovery finished.
I0315 08:14:57.672303 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.672210Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
I0315 08:14:57.672323 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.672236Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
I0315 08:14:57.673765 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.673678Z 0 [Warning] CA certificate ca.pem is self signed.
I0315 08:14:57.673795 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.673760Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
I0315 08:14:57.674216 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.674137Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
I0315 08:14:57.674234 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.674187Z 0 [Note] IPv6 is available.
I0315 08:14:57.674249 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.674207Z 0 [Note] - '::' resolves to '::';
I0315 08:14:57.674256 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.674231Z 0 [Note] Server socket created on IP: '::'.
I0315 08:14:57.711227 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.711166Z 0 [Note] Event Scheduler: Loaded 0 events
I0315 08:14:57.711470 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.711416Z 0 [Note] /usr/sbin/mysqld: ready for connections.
I0315 08:14:57.711494 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: Version: '5.7.31-log' socket: '/vt/socket/mysql.sock' port: 3306 MySQL Community Server (GPL)
I0315 08:14:57.747251 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:57.747174Z 2 [Note] Aborted connection 2 to db: '_vt' user: 'vt_dba' host: 'localhost' (Got an error reading communication packets)
I0315 08:14:59.663439 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:14:59.663302Z 3 [Note] Got an error reading communication packets
I0315 08:15:01.663922 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:15:01.663797Z 4 [Note] Got an error reading communication packets
I0315 08:15:03.056705 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:15:03.056592Z 8 [Note] Aborted connection 8 to db: 'vt_vitesstest' user: 'vt_dba' host: 'localhost' (Got an error reading communication packets)
I0315 08:15:03.072972 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:15:03.072895Z 9 [Note] Aborted connection 9 to db: 'vt_vitesstest' user: 'vt_dba' host: 'localhost' (Got an error reading communication packets)
I0315 08:15:03.663715 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:15:03.663583Z 12 [Note] Got an error reading communication packets
I0315 08:15:05.663625 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:15:05.663484Z 15 [Note] Got an error reading communication packets
I0315 08:15:07.174721 1 mysqld.go:398] Mysqld.Start(1647331788) stderr: 2022-03-15T08:15:07.174584Z 16 [Note] Start binlog_dump to master_thread_id(16) slave_server(1668038156), pos(, 4)
Raw
logs_vtctld.txt
I0315 08:14:56.722436 1 vtctl.go:2193] *** Using MoveTables v2 flow ***
I0315 08:14:56.726932 1 workflow.go:85] NewVReplicationWorkflow with params &{WorkflowType:0 Workflow:testremote2vitess TargetKeyspace:vitesstest Cells: TabletTypes:primary,replica,rdonly ExcludeTables: EnableReverseReplication:false DryRun:false KeepData:false Timeout:30s Direction:0 SourceKeyspace:testdb Tables: AllTables:true RenameTables:false SourceShards:[] TargetShards:[] SkipSchemaCopy:false AutoStart:true StopAfterCopy:false ExternalCluster:}
I0315 08:14:56.736377 1 traffic_switcher.go:754] Error building targets: no streams found in keyspace vitesstest for testremote2vitess
I0315 08:14:56.736412 1 workflow.go:91] Workflow state is <nil>
I0315 08:14:56.736424 1 workflow.go:126] Workflow state is <nil>
I0315 08:14:56.736432 1 workflow.go:126] Workflow state is <nil>
I0315 08:14:56.736495 1 workflow.go:126] Workflow state is <nil>
I0315 08:14:56.736439 1 workflow.go:395] In VReplicationWorkflow.initMoveTables() for Parameters: &{WorkflowType:0 Workflow:testremote2vitess TargetKeyspace:vitesstest Cells: TabletTypes:primary,replica,rdonly ExcludeTables: EnableReverseReplication:false DryRun:false KeepData:false Timeout:30s Direction:0 SourceKeyspace:testdb Tables: AllTables:true RenameTables:false SourceShards:[] TargetShards:[] SkipSchemaCopy:false AutoStart:true StopAfterCopy:false ExternalCluster:}
State: Not Created
I0315 08:14:56.775405 1 materializer.go:290] got table schemas from source primary cell:"zone1" uid:2282486144.
I0315 08:14:56.775479 1 materializer.go:149] Found tables to move: wp_commentmeta,wp_comments,wp_links,wp_options,wp_postmeta,wp_posts,wp_term_relationships,wp_term_taxonomy,wp_termmeta,wp_terms,wp_usermeta,wp_users
I0315 08:14:56.777644 1 routing_rules.go:47] Saving routing rules map[testdb.wp_commentmeta@rdonly:[testdb.wp_commentmeta] testdb.wp_commentmeta@replica:[testdb.wp_commentmeta] testdb.wp_comments@rdonly:[testdb.wp_comments] testdb.wp_comments@replica:[testdb.wp_comments] testdb.wp_links@rdonly:[testdb.wp_links] testdb.wp_links@replica:[testdb.wp_links] testdb.wp_options@rdonly:[testdb.wp_options] testdb.wp_options@replica:[testdb.wp_options] testdb.wp_postmeta@rdonly:[testdb.wp_postmeta] testdb.wp_postmeta@replica:[testdb.wp_postmeta] testdb.wp_posts@rdonly:[testdb.wp_posts] testdb.wp_posts@replica:[testdb.wp_posts] testdb.wp_term_relationships@rdonly:[testdb.wp_term_relationships] testdb.wp_term_relationships@replica:[testdb.wp_term_relationships] testdb.wp_term_taxonomy@rdonly:[testdb.wp_term_taxonomy] testdb.wp_term_taxonomy@replica:[testdb.wp_term_taxonomy] testdb.wp_termmeta@rdonly:[testdb.wp_termmeta] testdb.wp_termmeta@replica:[testdb.wp_termmeta] testdb.wp_terms@rdonly:[testdb.wp_terms] testdb.wp_terms@replica:[testdb.wp_terms] testdb.wp_usermeta@rdonly:[testdb.wp_usermeta] testdb.wp_usermeta@replica:[testdb.wp_usermeta] testdb.wp_users@rdonly:[testdb.wp_users] testdb.wp_users@replica:[testdb.wp_users] vitesstest.wp_commentmeta:[testdb.wp_commentmeta] vitesstest.wp_commentmeta@rdonly:[testdb.wp_commentmeta] vitesstest.wp_commentmeta@replica:[testdb.wp_commentmeta] vitesstest.wp_comments:[testdb.wp_comments] vitesstest.wp_comments@rdonly:[testdb.wp_comments] vitesstest.wp_comments@replica:[testdb.wp_comments] vitesstest.wp_links:[testdb.wp_links] vitesstest.wp_links@rdonly:[testdb.wp_links] vitesstest.wp_links@replica:[testdb.wp_links] vitesstest.wp_options:[testdb.wp_options] vitesstest.wp_options@rdonly:[testdb.wp_options] vitesstest.wp_options@replica:[testdb.wp_options] vitesstest.wp_postmeta:[testdb.wp_postmeta] vitesstest.wp_postmeta@rdonly:[testdb.wp_postmeta] vitesstest.wp_postmeta@replica:[testdb.wp_postmeta] vitesstest.wp_posts:[testdb.wp_posts] vitesstest.wp_posts@rdonly:[testdb.wp_posts] vitesstest.wp_posts@replica:[testdb.wp_posts] vitesstest.wp_term_relationships:[testdb.wp_term_relationships] vitesstest.wp_term_relationships@rdonly:[testdb.wp_term_relationships] vitesstest.wp_term_relationships@replica:[testdb.wp_term_relationships] vitesstest.wp_term_taxonomy:[testdb.wp_term_taxonomy] vitesstest.wp_term_taxonomy@rdonly:[testdb.wp_term_taxonomy] vitesstest.wp_term_taxonomy@replica:[testdb.wp_term_taxonomy] vitesstest.wp_termmeta:[testdb.wp_termmeta] vitesstest.wp_termmeta@rdonly:[testdb.wp_termmeta] vitesstest.wp_termmeta@replica:[testdb.wp_termmeta] vitesstest.wp_terms:[testdb.wp_terms] vitesstest.wp_terms@rdonly:[testdb.wp_terms] vitesstest.wp_terms@replica:[testdb.wp_terms] vitesstest.wp_usermeta:[testdb.wp_usermeta] vitesstest.wp_usermeta@rdonly:[testdb.wp_usermeta] vitesstest.wp_usermeta@replica:[testdb.wp_usermeta] vitesstest.wp_users:[testdb.wp_users] vitesstest.wp_users@rdonly:[testdb.wp_users] vitesstest.wp_users@replica:[testdb.wp_users] wp_commentmeta:[testdb.wp_commentmeta] wp_commentmeta@rdonly:[testdb.wp_commentmeta] wp_commentmeta@replica:[testdb.wp_commentmeta] wp_comments:[testdb.wp_comments] wp_comments@rdonly:[testdb.wp_comments] wp_comments@replica:[testdb.wp_comments] wp_links:[testdb.wp_links] wp_links@rdonly:[testdb.wp_links] wp_links@replica:[testdb.wp_links] wp_options:[testdb.wp_options] wp_options@rdonly:[testdb.wp_options] wp_options@replica:[testdb.wp_options] wp_postmeta:[testdb.wp_postmeta] wp_postmeta@rdonly:[testdb.wp_postmeta] wp_postmeta@replica:[testdb.wp_postmeta] wp_posts:[testdb.wp_posts] wp_posts@rdonly:[testdb.wp_posts] wp_posts@replica:[testdb.wp_posts] wp_term_relationships:[testdb.wp_term_relationships] wp_term_relationships@rdonly:[testdb.wp_term_relationships] wp_term_relationships@replica:[testdb.wp_term_relationships] wp_term_taxonomy:[testdb.wp_term_taxonomy] wp_term_taxonomy@rdonly:[testdb.wp_term_taxonomy] wp_term_taxonomy@replica:[testdb.wp_term_taxonomy] wp_termmeta:[testdb.wp_termmeta] wp_termmeta@rdonly:[testdb.wp_termmeta] wp_termmeta@replica:[testdb.wp_termmeta] wp_terms:[testdb.wp_terms] wp_terms@rdonly:[testdb.wp_terms] wp_terms@replica:[testdb.wp_terms] wp_usermeta:[testdb.wp_usermeta] wp_usermeta@rdonly:[testdb.wp_usermeta] wp_usermeta@replica:[testdb.wp_usermeta] wp_users:[testdb.wp_users] wp_users@rdonly:[testdb.wp_users] wp_users@replica:[testdb.wp_users]]
Raw
logs_vttablet_primary.txt
I0315 08:14:56.740577 1 rpc_server.go:84] TabletManager.VReplicationExec(query:"select id, source, message, cell, tablet_types from _vt.vreplication where workflow='testremote2vitess' and db_name='vt_vitesstest'")(on zone1-1728353218 from ): (*tabletmanagerdata.VReplicationExecResponse)(nil)
I0315 08:14:56.808795 1 rpc_server.go:84] TabletManager.VReplicationExec(query:"select 1 from _vt.vreplication where db_name='vt_vitesstest' and workflow='testremote2vitess'")(on zone1-1728353218 from ): (*tabletmanagerdata.VReplicationExecResponse)(nil)
I0315 08:14:56.811104 1 rpc_server.go:84] TabletManager.VReplicationExec(query:"select 1 from _vt.vreplication where db_name='vt_vitesstest' and message='FROZEN'")(on zone1-1728353218 from ): (*tabletmanagerdata.VReplicationExecResponse)(nil)
I0315 08:14:56.844657 1 mysqld.go:590] execCmd: /usr/bin/mysql /usr/bin/mysql [--defaults-extra-file=/tmp/example340506473 --batch]
I0315 08:14:56.882345 1 mysqld.go:604] execCmd: /usr/bin/mysql output:
W0315 08:14:57.170556 1 rpc_server.go:80] TabletManager.ApplySchema(sql:"CREATE TABLE `wp_commentmeta` (\n `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `comment_id` bigint unsigned NOT NULL DEFAULT '0',\n `meta_key` varchar(255) DEFAULT NULL,\n `meta_value` longtext,\n PRIMARY KEY (`meta_id`),\n KEY `comment_id` (`comment_id`),\n KEY `meta_key` (`meta_key`(191))\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;\nCREATE TABLE `wp_comments` (\n `comment_ID` bigint unsigned NOT NULL AUTO_INCREMENT,\n `comment_post_ID` bigint unsigned NOT NULL DEFAULT '0',\n `comment_author` tinytext NOT NULL,\n `comment_author_email` varchar(100) NOT NULL DEFAULT '',\n `comment_author_url` varchar(200) NOT NULL DEFAULT '',\n `comment_author_IP` varchar(100) NOT NULL DEFAULT '',\n `comment_date` datetime NOT NULL DEFAULT '2010-01-01 10:10:10',\n `comment_date_gmt` datetime NOT NULL DEFAULT '2010-01-01 10:10:10',\n `comment_content` text NOT NULL,\n `comment_karma` int NOT NULL DEFAULT '0',\n `comment_approved` varchar(20) NOT NULL DEFAULT '1',\n `comment_agent` varchar(255) NOT NULL DEFAULT '',\n `comment_type` varchar(20) NOT NULL DEFAULT '',\n `comment_parent` bigint unsigned NOT NULL DEFAULT '0',\n `user_id` bigint unsigned NOT NULL DEFAULT '0',\n PRIMARY KEY (`comment_ID`),\n KEY `comment_post_ID` (`comment_post_ID`),\n KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),\n KEY `comment_date_gmt` (`comment_date_gmt`),\n KEY `comment_parent` (`comment_parent`),\n KEY `comment_author_email` (`comment_author_email`(10))\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;\nCREATE TABLE `wp_links` (\n `link_id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `link_url` varchar(255) NOT NULL DEFAULT '',\n `link_name` varchar(255) NOT NULL DEFAULT '',\n `link_image` varchar(255) NOT NULL DEFAULT '',\n `link_target` varchar(25) NOT NULL DEFAULT '',\n `link_category` bigint NOT NULL DEFAULT '0',\n `link_description` varchar(255) NOT NULL DEFAULT '',\n `link_visible` varchar(20) NOT NULL DEFAULT 'Y',\n `link_owner` bigint unsigned NOT NULL DEFAULT '1',\n `link_rating` int NOT NULL DEFAULT '0',\n `link_updated` datetime NOT NULL DEFAULT '2010-01-01 10:10:10',\n `link_rel` varchar(255) NOT NULL DEFAULT '',\n `link_notes` mediumtext NOT NULL,\n `link_rss` varchar(255) NOT NULL DEFAULT '',\n PRIMARY KEY (`link_id`),\n KEY `link_category` (`link_category`),\n KEY `link_visible` (`link_visible`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;\nCREATE TABLE `wp_options` (\n `option_id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `option_name` varchar(191) NOT NULL DEFAULT '',\n `option_value` longtext NOT NULL,\n `autoload` varchar(20) NOT NULL DEFAULT 'yes',\n PRIMARY KEY (`option_id`,`option_name`),\n UNIQUE KEY `option_name` (`option_name`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;\nCREATE TABLE `wp_postmeta` (\n `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `post_id` bigint unsigned NOT NULL DEFAULT '0',\n `meta_key` varchar(255) DEFAULT NULL,\n `meta_value` longtext,\n PRIMARY KEY (`meta_id`),\n KEY `post_id` (`post_id`),\n KEY `meta_key` (`meta_key`(191))\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;\nCREATE TABLE `wp_posts` (\n `ID` bigint unsigned NOT NULL AUTO_INCREMENT,\n `post_author` bigint unsigned NOT NULL DEFAULT '0',\n `post_date` datetime NOT NULL DEFAULT '2010-01-01 10:10:10',\n `post_date_gmt` datetime NOT NULL DEFAULT '2010-01-01 10:10:10',\n `post_content` longtext NOT NULL,\n `post_title` text NOT NULL,\n `post_category` int NOT NULL DEFAULT '0',\n `post_excerpt` text NOT NULL,\n `post_status` varchar(20) NOT NULL DEFAULT 'publish',\n `comment_status` varchar(20) NOT NULL DEFAULT 'open',\n `ping_status` varchar(20) NOT NULL DEFAULT 'open',\n `post_password` varchar(255) NOT NULL DEFAULT '',\n `post_name` varchar(200) NOT NULL DEFAULT '',\n `to_ping` text NOT NULL,\n `pinged` text NOT NULL,\n `post_modified` datetime NOT NULL DEFAULT '2010-01-01 10:10:10',\n `post_modified_gmt` datetime NOT NULL DEFAULT '2010-01-01 10:10:10',\n `post_content_filtered` longtext NOT NULL,\n `post_parent` bigint unsigned NOT NULL DEFAULT '0',\n `guid` varchar(255) NOT NULL DEFAULT '',\n `menu_order` int NOT NULL DEFAULT '0',\n `post_type` varchar(20) NOT NULL DEFAULT 'post',\n `post_mime_type` varchar(100) NOT NULL DEFAULT '',\n `comment_count` bigint NOT NULL DEFAULT '0',\n PRIMARY KEY (`ID`),\n KEY `type_status_date` (`post_type`,`post_status`(1),`post_date`,`ID`),\n KEY `post_parent` (`post_parent`),\n KEY `post_author` (`post_author`),\n KEY `post_name` (`post_name`(191))\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;\nCREATE TABLE `wp_term_relationships` (\n `object_id` bigint unsigned NOT NULL DEFAULT '0',\n `term_taxonomy_id` bigint unsigned NOT NULL DEFAULT '0',\n `term_order` int NOT NULL DEFAULT '0',\n PRIMARY KEY (`object_id`,`term_taxonomy_id`),\n KEY `term_taxonomy_id` (`term_taxonomy_id`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;\nCREATE TABLE `wp_term_taxonomy` (\n `term_taxonomy_id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `term_id` bigint unsigned NOT NULL DEFAULT '0',\n `taxonomy` varchar(32) NOT NULL DEFAULT '',\n `description` longtext NOT NULL,\n `parent` bigint unsigned NOT NULL DEFAULT '0',\n `count` bigint NOT NULL DEFAULT '0',\n PRIMARY KEY (`term_taxonomy_id`),\n UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),\n KEY `taxonomy` (`taxonomy`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;\nCREATE TABLE `wp_termmeta` (\n `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `term_id` bigint unsigned NOT NULL DEFAULT '0',\n `meta_key` varchar(255) DEFAULT NULL,\n `meta_value` longtext,\n PRIMARY KEY (`meta_id`),\n KEY `term_id` (`term_id`),\n KEY `meta_key` (`meta_key`(191))\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;\nCREATE TABLE `wp_terms` (\n `term_id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `name` varchar(200) NOT NULL DEFAULT '',\n `slug` varchar(200) NOT NULL DEFAULT '',\n `term_group` bigint NOT NULL DEFAULT '0',\n PRIMARY KEY (`term_id`),\n KEY `name` (`name`(191)),\n KEY `slug` (`slug`(191))\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;\nCREATE TABLE `wp_usermeta` (\n `umeta_id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `user_id` bigint unsigned NOT NULL DEFAULT '0',\n `meta_key` varchar(255) DEFAULT NULL,\n `meta_value` longtext,\n PRIMARY KEY (`umeta_id`),\n KEY `user_id` (`user_id`),\n KEY `meta_key` (`meta_key`(191))\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;\nCREATE TABLE `wp_users` (\n `ID` bigint unsigned NOT NULL AUTO_INCREMENT,\n `user_login` varchar(60) NOT NULL DEFAULT '',\n `user_pass` varchar(255) NOT NULL DEFAULT '',\n `user_nicename` varchar(50) NOT NULL DEFAULT '',\n `user_email` varchar(100) NOT NULL DEFAULT '',\n `user_url` varchar(100) NOT NULL DEFAULT '',\n `user_registered` datetime NOT NULL DEFAULT '2010-01-01 10:10:10',\n `user_activation_key` varchar(255) NOT NULL DEFAULT '',\n `user_status` int NOT NULL DEFAULT '0',\n `display_name` varchar(250) NOT NULL DEFAULT '',\n PRIMARY KEY (`ID`),\n KEY `user_login_key` (`user_login`),\n KEY `user_nicename` (`user_nicename`),\n KEY `user_email` (`user_email`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1" allow_replication:true)(on zone1-1728353218 from ) error: EOF (errno 2013) (sqlstate HY000) during query: SELECT
table_name AS table_name,
ordinal_position AS ordinal_position,
column_name AS column_name
FROM information_schema.key_column_usage
WHERE table_schema = 'vt_vitesstest'
AND table_name IN ('wp_commentmeta', 'wp_comments', 'wp_links', 'wp_options', 'wp_postmeta', 'wp_posts', 'wp_term_relationships', 'wp_term_taxonomy', 'wp_termmeta', 'wp_terms', 'wp_usermeta', 'wp_users')
AND constraint_name='PRIMARY'
ORDER BY table_name, ordinal_position
EOF (errno 2013) (sqlstate HY000) during query: SELECT * FROM `vt_vitesstest`.`wp_links` WHERE 1=0
EOF (errno 2013) (sqlstate HY000) during query: SELECT * FROM `vt_vitesstest`.`wp_posts` WHERE 1=0
EOF (errno 2013) (sqlstate HY000) during query: SELECT * FROM `vt_vitesstest`.`wp_term_relationships` WHERE 1=0
EOF (errno 2013) (sqlstate HY000) during query: SHOW CREATE TABLE `vt_vitesstest`.`wp_comments`
EOF (errno 2013) (sqlstate HY000) during query: SHOW CREATE TABLE `vt_vitesstest`.`wp_postmeta`
EOF (errno 2013) (sqlstate HY000) during query: SHOW CREATE TABLE `vt_vitesstest`.`wp_term_taxonomy`
EOF (errno 2013) (sqlstate HY000) during query: SHOW CREATE TABLE `vt_vitesstest`.`wp_termmeta`
context canceled
I0315 08:14:57.747207 1 rpc_server.go:84] TabletManager.VReplicationExec(query:"select distinct workflow from _vt.vreplication where state != 'Stopped' and db_name = 'vt_vitesstest'")(on zone1-1728353218 from ): (*tabletmanagerdata.VReplicationExecResponse)(nil)
Raw
vitess_cluster.yaml
# The following example is minimalist. The security policies
# and resource specifications are not meant to be used in production.
# Please refer to the operator documentation for recommendations on
# production settings.
apiVersion: planetscale.com/v2
kind: VitessCluster
metadata:
name: test
spec:
images:
vtctld: vitess/lite:v12.0.0
vtctld: vitess/lite:v12.0.0
vtgate: vitess/lite:v12.0.0
vttablet: vitess/lite:v12.0.0
vtbackup: vitess/lite:v12.0.0
mysqld:
mysql56Compatible: vitess/lite:v12.0.0
mysqldExporter: prom/mysqld-exporter:v0.11.0
cells:
- name: zone1
gateway:
authentication:
static:
secret:
name: example-cluster-config
key: users.json
replicas: 1
resources:
requests:
cpu: 100m
memory: 256Mi
limits:
memory: 256Mi
vitessDashboard:
cells:
- zone1
extraFlags:
security_policy: read-only
replicas: 1
resources:
limits:
memory: 128Mi
requests:
cpu: 100m
memory: 128Mi
keyspaces:
- name: testdb
turndownPolicy: Immediate
databaseName: testdb
partitionings:
- equal:
parts: 1
shardTemplate:
databaseInitScriptSecret:
name: example-cluster-config
key: init_db.sql
replication:
enforceSemiSync: false
initializeBackup: false
tabletPools:
- cell: zone1
type: externalmaster
replicas: 1
vttablet:
extraFlags:
db_charset: utf8mb4
resources:
requests:
cpu: 50m
memory: 64Mi
externalDatastore:
user: root
host: 10.244.3.216
port: 3306
database: testdb
credentialsSecret:
name: example-cluster-config
key: external_users.json
- name: vitesstest
turndownPolicy: Immediate
vitessOrchestrator:
configSecret:
name: example-cluster-config
key: orc_config.json
resources:
limits:
memory: 128Mi
requests:
cpu: 100m
memory: 128Mi
partitionings:
- equal:
parts: 1
shardTemplate:
databaseInitScriptSecret:
name: example-cluster-config
key: init_db.sql
replication:
enforceSemiSync: false
tabletPools:
- cell: zone1
type: replica
replicas: 2
vttablet:
extraFlags:
db_charset: utf8mb4
disable_active_reparents: "true"
enable_semi_sync: "false"
resources:
limits:
memory: 256Mi
requests:
cpu: 100m
memory: 256Mi
mysqld:
resources:
limits:
memory: 256Mi
requests:
cpu: 100m
memory: 256Mi
dataVolumeClaimTemplate:
accessModes: ["ReadWriteOnce"]
resources:
requests:
storage: 10Gi
updateStrategy:
type: Immediate
---
apiVersion: v1
kind: Secret
metadata:
name: example-cluster-config
type: Opaque
stringData:
external_users.json: |
{
"root": ["root"]
}
users.json: |
{
"user": [{
"UserData": "user",
"Password": ""
}]
}
init_db.sql: |
# This file is executed immediately after mysql_install_db,
# to initialize a fresh data directory.
###############################################################################
# Equivalent of mysql_secure_installation
###############################################################################
# Changes during the init db should not make it to the binlog.
# They could potentially create errant transactions on replicas.
SET sql_log_bin = 0;
# Remove anonymous users.
DELETE FROM mysql.user WHERE User = '';
# Disable remote root access (only allow UNIX socket).
DELETE FROM mysql.user WHERE User = 'root' AND Host != 'localhost';
# Remove test database.
DROP DATABASE IF EXISTS test;
###############################################################################
# Vitess defaults
###############################################################################
# Vitess-internal database.
CREATE DATABASE IF NOT EXISTS _vt;
# Note that definitions of local_metadata and shard_metadata should be the same
# as in production which is defined in go/vt/mysqlctl/metadata_tables.go.
CREATE TABLE IF NOT EXISTS _vt.local_metadata (
name VARCHAR(255) NOT NULL,
value VARCHAR(255) NOT NULL,
db_name VARBINARY(255) NOT NULL,
PRIMARY KEY (db_name, name)
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS _vt.shard_metadata (
name VARCHAR(255) NOT NULL,
value MEDIUMBLOB NOT NULL,
db_name VARBINARY(255) NOT NULL,
PRIMARY KEY (db_name, name)
) ENGINE=InnoDB;
# Admin user with all privileges.
CREATE USER 'vt_dba'@'localhost';
GRANT ALL ON *.* TO 'vt_dba'@'localhost';
GRANT GRANT OPTION ON *.* TO 'vt_dba'@'localhost';
# User for app traffic, with global read-write access.
CREATE USER 'vt_app'@'localhost';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, FILE,
REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES,
LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW,
SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER
ON *.* TO 'vt_app'@'localhost';
# User for app debug traffic, with global read access.
CREATE USER 'vt_appdebug'@'localhost';
GRANT SELECT, SHOW DATABASES, PROCESS ON *.* TO 'vt_appdebug'@'localhost';
# User for administrative operations that need to be executed as non-SUPER.
# Same permissions as vt_app here.
CREATE USER 'vt_allprivs'@'localhost';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, FILE,
REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES,
LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW,
SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER
ON *.* TO 'vt_allprivs'@'localhost';
# User for slave replication connections.
# TODO: Should we set a password on this since it allows remote connections?
CREATE USER 'vt_repl'@'%';
GRANT REPLICATION SLAVE ON *.* TO 'vt_repl'@'%';
# User for Vitess filtered replication (binlog player).
# Same permissions as vt_app.
CREATE USER 'vt_filtered'@'localhost';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, FILE,
REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES,
LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW,
SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER
ON *.* TO 'vt_filtered'@'localhost';
# User for Orchestrator (https://github.com/openark/orchestrator).
# TODO: Reenable when the password is randomly generated.
CREATE USER 'orc_client_user'@'%' IDENTIFIED BY 'orc_client_user_password';
GRANT SUPER, PROCESS, REPLICATION SLAVE, RELOAD
ON *.* TO 'orc_client_user'@'%';
GRANT SELECT
ON _vt.* TO 'orc_client_user'@'%';
FLUSH PRIVILEGES;
RESET SLAVE ALL;
RESET MASTER;
orc_config.json: |
{
"Debug": true,
"Durability": "none",
"MySQLTopologyUser": "orc_client_user",
"MySQLTopologyPassword": "orc_client_user_password",
"MySQLReplicaUser": "vt_repl",
"MySQLReplicaPassword": "",
"RecoveryPeriodBlockSeconds": 5
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment