search

invoiceninja / dockerfiles

Docker files for Invoice Ninja
https://hub.docker.com/r/invoiceninja/invoiceninja
GNU General Public License v2.0
398 stars 264 forks source link

after update black page and nothing happen #516

Open Tabarane opened 1 year ago

Tabarane commented 1 year ago

Setup

Checklist

Describe the bug

stable system self-hosted, i regularly update the docker, after this update, black white page and no login

turbo124 commented 1 year ago

Are there any messages when the containers come up? Any messages in the browser console?

Tabarane commented 1 year ago

browser and f12 totals silence

and the 3 docker container logs as follow

 2023-06-10 19:45:03 App\Jobs\Ninja\QueueSize .................. 11.08ms DONE
   INFO  No scheduled commands are ready to run.  
   INFO  No scheduled commands are ready to run.  
   INFO  No scheduled commands are ready to run.  
   INFO  No scheduled commands are ready to run.  
  2023-06-10 19:50:00 Running [queue-size-job] ..................... 21ms DONE
  2023-06-10 19:50:00 Running [Callback] ........................... 15ms DONE
  2023-06-10 19:50:03 App\Jobs\Ninja\QueueSize ....................... RUNNING
  2023-06-10 19:50:03 App\Jobs\Ninja\QueueSize .................. 11.46ms DONE

2023-06-10 19:25:03 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-06-10 19:25:03 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2023-06-10 19:25:03 0 [Note] InnoDB: Completed initialization of buffer pool
2023-06-10 19:25:03 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2023-06-10 19:25:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-06-10 19:25:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-06-10 19:25:03 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-06-10 19:25:03 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-06-10 19:25:03 0 [Note] InnoDB: Waiting for purge to start
2023-06-10 19:25:03 0 [Note] InnoDB: 10.4.30 started; log sequence number 302187940; transaction id 7859482
2023-06-10 19:25:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-06-10 19:25:03 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-06-10 19:25:03 0 [Note] Server socket created on IP: '::'.
2023-06-10 19:25:03 0 [Note] Reading of all Master_info entries succeeded
2023-06-10 19:25:03 0 [Note] Added new Master_info '' to hash table
2023-06-10 19:25:03 0 [Note] mysqld: ready for connections.
Version: '10.4.30-MariaDB-1:10.4.30+maria~ubu2004'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
2023-06-10 19:25:04 0 [Note] InnoDB: Buffer pool(s) load completed at 230610 19:25:04

/docker-entrypoint.sh: /docker-entrypoint.d/ is not empty, will attempt to perform configuration
/docker-entrypoint.sh: Looking for shell scripts in /docker-entrypoint.d/
/docker-entrypoint.sh: Launching /docker-entrypoint.d/10-listen-on-ipv6-by-default.sh
10-listen-on-ipv6-by-default.sh: info: Getting the checksum of /etc/nginx/conf.d/default.conf
10-listen-on-ipv6-by-default.sh: info: Enabled listen on IPv6 in /etc/nginx/conf.d/default.conf
/docker-entrypoint.sh: Launching /docker-entrypoint.d/20-envsubst-on-templates.sh
/docker-entrypoint.sh: Launching /docker-entrypoint.d/30-tune-worker-processes.sh
/docker-entrypoint.sh: Configuration complete; ready for start up
2023/06/10 19:25:04 [notice] 1#1: using the "epoll" event method
2023/06/10 19:25:04 [notice] 1#1: nginx/1.25.0
2023/06/10 19:25:04 [notice] 1#1: built by gcc 10.2.1 20210110 (Debian 10.2.1-6) 
2023/06/10 19:25:04 [notice] 1#1: OS: Linux 5.4.0-99-generic
2023/06/10 19:25:04 [notice] 1#1: getrlimit(RLIMIT_NOFILE): 1048576:1048576
2023/06/10 19:25:04 [notice] 1#1: start worker processes
2023/06/10 19:25:04 [notice] 1#1: start worker process 28

when i try to access the webapp i get this in the logs

72.27.0.1 - - [10/Jun/2023:19:52:12 +0000] "GET / HTTP/1.1" 200 5 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36" "x.x.x.x"
172.27.0.1 - - [10/Jun/2023:19:52:14 +0000] "GET /flutter_service_worker.js?v=5.5.122 HTTP/1.1" 200 0 "https://xxx.xxx.xxx/flutter_service_worker.js?v=5.5.122" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36" "x.x.x.x"
turbo124 commented 1 year ago

not sure, i just upgrade some containers and was not able to replicate this. i do note you are using an old version of mariadb, are there any other changes made to the defaul config?

Tabarane commented 1 year ago

nothing, i used the same 3 commands for updates , docker stop docker pull docker start nothing more

Tabarane commented 1 year ago

i have updated mariadb , same issue as before , latest log from db

2023-06-10 21:38:46+00:00 [Note] [Entrypoint]: Backing up complete
2023-06-10 21:38:46+00:00 [Note] [Entrypoint]: Starting mariadb-upgrade
The --upgrade-system-tables option was used, user tables won't be touched.
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.global_priv                                  OK
mysql.gtid_slave_pos                               OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.index_stats                                  OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.transaction_registry                         OK
Phase 2/7: Installing used storage engines... Skipped
Phase 3/7: Fixing views... Skipped
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names ... Skipped
Phase 6/7: Checking and upgrading tables... Skipped
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK
2023-06-10 21:38:52+00:00 [Note] [Entrypoint]: Finished mariadb-upgrade
2023-06-10 21:38:52+00:00 [Note] [Entrypoint]: Stopping temporary server
2023-06-10 21:38:52 0 [Note] mariadbd (initiated by: unknown): Normal shutdown
2023-06-10 21:38:52 0 [Note] InnoDB: FTS optimize thread exiting.
2023-06-10 21:38:52 0 [Note] InnoDB: Starting shutdown...
2023-06-10 21:38:52 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2023-06-10 21:38:52 0 [Note] InnoDB: Shutdown completed; log sequence number 302370245; transaction id 7864835
2023-06-10 21:38:52 0 [Note] mariadbd: Shutdown complete
2023-06-10 21:38:52+00:00 [Note] [Entrypoint]: Temporary server stopped
2023-06-10 21:38:53 0 [Note] Starting MariaDB 11.0.2-MariaDB-1:11.0.2+maria~ubu2204 source revision 0005f2f06c8e1aea4915887decad67885108a929 as process 1
2023-06-10 21:38:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-06-10 21:38:53 0 [Note] InnoDB: Number of transaction pools: 1
2023-06-10 21:38:53 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-06-10 21:38:53 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-06-10 21:38:53 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOMEM: try larger memory locked limit, ulimit -l, or https://mariadb.com/kb/en/systemd/#configuring-limitmemlock under systemd (262144 bytes required)
2023-06-10 21:38:53 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
2023-06-10 21:38:53 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2023-06-10 21:38:53 0 [Note] InnoDB: Completed initialization of buffer pool
2023-06-10 21:38:53 0 [Note] InnoDB: Resetting space id's in the doublewrite buffer
2023-06-10 21:38:53 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2023-06-10 21:38:53 0 [Note] InnoDB: Opened 3 undo tablespaces
2023-06-10 21:38:53 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2023-06-10 21:38:53 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2023-06-10 21:38:53 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2023-06-10 21:38:53 0 [Note] InnoDB: log sequence number 302370245; transaction id 7864831
2023-06-10 21:38:53 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-06-10 21:38:53 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-06-10 21:38:53 0 [Note] Plugin 'wsrep-provider' is disabled.
2023-06-10 21:38:53 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-06-10 21:38:53 0 [Note] Server socket created on IP: '::'.
2023-06-10 21:38:53 0 [Note] mariadbd: ready for connections.
Version: '11.0.2-MariaDB-1:11.0.2+maria~ubu2204'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
2023-06-10 21:38:53 0 [Note] InnoDB: Buffer pool(s) load completed at 230610 21:38:53

mariadb ready for connection still nothing working

Tabarane commented 1 year ago

error found in laravel.log

[previous exception] [object] (PDOException(code: 40001): SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:419)
[stacktrace]
#0 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(419): PDOStatement->execute()
#1 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\\Database\\Connection->runQueryCallback()
#3 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run()
#4 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\\Database\\Connection->select()
#5 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#8 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\\Database\\Query\\Builder->get()
#9 /var/www/app/vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php(246): Illuminate\\Database\\Query\\Builder->first()
#10 /var/www/app/vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php(224): Illuminate\\Queue\\DatabaseQueue->getNextAvailableJob()
#11 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(30): Illuminate\\Queue\\DatabaseQueue->Illuminate\\Queue\\{closure}()
#12 /var/www/app/vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php(227): Illuminate\\Database\\Connection->transaction()
#13 /var/www/app/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(342): Illuminate\\Queue\\DatabaseQueue->pop()
#14 /var/www/app/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(351): Illuminate\\Queue\\Worker->Illuminate\\Queue\\{closure}()
#15 /var/www/app/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(160): Illuminate\\Queue\\Worker->getNextJob()
#16 /var/www/app/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\\Queue\\Worker->daemon()
#17 /var/www/app/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\\Queue\\Console\\WorkCommand->runWorker()
#18 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()
#19 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#20 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#21 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#22 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\\Container\\BoundMethod::call()
#23 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\\Container\\Container->call()
#24 /var/www/app/vendor/symfony/console/Command/Command.php(312): Illuminate\\Console\\Command->execute()
#25 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\\Component\\Console\\Command\\Command->run()
#26 /var/www/app/vendor/symfony/console/Application.php(1022): Illuminate\\Console\\Command->run()
#27 /var/www/app/vendor/symfony/console/Application.php(314): Symfony\\Component\\Console\\Application->doRunCommand()
#28 /var/www/app/vendor/symfony/console/Application.php(168): Symfony\\Component\\Console\\Application->doRun()
#29 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\\Component\\Console\\Application->run()
#30 /var/www/app/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\\Console\\Application->run()
#31 /var/www/app/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle()
#32 {main}
"}
db4rne commented 1 year ago

Hi, I seem to have the same problem, have you found a solution yet?