Known Issues for Adaptive Server Cluster Edition

When Adaptive Server attempts to bootstrap COTS JVM, you may encounter a signal 11 followed by a stacktrace in the error log which includes the module jvmh_utl_printn. This will result in Java operations not being able to execute.

Workaround: To avoid the issue, change the global java.policy file by adding the following rule and changing the first string starting after file: with your absolute path.

grant codeBase "file:/absolute_path_to/sybase/ASE-15_0/lib/pca/sybasert.jar" { permission java.lang.reflect.ReflectPermission "suppressAccessChecks"; };

For example,

grant codeBase "file:/opt/sybase/ASE-15_0/lib/pca/sybasert.jar" { permission java.lang.reflect.Reflect-Permission "suppressAccessChecks"; };

For each platform, the java.policy file is located here:

• IBM - $SYBASE/shared/JRE-6_0_SR9FP1_64BIT/lib/security/java.policy
• HP - $SYBASE/shared/JRE-6_0_10/lib/security/java.policy
• Linux - $SYBASE/shared/JRE-6_0_24_64BIT/lib/security/java.policy
• Solaris - $SYBASE/shared/JRE-6_0_24/lib/security/java.policy

Under certain circumstances, Adapter Server may encounter a segmentation violation followed by a stacktrace involving the function uppwakeup() when the number of engines is decreased via the alter thread pool command.

Workaround: To avoid the segmentation violation, do not decrease the number of engines (thread count).

In active-active or active-passive cluster configurations, you can configure RepAgent to run on only one node of the cluster. These errors may occur in rare circumstances when RepAgent reads an older image of database log pages that is on disk while the latest image is on another node.

Workaround: Sybase recommends that for:

• Active-passive configuration – run RepAgent on the active node to ensure that data and log pages are on the same node as RepAgent.
• Active-active configuration – start Adaptive Server with the 16872 trace flag to prevent log page corruption and 69x errors. However, using this flag degrades the server performance.

ct_send(): network packet layer: internal Client Library error: State error: trying to write when connection is expecting a read.

This message is reported in some cases when Kerberos message confidentiality service is turned on.

Workaround: Reconnect to the server with confidentiality service turned off.

Workaround: You can safely ignore this message.

If the $SYBASE/SYBASE_ASE/locales directory contains files or directories that are not server-related locales files, the sybcluster localize utility does not function properly. If unrelated files are in the locales directory, the localize command aborts and raises an exception at the beginning phase. If an unrelated directory is in the locales directory, the charset selection menu is shown incorrectly and localize may abort during further processing.

Workaround: Do not place files or directories unrelated to localization in the $SYBASE/SYBASE_ASE/locales directory.

You may encounter errors in these scenarios:

Active - Active setup: There is more than one node on the cluster which sends insert/update/delete operations on the database. This results in logs generated for a database on more than one node.

Active - Passive setup: There is only one node on the cluster which sends insert/update/delete operations on the database. This node is considered an active node. If RepAgent is configured on a passive node, the passive node will only have read operations.

Workaround: Active - Active setup: In order to configure RepAgent and prevent 624 or 69x errors, use traceflag 16872. Using this traceflag will degrade the performance of the servers in the active-active scenario.

Active - Passive: Configure RepAgent on the active node.

Workaround: Turn on statement statistics active to use LogicalReads for the above MDA tables.

Workaround: None.

select for update support exists only for datarows-locked pages.

Workaround: None.

 sp_jreconfig "disable",  "pca_jvm_netio"

Workaround: Remove any unused RMI classes from the database. By default, pca_jvm_netio is enabled.

Workaround: None.

• When creating a unique index that is using the ignore_dup_key property, importing a row with a key that is already present in the table leads to an error, and the import is aborted. This differs from when a duplicate key is inserted with bcp or with a regular insert statement, since in those cases, the row is discarded, and the transaction continues.
• When an insert trigger exists, the trigger is not fired when data is inserted through transfer table...from.

Workaround: None.

While running on a single engine, Adaptive Server may either stop responding, or cause connected clients to block indefinitely, generate a stack trace, or not process when the server performs a task that uses Java, as soon as additional engines are manually brought online. This problem occurs due to an issue with the HP-UX commercial off-the-shelf Java Virtual Machine.

Workaround: Always have a minimum of two engines configured when starting Adaptive Server; this allows the HP-UX commercial off-the-shelf JVM to automatically target the highest engine number available.

In addition, do not set any configuration options in Adaptive Server that targets engine 0 for the HP-UX commercial off-the-shelf JVM.

Due to a known issue in HP-UX, creating a file using the Java in the database feature fails unless the working directory permission mask is set to 0777 or equivalent.

sp_jreconfig 'add', pca_jvm_work_dir, '/some/path(ugo=rwx)'

sp_jreconfig 'update', pca_jvm_work_dir, '/old/path', '/newpath(ugo=rwx)'

If you start an instance while the rest of the cluster is performing a diagnostic shared memory dump, the instance that is starting may incorrectly perform a cluster takeover. This occurs only if automatic cluster takeover is set to 1, or if the --cluster_takeover option is passed to the data server. In environments without i/o fencing enabled, this may lead to data corruption.

Workaround: Do not start an instance during a diagnostic shared-memory dump. Configure automatic cluster takeover to 0.

When you configure the Job Scheduler Self Management feature for an Adaptive Server localized for Simplified Chinese, you may receive an error saying that a varchar datatype cannot be converted to a date. The Job Scheduler configuration process stops at this point.

Workaround: Do not configure the Self Management feature for Simplified Chinese.

When you attempt to create a Job Scheduler schedule using the Adaptive Server plug-in for an Adaptive Server that is localized for Simplified Chinese, you may receive an error indicating that the varchar datatype cannot be converted to a date.

Workaround: Localize the Adaptive Server for Simplified Chinese before configuring Job Scheduler.