View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0008068VALENTINA SERVERKeyValuepublic2017-09-14 07:502017-09-18 09:40
ReporterRuslan ZasukhinAssigned ToIvan Smahin 
PrioritynormalSeverityblockReproducibilityhave not tried
Status resolvedResolutionfixed 
PlatformALLOSALLOS VersionALL
Product Version7.4.x 
Target Version7.4.xFixed in Version 
Summary0008068: Cannot create KeyValue when vdb is under VSERVER.
DescriptionI can create it in local db, but not in remote.

May be bug in vclient? But Sergey you should check first.

Vserver gets SQL command, and ... see log below ..
Steps To ReproduceThu Sep 14 2017 10:35:30.665507 (TID 123145443033088): (UID 25) I_SqlDatabase 'vdb_bench' SqlSelect 'SHOW STATUS OF DATABASE'.
Thu Sep 14 2017 10:35:30.665920 (TID 123145443033088): (UID 25) Takes: '0' msec. Selected: '28' records.
Thu Sep 14 2017 10:35:30.666457 (TID 123145443569664): (UID 25) I_SqlDatabase ' ' SqlQueryEx '-- CREATE KEYVALUE "kvBenchResults" ----------------------------
CREATE KEYVALUE "kvBenchResults";
-- -------------------------------------------------------------
' .
Thu Sep 14 2017 10:35:30.669207 (TID 123145443569664): (UID 25) ERROR 0x69506: KeyValue "kvBenchResults" is not unique.
Thu Sep 14 2017 10:35:30.669695 (TID 123145445179392): (UID 25) I_SqlDatabase 'vdb_bench' SqlSelect 'SHOW STATUS OF DATABASE'.
Thu Sep 14 2017 10:35:30.669957 (TID 123145445179392): (UID 25) Takes: '0' msec. Selected: '28' records.
Thu Sep 14 2017 10:35:30.670377 (TID 123145443033088): (UID 25) Ping OK.
Thu Sep 14 2017 10:35:30.670410 (TID 123145443033088): (UID 25) Database: vdb_bench; User: sa: OK
Thu Sep 14 2017 10:35:30.670591 (TID 123145443569664): (UID 25) Ping OK.
Thu Sep 14 2017 10:35:30.670625 (TID 123145443569664): (UID 25) Database: vdb_bench; User: sa: OK
Thu Sep 14 2017 10:35:30.670826 (TID 123145445179392): (UID 25) I_SqlDatabase ' ' SqlQueryEx 'SELECT * FROM ( SHOW KEYVALUES ) WHERE fld_type NOT IN ( 'kKeyValueForTable', 'kKeyValueForLink' )' .
Thu Sep 14 2017 10:35:30.671734 (TID 123145445179392): (UID 25) Takes: '0' msec. Selected: '1' records.
Thu Sep 14 2017 10:35:30.672349 (TID 123145443033088): (UID 25) I_Database 'vdb_bench' get_KeyValue.
 10:35:30.672387 (TID 123145443033088): (UID 25) KeyValue 'kvBenchResults' remoteID -824581280 registered.
Thu Sep 14 2017 10:35:30.672539 (TID 123145443569664): (UID 25) Ping OK.
Thu Sep 14 2017 10:35:30.672560 (TID 123145443569664): (UID 25) Database: vdb_bench; User: sa: OK
Thu Sep 14 2017 10:35:30.672667 (TID 123145445179392): (UID 25) I_SqlDatabase ' ' SqlQueryEx 'SELECT * FROM ( SELECT * FROM ( SHOW KEYVALUES ) WHERE fld_type NOT IN ( 'kKeyValueForTable', 'kKeyValueForLink' ) ) _vs WHERE "fld_name" = 'kvBenchResults'' .
Thu Sep 14 2017 10:35:30.673813 (TID 123145445179392): (UID 25) Takes: '1' msec. Selected: '1' records.
Thu Sep 14 2017 10:35:30.674203 (TID 123145443033088): (UID 25) Ping OK.
Thu Sep 14 2017 10:35:30.674224 (TID 123145443033088): (UID 25) Database: vdb_bench; User: sa: OK
Thu Sep 14 2017 10:35:30.674378 (TID 123145443569664): (UID 25) Ping OK.
Thu Sep 14 2017 10:35:30.674404 (TID 123145443569664): (UID 25) Database: vdb_bench; User: sa: OK
Thu Sep 14 2017 10:35:30.674520 (TID 123145445179392): (UID 25) I_SqlDatabase ' ' SqlQueryEx 'SHOW PROPERTIES OF DATABASE' .
Thu Sep 14 2017 10:35:30.675252 (TID 123145445179392): (UID 25) Takes: '0' msec. Selected: '50' records.
TagsNo tags attached.

Activities

Ruslan Zasukhin

Ruslan Zasukhin

2017-09-14 07:52

administrator   ~0009894

Thread 18 Crashed:
0 libvserver_fat_release_x64.dylib 0x00000001027a0c66 fbl::VSRV_Gen_Storage::I_Storage_get_Size_void_handler(fbl::I_PacketRcv&, fbl::I_PacketSnd&) + 134
1 libvserver_fat_release_x64.dylib 0x00000001027a0448 fbl::VSRV_Gen_Storage::handle_command(fbl::I_PacketRcv&, fbl::I_PacketSnd&) + 312
2 libvserver_fat_release_x64.dylib 0x0000000102878e19 VSRV_KeyValue::handle_command(fbl::I_PacketRcv&, fbl::I_PacketSnd&) + 51
3 libvserver_fat_release_x64.dylib 0x00000001027c6851 VSRV_Client_Handler::handle_input(int) + 661
4 libvserver_fat_release_x64.dylib 0x000000010289b1c7 ACE_TP_Reactor::dispatch_socket_event(ACE_EH_Dispatch_Info&) + 69
5 libvserver_fat_release_x64.dylib 0x000000010289adda ACE_TP_Reactor::handle_socket_events(int&, ACE_TP_Token_Guard&) + 170
6 libvserver_fat_release_x64.dylib 0x000000010289a908 ACE_TP_Reactor::dispatch_i(ACE_Time_Value*, ACE_TP_Token_Guard&) + 102
7 libvserver_fat_release_x64.dylib 0x000000010289a83e ACE_TP_Reactor::handle_events(ACE_Time_Value*) + 110
8 libvserver_fat_release_x64.dylib 0x000000010288a77a ACE_Reactor::run_reactor_event_loop(int (*)(ACE_Reactor*)) + 46
9 libvserver_fat_release_x64.dylib 0x00000001027b244d V_Thread_Pool::svc() + 99
10 libvserver_fat_release_x64.dylib 0x0000000102899960 ACE_Task_Base::svc_run(void*) + 56
11 libvserver_fat_release_x64.dylib 0x00000001028893e3 ACE_Thread_Adapter::invoke() + 105
12 libsystem_pthread.dylib 0x00007fff92b4293b _pthread_body + 180
13 libsystem_pthread.dylib 0x00007fff92b42887 _pthread_start + 286
14 libsystem_pthread.dylib 0x00007fff92b4208d thread_start + 13

Issue History

Date Modified Username Field Change
2017-09-14 07:50 Ruslan Zasukhin New Issue
2017-09-14 07:50 Ruslan Zasukhin Status new => assigned
2017-09-14 07:50 Ruslan Zasukhin Assigned To => Sergey Pashkov
2017-09-14 07:52 Ruslan Zasukhin Note Added: 0009894
2017-09-14 07:52 Ruslan Zasukhin Assigned To Sergey Pashkov => Ivan Smahin
2017-09-14 07:53 Ruslan Zasukhin Project VALENTINA STUDIO => VALENTINA SERVER
2017-09-14 12:53 Ivan Smahin Status assigned => resolved
2017-09-14 12:53 Ivan Smahin Resolution open => fixed