Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: DBMail: users

dbmail3-migration : sql-convert-2_2-3_0.sql error

 

 

DBMail users RSS feed   Index | Next | Previous | View Threaded


pascal.longrais at orange

Apr 17, 2012, 1:30 AM

Post #1 of 3 (368 views)
Permalink
dbmail3-migration : sql-convert-2_2-3_0.sql error

Hello

I am following Reindl Harald dbmail3-migration procedures.

Upstream version dbmail v2.2.17 with mysql 5.5.21.

Target server is dbmail v3.0.2 with mysql 5.5.21 and Reindl's proposed
config setup files in dbmail3-migration.zip package (dbmail.conf, my.cnf).

Used scenario was:

1) mysqldump dbmail from v2.2.17

2) create fresh new dbmail v3 database

3) import mysqldump.sql

3) run sql-convert-2_2-3_0.sql

After waiting several hours dodropkeys() procedure to be done, I got the
following error:

....

--------------
DROP TABLE IF EXISTS `dbmail_envelope`
--------------

--------------
CREATE TABLE `dbmail_envelope` (
`physmessage_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`envelope` TEXT NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `physmessage_id_1` (`physmessage_id`),
UNIQUE KEY `physmessage_id_2` (`physmessage_id`,`id`),
CONSTRAINT `dbmail_envelope_ibfk_1` FOREIGN KEY (`physmessage_id`)
REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
--------------

ERROR 1005 (HY000) at line 77: Can't create table
'dbmail.dbmail_envelope' (errno: 150)


Thanks for your help
Pascal


_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail


harald.leithner at itronic

Apr 17, 2012, 1:50 AM

Post #2 of 3 (346 views)
Permalink
Re: dbmail3-migration : sql-convert-2_2-3_0.sql error [In reply to]

There is a problem in the sql Script from Harald Reindl.

The script creates the envelope table to early.

You could try to use the 2_2-3_0.mysql script in sql/mysql directory found
in the dbmail.tar.gz

after "DROP PROCEDURE IF EXISTS dodropkeys;"

regards,

Harald

Am 17.04.2012, 10:30 Uhr, schrieb Pascal Longrais
<pascal.longrais [at] orange>:


> Hello
>
> I am following Reindl Harald dbmail3-migration procedures.
>
> Upstream version dbmail v2.2.17 with mysql 5.5.21.
>
> Target server is dbmail v3.0.2 with mysql 5.5.21 and Reindl's proposed
> config setup files in dbmail3-migration.zip package (dbmail.conf,
> my.cnf).
>
> Used scenario was:
>
> 1) mysqldump dbmail from v2.2.17
>
> 2) create fresh new dbmail v3 database
>
> 3) import mysqldump.sql
>
> 3) run sql-convert-2_2-3_0.sql
>
> After waiting several hours dodropkeys() procedure to be done, I got the
> following error:
>
> ....
>
> --------------
> DROP TABLE IF EXISTS `dbmail_envelope`
> --------------
>
> --------------
> CREATE TABLE `dbmail_envelope` (
> `physmessage_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
> `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
> `envelope` TEXT NOT NULL,
> PRIMARY KEY (`id`),
> UNIQUE KEY `physmessage_id_1` (`physmessage_id`),
> UNIQUE KEY `physmessage_id_2` (`physmessage_id`,`id`),
> CONSTRAINT `dbmail_envelope_ibfk_1` FOREIGN KEY (`physmessage_id`)
> REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE
> CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8
> --------------
>
> ERROR 1005 (HY000) at line 77: Can't create table
> 'dbmail.dbmail_envelope' (errno: 150)
>
>
> Thanks for your help
> Pascal
>
>
> _______________________________________________
> DBmail mailing list
> DBmail [at] dbmail
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail


h.reindl at thelounge

Apr 17, 2012, 1:52 AM

Post #3 of 3 (352 views)
Permalink
Re: dbmail3-migration : sql-convert-2_2-3_0.sql error [In reply to]

hm - interesting

this did the upgrade on our main production server
without any problem, but not easy to say since
it is a one-shot thing :-(

Am 17.04.2012 10:50, schrieb ITronic Harald Leithner:
> There is a problem in the sql Script from Harald Reindl.
>
> The script creates the envelope table to early.
>
> You could try to use the 2_2-3_0.mysql script in sql/mysql directory found in the dbmail.tar.gz
>
> after "DROP PROCEDURE IF EXISTS dodropkeys;"
>
> regards,
>
> Harald
>
> Am 17.04.2012, 10:30 Uhr, schrieb Pascal Longrais <pascal.longrais [at] orange>:
>
>
>> Hello
>>
>> I am following Reindl Harald dbmail3-migration procedures.
>>
>> Upstream version dbmail v2.2.17 with mysql 5.5.21.
>>
>> Target server is dbmail v3.0.2 with mysql 5.5.21 and Reindl's proposed
>> config setup files in dbmail3-migration.zip package (dbmail.conf, my.cnf).
>>
>> Used scenario was:
>>
>> 1) mysqldump dbmail from v2.2.17
>>
>> 2) create fresh new dbmail v3 database
>>
>> 3) import mysqldump.sql
>>
>> 3) run sql-convert-2_2-3_0.sql
>>
>> After waiting several hours dodropkeys() procedure to be done, I got the
>> following error:
>>
>> ....
>>
>> --------------
>> DROP TABLE IF EXISTS `dbmail_envelope`
>> --------------
>>
>> --------------
>> CREATE TABLE `dbmail_envelope` (
>> `physmessage_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
>> `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
>> `envelope` TEXT NOT NULL,
>> PRIMARY KEY (`id`),
>> UNIQUE KEY `physmessage_id_1` (`physmessage_id`),
>> UNIQUE KEY `physmessage_id_2` (`physmessage_id`,`id`),
>> CONSTRAINT `dbmail_envelope_ibfk_1` FOREIGN KEY (`physmessage_id`)
>> REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
>> ) ENGINE=InnoDB DEFAULT CHARSET=utf8
>> --------------
>>
>> ERROR 1005 (HY000) at line 77: Can't create table
>> 'dbmail.dbmail_envelope' (errno: 150)
>>
>>
>> Thanks for your help
>> Pascal
>>
>>
>> _______________________________________________
>> DBmail mailing list
>> DBmail [at] dbmail
>> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
> _______________________________________________
> DBmail mailing list
> DBmail [at] dbmail
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

--

Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/

http://www.thelounge.net/signature.asc.what.htm
Attachments: signature.asc (0.26 KB)

DBMail users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.