Skip to main content
Version: 2.8

Troubleshooting database errors

This page describes database problems that you might encounter and steps how to troubleshoot them.

Database connection fails on installing D1

New D1 developers or administrators often have problems when performing the D1 installation the first time. In many cases the main problems are database related.

Check the database logs

Database issues are shown in D1 and Conversion Service logs.

  1. Review the adx_warn.log for database and jdbc related error messages.

If there are any errors, test the database connection by using one of the recommended database administration tools. See the Test the database connection section.

  1. Check the database permissions to make sure that with the same user as configured in D1 you can create a test table. See the Verify the user permissions.

Test the database connection

You can verify and test the database connection/setup by using database testing tools:

  • If your db connection testing tool can connect (from the machine that also runs D1), it should also work with D1.
  • If your db connection testing tool can connect, but only from another machine, it is probably a network/firewall issue.
  • If the connection with your db connection testing tool does not work at all, there is no need to test it with D1. It will not work there as well.
About database testing tools

You can use one of the following db administrator tools for testing the database connection:

  • Squirrel - is a Java based tool and it connects to the database via JDBC. This behavior is very similar to what D1 does. For information about this tool, see Squirrel SQL online documentation.

  • If you prefer not to work with Squirrel SQL, you can choose DBeaver tool.

For comparison and more information on Squirrel SQL and DBeaver, see Comparison of database tools.

Verify the user permissions

After you test the database connection, make sure the database user has the right permissions to create tables. Perform the following steps:

  1. Connect to the database server.

  2. Create a database.

  3. Run the following script:

    create table test (a int)
    insert into test values (1)
    select * from test
    drop table test

Database connection fails on the default repository

If you see this error in your health check report, perform the following steps:

  1. Verify that your database is up and running.

  2. Go to D1 installation directory and open the conf folder.

  3. Open the tribefire.properties file.

  4. Check that the database entries in the following properties are correct:

    ADX_DEFAULT_DB_TYPE
    ADX_DEFAULT_DB_NAME
    ADX_DEFAULT_DB_HOST
    ADX_DEFAULT_DB_PORT
    ADX_DEFAULT_DB_USER

If you find a wrong entry or a typo, fix it, save the file and restart D1. Database should now be available.