Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

night.fall.ff06_179503 avatar image
night.fall.ff06_179503 asked ·

alwayson-sql service keeps restarting

Hi experts


I'm having this strange problem with always-sql, as it get into "KILLED" state and keep on restaring.

I followd the document and grant required permission for the auth_user: gdt_dsefs


This is what i found in the service log:

Screenshot from the Spark Master

analyticsalwayson-sql
1573445452668.png (91.4 KiB)
1573445734169.png (145.3 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

AlexLiu avatar image
AlexLiu answered ·

AlwaysOn SQL has an app log file service.log which has more information about the error during AlwaysOn SQL starts up. If it couldn't startup correctly, DSE automatically restart it. Most likely some error logs are in service.log file

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.