Имеем сервак с рабочей БД. (Win2003+SP2, ClassicServer)
Останавливаем fb_inet_server, накатываем архив 2.5.0.26157 из
снапшотов тупой заменой файлов при распаковке, запускаем сервайс.
Запрос вида:
SELECT a.mon$attachment_id as "Attachment ID",
a.mon$server_pid as "Server PID",
a.mon$state as "State",
a.mon$attachment_name as "Attachment Name",
a.mon$user as "User",
a.mon$role as "Role",
a.mon$remote_protocol as "Remote Protocol",
a.mon$remote_address as "Remote Address",
a.mon$remote_pid as "Remote PID",
cs.rdb$character_set_name as "Character Set",
a.mon$timestamp as "Established At",
a.mon$garbage_collection as "Garbage Collection",
a.mon$remote_process as "Remote Process",
a.mon$stat_id as "Statistics ID",
r.mon$record_seq_reads as "Non-indexed Reads",
r.mon$record_idx_reads as "Indexed Reads",
r.mon$record_inserts as "Records Inserted",
r.mon$record_updates as "Records Updated",
r.mon$record_deletes as "Records Deleted",
r.mon$record_backouts as "Records Backed Out",
r.mon$record_purges as "Records Purged",
r.mon$record_expunges as "Records Expunged",
io.mon$page_reads as "Page Reads",
io.mon$page_writes as "Page Writes",
io.mon$page_fetches as "Page Fetches",
io.mon$page_marks as "Page Marks"
FROM mon$attachments a, rdb$character_sets cs
left join mon$record_stats r on (a.mon$stat_id = r.mon$stat_id)
left join mon$io_stats io on (a.mon$stat_id = io.mon$stat_id)
WHERE (a.mon$character_set_id = cs.rdb$character_set_id)
возвращает Error, что не может найти домен a.mon$stat_id.
Останавливаем сервайс fb_inet_server.exe, накатываем снапшот
2.5.0.26089 - и все работает.
Запрос взят из IBExpert-овской утилиты DataBaseMonitoring. К
Хвастунову посылать не надо, пробовал запрос выполнить из своей проги.
Та же ошибка.
