Query Logging - ProxySQl does not increase the event log file counter.

[Slawek Korwel]

So my issue is strange. Becuase whenever my query log file hits 100M proxysql creates it again from scratch with the same.000001 number 

| 2024-04-13 05:43:51 [INFO] Starting new mysql event log file /var/lib/proxysql/logs/queries.log.00000001

| 2024-04-13 05:46:03 [INFO] Starting new mysql event log file /var/lib/proxysql/logs/queries.log.00000001 

| 2024-04-13 05:51:48 [INFO] Starting new mysql event log file /var/lib/proxysql/logs/queries.log.00000001

And I have all the time the same number 00000001. 

What am I missing?

[René Cannaò]

Probably readdir() is failing, and proxysql cannot read the directory it is writing to.

My guess is that either you have a permission issue, or some other issue at filesystem level.

Please share with everyone your findings 

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/proxysql/49dcf013-4cdf-46c3-9cf5-cf1527eca063n%40googlegroups.com.

[René Cannaò]

Hi Slawek,

I just noticed all your messages were automatically moderated, I manually approved them right now.

To answer your previous question:

A file can be created if a process has write permission on a directory, but to read the files on the same directory the process needs read permission.

About absolute and relative paths, they should both work, but ...

Proxysql considers a relative path just as a filename, not a directory+filename.

This is not an expected limitation, and we will work on improving it.

Thank you for reporting the problem and the solution.

Sincerely,

René

On Tue, 16 Apr 2024, 18:49 Slawek Korwel, <sko...@auxiant.com> wrote:

The reason was a wrong 'eventslog-filename' setting. I had a filename with a relative path to the subfolder. When I changed it to be absolute it started to work normally. Thanks. 

To view this discussion on the web visit https://groups.google.com/d/msgid/proxysql/9ed55428-317b-4fed-bb3d-4a32a4d1b418n%40googlegroups.com.