Hitachi

Hitachi Advanced Database Messages


KFAA34008-E

The synonym-dictionary-file aa....aa operation failed. (node number = bb....bb, IP address = cc....cc, server definition = dd....dd, file = ee....ee, errno = ff....ff) (M+J+O)

An error occurred during operation on the synonym dictionary file. <SQLSTATE: 53050>

aa....aa: Name of the system call that caused the error
  • close: Closing the file

  • lseek: Moving a pointer on the file

  • open: Opening the file

  • read: Reading the file

bb....bb: Node number of the node where the error occurred

If a multi-node configuration is not used, * is displayed.

cc....cc: IP address of the node where the error occurred

If a multi-node configuration is not used, * is displayed.

dd....dd: Server definition operand that specifies the directory containing the file in which the error occurred
  • adb_syndict_storage_path

  • adb_syndict_node_storage_path

ee....ee:

Name of the file in which the error occurred

ff....ff:

Error number

S:

Ignores this SQL statement.

Action:

An error occurred during operation of the synonym dictionary file ee....ee under the directory specified by the dd....dd operand. Check in the OS documentation for the system call name and error number that are displayed, and then eliminate the cause of the error. If you cannot determine the corrective action to take based on the displayed system call name and error number, execute the adbinfoget command to collect troubleshooting information, and then contact the customer support center.

However, if one of the following conditions is met, also perform the corrective action appropriate for the condition.

  • If this message is output during execution of an SQL statement with the scalar function CONTAINS (with the synonym-search specification) specified

    Check whether a file name that begins with a synonym dictionary name is displayed for ee....ee. If a file name that begins with a synonym dictionary name is displayed, the synonym dictionary file might not exist. Check in the OS documentation for the system call name and error number that are displayed. If the error is caused by the absence of a synonym dictionary file, re-register the synonym dictionary and re-create the synonym dictionary file.

    For details about how to re-create a synonym dictionary file, see Steps to take if synonym dictionary files or their storage directory is accidentally deleted in the HADB Setup and Operation Guide.

  • If the error number is 0

    An attempt to allocate memory failed during processing to read the synonym dictionary file. Check for any unnecessary processes. If there are any unnecessary processes, stop or delete them. Then, re-execute the adbsyndict command.