V8-archive: Table 'directus.directus_roles' doesn't exist

Created on 4 Nov 2018 · 2Comments · Source: directus/v8-archive

Bug Report

Missing table at first access to api installed using docker

```docker-compose.yml
version: '3'
services:
directus-api:
image: directus/api
ports:
- "8083:80"
links:
- directus-db:mysql
environment:
- DATABASE_HOST=mysql
- DATABASE_USERNAME=directus
- DATABASE_PASSWORD=directus
directus-db:
image: mariadb:10.2
environment:
- MYSQL_ROOT_PASSWORD=root
- MYSQL_DATABASE=directus
- MYSQL_USER=directus
- MYSQL_PASSWORD=directus


## Steps to Reproduce

1. launch containers `docker-compose up -d`
2. access service `curl http://localhost:8083`

## Expected Behavior
Still discovering

## Actual Behavior
The error `{"error":{"code":null,"message":"Statement could not be executed (42S02 - 1146 - Table 'directus.directus_roles' doesn't exist)"}}` is shown 

## Other Context & Screenshots

Installed tables;
![image](https://user-images.githubusercontent.com/1025560/47968047-bd2d1580-e064-11e8-8edf-7eeafb52bcae.png)

Users:

MariaDB [directus]> select * from directus_users;
+----+--------+------------+-----------+-----------------+--------------------------------------------------------------+------------------+----------------------------------+------------------------------------------+-------------+------------------+----------+----------------+---------------------+---------------------+---------------------------------------------------------------+--------------+-------+----------------------------------------------------------------------------------+----------------+----------+-------+---------+------+-------+---------+------+----------+------------------+--------------+-------------+---------------+-----------------+
| id | status | first_name | last_name | email | password | salt | token | access_token | reset_token | reset_expiration | position | email_messages | last_login |last_access | last_page | ip | group | avatar | avatar_file_id | location | phone | address | city | state | country | zip | language | timezone | invite_token | invite_date | invite_sender | invite_accepted |
+----+--------+------------+-----------+-----------------+--------------------------------------------------------------+------------------+----------------------------------+------------------------------------------+-------------+------------------+----------+----------------+---------------------+---------------------+---------------------------------------------------------------+--------------+-------+----------------------------------------------------------------------------------+----------------+----------+-------+---------+------+-------+---------+------+----------+------------------+--------------+-------------+---------------+-----------------+
| 1 | 1 | Admin | User | [email protected] | $2y$12$UhoRXS9j6vtI.bK8Spf8YuOhlo1ka6BRldLPyfhjSk0W1iz92L2HS | 86GZl0euHhHA2VuL | qb4TnKpa4dFSGXVTx7VUf4g9FW1wjxwv | af567d7bfed223e912689312a6a9735cc08b9a9e | | NULL | | 1 | 2018-10-24 17:14:05 |2018-10-24 17:32:15 | {"path":"settings/tables/navigation","route":"settingsTable"} | 192.168.32.1 | 1 | //www.gravatar.com/avatar/64e1b8d34f425d19e1ee2ea7236d3028?s=200&d=identicon&r=g | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | en | America/New_York | NULL | NULL | NULL | NULL |
+----+--------+------------+-----------+-----------------+--------------------------------------------------------------+------------------+----------------------------------+------------------------------------------+-------------+------------------+----------+----------------+---------------------+---------------------+---------------------------------------------------------------+--------------+-------+----------------------------------------------------------------------------------+----------------+----------+-------+---------+------+-------+---------+------+----------+------------------+--------------+-------------+---------------+-----------------+
1 row in set (0.00 sec)
```

error.2018-11-04.log