Troubleshooting Full-Text Search Error (DB99999)

If you are using a full-text search server, and you want to migrate Garoon to a server with different OS on the source and destination, you must disable notifications sent from the MySQL service to the full-text search server before migration.
Otherwise, an error (DB99999) occurs and the full-text search server may not create indexes.

An Error Message Example

[Thu, 18 Feb 2016 12:02:13 +0900] 1 messages indexed.Error: DB99999
An error occurred in the database.
Database Error Number: 1305

Cause:
Response from Database: FUNCTION cb_cbgrn.notify does not exist

Counter Measure:
Please contact our official partners or your vendor.

If the above error occurs, change the MySQL notify library.

Changing the notify Library on Windows

This section describes a solution in case if an error (DB99999) occurs after migrating Garoon from a Linux environment to a Windows environment using a full-text search server with Garoon.
If the error above occurs, change the library used by MySQL from the one for Linux environment (notify.so) to the one for Windows environment (notify.dll).

Steps:
  1. Copy the notify library for Windows environment (notify.dll) to one for Linux environment (notify.so).

    Execute the following command: Type the command in one line.

    copy C:\Program Files\Cybozu\mysql-5.0\lib\plugin\notify.dll C:\Program Files\Cybozu\mysql-5.0\lib\plugin\notify.so

  2. Restart the MySQL service.

    From the Windows Start menu, select Administrative Tools > Service, and restart the following service:

    • Cybozu_Database_Engine_5_0

  3. Execute the following command to move the directory:

    cd C:\inetpub\scripts\cbgrn

  4. Activate notifications that the MySQL service sends to the full-text search server.

    Execute the following command: Type the command in one line.

    .\grn.exe -C -q code\command\fts\enable_udf_notifier.csp db_admin_password=(database administrator password)

    Confirm that "UDF notifier is available" appears. If you receive an error message, see "Appendix B Error Messages" in the full-text search server guide.

  5. Stop the MySQL service.

    From the Windows Start menu, select "Administrative Tools" > "Services" to stop the following service:

    • Cybozu_Database_Engine_5_0

  6. Delete the notify library for Linux environment (notify.so) that you created in step 1.

    Execute the following command: Type the command in one line.

    del C:\Program Files\Cybozu\mysql-5.0\lib\plugin\notify.so

  7. Start the MySQL service.

    From the Windows Start menu, select Administrative Tools > service, and start the following services.

    • Cybozu_Database_Engine_5_0

Changing the notify Library on Linux

This section describes a solution in case if an error (DB99999) occurs after migrating Garoon from a Windows environment to a Linux environment using a full-text search server with Garoon.
If the error above occurs, change the library used by MySQL from the one for Windows environment (notify.dll) to the one for Linux environment (notify.so).

Steps:
  1. Copy the notify library for Linux environment (notify.so) to one for Windows environment (notify.dll).

    Execute the following command: Type the command in one line.

    cp -p /usr/local/cybozu/mysql-5.0/lib/plugin/notify.so /usr/local/cybozu/mysql-5.0/lib/plugin/notify.dll

  2. Restart the MySQL service.

    /etc/init.d/cyde_5_0 restart

  3. Execute the following command to move the directory:

    cd /var/www/cgi-bin/cbgrn/

  4. Activate notifications that the MySQL service sends to the full-text search server.

    Execute the following command: Type the command in one line.

    ./grn.cgi -C -q code/command/fts/enable_udf_notifier.csp db_admin_password= (database administrator password)

    Confirm that "UDF notifier is available" appears.
    If you receive an error message, see "Appendix B Error Messages" in the full-text search server guide.

  5. Stop the MySQL service.

    /etc/init.d/cyde_5_0 stop

  6. Delete the notify library for Windows environment (notify.dll) that you created in step 1.

    rm /usr/local/cybozu/mysql-5.0/lib/plugin/notify.dll

  7. Start the MySQL service.

    /etc/init.d/cyde_5_0 start