Error 2007 During READNEXT statement

[jlogdup]

Good Morning, I got the error 2007 during a READNEXT statement:
****************************Error****************************
jBASE: Fatal memory signal seen on process id 7896
jBASE: Because of this, there may be file corruption on file .
\CHECKWRITER
** Error [ READNEXT_ERROR ] **
READNEXT operation failed , error number 2007 on file .\CHECKWRITER
****************************End Error****************************

This is something I need to fix with jcheck command, or just the
jbackup/jrestore can handle?
Thanks in advance for your help.

Below is the jdiag output
************************************jdiag
Result**************************************************
:jdiag
jdiag - jBASE diagnostic

System Information
==================

System : WinXP ICMIAPD01 5.2 i386
OS Release : Win XP Build 3790 Service Pack 2
NT User : encpdadmn
jBASE User (JBCLOGNAME) : ADMINISTRATOR
Time : Wed Dec 23 11:11:56 2009

Environment
===========

JBCRELEASEDIR : 'E:\JBASE30'
JBCGLOBALDIR : 'E:\JBASE30'
HOME : 'E:\Pick\ACCOUNTS\SYSPROG'
JEDIFILEPATH : '.'
JEDIFILENAME_MD : 'E:\Pick\ACCOUNTS\SYSPROG\MD'
MD file is (DICT) : 'E:\Pick\ACCOUNTS\SYSPROG\MD]D'
JEDIFILENAME_SYSTEM : 'E:\Pick\SYSTEM\SYSTEM'
SYSTEM File is (DICT) : 'E:\Pick\SYSTEM\SYSTEM]D'
JBCBASETMP : 'e:\JBASE30\tmp\ADMINWORK'
JBCNOINTERNAL : Not Set
JEDI_NOSHMEM : Not Set
RELEASE Information : Major 3.4 , Minor 3 , Patch 0159
Spooler dir (Default) : 'E:\JBASE30\jspooler'
JBCEMULATE : 'sequoia'
Object path (JBCOBJECTLIST) : 'E:\Pick\ACCOUNTS\SYSPROG\lib;E:\Pick
\ACCOUNTS\INS
TA-CHECK\lib;E:\Pick\ACCOUNTS\SALES\lib;E:\Pick\ACCOUNTS\JET-INSTALL
\lib;E:\Pick
\ACCOUNTS\LIBRARY\lib;E:\Pick\ACCOUNTS\SYSPROG\lib;E:\Pick\ACCOUNTS
\ACCUTERM\lib
'
VC++ Registry : Version 6; Path C:\Program Files
\Microsoft Visual
Studio\VC98
Program dir (JBCDEV_BIN) : 'E:\Pick\ACCOUNTS\SYSPROG\bin'
Subroutine dir (JBCDEV_LIB) : 'E:\Pick\ACCOUNTS\SYSPROG\lib'
There are No warnings, jBASE seems to be loaded correctly

************************************End jdiag
Result**************************************************

[Jim Idle]

Please remember to use the group search facility at jbase.markmail.org:

http://jbase.markmail.org/search/?q=error%202007

Where you will find that your file is corrupt, and may follow all the threads about repairing/reloading them.

Jim

> --
> Please read the posting guidelines at:
> http://groups.google.com/group/jBASE/web/Posting%20Guidelines
>
> IMPORTANT: Type T24: at the start of the subject line for questions
> specific to Globus/T24
>
> To post, send email to jB...@googlegroups.com
> To unsubscribe, send email to jBASE-un...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/jBASE?hl=en

[jlogdup]

Thank you Jim, It looks like Is size problem because the file is close
to 2gb:
:JCHECK CHECKWRITER
Checking file CHECKWRITER
WARNING! Record Key length greater than 250 characters, KeyLen
00180000
ERROR! Group 46341 Scanning record key, skipping rest of group
ERROR! SeekValue 78015b00 greater then file size 7503d000
ERROR! Group 82350 Problem with seek value 0000000078015b00, error 0
ERROR! SeekValue 7503e000 greater then file size 7503d000
ERROR! Group 98422 Problem with seek value 000000007503e000, error 0
ERROR! Group 98422 InGroup Reclen exceeds available, skipping rest of
group
ERROR! SeekValue 7503d034 greater then file size 7503d000
ERROR! Group 175790 Cannot Seek to offset 000000007503d034
ERROR! Freespace EOF 000000007503d000 incorrect should be
000000007503f000

:jstat -v CHECKWRITER
File .\CHECKWRITER
Type=J4 , Hash method = 4
Create at Sun May 24 09:01:34 2009
Groups = 190027 , Frame size = 4096 bytes , Secondary Record Size =
8192 bytes
Restore re-size parameters : (none)
File size = 1963204608 bytes , Inode = 12833 , Device = Id 47057
Last Accessed Mon Dec 28 18:47:54 2009 , Last Modified Mon Dec 28
18:47:54 2009
Backup = YES , Log = YES , Rollback = YES , Network = NO

.\CHECKWRITER: File is corrupt

I would need more time to interpret the output of jstat. According to
its output, can I resize this file? or definetly i have to purge and/
or distribute it?

Thanks a lot for your help.

> >http://groups.google.com/group/jBASE?hl=en- Hide quoted text -
>
> - Show quoted text -

[Jim Idle]

You may be able to resize it, but I doubt it, I think you should archive some of the entries basically. You are on 3.x and you can now get 5.x through jBASE I believe, you are on XP and should probably be looking at Windows 7 now and so on. Technology moves on and while it doesn't usually behoove you to be shipping windows 7 and jBASE 5.x the day after they come out, it does behoove you to keep up with the times.

Generally if you have a single file with 2GB of data in it, it tells you that perhaps your application design is a bit wonky. You could distribute the files, that is true, but then if you try and SELECT from the whole distributed file, you are hammering the system for no good reason (even with indexes in some cases). Does this file not have some sort of archiving scheme, or does your application really need to keep 2GB of written checks altogether in one lump? (Hint: the answer to that is no ;-).