Monday, September 30, 2013

Re: Cannot create new instance (billing not enabled)

I have the same problem. 
Project number: 985842380622

--
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/912a1ffb-1723-4ac7-9f2f-898013a9b9eb%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Re: MySQL 5.6 Support?

The recent discussion was around Google's use of MariaDB internally, and doesn't affect Cloud SQL.

j


On Fri, Sep 27, 2013 at 8:15 AM, SS <sarathbabou.somaya@ssomens.com> wrote:
Better Ggle shd think replacing MySQL by MariaDB just like, Ggle itself  is migrating its own instances to MariaDB 10.

Is cloud SQL towards this direction also?

S
From: Joe Faith
Sent: 27/9/2013 22:49
To: google-cloud-sql-discuss@googlegroups.com
Subject: Re: MySQL 5.6 Support?

sorry, we don't yet have a date.

j


On Thu, Sep 26, 2013 at 9:27 PM, DPope <dave.pope@myxer.com> wrote:
Any update on this?  The feature I'm most interested in is online schema updates:  http://dev.mysql.com/doc/refman/5.6/en/innodb-create-index-overview.html


On Monday, February 11, 2013 10:55:41 AM UTC-6, Yissachar Radcliffe wrote:
There are some general performance improvements that would be nice to have but the main feature that I would like is Fulltext Search for InnoDB engine.

On Monday, February 11, 2013 11:36:49 AM UTC-5, Ken Ashcraft wrote:
On Mon, Feb 11, 2013 at 4:10 PM, Yissachar Radcliffe <yissachar...@caseware.com> wrote:
Is there any timeline/roadmap for when we can expect MySQL 5.6 support? 


We're still discussing it internally, sorry.
 
There are some new features in MySQL 5.6 that I am interested in and would like to use on Google Cloud SQL but as we cannot manually upgrade our instances I have to wait until MySQL 5.6 is officially added.

What features are you interested in? 

--
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/35f8d2bc-7e09-4c4d-8579-df2fbcd8740a%40googlegroups.com.



--
Joe Faith | Product Manager | Google Cloud

--
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/CAHNz2%3D_teSYWx%2BD0Ge%2BBDcwa_eHE%3DCiD72GQQHfLjXjHxnkBWw%40mail.gmail.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
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/5245a193.cabf440a.0ad5.0f7f%40mx.google.com.

For more options, visit https://groups.google.com/groups/opt_out.



--
Joe Faith | Product Manager | Google Cloud

--
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/CAHNz2%3D8nHObDB-4bPxgd3SGpNPc6QfmWXMVy-yRk3a21WQ%3D42A%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Friday, September 27, 2013

Re: Consistency issues with Cloud SQL

Hi Matt,

Could you verify that the data was written out within transaction within Task 1 before being read by others?

How about trying the following to get a repro:
- Task 1 opens connection, writes record, transaction commit, closes connection.
- Task 1 opens new connection. Reads back data after transaction commit. Should see the write.
- Task 2 opens new connection. Reads back data. Should see the write.

Also, how did the scenario work with autocommit enabled?

Thanks,
-debangsu

On Fri, Sep 27, 2013 at 5:43 AM, Matt Doran <matt.doran@papercut.com> wrote:
Hi there,

I'm certain that this is being written within a transaction in a separate task queue (web request) to the queries that happen 10s of seconds later and the data doesn't exist.

I'm trying to get to the bottom of this .... but I just can't get my head around it.

Regards,
Matt


On Thursday, 26 September 2013 04:08:09 UTC+10, Debangsu Sengupta wrote:
Hi Matt,

I'd check to see whether task 1's transaction is being committed prior to task 2 reading it. Please try it with autocommit mode enabled.

References:

Thanks,
-debangsu


On Wed, Sep 25, 2013 at 4:55 AM, Matt Doran <matt....@papercut.com> wrote:
Hi there,

We have an appengine application that makes use of Cloud SQL for some of it's storage needs.  We are seeing cases where a record written in a previous transaction is not available a short time later, and then it reappears again after that.

Here's the basic gist of what happens:
 * Task 1 runs creating a record in the CloudSQL instance.  We have added debugging to retrieve this row and confirm it's saved within this task
 * Task 2 runs 30 seconds later and looks for the row created in task 1.  It does not exist.   We have the same debug logging code from task 1 and it returns nothing.  Because this record cannot be found our task execution fails, and google app engine re-schedules it for execution.
 * Task 2 re-runs a short period later and this time the record is found and the task is processed correctly.

This situation occurs regularly but without an obvious pattern.   It probably occurs a few time in every 40-50 tasks of this kind that occur over the period of a day.   It's only for the retry behaviour of the task queues that allows this to eventually succeed.

Our cloud SQL instance has the replication mode set to "Synchronous".

We are at a loss to explain it.  All the extra debug logging and testing we've added only confirms this strange behaviour... and hasn't provided any answers.

Does anyone have any ideas on what is happening here?   It's like we're seeing some sort of eventual consistency on our cloud SQL instance???

Regards,
Matt




--
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/5b6a0a2c-cd2c-41db-a3d2-b809cba4353d%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
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/1be8d7ac-4f9a-44b0-aa08-f2fd13b3fbf6%40googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
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/CAFjFvZs5GSo-9AT%3DtsY6FoOo9HsyDWdwhWTRjzWkh8r3-Z18oA%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

RE: MySQL 5.6 Support?

Better Ggle shd think replacing MySQL by MariaDB just like, Ggle itself  is migrating its own instances to MariaDB 10.

Is cloud SQL towards this direction also?

S
From: Joe Faith
Sent: 27/9/2013 22:49
To: google-cloud-sql-discuss@googlegroups.com
Subject: Re: MySQL 5.6 Support?

sorry, we don't yet have a date.

j


On Thu, Sep 26, 2013 at 9:27 PM, DPope <dave.pope@myxer.com> wrote:
Any update on this?  The feature I'm most interested in is online schema updates:  http://dev.mysql.com/doc/refman/5.6/en/innodb-create-index-overview.html


On Monday, February 11, 2013 10:55:41 AM UTC-6, Yissachar Radcliffe wrote:
There are some general performance improvements that would be nice to have but the main feature that I would like is Fulltext Search for InnoDB engine.

On Monday, February 11, 2013 11:36:49 AM UTC-5, Ken Ashcraft wrote:
On Mon, Feb 11, 2013 at 4:10 PM, Yissachar Radcliffe <yissachar...@caseware.com> wrote:
Is there any timeline/roadmap for when we can expect MySQL 5.6 support? 


We're still discussing it internally, sorry.
 
There are some new features in MySQL 5.6 that I am interested in and would like to use on Google Cloud SQL but as we cannot manually upgrade our instances I have to wait until MySQL 5.6 is officially added.

What features are you interested in? 

--
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/35f8d2bc-7e09-4c4d-8579-df2fbcd8740a%40googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.



--
Joe Faith | Product Manager | Google Cloud

--
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/CAHNz2%3D_teSYWx%2BD0Ge%2BBDcwa_eHE%3DCiD72GQQHfLjXjHxnkBWw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Re: MySQL 5.6 Support?

sorry, we don't yet have a date.

j


On Thu, Sep 26, 2013 at 9:27 PM, DPope <dave.pope@myxer.com> wrote:
Any update on this?  The feature I'm most interested in is online schema updates:  http://dev.mysql.com/doc/refman/5.6/en/innodb-create-index-overview.html


On Monday, February 11, 2013 10:55:41 AM UTC-6, Yissachar Radcliffe wrote:
There are some general performance improvements that would be nice to have but the main feature that I would like is Fulltext Search for InnoDB engine.

On Monday, February 11, 2013 11:36:49 AM UTC-5, Ken Ashcraft wrote:
On Mon, Feb 11, 2013 at 4:10 PM, Yissachar Radcliffe <yissachar...@caseware.com> wrote:
Is there any timeline/roadmap for when we can expect MySQL 5.6 support? 


We're still discussing it internally, sorry.
 
There are some new features in MySQL 5.6 that I am interested in and would like to use on Google Cloud SQL but as we cannot manually upgrade our instances I have to wait until MySQL 5.6 is officially added.

What features are you interested in? 

--
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/35f8d2bc-7e09-4c4d-8579-df2fbcd8740a%40googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.



--
Joe Faith | Product Manager | Google Cloud

--
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/CAHNz2%3D_teSYWx%2BD0Ge%2BBDcwa_eHE%3DCiD72GQQHfLjXjHxnkBWw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Re: Outage and health notifications

Hi Vladimir

Its a good point:
If there is a system-wide outage we'll inform you guys via this email list.
If there is an issue with individual instances we notify the owners of the project by email.

But we like the idea of the service dashboard

j


On Thu, Sep 26, 2013 at 5:24 PM, Vladimir Ralev <vladimir.ralev@gmail.com> wrote:
Understood. It's mostly a matter of efficiency, because I am used to checking the vendor health report if there is an outage first and only then dive into multi-day investigations locally. It saves time for everybody.

--
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/CAELWUnWHRGhUgY4rhdgSJinxWj8rJgJXshKK4cOWzqbBaDcO1Q%40mail.gmail.com.

For more options, visit https://groups.google.com/groups/opt_out.



--
Joe Faith | Product Manager | Google Cloud

--
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/CAHNz2%3D-oRL_J5_yU9wRbt2NWZW4nOcETwwScOsxA9P%3DehgEnaQ%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Re: Consistency issues with Cloud SQL

Hi there,

I'm certain that this is being written within a transaction in a separate task queue (web request) to the queries that happen 10s of seconds later and the data doesn't exist.

I'm trying to get to the bottom of this .... but I just can't get my head around it.

Regards,
Matt

On Thursday, 26 September 2013 04:08:09 UTC+10, Debangsu Sengupta wrote:
Hi Matt,

I'd check to see whether task 1's transaction is being committed prior to task 2 reading it. Please try it with autocommit mode enabled.

References:

Thanks,
-debangsu


On Wed, Sep 25, 2013 at 4:55 AM, Matt Doran <matt....@papercut.com> wrote:
Hi there,

We have an appengine application that makes use of Cloud SQL for some of it's storage needs.  We are seeing cases where a record written in a previous transaction is not available a short time later, and then it reappears again after that.

Here's the basic gist of what happens:
 * Task 1 runs creating a record in the CloudSQL instance.  We have added debugging to retrieve this row and confirm it's saved within this task
 * Task 2 runs 30 seconds later and looks for the row created in task 1.  It does not exist.   We have the same debug logging code from task 1 and it returns nothing.  Because this record cannot be found our task execution fails, and google app engine re-schedules it for execution.
 * Task 2 re-runs a short period later and this time the record is found and the task is processed correctly.

This situation occurs regularly but without an obvious pattern.   It probably occurs a few time in every 40-50 tasks of this kind that occur over the period of a day.   It's only for the retry behaviour of the task queues that allows this to eventually succeed.

Our cloud SQL instance has the replication mode set to "Synchronous".

We are at a loss to explain it.  All the extra debug logging and testing we've added only confirms this strange behaviour... and hasn't provided any answers.

Does anyone have any ideas on what is happening here?   It's like we're seeing some sort of eventual consistency on our cloud SQL instance???

Regards,
Matt




--
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/5b6a0a2c-cd2c-41db-a3d2-b809cba4353d%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
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/1be8d7ac-4f9a-44b0-aa08-f2fd13b3fbf6%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Thursday, September 26, 2013

Re: MySQL 5.6 Support?

Any update on this?  The feature I'm most interested in is online schema updates:  http://dev.mysql.com/doc/refman/5.6/en/innodb-create-index-overview.html


On Monday, February 11, 2013 10:55:41 AM UTC-6, Yissachar Radcliffe wrote:
There are some general performance improvements that would be nice to have but the main feature that I would like is Fulltext Search for InnoDB engine.

On Monday, February 11, 2013 11:36:49 AM UTC-5, Ken Ashcraft wrote:
On Mon, Feb 11, 2013 at 4:10 PM, Yissachar Radcliffe <yissachar...@caseware.com> wrote:
Is there any timeline/roadmap for when we can expect MySQL 5.6 support? 


We're still discussing it internally, sorry.
 
There are some new features in MySQL 5.6 that I am interested in and would like to use on Google Cloud SQL but as we cannot manually upgrade our instances I have to wait until MySQL 5.6 is officially added.

What features are you interested in? 

--
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/35f8d2bc-7e09-4c4d-8579-df2fbcd8740a%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Re: Outage and health notifications

Understood. It's mostly a matter of efficiency, because I am used to checking the vendor health report if there is an outage first and only then dive into multi-day investigations locally. It saves time for everybody.

--
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/CAELWUnWHRGhUgY4rhdgSJinxWj8rJgJXshKK4cOWzqbBaDcO1Q%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Unusual error SQLNonTransientException: Internal error.

I was scanning some older logs and found this exception in the google sql driver. It's the first time I have seen it, but it may be interesting to you:

Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/ef2fDS
        at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:147)
        at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141) [hibernate-core-4.1.2.Final.jar:4.1.2.Final]
        at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:278) [hibernate-core-4.1.2.Final.jar:4.1.2.Final]
        at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:297) [hibernate-core-4.1.2.Final.jar:4.1.2.Final]
        ... 84 more
Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/ef2fDS
        at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:390)
        at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:368)
        at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)
        at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139)
        ... 87 more
Caused by: javax.resource.ResourceException: IJ000658: Unexpected throwable while trying to create a connection: null
        at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:371)
        at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397)
        at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365)
        at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:329)
        ... 90 more
Caused by: javax.resource.ResourceException: Could not create connection
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)
        at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:761)
        at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:343)
        ... 93 more
Caused by: java.sql.SQLNonTransientException: Internal error.
        at com.google.cloud.sql.jdbc.internal.Exceptions.newSqlExceptionForApplicationError(Exceptions.java:185)
        at com.google.cloud.sql.jdbc.internal.Exceptions.newSqlException(Exceptions.java:211)
        at com.google.cloud.sql.jdbc.internal.SqlProtoClient.check(SqlProtoClient.java:158)
        at com.google.cloud.sql.jdbc.internal.SqlProtoClient.openConnection(SqlProtoClient.java:60)
        at com.google.cloud.sql.jdbc.Driver.connect(Driver.java:66)
        at com.google.cloud.sql.Driver.connectImpl(Driver.java:109)
        at com.google.cloud.sql.Driver.connect(Driver.java:98)
        at com.google.cloud.sql.Driver.connect(Driver.java:31)
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)
        ... 96 more

--
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/CAELWUnWaoe-S7a6oXDWbM_Wd3PnjDPrgCnZjDUO%3DgMBaO0JvWQ%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Re: Outage and health notifications

Hi Vladimir,

The "Connection id no longer valid" can happen for multiple reasons and does not indicate a system outage. You can give the native MySQL connections a try: https://developers.google.com/cloud-sql/docs/native-mysql-gae , and will get more familiar MySQL errors to understand what's going on. From the client side, retries, and avoiding long running connections will help. 

For monitoring dashboards currently available for Cloud SQL, you can go to https://cloud.google.com/console, select your project, then Cloud SQL, then instance, then Monitoring. 

The system wide calendar / dashboard is a good suggestion.

Thanks,
-debangsu


On Thu, Sep 26, 2013 at 3:06 PM, Vladimir Ralev <vladimir.ralev@gmail.com> wrote:
Hello could SQLl team,

We observe some rare short recoverable outages may be once per 2 months for a few minutes at a time. It manifests itself as different generic messages such as "Connection id no longer valid.".

I am sure everybody will appreciate it if you have some sort of calendar or a health dashboard like they do in AWS to cross-check any issues with certain known outages, errors or patches/updates in the backend of your system. Do you think this is possible?

--
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/CAELWUnXE8UWjknU9dKhT7%2BtVz%2BcW-icqoBTdQ55hTYiQOa9dEA%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
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/CAFjFvZv6XbZpzCpkzncceetsFG4BayZGRohZ0wXW2jV8f%2BHXng%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Outage and health notifications

Hello could SQLl team,

We observe some rare short recoverable outages may be once per 2 months for a few minutes at a time. It manifests itself as different generic messages such as "Connection id no longer valid.".

I am sure everybody will appreciate it if you have some sort of calendar or a health dashboard like they do in AWS to cross-check any issues with certain known outages, errors or patches/updates in the backend of your system. Do you think this is possible?

--
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/CAELWUnXE8UWjknU9dKhT7%2BtVz%2BcW-icqoBTdQ55hTYiQOa9dEA%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Wednesday, September 25, 2013

Re: Consistency issues with Cloud SQL

Hi Matt,

I'd check to see whether task 1's transaction is being committed prior to task 2 reading it. Please try it with autocommit mode enabled.

References:

Thanks,
-debangsu


On Wed, Sep 25, 2013 at 4:55 AM, Matt Doran <matt.doran@papercut.com> wrote:
Hi there,

We have an appengine application that makes use of Cloud SQL for some of it's storage needs.  We are seeing cases where a record written in a previous transaction is not available a short time later, and then it reappears again after that.

Here's the basic gist of what happens:
 * Task 1 runs creating a record in the CloudSQL instance.  We have added debugging to retrieve this row and confirm it's saved within this task
 * Task 2 runs 30 seconds later and looks for the row created in task 1.  It does not exist.   We have the same debug logging code from task 1 and it returns nothing.  Because this record cannot be found our task execution fails, and google app engine re-schedules it for execution.
 * Task 2 re-runs a short period later and this time the record is found and the task is processed correctly.

This situation occurs regularly but without an obvious pattern.   It probably occurs a few time in every 40-50 tasks of this kind that occur over the period of a day.   It's only for the retry behaviour of the task queues that allows this to eventually succeed.

Our cloud SQL instance has the replication mode set to "Synchronous".

We are at a loss to explain it.  All the extra debug logging and testing we've added only confirms this strange behaviour... and hasn't provided any answers.

Does anyone have any ideas on what is happening here?   It's like we're seeing some sort of eventual consistency on our cloud SQL instance???

Regards,
Matt




--
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/5b6a0a2c-cd2c-41db-a3d2-b809cba4353d%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
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/CAFjFvZu-vq%3D%2BL9TC-kn%3DtLu2KUceL%3DK8hXT5OhkB8_590bxOfQ%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Consistency issues with Cloud SQL

Hi there,

We have an appengine application that makes use of Cloud SQL for some of it's storage needs.  We are seeing cases where a record written in a previous transaction is not available a short time later, and then it reappears again after that.

Here's the basic gist of what happens:
 * Task 1 runs creating a record in the CloudSQL instance.  We have added debugging to retrieve this row and confirm it's saved within this task
 * Task 2 runs 30 seconds later and looks for the row created in task 1.  It does not exist.   We have the same debug logging code from task 1 and it returns nothing.  Because this record cannot be found our task execution fails, and google app engine re-schedules it for execution.
 * Task 2 re-runs a short period later and this time the record is found and the task is processed correctly.

This situation occurs regularly but without an obvious pattern.   It probably occurs a few time in every 40-50 tasks of this kind that occur over the period of a day.   It's only for the retry behaviour of the task queues that allows this to eventually succeed.

Our cloud SQL instance has the replication mode set to "Synchronous".

We are at a loss to explain it.  All the extra debug logging and testing we've added only confirms this strange behaviour... and hasn't provided any answers.

Does anyone have any ideas on what is happening here?   It's like we're seeing some sort of eventual consistency on our cloud SQL instance???

Regards,
Matt




--
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/5b6a0a2c-cd2c-41db-a3d2-b809cba4353d%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Tuesday, September 24, 2013

Re: Could not create an instance :(

Hi Allen,

Could you make sure that billing is enabled for the project. Once you have a valid billing profile, you will be able to create Cloud SQL instances.

Steps: 
- Go to the cloud console at http://cloud.google.com/console
- Select your project, 
- Select Billing
- Select Enable Billing
- Set Up Your Billing Profile.

Thanks,
-debangsu


On Mon, Sep 23, 2013 at 8:23 PM, Allen Nopre <ayenopre@gmail.com> wrote:
Project Number: 828442032982

--
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/c9929431-e8c1-4993-b70c-747293d0d820%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
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/CAFjFvZtqN4baEoGGUCsPSfJmjeK2dEdNnOxuxNaChLtuP74FJQ%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Re: Squirrel Unauthorized Client Issue

I wish this topic appeared higher up on Google's search results page! 

I've been searching for this for 2.5 - 3 hours!

Using the Python SDK I was able to connect via command line but not via SQuirreL SQL Client.

Following from what was said above, I connected to the Java SDK command line tool just once, restarted the SQuirreL SQL Client and volia, I can now connect! 

This really should be documented somewhere more official!!

On Sunday, 25 August 2013 21:33:46 UTC+1, Rob wrote:
Ah yes. The python google-SQL uses a different token store than the java one google_sql.sh is the one you want.  I'm aware this is confusing and will be remedied soon.

Rob

On Sunday, August 25, 2013, Michael Houck wrote:
I've run both on the same machine with only one google login set up.  Is there a different OAuth file for the python google-sql command line vs the OAuth used by the JDBC driver?

On Saturday, August 24, 2013 9:53:52 PM UTC-4, Amit Mondal wrote:

Is it running as same user?

On Aug 24, 2013 2:05 PM, "Michael Houck" <mho...@gmail.com> wrote:
I'm following the steps in this guide to test out external application access to the Google Cloud SQL:

https://developers.google.com/cloud-sql/docs/admin_tools

and when I get to the test portion, it's giving me this error:

java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: 400 Bad Request
{
  "error" : "unauthorized_client"
}

I've tried revoking the access, deleting the OAuth keys in the registry and then regaining access via the google_sql.cmd tool (where I go to the link and paste the auth code into the cmd window) and also via the gauth python script in the /bin directory.  I can connect to the database fine with the google_sql command line, but whenever I test the connection in Squirrel SQL it gives me the unauthorized access issue.

Can anyone help me out on this?

--
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/5a9a75c9-5584-41fa-b679-70053f331ef5%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
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/a5744803-5277-4325-9e49-c08aeae1a261%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

z
This message is for the named person's use only.  If you receive this message in error, please delete it and notify the sender.  Appogee is the products division of Ancoris Limited.
Ancoris reserves the right to monitor all e-mail communications through its networks. Ancoris Limited, Registered in England Number: 04830784, Registered address: 5a Frascati Way, Maidenhead, Berkshire SL6 4UY. Trading Address: Lily Hill House, Lily Hill Road, Bracknell, Berkshire RG12 2SJ

--
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/cb6b58b4-e5c8-42a9-a72b-0d8f6527954e%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Monday, September 23, 2013

Could not create an instance :(

Project Number: 828442032982

--
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/c9929431-e8c1-4993-b70c-747293d0d820%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Re: Could not create an instance because billing is not enabled.

Hi Bahtiar,

Can you try creating an instance now and let us know if it works now?

Thanks,
Sundar


On Sat, Sep 21, 2013 at 8:34 AM, Bahtiar Pakpahan <bahtiar@visioinformatika.com> wrote:
When Create a New Cloud SQL Instance, got this error : "Could not create an instance because billing is not enabled."
Project Number: 530758101386

Billing Status: 

Enabled.

Please Help.

--
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/2a4397bf-c3d7-42b6-b13d-e1b9988cf151%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.



--
-Sundar

--
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/CABrSwLQ3n%2B52bwFP%3D2Zemr2CNM1Druqu4AoHwMW%3DHFv1_gaqEw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Saturday, September 21, 2013

Could not create an instance because billing is not enabled.

When Create a New Cloud SQL Instance, got this error : "Could not create an instance because billing is not enabled."
Project Number: 530758101386

Billing Status: 

Enabled.

Please Help.

--
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/2a4397bf-c3d7-42b6-b13d-e1b9988cf151%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Friday, September 20, 2013

Re: How do i query to check records with two matching strings

thanks...


On Fri, Sep 20, 2013 at 11:10 PM, Sundar Venkatasubramanian <sundaresan@google.com> wrote:
Hello,

It looks like your question is related to Google Cloud DataStore and not Google Cloud SQL. google-cloud-sql-discuss group is meant for discussion regarding Google Cloud SQL. Please use one of the means posted here to get help for your question regarding Cloud DataStore.

Regards,
Sundaresan


On Fri, Sep 20, 2013 at 5:27 AM, Namrata <namrata@vspace.in> wrote:
Hello,
      I have created project using jsp, servlets in netbeans6.9 and datastore I am able to store whole entity values as well as retrieve all. But when i  write query as given below its showing error :-> com.google.appengine.api.datastore.EntityNotFoundException: No entity was found matching the key: firstname("Smita")

my code is here,
String uname="Smita";
DatastoreService ds = DatastoreServiceFactory.getDatastoreService();
Key key = KeyFactory.createKey("firstname", uname);
Entity ent = ds.get(key);

plz help me, i wants to check two fields firstname and lastname (need query as in mysql   select * from logininfo where firstname='smita' and lastname='sharma');
Thanks......

--
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/ffeffdc5-9598-45b0-9f0f-58aacbc8ec65%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.



--
-Sundar

--
You received this message because you are subscribed to a topic in the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-cloud-sql-discuss/kLNuVZDc9_I/unsubscribe.
To unsubscribe from this group and all its topics, 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/CABrSwLRsr0jeh8sb9TBz_4x98%2BKvubaTYzamRTjU-e00pE6Psg%40mail.gmail.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
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/CANpGnWz%3D95uz-dHNJfNDXwKjyX8Jj2pXONChRaQs1%2BqoxqHMVA%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Re: How do i query to check records with two matching strings

Hello,

It looks like your question is related to Google Cloud DataStore and not Google Cloud SQL. google-cloud-sql-discuss group is meant for discussion regarding Google Cloud SQL. Please use one of the means posted here to get help for your question regarding Cloud DataStore.

Regards,
Sundaresan


On Fri, Sep 20, 2013 at 5:27 AM, Namrata <namrata@vspace.in> wrote:
Hello,
      I have created project using jsp, servlets in netbeans6.9 and datastore I am able to store whole entity values as well as retrieve all. But when i  write query as given below its showing error :-> com.google.appengine.api.datastore.EntityNotFoundException: No entity was found matching the key: firstname("Smita")

my code is here,
String uname="Smita";
DatastoreService ds = DatastoreServiceFactory.getDatastoreService();
Key key = KeyFactory.createKey("firstname", uname);
Entity ent = ds.get(key);

plz help me, i wants to check two fields firstname and lastname (need query as in mysql   select * from logininfo where firstname='smita' and lastname='sharma');
Thanks......

--
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/ffeffdc5-9598-45b0-9f0f-58aacbc8ec65%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.



--
-Sundar

--
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/CABrSwLRsr0jeh8sb9TBz_4x98%2BKvubaTYzamRTjU-e00pE6Psg%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Re: How do I query for checking two string type fields

Hello,

It looks like your question is related to Google Cloud DataStore and not Google Cloud SQL. google-cloud-sql-discuss group is meant for discussion regarding Google Cloud SQL. Please use one of the means posted here to get help for your question regarding Cloud DataStore.

Regards,
Sundaresan


On Fri, Sep 20, 2013 at 5:13 AM, Namrata <namrata@vspace.in> wrote:
Hello,
      I have created project using jsp, servlets in netbeans6.9. I am able to store whole entity values as well as retrieve all. But when i  write query as given below its showing error :-> com.google.appengine.api.datastore.EntityNotFoundException: No entity was found matching the key: firstname("Smita")

my code is here,
String uname="Smita";
DatastoreService ds = DatastoreServiceFactory.getDatastoreService();
Key key = KeyFactory.createKey("firstname", uname);
Entity ent = ds.get(key);

plz help me, i wants to check two fields firstname and lastname (need query as in mysql   select * from logininfo where firstname='smita' and lastname='sharma');
Thanks......

--
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/3cdc5c35-2655-4f19-a41e-44e9fe5640ee%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.



--
-Sundar

--
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/CABrSwLTfv7V-7sJXJh26ixWf7i4mkFvM6WgX-vbWGsJaAsS15w%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

How do i query to check records with two matching strings

Hello,
      I have created project using jsp, servlets in netbeans6.9 and datastore I am able to store whole entity values as well as retrieve all. But when i  write query as given below its showing error :-> com.google.appengine.api.datastore.EntityNotFoundException: No entity was found matching the key: firstname("Smita")

my code is here,
String uname="Smita";
DatastoreService ds = DatastoreServiceFactory.getDatastoreService();
Key key = KeyFactory.createKey("firstname", uname);
Entity ent = ds.get(key);

plz help me, i wants to check two fields firstname and lastname (need query as in mysql   select * from logininfo where firstname='smita' and lastname='sharma');
Thanks......

--
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/ffeffdc5-9598-45b0-9f0f-58aacbc8ec65%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

How do I query for checking two string type fields

Hello,
      I have created project using jsp, servlets in netbeans6.9. I am able to store whole entity values as well as retrieve all. But when i  write query as given below its showing error :-> com.google.appengine.api.datastore.EntityNotFoundException: No entity was found matching the key: firstname("Smita")

my code is here,
String uname="Smita";
DatastoreService ds = DatastoreServiceFactory.getDatastoreService();
Key key = KeyFactory.createKey("firstname", uname);
Entity ent = ds.get(key);

plz help me, i wants to check two fields firstname and lastname (need query as in mysql   select * from logininfo where firstname='smita' and lastname='sharma');
Thanks......

--
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/3cdc5c35-2655-4f19-a41e-44e9fe5640ee%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Wednesday, September 18, 2013

Re: Problems accessing Cloud SQL from a Java Web App located on a Compute Engine VM instance

Hi Joe,

Yes you're right !
I had tomcat installed with apt-get and I did not pay attention it was installed with a specific user.

Thank you
:-)



Le lundi 16 septembre 2013 16:29:31 UTC+2, Joe Faith a écrit :
Hi Jean-Baptiste 

could you check which user tomcat is running as.
The access token is stored under the user's home folder

j


On Sat, Sep 14, 2013 at 9:48 AM, Jean-Baptiste Claramonte <jeanbaptist...@gmail.com> wrote:
Hello
I'm trying to install a simple Java Web App (petclinic from springframework) on a tomcat instance located on a Compute Engine VM instance (on which Cloud SQL is enabled).
This Java Web App need to access to my Cloud SQL instance. 

I downloaded google_sql on my VM instance, called gauth to be authenticated, called google_sql.sh and successfully connected to my Cloud SQL instance from my VM instance.
Unfortunately it still doesn't work, it fails when connecting and I have this error:

 java.sql.SQLException: Unable to load OAuth2 refresh or access token. Please run the google_sql command line tool once to setup cached credentials. See: http://code.google.com/apis/sql/docs/commandline.html

What should I do to be able to access my Cloud SQL instance from a VM Instance ? 

--
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/1ef4d0ad-1b5b-4f06-bc5f-f461eaa48c82%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.



--
Joe Faith | Product Manager | Google Cloud

--
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/08c19a34-8901-4221-93d1-1903e2ce3dca%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Monday, September 16, 2013

Re: Problems accessing Cloud SQL from a Java Web App located on a Compute Engine VM instance

Hi Jean-Baptiste 

could you check which user tomcat is running as.
The access token is stored under the user's home folder

j


On Sat, Sep 14, 2013 at 9:48 AM, Jean-Baptiste Claramonte <jeanbaptiste.claramonte@gmail.com> wrote:
Hello
I'm trying to install a simple Java Web App (petclinic from springframework) on a tomcat instance located on a Compute Engine VM instance (on which Cloud SQL is enabled).
This Java Web App need to access to my Cloud SQL instance. 

I downloaded google_sql on my VM instance, called gauth to be authenticated, called google_sql.sh and successfully connected to my Cloud SQL instance from my VM instance.
Unfortunately it still doesn't work, it fails when connecting and I have this error:

 java.sql.SQLException: Unable to load OAuth2 refresh or access token. Please run the google_sql command line tool once to setup cached credentials. See: http://code.google.com/apis/sql/docs/commandline.html

What should I do to be able to access my Cloud SQL instance from a VM Instance ? 

--
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/1ef4d0ad-1b5b-4f06-bc5f-f461eaa48c82%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.



--
Joe Faith | Product Manager | Google Cloud

--
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/CAHNz2%3D_0Y1LwngdwDt9NCxu25849Gx%2B%2Bn4Xo8tGgEFM7GyQ30g%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Saturday, September 14, 2013

Problems accessing Cloud SQL from a Java Web App located on a Compute Engine VM instance

Hello
I'm trying to install a simple Java Web App (petclinic from springframework) on a tomcat instance located on a Compute Engine VM instance (on which Cloud SQL is enabled).
This Java Web App need to access to my Cloud SQL instance. 

I downloaded google_sql on my VM instance, called gauth to be authenticated, called google_sql.sh and successfully connected to my Cloud SQL instance from my VM instance.
Unfortunately it still doesn't work, it fails when connecting and I have this error:

 java.sql.SQLException: Unable to load OAuth2 refresh or access token. Please run the google_sql command line tool once to setup cached credentials. See: http://code.google.com/apis/sql/docs/commandline.html

What should I do to be able to access my Cloud SQL instance from a VM Instance ? 

--
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/1ef4d0ad-1b5b-4f06-bc5f-f461eaa48c82%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Clous sql error "System property rdbms.driver must be set"


Hi, every one.

i have problem with cloud sql , i use spring mvc with google app engine 1.8.3 and maven 3.
I want connect to my sql cloud via hibernate / jpa, so I declared a persistent file that contains the cloud sql  connection parameters  :



<?xml version="1.0" encoding="UTF-8" ?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence"  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" version="1.0">
    <persistence-unit name="test" transaction-type="RESOURCE_LOCAL">
        <provider>org.hibernate.ejb.HibernatePersistence</provider>
        <class>com.demo.test/model</class>
        <properties>        
            <property name="hibernate.connection.driver_class" value="com.google.appengine.api.rdbms.AppEngineDriver"/>
             <property name="hibernate.connection.url" value="jdbc:google:rdbms://myinstan/mydb?zeroDateTimeBehavior=convertToNull"/>
            <property name="hibernate.connection.username" value="root"/>
             <property name="hibernate.connection.password" value=""/>
            <property name="hibernate.connection.pool_size" value="0" />
            <property name="hibernate.hbm2ddl.auto" value="update" />
            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
        </properties>
    </persistence-unit>
</persistence>


for running application i use maven command " appengine-devserver " ,and i have this error " System property rdbms.driver must be set " :

[INFO] ERROR: org.springframework.web.servlet.DispatcherServlet - Context initialization failed
[INFO] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor#0': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in ServletContext resource [/WEB-INF/spring/appServlet/servlet-context.xml]: Invocation of init method failed; nested exception is java.lang.IllegalStateException: System property rdbms.driver must be set.
.....................

[INFO] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in ServletContext resource [/WEB-INF/spring/appServlet/servlet-context.xml]: Invocation of init method failed; nested exception is java.lang.IllegalStateException: System property rdbms.driver must be set.
[INFO]     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1455)
..........................
[INFO] Caused by: java.lang.IllegalStateException: System property rdbms.driver must be set.
[INFO]     at com.google.appengine.api.rdbms.dev.LocalRdbmsServiceLocalDriver.registerDriver(LocalRdbmsServiceLocalDriver.java:80)

..............................

INFO] sept. 14, 2013 2:59:13 PM com.google.appengine.tools.development.ApiProxyLocalImpl log
[INFO] SEVERE: javax.servlet.ServletContext log: unavailable
[INFO] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor#0': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in ServletContext resource [/WEB-INF/spring/appServlet/servlet-context.xml]: Invocation of init method failed; nested exception is java.lang.IllegalStateException: System property rdbms.driver must be set.



my question is,  I need to configure the cloud sql in the pom.xml ??? or is another thing I do not???


thanks

--
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/7c0eea35-6954-40c3-b1ca-b80e477cffac%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:

Friday, September 13, 2013

Re: Cloud SQL with external app

Hi Joe,

Thanks for the invitation, i'm glad to join to this group of users.

Matt


On Fri, Sep 13, 2013 at 6:52 PM, Joe Faith <joefaith@google.com> wrote:
Hi Mate

we're currently working on improving connectivity to Cloud SQL instances.
I've sent you an invite to try out this functionality as a trusted tester.
Accept the invite if you're interested and let me know 

J


On Thu, Sep 12, 2013 at 1:07 PM, Máté Délceg <delcegmate@gmail.com> wrote:
Hi all,

My problam is following. I have created a desktop app, which works with datas from the cloud sql database. On my pc it works fine but if anybody else try to use it from other computers, they can't get access to the database because they didn't have the oauth key. Are there any opportunity to handle this situation or cloud sql works fine only with webapps?

Thanks for your help and time,
   Máté

--
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/57a6ea35-ddc1-4543-8166-526fa805b5d4%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.



--
Joe Faith | Product Manager | Google Cloud

--
You received this message because you are subscribed to a topic in the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-cloud-sql-discuss/6WL3UrmXVLw/unsubscribe.
To unsubscribe from this group and all its topics, 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/CAHNz2%3D9Emu9UE5y_PWn81sxHF52zNrT-s5q5jqj3NvMqWRt9TQ%40mail.gmail.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
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/CANM9f61rYN%2BqRWmhY5VOGZPoir_3E5TZzLQPbm0-c3HkE0e0pg%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
Posted by at No comments:
Subscribe to: Posts (Atom)