To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=103682
User fs changed the following:
What |Old value |New value
================================================================================
Assigned to|dbaneedsconfirm |fs
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Target milestone|--- |not determined
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Thu Aug 13 12:41:58 +0000
2009 -------
> IIRC, the following fixed the problem for my particular DB:
> - open the affected table in the table data view
> - change the value of the PK field in the last last (read: most recently
> inserted) to something else
> - change the value back
Ah, the most important information was missing here: You must not arbitrarily
change the value, but increment it by 1.
(for the record: I tried that with the corrupted database windl sent me
separately, and it worked fine - after that one could enter records, again.)
Still, there are open questions:
- How was this corrupted caused? Pretty difficult to find out
after-the-fact
- Can we fix HSQL to at least recognize this situation, and silently
correct it?
- Is there another manual workaround, like explicitly rebuilding the
affected index (since I assume that the index on the auto-inc PK column
is corrupted)?
I'll take over this issue, confirm it, and keep it for reference. Discussions
with the HSQL team are ongoing on this.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
