Re: MariaDB on Windows: SELECT query with ROW_NUMBER() kills the MariaDB 10.6.4 service

On 21-8-2021 02:32, DFS wrote:
> $ net start MariaDB
> The MariaDB service is starting.......
> The MariaDB service was started successfully.
> 
> 
> $ mariadb -u DFS -p
> Enter password: *******
> Welcome to the MariaDB monitor.  Commands end with ; or \g.
> Your MariaDB connection id is 3
> Server version: 10.6.4-MariaDB mariadb.org binary distribution
> 
> Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the current input 
> statement.
> 
> 
> MariaDB [(none)]> use usenet;
> Database changed
> MariaDB [usenet]> SELECT ROW_NUMBER() OVER
>      -> (ORDER BY COUNT(POSTID) DESC, POSTERNAME) ROWNUM,
>      -> P3.POSTERNAME, COUNT(DISTINCT(P.POSTERID)) AS NYMS,
>      -> COUNT(POSTID) AS POSTS, COUNT(DISTINCT(UTCDATE)) AS DAYS_POSTED,
>      -> COUNT(POSTID) / COUNT(DISTINCT(UTCDATE)) AS POSTSPERDAY,
>      -> MAX(UTCDATE) AS LASTPOST
>      -> FROM POST P, POSTER P2, POSTERNAME P3
>      -> WHERE P.POSTERID = P2.POSTERID
>      -> AND P3.POSTERNAMEID = P2.POSTERNAMEID
>      -> AND P.GROUPID = 1
>      -> AND P3.POSTERNAMEID NOT IN (141,381,388)
>      -> AND P.UTCDATE >= '2003-07-01'
>      -> GROUP BY P3.POSTERNAME;
> (after 30 seconds)
> ERROR 2013 (HY000): Lost connection to server during query
> 
> MariaDB [usenet]> show tables;
> ERROR 2006 (HY000): Server has gone away
> No connection. Trying to reconnect...
> ERROR 2002 (HY000): Can't connect to server on 'localhost' (10061)
> ERROR: Can't connect to the server
> 
> unknown [usenet]>exit
> Bye
> 

Did you check the log file ?

(see: `show variables like 'log_error';`)