Re: Nivana instead of index

Have you checked that your log files are not running full during the
index creation? Having autolog on can solve that problem, but first you
will have to create a complete database backup before you can switch it
on. It is just a guess. Otherwise have a look at your knldiag and
knldiag.err files in your data directory.

Regards,

Filip 


On Fri, 2005-03-25 at 14:14, Novad Protikin wrote:

    hi,
    
    I have a table with 20'000'000 rows (it's extracted
    from the freedb database).
    Unfortunately I haven't been able to create an index
    on it (composed of 2 int fields).
    I send the CREAT INDEX via an ODBC query tool and 
    then I wait and wait. 
    I even let it run overnight. Still not ready in the
    next morning.
    The hard disc LED did not show any activity.
    I broke off, rebooted and tried it several more times
    now.
    No hard disc accesses, CPU of kernel - process is 0 %.
    
    I started the MaxDB Database Manager to check the
    activity. At first this works.
    Then after about 10 minutes, the Database Manger stops
    to respond after trying a Refresh.
    
    With a smaller table with 1'626'571 rows, I could
    create some indexes rather quickly.
    
    I use the windows MaxDb version 7.6 and my machine is
    a Pentium 3.2  with 1GB Ram and a serial-ATA-hard
    disc, so that should be ok...
    
    
    Any ideas? Is there a setting that I have to change?
    
    wiser
    
    
    
                
    __________________________________ 
    Do you Yahoo!? 
    Yahoo! Small Business - Try our new resources site!
    http://smallbusiness.yahoo.com/resources/ 
    
    -- 
    MaxDB Discussion Mailing List
    For list archives: http://lists.mysql.com/maxdb
    To unsubscribe:    
http://lists.mysql.com/maxdb?unsub=filip.sergeys@xxxxxxxxxxxxxxxx
    

-- 
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
* System Engineer, Verzekeringen NV *
* www.verzekeringen.be              *
* Oostkaai 23 B-2170 Merksem        *
* 03/6416673 - 0477/340942          *
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*