Wednesday, May 29, 2019

[google-cloud-sql-discuss] Timeout Errors connecting to a Google Cloud SQL instance from a webpage

textPayload,insertId,resource.type,resource.labels.project_id,resource.labels.database_id,resource.labels.region,timestamp,severity,logName,receiveTimestamp
innodb_buffer_pool_load_at_startup=ON,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@ad,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.557423Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
innodb_file_format=Barracuda,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@ae,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.557655Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
innodb_file_per_table=ON,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@af,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.557854Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
innodb_flushing_avg_loops=5,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@ag,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.558030Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
innodb_flush_method=O_DIRECT,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@ah,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.558203Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
innodb_flush_neighbors=2,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@ai,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.564601Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
innodb_io_capacity=5000,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@aj,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.564998Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
innodb_log_file_size=512M,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@ak,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.565213Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
innodb_lru_scan_depth=2048,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@al,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.565404Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
innodb_monitor_enable=all,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@am,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.568951Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
innodb_page_cleaners=8,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@an,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.569204Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
master_info_repository=TABLE,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@ao,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.569403Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
max_binlog_size=104857600 # 100 MB,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@ap,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.574701Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
memlock=true,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@aq,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.575004Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
performance_schema=OFF,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@ar,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.575193Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
pid_file=/mysql/mysql.pid,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@as,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.575403Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
relay_log_info_repository=TABLE,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@at,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.576672Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
relay_log=/mysql/relaylog/relay-log,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@au,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.576922Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
relay_log_recovery=ON,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@av,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.577105Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
"require_super_for_system_table_writes=event,func,plugin,proc,heartbeat",s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@aw,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.577288Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
reserved_super_connections=20,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@ax,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.577470Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
rpl_semi_sync_master_async_notify_socket=/semisync/semisync.sock,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@ay,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.581809Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
rpl_semi_sync_master_do_async_notify=ON,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@az,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.582082Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
rpl_semi_sync_master_enabled=1,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@b10,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.582267Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
rpl_semi_sync_master_timeout=3000 # 3 second,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@b11,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.582461Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
rpl_semi_sync_master_wait_point=AFTER_SYNC,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@b12,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.583791Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
secure_file_priv=/mysql/tmp,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@b13,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.584017Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
skip_name_resolve=ON,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@b14,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.584219Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
slave_net_timeout=30,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@b15,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.584401Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
slow_query_log_file=/mysql/logs/slow.log,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@b16,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.590760Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
socket=/mysql/mysql.sock,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@b17,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.591057Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
ssl_ca=/mysql/datadir/client_ca_cert.pem,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@b18,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.591251Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
ssl_cert=/mysql/datadir/server_cert.pem,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@b19,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.591431Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
ssl_cipher=ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@b1a,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.593776Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
ssl_key=/mysql/datadir/server_pkey.pem,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@b1b,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.594016Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
sync_binlog=1,s=45471ca64e5d41ba8e617e8a1780d267;i=42c6fd;b=b59693f07e96460799643fad0cd0fe81;m=fb7076d43f;t=589f54e151ce8;x=3ad55d472d1bae99-0@b1c,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.594281Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.545334627Z
system_user_table=true,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@a1,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.594461Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
tmpdir=/mysql/tmp,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@a2,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.595680Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
max_allowed_packet=64553,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@a3,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.595879Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
wait_timeout=31536000,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@a4,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.596063Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
log_bin=/mysql/binlog/mysql-bin,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@a5,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.596243Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
gtid_mode=ON,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@a6,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.596417Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
log_slave_updates=ON,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@a7,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.603867Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
enforce_gtid_consistency=ON,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@a8,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.604136Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
server-id=3294777933,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@a9,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.604327Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
innodb_buffer_pool_size=1376711884,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@aa,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.604509Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
innodb_buffer_pool_instances=1,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@ab,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.605533Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
max_connections=4030,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@ac,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.606823Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
enforce_storage_engine=Innodb,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@ad,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.607019Z,INFO,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:13.750206Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@ae,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.752737Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:13.750434Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@af,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.753175Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:13.750472Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.14-google-log) starting as process 1 ...,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@ag,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.753369Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:13.761535Z 0 [Note] Plugin 'AUDIT_LOG' is disabled.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@ah,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.762655Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:13.763233Z 0 [Note] Plugin 'FEDERATED' is disabled.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@ai,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.763339Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:13.764144Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@aj,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.764260Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:13.765126Z
0 [Note] InnoDB: PUNCH HOLE support not available,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@ak,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.765236Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:13.765587Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@al,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.765685Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:13.765950Z 0 [Note] InnoDB: Uses event mutexes,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@am,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.766033Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:13.766268Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@an,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.766350Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:13.766606Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@ao,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.766686Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:13.766938Z 0 [Note] InnoDB: Using Linux native AIO,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@ap,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.767019Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:13.777836Z 0 [Note] InnoDB: Number of pools: 1,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@aq,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.778102Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:13.778800Z 0 [Note] InnoDB: Using CPU crc32 instructions,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@ar,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.778939Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
"2019-05-28T16:39:13.782067Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1.375G, instances = 1, chunk size = 128M",s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@as,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:13.782249Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:14.023417Z 0 [Note] InnoDB: Completed initialization of buffer pool,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@at,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.023777Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
"2019-05-28T16:39:14.202336Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().",s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@au,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.202744Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:14.227509Z 0 [Note] InnoDB: Highest supported file format is Barracuda.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c72f;b=b59693f07e96460799643fad0cd0fe81;m=fb707777b4;t=589f54e15c05d;x=203271d8530a5aed-0@av,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.227858Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:19.828229240Z
2019-05-28T16:39:14.500316Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@a1,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.500741Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.505354Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@a2,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.505657Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.705627Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@a3,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.705994Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.707524Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@a4,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.707793Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.708193Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@a5,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.708301Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.709097Z 0 [Note] InnoDB: Waiting for purge to start,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@a6,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.709260Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.760527Z 0 [Note] InnoDB: 5.7.14 started; log sequence number 2418068343,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@a7,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.760964Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.763574Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql/datadir/ib_buffer_pool,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@a8,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.763831Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.768417Z 0 [Note] Semi-sync replication initialized for transactions.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@a9,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.768679Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.769125Z 0 [Note] Semi-sync replication enabled on the master.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@aa,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.769263Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
"2019-05-28T16:39:14.837114Z 0 [Note] Skip crash recovery, binlog file '/mysql/binlog/mysql-bin.000020' size: 217",s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@ab,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.837403Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.839080Z 0 [Note] Starting ack receiver thread,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@ac,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.839306Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.853059Z 0 [Note] Found gtids in binlog: '7017ee11-4f80-11e9-83f7-42010a8002c4:1-5454264',s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@ad,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.853418Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.854154Z 0 [Note] Found gtids purged from binlog: '7017ee11-4f80-11e9-83f7-42010a8002c4:1-4749079',s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@ae,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.854375Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.857660Z 0 [Note] Skipping generation of SSL certificates as options related to SSL are specified.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@af,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.857898Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.863237Z 0 [Warning] CA certificate /mysql/datadir/client_ca_cert.pem is self signed.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@ag,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.863518Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.864017Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@ah,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.864181Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.865478Z 0 [Note] Server hostname (bind-address): '*'; port: 3306,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@ai,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.865640Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.865973Z 0 [Note] IPv6 is available.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@aj,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.866077Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.866354Z 0 [Note] - '::' resolves to '::';,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@ak,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.866450Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.866733Z 0 [Note] Server socket created on IP: '::'.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@al,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.866829Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.879793Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@am,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.880145Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.880695Z 0 [Warning] 'user' entry 'cloudsqlimport@localhost' ignored in --skip-name-resolve mode.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@an,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.880873Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
"2019-05-28T16:39:14.881150Z 0 [Note] Loaded users from system_user table: root@localhost,cloudsqlreplica@%,cloudsqlimport@localhost.",s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@ao,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.881251Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.881594Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190528 16:39:14,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@ap,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.881733Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.882179Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@aq,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.882319Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.884118Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@ar,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.884881Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.903266Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@as,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.903616Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.919999Z 0 [Note] Event Scheduler: Loaded 0 events,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@at,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.920313Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
2019-05-28T16:39:14.921108Z 0 [Note] /usr/sbin/mysqld: ready for connections.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@au,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.921298Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
Version: '5.7.14-google-log' socket: '/mysql/mysql.sock' port: 3306 (Google),s=45471ca64e5d41ba8e617e8a1780d267;i=42c761;b=b59693f07e96460799643fad0cd0fe81;m=fb70854bdc;t=589f54e239485;x=2ae451af1ada7932-0@av,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:14.921626Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:21.505531864Z
"2019-05-28T16:39:17.938738Z 2 [Warning] Timeout waiting for reply of binlog (file: mysql-bin.000021, pos: 479), semi-sync up to file , position 0.",s=45471ca64e5d41ba8e617e8a1780d267;i=42c7d3;b=b59693f07e96460799643fad0cd0fe81;m=fb70b9c28d;t=589f54e580b35;x=56a6720d3375b054-0@a1,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:17.938997Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:24.341155485Z
2019-05-28T16:39:17.939611Z 2 [Note] Semi-sync replication switched OFF.,s=45471ca64e5d41ba8e617e8a1780d267;i=42c7d3;b=b59693f07e96460799643fad0cd0fe81;m=fb70b9c28d;t=589f54e580b35;x=56a6720d3375b054-0@a2,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-28T16:39:17.940340Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-28T16:39:24.341155485Z
2019-05-29T15:22:47.304818Z 7226 [Note] Aborted connection 7226 to db: 'unconnected' user: 'root' host: '35.243.138.86' (Got an error reading communication packets),s=45471ca64e5d41ba8e617e8a1780d267;i=440935;b=b59693f07e96460799643fad0cd0fe81;m=10e7cf19faa;t=58a085a8fe852;x=e32ae4dc3a0f585f-0@a1,cloudsql_database,galvanic-ward-235617,galvanic-ward-235617:ontimeserver01,us-central,2019-05-29T15:22:47.305298Z,ERROR,projects/galvanic-ward-235617/logs/cloudsql.googleapis.com%2Fmysql.err,2019-05-29T15:22:52.601869056Z
I am seeing a number of timeout errors from our external web application (a Question2Answer site). The errors are attached and I've tried the following items already.

Added 4 database flags related to timeouts
Verified that my user has full resource access using SequelPro client
Verified that my user can create tables, etc from the SequelPro client
Enabled access to the IP address associated with the website and an IP address found in the logs
Researched the various connection issues associated with mysql
Confirmed that I can use an alternate mysql db connection from the web application
Verified that the instance public IP accessibility is configured and working
Noted that some additional error messages appear in the logs and attached

I am hoping someone can provide additional insight on how to resolve the connectivity issue from my networksolutions hosted website to my GCS instance.


Thanks in advance,
Tom

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/f3591a07-4c20-4a78-b71e-08b109b2cf70%40googlegroups.com.

No comments:

Post a Comment