Home > mailing lists

Thread: Postgresql service stopped automatically after restart

Postgresql service stopped automatically after restart

From

Kalai R

Date:

29 May 2014, 17:34:28

Hello,

I am developing application using postgresql 9.3 and VS2005 as FrontEnd.

I am using silent installation method to install postgresql from .Net application.

Postgresql installed and connected with application is fine

The problem is , when we on the system after shut down, postgresql service doesn't start. Can't start manually also. At this situation,

-> sometime files are deleted in bin folder, if I paste the deleted files in that folder, service start

->sometime files are not deleted,could not start the service

->some time if we change the postgresql service to local system account, service start

->some time if we change the postgresql service to local system account, could not start the service

Mostly this problem occurs in the System that have Windows XP or if any Virus Scanner installed

How to solve this Problem?

Thanks & Regards

kalai

Re: Postgresql service stopped automatically after restart

From

Adrian Klaver

Date:

29 May 2014, 17:45:59

On 05/29/2014 07:34 AM, Kalai R wrote:
> Hello,
>
> I am developing application using postgresql 9.3 and VS2005 as FrontEnd.
> I am using silent installation method to install postgresql from .Net
> application.
> Postgresql installed and connected with application is fine
>
> *The problem is* , when we on the system after shut down, postgresql
> service doesn't start. Can't start manually also. At this situation,
>
> -> sometime files are deleted in bin folder, if I paste the deleted
> files in that folder, service start
>
> ->sometime files are not deleted,could not start the service
>
> ->some time if we change the postgresql service to local system account,
> service start
>
> ->some time if we change the postgresql service to local system account,
> could not start the service
>
>
> Mostly this problem occurs in the System that have Windows XP or if any
> *Virus Scanner installed*
>
> How to solve this Problem?

Start by looking in the Postgres logs. The last time you had this issue
it was a mis-configured pg_hba.conf file:

http://www.postgresql.org/message-id/AANLkTikKMzZxcfirFMHEXu-ABE+ohqUwH2TcdQJZi7Dh@mail.gmail.com

As to deleted files, I would start by disabling the AV software checks
for the Postgres directories.

>
> Thanks & Regards
> kalai


--
Adrian Klaver
adrian.klaver@aklaver.com

Re: Postgresql service stopped automatically after restart

From

Kalai R

Date:

29 May 2014, 18:01:33

I have checked no problem in pg_hba.conf file.

Also I have disabled AV software checks for the Postgres Directories.

But Problem remains

On Thu, May 29, 2014 at 8:15 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:

On 05/29/2014 07:34 AM, Kalai R wrote:
Hello,

I am developing application using postgresql 9.3 and VS2005 as FrontEnd.
I am using silent installation method to install postgresql from .Net
application.
Postgresql installed and connected with application is fine

*The problem is* , when we on the system after shut down, postgresql

service doesn't start. Can't start manually also. At this situation,

-> sometime files are deleted in bin folder, if I paste the deleted
files in that folder, service start

->sometime files are not deleted,could not start the service

->some time if we change the postgresql service to local system account,
service start

->some time if we change the postgresql service to local system account,
could not start the service

Mostly this problem occurs in the System that have Windows XP or if any
*Virus Scanner installed*

How to solve this Problem?

Start by looking in the Postgres logs. The last time you had this issue it was a mis-configured pg_hba.conf file:

http://www.postgresql.org/message-id/AANLkTikKMzZxcfirFMHEXu-ABE+ohqUwH2TcdQJZi7Dh@mail.gmail.com

As to deleted files, I would start by disabling the AV software checks for the Postgres directories.

Thanks & Regards
kalai

--
Adrian Klaver
adrian.klaver@aklaver.com

Re: Postgresql service stopped automatically after restart

From

Adrian Klaver

Date:

30 May 2014, 02:22:17

On 05/29/2014 08:01 AM, Kalai R wrote:
> I have checked no problem in pg_hba.conf file.

Have you checked the Postgres or Windows system logs?

>
> Also I have disabled AV software checks for the Postgres Directories.
>
> But Problem remains

There actually seem to be several problems across multiple platforms if
I am following correctly. An attempt at a solution is going to need a
great deal more information then what we have been given so far. My
suggestion would be to stick to one issue at a time and work it to
completion, say the case where the files are not deleted but the service
does not start.

For starters, information that would be helpful:

1) OS version

2) What your .NET application is actually doing when installing Postgres.

3) Error messages that the user sees.

4) Error messages from the Postgres/OS logs

5) I assume this system was working in the past, so an indication of
when it quit working and any changes that occurred over that time period.

>

>

--
Adrian Klaver
adrian.klaver@aklaver.com

Re: Postgresql service stopped automatically after restart

From

David G Johnston

Date:

30 May 2014, 04:53:10

Kalai R wrote
> I have checked no problem in pg_hba.conf file.
>
> Also I have disabled AV software checks for the Postgres Directories.
>
> But Problem remains

Disabling AV won't magically make the system start working if it's already
broken.  You disable it to avoid breaking the system in the first place.

David J.



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Postgresql-service-stopped-automatically-after-restart-tp5805424p5805513.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Re: Postgresql service stopped automatically after restart

From

Kalai R

Date:

04 June 2014, 16:47:48

Hi,

Yesterday the psql service stopped in our two customers's machines

Windows OS ---> Windows XP

We re-installed the postgresql to solve the problem.

We use postgresql silent installation method to install psql from Our application

Psql Log for one machine

2014-06-01 18:29:48 IST LOG: database system was interrupted; last known up at 2014-06-01 18:23:19 IST

2014-06-01 18:29:49 IST LOG: database system was not properly shut down; automatic recovery in progress

2014-06-01 18:29:49 IST LOG: record with zero length at 0/5C44778

2014-06-01 18:29:49 IST LOG: redo is not required

2014-06-01 18:29:50 IST LOG: database system is ready to accept connections

2014-06-01 18:29:50 IST LOG: autovacuum launcher started

2014-06-01 18:33:21 IST ERROR: canceling statement due to user request

2014-06-01 18:33:21 IST LOG: received fast shutdown request

2014-06-01 18:33:21 IST LOG: aborting any active transactions

2014-06-01 18:33:21 IST ERROR: canceling statement due to user request

2014-06-01 18:33:21 IST LOG: autovacuum launcher shutting down

2014-06-01 18:33:21 IST LOG: shutting down

2014-06-01 18:33:22 IST LOG: database system is shut down

psql log for another one machine

2014-06-02 09:50:52 IST FATAL: the database system is starting up

2014-06-02 09:50:52 IST LOG: database system was shut down at 2014-06-01 17:04:03 IST

2014-06-02 09:50:53 IST FATAL: the database system is starting up

2014-06-02 09:50:53 IST LOG: database system is ready to accept connections

2014-06-02 09:50:53 IST LOG: autovacuum launcher started

2014-06-02 10:22:56 IST LOG: could not receive data from client: No connection could be made because the target machine actively refused it.

2014-06-02 10:23:54 IST ERROR: syntax error at or near ")" at character 515

2014-06-02 10:23:54 IST STATEMENT: select mrp,batchno,expdate,totalstock, salesrate, info from( select to_char(s.mrp,'FMFM9,99,99,99,990.00') as mrp,s.batchno,s.expdate, case when mu.units > 1 then div(cast (sum(stock) as numeric),mu.units) else sum(stock) end || case when mu.units > 1 and (cast(sum(stock) as numeric) % mu.units) <> 0 then '.' || abs(cast(sum(stock) as numeric) % mu.units) else '' end as totalstock, salesrate,info from stock s left join pricelist p on (s.itemno=p.itemno and s.mrp=p.mrp and s.batchno=p.batchno and p.itemno=),items i,measureunits mu where s.itemno= and mu.unitno=i.unitno and i.itemno=s.itemno group by s.mrp,s.batchno,s.expdate,salesrate,info,mu.units) as t where cast(totalstock as double precision) > 0 order by mrp,batchno,expdate

2014-06-02 10:47:53 IST LOG: could not receive data from client: No connection could be made because the target machine actively refused it.

2014-06-02 11:07:59 IST LOG: could not receive data from client: No connection could be made because the target machine actively refused it.

2014-06-02 11:33:16 IST LOG: could not receive data from client: No connection could be made because the target machine actively refused it.

2014-06-02 11:59:43 IST LOG: could not receive data from client: No connection could be made because the target machine actively refused it.

2014-06-02 12:00:41 IST ERROR: update or delete on table "items" violates foreign key constraint "sales2_itemno_fk" on table "sales2"

2014-06-02 12:00:41 IST DETAIL: Key (itemno)=(509) is still referenced from table "sales2".

2014-06-02 12:00:41 IST CONTEXT: SQL statement "delete from items where itemno=$1[1].itemno"

PL/pgSQL function public.fn_items(public.items[],integer,public.itembarcode[],integer,text,integer) line 79 at SQL statement

2014-06-02 12:00:41 IST STATEMENT: select public.fn_items(array[row(509,'ANODIESED DLX+ 5 LIT','20351','','',0,1,29,5,1,1,'N',0,0,'Y','N','N','','N','',0,'',0,1,1,0,'V','Y',0,0,0,'0',0,'','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','','','','','','','','','True')::public.items],1,'{}',0,'D',1)

2014-06-02 12:20:59 IST LOG: could not receive data from client: No connection could be made because the target machine actively refused it.

2014-06-02 14:44:50 IST LOG: could not receive data from client: No connection could be made because the target machine actively refused it.

2014-06-02 16:14:20 IST LOG: could not receive data from client: No connection could be made because the target machine actively refused it.

2014-06-02 16:32:54 IST LOG: could not reserve shared memory region (addr=029D0000) for child 000004D8: error code 1455

2014-06-02 16:32:54 IST LOG: could not fork autovacuum worker process: A blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:32:55 IST LOG: could not reserve shared memory region (addr=029D0000) for child 000004D0: error code 1455

2014-06-02 16:32:55 IST LOG: could not fork autovacuum worker process: A blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:32:56 IST LOG: could not reserve shared memory region (addr=029D0000) for child 00000474: error code 1455

2014-06-02 16:32:56 IST LOG: could not fork autovacuum worker process: A blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:32:57 IST LOG: could not reserve shared memory region (addr=029D0000) for child 000004A4: error code 1455

2014-06-02 16:32:57 IST LOG: could not fork autovacuum worker process: A blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:32:58 IST LOG: CreateProcess call failed: A blocking operation was interrupted by a call to WSACancelBlockingCall.

(error code 1455)

2014-06-02 16:32:58 IST LOG: could not fork autovacuum worker process: A blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:32:59 IST LOG: CreateProcess call failed: A blocking operation was interrupted by a call to WSACancelBlockingCall.

(error code 1455)

2014-06-02 16:32:59 IST LOG: could not fork autovacuum worker process: A blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:00 IST LOG: could not reserve shared memory region (addr=029D0000) for child 0000008C: error code 1455

2014-06-02 16:33:00 IST LOG: could not fork autovacuum worker process: A blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:01 IST LOG: could not reserve shared memory region (addr=029D0000) for child 000004DC: error code 1455

2014-06-02 16:33:01 IST LOG: could not fork autovacuum worker process: A blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:02 IST LOG: CreateProcess call failed: A blocking operation was interrupted by a call to WSACancelBlockingCall.

(error code 1455)

2014-06-02 16:33:02 IST LOG: could not fork autovacuum worker process: A blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:03 IST LOG: CreateProcess call failed: A blocking operation was interrupted by a call to WSACancelBlockingCall.

(error code 1455)

2014-06-02 16:33:03 IST LOG: could not fork autovacuum worker process: A blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:04 IST LOG: CreateProcess call failed: A blocking operation was interrupted by a call to WSACancelBlockingCall.

(error code 1455)

2014-06-02 16:33:04 IST LOG: could not fork autovacuum worker process: A blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:05 IST LOG: CreateProcess call failed: A blocking operation was interrupted by a call to WSACancelBlockingCall.

(error code 1455)

2014-06-02 16:33:05 IST LOG: could not fork autovacuum worker process: A blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:06 IST LOG: CreateProcess call failed: A blocking operation was interrupted by a call to WSACancelBlockingCall.

(error code 1455)

2014-06-02 16:33:06 IST LOG: could not fork autovacuum worker process: A blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:07 IST LOG: could not reserve shared memory region (addr=029D0000) for child 000004E8: error code 1455

2014-06-02 16:33:07 IST LOG: could not fork autovacuum worker process: A blocking operation was interrupted by a call to WSACancelBlockingCall.

2014-06-02 16:33:08 IST LOG: could not reserve shared memory region (addr=029D0000) for child 000004EC: error code 1455

2014-06-02 16:33:08 IST LOG: could not fork autovacuum worker process: A blocking operation was interrupted by a call to WSACancelBlockingCall.

TopMemoryContext: 246368 total in 31 blocks; 16528 free (120 chunks); 229840 used

TopTransactionContext: 8192 total in 1 blocks; 7696 free (0 chunks); 496 used

PL/pgSQL function context: 24576 total in 2 blocks; 14768 free (1 chunks); 9808 used

PL/pgSQL function context: 24576 total in 2 blocks; 10488 free (2 chunks); 14088 used

PL/pgSQL function context: 24576 total in 2 blocks; 4448 free (3 chunks); 20128 used

PL/pgSQL function context: 57344 total in 3 blocks; 11680 free (3 chunks); 45664 used

PL/pgSQL function context: 24576 total in 2 blocks; 3544 free (2 chunks); 21032 used

Record information cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used

PL/pgSQL function context: 122880 total in 4 blocks; 21568 free (2 chunks); 101312 used

RI compare cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used

RI query cache: 8192 total in 1 blocks; 4936 free (0 chunks); 3256 used

RI constraint cache: 73536 total in 3 blocks; 5904 free (0 chunks); 67632 used

PL/pgSQL function context: 122880 total in 4 blocks; 56928 free (2 chunks); 65952 used

PL/pgSQL function context: 57344 total in 3 blocks; 29248 free (3 chunks); 28096 used

PL/pgSQL function context: 122880 total in 4 blocks; 62848 free (2 chunks); 60032 used

PL/pgSQL function context: 57344 total in 3 blocks; 7448 free (3 chunks); 49896 used

PL/pgSQL function context: 253952 total in 5 blocks; 43672 free (2 chunks); 210280 used

CFuncHash: 8192 total in 1 blocks; 4936 free (0 chunks); 3256 used

Rendezvous variable hash: 8192 total in 1 blocks; 3848 free (0 chunks); 4344 used

PLpgSQL function cache: 24200 total in 2 blocks; 5904 free (0 chunks); 18296 used

Type information cache: 24576 total in 2 blocks; 14072 free (6 chunks); 10504 used

TableSpace cache: 8192 total in 1 blocks; 5640 free (0 chunks); 2552 used

Operator lookup cache: 57344 total in 3 blocks; 38624 free (14 chunks); 18720 used

MessageContext: 1048576 total in 8 blocks; 432824 free (4 chunks); 615752 used

JoinRelHashTable: 8192 total in 1 blocks; 4864 free (0 chunks); 3328 used

Operator class cache: 8192 total in 1 blocks; 4872 free (0 chunks); 3320 used

smgr relation table: 24576 total in 2 blocks; 6848 free (4 chunks); 17728 used

ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used

hba parser context: 7168 total in 3 blocks; 4280 free (2 chunks); 2888 used

TransactionAbortContext: 32768 total in 1 blocks; 32752 free (0 chunks); 16 used

Portal hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used

PortalMemory: 8192 total in 1 blocks; 8040 free (2 chunks); 152 used

PortalHeapMemory: 1024 total in 1 blocks; 936 free (0 chunks); 88 used

ExecutorState: 180560 total in 9 blocks; 1576 free (3 chunks); 178984 used

ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used

AggContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used

ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used

Relcache by OID: 8192 total in 1 blocks; 256 free (0 chunks); 7936 used

CacheMemoryContext: 2259528 total in 23 blocks; 48120 free (5 chunks); 2211408 used

CachedPlan: 64512 total in 6 blocks; 17320 free (0 chunks); 47192 used

CachedPlan: 31744 total in 5 blocks; 3416 free (0 chunks); 28328 used

CachedPlan: 31744 total in 5 blocks; 10040 free (0 chunks); 21704 used

purchase3_txnorowkeystockpointno_pk: 1024 total in 1 blocks; 312 free (0 chunks); 712 used

CachedPlan: 7168 total in 3 blocks; 2928 free (0 chunks); 4240 used

CachedPlan: 31744 total in 5 blocks; 15976 free (0 chunks); 15768 used

purchase2_rowkey_uq: 1024 total in 1 blocks; 480 free (0 chunks); 544 used

purchase2_txnoslno_pk: 1024 total in 1 blocks; 480 free (0 chunks); 544 used

CachedPlanSource: 3072 total in 2 blocks; 1688 free (0 chunks); 1384 used

CachedPlanQuery: 7168 total in 3 blocks; 4072 free (1 chunks); 3096 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

acvnosetup_vtnomonth_pk: 1024 total in 1 blocks; 480 free (0 chunks); 544 used

acvnosetup_vtnoprestartsuffix_uq: 3072 total in 2 blocks; 1840 free (0 chunks); 1232 used

CachedPlanSource: 3072 total in 2 blocks; 1256 free (0 chunks); 1816 used

CachedPlanQuery: 3072 total in 2 blocks; 496 free (1 chunks); 2576 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 1024 total in 1 blocks; 552 free (0 chunks); 472 used

CachedPlanSource: 1024 total in 1 blocks; 224 free (0 chunks); 800 used

CachedPlanQuery: 1024 total in 1 blocks; 536 free (1 chunks); 488 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlanSource: 3072 total in 2 blocks; 1616 free (0 chunks); 1456 used

CachedPlanQuery: 7168 total in 3 blocks; 2528 free (1 chunks); 4640 used

SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used

CachedPlanSource: 3072 total in 2 blocks; 1640 free (1 chunks); 1432 used

CachedPlanQuery: 3072 total in 2 blocks; 704 free (1 chunks); 2368 used

SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used

CachedPlanSource: 3072 total in 2 blocks; 1616 free (0 chunks); 1456 used

CachedPlanQuery: 3072 total in 2 blocks; 680 free (1 chunks); 2392 used

SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used

CachedPlanSource: 15360 total in 4 blocks; 400 free (0 chunks); 14960 used

CachedPlanQuery: 15360 total in 4 blocks; 2240 free (1 chunks); 13120 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 3072 total in 2 blocks; 1720 free (0 chunks); 1352 used

CachedPlanSource: 3072 total in 2 blocks; 1456 free (0 chunks); 1616 used

CachedPlanQuery: 3072 total in 2 blocks; 1784 free (1 chunks); 1288 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 1024 total in 1 blocks; 40 free (0 chunks); 984 used

CachedPlanSource: 3072 total in 2 blocks; 1648 free (0 chunks); 1424 used

CachedPlanQuery: 1024 total in 1 blocks; 24 free (1 chunks); 1000 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 1024 total in 1 blocks; 344 free (0 chunks); 680 used

CachedPlanSource: 1024 total in 1 blocks; 48 free (0 chunks); 976 used

CachedPlanQuery: 1024 total in 1 blocks; 328 free (1 chunks); 696 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 1024 total in 1 blocks; 344 free (0 chunks); 680 used

CachedPlanSource: 1024 total in 1 blocks; 40 free (0 chunks); 984 used

CachedPlanQuery: 1024 total in 1 blocks; 328 free (1 chunks); 696 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used

CachedPlanSource: 1024 total in 1 blocks; 200 free (0 chunks); 824 used

CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used

CachedPlanSource: 1024 total in 1 blocks; 200 free (0 chunks); 824 used

CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlanSource: 3072 total in 2 blocks; 1112 free (0 chunks); 1960 used

CachedPlanQuery: 3072 total in 2 blocks; 336 free (1 chunks); 2736 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 3072 total in 2 blocks; 864 free (0 chunks); 2208 used

CachedPlan: 7168 total in 3 blocks; 3552 free (0 chunks); 3616 used

CachedPlan: 7168 total in 3 blocks; 160 free (0 chunks); 7008 used

CachedPlan: 7168 total in 3 blocks; 3008 free (0 chunks); 4160 used

CachedPlan: 7168 total in 3 blocks; 1968 free (0 chunks); 5200 used

CachedPlan: 7168 total in 3 blocks; 1384 free (0 chunks); 5784 used

CachedPlan: 7168 total in 3 blocks; 3000 free (0 chunks); 4168 used

stock_stockpointnoitemnonpr_pk: 3072 total in 2 blocks; 2000 free (0 chunks); 1072 used

CachedPlan: 7168 total in 3 blocks; 2920 free (0 chunks); 4248 used

CachedPlan: 3072 total in 2 blocks; 72 free (0 chunks); 3000 used

pricelist_itemnomrpbatchno_pk: 1024 total in 1 blocks; 312 free (0 chunks); 712 used

CachedPlan: 7168 total in 3 blocks; 2992 free (0 chunks); 4176 used

CachedPlan: 3072 total in 2 blocks; 640 free (0 chunks); 2432 used

CachedPlan: 3072 total in 2 blocks; 1592 free (0 chunks); 1480 used

CachedPlan: 3072 total in 2 blocks; 384 free (0 chunks); 2688 used

CachedPlan: 3072 total in 2 blocks; 1592 free (0 chunks); 1480 used

CachedPlan: 3072 total in 2 blocks; 176 free (0 chunks); 2896 used

CachedPlan: 7168 total in 3 blocks; 2112 free (0 chunks); 5056 used

CachedPlan: 7168 total in 3 blocks; 1888 free (0 chunks); 5280 used

CachedPlan: 31744 total in 5 blocks; 7664 free (0 chunks); 24080 used

CachedPlanSource: 3072 total in 2 blocks; 1104 free (0 chunks); 1968 used

CachedPlanQuery: 7168 total in 3 blocks; 2808 free (1 chunks); 4360 used

SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used

CachedPlanSource: 3072 total in 2 blocks; 1104 free (0 chunks); 1968 used

CachedPlanQuery: 7168 total in 3 blocks; 2808 free (1 chunks); 4360 used

SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used

CachedPlan: 15360 total in 4 blocks; 8072 free (0 chunks); 7288 used

CachedPlan: 7168 total in 3 blocks; 2624 free (0 chunks); 4544 used

CachedPlanSource: 3072 total in 2 blocks; 1104 free (0 chunks); 1968 used

CachedPlanQuery: 7168 total in 3 blocks; 2808 free (1 chunks); 4360 used

SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used

CachedPlan: 15360 total in 4 blocks; 1696 free (0 chunks); 13664 used

CachedPlan: 7168 total in 3 blocks; 2912 free (0 chunks); 4256 used

CachedPlan: 31744 total in 5 blocks; 10040 free (0 chunks); 21704 used

CachedPlan: 31744 total in 5 blocks; 9792 free (0 chunks); 21952 used

purchase1_vtnoprefixidnosuffix_uq: 1024 total in 1 blocks; 312 free (0 chunks); 712 used

purchase1_txno_pk: 1024 total in 1 blocks; 552 free (0 chunks); 472 used

purchase1: 56320 total in 9 blocks; 5776 free (0 chunks); 50544 used

CachedPlanSource: 3072 total in 2 blocks; 1640 free (1 chunks); 1432 used

CachedPlanQuery: 3072 total in 2 blocks; 704 free (1 chunks); 2368 used

SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used

itemsuppliers_itemnoacno_pk: 1024 total in 1 blocks; 480 free (0 chunks); 544 used

CachedPlan: 7168 total in 3 blocks; 2576 free (0 chunks); 4592 used

CachedPlan: 3072 total in 2 blocks; 1080 free (0 chunks); 1992 used

CachedPlan: 3072 total in 2 blocks; 1632 free (1 chunks); 1440 used

CachedPlanSource: 3072 total in 2 blocks; 1640 free (1 chunks); 1432 used

CachedPlanQuery: 7168 total in 3 blocks; 2424 free (1 chunks); 4744 used

SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used

CachedPlanSource: 3072 total in 2 blocks; 512 free (0 chunks); 2560 used

CachedPlanQuery: 3072 total in 2 blocks; 344 free (1 chunks); 2728 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 31744 total in 5 blocks; 7736 free (0 chunks); 24008 used

CachedPlan: 15360 total in 4 blocks; 5568 free (0 chunks); 9792 used

CachedPlan: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used

CachedPlan: 3072 total in 2 blocks; 8 free (0 chunks); 3064 used

CachedPlan: 7168 total in 3 blocks; 2952 free (0 chunks); 4216 used

CachedPlan: 3072 total in 2 blocks; 992 free (0 chunks); 2080 used

CachedPlan: 7168 total in 3 blocks; 3448 free (0 chunks); 3720 used

pricelistreview_edateitemnomrpbatchno_pk: 1024 total in 1 blocks; 312 free (0 chunks); 712 used

CachedPlan: 3072 total in 2 blocks; 984 free (1 chunks); 2088 used

CachedPlanSource: 3072 total in 2 blocks; 504 free (0 chunks); 2568 used

CachedPlanQuery: 3072 total in 2 blocks; 344 free (1 chunks); 2728 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 7168 total in 3 blocks; 1448 free (0 chunks); 5720 used

CachedPlanSource: 3072 total in 2 blocks; 1640 free (1 chunks); 1432 used

CachedPlanQuery: 7168 total in 3 blocks; 2424 free (1 chunks); 4744 used

SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used

CachedPlan: 7168 total in 3 blocks; 704 free (0 chunks); 6464 used

CachedPlan: 7168 total in 3 blocks; 2184 free (0 chunks); 4984 used

CachedPlan: 7168 total in 3 blocks; 1616 free (0 chunks); 5552 used

CachedPlan: 7168 total in 3 blocks; 2344 free (0 chunks); 4824 used

CachedPlan: 3072 total in 2 blocks; 152 free (0 chunks); 2920 used

CachedPlan: 7168 total in 3 blocks; 3800 free (0 chunks); 3368 used

CachedPlan: 7168 total in 3 blocks; 3360 free (0 chunks); 3808 used

CachedPlan: 3072 total in 2 blocks; 984 free (1 chunks); 2088 used

CachedPlan: 3072 total in 2 blocks; 376 free (0 chunks); 2696 used

CachedPlan: 3072 total in 2 blocks; 136 free (1 chunks); 2936 used

CachedPlan: 7168 total in 3 blocks; 2360 free (0 chunks); 4808 used

CachedPlan: 3072 total in 2 blocks; 576 free (0 chunks); 2496 used

CachedPlan: 3072 total in 2 blocks; 16 free (0 chunks); 3056 used

CachedPlan: 3072 total in 2 blocks; 736 free (0 chunks); 2336 used

CachedPlan: 31744 total in 5 blocks; 7384 free (0 chunks); 24360 used

CachedPlan: 7168 total in 3 blocks; 3928 free (0 chunks); 3240 used

CachedPlan: 3072 total in 2 blocks; 1032 free (0 chunks); 2040 used

CachedPlan: 3072 total in 2 blocks; 344 free (0 chunks); 2728 used

items_itemno_pk: 1024 total in 1 blocks; 552 free (0 chunks); 472 used

items_itemname_uq: 1024 total in 1 blocks; 288 free (0 chunks); 736 used

items: 89088 total in 13 blocks; 1112 free (0 chunks); 87976 used

CachedPlan: 7168 total in 3 blocks; 3752 free (0 chunks); 3416 used

CachedPlan: 7168 total in 3 blocks; 3248 free (0 chunks); 3920 used

CachedPlan: 3072 total in 2 blocks; 8 free (0 chunks); 3064 used

CachedPlan: 3072 total in 2 blocks; 344 free (0 chunks); 2728 used

CachedPlan: 7168 total in 3 blocks; 1552 free (0 chunks); 5616 used

CachedPlan: 7168 total in 3 blocks; 4064 free (1 chunks); 3104 used

CachedPlan: 3072 total in 2 blocks; 8 free (0 chunks); 3064 used

CachedPlanSource: 3072 total in 2 blocks; 1640 free (1 chunks); 1432 used

CachedPlanQuery: 3072 total in 2 blocks; 704 free (1 chunks); 2368 used

SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used

CachedPlanSource: 3072 total in 2 blocks; 712 free (0 chunks); 2360 used

CachedPlanQuery: 3072 total in 2 blocks; 1144 free (1 chunks); 1928 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 7168 total in 3 blocks; 3768 free (0 chunks); 3400 used

CachedPlan: 7168 total in 3 blocks; 4056 free (1 chunks); 3112 used

CachedPlan: 7168 total in 3 blocks; 1552 free (0 chunks); 5616 used

CachedPlan: 7168 total in 3 blocks; 1528 free (0 chunks); 5640 used

CachedPlan: 7168 total in 3 blocks; 1552 free (0 chunks); 5616 used

CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used

CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used

CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used

CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used

CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

taxsetup_taxtrans_pk: 3072 total in 2 blocks; 2000 free (0 chunks); 1072 used

CachedPlan: 3072 total in 2 blocks; 1272 free (0 chunks); 1800 used

CachedPlanSource: 3072 total in 2 blocks; 208 free (0 chunks); 2864 used

CachedPlanQuery: 7168 total in 3 blocks; 3544 free (1 chunks); 3624 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 1024 total in 1 blocks; 216 free (0 chunks); 808 used

CachedPlanSource: 3072 total in 2 blocks; 1824 free (2 chunks); 1248 used

CachedPlanQuery: 1024 total in 1 blocks; 200 free (1 chunks); 824 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 1024 total in 1 blocks; 216 free (0 chunks); 808 used

CachedPlanSource: 3072 total in 2 blocks; 1872 free (2 chunks); 1200 used

CachedPlanQuery: 1024 total in 1 blocks; 200 free (1 chunks); 824 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 1024 total in 1 blocks; 552 free (0 chunks); 472 used

CachedPlanSource: 1024 total in 1 blocks; 232 free (0 chunks); 792 used

CachedPlanQuery: 1024 total in 1 blocks; 536 free (1 chunks); 488 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlanSource: 3072 total in 2 blocks; 200 free (0 chunks); 2872 used

CachedPlanQuery: 3072 total in 2 blocks; 168 free (1 chunks); 2904 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 3072 total in 2 blocks; 880 free (0 chunks); 2192 used

CachedPlan: 3072 total in 2 blocks; 1080 free (0 chunks); 1992 used

CachedPlan: 7168 total in 3 blocks; 936 free (0 chunks); 6232 used

CachedPlan: 7168 total in 3 blocks; 3136 free (0 chunks); 4032 used

CachedPlan: 1024 total in 1 blocks; 576 free (0 chunks); 448 used

CachedPlanSource: 1024 total in 1 blocks; 344 free (0 chunks); 680 used

CachedPlanQuery: 1024 total in 1 blocks; 560 free (1 chunks); 464 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 1024 total in 1 blocks; 584 free (0 chunks); 440 used

CachedPlanSource: 1024 total in 1 blocks; 272 free (0 chunks); 752 used

CachedPlanQuery: 1024 total in 1 blocks; 568 free (1 chunks); 456 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlan: 7168 total in 3 blocks; 2280 free (0 chunks); 4888 used

CachedPlanSource: 7168 total in 3 blocks; 1672 free (0 chunks); 5496 used

CachedPlanQuery: 7168 total in 3 blocks; 2504 free (1 chunks); 4664 used

SPI Plan: 1024 total in 1 blocks; 896 free (0 chunks); 128 used

CachedPlanSource: 3072 total in 2 blocks; 1608 free (0 chunks); 1464 used

CachedPlanQuery: 3072 total in 2 blocks; 368 free (1 chunks); 2704 used

SPI Plan: 1024 total in 1 blocks; 880 free (0 chunks); 144 used

CachedPlanSource: 7168 total in 3 blocks; 3608 free (0 chunks); 3560 used

CachedPlanQuery: 7168 total in 3 blocks; 3528 free (1 chunks); 3640 used