Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Location
    Russia
    Posts
    7

    Unanswered: Informix ISAM error 4566

    Hi!

    Where i can find description for follow error:

    Error mxODBC.OperationalError:('S1000', -271, '[Informix][Informix ODBC Driver][Informix]Could not insert new row into the table.', 4566)

    $ finderr 271
    -271 Could not insert new row into the table.

    This problem has many possible causes, including a locked table or a
    full disk. Check the accompanying ISAM error code for more
    information.

    table is not locked, dbspace is half-empty, informix log is usual...

    $ finderr 4566
    Message number -4566 not found.

    How to get description for this ISAM error message?

    Tnx in advance.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: Informix ISAM error 4566

    Originally posted by Suguby
    Hi!

    Where i can find description for follow error:

    Error mxODBC.OperationalError'S1000', -271, '[Informix][Informix ODBC Driver][Informix]Could not insert new row into the table.', 4566)

    $ finderr 271
    -271 Could not insert new row into the table.

    This problem has many possible causes, including a locked table or a
    full disk. Check the accompanying ISAM error code for more
    information.

    table is not locked, dbspace is half-empty, informix log is usual...

    $ finderr 4566
    Message number -4566 not found.

    How to get description for this ISAM error message?

    Tnx in advance.
    Hi,
    This error can be that you do not have free space or that do not satisfy a constraint. It tries to execute the sentence gave the dbaccess to see the isam error.

    Gustavo.

  3. #3
    Join Date
    Nov 2003
    Location
    Russia
    Posts
    7
    Tnx for u replay

    space in chuncks is present
    $ onstat -d

    Informix Dynamic Server 2000 Version 9.21.HC3 -- On-Line -- Up 31 days 03:25:57 -- 265864 Kbytes

    Dbspaces
    address number flags fchunk nchunks flags owner name
    [skiped]
    cb255de8 3 0x1 3 1 N informix workdbs1
    cb246e30 4 0x1 4 3 N informix workdbs2
    5 active, 2047 maximum

    Chunks
    address chk/dbs offset size free bpages flags pathname
    [skiped]
    cb255598 3 3 0 500000 213022 PO- /informix/chunks/db1
    cb255700 4 4 0 1000000 85 PO- /informix/chunks/db2
    cb255868 5 4 0 500000 0 PO- /informix/chunks/db3
    [skiped]
    cb255b38 7 4 0 1000000 838840 PO- /informix/chunks/db4
    7 active, 2047 maximum

    /informix/chunks/db4 is practically empty...

    table is very simple, without any constraint:
    CREATE TABLE usd_history (
    id SERIAL(1) NOT NULL,
    dt DATE NOT NULL,
    value FLOAT
    )

    oncheck -cI get no error...

    i need description for ISAM error 4566. Which utilites/manuals i can see?

  4. #4
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Originally posted by Suguby
    Tnx for u replay

    space in chuncks is present
    $ onstat -d

    Informix Dynamic Server 2000 Version 9.21.HC3 -- On-Line -- Up 31 days 03:25:57 -- 265864 Kbytes

    Dbspaces
    address number flags fchunk nchunks flags owner name
    [skiped]
    cb255de8 3 0x1 3 1 N informix workdbs1
    cb246e30 4 0x1 4 3 N informix workdbs2
    5 active, 2047 maximum

    Chunks
    address chk/dbs offset size free bpages flags pathname
    [skiped]
    cb255598 3 3 0 500000 213022 PO- /informix/chunks/db1
    cb255700 4 4 0 1000000 85 PO- /informix/chunks/db2
    cb255868 5 4 0 500000 0 PO- /informix/chunks/db3
    [skiped]
    cb255b38 7 4 0 1000000 838840 PO- /informix/chunks/db4
    7 active, 2047 maximum

    /informix/chunks/db4 is practically empty...

    table is very simple, without any constraint:
    CREATE TABLE usd_history (
    id SERIAL(1) NOT NULL,
    dt DATE NOT NULL,
    value FLOAT
    )

    oncheck -cI get no error...

    i need description for ISAM error 4566. Which utilites/manuals i can see?
    Hi Suguby,

    The error 4566 is of ODBC not Informix.
    Please test insert from dbaccess for see isam error.

    dbaccess database 2>error.log <<EOF
    insert into table ....
    EOF

    Gustavo

  5. #5
    Join Date
    Nov 2003
    Location
    Russia
    Posts
    7
    It look like miracle, but after dinner script begin work... %)
    without any changes from my side...

    May be any user block this table?... but how?... OK, will see.

    Any case tnx for u assistance

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •