Bitbucket Server in Google Cloud Sql

Santiago Arizti

I get this error when trying to install Bitbucket Server:

But that is not true, when I log in as this user I can totally create temporary tables in this database.

My database is in a Google Cloud SQL server, which is based on MySql 5.7, here is an article that points out the differences:

https://cloud.google.com/sql/docs/features#differences

Here it says (paraphrasing a little): CREATE TEMPORARY TABLE statements inside transactions are not compatible because Second Generation instances use GTID replication.

This leads me to believe that Bitbucket is trying to create a temporary table inside a transaction during the setup.

What can I do about this?

thanks for your help

 

--

edit.

I did read this article that talks about binary logging: https://confluence.atlassian.com/bitbucketserver/connecting-bitbucket-server-to-mysql-776640382.html

I am using an allowed binlog format according to the article and this output:

@binlog_format;

+-----------------+

@binlog_format |

+-----------------+

| ROW             |

+-----------------+

 

Ana Retamal

Hi Santiago! At the moment it won't be possible to use Google Cloud SQL with Bitbucket Center for the reason explained at BSERV-4964:

Note: This precludes the use of Google Cloud SQL, which enforces the use of GTID

You'll need to use one of the databases listed in the Supported platforms for Bitbucket Server.

Let us know if you have any questions!

Ana