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