logo       
Google Custom Search
    AddThis Social Bookmark Button

mdbtools with big files: msg#00002

Subject: mdbtools with big files
Hello

Lately I start to work with mdb-tools.

I try this with small files & everything is ok.

When I try with big files I get the next error:

# mdb-schema lib_data.mdb
-------------------------------------------------------------
-- MDB Tools - A library for reading MS Access database files
-- Copyright (C) 2000-2004 Brian Bruns
-- Files in libmdb are licensed under LGPL and the utilities under
-- the GPL, see COPYING.LIB and COPYING files respectively.
-- Check out http://mdbtools.sourceforge.net
-------------------------------------------------------------



-- CREATE ANY Relationships ...

-- relationships are not supported for access
==================================

I get the version of the file:

# mdb-ver lib_data.mdb
JET4

==================================

I did strace on the file:

execve("/usr/bin/mdb-schema", ["mdb-schema", "lib_data.mdb"], [/* 29 vars */]) 
= 0
brk(0)                                  = 0x804c000
access("/etc/ld.so.preload", R_OK)      = -1 ENOENT (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY)      = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=26343, ...}) = 0
mmap2(NULL, 26343, PROT_READ, MAP_PRIVATE, 3, 0) = 0xb7fd5000
close(3)                                = 0
open("/usr/lib/libmdb.so.0", O_RDONLY)  = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\320;\0\0004\0\0\0"..., 
512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=64580, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 
0xb7fd4000
mmap2(NULL, 116724, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 
0xb7fb7000
mmap2(0xb7fc6000, 8192, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xe) = 0xb7fc6000
mmap2(0xb7fc8000, 47092, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0xb7fc8000
close(3)                                = 0
open("/lib/libm.so.6", O_RDONLY)        = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0p4\0\0004\0\0\0"..., 
512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=149256, ...}) = 0
mmap2(NULL, 151680, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 
0xb7f91000
mmap2(0xb7fb5000, 8192, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x23) = 0xb7fb5000
close(3)                                = 0
open("/usr/lib/libglib-2.0.so.0", O_RDONLY) = 3
read(3, 
"\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\240\355\0\0004\0\0\0"..., 512) 
= 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=608408, ...}) = 0
mmap2(NULL, 608036, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 
0xb7efc000
mmap2(0xb7f8f000, 8192, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x93) = 0xb7f8f000
close(3)                                = 0
open("/lib/libncurses.so.5", O_RDONLY)  = 3
read(3, 
"\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\200\347\0\0004\0\0\0"..., 512) 
= 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=268880, ...}) = 0
mmap2(NULL, 268548, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 
0xb7eba000
mmap2(0xb7ef3000, 36864, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x38) = 0xb7ef3000
close(3)                                = 0
open("/lib/libreadline.so.5", O_RDONLY) = 3
read(3, 
"\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\360\316\0\0004\0\0\0"..., 512) 
= 512
fstat64(3, {st_mode=S_IFREG|0555, st_size=197572, ...}) = 0
mmap2(NULL, 200852, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 
0xb7e88000
mmap2(0xb7eb4000, 16384, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2c) = 0xb7eb4000
mmap2(0xb7eb8000, 4244, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0xb7eb8000
close(3)                                = 0
open("/lib/libc.so.6", O_RDONLY)        = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0@a\1\0004\0\0\0"..., 
512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=1229084, ...}) = 0
mmap2(NULL, 1234384, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 
0xb7d5a000
mmap2(0xb7e82000, 12288, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x128) = 0xb7e82000
mmap2(0xb7e85000, 9680, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0xb7e85000
close(3)                                = 0
open("/lib/libdl.so.2", O_RDONLY)       = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0p\n\0\0004\0\0\0"..., 
512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=9612, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 
0xb7d59000
mmap2(NULL, 12412, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 
0xb7d55000
mmap2(0xb7d57000, 8192, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1) = 0xb7d57000
close(3)                                = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 
0xb7d54000
set_thread_area({entry_number:-1 -> 6, base_addr:0xb7d546c0, limit:1048575, 
seg_32bit:1, contents:0, read_exec_only:0, limit_in_pages:1, seg_not_present:0, 
useable:1}) = 0
mprotect(0xb7d57000, 4096, PROT_READ)   = 0
mprotect(0xb7e82000, 8192, PROT_READ)   = 0
mprotect(0xb7eb4000, 4096, PROT_READ)   = 0
mprotect(0xb7f8f000, 4096, PROT_READ)   = 0
mprotect(0xb7fb5000, 4096, PROT_READ)   = 0
mprotect(0xb7fc6000, 4096, PROT_READ)   = 0
mprotect(0x804a000, 4096, PROT_READ)    = 0
mprotect(0xb7ff6000, 4096, PROT_READ)   = 0
munmap(0xb7fd5000, 26343)               = 0
brk(0)                                  = 0x804c000
brk(0x806d000)                          = 0x806d000
gettimeofday({1194449252, 958424}, NULL) = 0
stat64("lib_data.mdb", {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0
open("lib_data.mdb", O_RDONLY)          = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0
lseek(3, 0, SEEK_SET)                   = 0
read(3, "\0\1\0\0Standard Jet DB\0\1\0\0\0\265n\3b`\t\302U"..., 2048) = 2048
fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0
lseek(3, 8192, SEEK_SET)                = 8192
read(3, 
"\2\1\336\v\0\0\0\0\32\4\0\0Y\6\0\0\205\1\0\0\0\0\0\0\1\0\0\0\377\377\377\377"...,
 4096) = 4096
fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0
lseek(3, 24576, SEEK_SET)               = 24576
read(3, 
"\1\1\271\2\0\0\0\0\0\0\0\0\37\0\273\17v\0171\17\354\16\247\16b\16\35\16\330\r\223\r"...,
 4096) = 4096
fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0
lseek(3, 24576, SEEK_SET)               = 24576
read(3, 
"\1\1\271\2\0\0\0\0\0\0\0\0\37\0\273\17v\0171\17\354\16\247\16b\16\35\16\330\r\223\r"...,
 4096) = 4096
fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0
lseek(3, 51699712, SEEK_SET)            = 51699712
read(3, "\5\1\0\0\0@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 
4096) = 4096
fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0
lseek(3, 24576, SEEK_SET)               = 24576
read(3, 
"\1\1\271\2\0\0\0\0\0\0\0\0\37\0\273\17v\0171\17\354\16\247\16b\16\35\16\330\r\223\r"...,
 4096) = 4096
fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0
lseek(3, 51699712, SEEK_SET)            = 51699712
read(3, "\5\1\0\0\0@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 
4096) = 4096
fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0
lseek(3, 10211328, SEEK_SET)            = 10211328
read(3, 
"\1\1\250\17\273\t\0\0\0\0\0\0\1\0\270\17\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 
4096) = 4096
fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0
lseek(3, 51699712, SEEK_SET)            = 51699712
read(3, "\5\1\0\0\0@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 
4096) = 4096
fstat64(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 0), ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 
0xb7fdb000
write(1, "--------------------------------"..., 62) = 62
write(1, "-- MDB Tools - A library for rea"..., 62) = 62
write(1, "-- Copyright (C) 2000-2004 Brian"..., 39) = 39
write(1, "-- Files in libmdb are licensed "..., 67) = 67
write(1, "-- the GPL, see COPYING.LIB and "..., 60) = 60
write(1, "-- Check out http://mdbtools.sou";..., 45) = 45
write(1, "--------------------------------"..., 63) = 63
write(1, "\n\n", 2)                     = 2
write(1, "-- CREATE ANY Relationships ...\n", 32) = 32
write(1, "\n", 1)                       = 1
write(1, "-- relationships are not support"..., 46) = 46
close(3)                                = 0
exit_group(0)                           = ?

==================================
When I'm using odbc-mdb which come with mdb-tools the next error: "No 
tuples available at this result index".

How could I fix this problem?

Thanks for the help



-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/



Try Searching:
servers, voip, java, networking, microsoft ...
<Prev in Thread] Current Thread [Next in Thread>