Re: Another "An unknown problem occurred (ERROR_RDBMS)"

Can you contact me directly with the name of your instance? Creating triggers works fine (I attached an import that works properly).

-- Razvan ME

On Fri, Dec 21, 2012 at 6:08 AM, Alessandro Alessio <alessalessio@gmail.com> wrote:

Update

Problem seems to be related to the creation of the trigger after the creation of the table.

This means that it is NOT possible to create triggers within a DB hosted in Google Cloud????!!

Here is the trigger creation:

LOCK TABLES `gesevento` WRITE;

/*!40000 ALTER TABLE `gesevento` DISABLE KEYS */;

/*!40000 ALTER TABLE `gesevento` ENABLE KEYS */;

UNLOCK TABLES;

/*!50003 SET @saved_cs_client      = @@character_set_client */ ;

/*!50003 SET @saved_cs_results     = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client  = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection  = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;

/*!50003 SET sql_mode              = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `win415`.`GESEVENTO_Trigger`

BEFORE UPDATE ON `win415`.`gesevento`

FOR EACH ROW

begin

if  (not(new.aperto = '1' and new.calcolato = '0'))

then

set new.idtipo = old.idtipo;

set new.desc = old.desc;

set new.data = old.data;

set new.aperto = old.aperto;

set new.calcolato = old.calcolato;

end if;

end */;;

DELIMITER ;

/*!50003 SET sql_mode              = @saved_sql_mode */ ;

/*!50003 SET character_set_client  = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection  = @saved_col_connection */ ;

Il giorno venerdì 21 dicembre 2012 12:01:11 UTC+1, Alessandro Alessio ha scritto:

Hi,

I created my bucket and uploaded mysql dump files into. (   mysqldump --user=<user> --password=<password> --hex-blob win415 > win415.sql    )

What i got into logs is       Failed to import gs://win415bucket/win415.sql: An unknown problem occurred (ERROR_RDBMS)

I checked and there is the use win415 on top of the dump file.

It only creates the first table and nothing more. 

Can someone please help me going through?

p.s.: after the table creation, there is a trigger creation for that table. i hope triggers are allowed onto google cloud