mysql connecting error Code: 2004 Message: Can't create TCP/IP socket (97 "Address family not supported by protocol")

297 views
Skip to first unread message

Chris Deng

unread,
Feb 7, 2018, 9:08:32 PM2/7/18
to Google Cloud SQL discuss
Hi,

From Feb 2,  mysql error started to appear in Sigma log as below, while no package change has been made, it(borgcron job) runs well before,
and no error either when test from local host, any idea what's the cause? could you help with this? Thanks


mysql:173.194.249.18.


Errors connecting to database returned: 1
*****
Code: 2004
Message: Can't create TCP/IP socket (97 "Address family not supported by protocol")
# by query "INSERT INTO ipdb_audit (netblock,tags,vlan_id,building,prefixlen,attributes,...


python code
with dragonwell_db.DragonwellDbConn() as db:
      db.Insert(data, _AUDIT_TABLE, update_dupes=True)
      db.Insert(stats_data, _AUDIT_STATS_TABLE, update_dupes=True)

Kamran (Google Cloud Support)

unread,
Feb 8, 2018, 8:37:36 PM2/8/18
to Google Cloud SQL discuss

Hello Chris,

In order to investigate this issue, I'd recommend reporting this on GCP issue tracker.

Chris Deng

unread,
Feb 9, 2018, 9:32:44 AM2/9/18
to Google Cloud SQL discuss
Thanks, while neither I nor my colleague can access the bug component(Cloud SQL issue) to raise a bug
Reply all
Reply to author
Forward
0 new messages