MariaDB 5.3.0 7 crash in 4 minutes

Asked by Gurvan

Dear,

Centos 5.6 64Bits, 1800 databases 25GB, MariaDB 5.3.0 less than 24h. (Upgrade 5.1.50 -> 5.3.0).

I have the same problem as https://bugs.launchpad.net/maria/+bug/759016
I sent a comment with several logs.

First crash report
mysqld: misc.cpp:103: int __cxa_pure_virtual(): Assertion `!"Aborted: pure virtual method called."' failed.
mysqld: misc.cpp:103: int __cxa_pure_virtual(): Assertion `!"Aborted: pure virtual method called."' failed.

Second crash report many information :

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x463c428): SELECT mc.*,
                                                CASE mc.time_present
                                                when "00:00:00" then NULL
                                                else DATE_FORMAT(mc.time_present, "%H:%i")
                                                END AS time_present, divhome.shortname divhome,
                                                divhome.id divhomeid,
                                                divaway.id divawayid,
                                                t1.name AS team1,
                                                        t2.name AS team2,
                                                        u.name AS editor,
                                                        (Select count(mp.id)
                                                         FROM jos_joomleague_match_player AS mp
                                                         WHERE mp.match_id = mc.id
                                                           AND (came_in=0 OR came_in=1)
                                                           AND mp.teamplayer_id in (
                                                             SELECT id
                                                             FROM jos_joomleague_team_player AS tp
                                                             WHERE tp.projectteam_id = mc.projectteam1_id
                                                           )
                                                         ) AS homeplayers_count,
                                                        (Select count(ms.id)
                                                         FROM jos_joomleague_match_staff AS ms
                                                         WHERE ms.match_id = mc.id
                                                           AND ms.team_staff_id in (
                                                             SELECT id
                                                             FROM jos_joomleague_team_staff AS ts
                                                             WHERE ts.projectteam_id = mc.projectteam1_id
                                                           )
                                                        ) AS homestaff_count,
                                                        (
Connection ID (thread ID): 13874
Status: NOT_KILLED
---

All other crash (except Seven crash) as the same log.

I moved the database and start MariaDB. It is again stable.
I will restart the database in a VM for many test but im not an expert.

Are there any special settings to do to get accurate information?

Thanks.

Question information

Language:
English Edit question
Status:
Answered
For:
MariaDB Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Sergei Golubchik (sergii) said :
#1

few comments:

1. This is not the same issue as https://bugs.launchpad.net/maria/+bug/759016 - it has a very different stack trace
2. could you please submit it as a separate bug report?
3. please mention the stack trace in the bug report (basically, what you've pasted to the comment to the bug 759016), but also
add a *complete query text* - you can see that query text was truncated in the crash report, we need to see it in full.

Revision history for this message
Philip Stoev (pstoev-askmonty) said :
#2

Hello,

The query reported is from the JoomLeague open source application, so I was able to obtain the entire query test. After simplification, it seems that there is a bug with CASE + datetime handling:

https://bugs.launchpad.net/maria/+bug/839387

Can you help with this problem?

Provide an answer of your own, or ask Gurvan for more information if necessary.

To post a message you must log in.