Subject | Re: [firebird-support] The worst day i can have with firebird |
---|---|
Author | Alexey Kovyazin |
Post date | 2012-07-06T13:35:06Z |
Hello,
Is there any reason to delete connection which lasts 4 hours?
How did you plan migration? Did you perform compatibility and load tests?
Why you are using SuperClassic, not Classic?
Look here how migration should be done (regardless of start and end
database versions, steps are almost the same)
http://www.slideshare.net/ibsurgeon/firebird-migration-from-firebird-15-to-firebird-25
Regarding your problem with lock denied - I suppose that you use MON$
tables too often.
Regards,
Alexey Kovyazin
IBSurgeon
PS
- Doctor, when I do like this, it hurts!
-Well, don't do like this...
Is there any reason to delete connection which lasts 4 hours?
How did you plan migration? Did you perform compatibility and load tests?
Why you are using SuperClassic, not Classic?
Look here how migration should be done (regardless of start and end
database versions, steps are almost the same)
http://www.slideshare.net/ibsurgeon/firebird-migration-from-firebird-15-to-firebird-25
Regarding your problem with lock denied - I suppose that you use MON$
tables too often.
Regards,
Alexey Kovyazin
IBSurgeon
PS
- Doctor, when I do like this, it hurts!
-Well, don't do like this...
> Two days ago, we moved from one server with interbase 2009 windows[Non-text portions of this message have been removed]
> 2003 and
> 4 Gb RAM to Firebird 2.5.2 Superclassic, 16 Gb RAM
> The database is around 21 Gb, and yesterday seems all was running fine.
>
> Today, i have checked Firebird.log and i have seen that there is an error
> of type
> 1296554 page type 4 lock denied (216), and page type 4 lock denied in
> another page, that are logged from .
>
> viewing monitoring tables, i have seen on transaction opened for 4 hours,
> and i have tried to delete de attachment. When i have deleted it, firebird
> has crashed and around 130 users has been dropped. After that in
> Firebird.log, i see no information about the crash, and i don't know what
> can happen, and what to do, and where look up for the reason of the
> problem.
>
> After that crash, I see in the log page 1296554, page type 4 lock
> conversion denied (215), and don'n know what to do with this errors.
>
> Another problem is that transactions_id jumps, 20000, and 30000 in one
> minute.
>
> Any help or idea appreciated.
> Regards, Jesus
>
> [Non-text portions of this message have been removed]
>