Hello, It looks like i might have run into a bug in Firebird version 2.5.3 (also 2.5.2).
I have databases with ON CONNECT trigger that load some context values from a table. However, some times the context values appear to have not been loaded (or loaded and lost?). I am absolutely sure the flag for NODBTRIGGERS is not activated (in fact the db library used does not even support it). No command to clear the context values is given anywhere. It is my understanding (and please correct me if wrong) the above result should not be possible by any other designed means. The clients connecting are windows services. And so far a prior restarting of the OS has always been the common event when investigating the problem. Restarting the particular service where connection is without context values will result in the context values getting loaded properly. It looks a lot like the first connection to the database after OS restart might fail SOME times. Perhaps some dependant component of set_context function is not yet loaded? This issue is difficult to reproduce consistently but i've succeeded in a VM some times. I have worked around the problem for myself by other means so this is not a burning problem for me. However i could try out suggestions to pinpoint the problem and report back or provide remote access to the VM if someone is interested in taking a stab at the issue. I would have liked to investigate more and prepare a skeleton db + client to present the case but now i've rushed a bit because Dimitry told us 2.5.4 is planned for release this month. -- BR, Lauri ------------------------------------------------------------------------------ Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
