PI service freezes

Started by Andrey

Andrey

PI service freezes   16 February 2012, 18:51

Good day again
We have win 2008 x64 server with PI installed (7.0.3)
For our purposes, we reading PI database by ODBC source aimed to its database
As I understand, when PI writing to db info about new printjobs and in the same time db reading by odbc, we have next application log:

1. Unexpected exception occurred in the application. Error message: HP LaserJet 3050 PCL 6 (CE001591P_IT) error: TCoreDB: The database file is locked: database is locked

and then next message

2. Unexpected exception occurred in the application. Error message: Monitoring thread abnormally terminated

DB locating at fileshare for read-only access. Why db is locked? How can I have read-only access for this db and have no locks on it?

Thanx!
SoftPerfect Support forum - Andrew avatar image

Re: PI service freezes   16 February 2012, 23:30

By default the SQLite concurrency model locks the database file even for reading.

I however have updated Print Inspector so that it now waits for up to 10 seconds for locks to be released.

Please try the latest build from here and let me know if it's helped.
Andrey

PI service hangs   17 February 2012, 00:26

Thanx! I'll try it

Andrew, how can I see from PI concole the build of PI?
Before and after update it still 7.0.3
Do I have to check it in installation file property?

thanx again
Andrey

PI service hangs   17 February 2012, 00:31

and one more thing: after your post about updated build, I try "Check for updates" from console and it found no updates for PI
Why?
Thanx again, Andrew
SoftPerfect Support forum - Andrew avatar image

PI service hangs   17 February 2012, 00:44

You can check PrintInspectorService.exe modification date. If it's today, then it's updated correctly.

It does not see any updates because the version number has not changed. I gave you a link to version 7.0.3 with the only difference from the official release is waiting for locks to be released.
Andrey

PI service hangs   17 February 2012, 23:41

And one more:

What this log means?

'Unexpected exception occurred in the application. Error message: HP LaserJet 3005 PCL 6 TicketShop error: Closing printer failed: 6 The handle is invalid"

thanx
SoftPerfect Support forum - Andrew avatar image

PI service hangs   18 February 2012, 00:30

It's a non-critical error means Print Inspector was unable to correctly finish monitoring the printer. Does it happen repeatedly? If so, when?
Andrey

PI service hangs   18 February 2012, 00:40

"unable to correctly finish monitoring the printer"
Hm... Does it means that counting of printed pages is not correct?

How can I track "If so, when?" It happend today about 30 times during 50 minutes. Now everything is ok

How can I catch the event which leads to error?

thanx
SoftPerfect Support forum - Andrew avatar image

PI service hangs   18 February 2012, 01:24

Normally printers access handles are closed on stopping monitor or Print Inspector termination. It should not occur by itself. If possible, please post here a complete log.
Andrey

PI service hangs   22 February 2012, 16:14

Where can I find comlete log? U mean Windows App Log?
SoftPerfect Support forum - Andrew avatar image

PI service hangs   22 February 2012, 16:26

I mean Print Inspector log. See File - Event Log Viewer in the main menu.
Andrey

PI service hangs   22 February 2012, 18:06

log here
[sendfile.su]
SoftPerfect Support forum - Andrew avatar image

PI service hangs   22 February 2012, 22:46

I have published an updated build of Print Inspector where these errors should no longer occur.

You can download it here.
Andrey

PI service hangs   27 February 2012, 18:08

Thanx! I've renew build

Now I see in PrintInspectorService.exe properties:
date modified - 16.02.2012 22:54

Is it right?

After installation i canceled restart of Windows Server
SoftPerfect Support forum - Andrew avatar image

PI service hangs   27 February 2012, 23:13

Not really, it should be dated the 22nd of Feb. Perhaps the PrintInspectorService.exe file was locked, and it would not be replaced until restart.
Andrey

PI service hangs   27 February 2012, 23:40

Ok. I'll restart server later and post here the result of property checking

thanx
Andrey

PI service hangs   11 March 2012, 17:30

Good day again!
We have one more event in Application Log:
1. Unexpected exception occurred in the application. Error message: HP LaserJet 2300 PCL6_LAWYER error: TCoreDB: The database file is locked: database is locked
2. Unexpected exception occurred in the application. Error message: Monitoring thread abnormally terminated

I thought U resolve problem with locked database. Am I right? WHy this event occurs? Thanx
SoftPerfect Support forum - Andrew avatar image

PI service hangs   11 March 2012, 18:51

It occurs because Print Inspector could not acquire a lock on the database file within 10 seconds.

It's okay that you access the database file from your own application or script, but you need to make sure your transaction does not run longer than 10 seconds. If it does, Print Inspector doesn't have much choice: it needs to update the database and write job information, but it's opened by another application. So it waits for this period of time and then reports an error if the database does not become available.

Hope this helps.
Andrey

PI service hangs   12 March 2012, 01:05

Andrew, can U writi some tweak in PI or ini-file, which can change this setting, i mean "wait for db unlock" for example?
We doing our private reports using PI db and implementing information in our format. Is it possible?

thanx
SoftPerfect Support forum - Andrew avatar image

PI service hangs   13 March 2012, 18:37

Well, yes it's possible.

However, if you have long-running reports, a better solution would be to switch the database journalling mode to WAL.

Provided your ODBC SQLite provider supports it, you can turn the database into WAL mode. To do so, download a SQLite management tool, and run the following query:

PRAGMA journal_mode=WAL

Print Inspector service must be stopped beforehand. If it succeeds and your ODBC provider supports WAL databases, you can read the database as long as you want, it does not block writing.

Let me know if you need any help.

Sometimes you can get the answer faster if you try the forum search and/or have a look at the software user manual to see if your question has already been answered.

Our forum rules are simple:

  • Be polite.
  • Do not spam.
  • If possible, check your spelling and grammar.

Author:

Email:

Subject

A brief and informative title for your message, approximately 4–8 words:

     

Spam prevention: please enter the following code in the input field below.

  ******   **    **        **   *******   **        
 **    **   **  **         **  **     **  **    **  
 **          ****          **         **  **    **  
 **           **           **   *******   **    **  
 **           **     **    **         **  ********* 
 **    **     **     **    **  **     **        **  
  ******      **      ******    *******         **  

Message: