liquibase.exception.DatabaseException

ERROR: syntax error at or near "(" Position: 72 [Failed SQL: CREATE TABLE public."HT_abstract_coverage" (abstract_coverage_id BIGINT(2000000000, 10) NOT NULL, hib_sess_id CHAR(36))]


Solutions on the web371

Solution icon of stackoverflow
ERROR: syntax error at or near "(" Position: 72 [Failed SQL: CREATE TABLE public."HT_abstract_coverage" (abstract_coverage_id BIGINT(2000000000, 10) NOT NULL, hib_sess_id CHAR(36))]

Solution icon of web
via JIRA by Georgi Georgiev, 10 months ago
ERROR: syntax error at or near "0" Position: 385 [Failed SQL: CREATE TABLE reporting.report (id BIGSERIAL NOT

Solution icon of web
via JIRA by Georgi Georgiev, 1 year ago
ERROR: syntax error at or near "0" Position: 385 [Failed SQL: CREATE TABLE reporting.report (id BIGSERIAL NOT

Solution icon of stackoverflow
Error executing SQL CREATE TABLE `city` (`id` VARCHAR(16) NOT NULL, `version` BIGINT NOT NULL, `date_created` DATETIME NOT NULL, `last_updated` DATETIME NOT NULL, `name` VARCHAR(255) NOT NULL, CONSTRAINT `cityPK` PRIMARY KEY (`id`)) type=InnoDB: You

Solution icon of web
via JIRA by Ross Attrill, 1 year ago
Error executing SQL CREATE TABLE ACTION (ACTION_ID INTEGER CONSTRAINT ACTION_PK PRIMARY KEY AUTOINCREMENT AUTOINCREMENT NOT NULL, ACTION TEXT NOT NULL, ACTION_SOURCE_CODE TEXT NOT NULL): [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error)

Solution icon of web
via JIRA by Ross Attrill, 1 year ago
Error executing SQL CREATE TABLE ACTION (ACTION_ID INTEGER CONSTRAINT ACTION_PK PRIMARY KEY AUTOINCREMENT AUTOINCREMENT NOT NULL, ACTION TEXT NOT NULL, ACTION_SOURCE_CODE TEXT NOT NULL): [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error)

Solution icon of github
ERROR: syntax error at or near "$" 2017-02-14T13:13:21.51-0700 [APP/PROC/WEB/0]OUT Position: 382 [Failed SQL: CREATE TABLE public.jhi_user (id BIGSERIAL NOT NULL, login VARCHAR(50) NOT NULL, password_hash VARCHAR(60), first_name VARCHAR(50

Solution icon of googlegroups
via Google Groups by Unknown author, 2 months ago
Error executing SQL CREATE TAB LE car (id BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL, version BIGINT NOT NULL, engine VARCHAR(255) NOT NULL, make VARCHAR(255) NOT NULL, manufacturer VAR CHAR(255) NOT NULL, model_year VARCHAR(255) NOT NULL

Solution icon of github
via GitHub by adriens
, 9 months ago
ERROR: type "json" does not exist Position: 85 [Failed SQL: CREATE TABLE "public"."test_json" ("id" INT, "content" VARCHAR(100), "content_json" JSON)]

Solution icon of github
via GitHub by coderDem
, 1 year ago
Error executing SQL CREATE TABLE `aggregator_typ e` (`id` BIGINT AUTO_INCREMENT NOT NULL, `version` BIGINT NOT NULL, `measurand_group` VARCHAR(255) N OT NULL, `name` VARCHAR(255) NOT NULL, CONSTRAINT `aggregator_tyPK` PRIMARY KEY (`id`)): Table

Stack trace

  • liquibase.exception.DatabaseException: ERROR: syntax error at or near "(" Position: 72 [Failed SQL: CREATE TABLE public."HT_abstract_coverage" (abstract_coverage_id BIGINT(2000000000, 10) NOT NULL, hib_sess_id CHAR(36))] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1628)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
26 times, 1 year ago