Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-33140

transaction failed and "flush logs" statement failed. Could not use for logging (error 2)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • None
    • N/A
    • Replication
    • 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

        Activity

          People

            Roel Roel Van de Paar
            MurthyRamachandrula R S N Murthy
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.