#1 2012-04-01 09:02:45

coblongpamor
Member
From: Bali-Indonesia
Registered: 2010-11-07
Posts: 130
Website

Active Transaction

i tried to vacuum the database with this code

Client.EngineExecute('VACUUM');

but sometimes ESQLException error occure with message "cannot VACUUM-SQL statements in progress".

how to check there are SQL statements exists/pending to be execute? or to check if TSQLRest have an transaction still active?

thanks.

Offline

#2 2012-04-02 04:54:10

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,183
Website

Re: Active Transaction

It is already reported and fixed in latest version of trunk.
See http://synopse.info/forum/viewtopic.php?pid=3796#p3796

Offline

#3 2012-04-02 07:10:25

coblongpamor
Member
From: Bali-Indonesia
Registered: 2010-11-07
Posts: 130
Website

Re: Active Transaction

Sorry, I forgot about this.
now the error does not appear anymore.

thank you

Offline

#4 2012-04-02 07:44:42

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,183
Website

Re: Active Transaction

No problem.

Thanks for the report, anyway.
smile

Offline

Board footer

Powered by FluxBB