From Dan Leavitt, 4 Years ago, written in Plain Text.
- view diff
Embed
  1. 2016-12-22 17:58:18.035719 [ERR] switch_odbc.c:522 ERR: [CREATE TABLE channels (
  2.    uuid  VARCHAR(256),
  3.    direction  VARCHAR(32),
  4.    created  VARCHAR(128),
  5.    created_epoch  INTEGER,
  6.    name  VARCHAR(1024),
  7.    state  VARCHAR(64),
  8.    cid_name  VARCHAR(1024),
  9.    cid_num  VARCHAR(256),
  10.    ip_addr  VARCHAR(256),
  11.    dest  VARCHAR(1024),
  12.    application  VARCHAR(128),
  13.    application_data  VARCHAR(4096),
  14.    dialplan VARCHAR(128),
  15.    context VARCHAR(128),
  16.    read_codec  VARCHAR(128),
  17.    read_rate  VARCHAR(32),
  18.    read_bit_rate  VARCHAR(32),
  19.    write_codec  VARCHAR(128),
  20.    write_rate  VARCHAR(32),
  21.    write_bit_rate  VARCHAR(32),
  22.    secure VARCHAR(64),
  23.    hostname VARCHAR(256),
  24.    presence_id VARCHAR(4096),
  25.    presence_data VARCHAR(4096),
  26.    accountcode VARCHAR(256),
  27.    callstate  VARCHAR(64),
  28.    callee_name  VARCHAR(1024),
  29.    callee_num  VARCHAR(256),
  30.    callee_direction  VARCHAR(5),
  31.    call_uuid  VARCHAR(256),
  32.    sent_callee_name  VARCHAR(1024),
  33.    sent_callee_num  VARCHAR(256),
  34.    initial_cid_name  VARCHAR(1024),
  35.    initial_cid_num  VARCHAR(256),
  36.    initial_ip_addr  VARCHAR(256),
  37.    initial_dest  VARCHAR(1024),
  38.    initial_dialplan  VARCHAR(128),
  39.    initial_context  VARCHAR(128)
  40. );
  41. ]
  42. [STATE: HY000 CODE 1118 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.7.17-log]Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual.                                          You have to change some columns to TEXT or BLOBs
  43. ]
  44. 2016-12-22 17:58:18.036017 [ERR] switch_odbc.c:522 ERR: [select * from basic_calls where sent_callee_name='']
  45. [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.7.17-log]Table 'freeswitch.basic_calls' doesn't exist
  46. ]
  47. 2016-12-22 17:58:18.036151 [ERR] switch_odbc.c:522 ERR: [DROP VIEW basic_calls]
  48. [STATE: 42S02 CODE 1051 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.7.17-log]Unknown table 'freeswitch.basic_calls'
  49. ]
  50. 2016-12-22 17:58:18.036393 [ERR] switch_odbc.c:522 ERR: [create view basic_calls as select a.uuid as uuid,a.direction as direction,a.created as created,a.created_epoch as created_epoch,a.name as name,a.state as state,a.cid_name as                                          cid_name,a.cid_num as cid_num,a.ip_addr as ip_addr,a.dest as dest,a.presence_id as presence_id,a.presence_data as presence_data,a.accountcode as accountcode,a.callstate as callstate,a.callee_name as callee_name,a.callee_num as ca                                         llee_num,a.callee_direction as callee_direction,a.call_uuid as call_uuid,a.hostname as hostname,a.sent_callee_name as sent_callee_name,a.sent_callee_num as sent_callee_num,b.uuid as b_uuid,b.direction as b_direction,b.created as b                                         _created,b.created_epoch as b_created_epoch,b.name as b_name,b.state as b_state,b.cid_name as b_cid_name,b.cid_num as b_cid_num,b.ip_addr as b_ip_addr,b.dest as b_dest,b.presence_id as b_presence_id,b.presence_data as b_presence_d                                         ata,b.accountcode as b_accountcode,b.callstate as b_callstate,b.callee_name as b_callee_name,b.callee_num as b_callee_num,b.callee_direction as b_callee_direction,b.sent_callee_name as b_sent_callee_name,b.sent_callee_num as b_sen                                         t_callee_num,c.call_created_epoch as call_created_epoch from channels a left join calls c on a.uuid = c.caller_uuid and a.hostname = c.hostname left join channels b on b.uuid = c.callee_uuid and b.hostname = c.hostname where a.uui                                         d = c.caller_uuid or a.uuid not in (select callee_uuid from calls)]
  51. [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.7.17-log]Table 'freeswitch.channels' doesn't exist
  52. ]
  53. 2016-12-22 17:58:18.036551 [ERR] switch_odbc.c:522 ERR: [select * from detailed_calls where sent_callee_name='']
  54. [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.7.17-log]Table 'freeswitch.detailed_calls' doesn't exist
  55. ]
  56. 2016-12-22 17:58:18.036701 [ERR] switch_odbc.c:522 ERR: [DROP VIEW detailed_calls]
  57. [STATE: 42S02 CODE 1051 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.7.17-log]Unknown table 'freeswitch.detailed_calls'
  58. ]
  59. 2016-12-22 17:58:18.036958 [ERR] switch_odbc.c:522 ERR: [create view detailed_calls as select a.uuid as uuid,a.direction as direction,a.created as created,a.created_epoch as created_epoch,a.name as name,a.state as state,a.cid_name                                          as cid_name,a.cid_num as cid_num,a.ip_addr as ip_addr,a.dest as dest,a.application as application,a.application_data as application_data,a.dialplan as dialplan,a.context as context,a.read_codec as read_codec,a.read_rate as read_r                                         ate,a.read_bit_rate as read_bit_rate,a.write_codec as write_codec,a.write_rate as write_rate,a.write_bit_rate as write_bit_rate,a.secure as secure,a.hostname as hostname,a.presence_id as presence_id,a.presence_data as presence_dat                                         a,a.accountcode as accountcode,a.callstate as callstate,a.callee_name as callee_name,a.callee_num as callee_num,a.callee_direction as callee_direction,a.call_uuid as call_uuid,a.sent_callee_name as sent_callee_name,a.sent_callee_n                                         um as sent_callee_num,b.uuid as b_uuid,b.direction as b_direction,b.created as b_created,b.created_epoch as b_created_epoch,b.name as b_name,b.state as b_state,b.cid_name as b_cid_name,b.cid_num as b_cid_num,b.ip_addr as b_ip_addr                                         ,b.dest as b_dest,b.application as b_application,b.application_data as b_application_data,b.dialplan as b_dialplan,b.context as b_context,b.read_codec as b_read_codec,b.read_rate as b_read_rate,b.read_bit_rate as b_read_bit_rate,b                                         .write_codec as b_write_codec,b.write_rate as b_write_rate,b.write_bit_rate as b_write_bit_rate,b.secure as b_secure,b.hostname as b_hostname,b.presence_id as b_presence_id,b.presence_data as b_presence_data,b.accountcode as b_acc                                         ountcode,b.callstate as b_callstate,b.callee_name as b_callee_name,b.callee_num as b_callee_num,b.callee_direction as b_callee_direction,b.call_uuid as b_call_uuid,b.sent_callee_name as b_sent_callee_name,b.sent_callee_num as b_se                                         nt_callee_num,c.call_created_epoch as call_created_epoch from channels a left join calls c on a.uuid = c.caller_uuid and a.hostname = c.hostname left join channels b on b.uuid = c.callee_uuid and b.hostname = c.hostname where a.uu                                         id = c.caller_uuid or a.uuid not in (select callee_uuid from calls)]
  60. [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.7.17-log]Table 'freeswitch.channels' doesn't exist
  61. ]
  62. 2016-12-22 17:58:18.037524 [ERR] switch_odbc.c:522 ERR: [delete from channels where hostname='']
  63. [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.7.17-log]Table 'freeswitch.channels' doesn't exist
  64. ]
  65. 2016-12-22 17:58:18.037541 [ERR] switch_core_sqldb.c:587 ODBC SQL ERR [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.7.17-log]Table 'freeswitch.channels' doesn't exist
  66. ]
  67. delete from channels where hostname=''
  68. 2016-12-22 17:58:18.037547 [ERR] switch_core_sqldb.c:3540 Database Error [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.7.17-log]Table 'freeswitch.channels' doesn't exist
  69. ]
  70. 2016-12-22 17:58:18.037557 [INFO] switch_core_sqldb.c:3396 Opening DB
  71. 2016-12-22 17:58:18.037687 [ERR] switch_odbc.c:522 ERR: [delete from channels where hostname='fs.nuari.net']
  72. [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.7.17-log]Table 'freeswitch.channels' doesn't exist
  73. ]
  74. 2016-12-22 17:58:18.037702 [ERR] switch_core_sqldb.c:587 ODBC SQL ERR [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.7.17-log]Table 'freeswitch.channels' doesn't exist
  75. ]
  76. delete from channels where hostname='fs.nuari.net'
  77. 2016-12-22 17:58:18.039390 [ERR] switch_odbc.c:522 ERR: [select call_uuid, read_bit_rate, sent_callee_name, initial_cid_name, initial_cid_num, initial_ip_addr, initial_dest, initial_dialplan, initial_context, accountcode from chan                                         nels]
  78. [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.7.17-log]Table 'freeswitch.channels' doesn't exist
  79. ]
  80. 2016-12-22 17:58:18.039537 [ERR] switch_odbc.c:522 ERR: [DROP TABLE channels]
  81. [STATE: 42S02 CODE 1051 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.7.17-log]Unknown table 'freeswitch.channels'
  82. ]
  83. 2016-12-22 17:58:18.039744 [ERR] switch_odbc.c:522 ERR: [CREATE TABLE channels (
  84.    uuid  VARCHAR(256),
  85.    direction  VARCHAR(32),
  86.    created  VARCHAR(128),
  87.    created_epoch  INTEGER,
  88.    name  VARCHAR(1024),
  89.    state  VARCHAR(64),
  90.    cid_name  VARCHAR(1024),
  91.    cid_num  VARCHAR(256),
  92.    ip_addr  VARCHAR(256),
  93.    dest  VARCHAR(1024),
  94.    application  VARCHAR(128),
  95.    application_data  VARCHAR(4096),
  96.    dialplan VARCHAR(128),
  97.    context VARCHAR(128),
  98.    read_codec  VARCHAR(128),
  99.    read_rate  VARCHAR(32),
  100.    read_bit_rate  VARCHAR(32),
  101.    write_codec  VARCHAR(128),
  102.    write_rate  VARCHAR(32),
  103.    write_bit_rate  VARCHAR(32),
  104.    secure VARCHAR(64),
  105.    hostname VARCHAR(256),
  106.    presence_id VARCHAR(4096),
  107.    presence_data VARCHAR(4096),
  108.    accountcode VARCHAR(256),
  109.    callstate  VARCHAR(64),
  110.    callee_name  VARCHAR(1024),
  111.    callee_num  VARCHAR(256),
  112.    callee_direction  VARCHAR(5),
  113.    call_uuid  VARCHAR(256),
  114.    sent_callee_name  VARCHAR(1024),
  115.    sent_callee_num  VARCHAR(256),
  116.    initial_cid_name  VARCHAR(1024),
  117.    initial_cid_num  VARCHAR(256),
  118.    initial_ip_addr  VARCHAR(256),
  119.    initial_dest  VARCHAR(1024),
  120.    initial_dialplan  VARCHAR(128),
  121.    initial_context  VARCHAR(128)
  122. );
  123. ]
  124. [STATE: HY000 CODE 1118 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.7.17-log]Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual.                                          You have to change some columns to TEXT or BLOBs
  125.