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

Reply via email to