Re: [google-cloud-sql-discuss] Re: Urgent - All Stored procedures(MYISAM engine) is being automatically roll-backed in our First Generation Google Cloud SQL.

​

The following list of information items may help us progress towards a resolution:

- Store procedure name : SP_ACTIVE_CUSTOMERLIST

- How was stored procedure created.  : MyISAM engine

- Which command was used to list your stored procedures when they rolled back.

SHOW PROCEDURE STATUS WHERE DB = 'EI_INT';

- How did you modify the stored procedures.  

ACTIVE CC LIST stored procedure has temp table, I added new column.

- Date and time when the rollbacks first happened. : 2017-03-01 05:04:41

- Do your stored procedures run without issues on other instances in the same project?

No, I got issue in other instance in the same project

- What happens if you create a simple test procedure? Does it roll back as the others?

I created simple test procedure, But that one not roll back like the others

Simple Test Procedure:

DROP PROCEDURE IF EXISTS SP_CANDIDATE_DETAILS_INSERT; CREATE PROCEDURE SP_CANDIDATE_DETAILS_INSERT( IN CANDIDATENAME VARCHAR(50), IN EMAILID VARCHAR(50), IN DATEOFBIRTH DATE, IN CONTACTNO VARCHAR(10), IN REMARK TEXT, OUT SUCCESS_FLAG INTEGER) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; SET SUCCESS_FLAG=0; END; START TRANSACTION; SET AUTOCOMMIT = 0; SET SUCCESS_FLAG = 0; IF(REMARK='') THEN SET REMARK=NULL; END IF; IF(CANDIDATENAME IS NOT NULL AND EMAILID IS NOT NULL AND DATEOFBIRTH IS NOT NULL AND CONTACTNO IS NOT NULL) THEN INSERT INTO CANDIDATE_DETAILS (CANDIDATE_NAME, EMAIL_ID, DATE_OF_BIRTH, CONTACT_NO, REMARKS) VALUES (CANDIDATENAME, EMAILID, DATEOFBIRTH, CONTACTNO, REMARK); SET SUCCESS_FLAG=1; END IF; COMMIT; END;

- What is the result of running the SHOW PROCEDURE STATUS; command?  

Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation
EI_INT	SP_ACTIVE_CUSTOMERLIST	PROCEDURE	EIPHPDEV@%	28-02-2017 06:01:58	28-02-2017 06:01:58	DEFINER		utf8	utf8_general_ci	utf8_general_ci

Regards,

SATTANATHAN D

​​

On Thu, Mar 9, 2017 at 9:17 PM, 'George (Cloud Platform Support)' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

​​

The following list of information items may help us progress towards a resolution:

- Store procedure name.

- How was stored procedure created.  

- Which command was used to list your stored procedures when they rolled back.

- How did you modify the stored procedures.  

- Date and time when the rollbacks first happened.

- Do your stored procedures run without issues on other instances in the same project?

- What happens if you create a simple test procedure? Does it roll back as the others?

- What is the result of running the SHOW PROCEDURE STATUS; command?  

--
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/L7pvTcaARtU/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/7c560991-fd47-4a31-9d3f-d429f0ccddec%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/CABgY%2B3%3D4coQ5rEjdPNc%3DJyZMbSp%2BdZB8czVERiagNsuU90Rb-Q%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.