Error Writing Data To The Connection Interbase
0 Watchers: 7 Operations If you were logged in you would be able to see more operations. Firebird Core Error writing data to the connection (2.5.1) / transactions reliability / database corruption Created: 10/Jul/11 06:20 AM Updated: 16/Jul/11 06:14 PM Component/s: Engine Affects Version/s: 2.5.1 Fix Version/s: None Environment: Windows 32bits superserver Description « Hide the connection to the database is lost with error "error writing data to the connection" while running this piece of code (B): (Error message returned may vary from time to time) If you re run the code (B), then, after the 2nd error, when you try to reconnect the database is corrupted (wrong page type) A: Run the code recreate global temporary table test (x varchar(20) not null, y varchar(20) not null) on commit preserve rows B: Run the code execute block as declare variable i integer; declare variable j integer; begin i=0; while (i<500) do begin execute statement 'recreate global temporary table test (x varchar(20) not null, y varchar(20) not null) on commit preserve rows'; execute statement 'create unique index xtest on test (x,y)'; execute statement 'grant all on test to FMUSER'; j=0; while (j<10000) do begin in autonomous transaction do execute statement 'insert into test (x,y) values ( ' || cast(i as varchar(20)) || ', ' || cast( j as varchar(20)) || ')'; j=j+1; end i=i+1; end end Description the connection to the database is lost with error "error writing data to the connection" while running this piece of code (B): (Error message returned may vary from time to time) If you re run the code (B), then, after the 2nd error, when you try to reconnect the database is corrupted (wrong page type) A: Run the code recreate global temporary table test (x varchar(20) not null, y varchar(20) not null) on commit preserve rows B: Run the code execute block as declare variable i integer; declare variab
connection We have Interbase 5.5.0.742, with a database of about 50 tables and about 50 indexes and foreign keys. The Interbase server runs on Windows NT system version 4.0, service pack 3, and TCP/IP protocol. We experienced very often corruptions of the database during its normal use: while inserting, modifying or browsing a row (in general: while accessing the datas), the system returns the error "Unknown Win32 error 10054 - Could not write data to the connection", and there is no way to recover the database, nor using the database validation, backup and restore (through Interbase server manager). Sometimes the database backup worked http://tracker.firebirdsql.org/browse/CORE-3550 (we have successfully restored the dabase with no loss of data), but ever more often the problem is of no solution. Last time it occurred, we tried to validate the database, and it answered that there was a "1 index page error". We tried to follow the steps indicated on Operation Guide Manual, trying to validate and backup the database, but with no success. After the validation, we tried to backup http://www.delphigroups.info/2/28/247132.html the database, but it can't start! During validation operation, we always have the validation report window indating "1 index page error", and the Ignore checksum error option is enabled. The "interbase.log" file says: "Index 4 is corrupt (missing entries) in table MCA (158)". If we try to repeat the validation, it always ends with the validation report window indicating the same message described before. The last line of the "interbase.log" file says: "C:\Program Files\InterBase Corp\InterBase\bin\ibserver.exe: terminated abnormally (-1)" The physical database file size is about 30 Megabytes. NOTE: we have experienced the same problem using the previous release of Interbase (5.0 or 5.1) Saldi Giambattista - Antana s.a.s. Other Threads 1. Error reading data from the connection - 10054 2. Interbase 6.0.1 and Win98 10054 connection error 3. Indy 10054 (Connection Reset by Peer) NOT from EIdConnClosedGracefully 4. TIdHTTP: Socket Error # 10054 Connection reset by peer. 5. TidPop3.delete : Socket Error # 10054 Connection reset by peer 6. Socket Error 10054 Connection Reset By Peer 7. What is this error message (Connection reset by peer #10054) 8. Socket error 10054 Connection reset by peer 9. Connections are lost with 10054 error... 10. Error code 10054 from the Interbase server.
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 http://stackoverflow.com/questions/28882366/firebird-2-5-events-error-writing-data-to-the-connection this site About Us Learn more about Stack Overflow the company Business Learn http://borland.public.interbase.general.narkive.com/Nb4thFQ3/unable-to-complete-network-request-to-host-hostname 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 error writing 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 error writing data '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); } Finally, the code is tested by repeatedly tripping the trigger in a test suite similar to: query = "UPDATE table_name SET column1=value1 WHERE some_column=some_value;"; for (int i=0 ; i<1e6 ; i++) { if (isc_start_transaction(status_vector, &transactionHandle, 1, &da
to my effort to promoting Interbase as my recommended SQL server for my clients:'Unable to complete network request to host "HOSTNAME"Error writing data to the connectionAn existing connection was forcibly closed by remote host'Please is there a way programmable to reconnect the connection and enable my client work without having to loss, the work done, due to the fact that they have not commited the transaction.Please I need this help urgently.ThanksRegardsOwei Chong Keng Woon 2005-03-16 07:55:01 UTC PermalinkRaw Message i have this problem before..it is happening when the Interbase connectionsuddenly closed by remote host ..e.g. suddenly close Interbase Server ...if not IB_ConnectionHostDB.TestConnected thenerror := trueif error thenConnectDatabase;when system detect the Interbase not connected, it will reconnectautomatically for you ....Post by AOMPlease help, the following message have been a very destructive error tomy effort to promoting Interbase as my recommended SQL server for myPost by AOM'Unable to complete network request to host "HOSTNAME"Error writing data to the connectionAn existing connection was forcibly closed by remote host'Please is there a way programmable to reconnect the connection and enablemy client work without having to loss, the work done, due to the fact thatthey have not commited the transaction.Post by AOMPlease I need this help urgently.ThanksRegardsOwei AOM 2005-03-17 17:29:25 UTC PermalinkRaw Message I will try this, but can this code be placed in a global position?Post by Chong Keng Wooni have this problem before..it is happening when the Interbase connectionsuddenly closed by remote host ..e.g. suddenly close Interbase Server ...if not IB_ConnectionHostDB.TestConnected thenerror := trueif error thenConnectDatabase;when system detect the Interbase not connected, it will reconnectautomatically for you ....Post by AOMPlease help, the following message have been a very destructive error tomy effort to promoting Interbase as my recommended SQL server for myPost by AOM'Unable to complete network request to host "HOSTNAME"Error writing data to the connectionAn existing connection was forcibly closed by remote host'Please is there a way programmable to reconnect the connection and enablemy client work without having to loss, the work done, due to the fact thatthey have not commited the transaction.Post by AOMPlease I need this help urgently.ThanksRegardsOwei Quinn Wildman 2005-03-16 19:52:05 UTC PermalinkRaw Message How many remo