Гость
Форумы
[новые:0]
/ Firebird, InterBase
[новые:0]
[игнор отключен]
[закрыт для гостей]
/
Mirroring FireBird 2.5
[новые:0]
20 сообщений из 95, страница 4 из 4
|
|
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
rdb_dev,не скажу, ведущего админам нет на месте ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 13.10.2016, 11:20 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
kdvGallemar, у тебя же суперклассик? Просто классик. На суперклассик перейти не могу, есть проблемы с базой из-за приложения, при входе/выходе в программу лезут в mon$. А переподключений много, всякие импорты данных и т.п. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 13.10.2016, 11:23 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
GallemarНа суперклассик перейти не могу, есть проблемы с базой из-за приложения, при входе/выходе в программу лезут в mon$. что-то я не пойму как это связано. Есть какие-то особенные проблемы с mon$ именно в архитектуре SC, которые отсутствуют в CS? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 13.10.2016, 11:35 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
Gallemar, в данном случае пофиг, что классик что суперклассик. Они с файлом БД одинаково в shared-режиме работают, и несколько инстансов могут использовать один и тот же файл лок-менеджера. Грубо говоря, два процесса суперклассика равны двум процессам классика :-) А вот суперсервер блокирует базу в exclusive access. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 13.10.2016, 11:40 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
Симонов Денисчто-то я не пойму как это связано. Есть какие-то особенные проблемы с mon$ именно в архитектуре SC, которые отсутствуют в CS? Да нет. В 2.5.3 есть баг, конкретно номер не скажу, но суть в том, что блокировочник не отпускает страницы при запросах к mon$ когда их много. Внешне это выглядит так - база висит, подключится к ней нельзя, все коннекты и их попытки зависают, при завершении процессов fb база оживает. Я в такие моменты просто смотрю вывод fb_lock_print и вырубаю по PID кто мешает. Вот так это выглядит: LOCK_HEADER BLOCK Version: 145, Active owner: 0, Length: 134217728, Used: 78912256 Flags: 0x0001 Enqs: 2547741716, Converts: 8885068, Rejects: 46728876, Blocks: 32908983 Deadlock scans: 173, Deadlocks: 0, Scan interval: 120 Acquires: 2849648926, Acquire blocks: 572643349, Spin count: 0 Mutex wait: 20.1% Hash slots: 65521, Hash lengths (min/avg/max): 0/ 1/ 8 Remove node: 0, Insert queue: 0, Insert prior: 0 Owners (531): forward: 3374416, backward: 78912144 Free owners: *empty* Free locks (15233): forward: 538120, backward: 76384536 Free requests (30258): forward: 66054320, backward: 25763512 Lock Ordering: Enabled OWNER BLOCK 3374416 Owner id: 116221815029764, type: 1, pending: 43667968 Process id: 27060 (Alive), thread id: 23800 Flags: 0x06 scan wait infn Requests (113): forward: 3374528, backward: 43667968 Blocks: *empty* 3374416 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 46732168 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69951800 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 46732168 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 23056288 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 46732168 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69951800 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 46732168 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 26601168 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 46732168 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69951800 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 46732168 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 23056288 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 46732168 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69951800 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 46732168 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63064952 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 71062912 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 46732168 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 12568360 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 63066848 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. 69624392 waits on 53536648 waits on 74358808 waits on nothing. 52524512 waits on 53536648 waits on 74358808 waits on nothing. и т.д. В классике нужно завершить 2-3 процесса,а в суперклассике всех гасить приходится. На более старшие версии тоже не могу перейти из-за другого бага. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 13.10.2016, 11:42 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
kdvGallemar, я же дал ссылку на документ, начиная с 5й страницы. Есть информация о блоках, которые существовали в БД production на момент старта снапшота. И есть информация о блоках, которые изменены в production с этого момента. Если идет запись в снапшот, то по факту она идет в production. Снапшот сам по себе не предназначен быть модифицируемым. Модифицировать можно только клон, который является физической копией какого-то снапшота. Все там написано, в том числе про чтение для snapshot неизмененных блоков из production, и т.д. Собственно, rdb_dev и об этом пишет (а я только предполагал, что это так).Дмитрий, это, как раз, наследие старой реализации снапшота под названием Copy-on-Write, когда старый блок данных переносится в reserved snap pool хранилище, а на его место в reserved pool пишется новый. Но даже в этом случае проблем быть не должно, так как неизмененные данные будут читаться из reserved snap pool (есть подозрение, что в картинке 3 на стр. 7 перепутаны слова changed и unchanged). Более свежий алгоритм снапшота - Redirect-on-Write описан на стр. 7-9 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 13.10.2016, 11:58 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
С всеобщего позволения подниму тему. Вот такая проблема - при попытке обновить метаданные снепшота получаю сообщение, что object is use. Как это может быть? Вопрос в первую очередь к Владу и Дмитрию. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.09.2017, 09:43 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
что конкретно делаешь (DDL команда) и полный текст ошибки ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.09.2017, 10:04 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
dimitr, create or alter procedure Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements. lock conflict on no wait transaction. unsuccessful metadata update. object PROCEDURE "USR_ACCEPT_PEREOC" is in use. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.09.2017, 10:19 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
1) кто-то еще подключен к базе и закешировал эту процедуру 2) сколько раз уже говорили - DDL надо выполнять в WAIT-транзакции! Если параноик - с явным таймаутом. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.09.2017, 10:41 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
dimitr1) кто-то еще подключен к базе и закешировал эту процедуру 2) сколько раз уже говорили - DDL надо выполнять в WAIT-транзакции! Если параноик - с явным таймаутом. 1) Нету никого, кроме меня. 2) Выполняю в IBExpert, там нет возможности выбрать wait. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.09.2017, 11:01 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
Gallemarтам нет возможности выбрать wait. Есть. Posted via ActualForum NNTP Server 1.5 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.09.2017, 11:08 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
Дмитрий, какая ситуация. Есть две базы - одна это продуктив, а вторая - её изменяемый снепшот. Если в продуктиве использовать процедуру, то её нельзя будет изменить в снепшоте. Почему это происходит? Ведь снепшот изменяемый и любые изменения должны быть записаны. Как работает это механизм? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.09.2017, 11:12 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
Небольшая поправка - если снепшот подключен к другому серверу - проблема не воспроизводится ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.09.2017, 11:16 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
Dimitry SibiryakovGallemarтам нет возможности выбрать wait. Есть. Понял,думал нельзя руками поправить. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.09.2017, 11:17 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
GallemarНебольшая поправка - если снепшот подключен к другому серверу - проблема не воспроизводится Вру. Проблема то есть, то нет вне зависимости куда подключен снепшот ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.09.2017, 11:19 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
GallemarGallemarНебольшая поправка - если снепшот подключен к другому серверу - проблема не воспроизводится Вру. Проблема то есть, то нет вне зависимости куда подключен снепшот Опять вру. Выставил в настройках wait и понять не могу откуда магия. Итог - на разных серверах проблемы нет. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.09.2017, 11:24 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
GallemarВыставил в настройках wait и понять не могу откуда магия.Поиском по форуму, DE уже расписывал, что да как. Gallemar1) Нету никого, кроме меня.Коль уж ты пришел из эксперта, то ты можешь быть там в нескольких "инкарнациях" и сам себе наступать на "это самое". ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.09.2017, 12:01 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
Ivan_PisarevskyКоль уж ты пришел из эксперта, то ты можешь быть там в нескольких "инкарнациях" и сам себе наступать на "это самое". Специально выбирал те процедуры, в которые ни я , ни остальные просто не полезут. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.09.2017, 12:08 |
|
||
|
Mirroring FireBird 2.5
|
|||
|---|---|---|---|
|
#18+
GallemarIvan_PisarevskyКоль уж ты пришел из эксперта, то ты можешь быть там в нескольких "инкарнациях" и сам себе наступать на "это самое". Специально выбирал те процедуры, в которые ни я , ни остальные просто не полезут. Эксперт - штуко тонкое. Ты никогда не знаешь сколько там транзакций открыто и что закешировано. Депенденсы по какой-нибудь таблице глянул - пожалте бриться, полбазы in use. Во всяком случае, так было долгое время. В последних стало полегче. Причём, если в Эксперте оно in use, то просто тупо перенеся текст процедуры в WISQL, ничего нигде не закрывая, никакого тебе in us-a. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 01.09.2017, 19:48 |
|
||
20 сообщений из 95, страница 4 из 4
|
|
Форумы
[новые:0]
/ Firebird, InterBase
[новые:0]
[игнор отключен]
[закрыт для гостей]
/
Mirroring FireBird 2.5
[новые:0]
