Subject Re: DROP table statement hangs Firebird Server process with 100% CPU usage
Author
Post date 2018-06-18T11:38:03Z
Here is the output of:

> gstat /home/firebird/my_db.fdb -u 'theadmin' -p 'thepasswd' -r -t CONTEXTS                                                                               
Database "/home/firebird/my_db.fdb"
Gstat execution time Mon Jun 18 11:20:21 2018

Database header page information:
        Flags                   0
        Checksum                12345
        Generation              3794638
        Page size               4096
        ODS version             11.2
        Oldest transaction      3794391
        Oldest active           3794392
        Oldest snapshot         3794392
        Next transaction        3794394
        Bumped transaction      1
        Sequence number         0
        Next attachment ID      4083
        Implementation ID       24
        Shadow count            0
        Page buffers            0
        Next header page        0
        Database dialect        3
        Creation date           Apr 30, 2018 11:50:10
        Attributes              force write

    Variable header data:
        *END*


Database file sequence:
File /home/firebird/my_db.fdb is the only file

Analyzing database pages ...
CONTEXTS (130)
    Primary pointer page: 183, Index root page: 184
    Average record length: 783.89, total records: 5743050
    Average version length: 0.00, total versions: 0, max versions: 0
    Data pages: 1250851, data page slots: 1250851, average fill: 87%
    Fill distribution:
         0 - 19% = 2197
        20 - 39% = 7697
        40 - 59% = 22902
        60 - 79% = 116449
        80 - 99% = 1101606

    Index RDB$5 (0)
        Depth: 3, leaf buckets: 21437, nodes: 5743050
        Average data length: 3.72, total dup: 1823871, max dup: 1823871
        Fill distribution:
             0 - 19% = 116
            20 - 39% = 0
            40 - 59% = 9574
            60 - 79% = 7415
            80 - 99% = 4332

    Index RDB$FOREIGN7 (2)
        Depth: 0, leaf buckets: 0, nodes: 0
        Average data length: 0.00, total dup: 0, max dup: 0
        Fill distribution:
             0 - 19% = 0
            20 - 39% = 0
            40 - 59% = 0
            60 - 79% = 0
            80 - 99% = 0

    Index RDB$PRIMARY6 (1)
        Depth: 3, leaf buckets: 25910, nodes: 5743050
        Average data length: 5.32, total dup: 0, max dup: 0
        Fill distribution:
             0 - 19% = 177
            20 - 39% = 0
            40 - 59% = 9229
            60 - 79% = 10320
            80 - 99% = 6184



---In firebird-support@yahoogroups.com, <hvlad@...> wrote :

Please, run

gstat -r -t CONTEXTS <database>

and show its output here.

Regards,
Vlad