Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
-
None
-
OS : Red Hat Enterprise Linux 8.3, @@version: 10.5.9-MariaDB-log, Linux duuscn1ahxunwcadbs1001 4.18.0-513.9.1.el8_9.x86_64 #1 SMP Thu Nov 16 10:29:04 EST 2023 x86_64 x86_64 x86_64 GNU/Linux
Description
The application transaction failed with below error
*Caused by: java.sql.SQLTransientConnectionException: (conn=173325) Error writing file '/mariadb-binlog/hxun' (errno: 11 "Resource temporarily unavailable")*
|
20231229 191909.014 [] ERROR : .DatabaseHelperService-exception while saving {}
|
org.springframework.orm.jpa.JpaSystemException: could not execute batch; nested exception is org.hibernate.exception.GenericJDBCException: could not execute batch
|
*Caused by: java.sql.BatchUpdateException: (conn=173323) Writing one row to the row-based binary log failed
|
The DB has enough free space to handle the transaction, but still it was not proceeding with transaciton.
When tryied flusing the logs it throwed error. Noticed Below in mariadb error log file
[unicauser@duuscn1ahxunwcadbs1001 ~]$ tail -f /mariadb/data/duuscn1ahxunwcadbs1001.err
|
2023-12-29 11:32:49 173937 [ERROR] Could not use /mariadb/mariadb-binlog/hxun for logging (error 2). Turning logging off for the whole duration of the MariaDB server process. To turn it on again: fix the cause, shutdown the MariaDB server and restart it.
|
2023-12-29 11:32:49 173937 [ERROR] Could not use /mariadb/mariadb-binlog/hxun.000369 for logging (error 0). Turning logging off for the whole duration of the MariaDB server process. To turn it on again: fix the cause, shutdown the MariaDB server and restart it.
|
2023-12-29 11:48:13 174188 [Warning] Access denied for user '' (using password: YES)
|
Attachments
Issue Links
- relates to
-
MDEV-37177 Turning logging off for the whole duration of the MariaDB server process. To turn it on again: fix the cause, shutdown the MariaDB server and restart it.
-
- Closed
-