search

ptrumpis / snap-camera-server

An alternative, self-hosted solution that allows you to continue using Snap Camera with all Snapchat filters after its shutdown on January 25, 2023.
https://github.com/snapcamera
MIT License
330 stars 40 forks source link

Docker Error #154

Open MiX74P3 opened 3 months ago

MiX74P3 commented 3 months ago

Please make sure the Wiki and Discussions section does not solve your problem:

If you are having technical difficulties please provide the following information: System (please complete the following information):

2024-07-19 20:30:32 2024-07-20 00:30:32+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-19 20:30:32 2024-07-20 00:30:32+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2024-07-19 20:30:32 2024-07-20 00:30:32+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-19 20:30:33 2024-07-20 00:30:33+00:00 [Note] [Entrypoint]: Initializing database files 2024-07-19 20:32:49 2024-07-20 00:32:49+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-19 20:32:50 2024-07-20 00:32:50+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2024-07-19 20:32:50 2024-07-20 00:32:50+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-19 20:32:50 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' 2024-07-19 20:38:23 2024-07-20 00:38:23+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-19 20:38:23 2024-07-20 00:38:23+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2024-07-19 20:38:23 2024-07-20 00:38:23+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-19 20:38:23 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' 2024-07-19 20:30:33 2024-07-20T00:30:33.145682Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2024-07-19 20:30:33 2024-07-20T00:30:33.145810Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.38) initializing of server in progress as process 80 2024-07-19 20:30:33 2024-07-20T00:30:33.185587Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-07-19 20:30:39 2024-07-20T00:30:39.836925Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2024-07-19 20:31:31 2024-07-20T00:31:31.095674Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2024-07-19 20:32:51 2024-07-20T00:32:51.171215Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2024-07-19 20:32:51 2024-07-20T00:32:51.173097Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.38) starting as process 1 2024-07-19 20:32:51 2024-07-20T00:32:51.197721Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-07-19 20:32:51 2024-07-20T00:32:51.242192Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2024-07-19 20:32:51 2024-07-20T00:32:51.242260Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2024-07-19 20:32:51 2024-07-20T00:32:51.720759Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2024-07-19 20:32:51 2024-07-20T00:32:51.720932Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2024-07-19 20:32:51 2024-07-20T00:32:51.720966Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-07-19 20:32:51 2024-07-20T00:32:51.721334Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.38) MySQL Community Server - GPL. 2024-07-19 20:38:23 2024-07-20T00:38:23.777579Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2024-07-19 20:38:23 2024-07-20T00:38:23.780346Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.38) starting as process 1 2024-07-19 20:38:23 2024-07-20T00:38:23.795936Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-07-19 20:47:52 2024-07-20 00:47:52+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-19 20:47:53 2024-07-20 00:47:53+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2024-07-19 20:47:53 2024-07-20 00:47:53+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-19 20:47:53 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' 2024-07-19 20:54:48 2024-07-20 00:54:48+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-19 20:54:49 2024-07-20 00:54:49+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2024-07-19 20:54:49 2024-07-20 00:54:49+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-19 20:54:49 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' 2024-07-19 20:59:04 2024-07-20 00:59:04+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-19 20:59:05 2024-07-20 00:59:05+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2024-07-19 20:59:05 2024-07-20 00:59:05+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-19 20:59:05 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' 2024-07-19 20:59:09 2024-07-20 00:59:09+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-19 20:59:09 2024-07-20 00:59:09+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2024-07-19 20:59:09 2024-07-20 00:59:09+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-19 20:59:09 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' 2024-07-19 20:59:17 2024-07-20 00:59:17+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-19 20:38:23 2024-07-20T00:38:23.833179Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2024-07-19 20:38:23 2024-07-20T00:38:23.833231Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2024-07-19 20:38:24 2024-07-20T00:38:24.315510Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2024-07-19 20:38:24 2024-07-20T00:38:24.315728Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2024-07-19 20:38:24 2024-07-20T00:38:24.315770Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-07-19 20:38:24 2024-07-20T00:38:24.316261Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.38) MySQL Community Server - GPL. 2024-07-19 20:47:53 2024-07-20T00:47:53.531752Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2024-07-19 20:47:53 2024-07-20T00:47:53.534078Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.38) starting as process 1 2024-07-19 20:47:53 2024-07-20T00:47:53.549887Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-07-19 20:47:53 2024-07-20T00:47:53.600210Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2024-07-19 20:47:53 2024-07-20T00:47:53.600269Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2024-07-19 20:47:54 2024-07-20T00:47:54.075029Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2024-07-19 20:47:54 2024-07-20T00:47:54.075226Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2024-07-19 20:47:54 2024-07-20T00:47:54.075265Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-07-19 20:47:54 2024-07-20T00:47:54.075760Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.38) MySQL Community Server - GPL. 2024-07-19 20:54:49 2024-07-20T00:54:49.476554Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2024-07-19 20:54:49 2024-07-20T00:54:49.478893Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.38) starting as process 1 2024-07-19 20:54:49 2024-07-20T00:54:49.490687Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-07-19 20:54:49 2024-07-20T00:54:49.541682Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2024-07-19 20:54:49 2024-07-20T00:54:49.541744Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2024-07-19 20:54:50 2024-07-20T00:54:50.020559Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2024-07-19 20:54:50 2024-07-20T00:54:50.020780Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2024-07-19 20:54:50 2024-07-20T00:54:50.020817Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-07-19 20:54:50 2024-07-20T00:54:50.021263Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.38) MySQL Community Server - GPL. 2024-07-19 20:59:05 2024-07-20T00:59:05.789175Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2024-07-19 20:59:05 2024-07-20T00:59:05.790591Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.38) starting as process 1 2024-07-19 20:59:05 2024-07-20T00:59:05.802655Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-07-19 20:59:05 2024-07-20T00:59:05.834779Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2024-07-19 20:59:05 2024-07-20T00:59:05.834828Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2024-07-19 20:59:06 2024-07-20T00:59:06.319428Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2024-07-19 20:59:06 2024-07-20T00:59:06.319595Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2024-07-19 20:59:06 2024-07-20T00:59:06.319632Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-07-19 20:59:06 2024-07-20T00:59:06.320136Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.38) MySQL Community Server - GPL. 2024-07-19 20:59:10 2024-07-20T00:59:10.166264Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2024-07-19 20:59:10 2024-07-20T00:59:10.176641Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.38) starting as process 1 2024-07-19 20:59:10 2024-07-20T00:59:10.190750Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-07-19 20:59:10 2024-07-20T00:59:10.222190Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2024-07-19 20:59:10 2024-07-20T00:59:10.222254Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2024-07-19 20:59:10 2024-07-20T00:59:10.710811Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2024-07-19 20:59:10 2024-07-20T00:59:10.711045Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2024-07-19 20:59:10 2024-07-20T00:59:10.711080Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-07-19 20:59:10 2024-07-20T00:59:10.711561Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.38) MySQL Community Server - GPL. 2024-07-19 20:59:18 2024-07-20 00:59:18+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2024-07-19 20:59:18 2024-07-20 00:59:18+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-19 20:59:18 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' 2024-07-19 20:59:18 2024-07-20T00:59:18.402844Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2024-07-19 20:59:18 2024-07-20T00:59:18.404181Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.38) starting as process 1 2024-07-19 20:59:18 2024-07-20T00:59:18.411917Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-07-19 20:59:18 2024-07-20T00:59:18.437826Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2024-07-19 20:59:18 2024-07-20T00:59:18.437902Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2024-07-19 20:59:18 2024-07-20T00:59:18.927272Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2024-07-19 20:59:18 2024-07-20T00:59:18.927449Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2024-07-19 20:59:18 2024-07-20T00:59:18.927487Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-07-19 20:59:18 2024-07-20T00:59:18.928019Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.38) MySQL Community Server - GPL.

MiX74P3 commented 2 months ago

any idea on how to fix this issue?

ptrumpis commented 2 months ago

Looks like a problem with your MySQL server.

You could try to delete the MySQL Container, Image and Volume. And re-initialize everything with docker compose up.

You can refer to the upgrade guide for removal instructions. https://github.com/ptrumpis/snap-camera-server/wiki/Upgrading-Server-v2.x-to-v3.x#docker-desktop

MiX74P3 commented 2 months ago

i tried that but everything still times out after running docker compose up in power shell. https://i.imgur.com/hXpa9Ja.png

MiX74P3 commented 2 months ago

2024-07-25 13:27:17 2024-07-25 17:27:17+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-25 13:27:18 2024-07-25 17:27:18+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2024-07-25 13:27:18 2024-07-25 17:27:18+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-25 13:27:18 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' 2024-07-25 13:27:18 2024-07-25T17:27:18.625494Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2024-07-25 13:27:18 2024-07-25T17:27:18.630022Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.38) starting as process 1 2024-07-25 13:27:18 2024-07-25T17:27:18.657303Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-07-25 13:27:18 2024-07-25T17:27:18.750933Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2024-07-25 13:27:18 2024-07-25T17:27:18.750996Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2024-07-25 13:27:19 2024-07-25T17:27:19.201084Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2024-07-25 13:27:19 2024-07-25T17:27:19.201292Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2024-07-25 13:27:19 2024-07-25T17:27:19.201338Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-07-25 13:27:19 2024-07-25T17:27:19.201901Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.38) MySQL Community Server - GPL. 2024-07-25 15:42:49 2024-07-25T19:42:49.158888Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2024-07-25 15:42:49 2024-07-25T19:42:49.161873Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.38) starting as process 1 2024-07-25 15:42:49 2024-07-25T19:42:49.184218Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-07-25 15:42:49 2024-07-25T19:42:49.288981Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2024-07-25 15:42:49 2024-07-25T19:42:49.289044Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2024-07-25 15:42:49 2024-07-25T19:42:49.736408Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2024-07-25 15:42:49 2024-07-25T19:42:49.736713Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2024-07-25 15:42:49 2024-07-25T19:42:49.736757Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-07-25 15:42:49 2024-07-25T19:42:49.737392Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.38) MySQL Community Server - GPL. 2024-07-25 15:42:47 2024-07-25 19:42:47+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-25 15:42:48 2024-07-25 19:42:48+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2024-07-25 15:42:48 2024-07-25 19:42:48+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.38-1.el9 started. 2024-07-25 15:42:48 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'

MiX74P3 commented 2 months ago

well i deleted and used ur autosetup and all seems well w docker and mysql. https://i.imgur.com/gYN58vu.png but snapcamera.exe doesnt show filters. i signature patched it and am on 1.2.1. but u have no guide for windows, only mac. am i missing something?

MiX74P3 commented 2 months ago

let me know how i can fix this when u have time please. docker container is running fine but snapcam program does not show filters.