I was wondering if anyone has ever had an issue with SQL that returns an error similar to this
DINIT OS2 Disk error 110
s:\DBMS\OS2\KSource\DBLKIO\DISKIO.C at line 197
Unable to read primary Master Device
Read primary config block failed
Hi,
What kind of RDBMS software is it? DB2, Postgres, MySQL, WatcomSQL...
Database location on a network drive?
Assertion (database corruption due to lack of free disk space on that partition, hardware malfuntion, power failure etc. )
Does it report that right away when you start it?
//Jan-Erik
MySQL
As soon as you start it, it kicks that error out. The building did suffer a major power hit recently (enough to kill one of their elevators.) I was figuring that would have something to do with the possible corruption of the DB, was just curious under what other conditions people may have seen this error before if at all.
Ehh,
not good, not good at all.
Here at work I've specialized in recovering Sybase SQL Anywhere databases that hit the wall at our customers servers... even wrote a rexxsql replacement to aid me whenever I need (automatically determine the problematic tables and try to extract as much as possible). I mainly use it to restructure databases though.
I don't have experience with MySQL db's, but failure that early usually mean that you have to take out the backup and replace the existing db with it... but I presume that you haven't got one?!
Someone with experience with MySQL config files may be able to help you as it seem to be a problem with that.
I can only suggest something vague at this point that you shouldn't take to seriously.
Is it possible that it has been deleted or chkdsk has moved it to a directory called FOUND0?
Can you create a new database and somehow borrow files from it?
//Jan-Erik
I have enough MySQL experience at this point to be dangerous, same could be said for OS/2 :D. I did just end up restoring from a backup and that brought it back to life. I more or less was interested in finding a way to decipher some of OS/2's error codes (I'm still kinda of a huge newb when it comes to using it). If you could point me at any literature to better my overall OS/2 experience that would be awesome.
QuoteHere at work I've specialized in recovering Sybase SQL Anywhere databases...
Any chance to get this running via Odin? I've to use v9 here in VPC.
;D
The tool? Inside the VM, yes!
You need a rexx interpreter that run inside the vm then, such as
Regina (http://regina-rexx.sourceforge.net/index.html) (can be built with OpenWatcom (http://www.openwatcom.org))
Get
dbcon9.dll,
dbctrs9.dll,
dbeng9.exe,
dblgen9.dll (or de/fr etc. depending on language support),
dblib9.dll,
dbodbc9.dll,
dbserv9.dll
and
dbtool9.dll
from the win32-folder and place it with the script and my own supporting dll for rexx (dbtools and odbc)...or use rexxsql
Outside the vm, perhaps or not.
Quote from: Andi on 2009.06.11, 14:15:40
QuoteHere at work I've specialized in recovering Sybase SQL Anywhere databases...
Any chance to get this running via Odin? I've to use v9 here in VPC.
I can try here :)
//Jan-Erik