dockerfiles
dockerfiles copied to clipboard
Published
20 hours ago •
invoiceninja
invoiceninja
after update black page and nothing happen
Setup
- Version: <v5.6.1-->
- Environment: <Docker-Compose>
Checklist
- Can you replicate the issue on our v5 demo site https://demo.invoiceninja.com or https://react.invoicing.co/demo? No
- Have you searched existing issues? Yes, not found
- Have you reported this to Slack/forum before posting? No
- Have you inspected the logs in storage/logs/laravel.log for any errors? Yes , nothing updated and nothing showing
Describe the bug
stable system self-hosted, i regularly update the docker, after this update, black white page and no login
Are there any messages when the containers come up? Any messages in the browser console?
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"
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?
nothing, i used the same 3 commands for updates , docker stop docker pull docker start nothing more
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
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}
"}
