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 <[email protected]> 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%[email protected]> > . > To post to this group, send email to [email protected]. > 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
