[Bug]: too large wal message error handle

### Is there an existing issue for the same bug?

- [X] I have checked the existing issues.

### Branch Name

main

### Commit ID

latest

### Other Environment Information

```Markdown
- Hardware parameters:
- OS type:
- Others:
```

### Actual Behavior

too large wal message error handle

### Expected Behavior

1. Catch it ASAP
2. If any error when appending, shink the TXN message as a small aborted log message and retry

### Steps to Reproduce

```Markdown
Make >100m wal log entry
```

### Additional information

_No response_