JabberIqRegister TigaseDBException for user 小\uD…\uD…@jabber.today (#1304)

Open

Activities

wojciech.kapcia@tigase.net opened 3 years ago

[2021-12-10 00:04:12:168] [WARNING ] [jabber:iq:register-proc-0 ] JabberIqRegister.process()    : Database problem: tigase.db.TigaseDBException: Problem accessing repository for user: 小\uD…\uD…@jabber.today

wojciech.kapcia@tigase.net commented 3 years ago

Complete log:

[2021-12-10 00:04:12:157] [FINEST  ] [jabber:iq:register-proc-0 ] ClientConnectionManager.processSocketData(): Processing socket data: from=null, to=null, serverAuthorisedStanzaFrom=Optional.empty, DATA=<iq type="set" to="jabber.today" id="3EEC6D7F-AF00-4F29-8939-F46EF21BD7B2"><query xmlns="jabber:iq:register"><x type="submit" xmlns="jabber:x:data"><title>Account Registration</title><instructions>Please provide the following information to sign up for an account

Please also provide your e-mail address (must be valid!) to which we will send confirmation link.</instructions><field type="hidden" var="FORM_TYPE"><value>jabber:iq:register</value></field><field type="text-single" label="Username" var="username"><required/><value>小\uD83D\uDCA1</value></field><field type="text-private" label="Password" var="password"><required/><value>wjqzjut885160</value></field><field type="text-single" label="Email (MUST BE VALID!)" var="email"><required/><value>wjqzjut@sina.com</value></field></x></query></iq>, SIZE=792, XMLNS=null, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=set, STABLE_ID=null from connection: c2s@ip-172-31-38-91.us-west-2.compute.internal/172.27.0.2_5222_172.31.10.109_4756
[2021-12-10 00:04:12:157] [FINEST  ] [jabber:iq:register-proc-0 ] ClientConnectionManager.processSocketData(): XMLNS set for packet: from=null, to=null, serverAuthorisedStanzaFrom=Optional.empty, DATA=<iq type="set" to="jabber.today" xmlns="jabber:client" id="3EEC6D7F-AF00-4F29-8939-F46EF21BD7B2"><query xmlns="jabber:iq:register"><x type="submit" xmlns="jabber:x:data"><title>Account Registration</title><instructions>Please provide the following information to sign up for an account

Please also provide your e-mail address (must be valid!) to which we will send confirmation link.</instructions><field type="hidden" var="FORM_TYPE"><value>jabber:iq:register</value></field><field type="text-single" label="Username" var="username"><required/><value>小\uD83D\uDCA1</value></field><field type="text-private" label="Password" var="password"><required/><value>wjqzjut885160</value></field><field type="text-single" label="Email (MUST BE VALID!)" var="email"><required/><value>wjqzjut@sina.com</value></field></x></query></iq>, SIZE=814, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=set, STABLE_ID=null from connection: c2s@ip-172-31-38-91.us-west-2.compute.internal/172.27.0.2_5222_172.31.10.109_4756
[2021-12-10 00:04:12:157] [FINEST  ] [jabber:iq:register-proc-0 ] MessageRouter.processPacket() : Processing packet: from=c2s@ip-172-31-38-91.us-west-2.compute.internal/172.27.0.2_5222_172.31.10.109_4756, to=sess-man@ip-172-31-38-91.us-west-2.compute.internal, serverAuthorisedStanzaFrom=Optional.empty, DATA=<iq type="set" to="jabber.today" xmlns="jabber:client" id="3EEC6D7F-AF00-4F29-8939-F46EF21BD7B2"><query xmlns="jabber:iq:register"><x type="submit" xmlns="jabber:x:data"><title>Account Registration</title><instructions>Please provide the following information to sign up for an account

Please also provide your e-mail address (must be valid!) to which we will send confirmation link.</instructions><field type="hidden" var="FORM_TYPE"><value>jabber:iq:register</value></field><field type="text-single" label="Username" var="username"><required/><value>小\uD83D\uDCA1</value></field><field type="text-private" label="Password" var="password"><required/><value>wjqzjut885160</value></field><field type="text-single" label="Email (MUST BE VALID!)" var="email"><required/><value>wjqzjut@sina.com</value></field></x></query></iq>, SIZE=814, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=LOCAL, TYPE=set, STABLE_ID=7ac65f20-9a01-4308-beb5-ea31a2ac13db
[2021-12-10 00:04:12:157] [FINEST  ] [jabber:iq:register-proc-0 ] MessageRouter.getLocalComponent(): Called for : jabber.today
[2021-12-10 00:04:12:158] [FINEST  ] [jabber:iq:register-proc-0 ] MessageRouter.getLocalComponent(): No componentID matches (fast lookup against exact address): jabber.today, for map: [s2s@ip-172-31-38-91.us-west-2.compute.internal, socks5@ip-172-31-38-91.us-west-2.compute.internal, pubsub@ip-172-31-38-91.us-west-2.compute.internal, amp@ip-172-31-38-91.us-west-2.compute.internal, muc@ip-172-31-38-91.us-west-2.compute.internal, push@ip-172-31-38-91.us-west-2.compute.internal, http@ip-172-31-38-91.us-west-2.compute.internal, message-router@ip-172-31-38-91.us-west-2.compute.internal, vhost-man@ip-172-31-38-91.us-west-2.compute.internal, sess-man@ip-172-31-38-91.us-west-2.compute.internal, c2s@ip-172-31-38-91.us-west-2.compute.internal, ext@ip-172-31-38-91.us-west-2.compute.internal, eventbus@ip-172-31-38-91.us-west-2.compute.internal, cl-comp@ip-172-31-38-91.us-west-2.compute.internal, bosh@ip-172-31-38-91.us-west-2.compute.internal, ext-disco@ip-172-31-38-91.us-west-2.compute.internal, stats@ip-172-31-38-91.us-west-2.compute.internal, ws2s@ip-172-31-38-91.us-west-2.compute.internal, upload@ip-172-31-38-91.us-west-2.compute.internal, monitor@ip-172-31-38-91.us-west-2.compute.internal, cluster-contr@ip-172-31-38-91.us-west-2.compute.internal, message-archive@ip-172-31-38-91.us-west-2.compute.internal, mix@ip-172-31-38-91.us-west-2.compute.internal]; trying VHost lookup
[2021-12-10 00:04:12:158] [FINEST  ] [jabber:iq:register-proc-0 ] MessageRouter.getLocalComponent(): No component name matches (VHost lookup against component name): jabber.today, for map: [ext, vhost-man, c2s, amp, upload, monitor, ws2s, bosh, push, cl-comp, socks5, ext-disco, s2s, stats, eventbus, http, muc, sess-man, message-archive, cluster-contr, mix, message-router, pubsub], for all VHosts: [hosts count: 35]; trying other forms of addressing
[2021-12-10 00:04:12:158] [FINEST  ] [jabber:iq:register-proc-0 ] MessageRouter.getLocalComponent(): Component match failed: jabber.today, for comp: [ext, vhost-man, c2s, amp, upload, monitor, ws2s, bosh, push, cl-comp, socks5, ext-disco, s2s, stats, eventbus, http, muc, sess-man, message-archive, cluster-contr, mix, message-router, pubsub], basename: today
[2021-12-10 00:04:12:158] [FINEST  ] [jabber:iq:register-proc-0 ] MessageRouter.getLocalComponent(): Called for : sess-man@ip-172-31-38-91.us-west-2.compute.internal
[2021-12-10 00:04:12:158] [FINEST  ] [jabber:iq:register-proc-0 ] MessageRouter.processPacket() : 1. Packet will be processed by: sess-man@ip-172-31-38-91.us-west-2.compute.internal, from=c2s@ip-172-31-38-91.us-west-2.compute.internal/172.27.0.2_5222_172.31.10.109_4756, to=sess-man@ip-172-31-38-91.us-west-2.compute.internal, serverAuthorisedStanzaFrom=Optional.empty, DATA=<iq type="set" to="jabber.today" xmlns="jabber:client" id="3EEC6D7F-AF00-4F29-8939-F46EF21BD7B2"><query xmlns="jabber:iq:register"><x type="submit" xmlns="jabber:x:data"><title>Account Registration</title><instructions>Please provide the following information to sign up for an account

Please also provide your e-mail address (must be valid!) to which we will send confirmation link.</instructions><field type="hidden" var="FORM_TYPE"><value>jabber:iq:register</value></field><field type="text-single" label="Username" var="username"><required/><value>小\uD83D\uDCA1</value></field><field type="text-private" label="Password" var="password"><required/><value>wjqzjut885160</value></field><field type="text-single" label="Email (MUST BE VALID!)" var="email"><required/><value>wjqzjut@sina.com</value></field></x></query></iq>, SIZE=814, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=LOCAL, TYPE=set, STABLE_ID=7ac65f20-9a01-4308-beb5-ea31a2ac13db
[2021-12-10 00:04:12:158] [FINEST  ] [jabber:iq:register-proc-0 ] SessionManagerClustered.processPacket(): Received packet: from=c2s@ip-172-31-38-91.us-west-2.compute.internal/172.27.0.2_5222_172.31.10.109_4756, to=sess-man@ip-172-31-38-91.us-west-2.compute.internal, serverAuthorisedStanzaFrom=Optional.empty, DATA=<iq type="set" to="jabber.today" xmlns="jabber:client" id="3EEC6D7F-AF00-4F29-8939-F46EF21BD7B2"><query xmlns="jabber:iq:register"><x type="submit" xmlns="jabber:x:data"><title>Account Registration</title><instructions>Please provide the following information to sign up for an account

Please also provide your e-mail address (must be valid!) to which we will send confirmation link.</instructions><field type="hidden" var="FORM_TYPE"><value>jabber:iq:register</value></field><field type="text-single" label="Username" var="username"><required/><value>小\uD83D\uDCA1</value></field><field type="text-private" label="Password" var="password"><required/><value>wjqzjut885160</value></field><field type="text-single" label="Email (MUST BE VALID!)" var="email"><required/><value>wjqzjut@sina.com</value></field></x></query></iq>, SIZE=814, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=LOCAL, TYPE=set, STABLE_ID=7ac65f20-9a01-4308-beb5-ea31a2ac13db
[2021-12-10 00:04:12:158] [FINEST  ] [jabber:iq:register-proc-0 ] SessionManagerClustered.processPacket(): Ressource connection found: XMPPResourceConnection=[user_jid=null, packets=3, connectioId=c2s@ip-172-31-38-91.us-west-2.compute.internal/172.27.0.2_5222_172.31.10.109_4756, domain=jabber.today, authState=NOT_AUTHORIZED, isAnon=false, isTmp=false, parentSession hash=0, parentSession liveTime=]
[2021-12-10 00:04:12:158] [FINEST  ] [jabber:iq:register-proc-0 ] OnlineUsersCachingStrategy.getNodesForPacketForward(): Packet not suitable for forwarding: from=c2s@ip-172-31-38-91.us-west-2.compute.internal/172.27.0.2_5222_172.31.10.109_4756, to=sess-man@ip-172-31-38-91.us-west-2.compute.internal, serverAuthorisedStanzaFrom=Optional.empty, DATA=<iq type="set" to="jabber.today" xmlns="jabber:client" id="3EEC6D7F-AF00-4F29-8939-F46EF21BD7B2"><query xmlns="jabber:iq:register"><x type="submit" xmlns="jabber:x:data"><title>Account Registration</title><instructions>Please provide the following information to sign up for an account

Please also provide your e-mail address (must be valid!) to which we will send confirmation link.</instructions><field type="hidden" var="FORM_TYPE"><value>jabber:iq:register</value></field><field type="text-single" label="Username" var="username"><required/><value>小\uD83D\uDCA1</value></field><field type="text-private" label="Password" var="password"><required/><value>wjqzjut885160</value></field><field type="text-single" label="Email (MUST BE VALID!)" var="email"><required/><value>wjqzjut@sina.com</value></field></x></query></iq>, SIZE=814, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=LOCAL, TYPE=set, STABLE_ID=7ac65f20-9a01-4308-beb5-ea31a2ac13db
[2021-12-10 00:04:12:158] [FINEST  ] [jabber:iq:register-proc-0 ] DefaultClusteringStrategyAbstract.processPacket(): No cluster nodes found for packet forward: from=c2s@ip-172-31-38-91.us-west-2.compute.internal/172.27.0.2_5222_172.31.10.109_4756, to=sess-man@ip-172-31-38-91.us-west-2.compute.internal, serverAuthorisedStanzaFrom=Optional.empty, DATA=<iq type="set" to="jabber.today" xmlns="jabber:client" id="3EEC6D7F-AF00-4F29-8939-F46EF21BD7B2"><query xmlns="jabber:iq:register"><x type="submit" xmlns="jabber:x:data"><title>Account Registration</title><instructions>Please provide the following information to sign up for an account

Please also provide your e-mail address (must be valid!) to which we will send confirmation link.</instructions><field type="hidden" var="FORM_TYPE"><value>jabber:iq:register</value></field><field type="text-single" label="Username" var="username"><required/><value>小\uD83D\uDCA1</value></field><field type="text-private" label="Password" var="password"><required/><value>wjqzjut885160</value></field><field type="text-single" label="Email (MUST BE VALID!)" var="email"><required/><value>wjqzjut@sina.com</value></field></x></query></iq>, SIZE=814, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=LOCAL, TYPE=set, STABLE_ID=7ac65f20-9a01-4308-beb5-ea31a2ac13db
[2021-12-10 00:04:12:158] [FINEST  ] [jabber:iq:register-proc-0 ] SessionManager.processPacket(): processing packet: from=c2s@ip-172-31-38-91.us-west-2.compute.internal/172.27.0.2_5222_172.31.10.109_4756, to=sess-man@ip-172-31-38-91.us-west-2.compute.internal, serverAuthorisedStanzaFrom=Optional.empty, DATA=<iq type="set" to="jabber.today" xmlns="jabber:client" id="3EEC6D7F-AF00-4F29-8939-F46EF21BD7B2"><query xmlns="jabber:iq:register"><x type="submit" xmlns="jabber:x:data"><title>Account Registration</title><instructions>Please provide the following information to sign up for an account

Please also provide your e-mail address (must be valid!) to which we will send confirmation link.</instructions><field type="hidden" var="FORM_TYPE"><value>jabber:iq:register</value></field><field type="text-single" label="Username" var="username"><required/><value>小\uD83D\uDCA1</value></field><field type="text-private" label="Password" var="password"><required/><value>wjqzjut885160</value></field><field type="text-single" label="Email (MUST BE VALID!)" var="email"><required/><value>wjqzjut@sina.com</value></field></x></query></iq>, SIZE=814, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=NONE, TYPE=set, STABLE_ID=7ac65f20-9a01-4308-beb5-ea31a2ac13db, connection: XMPPResourceConnection=[user_jid=null, packets=3, connectioId=c2s@ip-172-31-38-91.us-west-2.compute.internal/172.27.0.2_5222_172.31.10.109_4756, domain=jabber.today, authState=NOT_AUTHORIZED, isAnon=false, isTmp=false, parentSession hash=0, parentSession liveTime=]
[2021-12-10 00:04:12:158] [FINEST  ] [jabber:iq:register-proc-0 ] StartTLS.preProcess()         : VHost: (Wrapped)Domain: jabber.today, enabled: true, anonym: false, register: true, tls: true, maxusers: 0, s2sSecret: ebaaf43f-e8a9-4b3c-9663-7852859d716c, domainFilter: ALL, saslAllowedMechanisms: [PLAIN], trustedJids: [http@{clusterNode}]; Extensions: [MessageArchiveVHostItemExtension(enabled: true, defaultStore: unset, requiredStore: unset, retentionType: userDefined, saveMuc: Optional[user]), ServerInfoVHostItemExtension(abuse: [], admin: [], feedback: [], sales: [], security: [], support: []), HardenedModeVHostItemExtension(hardened-mode: secure), SeeOtherHostVHostItemExtension(enabled: true), ClientTrustVHostItemExtension(caCertPath: null, certRequired: false), PresenceSubscriptionVHostItemExtension(mode: global), BruteForceLockerVHostExtension(enabled: true,mode: IpJid, lockAfter: 3, disableAfter: 20, period: 60, lockTime: 60)]
[2021-12-10 00:04:12:159] [FINEST  ] [jabber:iq:register-proc-0 ] DomainFilter.preProcess()     : Processing: from=c2s@ip-172-31-38-91.us-west-2.compute.internal/172.27.0.2_5222_172.31.10.109_4756, to=sess-man@ip-172-31-38-91.us-west-2.compute.internal, serverAuthorisedStanzaFrom=Optional.empty, DATA=<iq type="set" to="jabber.today" xmlns="jabber:client" id="3EEC6D7F-AF00-4F29-8939-F46EF21BD7B2"><query xmlns="jabber:iq:register"><x type="submit" xmlns="jabber:x:data"><title>Account Registration</title><instructions>Please provide the following information to sign up for an account

Please also provide your e-mail address (must be valid!) to which we will send confirmation link.</instructions><field type="hidden" var="FORM_TYPE"><value>jabber:iq:register</value></field><field type="text-single" label="Username" var="username"><required/><value>小\uD83D\uDCA1</value></field><field type="text-private" label="Password" var="password"><required/><value>wjqzjut885160</value></field><field type="text-single" label="Email (MUST BE VALID!)" var="email"><required/><value>wjqzjut@sina.com</value></field></x></query></iq>, SIZE=814, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=LOCAL, TYPE=set, STABLE_ID=7ac65f20-9a01-4308-beb5-ea31a2ac13db
[2021-12-10 00:04:12:159] [FINEST  ] [jabber:iq:register-proc-0 ] DomainFilter.getDomains()     : Domains read from user session: null for VHost: jabber.today
[2021-12-10 00:04:12:159] [FINEST  ] [jabber:iq:register-proc-0 ] SessionManager.walk()         : XMPPProcessorIfc: JabberIqRegister (jabber:iq:register)Request: from=c2s@ip-172-31-38-91.us-west-2.compute.internal/172.27.0.2_5222_172.31.10.109_4756, to=sess-man@ip-172-31-38-91.us-west-2.compute.internal, serverAuthorisedStanzaFrom=Optional.empty, DATA=<iq type="set" to="jabber.today" xmlns="jabber:client" id="3EEC6D7F-AF00-4F29-8939-F46EF21BD7B2"><query xmlns="jabber:iq:register"><x type="submit" xmlns="jabber:x:data"><title>Account Registration</title><instructions>Please provide the following information to sign up for an account

Please also provide your e-mail address (must be valid!) to which we will send confirmation link.</instructions><field type="hidden" var="FORM_TYPE"><value>jabber:iq:register</value></field><field type="text-single" label="Username" var="username"><required/><value>小\uD83D\uDCA1</value></field><field type="text-private" label="Password" var="password"><required/><value>wjqzjut885160</value></field><field type="text-single" label="Email (MUST BE VALID!)" var="email"><required/><value>wjqzjut@sina.com</value></field></x></query></iq>, SIZE=814, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=LOCAL, TYPE=set, STABLE_ID=7ac65f20-9a01-4308-beb5-ea31a2ac13db, conn: XMPPResourceConnection=[user_jid=null, packets=3, connectioId=c2s@ip-172-31-38-91.us-west-2.compute.internal/172.27.0.2_5222_172.31.10.109_4756, domain=jabber.today, authState=NOT_AUTHORIZED, isAnon=false, isTmp=false, parentSession hash=0, parentSession liveTime=]
[2021-12-10 00:04:12:159] [FINEST  ] [jabber:iq:register-proc-0 ] DomainFilter.filter()         : Filtering (packet): from=c2s@ip-172-31-38-91.us-west-2.compute.internal/172.27.0.2_5222_172.31.10.109_4756, to=sess-man@ip-172-31-38-91.us-west-2.compute.internal, serverAuthorisedStanzaFrom=Optional.empty, DATA=<iq type="set" to="jabber.today" xmlns="jabber:client" id="3EEC6D7F-AF00-4F29-8939-F46EF21BD7B2"><query xmlns="jabber:iq:register"><x type="submit" xmlns="jabber:x:data"><title>Account Registration</title><instructions>Please provide the following information to sign up for an account

Please also provide your e-mail address (must be valid!) to which we will send confirmation link.</instructions><field type="hidden" var="FORM_TYPE"><value>jabber:iq:register</value></field><field type="text-single" label="Username" var="username"><required/><value>小\uD83D\uDCA1</value></field><field type="text-private" label="Password" var="password"><required/><value>wjqzjut885160</value></field><field type="text-single" label="Email (MUST BE VALID!)" var="email"><required/><value>wjqzjut@sina.com</value></field></x></query></iq>, SIZE=814, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=LOCAL, TYPE=set, STABLE_ID=7ac65f20-9a01-4308-beb5-ea31a2ac13db
[2021-12-10 00:04:12:159] [FINEST  ] [jabber:iq:register-proc-0 ] JabberIqRegister.process()    : Processing packet: from=c2s@ip-172-31-38-91.us-west-2.compute.internal/172.27.0.2_5222_172.31.10.109_4756, to=sess-man@ip-172-31-38-91.us-west-2.compute.internal, serverAuthorisedStanzaFrom=Optional.empty, DATA=<iq type="set" to="jabber.today" xmlns="jabber:client" id="3EEC6D7F-AF00-4F29-8939-F46EF21BD7B2"><query xmlns="jabber:iq:register"><x type="submit" xmlns="jabber:x:data"><title>Account Registration</title><instructions>Please provide the following information to sign up for an account

Please also provide your e-mail address (must be valid!) to which we will send confirmation link.</instructions><field type="hidden" var="FORM_TYPE"><value>jabber:iq:register</value></field><field type="text-single" label="Username" var="username"><required/><value>小\uD83D\uDCA1</value></field><field type="text-private" label="Password" var="password"><required/><value>wjqzjut885160</value></field><field type="text-single" label="Email (MUST BE VALID!)" var="email"><required/><value>wjqzjut@sina.com</value></field></x></query></iq>, SIZE=814, XMLNS=jabber:client, PRIORITY=NORMAL, PERMISSION=LOCAL, TYPE=set, STABLE_ID=7ac65f20-9a01-4308-beb5-ea31a2ac13db
[2021-12-10 00:04:12:159] [FINEST  ] [jabber:iq:register-proc-0 ] SessionManager.processPacket(): Packet processed by: [jabber:iq:register]
[2021-12-10 00:04:12:168] [WARNING ] [jabber:iq:register-proc-0 ] JabberIqRegister.process()    : Database problem: tigase.db.TigaseDBException: Problem accessing repository for user: 小\uD83D\uDCA1@jabber.today

wojciech.kapcia@tigase.net commented 2 years ago

localpart: 小??

stacktrace:

tigase.db.TigaseDBException: Problem accessing repository for user: 小??@atlantiscity
	at tigase.db.jdbc.TigaseCustomAuth.addUser(TigaseCustomAuth.java:312)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at tigase.stats.StatisticsInvocationHandler.invoke(StatisticsInvocationHandler.java:75)
	at jdk.proxy2/jdk.proxy2.$Proxy36.addUser(Unknown Source)
	at tigase.db.AuthRepositoryMDImpl.addUser(AuthRepositoryMDImpl.java:54)
	at tigase.xmpp.impl.JabberIqRegister.createAccount(JabberIqRegister.java:443)
	at tigase.xmpp.impl.JabberIqRegister.doRegisterNewAccount(JabberIqRegister.java:643)
	at tigase.xmpp.impl.JabberIqRegister.process(JabberIqRegister.java:330)
	at tigase.server.xmppsession.SessionManager$ProcessorWorkerThread.process(SessionManager.java:2685)
	at tigase.util.processing.WorkerThread.run(WorkerThread.java:67)
Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x80@a...' for column '_user_id' at row 1
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at tigase.db.jdbc.PreparedStatementInvocationHandler.invoke(PreparedStatementInvocationHandler.java:38)
	at jdk.proxy2/jdk.proxy2.$Proxy35.execute(Unknown Source)
	at tigase.db.jdbc.TigaseCustomAuth.addUser(TigaseCustomAuth.java:291)
	... 12 more

wojciech.kapcia@tigase.net commented 2 years ago

The issue only affects MySQL (ancient issue with not handling emoji while using utf8 and requirement to use utf8mb4) and works fine with other database.

Do we want to support emojis in JIDs? In theory they should be legal (and they work just fine with other databases) but if we do we should do it across all components, thus would be better to slate it for 9.0

wojciech.kapcia@tigase.net batch edited 4 months ago

Name	Previous Value	Current Value
Iterations	empty	tigase-server-9.0.0

Type	Bug
Priority	Normal
Assignee	wojciech.kapcia@tigase.net
Version	tigase-server-9.0.0
Spent time	1h 45m

Iterations

tigase-server-9.0.0 Open

Issue Votes (0)

Watchers (2)

Reference

tigase/_server/server-core#1304