Subject Re: Firebird Memory Exhausted
Author call.assist
We have fixed this by taking a copy of the database structure via metadata and creating a brand new database from scratch
the data contained was kept on a copy but not needed as only ever 3 hours worth of current data

Cheers for the help

Andrew


--- In firebird-support@yahoogroups.com, "call.assist" <andrew@...> wrote:
>
> when i do a restore with -v :
>
> ...
> gbak: restoring privilege for user SUPUSER
> gbak: restoring privilege for user SUPUSER
> gbak: restoring privilege for user SVCUSER
> gbak: restoring privilege for user SVCUSER
> gbak: restoring privilege for user SVCUSER
> gbak: restoring privilege for user SVCUSER
> gbak: restoring privilege for user SVCUSER
> gbak: creating indexes
> gbak: restoring index RDB$PRIMARY12
> gbak: restoring index RDB$PRIMARY11
> gbak: restoring index REPL$I_LOG
> gbak: finishing, closing, and going home
> *** glibc detected *** ./gbak: corrupted double-linked list: 0x08c42a50 ***
> ======= Backtrace: =========
> /lib/libc.so.6[0x17dc1e]
> /lib/libc.so.6(cfree+0x90)[0x1811e0]
> /usr/lib/libfbembed.so.1[0xaef272]
> /usr/lib/libfbembed.so.1[0xaef346]
> /usr/lib/libfbembed.so.1(gds__free+0x28)[0x9b96b8]
> ./gbak[0x8084734]
> ./gbak[0x807fcaf]
> /lib/libc.so.6(__libc_start_main+0xdc)[0x12adec]
> ./gbak(isc_start_transaction+0x41)[0x8049e11]
> ======= Memory map: ========
> 00110000-00111000 rwxp 00110000 00:00 0
> 00111000-00113000 r-xp 00000000 fd:00 5768017 /lib/libdl-2.5.so
> 00113000-00114000 r-xp 00001000 fd:00 5768017 /lib/libdl-2.5.so
> 00114000-00115000 rwxp 00002000 fd:00 5768017 /lib/libdl-2.5.so
> 00115000-00252000 r-xp 00000000 fd:00 5767209 /lib/libc-2.5.so
> 00252000-00254000 r-xp 0013d000 fd:00 5767209 /lib/libc-2.5.so
> 00254000-00255000 rwxp 0013f000 fd:00 5767209 /lib/libc-2.5.so
> 00255000-00259000 rwxp 00255000 00:00 0
> 0074c000-0074d000 rwxp 0074c000 00:00 0
> 0077a000-0079f000 r-xp 00000000 fd:00 5767185 /lib/libm-2.5.so
> 0079f000-007a0000 r-xp 00024000 fd:00 5767185 /lib/libm-2.5.so
> 007a0000-007a1000 rwxp 00025000 fd:00 5767185 /lib/libm-2.5.so
> 007b8000-007f8000 rwxs 00000000 fd:00 20447242 /opt/firebird/isc_lock1.CHERYL
> 0085d000-0085e000 r-xp 0085d000 00:00 0 [vdso]
> 00873000-0088d000 r-xp 00000000 fd:00 5767207 /lib/ld-2.5.so
> 0088d000-0088e000 r-xp 00019000 fd:00 5767207 /lib/ld-2.5.so
> 0088e000-0088f000 rwxp 0001a000 fd:00 5767207 /lib/ld-2.5.so
> 009a1000-00b42000 r-xp 00000000 fd:00 20840530 /opt/firebird/lib/libfbembed.so.1.5.3
> 00b42000-00b6a000 rwxp 001a0000 fd:00 20840530 /opt/firebird/lib/libfbembed.so.1.5.3
> 00b6a000-00b70000 rwxp 00b6a000 00:00 0
> 00ec1000-00f70000 r-xp 00000000 fd:00 4315976 /usr/lib/libstdc++.so.5.0.7
> 00f70000-00f75000 rwxp 000ae000 fd:00 4315976 /usr/lib/libstdc++.so.5.0.7
> 00f75000-00f7a000 rwxp 00f75000 00:00 0
> 05614000-0561f000 r-xp 00000000 fd:00 5767265 /lib/libgcc_s-4.1.2-20080102.so.1
> 0561f000-05620000 rwxp 0000a000 fd:00 5767265 /lib/libgcc_s-4.1.2-20080102.so.1
> 05aa8000-05ab1000 r-xp 00000000 fd:00 5769512 /lib/libcrypt-2.5.so
> 05ab1000-05ab2000 r-xp 00008000 fd:00 5769512 /lib/libcrypt-2.5.so
> 05ab2000-05ab3000 rwxp 00009000 fd:00 5769512 /lib/libcrypt-2.5.so
> 05ab3000-05ada000 rwxp 05ab3000 00:00 0
> 05b3a000-05b7a000 r-xp 00000000 fd:00 4314556 /usr/lib/libncurses.so.5.5
> 05b7a000-05b82000 rwxp 00040000 fd:00 4314556 /usr/lib/libncurses.so.5.5
> 05b82000-05b83000 rwxp 05b82000 00:00 0
> 08048000-0808f000 r-xp 00000000 fd:00 20840451 /opt/firebird/bin/gbak
> 0808f000-08099000 rwxp 00046000 fd:00 20840451 /opt/firebird/bin/gbak
> 08a0e000-08cd3000 rwxp 08a0e000 00:00 0
> b7e00000-b7e21000 rwxp b7e00000 00:00 0
> b7e21000-b7f00000 --xp b7e21000 00:00 0
> bf8f2000-bf90a000 rwxp bf8f2000 00:00 0 [stack]
> Aborted
>
>
> -- In firebird-support@yahoogroups.com, "call.assist" <andrew@> wrote:
> >
> >
> >
> > [root@CHERYL bin]# ./gstat -h /opt/firebird/DRDBase.fdb
> >
> > Database "/opt/firebird/DRDBase.fdb"
> >
> > Database header page information:
> > Flags 0
> > Checksum 12345
> > Generation 3318
> > Page size 4096
> > ODS version 10.1
> > Oldest transaction 3084
> > Oldest active 3085
> > Oldest snapshot 3085
> > Next transaction 3310
> > Bumped transaction 1
> > Sequence number 0
> > Next attachment ID 0
> > Implementation ID 19
> > Shadow count 0
> > Page buffers 0
> > Next header page 0
> > Database dialect 1
> > Creation date Sep 13, 2009 10:35:39
> >
> > Variable header data:
> > Sweep interval: 0
> > *END*
> > [root@CHERYL bin]#
> >
> >
> >
> > --- In firebird-support@yahoogroups.com, Michael Weissenbacher <mw@> wrote:
> > >
> > > Hi Andrew!
> > > > I tried ��"h and got :
> > > > [root@CHERYL bin]# ./gfix -h /opt/firebird/DRDBase.fdb
> > > > numeric value required
> > > I'm sure Vlad actually meant "gstat -h", so please try this (shows database statistics).
> > >
> >
>