Displaying #apache-syncope/2016-06-29.log:

Wed Jun 29 03:33:27 2016  tmess:Joined the channel
Wed Jun 29 06:07:09 2016  tmess:Joined the channel
Wed Jun 29 06:19:32 2016  tmess:Joined the channel
Wed Jun 29 06:57:51 2016  svizzero81:Joined the channel
Wed Jun 29 07:11:01 2016  fmartelli:Joined the channel
Wed Jun 29 07:46:05 2016  tmess:Joined the channel
Wed Jun 29 07:56:17 2016  JEV:Joined the channel
Wed Jun 29 07:57:33 2016  JEV:Joined the channel
Wed Jun 29 07:58:10 2016  JeffreyEverling:Joined the channel
Wed Jun 29 07:59:12 2016  JeffreyEverling:hello?
Wed Jun 29 08:26:31 2016  JeffreyEverling:I have a question regarding database tables for Apache Syncope, if I might :)
Wed Jun 29 08:27:15 2016  coheigea:Joined the channel
Wed Jun 29 08:49:28 2016  sberyozkin:Joined the channel
Wed Jun 29 08:56:24 2016  svizzero81:Joined the channel
Wed Jun 29 10:54:58 2016  svizzero81:Joined the channel
Wed Jun 29 11:00:47 2016  svizzero81:Joined the channel
Wed Jun 29 12:00:03 2016  tmess:Joined the channel
Wed Jun 29 12:01:15 2016  svizzero81:Joined the channel
Wed Jun 29 12:05:46 2016  svizzero81:Hi Jeffrey, you can write your question here or in mailing list
Wed Jun 29 12:17:49 2016  giacomolm:Joined the channel
Wed Jun 29 12:26:49 2016  JeffreyEverling:awesome!
Wed Jun 29 12:29:32 2016  svizzero81:now, what's your question
Wed Jun 29 12:29:34 2016  svizzero81:???
Wed Jun 29 12:34:09 2016  JeffreyEverling:I noticed the following... Syncope creates a set of tables, but these are created as lowercase. But when creating a pull task
Wed Jun 29 12:34:17 2016  JeffreyEverling:yeah sorry had to boot my vm again
Wed Jun 29 12:34:21 2016  JeffreyEverling:it is incoming now :)
Wed Jun 29 12:34:46 2016  JeffreyEverling:ok so when creating a pull task I received the following error: org.apache.syncope.common.lib.SyncopeClientException: Scheduling [Failure obtaining db row lock: Table 'syncope.QRTZ_LOCKS' doesn't exist {prepstmnt 986440094 SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME = 'scheduler' AND LOCK_NAME = ? FOR UPDATE} [code=1146, state=42S02]]
Wed Jun 29 12:35:05 2016  JeffreyEverling:As you can see here the table is called for in uppercase
Wed Jun 29 12:35:13 2016  JeffreyEverling:and therefore it cannot find the requested table
Wed Jun 29 12:36:51 2016  tmess:Joined the channel
Wed Jun 29 12:47:04 2016  svizzero81:which db?oracle, mysql, ....
Wed Jun 29 12:48:58 2016  JeffreyEverling:sorry it is installed on mysql
Wed Jun 29 12:49:53 2016  tmess:Joined the channel
Wed Jun 29 12:49:59 2016  JeffreyEverling:let me check the version
Wed Jun 29 12:51:31 2016  JeffreyEverling:mysql-server.x86_64 5.1.73-7.el6 on CentOS release 6.8 (Final)
Wed Jun 29 12:53:26 2016  svizzero81:your mysql is a bit outdated :)
Wed Jun 29 12:54:11 2016  JeffreyEverling:oh did not realize that, it is the newest from the repo
Wed Jun 29 12:55:27 2016  JeffreyEverling:but I read that the case sensitivity is default behaviour of MySQL on Unix system, do you think that updating MySQL will fix the issue?
Wed Jun 29 12:59:53 2016  jbonofre:Joined the channel
Wed Jun 29 13:00:39 2016  svizzero81:our tests using the latest versions of MySQL(5.5 and 5.6)
Wed Jun 29 13:01:32 2016  svizzero81:you create the pull task from the console, or when load the master content at startup?
Wed Jun 29 13:03:07 2016  JeffreyEverling:it happens when I create the pull task from the console, when clicking finish
Wed Jun 29 13:07:59 2016  svizzero81:ok, can you update mysql?
Wed Jun 29 13:28:57 2016  JeffreyEverling:yeah sure let me find out how to do that (not an expert on this)
Wed Jun 29 13:40:24 2016  JeffreyEverling:hmm
Wed Jun 29 13:40:28 2016  JeffreyEverling:I am now on 5.5
Wed Jun 29 13:40:33 2016  JeffreyEverling:but still the same error
Wed Jun 29 13:41:02 2016  JeffreyEverling:| qrtz_fired_triggers |
Wed Jun 29 13:41:02 2016  JeffreyEverling:| qrtz_locks |
Wed Jun 29 13:41:02 2016  JeffreyEverling:| qrtz_paused_trigger_grps |
Wed Jun 29 13:41:04 2016  JeffreyEverling:| qrtz_scheduler_state
Wed Jun 29 13:41:08 2016  JeffreyEverling:these are the tables
Wed Jun 29 13:41:58 2016  JeffreyEverling:org.apache.syncope.common.lib.SyncopeClientException: Scheduling [Failure obtaining db row lock: Table 'syncope.QRTZ_LOCKS' doesn't exist {prepstmnt 1156556661 SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME = 'scheduler' AND LOCK_NAME = ? FOR UPDATE} [code=1146, state=42S02]] << error is still the same
Wed Jun 29 13:42:03 2016  svizzero81:your jdbc driver version?
Wed Jun 29 13:43:33 2016  svizzero81:and syncope version?
Wed Jun 29 13:45:52 2016  JeffreyEverling:mysql-connector-java-5.1.39-bin.jar
Wed Jun 29 13:46:13 2016  JeffreyEverling:syncope version: syncope-2.0.0-M2
Wed Jun 29 13:47:02 2016  JeffreyEverling:I have created a screenshot if you would like to have it, let me know where to send it
Wed Jun 29 13:49:50 2016  svizzero81:I'm creating an enviroment and try to reproduce your error
Wed Jun 29 13:51:39 2016  JeffreyEverling:thank you for your help!
Wed Jun 29 13:56:58 2016  tmess:Joined the channel
Wed Jun 29 14:24:04 2016  JeffreyEverling:i will be heading home in a minute. Shall we continue this conversation through E-mail?
Wed Jun 29 14:30:57 2016  svizzero81: i'm reproducing your error, I will open an issue
Wed Jun 29 14:34:08 2016  JeffreyEverling:ok, can you let me know where to track it?
Wed Jun 29 14:41:29 2016  svizzero81:https://issues.apache.org/jira/browse/SYNCOPE-885?jql=project%20%3D%20SYNCOPE
Wed Jun 29 14:41:47 2016  svizzero81:I will open tomorrow a new issue
Wed Jun 29 14:46:02 2016  JeffreyEverling:okee thank you very much. Have a nice evening
Wed Jun 29 15:19:07 2016  giacomolm1:Joined the channel
Wed Jun 29 15:23:18 2016  giacomolm:Joined the channel
Wed Jun 29 15:30:18 2016  giacomolm:Joined the channel
Wed Jun 29 15:36:57 2016  giacomolm:Joined the channel
Wed Jun 29 15:49:27 2016  svizzero81:JeffreyEverling: please check your provisioning.properties and change this properties: quartz.jobstore=org.quartz.impl.jdbcjobstore.StdJDBCDelegate
Wed Jun 29 15:49:27 2016  svizzero81:quartz.sql=tables_mysql.sql (if innodb tables_mysql_innodb.sql) quartz.scheduler.idleWaitTime=5000
Wed Jun 29 15:50:04 2016  svizzero81:take a look https://github.com/apache/syncope/blob/master/fit/core-reference/src/main/resources/mysql/provisioning.properties#L29-L31
Wed Jun 29 17:01:19 2016  fmartelli:Joined the channel
Wed Jun 29 17:35:04 2016  coheigea:Left the channel
Wed Jun 29 19:07:29 2016  JeffreyEverling:Joined the channel
Wed Jun 29 21:03:42 2016  jbonofre:Joined the channel
Wed Jun 29 22:44:02 2016  tmess:Joined the channel

Comments