search

ISISComputingGroup / IBEX

Top level repository for IBEX stories
5 stars 2 forks source link

mysql: error creating initial database tables #8561

Open FreddieAkeroyd opened 1 month ago

FreddieAkeroyd commented 1 month ago

During the upgrade to mysql 8.4 (running update_mysql.bat in ibex_utils/installation_and_upgrade) I saw the following error regarding the DELIMITER command when it finally ran EPICS\SystemSetup\config_mysql.bat to populate database tables

image

Acceptance criteria

Notes

before installing mysql 8.4 see if running config_mysql.bat errors on your existing setup. The delimiter command exists in both 8.0 and 8.4 but is a client side rather than SQL specific command, it looks like it is being passed over to the server when it should not be. This may be because the truncate_event.sql is being run by a source command and so skips some of the features (so we need to set delimiter, source, reset delimiter), but that is a pure guess. It may be when loading sql files as we do the delimiter has to be set a different way such as on command line

planning 106:00 2024/10/31

Chsudeepta commented 3 days ago

PR to fix the issue: https://github.com/ISISComputingGroup/EPICS-IocLogServer/pull/36