upgrading 3.0.11 -> 3.1.17 w/ mysql upgrade

[sgw]

Hello, could someone help me out here?

I want to upgrade from 3.0 to 3.1 (first step in the two-step-upgrade to 3.2.8 ) and I get problems at the step running scripts/DBUpdate-to-3.1.mysql.sql:

ERROR 1005 (HY000) at line 231: Can't create table 'otrs2.#sql-394_7a' (errno: 121)
ERROR 1005 (HY000) at line 234: Can't create table 'otrs2.#sql-394_7a' (errno: 121)
ERROR 1005 (HY000) at line 235: Can't create table 'otrs2.#sql-394_7a' (errno: 121)
ERROR 1005 (HY000) at line 236: Can't create table 'otrs2.#sql-394_7a' (errno: 121)
ERROR 1005 (HY000) at line 239: Can't create table 'otrs2.#sql-394_7a' (errno: 121)

This is an ubuntu 12.04 server, and I know already that this has to do with upgrading mysql on the way.

I already dumped the whole db and converted all the tables to InnoDB.

$ sudo bin/otrs.CheckDB.pl
Trying to connect to database
DSN: DBI:mysql:database=otrs2;host=localhost;port=3306;
DatabaseUser: otrs

It looks Ok!

--

But still those errors! What to do here?

Thanks in advance, Stefan


Addition:

restored my backup (it's a VM!) and started over.
I now plan to simply NOT upgrade mysql while doing my other stuff.
We'll see.

Addition 2:

I attended to install the OTRS-Upgrade *without* any mysql-package-upgrades.
Even then the script failed!
I clone the VM and will try my luck in the created test-box.

Is there a way to export data from the old OTRS and import into a fresh installation of the latest Release 3.2.8?
I could avoid those steps then.

[crythias]

It's a problem creating a table with a duplicate key...
A bit hard to fix, but take a look at http://thenoyes.com/littlenoise/?p=81

I'm sorry that I don't have a better answer with regard to this.

[sgw]

Thanks for the pointer ... I was already able to do the upgrade(s) correctly.
Rolled back twice .. in the end I was successful by dumping the DB ... editing the engine-type of all the tables and reimporting.
The first step was harder ... from 3.1.17 to 3.2.8 it was rather easy then

EDIT:

for reference: maybe others will face these issues as well.

I was able to modify/convert my database following this howto

http://www.ryv.id.au/2013/02/upgrading- ... o-321.html