Does this look familiar?
R>reload electro
Reloading data for SYS_COMMENTS 186 rows reloaded
-ERROR- Table SYS_COMMENTS has an incorrect number of rows. ( 450)
Reloading data for SYS_DEFAULTS 48 rows reloaded
-ERROR- Table SYS_DEFAULTS has an incorrect number of rows. ( 450)
Reloading data for SYS_RULES 12 rows reloaded
-ERROR- Table SYS_RULES has an incorrect number of rows. ( 450)
Reloading data for SYS_VIEWS 64 rows reloaded
Reloading data for SYS_COMPUTED 66 rows reloaded
-ERROR- Table SYS_COMPUTED has an incorrect number of rows. ( 450)
Reloading data for SYS_PASSWORDS 0 rows reloaded
Reloading data for SYS_CONSTRAINTS 116 rows reloaded
-ERROR- Table SYS_CONSTRAINTS has an incorrect number of rows. ( 450)
Reloading data for SYS_FORMS 0 rows reloaded
Reloading data for SYS_REPORTS 0 rows reloaded
Reloading data for SYS_LABELS 0 rows reloaded
Interesting (and ugly) coincidence, late last week I discovered the same
exact issue with my largest database. I do not know what caused it (maybe
my development computer I use remotely I have been having problems with
lately corrupted something) but I spent most of this weekend working to
eliminate the issue.
The problem appears to have been a corrupted system table?, but I am not
sure. I thought I had exceeded the maximum width of a table, but I don't
believe that now, because I removed many columns and reloaded and the
problems remained. I will give you the short version of what I think fixed
it.
When I would alter my customer table all FKs would be broken (referencing a
non-existent table with a temp name) as a result of failing to finish the
save of the new table properly.
The way (I think) I fixed it was to unload structure and break it into
pieces to build tables and views and stop there. Then I added the data.
Then I added a primary key and saved the table and all 626,000 rows were
gone. Tried again with error messages on and got a constraint error from
the PK saying the rows must be unique. Tried again with the empty table and
said append table2 to table1 where limit = 1. I got the "must be unique"
error. One row created was not unique??? Really????
So I deleted the table and created it brand new (no PKs or FKs at this time
so I could do this). Then I added the PK and appended the 636000 rows
successfully. Then I traced through the rest of the unloaded structure file
and I noticed that the PK on the table referenced a wrong table name. This
is an error that I had found earlier during the weekend and could not
explain. Add a column to the invoice table and it would say that "rows in
the customer table must be unique!"
ALTER TABLE `Invoice` ADD PRIMARY KEY +
(`invctrlnum` ) +
('Values for rows in customer must be unique. (2738)',+
'Cannot delete - values exist in another table. (2509)',+
'Cannot update - values exist in another table. (2717)')
Also I noticed that the str.unl file would show:
ALTER TABLE `podetail` ADD FOREIGN KEY +
( `VPOSCN` )+
REFERENCES `polist`
Note the above should be followed by the two error messages. I found a
number of these.
Moral of story: I replaced two problem tables with fresh built tables and
added the data and the PKs manually, then traced line by line through the
creation of indexes carefully looking for errors in the unload structure
file (create index part) before running them one at a time (F10) and
aborting if I found a problem.
I just got home from fixing(?) everything and so far testing seems to have
everything OK. Needs further testing.
This was not fun at all, but while I was working through this I got an error
twice saying something like "disk error - please check disk and files".
This happend both local and over the network. I changed computers and
worked locally to fix the issue.
If I discover anything else I will post.
Kenny Camp
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Dave McCann
Sent: Friday, April 06, 2012 10:18 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - strange database errors
I've been up against a wall with a recent database problem on one of my
projects, hoping I can get some ideas.
Recently my database began having this issue, whenever I go to add a column
or make pretty much any structural change, I get an ERROR - A foreign key
references a table not known to be referenced (1242), followed by an ERROR -
The number of rows counted was not expected.
I have been able to UNLOAD my structure and recreate the database with
seemingly no errors, database checks out OK with AUTOCHK and R:Scope
afterwards, but as soon as I go to edit the structure the errors return.
Running R:Scope the errors are invalid row count errors in SYS_RULES,
SYS_CONSTRAINTS, and SYS_COMMENTS. I suspected something wrong with a
constraint or rule because I've made adjustments in those areas in the last
month and since the initial error indicates a problem with a foreign key.
Any ideas about how I could go about narrowing down the specific
problem? Since everything was valid when setup, and again when
structure was recreated just not quite sure why/how this could be happening.
--
Dave McCann
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
