Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

On my integration server, Centos 6.5 x64, on Maria DB 5.5.36.

We installed this server for our Java web services a few weeks ago, and everything was working fine.

From one day to another, without changing anything on MariaDB, the web services stopped working. The reason is that last_insert_id() always returns 0, despite id's auto increments working well!

I tried the command mysql_upgrade but nothing changed. I restarted the service, checked that no other connection was alive, I still have the issue...

How can I fix this?

share|improve this question
can you post some log ? –  Up_One Mar 14 '14 at 13:07

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.