Skip to Content
author's profile photo Former Member
Former Member

loadercli timeout

Hello

I'm unable to export data via loadercli from a perfectly running maxdb instance (7.5.0.34)

I'm able to backup the db but i need to export a single user

The only way i know so far is to use loadercli

with the

TABLEEXTRACT USER DATA OUTSTREAM FILE <file> RECORDS

command.

When i launch this the command simply seems to hang, no output file is open, nor written

and the db seems to continue to work correctly

I look into knldiag.err and other db files but i see no errors there.

After a while (ten minutes or so) i get

ERR -25010

-25009

Failure in db communication (request): 3 = connection broken by TIMEOUT.

and the loadercli stops without any data output written.

If i trace the loadercli i see that it is waiting on a semop system call

(maybe is waiting the database to do the extraction operation?)

I remember to have done this in the past without problems and really nothing has changed

as far as i know since this is a stable release running some portals.

Question are:

What could be the cause?

Is possible to extend this timeout?

There is any other way to export data of a single db user?

thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 07, 2009 at 05:49 AM

    I've solved the problem enlarging the SESSION_TIMEOUT parameter

    (original value 15 minutes)

    The strange behaviour that i still i don't understand is that

    it takes half an hour prior to start writing the data output file

    for a database of 100K size.

    Strangely i've noticed that when i start loadercli

    in db manager i see a lot of sql calls execute while

    the database is substantially not used (just loadercli

    running to do the export)

    Anyway the problem was solved

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Lars Breddemann

      The database has just some hundreds records in every tables...it is nearly empty.

      The number of tables is around 200.

      To export command i use is the following

      loadercli -d psfdev -u dba,dba -E 0 <<EOF

      USE USER user password

      SQLMODE ORACLE

      SET MAXERRORCOUNT 999999

      CATALOGEXTRACT USER OUTSTREAM FILE 'filename'

      EOF

      If you need any other information let me know

      thanks

  • author's profile photo Former Member
    Former Member
    Posted on Aug 07, 2009 at 09:59 AM

    Hello,

    can you execute

    select * from domain.locks

    Maybe the loader waits for a lock request.

    Best Regards

    Wolfgang

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.