Grouper Users - Open Discussion List

[Shilen Patel <>]

Try removing the ‘BEQUEATH DEFINER’ from that statement?

Thanks!

- Shilen

On 1/25/19, 7:46 PM, "Baron Fujimoto" <> wrote:

    Thanks, this looks promising. I got as far as running 
edu.internet2.middleware.grouper.misc.SyncPITTables().syncAllPITTables(), but 
encountered syntax errors[*] trying to create GROUPER_CHANGE_LOG_TEMP_V... 
possibly due to our older version of MySQL. I'll see if I can sort them out 
and find workarounds to continue.
    
    [*] E.g.:
    
    ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check 
the manual that corresponds to your MySQL server version for the right syntax 
to use near 'BEQUEATH DEFINER
    AS
    SELECT gcle.created_on,
    gclt.change_log_categor' at line 33
    
    
    On Fri, Jan 25, 2019 at 08:16:10PM +0000, Shilen Patel wrote:
    >Does it seem like this issue?
    >
    
>https://urldefense.proofpoint.com/v2/url?u=https-3A__spaces.at.internet2.edu_display_Grouper_Change-2Blog-2Band-2Bpoint-2Bin-2Btime-2Bordering-2Bissue&d=DwIDaQ&c=imBPVzF25OnBgGmVOlcsiEgHoG1i6YHLR0Sj_gZ4adc&r=sWqutME58phurE0oO57Icg&m=evpk0uCTtJqo91Lycfe_5dNknKKKHgfuGSyRKX77K08&s=Z0VnNzLp1zSaYEJt9r6mCwBRYrMs_oKNs4tEEA-LA88&e=
    >
    >If so, it was fixed in a 2.3 patch.  But the wiki tells you how to 
update the timestamp in the temp changelog to get past it if you don’t have 
the patch.
    >
    >- Shilen
    >
    >On 1/25/19, 2:57 PM, " on behalf of 
Baron Fujimoto" < on behalf of 
> wrote:
    >
    >    Every so often when running 
loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog") from gsh, we encounter 
errors aprently due to table/entry inconsistencies that I have to manually 
try to hunt down and clean up (I don't know what the root cause of these 
inconsistencies might be).
    >    
    >    Today, the current exception is:
    >    
    >    // Error: unable to evaluate command: Sourced file: inline 
evaluation of: ``loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog");'' : 
Error invoking compiled command: : Error in compiled command: 
java.lang.RuntimeException: java.lang.RuntimeException: Active PITMember with 
sourceId=4d799e6a04594a128af363db89478f3b not found,
    >    Problem in HibernateSession: HibernateSession (4087f108): new, 
notReadonly, READ_WRITE_NEW, notActiveTransaction, session (1e769d81)
    >    
    >    I'm not sure where to find this offending entry though. I've 
attempted to search the grouper_pit_* tables for a source_id column with that 
value without success, but perhaps/probably it's in some other table under 
different column that is being used as the source_id? Any tips tracking this 
down?
    
    -- 
    Baron Fujimoto <> :: UH Information Technology Services
    minutas cantorum, minutas balorum, minutas carboratum desendus pantorum