/ Register

Get the most out of your Centmin Mod LEMP stack
Become a Member

MariaDB MariaDB 10.1.22 now available

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Mar 15, 2017.

Previous Thread Next Thread
Loading...
Page 1 of 2
  1. Mar 15, 2017 #1
    eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    9:47 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.22. This is a Stable (GA) release. See the release notes and changelog for details. Download MariaDB 10.1.22 Release Notes Changelog What is MariaDB 10.1? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!

    The post MariaDB 10.1.22 now available appeared first on MariaDB.org.

    Security update it seems
    Continue reading...
     
    Last edited: Mar 15, 2017
  2. Mar 15, 2017 #2
    Sunka

    Sunka Well-Known Member

    1,150
    325
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +525
    Local Time:
    1:47 PM
    Nginx 1.17.9
    MariaDB 10.3.22
    Updated, everything looking OK

    Code:
    [root@upcloud ~]# mysql -v     
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 177
Server version: 10.1.22-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Reading history-file /root/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
     
  3. Mar 15, 2017 #3
    eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    9:47 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    nice

    security update it seems
    CVE-2017-3313
    CVE-2017-3302
     
  4. Mar 15, 2017 #4
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    2:47 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    Code:
      Updating   : MariaDB-server-10.1.22-1.el7.centos.x86_64                                                                                                                                                                                                               22/74
warning: /etc/logrotate.d/mysql saved as /etc/logrotate.d/mysql.rpmsave
libsemanage.map_file: Unable to open /usr/share/mysql/policy/selinux/mariadb.pp
 (No such file or directory).
libsemanage.semanage_direct_install_file: Unable to read file /usr/share/mysql/policy/selinux/mariadb.pp
 (No such file or directory).
/usr/sbin/semodule:  Failed on /usr/share/mysql/policy/selinux/mariadb.pp!

    Updated and all was ok but i got this when upgrading .....
     
  5. Mar 15, 2017 #5
    eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    9:47 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    i think it's reporting missing SELinux policy files *.pp is because Centmin Mod recommends disabling SELinux so SELinux isn't on our systems so doesn't apply to us. Though i am not seeing or finding any mariadb.pp files in RPM packages installed so maybe MariaDB left those out ? Still would be irrelevant to us as SELinux is disabled.
     
  6. Mar 16, 2017 #6
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    2:47 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    This version and the previous seems to have some issues with my IPB forums as it is crashing every 1-3 days :(

    Never had that issue :(

    Maybe a specific query cause that issue ?

    @Revenge
    @Jimmy

    As i know you are using IPB also .... did you notice anything related?

    Now i am looking also for a monitoring service for server software like MariaDB if not working to get an alert .... any ideas?As most monitoring solutions check the server only and not the apps..

    Thanks
     
    Last edited: Mar 16, 2017
  7. Mar 16, 2017 #7
    Sunka

    Sunka Well-Known Member

    1,150
    325
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +525
    Local Time:
    1:47 PM
    Nginx 1.17.9
    MariaDB 10.3.22
    Did you install this before?
     
  8. Mar 16, 2017 #8
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    2:47 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    I will check it Sunka thanks :)
     
  9. Mar 16, 2017 #9
    Sunka

    Sunka Well-Known Member

    1,150
    325
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +525
    Local Time:
    1:47 PM
    Nginx 1.17.9
    MariaDB 10.3.22
    I have this to check out in pushover_process_list.txt file
    Code:
    /usr/local/etc/php-fpm.conf
lfd
/usr/local/sbin/nginx
/usr/bin/redis-server
/bin/java
/usr/sbin/mysqld
crond
     
  10. Mar 16, 2017 #10
    eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    9:47 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    symptoms ? exact error messages ? You might want to report them or search for issues on official MariaDB issue tracker at https://jira.mariadb.org/projects/MDEV/issues
     
  11. Mar 16, 2017 #11
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    2:47 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    Even a small IPB forum with less than 10 users online that never had any issues start getting a ton of 502 errors and i thought that something was related to phpfpm and i didn't find anything related and even restarting it doesn't work....

    Server load was 0,7 and the software on the server was using very low resources like mysql: 70% phpfpm: 20% nginx: 7%

    Not exact numbers but i remember that total was not used even 1 core and the server had a lot of free cpu and ram and it uses an ssd disk....

    I then try to restart MAriaDB and got about 4x times more to do so and then all was working great....

    Didn't check the show details to see what is going on and why was not responding and now i am looking for the next time that it will be in less than a day to monitor/find what's the issue.... I need an advice for this please.

    I thought also that cloudflare may cause it but no changes applied the past 2-3 days.....

    And the issue persist at all 5 IPB forums of mine and friends :(

    Thank you
     
  12. Mar 16, 2017 #12
    eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    9:47 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    Doesn't sound like MariaDB server crashing, but your mysql server was busy/loaded and caused php-fpm to timeout waiting for mysql server to respond which in turn caused nginx to return 502 as php-fpm timed out. Forcefully restarting MariaDB MySQL server (not advisable as you can corrupt your mysql data !) just cleared the mysql process/activity and didn't solve the real problem - the mysql process load. That doesn't rule out a MariaDB bug as it could cause slow processing of queries etc but more likely the former explanation by me is the reason. You need to troubleshoot and analyse your MySQL process/queries including enabling mysql slow query logging. Something left to end users to do.

    You can check your mysql error log which is listed along with all other log file locations as per How to troubleshoot Centmin Mod initial install issues (/var/log/mysqld.log) for clues. Server logs at FAQ 19 at Centmin Mod FAQ - Menu based Nginx installer
     
  13. Mar 16, 2017 #13
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    2:47 PM
    Nginx-1.29.x
    MariaDB 10.6.x
  14. Mar 16, 2017 #14
    eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    9:47 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    yeah if you register an account on MariaDB Jira site, you can subscribe and watch those bug issues so get alerted on status etc
     
  15. Mar 16, 2017 #15
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    2:47 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    I think the MariaDB optimizer may has an issue.....

    @Revenge was reported a month ago back a related issue with a query from IPB that the MariaDB optimizer was convert it to a real issue....
     
  16. Mar 16, 2017 #16
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    2:47 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    Just register but can't find where i must enable subscription to get notifications for bugs for MariaDB 10.1.x ...

    Any ideas? :)
     
  17. Mar 16, 2017 #17
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    2:47 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    Now i manage to produce it when i want so i may find something :)

    When a user try to open the admin control panel it gives that 502 error and if not then when he try to login there it will.....

    And that forum doesn't have even 10 users online and was never had any issues and i start to think that it may caused by a php upgrade maybe and not MariaDB but i am not sure as that seems very specific and if the user navigate to another page it works but on the other servers if i don't restart MariaDB it will not work.....

    :(

    Can a blocked Cloudflare cause this?

    From php logs i can see this:

    Code:
    failed (104: Connection reset by peer) while reading response header from upstream
     
    Last edited: Mar 16, 2017
  18. Mar 16, 2017 #18
    eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    9:47 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
  19. Mar 16, 2017 #19
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    2:47 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    Ok thanks :)

    I will try to find something and then i will post :)

    One last question for my case .... is there a way to check from ssh if phpfpm is not responding or if MariaDB is the one that is not responding?
     
  20. Mar 16, 2017 #20
    eva2000

    eva2000 Administrator Staff Member

    58,923
    12,491
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,123
    Local Time:
    9:47 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    question for another thread ;)

    but php-fpm status enabling and log checks and mysql log and process list checks including enabling mysql slow query logs

    Code (Text):
    curl -s 127.0.0.1/phpstatus
pool:                 www
process manager:      ondemand
start time:           15/Mar/2017:17:24:34 +0000
start since:          16468
accepted conn:        1
listen queue:         0
max listen queue:     0
listen queue len:     8151
idle processes:       0
active processes:     1
total processes:      1
max active processes: 1
max children reached: 0
slow requests:        0


    they will give info for you to determine if it's mysql or php related or both
     
Previous Thread Next Thread
Loading...
Page 1 of 2

.