Issues with Cloud SQL query parsing

[Glenn Molnar]

Hi,

We are suddenly seeing SQLExceptions when attempting to execute a Cloud SQL query, in a particular application environment as follows:

java.sql.SQLException: Wrong number of parameters: expected 0, was given 1 Query: delete from ppq.channel where clientId = ? Parameters: [7a8261ef-a3ff-480b-8024-05f959ccd762]

The error message does not make a whole lot of sense, as clearly the query has a ? parameter. This stopped working all of a sudden without any new code being deployed, but only in a single app engine application. The exact same code is running OK in other environments.

The only difference we have been able to spot is that the environment we are getting the error on is running appengine 1.9.23, but the others are are still working are running 1.9.22. Has something changed that we need to be aware of?

Thanks

[Ryan (Cloud Platform Support)]

Salutations Glenn,

Can you reply privately with your App ID and Cloud SQL instance.

Thanks

[Yann Le Bihan]

I have the exact same pb.

Yann

[Ryan (Cloud Platform Support)]

If anyone else runs into this issue please see this PIT.

On Tuesday, June 16, 2015 at 12:09:20 AM UTC-4, Glenn Molnar wrote:

[Ryan (Cloud Platform Support)]

Thank you all for bringing this to our attention. 

@All who posted messages to me you should be working now. If you still experience this error (even those who already messaged me) please go to the PIT and fill out the template.

[Yann Le Bihan]

Now, it works fine.

Thanks a lot for your quick reaction.

Yann Le Bihan | ya...@lebihan.bzh | +1 (415) 606-4890

--
You received this message because you are subscribed to a topic in the Google Groups "Google App Engine" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-appengine/Oc-wJvvCXgE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-appengi...@googlegroups.com.
To post to this group, send email to google-a...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/5b6b2338-2e16-4476-ac22-184a3b07a094%40googlegroups.com.

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

[Phil L]

Hi, 

I experience EXACTLY the same issue, newly deployed GAE apps (running newer appengine version) stopped working suddenly. The only way I was able to fix the issue was to roll back to an older version of my app (a 30+ days old version). That caused a hell of a mess, our apps simply stopped working.

Phil

On Tuesday, June 16, 2015 at 12:09:20 AM UTC-4, Glenn Molnar wrote:

[Ryan (Cloud Platform Support)]

This issue should have been fixed on the live server. If you are still seeing this please post on the PIT the required information.