Can't sign up

[jsaberon]

Can't sign up

[Almoullim]

@jdorfman
I just had the same issue. Seems like as of MariaDB 10.3+ this issue happens when you bind a volume to /var/lib/mysql on Windows using Hyper-V. For now, the only solutions seem to use MariaDB 10.2 or older.

Clone this repo https://github.com/appwrite/docker-mariadb.git in your appwrite-ce like so

git clone https://github.com/appwrite/docker-mariadb.git mariadb

go into the cloned repo directory and change the Dockerfile contents to this
FROM mariadb:10.4 to FROM mariadb:10.2

FROM mariadb:10.2

LABEL maintainer="[email protected]"

# Add appwrite schema and tables
ADD ./all.sql /docker-entrypoint-initdb.d/all.sql

RUN chown -R mysql:mysql /docker-entrypoint-initdb.d/

in your docker-compose.yaml file:
change this:

mariadb:
  image: appwrite/mariadb:1.0.0 
  restart: unless-stopped
  environment:
    - MYSQL_ROOT_PASSWORD=password
  volumes:
    - ./storage/db:/var/lib/mysql:rw
  ports:
    - 3306:3306/tcp

to this:

mariadb:
  build: ./mariadb
  restart: unless-stopped
  environment:
    - MYSQL_ROOT_PASSWORD=password
  volumes:
    - ./storage/db:/var/lib/mysql:rw
  ports:
    - 3306:3306/tcp
  command: mysqld --innodb-flush-method=fsync

@eldadfux maybe you could include all of this untill the issue is fixed on windows?

[eldadfux]

Hi this seems like your Appwrite instance is having trouble connecting with the MariaDB container.

To try and debug what failed, more information is needed:

1. Whats is your docker version?

2. Check your containers status using 'docker ps' command and paste it here.

3. If any of your Appwrite containers is down please paste the container log in here.

4. As this seems a database issue, please login into your mariadb container and check if you have the 'appwrite' database set up with all Appwrite tables. You can do so using the docker command: 'docker exec -it [container-id] bash', inside the container use: 'mysql -u root -p' and type your container password (default is: 'password'). In the mysql client check the output of: 'USE appwrite; SHOW FULL TABLES'.

[jsaberon]

Docker Version: Docker version 19.03.1, build 74b1e89

docker ps

CONTAINER ID        IMAGE                    COMMAND                  CREATED             STATUS                          PORTS                NAMES
deb86f443cf3        appwrite/appwrite        "/bin/bash /entrypoi…"   6 hours ago         Up 13 minutes                   0.0.0.0:80->80/tcp   appwrite-ce_appwrite_1
aa3146af56d7        appwrite/clamav:1.0.4    "/bin/bash /entrypoi…"   6 hours ago         Up 13 minutes (healthy)         3310/tcp             appwrite-ce_clamav_1
77f8e22f604c        appwrite/mariadb:1.0.0   "docker-entrypoint.s…"   6 hours ago         Restarting (1) 19 seconds ago                        appwrite-ce_mariadb_1
a7ef4b6ad927        redis:5.0                "docker-entrypoint.s…"   29 hours ago        Up 13 minutes                   6379/tcp             appwrite-ce_redis_1

I'm using Windows and I cant read the logs. because it is encrypted.

Please comment if you need more information

[eldadfux]

From the logs you posted its seems your mariadb container has trouble starting ('Restarting (1) 19 seconds ago').

The only way to debug this is to get the mariadb logs, don't really know why you are having trouble to get them. Do you have any error message?

A way to try and bypass the problem is to delete your storage directory, your appwrite/mariadb container and image and run the 'docker-compose up -d' command in the appwrite-ce working directory.

Another issue is that in your logs you posted only 4 containers, please make sure all the containers listed in the docker-compose.yml file are up and running.

[jsaberon]

I change my maria db container port 3306:3306 to 3306:5000 and I encountered the same error

This is the new docker ps:

CONTAINER ID        IMAGE                     COMMAND                  CREATED             STATUS                   PORTS                                        NAMES
5d02775f5863        appwrite/appwrite         "/bin/bash /entrypoi…"   26 seconds ago      Up 23 seconds            0.0.0.0:80->80/tcp                           appwrite-ce_appwrite_1
1147ca8f2f61        appwrite/mariadb:1.0.0    "docker-entrypoint.s…"   38 seconds ago      Up Less than a second    3306/tcp, 0.0.0.0:3306->5000/tcp             appwrite-ce_mariadb_1
89aba917429c        appwrite/clamav:1.0.4     "/bin/bash /entrypoi…"   2 minutes ago       Up 2 minutes (healthy)   3310/tcp                                     appwrite-ce_clamav_1
2ee66d3c432b        influxdb:1.6              "/entrypoint.sh infl…"   2 minutes ago       Up 2 minutes             0.0.0.0:8086->8086/tcp                       appwrite-ce_influxdb_1
7c4125248f91        appwrite/telegraf:1.0.0   "/entrypoint.sh tele…"   2 days ago          Up 2 minutes             8092/udp, 8094/tcp, 0.0.0.0:8125->8125/udp   appwrite-ce_telegraf_1
a7ef4b6ad927        redis:5.0                 "docker-entrypoint.s…"   2 days ago          Up 4 minutes             6379/tcp                                     appwrite-ce_redis_1
174b7bb663cc        appwrite/smtp:1.0.0       "/bin/entrypoint.sh …"   2 days ago          Up 2 minutes             0.0.0.0:25->25/tcp                           appwrite-ce_smtp_1

[eldadfux]

When changing mariadb port number make sure to let the 'appwrite' container know about the new port with the '_APP_DB_PORT' env variable.

it should look like this:

version: "3"

services:
    appwrite:
        image: appwrite/appwrite
        restart: unless-stopped
        volumes:
        - ./storage:/storage:rw
        ports:
        - "80:80"
        depends_on:
        - mariadb
        - redis
        - smtp
        - clamav
        - influxdb
        - telegraf
        environment:
        - _APP_ENV=development
        - _APP_OPENSSL_KEY_V1=your-secret-key
        - _APP_REDIS_HOST=redis
        - _APP_REDIS_PORT=6379
        - _APP_DB_HOST=mariadb
        - _APP_DB_PORT=5000
        - _APP_DB_SCHEMA=appwrite
        - _APP_DB_USER=root
        - _APP_DB_PASS=password
        - _APP_INFLUXDB_HOST=influxdb
        - _APP_INFLUXDB_PORT=8086
        - _APP_STATSD_HOST=telegraf
        - _APP_STATSD_PORT=8125

    mariadb:
        image: appwrite/mariadb:1.0.0
        restart: unless-stopped
        environment:
        - MYSQL_ROOT_PASSWORD=password
        volumes:
        - ./storage/db:/var/lib/mysql:rw
        ports:
        - 5000:3306/tcp

    smtp:
        image: appwrite/smtp:1.0.0
        environment:
        - MAILNAME=appwrite
        - RELAY_NETWORKS=:192.168.0.0/24:10.0.0.0/16
        ports:
        - "25:25"

    clamav:
        image: appwrite/clamav:1.0.4
        restart: unless-stopped
        volumes:
        - ./storage:/storage:rw
        
    redis:
        image: redis:5.0
        restart: unless-stopped

    influxdb:
        image: influxdb:1.6
        volumes:
        - ./storage/influxdb:/var/lib/influxdb
        ports:
        - "8086:8086"

    telegraf:
        image: appwrite/telegraf:1.0.0
        ports:
        - "8125:8125/udp"

Another thing to make sure is that the port was really the problem. Did you get error from docker indicating the port is already taken? As I wrote before, the best way to debug a container that keeps restarting is to check for its logs like this:

docker logs [mariadb-container-id]

[jsaberon]

I change the yml file to the configuration above and run docker-compose up -d and the maria db still restarting

docker ps

CONTAINER ID        IMAGE                     COMMAND                  CREATED             STATUS                          PORTS                                        NAMES
fae86ac3e0e4        appwrite/appwrite         "/bin/bash /entrypoi…"   2 minutes ago       Up 2 minutes                    0.0.0.0:80->80/tcp                           appwrite-ce_appwrite_1
57dca687126b        appwrite/mariadb:1.0.0    "docker-entrypoint.s…"   2 minutes ago       Restarting (1) 11 seconds ago                                                appwrite-ce_mariadb_1
89aba917429c        appwrite/clamav:1.0.4     "/bin/bash /entrypoi…"   2 hours ago         Up 3 minutes (healthy)          3310/tcp                                     appwrite-ce_clamav_1
2ee66d3c432b        influxdb:1.6              "/entrypoint.sh infl…"   2 hours ago         Up 2 minutes                    0.0.0.0:8086->8086/tcp                       appwrite-ce_influxdb_1
7c4125248f91        appwrite/telegraf:1.0.0   "/entrypoint.sh tele…"   2 days ago          Up 2 minutes                    8092/udp, 8094/tcp, 0.0.0.0:8125->8125/udp   appwrite-ce_telegraf_1
a7ef4b6ad927        redis:5.0                 "docker-entrypoint.s…"   2 days ago          Up 3 minutes                    6379/tcp                                     appwrite-ce_redis_1
174b7bb663cc        appwrite/smtp:1.0.0       "/bin/entrypoint.sh …"   2 days ago          Up 2 minutes                    0.0.0.0:25->25/tcp                           appwrite-ce_smtp_1

I try to run docker logs [mariadb-container-id] but the result is Error: No such container: [mariadb-container-id]

[eldadfux]

you should change the [mariadb-container-id] with your container id, from looking at your logs this:
57dca687126b

[jsaberon]

this is the logs from maria db

2019-09-05  5:02:26 0 [Note] mysqld (mysqld 10.4.4-MariaDB-1:10.4.4+maria~bionic) starting as process 1 ...
2019-09-05  5:02:26 0 [Note] InnoDB: Using Linux native AIO
2019-09-05  5:02:26 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-09-05  5:02:26 0 [Note] InnoDB: Uses event mutexes
2019-09-05  5:02:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-05  5:02:26 0 [Note] InnoDB: Number of pools: 1
2019-09-05  5:02:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-05  5:02:26 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2019-09-05  5:02:26 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2019-09-05  5:02:26 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-05  5:02:26 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-09-05  5:02:26 0 [ERROR] InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 0 pages than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
2019-09-05  5:02:26 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-09-05  5:02:26 0 [Note] InnoDB: Starting shutdown...
2019-09-05  5:02:27 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-05  5:02:27 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-05  5:02:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-05  5:02:27 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-09-05  5:02:27 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-05  5:02:27 0 [ERROR] Aborting
2019-09-05  5:02:30 0 [Note] mysqld (mysqld 10.4.4-MariaDB-1:10.4.4+maria~bionic) starting as process 1 ...
2019-09-05  5:02:30 0 [Note] InnoDB: Using Linux native AIO
2019-09-05  5:02:30 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-09-05  5:02:30 0 [Note] InnoDB: Uses event mutexes
2019-09-05  5:02:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-05  5:02:30 0 [Note] InnoDB: Number of pools: 1
2019-09-05  5:02:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-05  5:02:30 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2019-09-05  5:02:30 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2019-09-05  5:02:30 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-05  5:02:30 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-09-05  5:02:30 0 [ERROR] InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 0 pages than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
2019-09-05  5:02:30 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-09-05  5:02:31 0 [Note] InnoDB: Starting shutdown...
2019-09-05  5:02:31 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-05  5:02:31 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-05  5:02:31 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-05  5:02:31 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-09-05  5:02:31 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-05  5:02:31 0 [ERROR] Aborting
2019-09-05  5:02:34 0 [Note] mysqld (mysqld 10.4.4-MariaDB-1:10.4.4+maria~bionic) starting as process 1 ...
2019-09-05  5:02:34 0 [Note] InnoDB: Using Linux native AIO
2019-09-05  5:02:34 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-09-05  5:02:34 0 [Note] InnoDB: Uses event mutexes
2019-09-05  5:02:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-05  5:02:34 0 [Note] InnoDB: Number of pools: 1
2019-09-05  5:02:34 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-05  5:02:34 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2019-09-05  5:02:34 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2019-09-05  5:02:34 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-05  5:02:34 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-09-05  5:02:34 0 [ERROR] InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 0 pages than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
2019-09-05  5:02:34 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-09-05  5:02:35 0 [Note] InnoDB: Starting shutdown...
2019-09-05  5:02:35 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-05  5:02:35 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-05  5:02:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-05  5:02:35 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-09-05  5:02:35 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-05  5:02:35 0 [ERROR] Aborting
2019-09-05  5:02:39 0 [Note] mysqld (mysqld 10.4.4-MariaDB-1:10.4.4+maria~bionic) starting as process 1 ...
2019-09-05  5:02:39 0 [Note] InnoDB: Using Linux native AIO
2019-09-05  5:02:39 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-09-05  5:02:39 0 [Note] InnoDB: Uses event mutexes
2019-09-05  5:02:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-05  5:02:39 0 [Note] InnoDB: Number of pools: 1
2019-09-05  5:02:39 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-05  5:02:39 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2019-09-05  5:02:39 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2019-09-05  5:02:39 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-05  5:02:39 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-09-05  5:02:39 0 [ERROR] InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 0 pages than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
2019-09-05  5:02:39 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-09-05  5:02:40 0 [Note] InnoDB: Starting shutdown...
2019-09-05  5:02:40 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-05  5:02:40 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-05  5:02:40 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-05  5:02:40 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-09-05  5:02:40 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-05  5:02:40 0 [ERROR] Aborting
2019-09-05  5:02:43 0 [Note] mysqld (mysqld 10.4.4-MariaDB-1:10.4.4+maria~bionic) starting as process 1 ...
2019-09-05  5:02:43 0 [Note] InnoDB: Using Linux native AIO
2019-09-05  5:02:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-09-05  5:02:43 0 [Note] InnoDB: Uses event mutexes
2019-09-05  5:02:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-05  5:02:43 0 [Note] InnoDB: Number of pools: 1
2019-09-05  5:02:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-05  5:02:43 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2019-09-05  5:02:43 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2019-09-05  5:02:43 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-05  5:02:43 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-09-05  5:02:43 0 [ERROR] InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 0 pages than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
2019-09-05  5:02:43 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-09-05  5:02:43 0 [Note] InnoDB: Starting shutdown...
2019-09-05  5:02:43 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-05  5:02:43 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-05  5:02:43 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-05  5:02:43 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-09-05  5:02:43 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-05  5:02:43 0 [ERROR] Aborting
2019-09-05  5:02:47 0 [Note] mysqld (mysqld 10.4.4-MariaDB-1:10.4.4+maria~bionic) starting as process 1 ...
2019-09-05  5:02:47 0 [Note] InnoDB: Using Linux native AIO
2019-09-05  5:02:47 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-09-05  5:02:47 0 [Note] InnoDB: Uses event mutexes
2019-09-05  5:02:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-05  5:02:47 0 [Note] InnoDB: Number of pools: 1
2019-09-05  5:02:47 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-05  5:02:47 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2019-09-05  5:02:47 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2019-09-05  5:02:47 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-05  5:02:47 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-09-05  5:02:47 0 [ERROR] InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 0 pages than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
2019-09-05  5:02:47 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-09-05  5:02:48 0 [Note] InnoDB: Starting shutdown...
2019-09-05  5:02:48 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-05  5:02:48 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-05  5:02:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-05  5:02:48 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-09-05  5:02:48 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-05  5:02:48 0 [ERROR] Aborting
2019-09-05  5:02:53 0 [Note] mysqld (mysqld 10.4.4-MariaDB-1:10.4.4+maria~bionic) starting as process 1 ...
2019-09-05  5:02:53 0 [Note] InnoDB: Using Linux native AIO
2019-09-05  5:02:53 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-09-05  5:02:53 0 [Note] InnoDB: Uses event mutexes
2019-09-05  5:02:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-05  5:02:53 0 [Note] InnoDB: Number of pools: 1
2019-09-05  5:02:53 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-05  5:02:53 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2019-09-05  5:02:53 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2019-09-05  5:02:53 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-05  5:02:53 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-09-05  5:02:53 0 [ERROR] InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 0 pages than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
2019-09-05  5:02:53 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-09-05  5:02:53 0 [Note] InnoDB: Starting shutdown...
2019-09-05  5:02:53 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-05  5:02:53 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-05  5:02:53 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-05  5:02:53 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-09-05  5:02:53 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-05  5:02:53 0 [ERROR] Aborting
2019-09-05  5:03:02 0 [Note] mysqld (mysqld 10.4.4-MariaDB-1:10.4.4+maria~bionic) starting as process 1 ...
2019-09-05  5:03:02 0 [Note] InnoDB: Using Linux native AIO
2019-09-05  5:03:02 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-09-05  5:03:02 0 [Note] InnoDB: Uses event mutexes
2019-09-05  5:03:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-05  5:03:02 0 [Note] InnoDB: Number of pools: 1
2019-09-05  5:03:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-05  5:03:02 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2019-09-05  5:03:02 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2019-09-05  5:03:02 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-05  5:03:02 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-09-05  5:03:02 0 [ERROR] InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 0 pages than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
2019-09-05  5:03:02 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-09-05  5:03:03 0 [Note] InnoDB: Starting shutdown...
2019-09-05  5:03:03 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-05  5:03:03 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-05  5:03:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-05  5:03:03 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-09-05  5:03:03 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-05  5:03:03 0 [ERROR] Aborting

[eldadfux]

OK great, now we have a lot more information. This definitely seems like MariaDB/MySQL issue.

Solution 1:
I am not completely sure about this, but I found it online and it seems related to your issue:
https://manage.accuwebhosting.com/knowledgebase/2318/How-to-Fix-MySQL-Error-Plugin-andsharp039InnoDBandsharp039-registration-as-a-STORAGE-ENGINE-failed.html

Solution 2
If still having trouble solving this, I would try to remove the mariadb container, image, clean storage and run stack again.

Something like this:

docker stop [mardiadb-conatiner-id]

docker rm [mardiadb-conatiner-id]

docker rmi [appwrite/mariadb-image-id]
# you can see the image id using 'docker images' command

# then delete your storage directory located inside appwrite-ce directory

#run stack again
docker-compose up -d

# wait for all containers to run, on non-linux hosts, appwrite server might take longer to start as docker needs to map the volumes

[jsaberon]

This is the new error. I don't know how to access the pertaining folder in this error or where I can find it.

Initializing database
2019-09-05  5:27:43 0 [Warning] InnoDB: Retry attempts for writing partial data failed.
2019-09-05  5:27:43 0 [ERROR] InnoDB: Write to file ./ibdata1 failed at offset 0, 1048576 bytes should have been written, only 0 were written. Operating system error number 22. Check that your OS and file system support files of this size. Check also that the disk is not full or a disk quota exceeded.
2019-09-05  5:27:43 0 [ERROR] InnoDB: Error number 22 means 'Invalid argument'
2019-09-05  5:27:43 0 [ERROR] InnoDB: Could not set the file size of './ibdata1'. Probably out of disk space
2019-09-05  5:27:43 0 [ERROR] InnoDB: Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again.
2019-09-05  5:27:44 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-05  5:27:44 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-05  5:27:44 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-05  5:27:44 0 [ERROR] Aborting

Installation of system tables failed!  Examine the logs in
/var/lib/mysql/ for more information.

The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:

    shell> /usr/bin/mysql_install_db --defaults-file=~/.my.cnf

You can also try to start the mysqld daemon with:

    shell> /usr/sbin/mysqld --skip-grant-tables --general-log &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/bin/mysql -u root mysql
    mysql> show tables;

Try 'mysqld --help' if you have problems with paths.  Using
--general-log gives you a log in /var/lib/mysql/ that may be helpful.

The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
You can find the latest source at https://downloads.mariadb.org and
the maria-discuss email list at https://launchpad.net/~maria-discuss

Please check all of the above before submitting a bug report
at http://mariadb.org/jira

[eldadfux]

@Almoullim yes, sure.. but do you have any reference to the original issue in windows so I will be able to track it for changes and upgrade back when fixed?

[Almoullim]

@eldadfux Don't have anything that you can track, many issues around in the docker-library/mariadb repo opening and closing about this, most of the information can be found here MariaDB/mariadb-docker#95 and here the pull request that enabled passing the flag MariaDB/mariadb-docker#168

passing the flag should be the current fix --innodb-flush-method=fsync, downgrading shouldn't be necessary but in my case it was

[mikehac]

Hi there,
I tried to do as @Almoullim suggested, but still same problem(Connection Refused),
The json I received is as following:
{ message: "SQLSTATE[HY000] [2002] Connection refused", code: 2002, file: "/usr/share/nginx/html/app/init.php", line: 70, trace: [ { file: "/usr/share/nginx/html/app/init.php", line: 70, function: "__construct", class: "PDO", type: "->", args: [ "mysql:host=mariadb;dbname=appwrite;charset=utf8mb4", "root", "password", { 2: 5, 1002: "SET NAMES utf8mb4" } ] }, { file: "/usr/share/nginx/html/vendor/utopia-php/registry/src/Registry/Registry.php", line: 72, function: "{closure}", args: [ ] }, { file: "/usr/share/nginx/html/app/app.php", line: 195, function: "get", class: "Utopia\Registry\Registry", type: "->", args: [ "db" ] }, { function: "{closure}", args: [ ] }, { file: "/usr/share/nginx/html/vendor/utopia-php/abuse/src/Abuse/Adapters/TimeLimit.php", line: 263, function: "call_user_func", args: [ { } ] }, { file: "/usr/share/nginx/html/vendor/utopia-php/abuse/src/Abuse/Adapters/TimeLimit.php", line: 159, function: "getPDO", class: "Utopia\Abuse\Adapters\TimeLimit", type: "->", args: [ ] }, { file: "/usr/share/nginx/html/vendor/utopia-php/abuse/src/Abuse/Adapters/TimeLimit.php", line: 233, function: "count", class: "Utopia\Abuse\Adapters\TimeLimit", type: "->", args: [ "url:192.114.74.156/v1/auth/register,ip:192.114.74.111", 1568872800 ] }, { file: "/usr/share/nginx/html/app/app.php", line: 215, function: "remaining", class: "Utopia\Abuse\Adapters\TimeLimit", type: "->", args: [ ] }, { function: "{closure}", args: [ ] }, { file: "/usr/share/nginx/html/vendor/utopia-php/framework/src/App.php", line: 387, function: "call_user_func_array", args: [ { }, [ ] ] }, { file: "/usr/share/nginx/html/app/app.php", line: 792, function: "run", class: "Utopia\App", type: "->", args: [ { }, { } ] }, { file: "/usr/share/nginx/html/public/index.php", line: 27, args: [ "/usr/share/nginx/html/app/app.php" ], function: "include" } ], version: "latest" }

Can it help to figure it out?

[mikehac]

Are you going to organize hackaton and give a price to the winner that will fix issues that are under this label??

[eldadfux]

@mikehac You can learn more here: https://medium.com/@eldadfux/hacktoberfest-2019-is-almost-here-lets-celebrate-it-together-24b311236dd

[christyjacob4]

@eldadfux The connection refused error occurs because the root user has hostname 'localhost' or '127.0.0.1' . The initialisation scripts in the mariadb service might not be running because the its permissions are over-written by user : www-data.

MariaDB [(none)]> SELECT host, user FROM mysql.user;
+-----------+------+
| Host      | User |
+-----------+------+
| %         | root |
| %         | user |
| localhost | root |
+-----------+------+
3 rows in set (0.034 sec)

Once the root user has the host '%' the connection refused error should go.

[eldadfux]

@jsaberon can you check if this error is resolved with version 0.2.0?