Hi,
Well, do you use two-phase commit? Could you check if there are any
in-doubt transactions, by running "select * from
information_schema.in_doubt"? If yes, those transactions need to be either
rolled back or committed first.
If no, then I wonder whether you explicitly open the database in read-only
mode, or possibly don't have access rights to write to the file.
Regards,
Thomas
On Mon, Sep 30, 2013 at 1:46 PM, Noel Grandin <noelgran...@gmail.com> wrote:
> Hi
>
> I'm sorry, at this I've reached the limit of my knowledge of that area of
> the engine.
> Hopefully Thomas will chime in.
>
> Is it indeed a problem in database recovery.
>
> I can tell is that it the DB is being set readonly by the following logic
> in PageStore.recover()
> if (log.getInDoubtTransactions().**size() == 0) {
> log.recoverEnd();
> int firstUncommittedSection = getFirstUncommittedSection();
> log.removeUntil(**firstUncommittedSection);
> } else {
> setReadOnly = true;
> }
>
> But what exactly that piece of logic is trying to achieve I do not know.
>
> Regards, Noel.
>
>
> On 2013-09-30 13:28, Dieter Cailliau wrote:
>
>> insert into Element (lastSeen, sources, name, options, tupple,
>> host_string, assets2, DTYPE, string) values (?, ?, ?, ?, ?, ?, ?,
>> 'DeviceCapabilityService', ?)
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to
> h2-database+unsubscribe@**googlegroups.com<h2-database%2bunsubscr...@googlegroups.com>
> .
> To post to this group, send email to h2-database@googlegroups.com.
> Visit this group at
> http://groups.google.com/**group/h2-database<http://groups.google.com/group/h2-database>
> .
> For more options, visit
> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out>
> .
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
