SQL statement failed: (-305) I/O error Fatal error: A disk read from file "SomeDatabase.db" failed with error code: (38)

SQL Anywhere 10.0.1.3831

E. 2009-09-11 21:55:41. SQL statement failed: (-305) I/O error Fatal
error:  A disk read from file "D:\FHMSL\iFHMS\Data\Feedlot111.db"
failed with error code: (38) -- transaction rolled back
E. 2009-09-11 21:55:41. Error while executing hook procedure
sp_hook_dbmlsync_end.

Received this error while running a proc during sync. Tried to
validate the db in Sybase Central resulting in the same error.

I saw the post at
http://groups.google.com/group/sybase.public.sqlanywhere.general/browse_thread/thread/b5d958904160e576?fwc=1
and am wondering if there is another way besides using a backup copy
or rebuilding from Consolidated. It is quite possible that the db was
run on a lower build, corrupted, and updated as suggested in the post.
Could a physical disk problem such as bad sectors also cause this?
-1
Sohaib
9/15/2009 12:38:06 AM
sybase.sqlanywhere.general 32637 articles. 4 followers. Follow

1 Replies
1405 Views

Similar Articles

[PageSpeed] 59

Sohaib,

=====================
C:\>net helpmsg 38

Reached the end of the file.
=====================

It seems that the file is shorter than expected on the filesystem. This 
could happen in various ways, but likely it's at the filesystem level. 
Bad blocks or a sudden power outage with outstanding writes against a 
disk might produce a database that looks like this. We have initial 
reports from some customers that running the database as a service with 
automatic restarts (for Windows Update) may also produce a scenario like 
this in very specific instances.

Going to your backup copy is the way to get the database back up and 
running. You may be able to use the transaction log to bring the 
database up-to-date (e.g: dbeng10 <database> -a Feedlot111.log) - 
http://dcx.sybase.com/html/dbdaen10/da-rec-a-database-dbengine.html

Regards,

Sohaib Uthmani wrote:
> SQL Anywhere 10.0.1.3831
> 
> E. 2009-09-11 21:55:41. SQL statement failed: (-305) I/O error Fatal
> error:  A disk read from file "D:\FHMSL\iFHMS\Data\Feedlot111.db"
> failed with error code: (38) -- transaction rolled back
> E. 2009-09-11 21:55:41. Error while executing hook procedure
> sp_hook_dbmlsync_end.
> 
> Received this error while running a proc during sync. Tried to
> validate the db in Sybase Central resulting in the same error.
> 
> I saw the post at
> http://groups.google.com/group/sybase.public.sqlanywhere.general/browse_thread/thread/b5d958904160e576?fwc=1
> and am wondering if there is another way besides using a backup copy
> or rebuilding from Consolidated. It is quite possible that the db was
> run on a lower build, corrupted, and updated as suggested in the post.
> Could a physical disk problem such as bad sectors also cause this?

-- 
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community : 
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs : 
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/
-1
Jeff
9/15/2009 2:29:28 PM
Reply:

Similar Artilces:

SQL statement failed: (-305) I/O error Fatal error: No such file or directory
Hi, I have sybase 9.0.2.3586 on the remote DB on PDA. We are trying to sync it to the SQL Server 2005 on the server. It is successful for all our clients except in one case we are getting this following error. E. 05/22 11:09:08. SQL statement failed: (-305) I/O error Fatal error: No such file or directory -- transaction rolled back E. 05/22 11:09:08. SQL statement failed: (-101) Not connected to a database E. 05/22 11:09:08. SQL statement failed: (-101) Not connected to a database E. 05/22 11:09:08. SQL statement failed: (-101) Not connected to a database Please reply if ...

superreview requested: [Bug 298478] Downloads fail with "..could not be saved, because the source file could not be read" (error in JS Console: "Error: uncaught exception:Permission denied to get prop
Chase Phillips <chase@mozilla.org> has asked Daniel Veditz <dveditz@cruzio.com> for superreview: Bug 298478: Downloads fail with "..could not be saved, because the source file could not be read" (error in JS Console: "Error: uncaught exception:Permission denied to get property RegExp.constructor") https://bugzilla.mozilla.org/show_bug.cgi?id=298478 Attachment 187169: Alternative approach, give the component loader its own compilation context https://bugzilla.mozilla.org/attachment.cgi?id=187169&action=edit ...

superreview granted: [Bug 298478] Downloads fail with "..could not be saved, because the source file could not be read" (error in JS Console: "Error: uncaught exception:Permission denied to get proper
Daniel Veditz <dveditz@cruzio.com> has granted Chase Phillips <chase@mozilla.org>'s request for superreview: Bug 298478: Downloads fail with "..could not be saved, because the source file could not be read" (error in JS Console: "Error: uncaught exception:Permission denied to get property RegExp.constructor") https://bugzilla.mozilla.org/show_bug.cgi?id=298478 Attachment 187169: Alternative approach, give the component loader its own compilation context https://bugzilla.mozilla.org/attachment.cgi?id=187169&action=edit ------- Additional Comm...

Frequent "Failed Error Code: 0x0000190C" errors
I see this frequently with the PCs here. Here is the admin message (converted to plain text): The following deployment events have occurred. For more information log in to the Novell ZENworks Patch Management. ---------------------------------------------------------------------------- ---- Deployment Information Deployment Type: Package Package Name: Discover Applicable Updates Status: Failed Error Code: 0x0000190C : PostScript1 Origin: System Scheduled For: Sep 1 2001 12:00AM (Local Time) Schedule Type: Recurring Rollout Downloaded At: Jun 14 2007 ...

Getting compilation error "The compiler failed with error code 128"
Hi All - I am getting a compilation error when I contact AXMS page , below is the error which i got . Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: The compiler failed with error code 128. when i retstart the system its working fine , but its happening now and then so could not able to predict whats going on .  kindly guide me to eluminate this problem .  Thanks, Jeyaprakash. Tr...

Error: "Encapsulate Field invocation failed with error code 0x8007000e"
I just learned that the C# 2.0 IDE can automatically generate get/set properties for your fields in your classes by right-clicking the variable and selecting Refactor-->Encapsulate Field. But when I try it with my copy of c#, I get the error message "Encapsulate Field invocation failed with error code 0x8007000e" Can anyone tell me why I might be getting this error message? Thanks in advance. Ray  Ray C. Hi, 0x8007000E is E_OUTOFMEMORY Not enough memory to complete the operation. Fortunately, that's not possible. I checked all memory and monitored all files. and everything ...

"SQL Error: Error mapping failed" with Delphi 6 Application and DBExpress
Im using Delphi 6, Firebird 2.x, dbExpress The problem is only with remote database connection and not with local connection. The following connection gives and error Database := MyServer:C:\DEMO.FDB But when locally connected i.e database in the same computer Database := C:\FBdatabases\dbAccounts.FDB Following solution from Firebird forun worked ----------------------------------------- Actually, the issue is inside Borland's DBX driver for InterBase. It's not very much compatible with Firebird. First of all, it uses some internal (metadata) queries in the...

asp.net (VB) error message: "The compiler failed with error code 1"
I'm running a asp.net (VB.NET) on one my servers, and when I try and open it up I'm getting the following error message: Server Error in '/' Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: The compiler failed with error code 1. Show Detailed Compiler Output: C:\WINNT\system32> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\vbc.exe" /t:library /utf...

Help on Error message: "An error occurred while try to load the string resources (GetModuleHandle failed with error "
Hi I have compiled my project in VS.NET (ASP.NET web application in C#) without any build errors. This was in the process of establishing a local setup using the files from the deployed server. Now after copying all the relevant files and compiling them, when I try to browse from IIS (inetmgr) with an appropriate start page (Login.aspx), I get the following error message: An error occurred while try to load the string resources (GetModuleHandle failed with error -2147023888). Description: An unhandled exception occurred during the execution of the current web request. Please revie...

Login Error message "A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 1
 Hi all, I was wondering if any body know anything about this problem I'm getting with the login program?Thanks in advance.  A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 1 - I/O Error detected in read/write operation) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: A transport-level...

"Generation of designer file failed" error always popup up the error list window. bug(?)
When I get any entry related to "generated of designer file failed" the error window always popup. /wap project/For example (it happens for any other error which case a temporary "Generation of designer file failed" error):- The error list is docked in the bottom and set to auto-hide.- I start writing something in source view, for example some databinding: <%# %>- The ide immediatelly add a new error to the list: Generation of designer file failed: The expression in a <%= %> or <%# %> block cannot be an empty string.- And the error list is pop up in my f...

Saving image fails with "A generic error occurred in GDI+." and an error code of -2147467259 for large images only
I have run into a stumbling block with my latest application. I am using web services and WSE 3.0 to upload large images (tiffs and jpegs) to a central server. The image data successfully gets to the server via the web services as a byte[] but I am not able to save large images to disk for some reason. If the image is greater than ~5MB I always receive the following error message. "A generic error occurred in GDI+". The error code is -2147467259. This happens on the image.Save method. Since I can save smaller images to disk I do not think that this is a permissions problem. My code...

"Error Group: WINSOCK" "Error Code:11004"
Hi Just setup iPrint on the server and tried to install the printer to the laptop and got the following message: Error code:11004 Error message: Winsock 11004 - The DNS name has been found in the database, but its associated data is not correct. Error group: WINSOCK Error code:11004 Anyone know what associated data it is referring to? Thanks in advance -- iangh2 A quick Google found this on http://www.sockets.com/err_lst1.htm WSANO_DATA (11004) Valid name, no data record of requested type Berkeley description: The requested name is valid, but does not hav...

DBD::Proxy::db table_info failed: Server returned error: Failed to execute method CallMethod: Can't use string ("1") as an ARRAY ref while "strict refs" in use
------_=_NextPart_001_01C2BB46.4379CEA8 Content-Type: multipart/related; type="multipart/alternative"; boundary="----_=_NextPart_002_01C2BB46.4379CEA8" ------_=_NextPart_002_01C2BB46.4379CEA8 Content-Type: multipart/alternative; boundary="----_=_NextPart_003_01C2BB46.4379CEA8" ------_=_NextPart_003_01C2BB46.4379CEA8 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'm having a problem using the table_info() via ProxyServer... I'm = getting the following error messages: I am us...

upgrade error:"CONNECTIVITY ERROR:DB-Library: "SQL Server connection timed out."
PLEASE HELP OH WISE SYBASE GURUS! upgrading 11.9.2 to 12.0. unloaded software. rebooted server. selected "upgrade server" in Configure Sybase Servers window. typed in sa password. got "CONNECTIVITY ERROR: DB-Library: "SQL Server connection timed out." -- Chuck Boyce chuck_boyce@operamail.com http://www.geocities.com/chuck_boyce_jr/ Yahoo Messenger ID: chuck_boyce_jr http://messenger.yahoo.com AOL Instant Messenger ID: sg95m476 http://www.aol.com/aim/ ICQ Messenger ID: 41449031 http://www.icq.com ...

How to avoid the error "PowerDesigner failed to read the file xxxx?"
I have a workspace that has 40 Physical Models and more than 3500 tables and views. But, frequently I am getting an error while opening the individual models, saying "PowerDesigner failed to read the file <file path>?" Is there any way to avoid this error from recurring? Please suggest. Somaskandan wrote... > I have a workspace that has 40 Physical Models and more than > 3500 tables and views. But, frequently I am getting an error > while opening the individual models, saying "PowerDesigner > failed to read the file <file path>?" Is there a...

DW Export error, "Fatal disk error, retry?"
I am using PowerBuilder 7.0.3.10213 to compile the program, but I find an error at the exe program. When I try to export the data from datawindow using dwcontrol.SaveAs ( { string filename, saveastype saveastype, boolean colheading } ) there will be an error Window Title: Library Manager Error Message: Fatal disk error, retry? Buttons: Retry, Cancel The same set of program run at a machine do not have this problem, but when I copy it to another machine the problem occurred. Do anyone know how and what causing this kind of problem? And how can I fix it? Hi ...

Re: SMTP "authentication failed", Message "UGFzc3dvcmQ6" and error code 535
> {quote:title=Kevin Killion wrote:}{quote} > I'm trying to use a TIdSMTP to send an email message, but when issuing the "Send" I'm getting a EIdSMTPReplyError exception, with: > Message: authentication failed: UGFzc3dvcmQ6 > ErrorCode: 535 > > Needless to say, neither the Message nor that ErrorCode tell me much about what went wrong! You stand a better chance of getting answers about Indy components if you ask in the WinSock group instead. Members of the Indy team (at least one or two, anyway) check in there pretty often. (Forums->...

Asp.Net
Dear all, i have developed a test page with master page and report viewer control,and 3 reports, with .Net Framework 2.0, visual studio 2005 and SQL Server 2005. The report viewer i use will show a report, with drill through to show a second report, and then from the second report to the third. The problem is whenever i try to navigate from second report to show the third report using drill through (using Navigation , Jump To Report), i keep on getting the following error which is "Failed to load viewstate". Further more, whenever i navigate from first report to second report, and click on the "next page button" as the second report contains 2 pages, it will bring me back to first report. When i attempt to navigate to second report again, it gaves me the same error as my first problem as below. "Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request. " [HttpException (0x80004005): Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and p...

"AUTO FAIL" and "NO MEMORY" errors
When I try to load GroupWise 7.0.1 agents on a couple of my servers, they don't load and there is serveral "AUTO FAIL" and "NO MEMORY" errors. GroupWise is the only thing that I load on the server and it as 3 gigs of memory. There is also cluster services installed. Did anybody experienced this problem? Yann Laplante wrote: > When I try to load GroupWise 7.0.1 agents on a couple of my servers, > they don't load and there is serveral "AUTO FAIL" and "NO MEMORY" > errors. GroupWise is the only thing that I load on the server an...

[wxperl-users] From whence "Wx::App Error" "Fatal error: exiting"?
This is a multi-part message in MIME format. ------_=_NextPart_001_01C48798.98A9B782 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I tried to send this message some months ago (early May), but for some reason at that time I was unable to send to the wxPerl mailing list. It seems to be working now, so . . . I'm stumbling around trying to find a single, fail-free method for exiting a running wxPerl app that may or may not have open frames. The Perl functions "exit" and "die" seem vulnerable to problem...

SSIS job fails for package containing Script Task with error "The script files failed to load."
I have developed a SQL Server 2005 Integration Services (SSIS) package that includes a Script Task on a 32-bit machine.  The PrecompileScriptIntoBinaryCode property is set to True.  After I build the package, the .dtsx file includes a <BinaryItem> element for that Task.  Package runs fine on the dev machine, both in BIDS and as SQL Server Agent job. When I deploy the package to a 64-bit server, it runs fine when I execute the package ad hoc from SQL Server Management Studio.  However, when I schedule the package for execution as a SQL Server Agent job, th...

Error
We have a very simple, straightforward application that uses the FILE method for replication. The database is set up and replication only takes place for a week, then we start fresh with a new database and the area used on the server to store DBREMOTE messages is cleared of any lingering messages. Last week, we started getting the above error when attempting to transmit. The DBREMOTE.LOG looked like this: Incoming messages from directory W:\SQLREMOTE\CONSOLIDATED Received message from "TeamA" (0-0002783664-0) Applying message from "TeamA" (0-0002783664-0) Received...

"check out failed i/o error"
We are currently moving an application from PB 4.0.05 to PB 5.0.03. We have several developers sharing the pbl's on a Novell network. Ever since we moved to PB 5.0.03 we encounter the above error when trying to check in or out while someone is running the application. We had this problem in the past, but we were able to get around it by setting the Novell share flag on the files. We have the Novell share flags set under PB 5.0.03, but it does not seem to help. Is this a bug with PB 5.0.03? Has anyone else encountered this problem? Do you have the same problem if you use NT 4.0...

Web resources about - SQL statement failed: (-305) I/O error Fatal error: A disk read from file "SomeDatabase.db" failed with error code: (38) - sybase.sqlanywhere.general

Resources last updated: 2/18/2016 5:07:16 PM