Derby Server and Hive Server2 services not starting

[Júlio Cesar]

Hello

Anyone can help me about services? Derby Server and Hive Server2 services not starting

My Computer:

Windows 10 Pro

16GB RAM

120GB SSD

[Aravindraja Thinakaran]

Hi Julio, 

Thank you for using Syncfusion products. 

 

Derby and Hive service may fail due to crashed or corrupted files of Metastore_db directory available in the below location. 

C:\Syncfusion\BigData\<version>\BigDataSDK\SDK\Derby\bin\metastore_db 

You can delete or rename the “metastore_db” directory and retry the service starting process. 

Now a new metastore_db will be created. 

Still if you are facing the same problem. Please share the following details to figure out the exact root cause. 

 

1.       Installed Big Data Platform version. 

2.       Log files in following locations. 

a.       C:\Syncfusion\BigData\<Installed Version>\BigDataSDK\Logs\ServiceManager\ 

b.       C:\Syncfusion\BigData\<Installed Version>\Agent\logs\InstallerAgent\ 

Thanks, 

Aravindraja T. 

[Júlio Cesar]

Hi again

rename and delete not working...

actually, doesnt exist the metastore_db directory

version of bigdata plataform: 3.1.0.25 (the version latest version occurs the same error)

Attachment: Logs_eefddd77.zip

[Aravindraja Thinakaran]

Hi Julio, 

We have checked the logs and found that system locale is Portuguese and Derby server is not started due to this locale settings. 

Please find the “startNetworkServer.bat” from the following link,  

http://www.syncfusion.com/downloads/support/forum/128977/7z/startNetworkServer-1181985370.7z  

and replace it in the following location and restart the services. 

C:\Syncfusion\BigData\<version>\BigDataSDK\SDK\Derby\bin\ 

Highlighted changes are new one that can be found in the file that we provided. 

startNetworkServer.bat 

:runNoClasspath 

"%_JAVACMD%" %DERBY_OPTS% -Dderby.ui.locale=en_US -classpath "%LOCALCLASSPATH%" org.apache.derby.drda.NetworkServerControl start %DERBY_CMD_LINE_ARGS% 

goto end 

 

:runWithClasspath 

"%_JAVACMD%" %DERBY_OPTS% -Dderby.ui.locale=en_US -classpath "%CLASSPATH%;%LOCALCLASSPATH%" org.apache.derby.drda.NetworkServerControl start %DERBY_CMD_LINE_ARGS% 

goto end 

Thanks, 

Aravindraja T. 

[Júlio Cesar]

Thanks, but now there is other errrors. Can you see the log and files attachment?

Attachment: errorSyncFusion20170221_fd78e548.7z

[Aravindraja Thinakaran]

Hi Julio,  

  

On analyzing the provided logs from your side, as we discussed earlier the reason for Hive Server failure is crashed or corrupted files of Metastore_db directory available in the below location.  

C:\Syncfusion\BigData\<version>\BigDataSDK\SDK\Derby\bin\metastore_db  

 

You can delete or rename the “metastore_db” directory and retry the service starting process.  

Now a new metastore_db will be created.  

 

Thanks,  

Aravindraja T.  

[Júlio Cesar]

Yes, I did it when you had mentioned it. Changing the derby command line solved some of the problem. The metastore_db directory did not even exist. I did not have to delete files or the metastore_db directory. Here is the image of the bin directory.

[Júlio Cesar]

the image.

Attachment: image_f437df88.7z

[Aravindraja Thinakaran]

Hi Julio, 

 

A support incident to track the status of your query has been already created under your account. Please log on to our support website to check for further updates,

https://www.syncfusion.com/account/login

Please let us know if you need further clarifications regarding this.  

 

Thanks, 

Aravindraja T.