Latest linux + docker images missing SQL files on fresh install, fatal error.
Over the last few days I've done probably a dozen installs across windows, linux + docker, and just wondering if there's a suggested 'stable' release I should be targeting to install?
I was attempting to setup an AWS based instance (ubuntu 20.04) with massive overkill specs to find out if my slowness with 12+ toons was related to my local clients or the server, and ran into problems with both a standard 'basic linux' install, and the docker install (logs below) - both complain around missing .SQL files and this error, and it borks out: orld | QueryErr | QueryDatabaseMulti [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ADD COLUMN `seconds_before_idle` int(11) UNSIGNED NOT NULL DEFAULT 60 AFTER `...' at line 3] (1064) query [ALTER TABLE `zone`ADD COLUMN `idle_when_empty` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 AFTER `min_lava_damage`ADD COLUMN `seconds_before_idle` int(11) UNSIGNED NOT NULL DEFAULT 60 AFTER `idle_when_empty`] Am I running into the case of using the 'bleeding edge' .. is there a way to pull down the earlier 'stable' versions? I'm perfectly happy with an older version, just wanting something as stable as possible... (and the install last week was stable with docker, but this week isn't). Any suggestions appreciated. [Zip] Extracting [/tmp/eqemu-server-linux-x64.zip] [Zip] Extracted (10) files in [/tmp/eqemu-server-linux-x64.zip] to [/home/eqemu/server/bin]! Starting server > Bootstrapping PEQ Database curl http://db.projecteq.net/api/v1/dump/latest -o /tmp/db.zip % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 30.2M 0 30.2M 0 0 4240k 0 --:--:-- 0:00:07 --:--:-- 5604k unzip -o /tmp/db.zip -d /tmp/db/ Archive: /tmp/db.zip inflating: /tmp/db/peq-dump/create_all_tables.sql inflating: /tmp/db/peq-dump/create_tables_content.sql inflating: /tmp/db/peq-dump/create_tables_login.sql inflating: /tmp/db/peq-dump/create_tables_player.sql inflating: /tmp/db/peq-dump/create_tables_queryserv.sql inflating: /tmp/db/peq-dump/create_tables_state.sql inflating: /tmp/db/peq-dump/create_tables_system.sql inflating: /tmp/db/peq-dump/drop_all_tables.sql inflating: /tmp/db/peq-dump/drop_tables_content.sql inflating: /tmp/db/peq-dump/drop_tables_login.sql inflating: /tmp/db/peq-dump/drop_tables_player.sql inflating: /tmp/db/peq-dump/drop_tables_queryserv.sql inflating: /tmp/db/peq-dump/drop_tables_state.sql inflating: /tmp/db/peq-dump/drop_tables_system.sql cd /tmp/db/peq-dump/ && mysql -ueqemu \ -pkwMVsuWS5172zDiBosbVwX2gZucik51 \ -h mariadb \ peq \ < ./create_all_tables.sql rm -rf /tmp/db/ cd ~/server && ./bin/world database:updates World | Info | CheckVersionsUpToDate ---------------------------------------------------------------------- World | Info | CheckVersionsUpToDate Server | database [9249] binary [9252] checking updates World | Info | CheckVersionsUpToDate Config | [server.auto_database_updates] [true] World | Info | CheckVersionsUpToDate ---------------------------------------------------------------------- World | Info | UpdateManifest [9250] [missing] | [2023_01_06_task_activities_list_group.sql] World | Info | UpdateManifest [9251] [ok] | [2023_01_12_instance_list_notes.sql] World | Info | UpdateManifest [9252] [missing] | [2024_01_07_zone_idle_when_empty.sql] World | Info | UpdateManifest ---------------------------------------------------------------------- World | Info | UpdateManifest Automatically backing up database before applying updates World | Info | UpdateManifest ---------------------------------------------------------------------- World | Info | DatabaseDump MySQL installed [mysql Ver 15.1 Distrib 10.11.4-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper] World | Info | DatabaseDump Database [peq] Host [mariadb] Username [eqemu] World | Info | DatabaseDump Backing up database [mysqldump --defaults-extra-file=login.my.cnf peq --allow-keywords --extended-insert --max-allowed-packet=1G --net-buffer-length=32704 --skip-lock-tables > backups/peq-2024-01-13.sql] World | Info | DatabaseDump This can take a few minutes depending on the size of your database World | Info | DatabaseDump LOADING... PLEASE WAIT... World | Info | DatabaseDump Database dump created at [backups/peq-2024-01-13.sql] World | Info | DatabaseDump Compression requested. Compressing dump [backups/peq-2024-01-13.sql] World | Info | DatabaseDump Compressed dump created at [backups/peq-2024-01-13.tar.gz] World | Info | UpdateManifest ---------------------------------------------------------------------- World | Info | UpdateManifest Running database migrations. Please wait... World | Info | UpdateManifest ---------------------------------------------------------------------- World | Info | UpdateManifest [9250] [2023_01_06_task_activities_list_group.sql] [ok] World | QueryErr | QueryDatabaseMulti [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ADD COLUMN `seconds_before_idle` int(11) UNSIGNED NOT NULL DEFAULT 60 AFTER `...' at line 3] (1064) query [ALTER TABLE `zone`ADD COLUMN `idle_when_empty` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 AFTER `min_lava_damage`ADD COLUMN `seconds_before_idle` int(11) UNSIGNED NOT NULL DEFAULT 60 AFTER `idle_when_empty`] World | Error | UpdateManifest (#1064) [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ADD COLUMN `seconds_before_idle` int(11) UNSIGNED NOT NULL DEFAULT 60 AFTER `...' at line 3] World | Info | UpdateManifest Required database update failed. This could be a problem World | Info | UpdateManifest Would you like to skip this update? [y/n] (Timeout 60s) World | Info | UpdateManifest [9252] [2024_01_07_zone_idle_when_empty.sql] [error] World | Error | UpdateManifest Fatal | Database migration [2024_01_07_zone_idle_when_empty.sql] failed to run World | Error | UpdateManifest Fatal | Shutting down make[1]: *** [Makefile:114: init-peq-database] Error 1 make: *** [Makefile:66: install] Error 2 make: *** [Makefile:101: install] Error 2 |
All times are GMT -4. The time now is 08:42 AM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.