MySQL Bugs: #34117: Migration Toolkit appears to hang

Bug #34117	Migration Toolkit appears to hang
Submitted:	28 Jan 2008 23:22	Modified:	4 Jul 2011 16:15
Reporter:	Martin Zardecki	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S2 (Serious)
Version:	1.1.12, 1.1.13	OS:	Windows (XP Pro)
Assigned to:		CPU Architecture:	Any
Tags:	Oracle Hang

Description:
Trying to migrate large DB (700+ tables) from Oracle to MySQL, has been sitting at "Executing... Fetch PK Information" for two hours.

How to repeat:
See above.

Trace from advanced tab/button:

Getting version information ... 
Initializing JDBC driver ... 
Driver class Oracle Thin JDBC Driver using SID
Build simple Oracle datatypes.
Call Oracle stored procedure ANALYZE_SCHEMA for EDMS.
CALL DBMS_UTILITY.ANALYZE_SCHEMA(?,  'ESTIMATE', 50, 0, 'FOR TABLE')
Fetch the number of tables in the schema EDMS.
SELECT COUNT(*) AS TABLECOUNT FROM ALL_TABLES t, ALL_OBJECTS a WHERE t.OWNER=? AND a.OWNER=t.OWNER AND a.OBJECT_NAME=t.TABLE_NAME AND  a.OBJECT_TYPE='TABLE' AND a.STATUS='VALID' 
Fetching 702 table(s) of the schema EDMS.
SELECT t.* FROM ALL_TABLES t, ALL_OBJECTS a WHERE t.OWNER=? AND a.OWNER=t.OWNER AND a.OBJECT_NAME=t.TABLE_NAME AND  a.OBJECT_TYPE='TABLE' AND a.STATUS='VALID' ORDER BY t.OWNER, t.TABLE_NAME
Fetch column information.
Fetching column information.
SELECT tc.TABLE_NAME, tc.COLUMN_NAME,  tc.DATA_TYPE, tc.DATA_TYPE_MOD, tc.CHAR_LENGTH, tc.DATA_LENGTH,  tc.DATA_PRECISION, tc.DATA_SCALE, tc.NULLABLE, tc.DEFAULT_LENGTH,  tc.DENSITY, tc.NUM_NULLS, tc.NUM_BUCKETS, tc.CHARACTER_SET_NAME,  tc.DATA_DEFAULT FROM ALL_TAB_COLUMNS tc, ALL_TABLES t WHERE tc.OWNER=? AND t.OWNER=tc.OWNER AND tc.TABLE_NAME=t.TABLE_NAME ORDER BY tc.TABLE_NAME, tc.COLUMN_ID
Fetch PK information.

Thank you for a problem report. Have you tried to run that statements against Oracle directly, from SQL*Plus (with placeholder ? replaced by proper value)? How fast do they run in Oracle?

Executed the following query in 10.335 seconds and retrieved 13665 rows using separate query tool against oracle.

SELECT 
    tc.TABLE_NAME, 
    tc.COLUMN_NAME, 
    tc.DATA_TYPE, 
    tc.DATA_TYPE_MOD, 
    tc.CHAR_LENGTH, 
    tc.DATA_LENGTH, 
    tc.DATA_PRECISION, 
    tc.DATA_SCALE, 
    tc.NULLABLE, 
    tc.DEFAULT_LENGTH, 
    tc.DENSITY, 
    tc.NUM_NULLS, 
    tc.NUM_BUCKETS, 
    tc.CHARACTER_SET_NAME, 
    tc.DATA_DEFAULT 
FROM 
    ALL_TAB_COLUMNS tc, 
    ALL_TABLES t 
WHERE 
    tc.OWNER         = 'OWNER' 
    AND t.OWNER      = tc.OWNER 
    AND tc.TABLE_NAME= t.TABLE_NAME 
ORDER BY 
    tc.TABLE_NAME, 
    tc.COLUMN_ID

Please, specify the exact Oracle RDBMS and JDBC driver versions used.

Oracle version

C:\Documents and Settings\mpzarde>sqlplus ****/****@*********
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jan 30 09:05:31 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:
Oracle9i Release 9.2.0.3.0 - Production
JServer Release 9.2.0.3.0 - Production

JDBC Drivers ARE:

Oracle9i 9.2.0.8 JDBC Drivers, for use with JDK 1.4.

Please, try to repeat with a newer version, from GUI Tools 5.0-r13, and inform about the results.

Bug #40198 was marked as a duplicate of this one.

Bug #32660 was marked as a duplicate of this one.

Bug #24666 was marked as a duplicate of this one.

All reporters:

Can anybody upload a dump (exp results) for the problematic schema? I can not repeat the problem with a simple tables created like this:

  1   begin
  2     for i in 10..10000
  3     loop
  4       execute immediate
  5         'create table t'||i||' (c1 number primary key, c2 number)';
  6     end loop;
  7*  end;
SQL> /

I can't upload the dump file to the mysql site because :
- the file is too strong  (the compressed file is over 30 Mo)
- the file contains confidential data.
Where can i upload it ?

What's news ?
Did you can use my oracle dump file ?
Did you see where they are a problem ?
Thanks

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Example of my "problem"

Attachment: Migration_Toolkit.JPG (image/jpeg, text), 59.55 KiB.

Sorry to open an old "bug"...but my problem seems solved(sorry for the english faults). I had the same thing with Fetch PK Information screen who stay a very long time, but the situation is good now. I will be more patient the next time.
(20 minutes for 273 tables, I have a schema of more than 500 tables...I hope for a solution under 1 hour)

We do not support Migration Toolkit any more, sorry.