mORMot Open Source

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.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,660

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

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

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,660

Website

Re: Active Transaction

No problem.

Thanks for the report, anyway.