koel / docker

A minimal docker image for the koel music streaming server.
https://hub.docker.com/r/phanan/koel/
MIT License
166 stars 54 forks source link

Koel Sync error - SQLSTATE[HY000]: General error: 1 no such table: info #143

Open ch1nch4ch4 opened 2 years ago

ch1nch4ch4 commented 2 years ago

I am trying to sync media via the command link using php artisan koel:sync and I keep getting the below error. Although I get the below error, music does appear after 5-10 mins in Koel.


  at vendor/teamtnt/tntsearch/src/TNTSearch.php:399
    395▕ 
    396▕     public function getValueFromInfoTable($value)
    397▕     {
    398▕         $query = "SELECT * FROM info WHERE key = '$value'";
  ➜ 399▕         $docs  = $this->index->query($query);
    400▕ 
    401▕         if ($ret = $docs->fetch(PDO::FETCH_ASSOC)) {
    402▕             return $ret['value'];
    403▕         }

  +20 vendor frames 
  21  app/Services/FileSynchronizer.php:198
      Illuminate\Database\Eloquent\Model::__callStatic()

 22  app/Services/MediaSyncService.php:95
      App\Services\FileSynchronizer::sync()

To reproduce Steps to reproduce the behavior:

  1. docker exec --user www-data -it koel bash
  2. php artisan koel:sync

Expected behavior Sync Music to Koel Server without error

Screenshots Screenshot

Environment

DOCKER Docker version 19.03.13, build 4484c46d9d

Ansible deploys the containers - main config for each below

KOEL

docker_container:
    name: koel
    image: "phanan/koel:latest"
    pull: yes
    published_ports:
      - "127.0.0.1:800:80"
    env:
      BACKUP: "no"
      FORCE_HTTPS : "true"
      DB_CONNECTION: "mysql"
      DB_HOST : "mysql"
      DB_USERNAME : "koel"
      DB_PASSWORD : "samplePW"
      DB_DATABASE : "koel"
      PUID: "{{ uid }}"
      PGID: "{{ gid }}"
      UMASK: 002
      VIRTUAL_HOST: "koel.{{ user.domain }}"
      VIRTUAL_PORT: 80
      LETSENCRYPT_HOST: "koel.{{ user.domain }}"
      LETSENCRYPT_EMAIL: "{{ user.email }}"
      TZ: "{{ tz }}"
    volumes: "{{ default_volumes }}"
    labels:
     "com.github.cloudbox.cloudbox_managed": "true"
   networks:
      - name: koelnetwork
        aliases:
        - koel

MYSQL

docker_container:
    name: mysql
    image: "mysql"
    pull: yes
    env:
      TZ: "{{ tz }}"
      PUID: "{{ uid }}"
      PGID: "{{ gid }}"
      LOG_LEVEL: DEBUG
      MYSQL_DATABASE : "koel"
      MYSQL_USER : "koel"
      MYSQL_PASSWORD : "samplePW"
      MYSQL_ROOT_PASSWORD: "samplePW"
    volumes:
      - /opt/mysql/data:/var/lib/mysql
    labels:
      "com.github.cloudbox.cloudbox_managed": "true"
    networks:
      - name: koelnetwork
        aliases:
          - mysql

RClone Mount - Config

[Unit]
Description=Rclone VFS dibdab-t-en-01 Mount
After=network-online.target

[Service]
User=serveruser
Group=serveruser
Type=notify
ExecStartPre=/bin/sleep 10
ExecStart=/usr/bin/rclone mount \
  --user-agent='Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36' \
  --config=/home/serveruser/.config/rclone/rclone.conf \
  --allow-other \
  --allow-non-empty \
  --drive-skip-gdocs \
  --vfs-read-chunk-size=64M \
  --vfs-read-chunk-size-limit=2048M \
  --buffer-size=64M \
  --poll-interval=1m \
  --dir-cache-time=168h \
  --timeout=10m \
  --drive-chunk-size=64M \
  --vfs-cache-mode=writes \
  --umask=002 \
  --syslog \
  --use-mmap \
  -v \
  koel-music: /mnt/remote/koel
ExecStop=/bin/fusermount -uz /mnt/remote/koel
Restart=on-abort
RestartSec=5
StartLimitInterval=60s
StartLimitBurst=3

[Install]
WantedBy=default.target

Additional context Add any other context about the problem here.