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

Awesome, thanks!

Merry Christmas to you too! :-)

-- Razvan ME

On Tue, Dec 25, 2012 at 1:51 AM, Alessandro Alessio <alessalessio@gmail.com> wrote:

Hello Razvan

thanks for your reply. I`am actually out of office for holiday. I ll be back in 2 days and i ll send you the dump file.

 

tnx and merry christmas

2012/12/22 Razvan Musaloiu-E. <razvanm@google.com>

Quick update: I also tried the dump fragment from your email and it worked properly for my dummy table. If you still have issues with the import can you share the exact dump file with me?

Thanks!

Razvan ME

On Fri, Dec 21, 2012 at 10:10 AM, Razvan Musaloiu-E. <razvanm@google.com> wrote:

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