Re: console: Failed to load databases, unable to access via any method

Cannot access it via command line, either...no method seems to be working.

The longer queries are performed by python scripts running as cron jobs on appengine.  I'd hardly think a simple count statement counts as a long query, and in any case we get the same results there as well.


On Tuesday, May 8, 2012 3:23:35 PM UTC-7, rcleveng wrote:

Try using the command line tool vs. the web tool. The web tool isn't designed for long queries.

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

Rob

On Tue, May 8, 2012 at 3:17 PM, Jacob Padgett <jacob@fdgweb.com> wrote:

Instance name is iabalpadtest:iabreportsection. Screenshot attached...it's been down for about a half hour.


In addition to the periodic complete outages, we've been having sporadic issues with this particular instance. Restarts have not helped.  Various queries on one db in the instance in particular either periodically fail, experience unusual timeouts, or come back with inconsistent results. We've ported the data out, get expected results on the data itself when loaded in a different database.

Attempts to build 1:1 views off of a table with approximately 800,000 rows only return 8,000 rows. Additionally, the following queries give drastically different results:
(unique_id is the primary key)
SELECT COUNT(`unique_id`) FROM `instance` returns expected number of rows, approx. 800,000
select count(distinct unique_id) from instance returns only approx 8,000...or around 1% of the total. Manual verification of the data via dump and restore to a local instance of my_sql confirms there are no duplicate primary keys.

We really need help with first, getting the instance running, and secondly, understanding into why our queries are not working....