Error in the deployment in mysql database
Good morning, everyone. I'm encountering this error in the deployment log of my MySQL database. Does anyone know what this issue is? I think I'm unable to deploy my API due to this database error.
id project: c648f600-016b-48f6-9527-177e346dc493
Pleaseeee
9 Replies
Project ID:
c648f600-016b-48f6-9527-177e346dc493console message:
2023-11-24 15:27:02+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
2023-11-24 15:27:03+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-11-24 15:27:03+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-11-24T15:27:03.638676Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2023-11-24T15:27:03.889598Z 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.
2023-11-24T15:27:03.891404Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.2.0) starting as process 1
2023-11-24T15:27:03.902203Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-24T15:27:04.146678Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-11-24T15:27:04.404549Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-11-24T15:27:04.404593Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-11-24T15:27:04.407628Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2023-11-24T15:27:04.436251Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2023-11-24T15:27:04.436386Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.2.0' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
I don't see any errors? red doesn't always mean error.
are you not able to connect to the database?
I accidentally found out what was happening.
I was unable to start my api, due to the connection to the database. I thought the error was in the bank's deployment, but it wasn't. I had some images (base64) in my database, so when I deleted them, the api started working again.
Have you seen anything like this before?
nope, just seems like a code issue to me?
I don't know if it's a code problem.
I'll explain the project to you, I'm using react-native for a mobile application, so I already convert the image directly on react-native to base 64, I receive it on the node in normal text format and my database receives a longtext.
i mean ive always heard that storing files into an sql database isnt ideal
I understand, but I'm in the final stretch of my final course project, so I have no other choice.
Try to serialize it?