In the past week, we have a few databases from several customers run out of the 2^31-1 transaction ID limit. After some research I found this problem to have been around since five years ago. Some suggestions were given such as this thread, http://firebird.1100200.n4.nabble.com/discussion-about-real-fix-for-CORE-2348-td3478013.html but they requires off-time.
While we've made our efforts to reduce number of transactions from application level, we still need a thorough solution. 1.I wonder if anyone now has a proper solution to this issue, without requireing shutting down the system. 2. If we have no option other than modifying Firebird source code, can anyone shed some light on how complicated this change will be and how wide the change would affect? Any advice on where to make the code change will be appreciated. -- View this message in context: http://firebird.1100200.n4.nabble.com/Firebird-Transaction-ID-limit-solution-tp4230210p4230210.html Sent from the firebird-devel mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel