search

jchonig / docker-mmonit

A container to run M/Monit
Creative Commons Zero v1.0 Universal
10 stars 4 forks source link

4.2.2 is not starting ... error.log is full with "Unsupported database schema version: 22" #22

Closed roe1974 closed 4 months ago

roe1974 commented 4 months ago

Coming from 4.0.2 ... waiting here for about 45min and Mmonit is not starting ... the logs are full with:

2024-05-09 06:42:09,stdout,AssertException: Unsupported database schema version: 22 -- please run database upgrade script(s) to update M/Monit to version 4.2.2 (database schema version 23)

2024-05-09 06:42:09,stdout,Starting mmonit 4.2.2

2024-05-09 06:42:08,stdout,AssertException: Unsupported database schema version: 22 -- please run database upgrade script(s) to update M/Monit to version 4.2.2 (database schema version 23)

2024-05-09 06:42:07,stdout,Starting mmonit 4.2.2

2024-05-09 06:42:06,stdout,AssertException: Unsupported database schema version: 22 -- please run database upgrade script(s) to update M/Monit to version 4.2.2 (database schema version 23)

2024-05-09 06:42:06,stdout,Starting mmonit 4.2.2

2024-05-09 06:42:05,stdout,AssertException: Unsupported database schema version: 22 -- please run database upgrade script(s) to update M/Monit to version 4.2.2 (database schema version 23)

2024-05-09 06:42:05,stdout,Starting mmonit 4.2.2

2024-05-09 06:42:05,stdout,AssertException: Unsupported database schema version: 22 -- please run database upgrade script(s) to update M/Monit to version 4.2.2 (database schema version 23)

2024-05-09 06:42:04,stdout,Starting mmonit 4.2.2

2024-05-09 06:42:03,stdout,AssertException: Unsupported database schema version: 22 -- please run database upgrade script(s) to update M/Monit to version 4.2.2 (database schema version 23)

should i wait longer ?? br, Richard

See the full log here: Mmonit (3).csv

roe1974 commented 4 months ago

Her the Feedback from Mmonit Support:

These errors come from mmonit start attempt, when it detects that the database was not upgraded:

2024-05-09 06:42:09,stdout,AssertException: Unsupported database schema version: 22 -- please run database upgrade script(s) to update M/Monit to version 4.2.2 (database schema version 23)

2024-05-09 06:42:09,stdout,Starting mmonit 4.2.2

Normally it is necessary to run the upgrade program before starting the new M/Monit version (https://mmonit.com/wiki/MMonit/Release4-2-2#upgrade), for example:

/usr/local/mmonit-4.2.2/upgrade/upgrade -p /usr/local/mmonit-4.2.1

I'm not sure however how that 3rd party docker container deals with the upgrade.

roe1974 commented 4 months ago

migration worked over 4.2.1 so upgrade 4.0.2 -> 4.2.1 -> 4.2.2 and this version is as fast as 4.0.2, everything good now 😊

jchonig commented 4 months ago

A quick check of the commit logs does not show any changes in my upgrade scripts since 4.0.2.

Do you have the full log of the run so I can make sure this does not happen in the future?

Thanks.

Jeff

roe1974 commented 4 months ago

It has nothing to do with your script. i have mmonit 4.0.2 and 4.2.2 installed on my MAC and wanted to migrate the DB there, but it didn't work either. the following error occurred:

Aggregating data from statistics_aggregate_1m to statistics_aggregate_2m. This can take a while. Please be patient

Upgrade failed: SQLException: FOREIGN KEY constraint failed (src/db/Connection.c Connection_execute 316)

I also had to migrate via this path on the MAC 4.0.2 -> 4.2.1 -> 4.2.2. When this worked there, I realised that I also had to go via 4.2.1 on the Syn (Docker). That worked there too :-). This has something to do with my DB ;-) (Feedback from Mmonit Support) lg Richard