ERROR 1050 (42S01) at line 29 in file: 'mysql_gen/AUDIT_TRAIL.sql': Table 'AUDIT_TRAIL' already exists

12 views
Skip to first unread message

salonimi...@gmail.com

unread,
Aug 10, 2021, 1:54:13 AMAug 10
to schedulix

Hi Ronald,

We are installing schedulix 2.7 in our new environment where we are creating schedulix database and after running below command -

mysql --user=schedulix --password='Schedulix@123' --database=schedulixdb --execute="source mysql/install.sql"

we are getting the below error-

mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1050 (42S01) at line 29 in file: 'mysql_gen/AUDIT_TRAIL.sql': Table 'AUDIT_TRAIL' already exists

Could you please help.

Thank you,
Saloni

Ronald Jeninga

unread,
Aug 10, 2021, 2:18:32 AMAug 10
to schedulix
Hi Saloni,

as it seems, the schema is already present in your database.
If it's empty, you can use it, if not, you'll have to drop and recreate it.

If we've made a mistake in our installation scripts that causes the CREATE AUDIT_TRAIL statement to be executed twice, well, that's fine as well.
We need that table, but we don't need two of them ;-) In that case, just ignore the error.

HTH

Best regards,

Ronald

salonimi...@gmail.com

unread,
Aug 10, 2021, 2:33:57 AMAug 10
to schedulix
Hi Ronald,

Before the above error we have got the below error-

[root@ora-sitbtch sql]# mysql --user=schedulix --password=Schedulix@123 --database=schedulixdb --execute="source mysql/install.sql"

mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1064 (42000) at line 29 in file: 'mysql_gen/GROUPS.sql': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUPS (
    `ID`                           decimal(20) NOT NULL
    , `NAME`   ' at line 1


Could you please help on this?

Thank you,
Saloni
Reply all
Reply to author
Forward
0 new messages