Re: Errors with Information_Schema in Create Target Results
Posted by: Vaughan Wickham
Date: October 30, 2021 05:50PM

Hello Peter,

Thanks for your last reply, that was very comprehensive. That would have taken me a long time to figure out, if at all.

I have started restoring the databases to the Lab server and am reviewing the log.

Some errors have occurred

ERROR 1128 (HY000): Function 'newforma_wordbreaker' is not defined
Query OK, 0 rows affected (0.00 sec)

Not sure about the significance of this error.


ERROR 1146 (42S02): Table 'newformaglobal_nix.search_content' doesn't exist
ERROR 1146 (42S02): Table 'newformaglobal_nix.search_content' doesn't exist
ERROR 1146 (42S02): Table 'newformaglobal_nix.search_content' doesn't exist
ERROR 1146 (42S02): Table 'newformaglobal_nix.search_content' doesn't exist
Query OK, 0 rows affected (0.00 sec)

I think this one is a concern, because the table doesn't exist in the Lab server but does exist in production.

What's not clear to me, is why this would be the case. As I would have thought that if a table wasn't created, that would lead to an error being reported.

Unless the consequences of that first error, is the table not being created?

Do you have any ideas?

There were also a bunch of the following (of which I have only shown a few)

Warning (Code 1300): Invalid utf8 character string: '9C73B1'
Warning (Code 1300): Invalid utf8 character string: '9CCBCC'
Warning (Code 1300): Invalid utf8 character string: '9C3306'
Warning (Code 1300): Invalid utf8 character string: '9C3333'
Warning (Code 1300): Invalid utf8 character string: '9C3336'
Warning (Code 1300): Invalid utf8 character string: '9C3332'
Warning (Code 1300): Invalid utf8 character string: '9C3334'
Warning (Code 1300): Invalid utf8 character string: '9C3333'

Can these warnings be ignored?

Options: ReplyQuote


Subject
Written By
Posted
Re: Errors with Information_Schema in Create Target Results
October 30, 2021 05:50PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.