Solr 7.7.0: Log file not getting generated

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

Solr 7.7.0: Log file not getting generated

Paresh
Hi,

We just moved to Solr 7.7.0 and log file is not getting generated. Even log
folder is not present there.

I manually enabled all the logs through Solr-admin UI but it is not working.

Is there any other way to enable the logs and how can we enable it at the
start of Solr?

Any help is appreciated.

Thanks,
Paresh



--
Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html
Reply | Threaded
Open this post in threaded view
|

Re: Solr 7.7.0: Log file not getting generated

Paras Lehana
Hey Paresh,

Please see permanent logging in Configuring Logging
<https://lucene.apache.org/solr/guide/7_7/configuring-logging.html#permanent-logging-settings>.
Check what is your log directory.

On Mon, 11 Nov 2019 at 12:27, Paresh <[hidden email]> wrote:

> Hi,
>
> We just moved to Solr 7.7.0 and log file is not getting generated. Even log
> folder is not present there.
>
> I manually enabled all the logs through Solr-admin UI but it is not
> working.
>
> Is there any other way to enable the logs and how can we enable it at the
> start of Solr?
>
> Any help is appreciated.
>
> Thanks,
> Paresh
>
>
>
> --
> Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html
>


--
--
Regards,

*Paras Lehana* [65871]
Development Engineer, Auto-Suggest,
IndiaMART Intermesh Ltd.

8th Floor, Tower A, Advant-Navis Business Park, Sector 142,
Noida, UP, IN - 201303

Mob.: +91-9560911996
Work: 01203916600 | Extn:  *8173*

--
IMPORTANT: 
NEVER share your IndiaMART OTP/ Password with anyone.
Reply | Threaded
Open this post in threaded view
|

Re: Solr 7.7.0: Log file not getting generated

Paresh
Thanks Paras. It solved my problem. I am now able to see the logs.



--
Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html
Reply | Threaded
Open this post in threaded view
|

Re: Solr 7.7.0: Log file not getting generated

Paras Lehana
Hi Paresh,

Glad that it worked. For the sake of future views, please try to explain
how it worked and what you did. It will help users having similar issues in
future.

On Mon, 11 Nov 2019 at 14:32, Paresh <[hidden email]> wrote:

> Thanks Paras. It solved my problem. I am now able to see the logs.
>
>
>
> --
> Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html
>


--
--
Regards,

*Paras Lehana* [65871]
Development Engineer, Auto-Suggest,
IndiaMART Intermesh Ltd.

8th Floor, Tower A, Advant-Navis Business Park, Sector 142,
Noida, UP, IN - 201303

Mob.: +91-9560911996
Work: 01203916600 | Extn:  *8173*

--
IMPORTANT: 
NEVER share your IndiaMART OTP/ Password with anyone.
Reply | Threaded
Open this post in threaded view
|

Re: Solr 7.7.0: Log file not getting generated

Paresh
In my environment I was creating a windows service for Solr and there I
forgot to specify -Dsolr.log.dir as a command line for Windows Service.
After defining it to correct path and reinstalling solr as service solved
the issue.



--
Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html
Reply | Threaded
Open this post in threaded view
|

Re: Solr 7.7.0: Log file not getting generated

Paresh
How can we see SQL in log file?



--
Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html
Reply | Threaded
Open this post in threaded view
|

Re: Solr 7.7.0: Log file not getting generated

Paras Lehana
Hey Paresh,

I have never worked with "SQL". Did you mean DIH logging? A simple google
search yields this:
https://grokbase.com/t/lucene/solr-user/12618pmah7/how-to-show-dih-query-sql-in-log-file

Turn the Solr logging level to "FINE" for the DIH packages/classes and
they will
> show up in the log.


On Mon, 11 Nov 2019 at 16:39, Paresh <[hidden email]> wrote:

> How can we see SQL in log file?
>
>
>
> --
> Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html
>


--
--
Regards,

*Paras Lehana* [65871]
Development Engineer, Auto-Suggest,
IndiaMART Intermesh Ltd.

8th Floor, Tower A, Advant-Navis Business Park, Sector 142,
Noida, UP, IN - 201303

Mob.: +91-9560911996
Work: 01203916600 | Extn:  *8173*

--
IMPORTANT: 
NEVER share your IndiaMART OTP/ Password with anyone.
Reply | Threaded
Open this post in threaded view
|

Re: Solr 7.7.0: Log file not getting generated

Paresh
This post was updated on .
Hi Paras,

I have db-data-config.xml file with entities defined for data population and
update.

As a part of some process, I want to delete the documents from Solr for data
deleted in RDBMS. For this purpose I am writing SQL to fetch data from RDBMS
and delete it in Solr using $deleteDocByQuery.

I want to debug if the query getting formed is correct or not -

Here is the snippet of entity -

        <entity name="delete_docs" pk="ID" query="SELECT CONCAT(
'SolrFieldName:', dbColumnName ) AS &amp;quot;$deleteDocByQuery&amp;quot;
FROM DBTableName t1 WHERE t1.pstate = 1 AND t1.plast_modified_date &amp;gt;
TO_DATE ('${dih.last_index_time}','YYYY-MM-DD HH24:MI:SS')">
            <field column="ID" name="id"/>
            <field column="PRODUCT"
name="TC_0Y0_ProductScope_0Y0_product_uid"/>
        </entity>

The said entity, I am not able to delete the docs from solr using
delta-import operation, so wanted to debug it.

And the supported log types are not having FINE -
ALL
TRACE
DEBUG
INFO
WARN
ERROR
FATAL
OFF

I tried ALL but not getting SQL logs for this.

Any help on deleteDocsByQuery is also appreciated as there is no documentation on how to get this done.

Regards,
Paresh



--
Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html