Where to post an Aurora MySQL bug which lead to a segmentation fault?

Question

Hi, I've been able to cause a segmentation fault and crash Aurora (  5.6.mysql_aurora.1.23.2 )  - two difference instances with an accidental misuse of SUBSTRING() with a zero index, meant to be 1.

`/etc/rds/oscar-start-cmd: line 39: 34079 Segmentation fault (core dumped) /rdsdbbin/oscar/bin/mysqld --core-file --innodb_shared_buffer_pool_uses_huge_pages='1' "$@" `

Where's the best place to log that with the Aurora team?

The query which did it wasn't particularly complex:

```
SELECT 
    substring(ba.BSB, 0, 2) as bsbBankNum,
    count(distinct c.Id) as Portfolios
FROM
    Customer C
     inner join BankAccount ba on ba.CustomerId = c.Id
WHERE
    C.DataSetType = 'Subscription'
        AND C.SubscriptionStatus NOT IN ('Trial' , 'TrialExpired', 'Cancelled')
group by substring(ba.BSB, 0, 2)

```

Answer

The query seems very benign, without looking at logs its hard to tell what exactly is causing the segmentation fault. Your best option is to open a ticket with support, could be something peculiar to your environment or the version  that you are using or a combination of both or some other factors.

Where to post an Aurora MySQL bug which lead to a segmentation fault?

相关内容