Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Data persistence doesn't work #18

Closed
maxguru opened this issue Oct 8, 2016 · 5 comments
Closed

Data persistence doesn't work #18

maxguru opened this issue Oct 8, 2016 · 5 comments

Comments

@maxguru
Copy link

maxguru commented Oct 8, 2016 •
edited
Loading

The README says 'To make your data persistant, you have to mount /var/www/app/public/logo and /var/www/app/storage.'

Well, I added the following to the app section in docker-compose.yml,

    ......
    volumes:
      - ./data/storage:/var/www/app/storage
      - ./data/logo:/var/www/app/public/logo

# docker-compose up

... did lots of configuration through the web UI ..

# docker-compose down
# docker-compose up

and everything is gone and I start from scratch!
@maxguru maxguru mentioned this issue Oct 12, 2016
Closed
@lalop
Copy link
Member

lalop commented Oct 17, 2016

The data is stored in the database, this folder is shared to keep logos et invoice's template mainly.
According to the docker-compose file you shared #20 it seems that you don't mount the good folder for mysql container.
See this for more information https://hub.docker.com/_/mysql/

@lalop lalop closed this as completed Oct 17, 2016
@maxguru
Copy link
Author

maxguru commented Oct 17, 2016

Actually, I did guess this correctly and initially had a volume for /var/lib/mysql, however, it was failing for me with the initialization migration scripts outputting duplicate key errors.

@lalop
Copy link
Member

lalop commented Oct 18, 2016

Wich one is fixed isn't it ?

@maxguru
Copy link
Author

maxguru commented Oct 18, 2016

I just tested it and it seems to be failing to initialize.

I have the following docker-compose.yml file,

version: "2"

services:
  db:
    image: mysql
    environment:
      MYSQL_DATABASE: ninja                                                                                           
      MYSQL_ROOT_PASSWORD: somethingsomething
    volumes:
      - ./data/mysql:/var/lib/mysql

  app:
    image: invoiceninja/invoiceninja
    links:
      - db:mysql
    environment:
      APP_DEBUG: 0
      DB_USERNAME: root
      DB_PASSWORD: somethingsomething
    volumes:
      - ./data/storage:/var/www/app/storage
      - ./data/logo:/var/www/app/public/logo

  web:
    image: nginx
    volumes:
      - ./nginx.conf:/etc/nginx/nginx.conf:ro
    links:
      - app
    volumes_from:
      - app
    ports:
      - "80:80"

  cron:
    image: invoiceninja/invoiceninja
    links:
      - db:mysql
    user: www-data
    environment:
      APP_DEBUG: 1
    entrypoint: |
      bash -c 'bash -s <<EOF
      trap "break;exit" SIGHUP SIGINT SIGTERM
      sleep 300s
      while /bin/true; do
        DB_USERNAME=root DB_PASSWORD=somethingsomething /usr/local/bin/php /var/www/app/artisan ninja:send-invoices
        DB_USERNAME=root DB_PASSWORD=somethingsomething /usr/local/bin/php /var/www/app/artisan ninja:send-reminders
        sleep 1d
      done
      EOF'
    volumes_from:
      - app

I had to do the following to make it work,

mkdir data/logo
mkdir data/mysql
mkdir data/storage
chown nobody:nobody data/*
chmod a+rwx data/*

However, it seems to be failing,

$ docker-compose up  
Creating network "test_default" with the default driver
Creating test_db_1
Creating test_app_1
Creating test_web_1
Creating test_cron_1
Attaching to test_db_1, test_app_1, test_web_1, test_cron_1
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
db_1    | Initializing database
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
db_1    | 2016-10-18T21:42:36.574634Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
db_1    | 2016-10-18T21:43:13.830152Z 0 [Warning] InnoDB: New log files created, LSN=45790
db_1    | 2016-10-18T21:43:15.289662Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
db_1    | 2016-10-18T21:43:20.473941Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: e3159d18-957b-11e6-b319-0242ac120002.
db_1    | 2016-10-18T21:43:21.848335Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
db_1    | 2016-10-18T21:43:21.848602Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
app_1   | MySQL Connection Error: SQLSTATE[HY000] [2002] Connection refused
test_app_1 exited with code 1
db_1    | 2016-10-18T21:44:20.515367Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
db_1    | 2016-10-18T21:44:20.515391Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
db_1    | 2016-10-18T21:44:20.515404Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
db_1    | 2016-10-18T21:44:20.515413Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
db_1    | 2016-10-18T21:44:20.515438Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
db_1    | Database initialized
db_1    | MySQL init process in progress...
db_1    | 2016-10-18T21:44:27.135975Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
db_1    | 2016-10-18T21:44:27.137097Z 0 [Note] mysqld (mysqld 5.7.16) starting as process 57 ...
db_1    | 2016-10-18T21:44:27.139503Z 0 [Note] InnoDB: PUNCH HOLE support available
db_1    | 2016-10-18T21:44:27.139521Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db_1    | 2016-10-18T21:44:27.139525Z 0 [Note] InnoDB: Uses event mutexes
db_1    | 2016-10-18T21:44:27.139528Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
db_1    | 2016-10-18T21:44:27.139531Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
db_1    | 2016-10-18T21:44:27.139535Z 0 [Note] InnoDB: Using Linux native AIO
db_1    | 2016-10-18T21:44:27.139727Z 0 [Note] InnoDB: Number of pools: 1
db_1    | 2016-10-18T21:44:27.139809Z 0 [Note] InnoDB: Using CPU crc32 instructions
db_1    | 2016-10-18T21:44:27.140972Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
db_1    | 2016-10-18T21:44:27.147579Z 0 [Note] InnoDB: Completed initialization of buffer pool
db_1    | 2016-10-18T21:44:27.149029Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db_1    | 2016-10-18T21:44:27.160283Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
db_1    | 2016-10-18T21:44:27.222955Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db_1    | 2016-10-18T21:44:27.223006Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db_1    | 2016-10-18T21:44:27.502864Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db_1    | 2016-10-18T21:44:27.503499Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
db_1    | 2016-10-18T21:44:27.503507Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
db_1    | 2016-10-18T21:44:27.503769Z 0 [Note] InnoDB: Waiting for purge to start
db_1    | 2016-10-18T21:44:27.553961Z 0 [Note] InnoDB: 5.7.16 started; log sequence number 2533166
db_1    | 2016-10-18T21:44:27.554152Z 0 [Note] Plugin 'FEDERATED' is disabled.
db_1    | 2016-10-18T21:44:27.554168Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db_1    | 2016-10-18T21:44:27.555313Z 0 [Note] InnoDB: Buffer pool(s) load completed at 161018 21:44:27
db_1    | 2016-10-18T21:44:27.557396Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
db_1    | 2016-10-18T21:44:27.579241Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
db_1    | 2016-10-18T21:44:27.579265Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
db_1    | 2016-10-18T21:44:27.579281Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
db_1    | 2016-10-18T21:44:27.579290Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
db_1    | 2016-10-18T21:44:27.580367Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
db_1    | 2016-10-18T21:44:27.584958Z 0 [Note] Event Scheduler: Loaded 0 events
db_1    | 2016-10-18T21:44:27.585137Z 0 [Note] mysqld: ready for connections.
db_1    | Version: '5.7.16'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server (GPL)
db_1    | Warning: Unable to load '/usr/share/zoneinfo/Factory' as time zone. Skipping it.
db_1    | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
db_1    | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
db_1    | Warning: Unable to load '/usr/share/zoneinfo/posix/Factory' as time zone. Skipping it.
db_1    | Warning: Unable to load '/usr/share/zoneinfo/right/Factory' as time zone. Skipping it.
db_1    | Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
db_1    | 2016-10-18T21:44:35.417323Z 4 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
db_1    | 2016-10-18T21:44:35.417339Z 4 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
db_1    | 2016-10-18T21:44:35.417364Z 4 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
db_1    | mysql: [Warning] Using a password on the command line interface can be insecure.
db_1    | 
db_1    | 2016-10-18T21:44:35.421111Z 0 [Note] Giving 0 client threads a chance to die gracefully
db_1    | 2016-10-18T21:44:35.421126Z 0 [Note] Shutting down slave threads
db_1    | 2016-10-18T21:44:35.421129Z 0 [Note] Forcefully disconnecting 0 remaining clients
db_1    | 2016-10-18T21:44:35.421133Z 0 [Note] Event Scheduler: Purging the queue. 0 events
db_1    | 2016-10-18T21:44:35.421165Z 0 [Note] Binlog end
db_1    | 2016-10-18T21:44:35.421687Z 0 [Note] Shutting down plugin 'ngram'
db_1    | 2016-10-18T21:44:35.421694Z 0 [Note] Shutting down plugin 'BLACKHOLE'
db_1    | 2016-10-18T21:44:35.421698Z 0 [Note] Shutting down plugin 'partition'
db_1    | 2016-10-18T21:44:35.421700Z 0 [Note] Shutting down plugin 'ARCHIVE'
db_1    | 2016-10-18T21:44:35.421702Z 0 [Note] Shutting down plugin 'MEMORY'
db_1    | 2016-10-18T21:44:35.421705Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
db_1    | 2016-10-18T21:44:35.421710Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
db_1    | 2016-10-18T21:44:35.421712Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
db_1    | 2016-10-18T21:44:35.421714Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
db_1    | 2016-10-18T21:44:35.421716Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
db_1    | 2016-10-18T21:44:35.421718Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
db_1    | 2016-10-18T21:44:35.421720Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
db_1    | 2016-10-18T21:44:35.421722Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
db_1    | 2016-10-18T21:44:35.421726Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
db_1    | 2016-10-18T21:44:35.421732Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
db_1    | 2016-10-18T21:44:35.421736Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
db_1    | 2016-10-18T21:44:35.421739Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
db_1    | 2016-10-18T21:44:35.421782Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
db_1    | 2016-10-18T21:44:35.421789Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
db_1    | 2016-10-18T21:44:35.421793Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
db_1    | 2016-10-18T21:44:35.421797Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
db_1    | 2016-10-18T21:44:35.421804Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
db_1    | 2016-10-18T21:44:35.421808Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
db_1    | 2016-10-18T21:44:35.421812Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
db_1    | 2016-10-18T21:44:35.421818Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
db_1    | 2016-10-18T21:44:35.421822Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
db_1    | 2016-10-18T21:44:35.421829Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
db_1    | 2016-10-18T21:44:35.421833Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
db_1    | 2016-10-18T21:44:35.421851Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
db_1    | 2016-10-18T21:44:35.421855Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
db_1    | 2016-10-18T21:44:35.421859Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
db_1    | 2016-10-18T21:44:35.421870Z 0 [Note] Shutting down plugin 'INNODB_CMP'
db_1    | 2016-10-18T21:44:35.421875Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
db_1    | 2016-10-18T21:44:35.421881Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
db_1    | 2016-10-18T21:44:35.421885Z 0 [Note] Shutting down plugin 'INNODB_TRX'
db_1    | 2016-10-18T21:44:35.421889Z 0 [Note] Shutting down plugin 'InnoDB'
db_1    | 2016-10-18T21:44:35.421941Z 0 [Note] InnoDB: FTS optimize thread exiting.
db_1    | 2016-10-18T21:44:35.421980Z 0 [Note] InnoDB: Starting shutdown...
db_1    | 2016-10-18T21:44:35.522189Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
db_1    | 2016-10-18T21:44:35.522374Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 161018 21:44:35
db_1    | 2016-10-18T21:44:39.014599Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12138965
db_1    | 2016-10-18T21:44:39.016134Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
db_1    | 2016-10-18T21:44:39.016144Z 0 [Note] Shutting down plugin 'MyISAM'
db_1    | 2016-10-18T21:44:39.016154Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
db_1    | 2016-10-18T21:44:39.016161Z 0 [Note] Shutting down plugin 'CSV'
db_1    | 2016-10-18T21:44:39.016168Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
db_1    | 2016-10-18T21:44:39.016191Z 0 [Note] Shutting down plugin 'sha256_password'
db_1    | 2016-10-18T21:44:39.016199Z 0 [Note] Shutting down plugin 'mysql_native_password'
db_1    | 2016-10-18T21:44:39.016298Z 0 [Note] Shutting down plugin 'binlog'
db_1    | 2016-10-18T21:44:39.017516Z 0 [Note] mysqld: Shutdown complete
db_1    | 
db_1    | 
db_1    | MySQL init process done. Ready for start up.
db_1    | 
db_1    | 2016-10-18T21:44:39.226656Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
db_1    | 2016-10-18T21:44:39.227754Z 0 [Note] mysqld (mysqld 5.7.16) starting as process 1 ...
db_1    | 2016-10-18T21:44:39.230171Z 0 [Note] InnoDB: PUNCH HOLE support available
db_1    | 2016-10-18T21:44:39.230189Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db_1    | 2016-10-18T21:44:39.230194Z 0 [Note] InnoDB: Uses event mutexes
db_1    | 2016-10-18T21:44:39.230201Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
db_1    | 2016-10-18T21:44:39.230208Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
db_1    | 2016-10-18T21:44:39.230215Z 0 [Note] InnoDB: Using Linux native AIO
db_1    | 2016-10-18T21:44:39.230445Z 0 [Note] InnoDB: Number of pools: 1
db_1    | 2016-10-18T21:44:39.230531Z 0 [Note] InnoDB: Using CPU crc32 instructions
db_1    | 2016-10-18T21:44:39.231656Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
db_1    | 2016-10-18T21:44:39.238152Z 0 [Note] InnoDB: Completed initialization of buffer pool
db_1    | 2016-10-18T21:44:39.239667Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db_1    | 2016-10-18T21:44:39.250867Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
db_1    | 2016-10-18T21:44:39.298042Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db_1    | 2016-10-18T21:44:39.298101Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db_1    | 2016-10-18T21:44:39.594491Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db_1    | 2016-10-18T21:44:39.595153Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
db_1    | 2016-10-18T21:44:39.595166Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
db_1    | 2016-10-18T21:44:39.595561Z 0 [Note] InnoDB: 5.7.16 started; log sequence number 12138965
db_1    | 2016-10-18T21:44:39.595727Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db_1    | 2016-10-18T21:44:39.595848Z 0 [Note] Plugin 'FEDERATED' is disabled.
db_1    | 2016-10-18T21:44:39.599299Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
db_1    | 2016-10-18T21:44:39.599591Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
db_1    | 2016-10-18T21:44:39.599618Z 0 [Note] IPv6 is available.
db_1    | 2016-10-18T21:44:39.599627Z 0 [Note]   - '::' resolves to '::';
db_1    | 2016-10-18T21:44:39.599645Z 0 [Note] Server socket created on IP: '::'.
db_1    | 2016-10-18T21:44:39.599940Z 0 [Note] InnoDB: Buffer pool(s) load completed at 161018 21:44:39
db_1    | 2016-10-18T21:44:39.628966Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
db_1    | 2016-10-18T21:44:39.628983Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
db_1    | 2016-10-18T21:44:39.630641Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
db_1    | 2016-10-18T21:44:39.634763Z 0 [Note] Event Scheduler: Loaded 0 events
db_1    | 2016-10-18T21:44:39.634934Z 0 [Note] mysqld: ready for connections.
db_1    | Version: '5.7.16'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
cron_1  | 2016-10-18 Running SendRecurringInvoices...
cron_1  | 
cron_1  |                                                                                                                                                                                                                                                                                                                                                                                  
cron_1  |   [Illuminate\Database\QueryException]                                                                                                                                                                                                                                                                                                                                           
cron_1  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ninja.invoices' doesn't exist (SQL: select * from `invoices` where is_deleted IS FALSE AND deleted_at IS NULL AND is_recurring IS TRUE AND frequency_id > 0 AND start_date <= 2016-10-18 21:49:09 AND (end_date IS NULL OR end_date >= 2016-10-18 21:49:09) and `invoices`.`deleted_at` is null order by `id` asc)  
cron_1  |                                                                                                                                                                                                                                                                                                                                                                                  
cron_1  | 
cron_1  |                                                                                             
cron_1  |   [PDOException]                                                                            
cron_1  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ninja.invoices' doesn't exist  
cron_1  |                                                                                             
cron_1  | 
cron_1  | 2016-10-18 Running SendReminders...
cron_1  | 
cron_1  |                                                                                                                                                                                                                                            
cron_1  |   [Illuminate\Database\QueryException]                                                                                                                                                                                                     
cron_1  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ninja.accounts' doesn't exist (SQL: select * from `accounts` where enable_reminder1 = 1 OR enable_reminder2 = 1 OR enable_reminder3 = 1 and `accounts`.`deleted_at` is null)  
cron_1  |                                                                                                                                                                                                                                            
cron_1  | 
cron_1  |                                                                                             
cron_1  |   [PDOException]                                                                            
cron_1  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ninja.accounts' doesn't exist  
cron_1  |                                                                                             
cron_1  |

@karneaud
Copy link

+1

@danielgroen danielgroen mentioned this issue Apr 5, 2020
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@lalop @karneaud @maxguru