Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Pervasive V 9.1 MKDE, System Error : 110.-1.0

Posted on 2006-06-26
10
Medium Priority
?
2,103 Views
Last Modified: 2013-12-25
Hello Experts,
We are running on Pervasive V 9.1 and am running into a weird problem, hope someone can help me out.

Pervasive is our main production database and recently after the new update to v 9.1 we have noticed that all of a sudden sumtimes some tables just stop responding. I mean anything we add to the table does not get added through the 3rd party applciation or even the regular insert queries dont work. The only thing that's common between all the instances is that i noticed in the pervasive log, just before this starts happening that particular table gives an error as follows::

06-16-2006 09:19:01 MKDE            00000DD0 NTDBSMGR.EXE    NHSERVER        E                        System Error: 110.-1.0 File: (Physical location where the file is located)
06-16-2006 11:53:57 W3COMSRV        00000DD0 NTDBSMGR.EXE    NHSERVER        I                        Client session timeout, CID=ffffffff0000c0a8019c6805, SA=0000, TN=0000.
06-16-2006 11:53:57 W3COMSRV        00000DD0 NTDBSMGR.EXE    NHSERVER        I                        Client

How do i go about debuggin whatz actually causing the problem???

0
Comment
Question by:PremkumarBalwani
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
10 Comments
 
LVL 18

Expert Comment

by:mirtheil
ID: 16984663
Is there any error from the application?  
How does the application insert data?  Does it fail from all clients when it stops "responding"?  
There's two things in your log.  One (System Error) may be related to a corrupted file.  Rebuild the file.
The second is related to your network and could indicate a problem with connections (losing connection).  
Does a PSA Network Test fail?  
0
 
LVL 1

Author Comment

by:PremkumarBalwani
ID: 16985465
The application or a regular insert query they all work fine without any error. It just does not save any information in those tables. But at the same time there are other updates and inserts to other tables that works fine and that's what rules out the network issue. The PSA test also executes fine without any problems.

If the System Error is related to corrupt file, is it the actual data file that's corrupt or one of the configuration files. I was looking into pervasive support and it mentioned that System Error 110.-1.0 is related to Blog.cfg file and i am not sure how to rebuild it??

any suggestions??
and thank you for the quick response.
0
 
LVL 18

Expert Comment

by:mirtheil
ID: 16985525
Rebuild the file referenced in the System Error.  
How do you know that the data isn't saved?  
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
LVL 1

Author Comment

by:PremkumarBalwani
ID: 16985682
I have web applications that work with the production database and while saving the changes or updating them i have a different sets of table in sql server that saves the history of work done through those web applicaitons. In those history tables i record all the information and that has been working fine but the data in Pervasive has not been updated or added.

and thus as such i lost all the data that we must have added directly through the 3rd party application as we dont save it anywhere else.

i cant rebuild (re-index) in the production environment, but i will do it later tonite during after hours. Is this the only reason that's happening or could there be more reasons that we are not considering. after a few lines it shows the error on the log file it also shows that the log file is corrupt.

06-24-2006 10:33:41 MKDE            00000B54 NTDBSMGR.EXE    NHSERVER        W                        Resources allocated
06-24-2006 10:34:01 MKDE            00000B54 NTDBSMGR.EXE    NHSERVER        W                        The log file is corrupt.
06-24-2006 10:35:24 MKDE            00000B54 NTDBSMGR.EXE    NHSERVER        W                        The log file is corrupt.


But this comes up when after we reboot the server and all the previous tables that were acting up start working fine again.


Just so its clear what i m trying to explain, the sequence of events in the log file would be as follows::

certain day  MKDE ---- System error 110.-1.0 File :: physical location

after a few days when we find out.. and reboot the server.....

day of reboot MKDE --- Resources allocated
day of reboot MKDE -- The log file is corrupt.....


And after the reboot that particular file works fine.


thanks ...
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 16988758
The System Error is indicating a problem in accessing the file.  The "-1" in there tells us that the problem is related to a normal background (I/O) thread which does system transactions.  The 110 indicates WHERE in the Pervasive code the error is detected, with 110 indicating "A record address or page number references a PAT page range at least two PAT pages past the end of the physical file."  The final number, 0, indicates that the OS seems happy with the file.

It sounds like the Pervasive log files are not getting cleaned up correctly, and when these get damaged, the problem creeps up on the rest of the files (for which the logs are keeping track).

Suggestion: Clean up the logs:
1) Shut down the database engine.
2) Delete all files from the C:\PVSW\BIN\MKDE\LOG directory on the server. (If you moved the transaction logs, clean out whatever directory you moved them to.)
3) Restart the engine and see if they stay clean.  

If the problem continues, it could be a problem with having the logs on the drive in question -- you can try moving them to another drive to see if that helps.

0
 
LVL 1

Author Comment

by:PremkumarBalwani
ID: 16989544
Thank you bill about your specific description what the error really means. it makes it easier to figure out the problem once its clear what the error is really telling ya.

i looked up the mkde folder in my pvsw folder. it was about 4 gigs. i backed it up to a different folder and deleted all the log files in that folder.

Now the nature of the error being so random and in frequent i wont really be sure until it happens again but i will keep a close eye on my mkde folder and delete any log files in there on a regular basis. i am guessing there must be a way to clear it out automatically.

also i noticed the mkde log files contained transaction data in it. i was just wondering out of curiosity is it possible to parse those log files and be able to get the data as its all the data that was inputted using the 3rd party application does not have a history log and i would love to get it back.

i dont think it should be a problem with the drive as the drive still has approx 20 gigs of free space. I will keep an close eye though and give me till tomorrow to monitor and then later tom i can accept the answer and give you guys the point that you guyz soooo rightly deserve.......lol

thanks for all your help.
0
 
LVL 28

Accepted Solution

by:
Bill Bach earned 1000 total points
ID: 16991816
There was a bug posted in the PSQLv9.1 engine that caused runaway log files to randomly occur and not get deleted properly.  I do not know if Pervasive ever figured out what the combination of factors was that caused it, but I do believe it is fixed in the v9.5 (Service Pack 2) update.  I would strongly suggest that you apply the SP2 update as soon as you can -- this may prevent the problem from recurring.

In the meantime, please do not delete ALL log files while the engine is running -- only those that are old.  If you shut down the engine, you can delete everything in this folder.

The translog is not a valid or readable history, and should not be used as such.  You MAY be able to do something with the "Archival Logging" feature if you need that data, but even it is not perfectly usable as a history.  For a true history, you should consider implementing Pervasive's AuditMaster tool -- a true auditing and hiostorical tool for this database.  More information and pricing can be found here: www.goldstarsoftware.com/am.asp.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this article, we’ll look at how to deploy ProxySQL.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question