SQL error

[Xavier Humbert]

Hi,

I have a lot of errors like this in service.log :

[2024-04-16T12:23:11,926] WARN spi.SqlExceptionHelper - SQL Error: 1366,
SQLState: 22007
[2024-04-16T12:23:11,926] ERROR spi.SqlExceptionHelper - (conn=54493)
Incorrect string value: '\xEF\xBF\xBDre ...' for column
`rdhpopera`.`workflow_step`.`job_name` at row 1
caught exception
org.springframework.jdbc.BadSqlGrammarException: Hibernate operation:
could not execute statement; bad SQL grammar [n/a]; nested exception is
java.sql.SQLSyntaxErrorException: (conn=54493) Incorrect string value:
'\xEF\xBF\xBDre ...' for column `rdhpopera`.`workflow_step`.`job_name`
at row 1

What can cause this ?

This is a RPM fresh installation of 5.3.0 on RHEL9

Regards,

Xavier

--
Xavier Humbert
CRT Supervision et Exploitation de Niveau 1
Direction des Services d'Information du Grand Est
Rectorat de l'Académie de Nancy-Metz
Ministère de l'Éducation Nationale et de la Jeunesse
03 83 86 27 39

[rac...@rundeck.com]

Hi Xavier,

Which database (and version) are you using? is it a fresh database? It seems to be a special character/encoding issue.

Regards.

[Xavier Humbert]

Hi  Reiner,

I use MariaDB 10.5 and this is a fresh database.

FWIW, restarting Rundeck fixed the problem

Regards,

Xavier

--
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/d65d0fd7-6544-4ec3-a23e-1f7509bbda08n%40googlegroups.com.

[Xavier Humbert]

Hi,

It happened again, have to restart Rundeck
Any idea of the root cause ?

Regards,

Xavier

To view this discussion on the web visit https://groups.google.com/d/msgid/rundeck-discuss/b086085f-6900-4514-8333-3ccfa0287e3b%40ac-nancy-metz.fr.

[rac...@rundeck.com]

Hi Xavier,

Incorrect string value: '\xEF\xBF\xBDre ...' for column
`rdhpopera`.`workflow_step`.`job_name` at row 1
caught exception

Is Rundeck running with UTF8 charset? Also, is your database configured with a specific charset? Like this.

Regards.

[Xavier Humbert]

Hi Reiner,

It's the default encoding :

  ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

Should I run :
  ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

on every table ? Any risk to loose data ?


Regards,

Xavie


To view this discussion on the web visit https://groups.google.com/d/msgid/rundeck-discuss/cb13c8c4-3b9b-4e14-811b-e28d98ec7ee6n%40googlegroups.com.

[rac...@rundeck.com]

Hi Xavier,

It depends on the data stored / backend engine. After checking this, some considerations are present (see the answer comments).

The main advice is to test in a nonprod/dev environment and see the behavior.

Regards.