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.
- 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.
- 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.
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:
Connect to the database server.
Create a database.
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:
Verify that your database is up and running.
Go to D1 installation directory and open the
conf
folder.Open the
tribefire.properties
file.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.