Duplicate key on write or update

634 views
Skip to first unread message

Xavier Humbert

unread,
Sep 23, 2022, 4:54:55 AM9/23/22
to rundeck-discuss
Hi,

Fresh install of 4.6.1, first launch :


> [2022-09-23T10:51:16,704] ERROR boot.SpringApplication - Application
> run failed
> liquibase.exception.LiquibaseException:
> liquibase.exception.MigrationFailedException: Migration failed for
> change set core/ConstraintsIndexesKeys.groovy::3.4.0-56::rundeckuser
> (generated):
>      Reason: liquibase.exception.DatabaseException: (conn=438) Can't
> create table `rdpr2`.`scheduled_execution_filter` (errno: 121
> "Duplicate key on write or update") [Failed SQL: (1005) ALTER TABLE
> rdpr2.scheduled_execution_filter ADD CONSTRAINT
> FK22545y15qs4iqod1ljyqsm1fi FOREIGN KEY (user_id) REFERENCES
> rdpr2.rduser (id)]

What happens ?

Cheers

Xavier

--
Xavier Humbert
CRT Supervision et Exploitation de Niveau 1
Rectorat de Nancy-Metz
03 83 86 27 39

rac...@rundeck.com

unread,
Sep 23, 2022, 8:52:17 AM9/23/22
to rundeck-discuss
Hi Xavier,

It's a fresh database too? Do you follow these steps to create the backend?

Regards.

Juan Carlos Huayane M.

unread,
Sep 23, 2022, 9:00:06 AM9/23/22
to rundeck...@googlegroups.com
Hi, the same thing happened to me, I solved it with the user rundeck.

--
You received this message because you are subscribed to the Google Groups "rundeck-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rundeck-discu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rundeck-discuss/c675b034-15c5-7e87-7201-bc2dc5b5e931%40ac-nancy-metz.fr.

Xavier Humbert

unread,
Sep 23, 2022, 10:46:49 AM9/23/22
to rundeck...@googlegroups.com, rac...@rundeck.com

Hi, Rainer,

Yes it's an empty database, with appropriate user/grants

You'll find attached the whole log when starting with an empty DB. Please note that the DB is a Galera cluster...

Thanks,

Cheers,

Xavier

Le 9/23/22 14:52, rac...@rundeck.com a écrit :
--
You received this message because you are subscribed to the Google Groups "rundeck-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rundeck-discu...@googlegroups.com.
BugGalera+Rundeck.txt

rac...@rundeck.com

unread,
Sep 23, 2022, 4:06:56 PM9/23/22
to rundeck-discuss
Hi Xavier,

Rundeck doesn't support that database environment (clustered backends), take a look at this. Could you test on a single database backend?

Regards.

Xavier Humbert

unread,
Sep 26, 2022, 6:10:36 AM9/26/22
to rundeck...@googlegroups.com, rac...@rundeck.com

Hi Rainer,

I demoted my Galera Cluster, ans connected to a signgle database. Same problem :

Sep 26, 2022 12:05:30 PM liquibase.lockservice
INFO: Successfully acquired change log lock
Sep 26, 2022 12:05:32 PM liquibase.changelog
INFO: Creating database history table with name: rdpr2.DATABASECHANGELOG
Sep 26, 2022 12:05:32 PM liquibase.changelog
INFO: Reading from rdpr2.DATABASECHANGELOG
Running Changeset: config-changelog.groovy::3.4.0-config-1::rundeckuser (generated)
Sep 26, 2022 12:05:32 PM liquibase.changelog
INFO: Table app_config created
Sep 26, 2022 12:05:32 PM liquibase.changelog
INFO: ChangeSet config-changelog.groovy::3.4.0-config-1::rundeckuser (generated) ran successfully in 39ms
Running Changeset: drop-clob-columns.groovy::1619546948390::rundeckuser (generated)
Sep 26, 2022 12:05:32 PM liquibase.changelog
INFO: Marking ChangeSet: drop-clob-columns.groovy::1619546948390::rundeckuser (generated) ran despite precondition failure due to onFail='MARK_RAN':
          config-changelog.groovy : Not precondition failed
Running Changeset: drop-clob-columns.groovy::1619546948392::rundeckuser (generated)
Sep 26, 2022 12:05:32 PM liquibase.changelog
INFO: Marking ChangeSet: drop-clob-columns.groovy::1619546948392::rundeckuser (generated) ran despite precondition failure due to onFail='MARK_RAN':
          config-changelog.groovy : Not precondition failed
Running Changeset: modify-appconfig.groovy::1619546948393::rundeckuser (generated)
Sep 26, 2022 12:05:32 PM liquibase.changelog
INFO: app_config.application datatype was changed to VARCHAR(1024)
Sep 26, 2022 12:05:32 PM liquibase.changelog
INFO: ChangeSet modify-appconfig.groovy::1619546948393::rundeckuser (generated) ran successfully in 35ms
Running Changeset: modify-appconfig.groovy::1619546948394::rundeckuser (generated)
Sep 26, 2022 12:05:32 PM liquibase.changelog
INFO: app_config.key_name datatype was changed to VARCHAR(1024)
Sep 26, 2022 12:05:32 PM liquibase.changelog
INFO: ChangeSet modify-appconfig.groovy::1619546948394::rundeckuser (generated) ran successfully in 24ms
Running Changeset: modify-appconfig.groovy::1619546948395::rundeckuser (generated)
Sep 26, 2022 12:05:32 PM liquibase.changelog
INFO: app_config.stratum datatype was changed to VARCHAR(1024)
Sep 26, 2022 12:05:32 PM liquibase.changelog
INFO: ChangeSet modify-appconfig.groovy::1619546948395::rundeckuser (generated) ran successfully in 26ms
Sep 26, 2022 12:05:32 PM liquibase.lockservice
INFO: Successfully released change log lock
[2022-09-26T12:05:37,135] INFO  rundeckapp.Application - The following 3 profiles are active: "composite", "da079c6a-8111-532b-ba42-a573d0a41bd1", "production"
Configuring Spring Security Core ...
... finished configuring Spring Security Core
[2022-09-26T12:06:09,566] WARN  config.NavigableMap - Accessing config key '[rundeck.security.oauth]' through dot notation is deprecated, and it will be removed in a future release. Use 'config.getProperty(key, targetClass)' instead.
Running Changeset: core/AuthToken.groovy::3.4.0-2::rundeckuser (generated)
Running Changeset: core/BaseReport.groovy::3.4.0-3::rundeckuser (generated)
Running Changeset: core/Execution.groovy::3.4.0-4::rundeckuser (generated)
Running Changeset: core/JobFileRecord.groovy::3.4.0-6::rundeckuser (generated)
Running Changeset: core/LogFileStorageRequest.groovy::3.4.0-8::rundeckuser (generated)
Running Changeset: core/NodeFilter.groovy::3.4.0-9::rundeckuser (generated)
Running Changeset: core/Notification.groovy::3.4.0-10::rundeckuser (generated)
Running Changeset: core/Orchestrator.groovy::3.4.0-11::rundeckuser (generated)
Running Changeset: core/PluginMeta.groovy::3.4.0-12::rundeckuser (generated)
Running Changeset: core/Project.groovy::3.4.0-13::rundeckuser (generated)
Running Changeset: core/ReferencedExecution.groovy::3.4.0-17::rundeckuser (generated)
Running Changeset: core/RDUSER.groovy::3.4.0-16::rundeckuser (generated)
Running Changeset: core/ReportFilter.groovy::3.4.0-18::rundeckuser (generated)
Running Changeset: core/ScheduledExecution.groovy::3.4.0-19::rundeckuser (generated)
Running Changeset: core/ScheduledExecution.groovy::3.4.0-20::rundeckuser (generated)
Running Changeset: core/ScheduledExecution.groovy::3.4.0-21::rundeckuser (generated)
Running Changeset: core/Storage.groovy::3.4.0-23::rundeckuser (generated)
Running Changeset: core/StoredEvent.groovy::3.4.0-24::rundeckuser (generated)
Running Changeset: core/Workflow.groovy::3.4.0-26::rundeckuser (generated)
Running Changeset: core/Workflow.groovy::3.4.0-27::rundeckuser (generated)
Running Changeset: core/Workflow.groovy::3.4.0-28::rundeckuser (generated)
Running Changeset: core/RDOPTION.groovy::3.4.0-14::rundeckuser (generated)
Running Changeset: core/RDOPTION.groovy::3.4.0-15::rundeckuser (generated)
Running Changeset: core/Webhook.groovy::3.4.0-25::rundeckuser (generated)
Running Changeset: core/Webhook.groovy::3.4.11-webhook-auth_config_json::Stephen Joyner
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-29::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-30::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-31::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-32::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-33::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-34::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-35::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-36::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-37::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-38::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-39::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-40::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-41::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-42::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-43::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-44::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-45::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-46::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-47::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-48::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-49::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-50::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-51::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-52::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-53::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-54::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-55::rundeckuser (generated)
Running Changeset: core/ConstraintsIndexesKeys.groovy::3.4.0-56::rundeckuser (generated)
[2022-09-26T12:06:33,641] ERROR boot.SpringApplication - Application run failed


liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set core/ConstraintsIndexesKeys.groovy::3.4.0-56::rundeckuser (generated):

     Reason: liquibase.exception.DatabaseException: (conn=150) Can't create table `rdpr2`.`scheduled_execution_filter` (errno: 121 "Duplicate key on write or update") [Failed SQL: (1005) ALTER TABLE rdpr2.scheduled_execution_filter ADD CONSTRAINT FK22545y15qs4iqod1ljyqsm1fi FOREIGN KEY (user_id) REFERENCES rdpr2.rduser (id)]


Le 9/23/22 22:06, rac...@rundeck.com a écrit :

Hi Xavier,

Rundeck doesn't support that database environment (clustered backends), take a look at this. Could you test on a single database backend?

Regards.
-- 
Xavier Humbert
CRT Supervision et Exploitation de Niveau 1
Rectorat de Nancy-Metz
03 83 86 27 39

rac...@rundeck.com

unread,
Sep 26, 2022, 8:26:04 AM9/26/22
to rundeck-discuss
Hi Xavier,

It seems a problem during a database upgrading process (similar to this), If you're upgrading from an old version make sure to follow this, and this if you're running from an empty database.

Regards.

Xavier Humbert

unread,
Sep 26, 2022, 8:37:51 AM9/26/22
to rundeck...@googlegroups.com, rac...@rundeck.com

Hi,

Alas, it was an empty database (drop database/create database)

Cheers

Xavier

Le 9/26/22 14:26, rac...@rundeck.com a écrit :
--
You received this message because you are subscribed to the Google Groups "rundeck-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rundeck-discu...@googlegroups.com.

rac...@rundeck.com

unread,
Sep 26, 2022, 11:45:37 AM9/26/22
to rundeck-discuss

Hi Xavier,

Could you post the rundeck-config.properties file content? (please hide any potentially sensitive information).

Regards.

​

Xavier Humbert

unread,
Sep 27, 2022, 2:19:24 AM9/27/22
to rundeck...@googlegroups.com, rac...@rundeck.com

Hi,

You'll find attached the rundeck-config.properties file

Thanks,

Regards,

Xavier

Le 9/26/22 17:45, rac...@rundeck.com a écrit :
rundeck-config.properties

Xavier Humbert

unread,
Sep 27, 2022, 4:42:15 AM9/27/22
to rundeck...@googlegroups.com, Juan Carlos Huayane M.

Hi, Juan Carlos

What do you mean precisely with user rundeck ?

Cheers

Xavier

Le 9/23/22 14:57, Juan Carlos Huayane M. a écrit :

rac...@rundeck.com

unread,
Oct 3, 2022, 10:44:11 AM10/3/22
to rundeck-discuss

Hi Xavier,

Test changing:

dataSource.dbCreate=none instead of dataSource.dbCreate=update.

or without that parameter.

Hope it helps.

​

Xavier Humbert

unread,
Oct 4, 2022, 2:47:05 AM10/4/22
to rundeck...@googlegroups.com, rac...@rundeck.com

Hi Rainer,

Yes ! It worked !

Many thanks

Cheers

Xavier

Le 10/3/22 16:44, rac...@rundeck.com a écrit :
Reply all
Reply to author
Forward
0 new messages