Projects tigase _server server-core Issues #283
Derby schema issues with large number of VHosts (#283)
Closed
wojciech.kapcia@tigase.net opened 1 decade ago

Derby schema uses limited column type for storing key value in tig_pairs table which fails for large number of VHosts

wojciech.kapcia@tigase.net commented 1 decade ago

Derby has limitation for VARCHAR ( "maximum length of 32,700 characters" ) and with recent additions of VHostItem elements the limit was hit with about 100 VHosts. I've switched to CLOB for pval column which resolves the issue ( "A CLOB (character large object) value can be up to 2,147,483,647 characters long." )

issue 1 of 1
Type
Bug
Priority
Normal
Assignee
RedmineID
1717
Version
tigase-server-5.2.1
Spent time
27h
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/server-core#283
Please wait...
Page is in error, reload to recover