Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    hungary
    Posts
    1

    Question Unanswered: delete logical log

    Hi all!

    My problem:

    I used ontape -c to backup my logical log on tape drive.
    Now is that full. I made a big update an I think the IDS cannt commit the work:

    My online log show the next:

    08:36:53 Informix Dynamic Server Version 7.30.UC7
    08:36:53 Who: Session(2877, mtssped@riba, 908, 0)
    Thread(8384, sqlexec, 0, 3)
    File: rstrans.c Line: 2117
    08:36:53 Results: Log record (OLDRSAM:RDELETE) in log 40139, offset 0x4a190 was not rolled back
    08:36:53 Action: Use 'onlog' to view the transaction and repair manually.
    08:37:02 See Also: /tmp/af.20c0b814, shmem.20c0b814.0
    08:38:16 Assert Failed: Rollback error 126
    08:38:16 Informix Dynamic Server Version 7.30.UC7
    08:38:16 Who: Session(2877, mtssped@riba, 908, 0)
    Thread(8384, sqlexec, 0, 3)
    File: rsextlog.c Line: 1414
    08:38:16 Results: Log record (OLDRSAM:RDELETE) in log 40139, offset 0x4a190 was not rolled back
    08:38:16 Action: Use 'onlog' to view the transaction and repair manually.
    08:38:22 See Also: /tmp/af.20c0b814, shmem.20c0b814.1
    08:39:33 Assert Failed: Dynamic Server must abort
    08:39:33 Informix Dynamic Server Version 7.30.UC7
    08:39:33 Who: Session(2877, mtssped@riba, 908, 0)
    Thread(8384, sqlexec, 0, 3)
    File: rslog.c Line: 3152
    08:39:33 Results: Dynamic Server must abort
    08:39:33 Action: Reinitialize shared memory
    08:39:35 See Also: /tmp/af.20c0b814, shmem.20c0b814.2
    08:40:34 rslog.c, line 3152, thread 8384, proc id 924, Dynamic Server must abort.
    08:40:34 PANIC: Attempting to bring system down


    The problem that I can't initialize the shared memory to delete the logs...



    Pls help me becouse its very dangerous situation for me


    Thanks a lot....

  2. #2
    Join Date
    Mar 2004
    Posts
    18

    Dropping logs files

    In ordet to Drop a log file:

    onparams -d -l number -y or
    onutil DROP LOG number command,
    depending on the database server.

Posting Permissions

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