Interbase Error Writing Data To The Connection
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Firebird 2.5 Events “error writing data to the connection” up vote 1 down vote favorite I am using the latest Firebird 2.5.3 on OSX10.10 using the C api, and have an issued I've narrowed specifically to events. I get "error writing data to the connection" with ~1:5 probability of happening on an event that is run from a database trigger using: POST_EVENT 'xxx'; where 'xxx' is the Event_Callback Is this an issue others are seeing? I'm having a hard time tracking much info down using google, as most references are for earlier versions of Firebird, or for supposedly 'fixed' bugs. edit - additional info obviously, some of the details have been The trigger is created with something akin to: "CREATE TRIGGER \"%s\" FOR \"%s\" \ AFTER %s \ AS \ BEGIN \ if( new.id = %d ) THEN \ BEGIN \ INSERT INTO \"Event_Log\" (\"ID\",\"triggerName\", \"lastModified\") VALUES (GEN_ID(\"seq_Event_Table\",1)'%s', (select current_timestamp from rdb$database) ); \ POST_EVENT '%s'; \ END \ END;" Events are initialized with code that executes: isc_que_events(status, &database, &eventData->id, eventData->length, eventData->buffer, (isc_callback)EventCallback, eventData->resultBuffer); And finally the event is structured: isc_callback EventCallback( char *result, short length, char *updated ) { uint64_t startTime; startTime = mach_absolute_time(); printf("__EVENT__:%s:%s:%llu\n",eventData->buffer,eventData->resultBuffer,startTime); while (length--) { *result++ = *updated++; } isc_event_counts(status, eventData->length, eventData->buffer, eventData->resultBuffer); isc_que_events(status, &database, &eventData->id, eventData->length, eventData->buffer, (isc_callback)EventCallback, eventData->resultBuffer); return(0
Swedish Traditional Chinese Turkish | Location All Other RegionsASEANAustralia/New ZealandBeneluxD-A-CHGreater ChinaLatin AmericaNordicTaiwanUK and IrelandUS and CaribbeanCountriesBrazilCanadaFranceIndiaItalyJapanKorea (South)Russian FederationSpain Embarcadero Home Watch, Follow, & Connect with Us Share This Communities Articles Blogs Resources Downloads Help Submit Translation Printer-friendly EDN » InterBase » Access Tools » API Show All [All] Multi-threaded applicattion exception By: Ben Matterson Abstract: Multi-threaded applications need one connection per thread. PROBLEM A multi-threaded InterBase application is throwing this exception: Unable to complete http://stackoverflow.com/questions/28882366/firebird-2-5-events-error-writing-data-to-the-connection network request to host "goofy". Error writing data to the connection. An established connection was aborted by the software in your host machine. All access to the database takes place in "critical sections", so only one thread can access the data at one time. Sometimes the application runs fine for thousands of http://edn.embarcadero.com/article/28796 transactions, and then it raises the exception. What's going on? SOLUTION InterBase's client software is not thread safe. Each thread must have its own connection and the connection must be remote (the connection string must specify the server's name or IP address), even if the multi-threaded applicatiuon runs on the same machine as the InterBase server. Note: This applies to InterBase versions prior to 7.x. Latest Comments View AllAdd NewRSSATOM Move mouse over comment to see the full text Rating Average rating: 5 Votes: 0 0 0 0 1 Rating: 1 2 3 4 5 1=Poor, 5=Excellent Download Trial Buy Now Free Developer Edition! Click here to download a free non-expiring Developer Edition or 30-day trial > More InterBase Info InterBase XE7 Product Info Free Developer Edition download Connect Online InterBase on Google+ Follow @InterBase on Twitter Server Response from: ETNASC03 Copyright© 1
Board interbase error index Change font size FAQ Login Information The requested topic does not exist. Board index The team • interbase error writing Delete all board cookies • All times are UTC + 3 hours [ DST ] Tags: Firebird, Firebird download, Firebird скачать, Firebird driver, Firebird oledb provider, Interbase driver, Interbase ole db provider, Firebird odbc driver, Interbase odbc driver, Firebird ADO .Net, Interbase c#, vb.Net, interbase c++, delphi, firebird vbscript, visual basic, vba