Sorry about the confusion.The logs you pasted indicate that MySQL is working properly.The fact that they are marked with "error" severity is a bug.On Fri, Jun 3, 2016 at 2:30 AM Pavlo Maksymchuk <pa...@solidstategroup.com> wrote:Hi RupeshThank you for your suggestion.Have tried setting root password using console. Password was set successfully however issue still exist, Failed to load users.Below is sql trace log. Even though it shows as error it has annotation as a note or warning. Does not explain much.15:16:27.723 + ROOT=/mysql
15:16:27.724 + cat /mysql/my.cnf
15:16:27.734
+ exec /usr/sbin/mysqld --defaults-file=/mysql/my.cnf
15:16:27.749
2016-06-02 14:16:27 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_
timestamp server option (see documentation for more details). 15:16:27.750
2016-06-02 14:16:27 0 [Note] /usr/sbin/mysqld (mysqld 5.6.29-google) starting as process 1 ...
15:16:27.752
2016-06-02 14:16:27 1 [Warning] You need to use --log-bin to make --binlog-format work.
15:16:27.753
2016-06-02 14:16:27 1 [Note] Plugin 'FEDERATED' is disabled.
15:16:27.753
2016-06-02 14:16:27 1 [Note] Semi-sync replication initialized for transactions.
15:16:27.754
2016-06-02 14:16:27 1 [Note] Semi-sync replication enabled on the master.
15:16:27.967
2016-06-02 14:16:27 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
15:16:27.968
2016-06-02 14:16:27 1 [Note] InnoDB: The InnoDB memory heap is disabled
15:16:27.968
2016-06-02 14:16:27 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
15:16:27.968
2016-06-02 14:16:27 1 [Note] InnoDB: Memory barrier is not used
15:16:27.968
2016-06-02 14:16:27 1 [Note] InnoDB: Compressed tables use zlib 1.2.8
15:16:27.968
2016-06-02 14:16:27 1 [Note] InnoDB: Using Linux native AIO
15:16:27.970
2016-06-02 14:16:27 1 [Note] InnoDB: Using CPU crc32 instructions
15:16:27.972
2016-06-02 14:16:27 1 [Note] InnoDB: Initializing buffer pool, size = 1.8G
15:16:28.176
2016-06-02 14:16:28 1 [Note] InnoDB: Completed initialization of buffer pool
15:16:28.237
2016-06-02 14:16:28 1 [Note] InnoDB: Highest supported file format is Barracuda.
15:16:28.270
2016-06-02 14:16:28 1 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*32768 pages, LSN=1625987
15:16:28.275
2016-06-02 14:16:28 1 [Warning] InnoDB: Starting to delete and rewrite log files.
15:16:28.284
2016-06-02 14:16:28 1 [Note] InnoDB: Setting log file ./ib_logfile101 size to 512 MB
15:16:30.623
InnoDB: Progress in MB: 100 200 300 400 500
15:16:38.825
2016-06-02 14:16:38 1 [Note] InnoDB: Setting log file ./ib_logfile1 size to 512 MB
15:16:39.501
InnoDB: Progress in MB: 100 200 300 400 500
15:16:56.106
2016-06-02 14:16:56 1 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
15:16:56.106
2016-06-02 14:16:56 1 [Warning] InnoDB: New log files created, LSN=1625987
15:16:56.107
2016-06-02 14:16:56 1 [Note] InnoDB: 128 rollback segment(s) are active.
15:16:56.108
2016-06-02 14:16:56 1 [Note] InnoDB: Waiting for purge to start
15:16:56.159
2016-06-02 14:16:56 1 [Note] InnoDB: 5.6.29 started; log sequence number 1625987
15:16:56.159
2016-06-02 14:16:56 1 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a961f7b3-28cc-11e6-9ce7-
0242ac110003. 15:16:56.161
2016-06-02 14:16:56 1 [Warning] Failed to setup SSL
15:16:56.162
2016-06-02 14:16:56 1 [Warning] SSL error: SSL_CTX_set_default_verify_
paths failed 15:16:56.162
2016-06-02 14:16:56 1 [Note] RSA private key file not found: /mysql/datadir//private_key.
pem. Some authentication plugins will not work. 15:16:56.162
2016-06-02 14:16:56 1 [Note] RSA public key file not found: /mysql/datadir//public_key.
pem. Some authentication plugins will not work. 15:16:56.163
2016-06-02 14:16:56 1 [Note] Server hostname (bind-address): '*'; port: 3306
15:16:56.163
2016-06-02 14:16:56 1 [Note] IPv6 is available.
15:16:56.164
2016-06-02 14:16:56 1 [Note] - '::' resolves to '::';
15:16:56.164
2016-06-02 14:16:56 1 [Note] Server socket created on IP: '::'.
15:16:56.165
2016-06-02 14:16:56 1 [Note] Loaded users from system_user table: root@localhost,
cloudsqlreplica@%, cloudsqlimport@localhost. 15:16:56.168
2016-06-02 14:16:56 1 [Note] Event Scheduler: Loaded 0 events
15:16:56.169
2016-06-02 14:16:56 1 [Note] /usr/sbin/mysqld: ready for connections.
15:16:56.169
Version: '5.6.29-google' socket: '/mysql/mysql.sock' port: 3306 (Google)
--
On Friday, 3 June 2016 09:59:24 UTC+1, Rupesh Kumar wrote:For the time you can use the gcloud command line tool to set the root password -
gcloud sql instances set-root-password [INSTANCE_NAME ] --password [PASSWORD ]*If you don't have gcloud setup you can use Cloud Shell to do the same.I faced same issue from yesterday and resolved by usi cli command
On Friday, June 3, 2016 at 1:39:53 PM UTC+5:30, Pavlo Maksymchuk wrote:We have successfully used Cloud Sql for some time.Recently we have increased an instance to higher spec and on last update "An unknown error occurred"Since then we cannot get any access to sql database.Going into Access Control > Users comes back with "Failed to load" error.
Checked sql logs and there are quite few errors as well.Have tried creating completely new instances, even on different projects still no luck to start it up.In list of instances all showing green (Runnable)Is there something wrong with Google Cloud Sql storage or we are missing something?
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/cdfbba0a-65ea-4a11- bd48-8ab27d856a9d% 40googlegroups.com
For more options, visit https://groups.google.com/d/optout .
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/eb05f7e4-20d3-4cf3-aa66-c4b838cf8a3a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment