View Single Post
  #1  
Old 01-13-2024, 06:49 PM
Xamven
Fire Beetle
 
Join Date: Jul 2019
Posts: 12
Default 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
Reply With Quote