Данный пост для информирования разработчиков сервера.
Firebird 3.0.4.32987. Сегодня, предположительно при перекомпиляции триггеров, произошло следующее:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
SERVER Thu Aug 09 11:04:00 2018
Database: [CUTTED]
internal Firebird consistency check (invalid SEND request (167), file: JrdStatement.cpp line: 327)
SERVER Thu Aug 09 11:04:00 2018
Database: [CUTTED]
internal Firebird consistency check (invalid SEND request (167), file: JrdStatement.cpp line: 327)
SERVER Thu Aug 09 11:05:20 2018
I/O error during "ReadFile" operation for file "C:\WINDOWS\TEMP\FB_TABLE_2M7PGI"
Error while trying to read from file
Неверный дескриптор.
SERVER Thu Aug 09 11:05:20 2018
Database: [CUTTED]
database file appears corrupt (C:\WINDOWS\TEMP\FB_TABLE_2M7PGI)
wrong page type
page 2387 is of wrong type (expected index root, found blob)
SERVER Thu Aug 09 11:05:21 2018
I/O error during "ReadFile" operation for file "C:\WINDOWS\TEMP\FB_TABLE_2M7PGI"
Error while trying to read from file
Неверный дескриптор.
SERVER Thu Aug 09 11:05:21 2018
Database: [CUTTED]
database file appears corrupt (C:\WINDOWS\TEMP\FB_TABLE_2M7PGI)
wrong page type
page 341 is of wrong type (expected index root, found blob)
SERVER Thu Aug 09 11:05:24 2018
I/O error during "ReadFile" operation for file "C:\WINDOWS\TEMP\FB_TABLE_2M7PGI"
Error while trying to read from file
Неверный дескриптор.
SERVER Thu Aug 09 11:05:24 2018
Database: [CUTTED]
database file appears corrupt (C:\WINDOWS\TEMP\FB_TABLE_2M7PGI)
wrong page type
page 283 is of wrong type (expected index root, found blob)
SERVER Thu Aug 09 11:05:40 2018
I/O error during "ReadFile" operation for file "C:\WINDOWS\TEMP\FB_TABLE_2M7PGI"
Error while trying to read from file
Неверный дескриптор.
SERVER Thu Aug 09 11:05:40 2018
Database: [CUTTED]
database file appears corrupt (C:\WINDOWS\TEMP\FB_TABLE_2M7PGI)
wrong page type
page 138 is of wrong type (expected index root, found blob)
SERVER Thu Aug 09 11:06:20 2018
I/O error during "ReadFile" operation for file "C:\WINDOWS\TEMP\FB_TABLE_2M7PGI"
Error while trying to read from file
Неверный дескриптор.
SERVER Thu Aug 09 11:06:20 2018
Database: [CUTTED]
database file appears corrupt (C:\WINDOWS\TEMP\FB_TABLE_2M7PGI)
wrong page type
page 222 is of wrong type (expected index root, found blob)
SERVER Thu Aug 09 11:06:24 2018
I/O error during "ReadFile" operation for file "C:\WINDOWS\TEMP\FB_TABLE_2M7PGI"
Error while trying to read from file
Неверный дескриптор.
SERVER Thu Aug 09 11:06:24 2018
Database: [CUTTED]
database file appears corrupt (C:\WINDOWS\TEMP\FB_TABLE_2M7PGI)
wrong page type
page 111 is of wrong type (expected index root, found data)
SERVER Thu Aug 09 11:06:28 2018
I/O error during "ReadFile" operation for file "C:\WINDOWS\TEMP\FB_TABLE_2M7PGI"
Error while trying to read from file
Неверный дескриптор.
SERVER Thu Aug 09 11:06:28 2018
Database: [CUTTED]
database file appears corrupt (C:\WINDOWS\TEMP\FB_TABLE_2M7PGI)
wrong page type
page 428 is of wrong type (expected index root, found pointer)
SERVER Thu Aug 09 11:06:28 2018
error while shutting down attachment
database file appears corrupt (C:\WINDOWS\TEMP\FB_TABLE_2M7PGI)
wrong page type
page 428 is of wrong type (expected index root, found pointer)
Далее идет такой же набор из wrong page type.
С самой базой все норм, кроме застревания OLDEST ACTIVE TRANSACTION ID - в MON$DATABASE указан номер, но в MON$TRANSACTION такой транзакции не существует.
