Fatal Lock Manager Error - Doubled Records in rdb$procedure_parameters ----------------------------------------------------------------------
Key: CORE-6405
URL: http://tracker.firebirdsql.org/browse/CORE-6405
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.4
Environment: Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. Alle Rechte vorbehalten.
Hostname: 999SV2204
Betriebssystemname: Microsoft Windows Server 2012 R2
Datacenter
Betriebssystemversion: 6.3.9600 Nicht zutreffend Build 9
600
Betriebssystemhersteller: Microsoft Corporation
Betriebssystemkonfiguration: Mitgliedsserver
Betriebssystem-Buildtyp: Multiprocessor Free
Registrierter Benutzer: Windows-Benutzer
Registrierte Organisation:
Produkt-ID: 00253-50000-00000-AA442
Ursprüngliches Installationsdatum: 03.02.2016, 13:58:21
Systemstartzeit: 14.11.2019, 00:13:46
Systemhersteller: VMware, Inc.
Systemmodell: VMware Virtual Platform
Systemtyp: x64-based PC
Prozessor(en): 2 Prozessor(en) installiert.
[01]: Intel64 Family 6 Model 62 S
tepping 4 GenuineIntel ~2993 MHz
[02]: Intel64 Family 6 Model 62 S
tepping 4 GenuineIntel ~2993 MHz
BIOS-Version: Phoenix Technologies LTD 6.00, 05
.04.2016
Windows-Verzeichnis: C:\Windows
System-Verzeichnis: C:\Windows\system32
Startgerät: \Device\HarddiskVolume1
Systemgebietsschema: de;Deutsch (Deutschland)
Eingabegebietsschema: de;Deutsch (Deutschland)
Zeitzone: (UTC+01:00) Amsterdam, Berlin, Be
rn, Rom, Stockholm, Wien
Gesamter physischer Speicher: 6.144 MB
Verfügbarer physischer Speicher: 1.700 MB
Virtueller Arbeitsspeicher: Maximale Größe: 24.576 MB
Virtueller Arbeitsspeicher: Verfügbar: 19.924 MB
Virtueller Arbeitsspeicher: Zurzeit verwendet: 4.652 MB
Auslagerungsdateipfad(e): D:\pagefile.sys
Hotfix(es): 168 Hotfix(e) installiert.
[01]: KB2959936
[02]: KB2894856
[03]: KB2896496
[04]: KB2919355
[05]: KB2920189
[06]: KB2928120
[07]: KB2931358
[08]: KB2933826
[09]: KB2934520
[10]: KB2938066
[11]: KB2938772
[12]: KB2949621
[13]: KB2954879
[14]: KB2965500
[15]: KB2966407
[16]: KB2967917
[17]: KB2971203
[18]: KB2971850
[19]: KB2973448
[20]: KB2975061
[21]: KB2976627
[22]: KB2977629
[23]: KB2987107
[24]: KB2989647
[25]: KB2989930
[26]: KB2999226
[27]: KB3000483
[28]: KB3000850
[29]: KB3003057
[30]: KB3004545
[31]: KB3012702
[32]: KB3013172
[33]: KB3013769
[34]: KB3013791
[35]: KB3013816
[36]: KB3014029
[37]: KB3014442
[38]: KB3019978
[39]: KB3021910
[40]: KB3023266
[41]: KB3024751
[42]: KB3024755
[43]: KB3030947
[44]: KB3031044
[45]: KB3033446
[46]: KB3035126
[47]: KB3036612
[48]: KB3038002
[49]: KB3042085
[50]: KB3044374
[51]: KB3044673
[52]: KB3045634
[53]: KB3045685
[54]: KB3045717
[55]: KB3045719
[56]: KB3045755
[57]: KB3045999
[58]: KB3046017
[59]: KB3046737
[60]: KB3050267
[61]: KB3054169
[62]: KB3054203
[63]: KB3054256
[64]: KB3054464
[65]: KB3055323
[66]: KB3055343
[67]: KB3055642
[68]: KB3058515
[69]: KB3059317
[70]: KB3060681
[71]: KB3060716
[72]: KB3060793
[73]: KB3061512
[74]: KB3063843
[75]: KB3068708
[76]: KB3071756
[77]: KB3077715
[78]: KB3078405
[79]: KB3078676
[80]: KB3080149
[81]: KB3082089
[82]: KB3084135
[83]: KB3084905
[84]: KB3086255
[85]: KB3087137
[86]: KB3091297
[87]: KB3094486
[88]: KB3095701
[89]: KB3099834
[90]: KB3100473
[91]: KB3102429
[92]: KB3103616
[93]: KB3103696
[94]: KB3103709
[95]: KB3109103
[96]: KB3109976
[97]: KB3110329
[98]: KB3112336
[99]: KB3115224
[100]: KB3121261
[101]: KB3123245
[102]: KB3124275
[103]: KB3133690
[104]: KB3134179
[105]: KB3134815
[106]: KB3137728
[107]: KB3138602
[108]: KB3139164
[109]: KB3140219
[110]: KB3140234
[111]: KB3145384
[112]: KB3146604
[113]: KB3146751
[114]: KB3147071
[115]: KB3172614
[116]: KB3179574
[117]: KB3186539
[118]: KB4012213
[119]: KB4025333
[120]: KB4033369
[121]: KB4033428
[122]: KB4034672
[123]: KB4038793
[124]: KB4041687
[125]: KB4054522
[126]: KB4054566
[127]: KB4054854
[128]: KB4054990
[129]: KB4054993
[130]: KB4056898
[131]: KB4088879
[132]: KB4093115
[133]: KB4093753
[134]: KB4096236
[135]: KB4103715
[136]: KB4284878
[137]: KB4338605
[138]: KB4338824
[139]: KB4343888
[140]: KB4344166
[141]: KB4457143
[142]: KB4462941
[143]: KB4467703
[144]: KB4480964
[145]: KB4486105
[146]: KB4486111
[147]: KB4487028
[148]: KB4488665
[149]: KB4489883
[150]: KB4495586
[151]: KB4495625
[152]: KB4499165
[153]: KB4503290
[154]: KB4507457
[155]: KB4512489
[156]: KB4514331
[157]: KB4514338
[158]: KB4515846
[159]: KB4515853
[160]: KB4516064
[161]: KB4517298
[162]: KB4519567
[163]: KB4519571
[164]: KB4519974
[165]: KB4519990
[166]: KB4525106
[167]: KB4525250
[168]: KB4525243
Netzwerkkarte(n): 1 Netzwerkadapter installiert.
[01]: vmxnet3 Ethernet Adapter
Verbindungsname: Ethernet
DHCP aktiviert: Ja
DHCP-Server: 10.45.0.15
IP-Adresse(n)
[01]: 10.45.0.129
[02]: fe80::599e:87c0:b048:
128c
Anforderungen für Hyper-V: Es wurde ein Hypervisor erkannt.
Features, die für Hyper-V erforderlich sind, werden nicht angezeigt.
Reporter: Benjamin Bacik
Priority: Critical
Attachments: rdb$procedure_parameters.sql, Screenshot.png
After commit a compiled procedure and the dependences the Firebird server
throws a fatal lock mananger Error.
LOG:
999SV2204 Mon Sep 21 15:35:52 2020
Fatal lock manager error: invalid lock id (0), errno: 0
999SV2204 Mon Sep 21 15:35:52 2020
"C:\Program Files\Firebird\Firebird_3_0\firebird.exe": terminated
abnormally (4294967295)
999SV2204 Mon Sep 21 15:35:52 2020
Guardian starting: "C:\Program
Files\Firebird\Firebird_3_0\firebird.exe"
999SV2204 Mon Sep 21 15:35:53 2020
Sweep is started by SWEEPER
Database "D:\COMED\DATABASE\LEA-WEB.FDB"
OIT 494741611, OAT 495689353, OST 495689353, Next 495689353
After the restart there were doubled records in the rdb$procedure_parameters
for all compiled procedures. It seems that the Database is working correct at
the moment. The doubled records cannot be deleted.
Any suggestions about this? or any further Informations needed?
Is there a possibility to clean this up without complete Database
backup&restore?
some doubled records:
INSERT INTO RDB$PROCEDURE_PARAMETERS (RDB$PARAMETER_NAME, RDB$PROCEDURE_NAME,
RDB$PARAMETER_NUMBER, RDB$PARAMETER_TYPE, RDB$FIELD_SOURCE, RDB$SYSTEM_FLAG,
RDB$COLLATION_ID, RDB$NULL_FLAG, RDB$PARAMETER_MECHANISM, RDB$FIELD_NAME,
RDB$RELATION_NAME, RDB$PACKAGE_NAME)
VALUES ('I_BA_MANDANTEN_ID',
'ER_SUCHE_KUMBEFUND', 0, 0, 'RDB$138332', 0, NULL, NULL, 0, NULL, NULL, NULL);
INSERT INTO RDB$PROCEDURE_PARAMETERS (RDB$PARAMETER_NAME, RDB$PROCEDURE_NAME,
RDB$PARAMETER_NUMBER, RDB$PARAMETER_TYPE, RDB$FIELD_SOURCE, RDB$SYSTEM_FLAG,
RDB$COLLATION_ID, RDB$NULL_FLAG, RDB$PARAMETER_MECHANISM, RDB$FIELD_NAME,
RDB$RELATION_NAME, RDB$PACKAGE_NAME)
VALUES ('I_BA_BENUTZER_ID', 'ER_SUCHE_KUMBEFUND',
1, 0, 'RDB$138333', 0, NULL, NULL, 0, NULL, NULL, NULL);
INSERT INTO RDB$PROCEDURE_PARAMETERS (RDB$PARAMETER_NAME, RDB$PROCEDURE_NAME,
RDB$PARAMETER_NUMBER, RDB$PARAMETER_TYPE, RDB$FIELD_SOURCE, RDB$SYSTEM_FLAG,
RDB$COLLATION_ID, RDB$NULL_FLAG, RDB$PARAMETER_MECHANISM, RDB$FIELD_NAME,
RDB$RELATION_NAME, RDB$PACKAGE_NAME)
VALUES ('I_AUFTRAG_NR', 'ER_SUCHE_KUMBEFUND', 2,
0, 'D_AUFTRAG_NR', 0, NULL, NULL, 0, NULL, NULL, NULL);
INSERT INTO RDB$PROCEDURE_PARAMETERS (RDB$PARAMETER_NAME, RDB$PROCEDURE_NAME,
RDB$PARAMETER_NUMBER, RDB$PARAMETER_TYPE, RDB$FIELD_SOURCE, RDB$SYSTEM_FLAG,
RDB$COLLATION_ID, RDB$NULL_FLAG, RDB$PARAMETER_MECHANISM, RDB$FIELD_NAME,
RDB$RELATION_NAME, RDB$PACKAGE_NAME)
VALUES ('I_BA_MANDANTEN_ID',
'ER_SUCHE_KUMBEFUND', 0, 0, 'RDB$139050', 0, NULL, NULL, 0, NULL, NULL, NULL);
INSERT INTO RDB$PROCEDURE_PARAMETERS (RDB$PARAMETER_NAME, RDB$PROCEDURE_NAME,
RDB$PARAMETER_NUMBER, RDB$PARAMETER_TYPE, RDB$FIELD_SOURCE, RDB$SYSTEM_FLAG,
RDB$COLLATION_ID, RDB$NULL_FLAG, RDB$PARAMETER_MECHANISM, RDB$FIELD_NAME,
RDB$RELATION_NAME, RDB$PACKAGE_NAME)
VALUES ('I_BA_BENUTZER_ID', 'ER_SUCHE_KUMBEFUND',
1, 0, 'RDB$139051', 0, NULL, NULL, 0, NULL, NULL, NULL);
INSERT INTO RDB$PROCEDURE_PARAMETERS (RDB$PARAMETER_NAME, RDB$PROCEDURE_NAME,
RDB$PARAMETER_NUMBER, RDB$PARAMETER_TYPE, RDB$FIELD_SOURCE, RDB$SYSTEM_FLAG,
RDB$COLLATION_ID, RDB$NULL_FLAG, RDB$PARAMETER_MECHANISM, RDB$FIELD_NAME,
RDB$RELATION_NAME, RDB$PACKAGE_NAME)
VALUES ('I_AUFTRAG_NR', 'ER_SUCHE_KUMBEFUND', 2,
0, 'D_AUFTRAG_NR', 0, NULL, NULL, 0, NULL, NULL, NULL);
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
