Stream: troubleshooting

Topic: ✔ [v6.9] can't deploy v6.9 due to SQL errors

view this post on Zulip Brian Cassidy (Feb 12 2026 at 13:09):

Hi All! I'm following the instructions for v6.9 and i've moved to the new payara, but when i try to deploy the war, i just get a series for SQL issues and "Command deploy failed." at the end:

PER01003: Deployment encountered SQL Exceptions:
    PER01000: Got SQLException executing statement "CREATE TABLE EXTERNALTOOLTYPE (ID  SERIAL NOT NULL, TYPE VARCHAR(255) NOT NULL, EXTERNALTOOL_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "externaltooltype" already exists
(etc)

view this post on Zulip Brian Cassidy (Feb 12 2026 at 13:26):

RESOLVED! I went back to the 6.7 instructions and saw:

Note: if you have any trouble deploying, stop Payara, remove the following directories, start Payara, and try to deploy again.

sudo service payara stop
sudo rm -rf $PAYARA/glassfish/domains/domain1/generated
sudo rm -rf $PAYARA/glassfish/domains/domain1/osgi-cache
sudo rm -rf $PAYARA/glassfish/domains/domain1/lib/databases
sudo service payara start

That worked.

view this post on Zulip Notification Bot (Feb 12 2026 at 13:26):

Brian Cassidy has marked this topic as resolved.

Last updated: Apr 03 2026 at 06:08 UTC