Re: [google-cloud-sql-discuss] Re: Issue creating Cloud SQL 2nd gen

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 <pavlo@solidstategroup.com> wrote:

Hi Rupesh

Thank 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/CABDU3p290JVL9LAWEm5g8ULPcgv8w9HwwQtZL-pzZ7AjGLMK0w%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.